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 Mar 23 14:26:41 UTC 2022

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