Replication Import Processor - Cannot Update Record - Duplicate Key Value Violates Unique Constraint

[Chuck Boecking]

Hi Everyone,

I am testing replication, and I cannot get the target machine to update an existing record. It creates records just fine. When it goes to update, I get a duplicate key value violates unique constraint error. 

I debugged this issue, at it seems that PO.is_new() always return 'true' because the member variable m_createNew is always true even when trying to update an existing record.

The Replication Strategy has one Table line that "merges" a very simple table. All records in the Export Format for this table are active.

Please let me know your thoughts. Thanks!!

Regards,

Chuck Boecking

[Chuck Boecking]

Hi Everyone,

I also ran into an issue where the target server would not delete records that were deleted on the source server.

I fixed both issues (no target update and no target delete) with the attached patch. 

Regards,

Chuck Boecking

erp-academy.chuckboecking.com