Customer Contact with REST failing in LIVE

Epicor ERP 10
1

I’m trying to make a REST call to https://xxxxxx/E10Live/api/v1/Erp.BO.CustCntSvc/CustCnts
to update a contact. The rest call works in our testing environment no problem. But when I call it against the LIVE database it fails. Looking at the event log on the Epicor server we get this:

System.Data.Entity.Core.UpdateException: An error occurred while updating the entries. See the inner exception for details. —> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint ‘PK_CustCnAttr’. Cannot insert duplicate key in object ‘Erp.CustCnAttr’. The duplicate key value is (SD, 1817, , 2, ).
The statement has been terminated.

Why is the BO trying to create another record in CustCnAttr instead of updating? This is weird because the same exact payload is working against the other slot with the same exact data! What is different about this table in live?

2

What does the client code look like? I really doubt it’s a BO/sql table issue

3

For simplicity (and proof of error) I’m using POSTMAN to do the requests.

Working:

image
image923×760 56 KB

Not working:

image
image923×828 50.5 KB

server error on the fail:

image
image1428×447 51.8 KB

4

I’m trying to use PATCH now. How do you specific a blank string? The Customer Contact in the database has a blank ship to num. Meaning the contact lives at customer head.
Is forcing the ShipToNum an oversight by the BO that’s doing the REST?

image
image1392×692 43.4 KB

I tried putting nothing there, null, a space, 0, empty quotes, nothing worked. Is there a way to say this contact lives at the customer head level in the PATCH?

5

Did you find a solution to this problem?