When connecting to the Adapter for Microsoft Dynamics 365 And CRM or Publisher the metadata for the CRM organization will be synchronized. If there are many tables or the CRM organization is highly customized this can cause the metadata payload to be too large and the following exception would be received. "System.OutOfMemoryException."

1. On the TIBCO Scribe® Insight server navigate to the drive where Insight is installed > Program Files (x86) > Scribe > Locate the “DynamicsCRMAdapter2011Metadata.xml” file and open it in a text editor as administrator.
2. Locate the section "<!-- Omit these objects -->".
3. Add the following to omit all of the msdyn tables -  <BusinessEntityTableMetadata TableName="msdyn_*" omit="true"/>
4. Add additional lines using the sample above changing the "TableName" to omit other tables that are not needed. 
5. Run the below SQL script against the Insight Internal Database to delete the metadata entries for your Dynamics 365 and CRM adapter connection from the SCRIBE.ADAPTERMETADATA table. Deleting the entries in this table will allow the metadata to be reloaded upon the next connection to the CRM organization
    
   Delete From SCRIBE.ADAPTERMETADATA
   Where NAME IN ('Adapter for Dynamics 365 and CRM','DynamicsCrm 2011 Adapter','Adapter for Dynamics CRM') and IDENTIFIER<>'DEFAULT';
    
6. Re-connect the Dynamics 365 and CRM Adapter or Publisher to reload the metadata and verify the "System.OutOfMemoryException." is resolved.