Exception while trying to update customer info via econnect

(0) Share

Report

Posted on by sprasana

We started getting below exception while trying to update customer info via econnect.

Cannot insert the value NULL into column ‘Caller_ID_String’, table ‘ZTEST.dbo.CN00100’; column does not allow nulls. INSERT fails. The statement has been terminated.

econnect endpoint: /eConnect/RMCustomerMasterType.

We recently updated GP service package and after that i started throwing exception and was working fine before. When econnect writes into CN00100? We are using GP version 18.5

Categories:

Development / Customization / SDK

All responses (1)

Answers (0)

Suggested answer

David Musgrave MVP ... 13,831 Moderator on at

Like (0)

Report

RE: Exception while trying to update customer info via econnect

Try running the Bind Defaults code so that unspecified columns have a default non-NULL value.

exec smBindTableDefaults 0

Regards

David