Error - An Item With The Same Key Has Already Been Registered
Article ID: KB0078150
Updated On:
| Products | Versions |
|---|---|
| TIBCO Scribe Insight | - |
Description
If you see the following error:
Registration Error: An item with the same key has already been added.
You see this error when you try to register TIBCO Scribe Insight and there is a duplicate entry in the Scribe Internal Database KSYNC table for one of the Microsoft Dynamics CRM Properties.
If there are entries for both versions of Microsoft Dynamics CRM, run the delete statements below to remove references to Microsoft Dynamics CRM 2011. Once complete, open the Workbench and Register TIBCO Scribe Insight.
For additional information see the following in the TIBCO Scribe Insight Help: TIBCO Scribe Adapter For Microsoft Dynamics CRM
Registration Error: An item with the same key has already been added.
Resolution
Run the SQL script below against the Scribe Internal Database in SQL to determine whether or not there are MICROSOFT DYNAMICS CRM 2011 and MICROSOFT DYNAMICS CRM entries. SELECT TOP 1000 [SECTION]
,[KEYNAME]
,[KEYVALUE]
FROM [ScribeInternal].[SCRIBE].[KSYNC]
Where KEYNAME like '%MICROSOFT DYNAMICS CRM%'
,[KEYNAME]
,[KEYVALUE]
FROM [ScribeInternal].[SCRIBE].[KSYNC]
Where KEYNAME like '%MICROSOFT DYNAMICS CRM%'
If there are entries for both versions of Microsoft Dynamics CRM, run the delete statements below to remove references to Microsoft Dynamics CRM 2011. Once complete, open the Workbench and Register TIBCO Scribe Insight.
delete from SCRIBE.KSYNC where SECTION = 'ADAPTERS' and KEYNAME = 'MICROSOFT DYNAMICS CRM 2011.LABEL';
delete from SCRIBE.KSYNC where SECTION = 'ADAPTERS' and KEYNAME = 'MICROSOFT DYNAMICS CRM 2011.HELPFILE';
delete from SCRIBE.KSYNC where SECTION = 'ADAPTERS' and KEYNAME = 'MICROSOFT DYNAMICS CRM 2011.SKU';
delete from SCRIBE.KSYNC where SECTION = 'ADAPTERS' and KEYNAME = 'MICROSOFT DYNAMICS CRM 2011.SKULABEL';
delete from SCRIBE.KSYNC where SECTION = 'ADAPTERS' and KEYNAME = 'MICROSOFT DYNAMICS CRM 2011.VERSION';
delete from SCRIBE.KSYNC where SECTION = 'ADP' and KEYNAME = 'DATA SOURCES.ADAPTERS.MICROSOFT DYNAMICS CRM 2011.LABEL';
delete from SCRIBE.KSYNC where SECTION = 'ADP' and KEYNAME = 'DATA SOURCES.ADAPTERS.MICROSOFT DYNAMICS CRM 2011.ADAPTERID';
delete from SCRIBE.KSYNC where SECTION = 'ADP' and KEYNAME = 'DATA SOURCES.ADAPTERS.MICROSOFT DYNAMICS CRM 2011.CONNECTLIB';
delete from SCRIBE.KSYNC where SECTION = 'ADP' and KEYNAME = 'DATA SOURCES.ADAPTERS.MICROSOFT DYNAMICS CRM 2011.REMOTABLE';
delete from SCRIBE.KSYNC where SECTION = 'ADP' and KEYNAME = 'DATA SOURCES.ADAPTERS.MICROSOFT DYNAMICS CRM 2011.SOURCETYPE';
delete from SCRIBE.KSYNC where SECTION = 'ADAPTERS' and KEYNAME = 'MICROSOFT DYNAMICS CRM 2011.HELPFILE';
delete from SCRIBE.KSYNC where SECTION = 'ADAPTERS' and KEYNAME = 'MICROSOFT DYNAMICS CRM 2011.SKU';
delete from SCRIBE.KSYNC where SECTION = 'ADAPTERS' and KEYNAME = 'MICROSOFT DYNAMICS CRM 2011.SKULABEL';
delete from SCRIBE.KSYNC where SECTION = 'ADAPTERS' and KEYNAME = 'MICROSOFT DYNAMICS CRM 2011.VERSION';
delete from SCRIBE.KSYNC where SECTION = 'ADP' and KEYNAME = 'DATA SOURCES.ADAPTERS.MICROSOFT DYNAMICS CRM 2011.LABEL';
delete from SCRIBE.KSYNC where SECTION = 'ADP' and KEYNAME = 'DATA SOURCES.ADAPTERS.MICROSOFT DYNAMICS CRM 2011.ADAPTERID';
delete from SCRIBE.KSYNC where SECTION = 'ADP' and KEYNAME = 'DATA SOURCES.ADAPTERS.MICROSOFT DYNAMICS CRM 2011.CONNECTLIB';
delete from SCRIBE.KSYNC where SECTION = 'ADP' and KEYNAME = 'DATA SOURCES.ADAPTERS.MICROSOFT DYNAMICS CRM 2011.REMOTABLE';
delete from SCRIBE.KSYNC where SECTION = 'ADP' and KEYNAME = 'DATA SOURCES.ADAPTERS.MICROSOFT DYNAMICS CRM 2011.SOURCETYPE';
For additional information see the following in the TIBCO Scribe Insight Help: TIBCO Scribe Adapter For Microsoft Dynamics CRM
Issue/Introduction
If you see an error indicating that a duplicate item has already been registered, you may have a duplicate entry in your Scribe Internal Database. Use these instructions to resolve the error.
Environment
TIBCO Scribe Insight
Feedback
Yes
No
Powered by
