Microsoft Dynamics CRM 4.0 Adapter for Microsoft Dynamics GP generic error

This error appears in the Adapter Log:

"The application encountered an unhandled system exception.  Contact your system administrator for details."

Also

"A system exception occurred that is preventing communication with the web server hosting the GP Web Services. Check the user credentials you are using to access the GP web services. Make sure these credentials are accurate in the Integration Adapter Settings."

 

 

The error message indicates a problem accessing GP web services. However, when you ‘Test Settings’ in the Adaptor the user gets the message ‘Test settings succeeded’.

To understand why the error is being generated navigate to
Start - Administrative Tools - Dynamics GP Web Service Exception Management Console
Once the snap-in loads, expand Web Service Exceptions, expand All Exceptions, then click on System Exceptions as per below shows.

 

Then double click on the exception, hit "View Exception Detail...", then "Inner Exception Detail..."

 

The above error indicates the ABCCODE isn't valid for my item.  In  the GP table where ABCCODE is stored (IV00101.ABCCODE), some items had an ABCCODE = 0.  The valid values for ABCCODE are 1, 2, 3 and 4.  (Under normal circumstances ABCCODE would not be = 0, but in this particular case the items were imported, and the import process did not update ABCCODE with a valid value).  Once this was corrected the item is successfully brought into CRM and the error was no longer.

In summary, if you receive the above mentioned generic error, check the Dynamics GP Web Service Exception Management Console for a more descriptive error of the issue.

 

Thank you
EMEA Dynamics CRM Team