TCPE-527: Error ORA-00942 in SQL Editor Query

[Mohsen_84]

Error: “ORA-00942: Table or View Does Not Exist/ORA-00903 Invalid Table Name”

 

Environment Details

 

After update to Designer 2022.3 previous workflows with working Queries in SQL Editor now fail with ORA error due to parse formatting issues.

 

ORA-00942 Table or View Does Not Exist/ORA-00903 Invalid Table Name

 

• Alteryx Designer
  • 2022.3
• Oracle
  • 19.17

Cause

 

Defect: TCPE-527.
Status: Open

We suspect that this could be due to there being a line break within the editor.

image.png

image.png

This could possibly happen with other databases outside of Oracle. With Snowflake for example, you get below error:

image.png

 

Resolution

Defect TCPE-527 is targeted for resolution in a future release.
 

Workaround

 

1. Move the fields and table names next to the Select and From Queries to be on the same line.
2. If there are multiple fields underneath each other just move the first field and table name next to Select and From

image.png

 


 

Additional Resources

• Using the visual query builder

• Error SQLPrepare: [Teradata][ODBC Teradata Driver][Teradata Database] (-3706) Syntax error: expected...