SQL editor
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
- Labels:
- Bug
- Error Message
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @ekosj ,
Have you updated the data connections and their respective aliases in the input tools/workflow?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes. The connections are updated. The workflows run just fine.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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! :)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 ?
![](/skins/images/6056C79A596CAB15526D64C598622101/responsive_peak/images/icon_anonymous_message.png)