Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

12
Replies
3962
Views
AnuradhaW Member since 2015 37 posts
Virtusa
Posted: Jun 12, 2018
Last activity: Jun 14, 2018
Closed

error in your SQL syntax; check the manual that corresponds to your MySQL server version

I'm getting exception in report definition, My properties mapped into external mysql DB, When i was run the report definition, this exception occurred

Show More

I'm getting exception in report definition, My properties mapped into external mysql DB, When i was run the report definition, this exception occurred

Error:
** An error occured 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 near '.`customerid` AS "customerid" , "PC0".`customername` AS "customername" FROM TELE' at line 1 DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.`customerid` AS "customerid" , "PC0".`customername` AS "customername" FROM TELE' at line 1 | SQL Code: 1064 | SQL State: 42000

"


Show Less
To see attachments, please log in.
Low-Code App Development
DevOps
Data Integration

Posted: 6 years ago

Did you check- what happens when you run his query directly from the database. Can you please check if these columns/schema/tables ( customerid/customername/TELECOMMUNICATION/bsstest ) exists as query seems to be correct.

To see attachments, please log in.
Posted: 6 years ago

I have run that query directly from the Mysql DB, same exception occurred in mysql DB , Exception is

"SELECT "PC0".`customerid` AS "customerid" , "PC0".`customername` AS "customername" FROM TELECOMMUNICATION.bsstest "PC0"    Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.`customerid` AS "customerid" , "PC0".`customername` AS "customername" FROM TELE' at line 1    0.047 sec"

 

To see attachments, please log in.
Posted: 6 years ago

can you please check if "customername" and other columns exist and mapping is proper. Also, check if all the columns are in lower case i.e check case sensitivity.   I actually prepared some sample data and ran a similar query and it seems to be working. The problem seems to be at db end.

To see attachments, please log in.

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

Pega Collaboration Center 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