java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 ');.*' order by ISNULL(`product_class`.`product_family`) ASC, `product_class`.`pr' at line 1

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Pentaho BI Platform Tracking by Benny Chow, 1 year ago
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 ');.*' order by ISNULL(`product_class`.`product_family`) ASC, `product_class`.`pr' at line 1
via Pentaho BI Platform Tracking by Benny Chow, 1 year ago
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 ');.*' order by ISNULL(`product_class`.`product_family`) ASC, `product_class`.`pr' at line 1
via Pentaho BI Platform Tracking by Curtis Boyden, 1 year ago
mondrian.olap.MondrianException: Mondrian Error:The 'Dt' dimension contains more than one hierarchy, therefore the hierarchy must be explicitly specified.
via Pentaho BI Platform Tracking by Curtis Boyden, 1 year ago
mondrian.olap.MondrianException: Mondrian Error:The 'Dt' dimension contains more than one hierarchy, therefore the hierarchy must be explicitly specified.
via Pentaho BI Platform Tracking by Golda David, 1 year ago
java.lang.ClassCastException: nl.cwi.monetdb.jdbc.MonetClob cannot be cast to java.lang.Com parable
via Pentaho BI Platform Tracking by Rob Fellows, 1 year ago
org.postgresql.util.PSQLException: ERROR: relation "ANALYZERDS" does not exist
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 ');.*' order by ISNULL(`product_class`.`product_family`) ASC, `product_class`.`pr' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2571)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1464)
at mondrian.rolap.SqlStatement.execute(SqlStatement.java:161)
at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:279)
at mondrian.rolap.HighCardSqlTupleReader.prepareTuples(HighCardSqlTupleReader.java:80)
at mondrian.rolap.HighCardSqlTupleReader.readMembers(HighCardSqlTupleReader.java:136)
at mondrian.rolap.RolapNativeSet$SetEvaluator.executeList(RolapNativeSet.java:234)
at mondrian.rolap.RolapNativeSet$SetEvaluator.execute(RolapNativeSet.java:177)
at mondrian.olap.fun.FilterFunDef$BaseIterCalc.evaluateIterable(FilterFunDef.java:118)
at mondrian.calc.impl.AbstractIterCalc.evaluate(AbstractIterCalc.java:50)
at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:864)
at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:87)
at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:62)
at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:99)
at mondrian.olap.fun.FilterFunDef$IterIterCalc.makeIterable(FilterFunDef.java:217)
at mondrian.olap.fun.FilterFunDef$BaseIterCalc.evaluateIterable(FilterFunDef.java:121)
at mondrian.calc.impl.AbstractIterCalc.evaluate(AbstractIterCalc.java:50)
at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:864)
at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:87)
at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:62)
at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:99)
at mondrian.olap.fun.GenerateFunDef$GenerateListCalcImpl.evaluateList(GenerateFunDef.java:111)
at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65)
at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:864)
at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:87)
at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:62)
at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:99)
at mondrian.olap.fun.OrderFunDef$CalcImpl.evaluateList(OrderFunDef.java:199)
at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65)
at mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:864)
at mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:87)
at mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:62)
at mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:99)
at mondrian.calc.impl.IterableListCalc.evaluateList(IterableListCalc.java:38)
at mondrian.olap.fun.UnionFunDef$1.evaluateList(UnionFunDef.java:56)
at mondrian.calc.impl.AbstractListCalc.evaluateIterable(AbstractListCalc.java:71)
at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:772)
at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:615)
at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:580)
at mondrian.rolap.RolapResult.(RolapResult.java:288)
at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:625)
at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:52)
at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:586)
at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:585)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Users with the same issue

61 times, 15 hours ago
9 times, 3 days ago
Once, 1 week ago
4 times, 2 weeks ago
Once, 2 weeks ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.