Trigger in HANA on a replicated table

[Former Member]

Hi all,

I have written a trigger for a replicated table (EKPO) which has been replicated from ECC to HANA. The trigger inserts values to a separate table based on values in EKPO. However the EKPO table's replication is stopped after creation of the trigger with an error being generated and replication starts after the trigger is deleted. I need to trigger a value based on values being updated from ECC for the table EKPO. Any ideas on how I could do this ?

Thanks,

Best Regards,

Nuzhi

[rohit_chowdhury17]

Hello Nuzhi,

Have you checked if

1 . there are any constraints defined on the target table which is resisting the data to be replicated on EKPO and subsequently to the target table .

2.Can you check if the trigger is working if you manually try to insert a record in the table EKPO .

Regards

Rohit