We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Error: "An item with the same key has already been added" when selecting Oracle Quick Connect

ntobon
Alteryx
Alteryx
Created

Environment Details


Alteryx Designer
  • All Alteryx version
  • Oracle

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

image.png

image.png

Cause


Alteryx is not able to find the alias files.

Resolution

 

Rename the alias files and and generate new ones.

- USER’s Data base connections are stored in here: %APPDATA%\Alteryx\Engine\UserAlias.xml  
(UserAlias.xml file) 
- SYSTEM ’s Data base connections are stored in here: C:\ProgramData\Alteryx\Engine\SystemAlias.xml
(SystemAlias.xml file and SystemConnections.xml file)

a. Open File Explorer.
b. Navigate to those folders.
c. Rename those files.
c. Re-launch Alteryx Designer. This will re-sync the files and you should now be able to see and use the data connections.
d. Test again the Oracle Quick Connect. 


 

null
No ratings