Error message: Object reference not set to an instance of an object. Anyone else get this

[Manoj Chaurasia]

Currently doing Scribe training and seem to get Object Reference error when running replication from MS_CRM to MySQL_Hosted.

 

The error reads: Object reference not set to an instance of an object.

 

I have a trial environment of Dynamics 365 CRM. I have also hosted a free SQL Database to be used in MySQL Workbench.

 

I am trying to replicate the data from MS CRM to MySQL so that the tables will be created and I can then carry on with labs to learn how the integration works.

 

Unfortunately becasue of this issue I've hit a brick wall so to speak.

 

Any help or guidance will be greatly appreciated.

 

Thanks

[Manoj Chaurasia]

Hello Liam,

 

Can you make sure that you have the proper permissions on both MS_CRM and MySQL.

 

MS_CRM

"YourMicrosoft Dynamics 365account must have appropriate permissions to allowTIBCO Scribe Onlineto perform Create, Read, Update, Delete, and Batch or non-Batch operations. Contact yourMicrosoft Dynamics 365administrator for assistance."

 

MySQL:

"... associate the Login username with the hostname of the computer where theTIBCO Scribe OnlineAgent is installed. The hostname can be either the machine name or IP address of the machine where the Agent is installed."

 

The links below should assist you with information about the connectors you are using, and required privileges and permissions:

https://help.scribesoft.com/scribe/en/index.htm#sol/conn/mysql.htm

https://help.scribesoft.com/scribe/en/index.htm#sol/conn/crm.htm

 

With regards,

Marzieh

[David Mavin 2]

I keep getting this over and over again on any entity. CSM account is administrator and so is MySQL The connectors connect fine just does not appear to work - keeps throwingObject reference not set to an instance of an object.

[David Mavin 2]

I keep getting this also the CRM is administrator and the MYSQL is also. Connectors fully connect but kee getting Object reference not set to an instance of an object.on any entity replication

[Ash Arendsz]

Hi Guys,

I had similar issueusing mysql ver5.7 as target and CRM D365 trial as source.

I selected one entity "account" to replicate and it gave me this error.

After looking into it, I've found a quick way to resolve it, by installing the sql connector fromthe marketplace, no need to use amicrosoft sql server, just install the microsoft sql connector by clicking the install button in the marketplace.

It can take a few minutes for the change to take effect,after the second run, thereplication started working again.

 

In training level 1 there is a note regarding this issue with MYSQL.

***Also, after running your Lab exercise #2 Replication Service Solution, should you find that the selected replication entity table has been created, however, the table is emptywithin the target MySQL database, please try installing the Microsoft SQL Server connector from the Marketplace and rerun your RS Solution. You do not need to use the connector, just install it. This is a known potential issue which is currently under review.

[David Mavin 2]

Thanks Ash,

 

I did install the SQL connector, but it did not work at the time. Anyway I would update the training as try as I may I could not resolve.