SAP Knowledge Base Article - Preview

2633915 - Msg 547 reported when reconciling tables with constraints - SRS Data Assurance

Symptom

Running this Data Assurance command results in Msg 547:

create compareset EXT_COMPONENT
set desc="Sample on comparison on the dbo.EXT_COMPONENT table"
with source conn_UAT_7_UTIL dbo EXT_COMPONENT s2
target conn_UAT_EXT_7_UTIL dbo EXT_COMPONENT t2
map all
go

Msg 547, Level 16, State 1:

Server 'UAT_EXT_7', Line 2:

Dependent foreign key constraint violation in a referential integrity constraint. dbname =  'UTIL', table name = 'dbo.EXT_COMPONENT', constraint name = 'EXTFK_COMP_ID'.

Command has been aborted.


Read more...

Environment

SAP Replication Server (SRS)

Product

SAP Replication Server 15.7 ; SAP Replication Server 16.0

Keywords

COMPARISON, MAX_CONCURRENT_COMPARISONS , KBA , 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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.