New CRM Custom Entity Not Visible In TIBCO Scribe® Insight Workbench

Products	Versions
TIBCO Scribe Insight	7.9.1

Description

If you have created a new custom entity in Dynamics CRM and you cannot see that entity when you are working in TIBCO Scribe® Insight, you must clear the Dynamics CRM records from the table that stores the metadata in the ScribeInternal database.

Issue/Introduction

If you have created a new custom entity in Dynamics CRM and you cannot see that entity when you are working in TIBCO Scribe® Insight, you must clear the Dynamics CRM records from the table that stores the metadata in the ScribeInternal database.

Resolution

In SQL Server under Databases, select the SCRIBEINTERNAL database.
Run the SQL scripts below against the Scribe Internal Database to review and delete the connection entries for your Dynamics CRM connection from the SCRIBE.ADAPTERMETADATA table:

Select * From SCRIBE.ADAPTERMETADATA

This shows you the the contents of the table before deleting any records. Next run the following script:

Delete From SCRIBE.ADAPTERMETADATA

Where NAME IN ('Adapter for Dynamics 365 and CRM','DynamicsCrm 2011 Adapter','Adapter for Dynamics CRM') and IDENTIFIER<>'DEFAULT';

Note: The Connection name in the example above must be modified to match the name of your Dynamics CRM connection as it is shown in the SCRIBE.ADAPTERMETADATA table.

Open the TIBCO Scribe® Insight Workbench.
Open the DTS.
Re-connect again to Dynamics CRM using the same credentials.
Run the DTS again.

Welcome to "KB Articles"