nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

SQL editor

ekosj

I had the 32-bit version of Alteryx (2022.1..1.30961_1) but when I was just issued a new laptop it had the 64-bit version installed. All my old workflows still run. In fact, they are lots faster. But (you knew there was a "but" coming) I can no longer edit the SQL for those old workflows, I was lazy and never took the time to build the dynamic interfaces to change frequently changed parameters, I always just changed things directly in the SQL. But now I can't seem to access the SQL. When I click on the button that should bring up the SQL editor, Alteryx just locks up tight and needs to be restarted. Ideas?

Error Message

Bugs & Issues

Accepted answers

JagdeeshN

Have you also tried reestablishing the database connection in a new Input Data tool?

If you are trying to access the SQL query itself, can you try the following and try accessing the query that way:-

- In Alteryx Designer: Options > User Settings > Edit User Settings > Advanced > Display XML in Properties Window. This will allow you to view the XML code of individual tools and the entire workflow as you work in Alteryx designer.

- Alteryx Designer workflows (.yxmd/.yxmc/.yxwz/.bak) can also be opened in text editing programs (like Notepad++). This will allow you to view the same XML code in another program.

All comments

JagdeeshN

Hi @ekosj ,

Have you updated the data connections and their respective aliases in the input tools/workflow?

ekosj

Yes. The connections are updated. The workflows run just fine.

JagdeeshN

What happens when you click on the 3 dots next to the Table or Query setting in the configuration window? Does Alteryx just hang?

Have you also tried reestablishing the database connection in a new Input Data tool?

ekosj

RE - What happens when you click on the 3 dots next to the Table or Query setting in the configuration window? Does Alteryx just hang?

Exactly

JagdeeshN

Have you also tried reestablishing the database connection in a new Input Data tool?

If you are trying to access the SQL query itself, can you try the following and try accessing the query that way:-

- Alteryx Designer workflows (.yxmd/.yxmc/.yxwz/.bak) can also be opened in text editing programs (like Notepad++). This will allow you to view the same XML code in another program.

ekosj

Havent tried option 1 yet ... but option 2 ... "Alteryx Designer workflows (.yxmd/.yxmc/.yxwz/.bak) can also be opened in text editing programs (like Notepad++). This will allow you to view the same XML code in another program." works a treat!!!

Push comes to shove I can use that to rebuild the queries easily.

Thanks!!!

JagdeeshN

awesome.

This can definitely be a possible work around.

I would also suggest reaching out to Alteryx support to understand better why it was hanging in the first place!

guibader

Hi guys, i have the same situation, when i click in the 3 dots to open the sql editor appears this msg box.

It started because a downloaded the last version of alteryx.

This option "Alteryx Designer workflows (.yxmd/.yxmc/.yxwz/.bak) can also be opened in text editing programs (like Notepad++). This will allow you to view the same XML code in another program." works to me too, but have you seen this error ?

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15912

binu_acs 15783

MarqueeCrew 13710

apathetichell 13703