Deleting Metadata From The Scribe Internal Database

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

The steps shown below are for removing metadata for Dynamics CRM.

  1. In SQL Server under Databases, select the SCRIBEINTERNAL database.
  2. 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 contents of the table before deleting any records. Next run the script below:

    Delete From SCRIBE.ADAPTERMETADATA

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

    Note: 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.

  3. Open the Workbench.
  4. Open the DTS.
  5. Re-connect again to Dynamics CRM using the same credentials.
  6. Run the DTS again.

See also

Administrator's Guide