Hi there
I came across a strange problem when using the Dynamics Connector with CRM 2011 and Dynamics NAV 2009 R2.
I have installed the connector, configured it and it's up and running with the supplied/default maps as well as some 15 custom maps that I have setup. It's all working beautifully until you try and add a new field to an existing entity in CRM 2011 and try to get that field reflected in the Dynamics Connector.
The problem that after re-publishing the entity in CRM through the connector Configuration, the CRM entity would show up twice CRM entity listing section when using the "New Map" screen. Upon selecting either one of the two causes the entire Connector to crash with the error "Reference to the Object not set".
So what I have done is this:
- Installed the Connector and configured CRM and NAV (in CRM I configured the default selected entities and some new entities I created).
- Created maps for these entities and activated the maps. It;s all running 100%.
- Create a new field in CRM 2011 on the account entity, for example and publish the account entity changes.
- When I run the Dynamics Connector now (even after restarting the connector service and the application) the new field does not appear in a new map that I create for the NAV Customer Card to CRM account entity, so I decided to re0run the Dynamics Connector CRM configuration.
- I ran the Dynamics Connector application and clicked on the "Adapter Settings" button. Selected Microsoft Dynamics CRM on the left hand side and clicked on the Configure Microsoft Dynamics CRM" link on the right hand side.
- In the Configuration Option I selected the "Install" option (default) and on the next page I deselected all entities and just enabled the "account" entity in the list. I placed a checkmark in the "Skip complete configuration..." checkbox.
- Click Next and then I clicked on the Configure button.
- Configuration successfully published the account entity.
According to the Dynamics Connector manual these are the steps that one is suppose to follow to refresh the entity, but this causes the issue.
I then opened the Dynamics Connector (I restarted the connector service first) and then deleted my old NAV Customer to CRM account map and clicked on the "New Map" button - right there in the New Map feature where you select the source entity and the destination entity is where I now have two account entities in CRM in the list and no matter what I do the connector will no longer run for the CRM account entity - it will crash with the error "Reference to the object not set" and I have to delete records in the MSDI database where the ReaderObject and WriterObject = null to be able to re-open the connector application again.
This is a serious problem to me since the only way that I have been able to overcome this problem is to use the "Remove" option from the CRM Configuration in the Dynamics Connector and then re-install the connector in CRM. The issue with this is that all the data in the connector-related fields are deleted which means the NAV data no longer links to CRM data and this causes duplication of records in CRM when re-running the maps.
Has anyone seen this?
Many thanks
Wiechardt