SYMPTOM:
In Strategy Desktop 9.4.1 - Developer 10.x, the following error occurs when trying to modify or create a Database Connection object from the Database Instances editor, as shown below:
'Key is not unique in collection.'
This error only occurs when using a 3-tier project source that is pointing to a Strategy Intelligence Server Universal running on UNIX/Linux.
CAUSE:
The error occurs because the ODBC.ini file, which stores all of the data source name connection information, has too many connections listed or is corrupted.
ACTION:
Edit the ODBC.ini file in the HOME directory where Strategy Intelligence Universal was installed. Clean up the file by removing all of the connections that are no longer required. After saving the file, restart the Strategy Intelligence Server Universal, and this will reload the information in the ODBC.ini file.
