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.
IN
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
Virtusa
LK
this is the query SELECT "PC0".`customerid` AS "customerid" , "PC0".`customername` AS "customername" FROM TELECOMMUNICATION.bsstest "PC0"
Pegasystems Inc.
IN
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.
IN
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.
Virtusa
LK
i'm using Mysql latest version ,i think this issue due to latest version, it's not support some old syntax . Here Attached with Screen shoot
Virtusa
LK
In this query "pc0".customerid , without alias with double quotes around it working fine, pc0.customerid
Pegasystems Inc.
IN
Probably you can take help of DBA to address this issue. As said earlier, it does not seems to be an issue with PRPC.
Pegasystems Inc.
IN
What is the version of mysql with which you are facing this issue?
Virtusa
LK
Version of the mysql server is 8.0.11(Mysql community server - GPL)
Coforge Technologies DPA
IN
Hi
If the query copied is the exact the same then probably the issue is with single quotes, it seems to be different,
' or `.
Virtusa
LK
query is not working with (double quotes) "pc0".customerid but query is working correctly without (double quotes) pc0.customerid