TCPE-357: DCM connection fails if the query has lines commented out using --

[ntobon]

Issue

Receive various syntax errors on queries with lines commented out using – when using a connection set up through DCM.
 

Input Data (1) Error SQLPrepare: SQL compilation error:¶Empty SQL statement.

Input Data (1) Error SQLPrepare: SQL compilation error:¶syntax error line 1 at position 223 unexpected '<EOF>'.

Environment Details

 

• Alteryx Designer
  • Versions 2021.4, 2022.1.
• Any database.

Cause

Defect: TCPE-357
Status: Open.

After receiving the error, if you re-open the query you will notice that the formatting is all off and all the carriage returns have been removed making the query a big long comment; the whole thing after the comments gets commented out.

Example 1:

Query before running the workflow:

image.png

Error:

image.png

Re-open query after the failure:

image.png image.png


Example 2:

Query before running the workflow:

image.png

Error:
image.png

Re-open query after the failure:

image.png image.png

Diagnosis 

Same queries work fine using regular ODBC connections.   
 

Resolution

Defect TCPE-357 is target for resolution in future release. 
 

Workaround

Remove the commented lines out completely on the query before running the workflow.

Additional Resources

• DCM - Designer