Tracerg.pentaho.platform.api.engine.ActionExecutionException: RuntimeContext.ERROR_0017 - ?′???¨?—??3??‰§è??

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
    Tracerg.pentaho.platform.api.engine.ActionExecutionException: RuntimeContext.ERROR_0017 - ?′???¨?—??3??‰§è??
  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
    Tracerg.pentaho.platform.api.engine.ActionExecutionException: RuntimeContext.ERROR_0017 - ?′???¨?—??3??‰§è??

    Root Cause Analysis

    1. Tracerg.pentaho.platform.api.engine.ActionExecutionException

      RuntimeContext.ERROR_0017 - ?′???¨?—??3??‰§è??

      at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent()
    2. org.pentaho.platform
      ViewAction.doGet
      1. org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1325)
      2. org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1262)
      3. org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1161)
      4. org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1105)
      5. org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:987)
      6. org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:897)
      7. org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:399)
      8. org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:317)
      9. org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:193)
      10. org.pentaho.platform.engine.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:159)
      11. org.pentaho.platform.web.servlet.ViewAction.handleActionRequest(ViewAction.java:167)
      12. org.pentaho.platform.web.servlet.ViewAction.doGet(ViewAction.java:316)
      12 frames
    3. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
      1 frame