Object reference not set to an instance of an object.

Jul 18, 2008 at 8:49 AM
Hi All.

Firstly, thanks for the CRM Connector - it looks to be a great product for leveraging the use of Microsoft CRM.

I have an issue with the SageCRM Service which pulls information from Sage. While the issue is similar to the other thread on this discussion page, mine is slightly different.

The Connector Service makes an effort to start, and never moves beyond the state of 'Starting'. I enabled logging on the integration settings, and can see that the service is pulling data from our Sage repository. CRM reflects these imported customers too, however not all are transferred. The connector will stay 'Starting' for over 2 hours, and then fail before importing all of the customers. The following is the output from this activity. I have tried on 4 seperate occasions to get past this by restarting the connector in the hope it would self-heal.

2008/07/17 19:16:55 - Found Existing Record for account, CRM Id = b67da24d-e553-dd11-98d1-001cc4959ce8
2008/07/17 19:16:58 - Update Account record, CRM Id = b67da24d-e553-dd11-98d1-001cc4959ce8
2008/07/17 19:17:07 - Create Account record, Name = <<CUSTOMER NAME REMOVED>>
2008/07/17 19:17:08 - CRMSageIntegration failed at method: ProcessCRMSageIntegration with exception: Server was unable to process request.
2008/07/17 19:17:08 - CRMSageIntegration failed at method: ProcessCRMSageIntegration with exception: Object reference not set to an instance of an object.

When I restart the service, things look good again as follows:

2008/07/18 09:29:30 - Sage -> Microsoft CRM Processing started...
2008/07/18 09:29:30 - Retrieving Sage Data.
2008/07/18 09:29:36 - Updating CRM.
2008/07/18 09:29:36 - Found Existing Record for account, CRM Id = b68f48e8-d853-dd11-98d1-001cc4959ce8
2008/07/18 09:29:39 - No change to Account record, CRM Id = b68f48e8-d853-dd11-98d1-001cc4959ce8
2008/07/18 09:29:43 - Found Existing Record for account, CRM Id = ba8f48e8-d853-dd11-98d1-001cc4959ce8

However the same error above is returned after some time. Initially I thought it may be something to do with the data in Sage, however it's difficult to actually trace the customer record which may be at fault as I cannot determine which accounts are being pulled at a time.

Any ideas would be greatly welcomed.

Many thanks

Diarmaid
Republic of Ireland