How to stop properly SLT replication and delete triggers?

[former_member555322]

Hello Gurus,

I have implemented a BW quality project using ODP - SLT Queue for tables replicaction (ECC => SLT => ODP -SLT Queure => BW DSO).

We are trying to find the good procedure to stop SLT replication and remove triggers on ECC tables for manage technical operations (ECC upgrade or tables modification).

I have found the following SAP notes :

1620618 - Delete Trigger
2250802 - Errors occurred during Check for SLT Triggers - SLT trigger errors during upgrade using SUM

If I make a summary :

1. Stop the configuration transfer jobs under LTRC-> Admin tab.
2. Delete manually triggers in ECC with programm IUUC_DELETE_TRIGGERS_REMOTE
3. LTRC-> Processing steps-> Delete Generated Runtime Objects
4. LTRC-> Processing steps-> Delete Load / Replication Objects
5. LTRC-> Processing steps-> Define Load / Replication Object
6. LTRC-> Processing steps-> Generate Runtime Modules
7. Start Configuration.

It looks very complicated to imlplement this solution every time we have a table modification in ECC.

Does it have a simple way to stop replication and remove triggers?

Thanks for help,

Franck

[Andrey_M]

The above described procedure is wrong. Deletion and regeneration of runtime object has nothing with SLT triggers. WIth item 2, of course, you will delete triggers, but in such case all replicated table has no sence anymore. After upgrade you have to start replication of all table from scratch.

Insuch case the easiest way to delete the whole configuration at all.

I recommend you to ask for the help the team and experts in SUM DMO procedure. I head about many succesfully projects in upgrading SLT servers.

[Former Member]

Hello Franck,

as far as I remember, you can make the settings in the SLT cockpit. Changes are made neither in the source, nor in the target system. You can also stop the trigger processing and synchronization in the cockpit.

Find further details about here:

https://blogs.sap.com/2014/05/30/sap-lt-replication-part-1-configuration

Hope this helps.

Best regards

Markus