I am doing setup and configuration of "Connector for Dynamics NAV" to synchronise my existing CRM and NAV databases. I am using CRM 2011 and NAV 2009 R2.
I am following the configuration guide "MSDynConnectorNAVconfig.pdf" and i have reached to the stage for activating the first map i.e.NAV Enumerated Values to Picklist. I am using the default maps as it is without any customization.
When activating this map for the first time i do not see the Last Run Time being changed in the Status section. Also there is no Log being generated when i see the Log section. I have checked that the Connector service is running.
However when i see the Windows log in the Event Viewer i get the below error message:
The error says that there is some problem with the Country Code field mapping.
I am not sure why and i don't know how to resolve this error.
Any help will be much appreciated.
Error point on issue with NAV part mapping, could you show what you have in your PickList Map for "dynamics_erpcountrycode" field?
My map has "dynamics_erpcountrycode" = "Countries Regions\Country Regions\Code" and it works fine
Thanks for your reply.
Below is the screenshot of the Enum-Picklist map.
It appears that the mapping is same as you have however i don't know from where the event log is picking up the mapping to Countries Regions\Item\Code.
Here is the screenshot of the event log.
Hope the above information is usefull.
Looks like you have modified Country Page (PAG10) in NAV.
Please make sure that your page has field "Code". if not, then you have to add it and refresh Connector Setting for NAV.
Another strange thing, on screenshot you have "Countries/Regions\Country/Regions\Code", on my map I have "Countries Regions\Country Regions\Code". Spaces instead slashes.
You can also try to delete this line in mapping and add it again, probably it will help.
The Page10 do have the Code field.
I then deleted the map and added it as Countries_Regions\Country_Region\Code. Note the underscore '_' instead of forward slash '/'.
After making the above change and running the map again, i see that the map is running successfully. I even verified the picklist values populated from NAV to CRM.
The reason for using underscrore instead of forward slash is due to the setup done on Alter Database dialog, Integration tab > Remove Characters. Here it is set as ."\/'. which effectively removes the forward slash found in Country/Region and replaces it with underscore i.e. Country_Region (as seen in SQL database table name)
Please check your Remove Character setting in Alter Database dialog for having spaces in your object name i.e. Country Region .
One hintch i have is that inspite of the map running successfully, the Last Run Time is not getting updated.
Hey, after exiting the connector and running it again i can see the Last run time getting updated.
I suspect it was not changing since i was running a RDP to the connector machine for a long time.
Seems like the problem is solved.
Thanks once again.
After running the Customer-Account map, it seems that the issue is not resolved. The log shows an error displaying "...The supplied country "UK" is not in the integrated Microsoft Dynamics ERP Country options". This means that the Enum-Picklist mapping for Dynamics ERP Country Code has some problem.
Although i have set the Dynamics ERP Country Code mapped to Countries_Regions\Country_Region\Code in Enum-Picklist mapping, when i click the icon next to this mapping field, the Map Destination Field dialog does now show any selection for Countries_Regions. Since i have entered the mapping manually, it maps the field to a constant value. Sounds strange to me.
Is there any selection available in Map Destination Field dialog for Countires_Regions?
Has anyone solved this Topic so far? We have exactly the same problem here.
Is the value "UK" actually in the option set win CRM? Was it added to NAV after the initial sync was done or did it never make it over to CRM?
In the enumerated values to picklist map the NAV source should be: "Countries_Regions\Item\Code" for the "Item" node under the "Dynamics ERP Country Code" destination.
This posting is provided "AS IS" with no warranties, and confers no rights.
Connector for Microsoft Dynamics team blog
It seems that the Connector still took the old Mapping after an upgrade so we were deleting the Integration and then the objectConfig and creating the new Integration again.
ObjectConfig can be found here:
C:\Program Files (x86)\Microsoft Dynamics\Microsoft Dynamics Adapter\Adapters\Microsoft.Dynamics.Integration.Adapters.Nav2009\ObjectConfig
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13