web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Exception while trying...

Finance | Project Operations, Human Resources, ...

Suggested Answer

Exception while trying to update customer info via econnect

(0) Share

Report

Report

Posted on by sprasana

44

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:

Microsoft Dynamics GP

I have the same question (1)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

David Musgrave MVP ... 14,151 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

exec smBindTableDefaults 0

Regards

David

Was this reply helpful? Yes No
Suggested answer

KC-07051756-0 2 on at

Like (0)

Report
Copy link

Link copied!

I know this is a bit of an old post (not old in GP terms though). I had this error as well when I tried to use eConnect to insert our customers. The upgrade to GP 18.x changes the schema of RM00101.Caller_ID_String to being not null. The trigger that is firing [cnpCreate_Collection_Management_Note] is not part of the upgrade if I understand correctly. It is part of a 3rd party collections module. Anyways, it attempts to pass nulls in, instead of providing defaults. That is why you are seeing this error. You need to get an update to your collections module or add this snip to your trigger sproc: Right after the BEGIN:

/* --- Global Fix for eConnect/Trigger NULL errors --- */
SET @CallerID = ISNULL(@CallerID, '')
SET @AssignedTo = ISNULL(@AssignedTo, '')
SET @ActionPromised = ISNULL(@ActionPromised, '')
SET @ContactPerson = ISNULL(@ContactPerson, '')
SET @UserID = ISNULL(@UserID, 'sa') -- Defaulting to 'sa' if no user is passed
/* --------------------------------------------------- */

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Giorgio Bonacorsi 692

#2

André Arnaud de Cal... 532 Super User 2026 Season 1

#3

CP04-islander 478

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans