ADMIN BI360 Error: An item with the same key has already been added.

Summary:

This article troubleshoots an error that occurs when trying to add BI360DW connections after an upgrade from 3.x to 4.x due to leftover BI360 data connections which were corrupted during the upgrade.

Article Sections:

• Symptoms
• Causes
• Resolution
• Properties

Symptoms:

When a user tires to add a data connection in Admin Tool > System > Settings > Data Connections and when trying to add to a role's Company Access in Admin Tool > Security > Access Management following an upgrade from 3.x to 4.x, they receive the following error message:

An item with the same key has already been added.

All other live connections work fine.

Causes:

The old BI360 data connections were left over and corrupted during the upgrade.

Resolution:

NOTE: Make a backup of the OSR_Repository prior to making any changes.

The following needs to be done by a SQL DBA who is familiar with SQL and running SQL queries. 

1. Delete from these tables where IntegrationName = 'SODS-MSSQL' to remove all corrupt data connections:
   • dbo.Integrations
   • dbo.IntegrationSettings
   • dbo.SystemConnectionswill 
2. Re-add the BI360DW to the data connections.
3. Remove all the old BI360DW from the Company Access window.

Properties:

BI360 Administration 4.x