We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

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

ntobon
Alteryx
Alteryx
Created

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.pngimage.png

Error:

image.pngimage.png

Re-open query after the failure:

image.pngimage.png image.pngimage.png


Example 2:

Query before running the workflow:

image.pngimage.png

Error:
image.pngimage.png

Re-open query after the failure:

image.pngimage.png image.pngimage.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