0

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

this is db query on tracer "SELECT "PC0".customerid AS "customerid" , "PC0".customername AS "customername" FROM TELECOMMUNICATION.bsstest "PC0" "

anu
  • 1
  • 1
  • https://dba.stackexchange.com ask db related question at db stackexchange – Ratan Uday Kumar Jun 13 '18 at 05:05
  • Are you sure that class property names and db column names are same ? I mean if db column name is `customerid` then the class property should also have to be `customerid`. – AJ. Jun 13 '18 at 10:57
  • Yes, both are same, I have run that query directly from the mysql db. i think this error occurred in " PC0" part. db query is "SELECT "PC0".customerid AS "customerid" , "PC0".customername AS "customername" FROM TELECOMMUNICATION.bsstest "PC0" " – anu Jun 13 '18 at 11:17

1 Answers1

0

I guess MySQL doesn't recognize the alias with quotes around it. You need to follow up with PEGA regarding this.

Tarun
  • 1