Hello,
could you please let me know how to update the records (assigned Primary Key) at DB table from SAP PI
Scenario: JDBC Sender to JDBC receiver
Mapping:
sender Message Type: field1, field2, field3, field4
receiver Message Type: field1<primaryKey>, field2, field3, field4
Action: tried with UPDATE and UPDATE_INSERT
Business Logic: in DB1 we have 100 records and same records are inserted to DB2.
on next day out of 100 records, 5 records are updated in DB1. So same 5 records i need to send again to DB2.
Issue: the update query from sender channel will get the updated 5 records from DB1 and try to insert at DB2, it is failing with PK issue (java.sql.SQLException: ORA-00001: unique constraint (DATA.TABLE1_PK) violated)
Best Regards,SARAN