Replication issue in HANA

[former_member200537]

Hi ,

We are using SLT technology (SLT configured in separate system) for repliciating tables from ecc to HANA.   schema in SLT system is showing in red status with error messages in trigger tab "Trigger is missing in Source System although it is internally set as activated" but when i looked in source system we found triggers for those tables.

Also when we are trying to replicate new tables in HANA studio few tables are going into schedule  or error status and in schema thest tables are showing in yellow status with "Table was not yet processed; trigger should be created during first processing" in schema under trigger tab and also we can't find triggers for these tables in source system.

we already applied oss note 1663138 and 1645517. we are on HANA SP4 and DMIS SP5.

[Former Member]

Hi Uday,

You could use transaction iuuc_sync_mon in your SLT system to check a few things:

a. Application logs to see if it gives you anymore info on why the trigger creation failed

b. You could use the same transaction to delete and recreate the triggers for a specific table (Do this only if it isnt a production environment). If that recreates the trigger successfully, then you can restart the replication within the HANA studio.

Thanks,

Anooj

[former_member200537]

Hi Anooj,

There are no error logs in iuuc_sync_mon t.code, moreover when i try to delete triggers i got meassage table (tried with one table) triggers are deleted but i still see errror message in schema for that table under trigger tab and also while trying to create/activate trigger getting message "no object to be processed for this selection". I'm just providing table name and mass id number  for deleting trigger.