Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 306 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Map Entry No as primary key
ruben007
Member Posts: 4
Hi,
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?
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?
0