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

Pentaho BI Platform Tracking | Benny Chow | 5 years ago
  1. 0

    This used to work on Mondrian 3.2 but after upgrade to 3.3 this Analyzer test started failing. It may have something to do with native evaluation of the match function on mysql. Stack trace: 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 at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(AnalysisAreaManager.java:278) at com.pentaho.analyzer.report.ReportManagerImpl.parseAndExecuteMDX(ReportManagerImpl.java:301) at com.pentaho.analyzer.report.ReportManagerImpl.getCVResultSet(ReportManagerImpl.java:362) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(ReportManagerImpl.java:117) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(ReportManagerImpl.java:88) at com.pentaho.analyzer.report.ReportRequestService.runReportSync(ReportRequestService.java:228) at com.pentaho.analyzer.service.impl.PredicateFilterTest.testFilterContainsSpecialChars(PredicateFilterTest.java:420) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.junit.internal.runners.TestMethod.invoke(TestMethod.java:59) at org.junit.internal.runners.MethodRoadie.runTestMethod(MethodRoadie.java:98) at org.junit.internal.runners.MethodRoadie$2.run(MethodRoadie.java:79) at org.junit.internal.runners.MethodRoadie.runBeforesThenTestThenAfters(MethodRoadie.java:87) at org.junit.internal.runners.MethodRoadie.runTest(MethodRoadie.java:77) at org.junit.internal.runners.MethodRoadie.run(MethodRoadie.java:42) at org.junit.internal.runners.JUnit4ClassRunner.invokeTestMethod(JUnit4ClassRunner.java:88) at org.junit.internal.runners.JUnit4ClassRunner.runMethods(JUnit4ClassRunner.java:51) at org.junit.internal.runners.JUnit4ClassRunner$1.run(JUnit4ClassRunner.java:44) at org.junit.internal.runners.ClassRoadie.runUnprotected(ClassRoadie.java:27) at org.junit.internal.runners.ClassRoadie.runProtected(ClassRoadie.java:37) at org.junit.internal.runners.JUnit4ClassRunner.run(JUnit4ClassRunner.java:42) at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:49) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197) Caused by: 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 java.lang.reflect.Constructor.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.<init>(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) Here's the SQL: 2187 [mondrian.rolap.RolapResultShepherd$executor] DEBUG mondrian.rolap.RolapUtil - HighCardSqlTupleReader.readTuples [[Product].[Product Category]]: done executing sql [select `product_class`.`product_family` as `c0`, `product_class`.`product_department` as `c1`, `product_class`.`product_category` as `c2` from `FOODMART`.`product` as `product`, `FOODMART`.`product_class` as `product_class`, `FOODMART`.`sales_fact_1997` as `sales_fact_1997` where `product`.`product_class_id` = `product_class`.`product_class_id` and `sales_fact_1997`.`product_id` = `product`.`product_id` group by `product_class`.`product_family`, `product_class`.`product_department`, `product_class`.`product_category` having UPPER(c2) REGEXP '.*A"); WINDOW.ALERT("WOOT');.*' order by ISNULL(`product_class`.`product_family`) ASC, `product_class`.`product_family` ASC, ISNULL(`product_class`.`product_department`) ASC, `product_class`.`product_department` ASC, ISNULL(`product_class`.`product_category`) ASC, `product_class`.`product_category` ASC], exec+fetch 8 ms, 0 rows MDX: With Set [*NATIVE_CJ_SET] as 'Filter([*BASE_MEMBERS_Product], Not IsEmpty ([Measures].[Unit Sales]))' Set [*SORTED_ROW_AXIS] as 'Order([*CJ_ROW_AXIS],[Product].CurrentMember.OrderKey,BASC,Ancestor([Product].CurrentMember,[Product].[Product Department]).OrderKey,BASC)' Set [*NATIVE_MEMBERS_Product] as 'Generate([*NATIVE_CJ_SET], {[Product].CurrentMember})' Set [*BASE_MEMBERS_Product] as 'Filter([Product].[Product Category].Members,[Product].CurrentMember.Caption Matches ("(?i).*\Qa""); window.alert(""woot'');\E.*"))' Set [*BASE_MEMBERS_Measures] as '{[Measures].[*FORMATTED_MEASURE_0]}' Set [*CJ_ROW_AXIS] as 'Generate([*NATIVE_CJ_SET], {([Product].currentMember)})' Set [*CJ_COL_AXIS] as '[*NATIVE_CJ_SET]' Member [Product].[*TOTAL_MEMBER_SEL~SUM] as 'Sum([*NATIVE_MEMBERS_Product])', SOLVE_ORDER=-100 Member [Measures].[*FORMATTED_MEASURE_0] as '[Measures].[Unit Sales]', FORMAT_STRING = 'Standard', SOLVE_ORDER=400 Select [*BASE_MEMBERS_Measures] on columns, Union({[Product].[*TOTAL_MEMBER_SEL~SUM]},[*SORTED_ROW_AXIS]) on rows From [Sales]

    Pentaho BI Platform Tracking | 5 years ago | Benny Chow
    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
  2. 0

    This used to work on Mondrian 3.2 but after upgrade to 3.3 this Analyzer test started failing. It may have something to do with native evaluation of the match function on mysql. Stack trace: 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 at com.pentaho.analyzer.service.impl.AnalysisAreaManager.executeQuery(AnalysisAreaManager.java:278) at com.pentaho.analyzer.report.ReportManagerImpl.parseAndExecuteMDX(ReportManagerImpl.java:301) at com.pentaho.analyzer.report.ReportManagerImpl.getCVResultSet(ReportManagerImpl.java:362) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(ReportManagerImpl.java:117) at com.pentaho.analyzer.report.ReportManagerImpl.runReport(ReportManagerImpl.java:88) at com.pentaho.analyzer.report.ReportRequestService.runReportSync(ReportRequestService.java:228) at com.pentaho.analyzer.service.impl.PredicateFilterTest.testFilterContainsSpecialChars(PredicateFilterTest.java:420) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.junit.internal.runners.TestMethod.invoke(TestMethod.java:59) at org.junit.internal.runners.MethodRoadie.runTestMethod(MethodRoadie.java:98) at org.junit.internal.runners.MethodRoadie$2.run(MethodRoadie.java:79) at org.junit.internal.runners.MethodRoadie.runBeforesThenTestThenAfters(MethodRoadie.java:87) at org.junit.internal.runners.MethodRoadie.runTest(MethodRoadie.java:77) at org.junit.internal.runners.MethodRoadie.run(MethodRoadie.java:42) at org.junit.internal.runners.JUnit4ClassRunner.invokeTestMethod(JUnit4ClassRunner.java:88) at org.junit.internal.runners.JUnit4ClassRunner.runMethods(JUnit4ClassRunner.java:51) at org.junit.internal.runners.JUnit4ClassRunner$1.run(JUnit4ClassRunner.java:44) at org.junit.internal.runners.ClassRoadie.runUnprotected(ClassRoadie.java:27) at org.junit.internal.runners.ClassRoadie.runProtected(ClassRoadie.java:37) at org.junit.internal.runners.JUnit4ClassRunner.run(JUnit4ClassRunner.java:42) at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:49) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197) Caused by: 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 java.lang.reflect.Constructor.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.<init>(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) Here's the SQL: 2187 [mondrian.rolap.RolapResultShepherd$executor] DEBUG mondrian.rolap.RolapUtil - HighCardSqlTupleReader.readTuples [[Product].[Product Category]]: done executing sql [select `product_class`.`product_family` as `c0`, `product_class`.`product_department` as `c1`, `product_class`.`product_category` as `c2` from `FOODMART`.`product` as `product`, `FOODMART`.`product_class` as `product_class`, `FOODMART`.`sales_fact_1997` as `sales_fact_1997` where `product`.`product_class_id` = `product_class`.`product_class_id` and `sales_fact_1997`.`product_id` = `product`.`product_id` group by `product_class`.`product_family`, `product_class`.`product_department`, `product_class`.`product_category` having UPPER(c2) REGEXP '.*A"); WINDOW.ALERT("WOOT');.*' order by ISNULL(`product_class`.`product_family`) ASC, `product_class`.`product_family` ASC, ISNULL(`product_class`.`product_department`) ASC, `product_class`.`product_department` ASC, ISNULL(`product_class`.`product_category`) ASC, `product_class`.`product_category` ASC], exec+fetch 8 ms, 0 rows MDX: With Set [*NATIVE_CJ_SET] as 'Filter([*BASE_MEMBERS_Product], Not IsEmpty ([Measures].[Unit Sales]))' Set [*SORTED_ROW_AXIS] as 'Order([*CJ_ROW_AXIS],[Product].CurrentMember.OrderKey,BASC,Ancestor([Product].CurrentMember,[Product].[Product Department]).OrderKey,BASC)' Set [*NATIVE_MEMBERS_Product] as 'Generate([*NATIVE_CJ_SET], {[Product].CurrentMember})' Set [*BASE_MEMBERS_Product] as 'Filter([Product].[Product Category].Members,[Product].CurrentMember.Caption Matches ("(?i).*\Qa""); window.alert(""woot'');\E.*"))' Set [*BASE_MEMBERS_Measures] as '{[Measures].[*FORMATTED_MEASURE_0]}' Set [*CJ_ROW_AXIS] as 'Generate([*NATIVE_CJ_SET], {([Product].currentMember)})' Set [*CJ_COL_AXIS] as '[*NATIVE_CJ_SET]' Member [Product].[*TOTAL_MEMBER_SEL~SUM] as 'Sum([*NATIVE_MEMBERS_Product])', SOLVE_ORDER=-100 Member [Measures].[*FORMATTED_MEASURE_0] as '[Measures].[Unit Sales]', FORMAT_STRING = 'Standard', SOLVE_ORDER=400 Select [*BASE_MEMBERS_Measures] on columns, Union({[Product].[*TOTAL_MEMBER_SEL~SUM]},[*SORTED_ROW_AXIS]) on rows From [Sales]

    Pentaho BI Platform Tracking | 5 years ago | Benny Chow
    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
  3. 0

    Database Values Plugin , MySQL error on Jira - Atlassian Answers

    atlassian.com | 11 months ago
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jiradb.CUSTOMFIELDOPTION' doesn't exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error while editing some fields in Squirrel

    squirrel-sql | 6 years ago | *anonymous
    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 '&test='&test'' at line 1
  6. 0

    运行时出现异常

    GitHub | 3 years ago | gewanbo
    java.lang.ExceptionInInitializerError

  1. jstrayer 4 times, last 2 months ago
  2. linxiaolong 1 times, last 4 months ago
  3. mortalman7 4 times, last 5 months ago
  4. bpbhat77 22 times, last 7 months ago
  5. Kialandei 1 times, last 2 weeks ago
27 more registered users
65 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. 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()
  2. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    4. java.lang.reflect.Constructor.newInstance(Unknown Source)
    4 frames
  3. MySQL jdbc
    StatementImpl.executeQuery
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    2. com.mysql.jdbc.Util.getInstance(Util.java:381)
    3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
    4. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
    5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
    6. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
    7. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
    8. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
    9. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642)
    10. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2571)
    11. com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1464)
    11 frames
  4. mondrian.rolap
    RolapNativeSet$SetEvaluator.execute
    1. mondrian.rolap.SqlStatement.execute(SqlStatement.java:161)
    2. mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:279)
    3. mondrian.rolap.HighCardSqlTupleReader.prepareTuples(HighCardSqlTupleReader.java:80)
    4. mondrian.rolap.HighCardSqlTupleReader.readMembers(HighCardSqlTupleReader.java:136)
    5. mondrian.rolap.RolapNativeSet$SetEvaluator.executeList(RolapNativeSet.java:234)
    6. mondrian.rolap.RolapNativeSet$SetEvaluator.execute(RolapNativeSet.java:177)
    6 frames
  5. mondrian.olap.fun
    FilterFunDef$BaseIterCalc.evaluateIterable
    1. mondrian.olap.fun.FilterFunDef$BaseIterCalc.evaluateIterable(FilterFunDef.java:118)
    1 frame
  6. mondrian.calc.impl
    AbstractIterCalc.evaluate
    1. mondrian.calc.impl.AbstractIterCalc.evaluate(AbstractIterCalc.java:50)
    1 frame
  7. mondrian.rolap
    RolapNamedSetEvaluator.evaluateTupleIterable
    1. mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:864)
    2. mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:87)
    3. mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:62)
    3 frames
  8. mondrian.mdx
    NamedSetExpr$1.evaluateIterable
    1. mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:99)
    1 frame
  9. mondrian.olap.fun
    FilterFunDef$BaseIterCalc.evaluateIterable
    1. mondrian.olap.fun.FilterFunDef$IterIterCalc.makeIterable(FilterFunDef.java:217)
    2. mondrian.olap.fun.FilterFunDef$BaseIterCalc.evaluateIterable(FilterFunDef.java:121)
    2 frames
  10. mondrian.calc.impl
    AbstractIterCalc.evaluate
    1. mondrian.calc.impl.AbstractIterCalc.evaluate(AbstractIterCalc.java:50)
    1 frame
  11. mondrian.rolap
    RolapNamedSetEvaluator.evaluateTupleIterable
    1. mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:864)
    2. mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:87)
    3. mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:62)
    3 frames
  12. mondrian.mdx
    NamedSetExpr$1.evaluateIterable
    1. mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:99)
    1 frame
  13. mondrian.olap.fun
    GenerateFunDef$GenerateListCalcImpl.evaluateList
    1. mondrian.olap.fun.GenerateFunDef$GenerateListCalcImpl.evaluateList(GenerateFunDef.java:111)
    1 frame
  14. mondrian.calc.impl
    AbstractListCalc.evaluate
    1. mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65)
    1 frame
  15. mondrian.rolap
    RolapNamedSetEvaluator.evaluateTupleIterable
    1. mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:864)
    2. mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:87)
    3. mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:62)
    3 frames
  16. mondrian.mdx
    NamedSetExpr$1.evaluateIterable
    1. mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:99)
    1 frame
  17. mondrian.olap.fun
    OrderFunDef$CalcImpl.evaluateList
    1. mondrian.olap.fun.OrderFunDef$CalcImpl.evaluateList(OrderFunDef.java:199)
    1 frame
  18. mondrian.calc.impl
    AbstractListCalc.evaluate
    1. mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:65)
    1 frame
  19. mondrian.rolap
    RolapNamedSetEvaluator.evaluateTupleIterable
    1. mondrian.rolap.RolapResult.evaluateExp(RolapResult.java:864)
    2. mondrian.rolap.RolapNamedSetEvaluator.ensureList(RolapNamedSetEvaluator.java:87)
    3. mondrian.rolap.RolapNamedSetEvaluator.evaluateTupleIterable(RolapNamedSetEvaluator.java:62)
    3 frames
  20. mondrian.mdx
    NamedSetExpr$1.evaluateIterable
    1. mondrian.mdx.NamedSetExpr$1.evaluateIterable(NamedSetExpr.java:99)
    1 frame
  21. mondrian.calc.impl
    IterableListCalc.evaluateList
    1. mondrian.calc.impl.IterableListCalc.evaluateList(IterableListCalc.java:38)
    1 frame
  22. mondrian.olap.fun
    UnionFunDef$1.evaluateList
    1. mondrian.olap.fun.UnionFunDef$1.evaluateList(UnionFunDef.java:56)
    1 frame
  23. mondrian.calc.impl
    AbstractListCalc.evaluateIterable
    1. mondrian.calc.impl.AbstractListCalc.evaluateIterable(AbstractListCalc.java:71)
    1 frame
  24. mondrian.rolap
    RolapConnection$1.call
    1. mondrian.rolap.RolapResult.executeAxis(RolapResult.java:772)
    2. mondrian.rolap.RolapResult.evalLoad(RolapResult.java:615)
    3. mondrian.rolap.RolapResult.loadMembers(RolapResult.java:580)
    4. mondrian.rolap.RolapResult.<init>(RolapResult.java:288)
    5. mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:625)
    6. mondrian.rolap.RolapConnection.access$000(RolapConnection.java:52)
    7. mondrian.rolap.RolapConnection$1.call(RolapConnection.java:586)
    8. mondrian.rolap.RolapConnection$1.call(RolapConnection.java:585)
    8 frames
  25. Java RT
    Thread.run
    1. java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
    2. java.util.concurrent.FutureTask.run(Unknown Source)
    3. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
    4. java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    5. java.lang.Thread.run(Unknown Source)
    5 frames