SAP Knowledge Base Article - Preview

2688855 - Replication is recieving the message: Msg 546, Level 16, State 1: - SAP ASE / REP

Symptom

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?


Read more...

Environment

  • SAP Adaptive Server Enterprise 15.7 ESD#2 and above
  • SAP Replication Server all versions

Product

SAP Replication Server 16.0 ; SAP Sybase Replication Server 15.7, heterogeneous edition

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-REP , Sybase Replication Server (standalone) , Problem

About this page

This 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.