October 21, 2019 at 1:32 pm
Hi,
I've setup some publications and subscriptions today and use a backup to start off the process ( init from backup ).
Restored a backup to server
Added in new subscriber using a backup file - it creates the subscription and SQL job etc ok no errors.
But I just get this ( I've setup loads of these!! )
Command attempted:
if @@trancount > 0 rollback tran
(Transaction sequence number: 0x0010FF4B00006B93007B00000000, Command ID: 3)
Error messages:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SOPOrderReturnLine_SOPOrderReturn". The conflict occurred in database "prd-sagedb", table "dbo.SOPOrderReturn", column 'SOPOrderReturnID'. (Source: MSSQLServer, Error number: 547)
Get help: http://help/547
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_SOPOrderReturnLine_SOPOrderReturn". The conflict occurred in database "prd-sagedb", table "dbo.SOPOrderReturn", column 'SOPOrderReturnID'. (Source: MSSQLServer, Error number: 547)
Get help: http://help/547
October 22, 2019 at 2:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
October 28, 2019 at 4:08 pm
This was removed by the editor as SPAM
November 1, 2019 at 3:22 pm
You may need to change the foreign Key Constraint rules.
Check this link out
https://www.c-sharpcorner.com/UploadFile/f0b2ed/solve-error-message-547-level-16-in-sql-server/
November 3, 2019 at 6:36 pm
Please confirm that you have set the foreign key constraints on the Publisher to by 'Not for Replication'
These links provides more info
https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms152529(v=sql.105)?redirectedfrom=MSDN
April 6, 2023 at 6:09 pm
This was removed by the editor as SPAM
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply