Alteryx Alias Problem - Errors Continuously

Hi Community/ Alteryx,

Hopefully you can help with this issue. The user has 2 alias's in his connection manager that have worked for about 6 months. Today when he opened up a workflow to run it he received an error. Error pictures are attached. When we try to use or click on the connection it says the error. When we go to the alias manager it errors. Basically we can't seem to find a way to fix or see whatever is causing the alias to be invalid.

Error log was sent.

Please advise if possible?

Thanks,

Andrew

Error3.png

Error2.png

Error1.png

Workflow

Input

Accepted answers

patrick_digan

Sorry I forgot to ask if you're trying to use a gallery or user alias since both files exist.

If you're trying to use one of your two "user" aliases, is it possible to backup the user alias XML (just change the filename) and then recreate the 2 connections in their alteryx designer?

If you're trying to use a "gallery" data connection, you'll need a gallery admin to check that the name of the connection hasn't changed in the gallery admin screens and that the user still has access.

I'm really at a loss so these are just shots in the dark. All the info you've provided seems normal, so I must be overlooking something.

All comments

David-Carnes

Hey @Hydra!

Have you tried connecting to the data source without using the aliases? Start from scratch . If that works then perhaps you can delete the offending aliases and set new ones.

If you encounter errors then perhaps drivers/DSNs/TNSnames files/whatever have gotten updated/corrupted/deleted/whatever. Or the data sources themselves have issues.

Good luck!

Ciao,

David

patrick_digan

@Hydra I would try opening the workflow using notepad and looking for lines like this:

          <CachedCosmeticName />
          <File RecordLimit="1" FileFormat="17">aka:ALIAS_NAME|||TABLE_NAME</File>

This is the underlying data for input tools, and it may shed some light on the alias that appears to have gotten messed up. If you can post back/message me those couple of lines, we may be able to further debug. For what it's worth, here is where the alias info is stored:

SYSTEM aliases: "C:\ProgramData\Alteryx\Engine\SystemAlias.xml"
USER aliases: "C:\Users\<<YOURUSERID>>\AppData\Roaming\Alteryx\Engine\UserAlias.xml"
GALLERY aliases: "C:\Users\<<YOURUSERID>>\AppData\Roaming\Alteryx\Engine\GalleryAlias.xml"