Support Article
1064 SQLState:Double Quotes around the alias base-table name
SA-38760
Summary
Unable to run a report definition that is selecting records on a MySQL external database.
Error Messages
An error occurred on executing the query for the report definition - There was a problem getting a list: code: 1064 SQLState: 42000 Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use
Steps to Reproduce
1. Map a MySQL external database to a class.
2. Create a report definition for that class.
3. Run it and observe it fails.
Root Cause
A third-party product issue MySQL server cannot run a sql with Double quotes around the base table name alias,
example : Select "pc0".column1 from base table "pc0";
This sql cannot run on a Mysql server.
It runs successfully on the 5 servers that are certified for report definitions (Oracle, Teradata, DB2, MSSql and Postgres).
Resolution
Instead of using a report definition use a Connect SQL external query to the database and use this Connect SQL rule as part of the activity which in turn will be the data page's source.
Published July 17, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.