Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

GCSE-280: Error "An item with the same key has already been added" when selecting Quick Connect (Oracle or Microsoft SQL Server)

ntobon
Alteryx
Alteryx
Created

Issue


    When selecting Oracle Quick Connect or Microsoft SQL Server Microsoft SQL Server, the following error occurs:
     
    An item with the same key has already been added

    image.png

    image.png
     

    Environment Details

    • Alteryx Designer
      • Version 2021.3
    • Oracle / Microsoft SQL Server
      • All versions


    Cause

    The error occurs if there are two or more connections for the same data source with the same name. 
    Defect: GCSE-280. 
    Status: Open.

    Resolution


    Defect GCSE-280 is target for resolution in future release.

    Workaround #1: 

    1. Close Designer.

    2. Browse to the following files and make a copy of them to the Desktop. (This is to backup the XML files away from the Alteryx folder.)

     

    • C:\ProgramData\Alteryx\Engine\SystemAlias.xml
    • %USERPROFILE%\AppData\Roaming\Alteryx\Engine\UserAlias.xml
    • %USERPROFILE%\AppData\Roaming\Alteryx\Engine\GalleryAlias.xml

     

    3. Delete those XML files and re-open Designer and re-test the issue.


    Note

    When re-opening Designer, only the GallerAlias.xml file will be re-created using the Sync button on the Manage Data Connections window.

    If pasting either the SystemAlias.xml and/or UserAlias.xml, brings back the original error, then the files are corrupted. Repeat the resolution steps above and create the connections again from the Alteryx GUI.

    Workaround #2: 

    Remove one or more data connections to resolve the duplication.



    No ratings