Sage 200 - Error "unexpected exception Contract Failure: A referential integrity exception on update has occured. This method should be overridden by the subclass"

Solution Properties

Solution ID:

200427112436493

Last Modified Date:

Wed Jul 01 11:01:11 UTC 2026

Taxonomy Path:

Case category//How do I...//processing

Author:

[email protected]

Sage 200 - Error "unexpected exception Contract Failure: A referential integrity exception on update has occured. This method should be overridden by the subclass"

Description

Cause

Resolution

Please check for and remove any disconnected logins from Sage 200 in the first instance.

If this has not resolved, then back up the impacted database before running the following SQL script against it.


UPDATE PLSupplierDocument
SET SendToPLSuppContactValueID = NULL
WHERE SendToPLSuppContactValueID NOT IN (SELECT PLSupplierContactValueID FROM PLSupplierContactValue)

Steps to duplicate