KB18461: ‘The key is already associated with an element of this collection’ error appears when trying to edit the ‘Pre-/Post-SQL…’ setting of a static or dynamic subscription set in MicroStrategy Narrowcast Server

• Strategy

When any user tries to modify the 'Pre-/Post-SQL…' setting of a static or dynamic subscription set, either via the Subscription Set Editor or the Subscription Set wizard, the following error occurs in MicroStrategy Narrowcast Server: "The key is already associated with an element of this collection."

SYMPTOM:
When any user tries to modify the 'Pre-/Post-SQL…' setting of a static or dynamic subscription set, either via the Subscription Set Editor or the Subscription Set wizard, the following error occurs in Strategy Narrowcast Server:


The key is already associated with an element of this collection

CAUSE:
More than one DSN exists with the exact same name within the list of system DSNs of the machine that uses and hosts the Strategy Narrowcast Server.

ACTION:
The user needs to remove all and any repeated entries from the entire list of system DSNs of the machine that uses and hosts Strategy Narrowcast Server. Once this action has been performed and the Strategy Narrowcast Server system has been restarted, the user will now be able to edit the 'Pre-/Post-SQL…' setting.

The system DSNs for the machine that hosts Strategy Narrowcast Server can be located at:

For Strategy 9.x: Start > Settings > Control Panel > Administrative Tools > ODBC Data Sources (32-bit) > System DSN
For Strategy 10.x: Start > Settings > Control Panel > Administrative Tools > ODBC Data Sources (64-bit) > System DSN

Comment

0 comments

Details

Knowledge Article

Published:

May 30, 2017

Last Updated:

May 30, 2017