When setting up a Sage1000 SData integration on a CRM system that's been upgraded from 7.1 to 7.2 the integration that is set up fails.


The integration set up to fails at the schema application phase:
“org.hibernate.exception.ConstraintViolationException: Cannot insert the value NULL into column 'Id_TableId', table 'Sage1000.dbo.SQL_Identity'; column does not allow nulls. INSERT fails”


The problem is with the identity columns in CRM being different in an install upgraded from 7.1 to 7.2 and a fresh 7.2 install.

More information:

If you have an integration on 7.1 prior to upgrading and then upgrade to 7.2 the integration should still work (unless there's a schema change on ERP).