July 23, 2011 at 5:34 am
Hi Experts,
We are getting below error in our replication and as a result of this we are moving the affected tables (child tables)out for replication for time being.
There are no primary or candidate keys in the referenced table 'MasterTable' that match the referencing column list in the foreign key 'FK_childtable_mastertable'. (Source: MSSQLServer, Error number: 1776)
The reference column is there in child table.
Please help
TIA
July 23, 2011 at 9:58 am
What schema changes did you recently make?
You are missing some objects.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 23, 2011 at 11:40 am
Development team has done some changes ,not sure about that..
Could you please let me know what changes it can be?
July 23, 2011 at 11:47 am
Rechana Rajan (7/23/2011)
Development team has done some changes ,not sure about that..Could you please let me know what changes it can be?
What changes?
http://technet.microsoft.com/en-us/library/ms151870.aspx
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 24, 2011 at 11:26 am
NOw we are received below error after many foreign key violation.
Error messages:
•The process could not bulk copy into table '"dbo"."Master"'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20037)
Get help: http://help/MSSQL_REPL20037
•Batch send failed
•Violation of PRIMARY KEY constraint 'PK_Master'. Cannot insert duplicate key in object 'dbo.Master'. (Source: MSSQLServer, Error number: 2627)
Get help: http://help/2627
•To obtain an error file with details on the errors encountered when initializing the subscribing table, execute the bcp command that appears below. Consult the BOL for more information on the bcp utility and its supported options. (Source: MSSQLServer, Error number: 20253)
Get help: http://help/20253
•bcp "SUBS_Current"."dbo"."Master" in "f:\monster\Partition\MSSQL.1\MSSQL\repldata\unc\monster$mixed\20110722115276\Master_423#1.bcp" -e "errorfile" -t"<x$3>" -r"<,@g>" -m10000 -SPUBS\PUBLISHER -T -w (Source: MSSQLServer, Error number: 20253)
Get help: http://help/20253
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply