SQL errors

lfj0503

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

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