Skip to Content

Trigger in HANA on a replicated table

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Feb 19, 2016 at 05:01 AM

    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

    Add comment
    10|10000 characters needed characters exceeded