Hi Experts, Unable to delete schema in SLT Server

[Former Member]

Hi Experts,

     I'm trying to delete schema in SLT Server(T-code:LTR) but system is showing error "Error while deleting Triggers". Please any one tell me th solution.

Thanks,

Vishali Raghava Raju.

[Former Member]

Hi,

Please check if you authorization to delete SLT schema or not.

Follow these steps to delete the complete SLT schema before reconfiguring a new schema in SLT.

1) In SLT: Using SLT configuration dialog - delete the configuration

2.) In HANA Studio: drop SLT schema and user in HANA system

3 a) In HANA Studio:  in case that there is only one source system replicated into HANA - delete whole schema SYS_REPL

3 b) In HANA Studio: in case that there are multiple source systems replicated into HANA - remove related records from every table in schema SYS_REPL

Regards,

Shilpa

[Former Member]

Hi,

If the above steps don't work, you could deleting the DB triggers manually in the transaction IUUC_SYNC_MON (in the SLT system) and subsequently try deleting it from LTR. The application logs in this transactions might also give you some clue as to why the DB trigger deletion is failing. You could check for errors in ST22, SM21 and SM37 transactions.

Thanks,

Anooj