org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT Id,FirstName,LastName FROM STAFF WHERE Id=${StaffId}

Pentaho BI Platform Tracking | widelia | 3 years ago
  1. 0

    My pentaho server used the default hsql.But the reports in pentaho-solution use the mysql JNDI.The first day, all reports works well.But all reports broken at tomorrow morning.All my reports work with xaction file.The error said "The Pentaho BI Platform reported an error while running an action sequence". Following is the log in tomcat catalina.out. 17:40:13,047 ERROR [AbstractReportProcessor] 1395085579: Report processing failed. 17:40:13,048 ERROR [SimpleReportingComponent] [execute] Component execution failed. org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT Id,FirstName,LastName FROM STAFF WHERE Id=${StaffId} at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:258) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:171) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:135) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:431) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryStatic(CachingDataFactory.java:184) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:130) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:85) at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:188) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.initializeForMasterReport(ProcessState.java:260) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:477) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1647) at org.pentaho.reporting.platform.plugin.output.PDFOutput.generate(PDFOutput.java:49) at org.pentaho.reporting.platform.plugin.SimpleReportingComponent.execute(SimpleReportingComponent.java:1069) .............................. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:679) ParentException: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:532) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) at com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1206) at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1198) at com.mysql.jdbc.ConnectionImpl.getMetaData(ConnectionImpl.java:3062) at com.mysql.jdbc.ConnectionImpl.getMetaData(ConnectionImpl.java:3057) at org.apache.commons.dbcp.DelegatingConnection.getMetaData(DelegatingConnection.java:345) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.getMetaData(PoolingDataSource.java:245) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.getBestResultSetType(SimpleSQLReportDataFactory.java:210) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.parametrizeAndQuery(SimpleSQLReportDataFactory.java:370) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:254) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:171) ................................ at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:679) Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 405,866 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:532) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.checkAutoClose(SimpleSQLReportDataFactory.java:668) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.getConnection(SimpleSQLReportDataFactory.java:196) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.getReferencedFields(SimpleSQLReportDataFactory.java:294) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.getReferencedFields(SQLReportDataFactory.java:182) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLDataFactoryCore.getReferencedFields(SQLDataFactoryCore.java:54) at org.pentaho.reporting.engine.classic.core.metadata.DefaultDataFactoryMetaData.getReferencedFields(DefaultDataFactoryMetaData.java:99) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.createCacheKey(CachingDataFactory.java:367) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryStatic(CachingDataFactory.java:162) ... 89 more Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2540) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990) ... 106 more 17:40:13,053 ERROR [SolutionEngine] 8eed0021-6891-11e3-8db2-dbbf549fe0fa:SOLUTION-ENGINE:edMeal_MealCount_AllSch.xaction: Action Sequence execution failed, see details below ?05?—?40???13?§’ CST | Error Time: 2013?1′12???19?—¥ ????????? ???? | Session ID: wf_Unit5 | Instance Id: 8eed0021-6891-11e3-8db2-dbbf549fe0fa | Action Sequence: edMeal_MealCount_AllSch.xaction | Execution Stack: EXECUTING ACTION: Pentaho Report (SimpleReportingComponent) | Action Class: SimpleReportingComponent | Action Desc: Pentaho Report | Loop Index (1-based): 0 Stack Tracerg.pentaho.platform.api.engine.ActionExecutionException: RuntimeContext.ERROR_0017 - ?′???¨?—??3??‰§è?? at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1325) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1262) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1161) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1105) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:987) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:897) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:399) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:317) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:193) at org.pentaho.platform.engine.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:159) at org.pentaho.platform.web.servlet.ViewAction.handleActionRequest(ViewAction.java:167) at org.pentaho.platform.web.servlet.ViewAction.doGet(ViewAction.java:316) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) ........... I know it maybe the mysql "wait_timeout", so I add autoReconnect=true to the JNDI url. But it still not work. Maybe because of the mysql version is 5. I tried to change the pentaho.xml.See below. <dbcp-defaults> <max-act-conn>20</max-act-conn> <max-idle-conn>2</max-idle-conn> <min-idle-conn>1</min-idle-conn> <num-idle-conn>5</num-idle-conn> <valid-query>select 1</valid-query> <when-exhausted-action>1</when-exhausted-action> <wait>100</wait> <test-while-idle>true</test-while-idle> <test-on-borrow>true</test-on-borrow> <test-on-return>true</test-on-return> </dbcp-defaults> I clear the cache of tomcat and restart the server. But it still broken. Can I config the c3po connection? If yes,how can I config this?

    Pentaho BI Platform Tracking | 3 years ago | widelia
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT Id,FirstName,LastName FROM STAFF WHERE Id=${StaffId}
  2. 0

    My pentaho server used the default hsql.But the reports in pentaho-solution use the mysql JNDI.The first day, all reports works well.But all reports broken at tomorrow morning.All my reports work with xaction file.The error said "The Pentaho BI Platform reported an error while running an action sequence". Following is the log in tomcat catalina.out. 17:40:13,047 ERROR [AbstractReportProcessor] 1395085579: Report processing failed. 17:40:13,048 ERROR [SimpleReportingComponent] [execute] Component execution failed. org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT Id,FirstName,LastName FROM STAFF WHERE Id=${StaffId} at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:258) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:171) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:135) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:431) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryStatic(CachingDataFactory.java:184) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:130) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:85) at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:188) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.initializeForMasterReport(ProcessState.java:260) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:477) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1647) at org.pentaho.reporting.platform.plugin.output.PDFOutput.generate(PDFOutput.java:49) at org.pentaho.reporting.platform.plugin.SimpleReportingComponent.execute(SimpleReportingComponent.java:1069) .............................. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:679) ParentException: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:532) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) at com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1206) at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1198) at com.mysql.jdbc.ConnectionImpl.getMetaData(ConnectionImpl.java:3062) at com.mysql.jdbc.ConnectionImpl.getMetaData(ConnectionImpl.java:3057) at org.apache.commons.dbcp.DelegatingConnection.getMetaData(DelegatingConnection.java:345) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.getMetaData(PoolingDataSource.java:245) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.getBestResultSetType(SimpleSQLReportDataFactory.java:210) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.parametrizeAndQuery(SimpleSQLReportDataFactory.java:370) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:254) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:171) ................................ at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:679) Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 405,866 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:532) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3090) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3520) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.checkAutoClose(SimpleSQLReportDataFactory.java:668) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.getConnection(SimpleSQLReportDataFactory.java:196) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.getReferencedFields(SimpleSQLReportDataFactory.java:294) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.getReferencedFields(SQLReportDataFactory.java:182) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLDataFactoryCore.getReferencedFields(SQLDataFactoryCore.java:54) at org.pentaho.reporting.engine.classic.core.metadata.DefaultDataFactoryMetaData.getReferencedFields(DefaultDataFactoryMetaData.java:99) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.createCacheKey(CachingDataFactory.java:367) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryStatic(CachingDataFactory.java:162) ... 89 more Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2540) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2990) ... 106 more 17:40:13,053 ERROR [SolutionEngine] 8eed0021-6891-11e3-8db2-dbbf549fe0fa:SOLUTION-ENGINE:edMeal_MealCount_AllSch.xaction: Action Sequence execution failed, see details below ?05?—?40???13?§’ CST | Error Time: 2013?1′12???19?—¥ ????????? ???? | Session ID: wf_Unit5 | Instance Id: 8eed0021-6891-11e3-8db2-dbbf549fe0fa | Action Sequence: edMeal_MealCount_AllSch.xaction | Execution Stack: EXECUTING ACTION: Pentaho Report (SimpleReportingComponent) | Action Class: SimpleReportingComponent | Action Desc: Pentaho Report | Loop Index (1-based): 0 Stack Tracerg.pentaho.platform.api.engine.ActionExecutionException: RuntimeContext.ERROR_0017 - ?′???¨?—??3??‰§è?? at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1325) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1262) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1161) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1105) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:987) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:897) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:399) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:317) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:193) at org.pentaho.platform.engine.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:159) at org.pentaho.platform.web.servlet.ViewAction.handleActionRequest(ViewAction.java:167) at org.pentaho.platform.web.servlet.ViewAction.doGet(ViewAction.java:316) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) ........... I know it maybe the mysql "wait_timeout", so I add autoReconnect=true to the JNDI url. But it still not work. Maybe because of the mysql version is 5. I tried to change the pentaho.xml.See below. <dbcp-defaults> <max-act-conn>20</max-act-conn> <max-idle-conn>2</max-idle-conn> <min-idle-conn>1</min-idle-conn> <num-idle-conn>5</num-idle-conn> <valid-query>select 1</valid-query> <when-exhausted-action>1</when-exhausted-action> <wait>100</wait> <test-while-idle>true</test-while-idle> <test-on-borrow>true</test-on-borrow> <test-on-return>true</test-on-return> </dbcp-defaults> I clear the cache of tomcat and restart the server. But it still broken. Can I config the c3po connection? If yes,how can I config this?

    Pentaho BI Platform Tracking | 3 years ago | widelia
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT Id,FirstName,LastName FROM STAFF WHERE Id=${StaffId}
  3. 0

    Error retrieving next row on connecting to hive table through Pentaho Report Designer

    pentaho.com | 7 months ago
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: select id, name from test
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Starting with a blank report, I created a new JDBC connection and hand-typed a SQL query which was invalid. When I clicked the preview button, a dialog flashed on the screen and disappeared but received no other feedback. The log file contains the following information: WARN 17-07 15:24:07,235 - Query thread received exception [Failed at query: select foo from bar] WARN 17-07 15:24:07,280 - QueryPanel.actionPerformed org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: select foo from bar at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:265) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:107) at org.pentaho.reporting.ui.datasources.jdbc.ui.PreviewDialog$QueryThread.run(PreviewDialog.java:195) ParentException: java.sql.SQLException: Table not found in statement [select foo from bar] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:155) at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:107) at org.pentaho.reporting.ui.datasources.jdbc.ui.PreviewDialog$QueryThread.run(PreviewDialog.java:195)

    Pentaho BI Platform Tracking | 7 years ago | David Kincade
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: select foo from bar
  6. 0

    Pentaho - Couldn't find SQLSERVER drivers to connect

    Stack Overflow | 3 years ago | Yann Braga
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT * FROM Client;

    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. org.pentaho.reporting.engine.classic.core.ReportDataFactoryException

      Failed at query: SELECT Id,FirstName,LastName FROM STAFF WHERE Id=${StaffId}

      at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData()
    2. org.pentaho.reporting
      SimpleReportingComponent.execute
      1. org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:258)
      2. org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:171)
      3. org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:135)
      4. org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:431)
      5. org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryStatic(CachingDataFactory.java:184)
      6. org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:130)
      7. org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:85)
      8. org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97)
      9. org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:188)
      10. org.pentaho.reporting.engine.classic.core.states.process.ProcessState.initializeForMasterReport(ProcessState.java:260)
      11. org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:477)
      12. org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1647)
      13. org.pentaho.reporting.platform.plugin.output.PDFOutput.generate(PDFOutput.java:49)
      14. org.pentaho.reporting.platform.plugin.SimpleReportingComponent.execute(SimpleReportingComponent.java:1069)
      14 frames