Error: Data could not be saved. Cannot insert the value NULL into column 'NUMEMPLOYEES', table 'XXXXX.dbo.ORGANIZATIONDATA'; column does not allow nulls. UPDATE fails.

When attempting to merge two organisation records the following error occurs.

Error:

Data could not be saved. 

Cannot insert the value NULL into column 'NUMEMPLOYEES', table 'XXXX.dbo.ORGANIZATIONDATA'; column does not allow nulls. UPDATE fails.


Both organisations have zero employees on their records.

Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

Environment

 2.9.1001 patch 131
 2.91.1535, patch 111 ; 2.9.1001.141 ; 3.0.516 ; 2.93.2034, patch 79

Was this article helpful?