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
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.pngThis 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
- Move the fields and table names next to the Select and From Queries to be on the same line.
- 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