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
I'm getting exception in report definition, My properties mapped into external mysql DB, When i was run the report definition, this exception occurred
"
Pegasystems Inc.
US
Hi,
This error can have multiple causes. Please refer.
https://www.inmotionhosting.com/support/website/database-troubleshooting/error-1064
Also, see the query in tracer(enable DB query in settings) and run it directly from the database. Also, post the complete query here so that we can look into it.
Regards,
Rachit
Pegasystems Inc.
US
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.
Virtusa
LK
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"
Pegasystems Inc.
US
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 q
uery and it seems to be working. The problem seems to be at db end.
Pegasystems Inc.
US
Probably you can take help of DBA to address this issue. As said earlier, it does not seems to be an issue with PRPC.
