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)



    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



    Environment Details

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


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


    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.


    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