The system is configured using HVAR and a warm standby replication. The table that is failing has a "self referencing foreign key" is failing with the following error:
Msg 546, Level 16, State 1:
Server 'MYSERVER', Line 3:
Foreign key constraint violation occurred, dbname = 'dbname', table name = 'mytable', constraint name = 'fky_parent_mytable_id'.
Command has been aborted.
(0 rows affected)
Other than, skipping the transaction which causes the data to be out-of-sync, how is this resolved?
SAP Adaptive Server Enterprise 15.7 ESD#2 and above
SAP Replication Server all versions
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-REP , Sybase Replication Server (standalone) , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.