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.

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