Map Entry No as primary key

ruben007ruben007 Member Posts: 4
edited 2015-02-27 in Dynamics CRM

We're synchronizing data using the connector (version 2013) and de NAV Webservice. We're able to synchronise contact, invoices etc but one table gives us a hard time. The table has "Entry No." as primary Key. The Field "Entry No." is an auto increment field.

When synchronising data, we receive an error:
You cannot change the value of an Auto increment field. Field: Entry No. Table: OFCRM Relation Person Identification fields and values: Entry No.='6911'

We've turned of the auto increment property and we generate a number by c/al code (last entry no + 1).
Unfortunately, when the connector creates a new entry, the connector receives an error:
HTTP/1.1 500 Internal Server Error
Content-Length: 449
Content-Type: text/xml; charset=utf-8
Server: Microsoft-HTTPAPI/2.0
Date: Thu, 26 Feb 2015 13:42:25 GMT

To test the NAV Webservice. We've written a C# .net program. Using the C# .net program, we are able the create and update entries successfully (using the same NAV Webservice!).

Does anyone know how we can resolve this error or how we can find out what causes the “internal server" error?
Sign In or Register to comment.