Query Deletes from my input tool when I try to edit

[mreinsch]

Cannot edit my query because it deletes each time I go to edit. Even if I just select the input it deletes the query. Has anyone else seen this bug in 11.5?

[JeradR · Accepted solution]

Hi @mreinsch,

This was a known issue for 11.5. It was fixed in 2018.1 and included in a stable update for 11.7. You can also workaround the issue by opening the workflow in a text editor and adding a semicolon prior to the pipe character separating the connection string from the query string. For example...

Original - odbc:DSN=Connection;UID=user;PWD=__EncPwd1__|Select BLAH.dbo.BLUE.COLUMN, BLAH.dbo.BLUE...

Revised - odbc:DSN=Connection;UID=user;PWD=__EncPwd1__;|Select BLAH.dbo.BLUE.COLUMN, BLAH.dbo.BLUE...

Please let me know if this helps.

Jerad Rades

Sr. Customer Support Engineer