Error: "internal error in SRC_GetCosmeticName_Raw" when creating new database connections

[gtorres8]

Issue

After a recent upgrade of Alteryx Designer and now trying to create a new database connection (such as SQL Server or Oracle), the following error occurs:
 

internal error in SRC_GetCosmeticName_Raw

 

When trying the Manage Data Connections window, the following error occurs and Designer has to be killed:
 

An Unhandled Exception occurred. A previous action may not have completed successfully.

Environment Details

 

• Alteryx Product
  • Version 2018+
• Any Database Platform
  • All versions

Cause

 

Corrupted Alias XML files after upgrade.

Resolution

 

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.

[DarleneK]

If you do not see the files mentioned in Step 2, complete a full uninstallation of Designer. A bad installation of Designer also causes this error. After a fresh re-installation, the error will disappear.