Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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.
Suggest Edit

Published July 17, 2017 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us