Fixed: "After upgrading to the Insight Unicode product (Insight 7.5), the CRM adapter will throw errors.."

Topic: "After upgrading to the Insight Unicode product (Insight 7.5), the CRM adapter will throw errors.."

Tags:

We have seen in a few instances after upgrading to the Insight Unicode product (Insight 7.5), the CRM adapter will throw errors
'Scribe.DynamicsCrm5.Adapter.DynamicsCRMTable - Error opening table or Query 896'
'Object reference not set to an instance of object.'

These are due to corruption of the metadata during upgrade and requires a refresh of the CRM metadata.

Adapter for Microsoft Dynamics CRM 2011 metadata
To import metadata when using the Adapter for Dynamics CRM 2011:

1. Stop the Scribe services.
2. From SQL Server Management Studio, run the following query:

use SCRIBEINTERNAL;
delete from SCRIBE.ADAPTERMETADATA where NAME='DynamicsCrm 2011 Adapter' and IDENTIFIER='DEFAULT';

3. Close SQL Server Management Studio.
4. Restart Scribe services; the next time you reconnect, Insight will automatically update the metadata the next time using a connection is made.

Posted by Josh S on Jan 09, 2012 03:48PM

We have also seen this issue for CRM 4.
Error opening data source Scribe.MSCRMAdapter30.Database
Error details:
System.ArgumentNullException: Value cannot be null.
Parameter name: s
at System.IO.StringReader..ctor(String s)
at System.Xml.XmlDocument.LoadXml(String xml)
at Scribe.DRS.MetadataOverride.FromXml(String xml)
at Scribe.DynamicsCrm.Adapter.Database.DoConnect(Object db, Int16
flags)
The resolution was to perform the following steps:
1. From SQL Server Management Studio, run the following query:
use SCRIBEINTERNAL;
delete from SCRIBE.ADAPTERMETADATA where NAME='DynamicsCrmAdapter' and IDENTIFIER='DEFAULT';
2. Close SQL Server Management Studio.
Then Run
3. Run MetadataConfig.exe (It is located in the Scribe Program folder for exp C:\Program Files (x86)\Scribe)
4. Select the DynamicsCRMAdapter from the adapter dropdown list
5. Click Import Metadata button
6. Select DynamicsCRMAdapterMetadata.xml in the Import Metadata File Browser (also in C:\Program Files (x86)\Scribe

Posted in: Scibe Troubleshooting