2023.2 Errors from comments at beginning of SQL queries

[pbibler]

We are getting errors like "Error - ToolId 46: Error opening "SELECT * FROM --EPIC ACE PLACEMENT DETAIL" when running queries that have a comment before a Select statement.  These ran fine under 2023.1.  Anyone seeing these?

[Raj]

Temporarily removing the comment before the SELECT statement could serve as a quick workaround to check if the query executes without errors. Though it might not be the most convenient solution, it could provide immediate relief until a more permanent resolution is implemented.

[pbibler]

It does work when the comment is removed, but we're not looking forward to going through a lot of workflows.  Thanks!

[Raj]

@pbibler please mark it done if your problem is solved.
or you can add if you are looking for anything else.

[pbibler]

I was hoping to understand if anyone had seen this and had a solution other than modifying every query like this.

[pbibler · Accepted solution]

Looks like this is part of the patch coming out in March

[DataZeta]

I'm also experiencing this after an upgrade to 2023.2 today. Do we know if there will definitely be a patch coming soon? I may roll back to 2023.1 and wait until the patched version is released rather than trawl through all of my workflows to "fix" the problem.  

[apathetichell]

Downgrade. It's the easiest way to fix this.