Dynamics NAV/CRM connector - Exception thrown on NAV.

katko
Member Posts: 11
The blank CRM/NAV went together per my previous thread.
But now, trying to sync a real database with plenty of data, NAV 2013, with CRM 2013 fails every time. It gets to the point of syncing NAV customer cards to CRM accounts and POOF. It immediately fails.
I set a connector filter to only grab ONE account by name, poof. Exception through.
Now THIS part is interesting: I set a connector filter to grab by name for a constraint that can't exist. ZERO records would be returned by this criterea, so: 1) if it doesn't fail it's likely the records and 2) if it does fail, it's likely the process of authenticating/communicating and not the records themselves. (Likely but still not guranteed.)
Well? With a zero record matching filter, IT STILL THROWS AN EXCEPTION.
There are no other errors. CRM doesn't list any errors. The connector only lists "Exception occurred in Dynamics NAV" and doesn't log anything to a file, even with tracing set to full.
But now, trying to sync a real database with plenty of data, NAV 2013, with CRM 2013 fails every time. It gets to the point of syncing NAV customer cards to CRM accounts and POOF. It immediately fails.
I set a connector filter to only grab ONE account by name, poof. Exception through.
Now THIS part is interesting: I set a connector filter to grab by name for a constraint that can't exist. ZERO records would be returned by this criterea, so: 1) if it doesn't fail it's likely the records and 2) if it does fail, it's likely the process of authenticating/communicating and not the records themselves. (Likely but still not guranteed.)
Well? With a zero record matching filter, IT STILL THROWS AN EXCEPTION.
Exception occurred in Microsoft Dynamics NAV --- Exception Dump --- Caught Exception: [Microsoft.Dynamics.Integration.AdapterAbstractionLayer.AdapterException] Exception occurred in Microsoft Dynamics NAV Stack trace: at Microsoft.Dynamics.Integration.Adapters.Nav2009.NavObjectProvider.ReadObjectKeys(DateTime modifiedDate) at Microsoft.Dynamics.Integration.Service.Tasks.MapWork.ReadObjectKeyList(DbMap map, DateTime queryDate, Int32& count) at Microsoft.Dynamics.Integration.Service.Tasks.MapWork.ProcessRecordsImplementation(OperationType operationType) Inner Exception: [System.NullReferenceException] Object reference not set to an instance of an object. Stack trace: at Microsoft.Dynamics.Integration.Adapters.Nav2009.CustomerObjectProvider.ReadDynamicObjectKeys(DateTime modifiedDate) at Microsoft.Dynamics.Integration.Adapters.Nav2009.NavObjectProvider.ReadObjectKeys(DateTime modifiedDate) User: _________\CRMRunner Machine: _________-SQL01
There are no other errors. CRM doesn't list any errors. The connector only lists "Exception occurred in Dynamics NAV" and doesn't log anything to a file, even with tracing set to full.
0
Comments
-
I found the same thread in Dynamics Community.
https://community.dynamics.com/nav/f/34/t/145852
See if it fixes your issues.0 -
Hello Katko,
I will share my personal experience regarding CRM connector for Nav.
I researched the possibility on using it in a solution of ours and I encounter many misbehaviors and difficulties in combining it with our custom entities.
In addition, I encountered many problems or errors that I could not figure out why or how to overcome and it was very much time consuming.
As a result I decided to build my own add-in that connects to CRM and creates/updates data by calling its functions from a MBS Nav NAS (Nav version 2013) and it went smoothly because we had control on what was happening and create a detail log on MBS Nav.
I hope you overcome your troubles and please share your experience here for other people to know.
Best regards,
Arhontis0
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions