How can we help you today? How can we help you today?

SQL errors

The following error message was returned from the SQL Server:

[547] The DELETE statement conflicted with the REFERENCE constraint "TARPAUSCHALE_TARZTRPH_FOREIGN1". The conflict occurred in database "PARK_DB_BRUUNS", table "dbo.TARPAUSCHALE".

The following SQL command caused the error:

DECLARE @pv binary(16)

I get this error when I run the synchronization, but the synchronization has been running in monts witout problems, and then suntenly this error occours.

Can you help me ?

Lars Frost
It-mannager
lfj0503
0

Comments

1 comment

Sort by
  • Michelle T
    Try switching on the option 'Ignore Foreign Keys and Check Constraints' - that ought to get you past the immediate problem. It sounds like you have added or enabled a foreign key, or added data to a table in the target which was previously always empty (and hence would never have triggered this problem before).
    Michelle T
    0

Add comment

Please sign in to leave a comment.