com.solarmetric.jdbc.ReportingSQLException

Syntax error or access violation, message from server: "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 'SELECT COUNT(*) FROM entityinter_entprop t2 WHERE (t2.ENTITYINT" {prepstmnt 23459640 SELECT COUNT(t0.JDOID) FROM entityinter t0 INNER JOIN entityintersourceidentity t1 ON t0.SOURCEIDENTITY_JDOID = t1.JDOID WHERE (? = ? AND t1.CLIENTIDENTITY_JDOID IS NULL AND t0.TYPESTR = ? AND (? <> ? OR 0 = (SELECT COUNT(*) FROM entityinter_entprop t2 WHERE (t2.ENTITYINTERACTIONPROPS_JDOID IS NULL) AND t0.JDOID = t2.JDOID))) [params=(String) 1, (String) 1, (String) EMAIL_SENT, (String) 1, (String) 1] [reused=0]} [code=1064, state=42000]

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web49

  • Syntax error or access violation, message from server: "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 'SELECT COUNT(*) FROM entityinter_entprop t2 WHERE (t2
  • via Oracle Community by 3004, 2 weeks ago
    Syntax error or access violation, message from server: "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 '' at line 1" {prepstmnt 3338151 SELECT COUNT(?) FROM [reused=0]} [code=1064, state=42000]
  • = t5.oid(+) AND t3.FOR_MGMT_COMPANY_OID = t4.oid(+) AND t5.FOR_MGMT_COMPANY_OID = t6.oid(+) [params=(String) joeRozario, (String) joeRozario, (String) joeRozario, (String) joeRozario, (String) joeRozario] [reused=0]} [code=1790, state=42000]
  • Stack trace

    • com.solarmetric.jdbc.ReportingSQLException: Syntax error or access violation, message from server: "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 'SELECT COUNT(*) FROM entityinter_entprop t2 WHERE (t2.ENTITYINT" {prepstmnt 23459640 SELECT COUNT(t0.JDOID) FROM entityinter t0 INNER JOIN entityintersourceidentity t1 ON t0.SOURCEIDENTITY_JDOID = t1.JDOID WHERE (? = ? AND t1.CLIENTIDENTITY_JDOID IS NULL AND t0.TYPESTR = ? AND (? <> ? OR 0 = (SELECT COUNT(*) FROM entityinter_entprop t2 WHERE (t2.ENTITYINTERACTIONPROPS_JDOID IS NULL) AND t0.JDOID = t2.JDOID))) [params=(String) 1, (String) 1, (String) EMAIL_SENT, (String) 1, (String) 1] [reused=0]} [code=1064, state=42000] at kodo.query.AbstractQuery.executeWithMap(AbstractQuery.java:760) at com.jario.server.console.report.queries.EmailedExternally.runQuery(EmailedExternally.java:77) at com.jario.server.console.report.engine.Column.run(Column.java:222) at java.lang.Thread.run(Thread.java:534) at com.jario.server.console.report.engine.Column.runReport(Column.java:195) at com.jario.server.console.report.engine.Row.run(Row.java:100) at java.lang.Thread.run(Thread.java:534)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You’re the first here who have seen this exception.