com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'hibernate.pro_audit' doesn't exist

Pentaho BI Platform Tracking | Golda David | 8 years ago
  1. 0

    Got the following error when I run the SQL script after dropping the already existing one for Hibernate and Quartz. (CE-473 and EE-453 from the Ci build Creating Hibernate Repository... ERROR 1146 (42S02) at line 13: Table 'hibernate.pro_schedule' doesn't exist After this started the PCI got the following error 09:39:35,937 ERROR [Logger] Error: Pentaho 09:39:35,937 ERROR [Logger] misc-org.pentaho.platform.engine.services.audit.AuditSQLEntry: Table 'hibernate.pro_audit' doesn't exist com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'hibernate.pro_audit' doesn't exist at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) at org.pentaho.platform.engine.services.audit.AuditSQLEntry.auditAll(AuditSQLEntry.java:110) at org.pentaho.platform.engine.core.audit.AuditEntry.auditAll(AuditEntry.java:58) at org.pentaho.platform.engine.core.audit.AuditEntry.auditJobDuration(AuditEntry.java:47) at org.pentaho.platform.engine.core.audit.AuditHelper.audit(AuditHelper.java:83) at org.pentaho.platform.engine.core.system.BaseSession.<init>(BaseSession.java:59) at org.pentaho.platform.engine.core.system.StandaloneSession.<init>(StandaloneSession.java:57) at org.pentaho.platform.engine.core.system.StandaloneSession.<init>(StandaloneSession.java:53) at org.pentaho.platform.engine.core.system.StandaloneSession.<init>(StandaloneSession.java:49) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:313) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:246) at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:131) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022) at org.apache.catalina.core.StandardHost.start(StandardHost.java:736) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:448) at org.apache.catalina.core.StandardServer.start(StandardServer.java:700) at org.apache.catalina.startup.Catalina.start(Catalina.java:552) 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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433) 09:39:35,968 ERROR [Logger] Error end: 09:39:35,968 ERROR [Logger] Error: Pentaho 09:39:35,968 ERROR [Logger] misc-org.pentaho.platform.engine.core.audit.AuditHelper: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Can't call rollback when autocommit=true org.pentaho.platform.api.engine.AuditException: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Can't call rollback when autocommit=true at org.pentaho.platform.engine.services.audit.AuditSQLEntry.auditAll(AuditSQLEntry.java:116) at org.pentaho.platform.engine.core.audit.AuditEntry.auditAll(AuditEntry.java:58) at org.pentaho.platform.engine.core.audit.AuditEntry.auditJobDuration(AuditEntry.java:47) at org.pentaho.platform.engine.core.audit.AuditHelper.audit(AuditHelper.java:83) at org.pentaho.platform.engine.core.system.BaseSession.<init>(BaseSession.java:59) at org.pentaho.platform.engine.core.system.StandaloneSession.<init>(StandaloneSession.java:57) at org.pentaho.platform.engine.core.system.StandaloneSession.<init>(StandaloneSession.java:53) at org.pentaho.platform.engine.core.system.StandaloneSession.<init>(StandaloneSession.java:49) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:313) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:246) at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:131) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022) at org.apache.catalina.core.StandardHost.start(StandardHost.java:736) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:448) at org.apache.catalina.core.StandardServer.start(StandardServer.java:700) at org.apache.catalina.startup.Catalina.start(Catalina.java:552) 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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433) Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Can't call rollback when autocommit=true at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:888) at com.mysql.jdbc.Connection.rollback(Connection.java:5257) at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:288) at org.pentaho.platform.engine.services.audit.AuditSQLEntry.auditAll(AuditSQLEntry.java:114) ... 34 more 09:39:36,000 ERROR [Logger] Error end: Pentaho BI Platform server is ready. (Pentaho Platform Engine Core 2.0.0-SNAPSHOT.development) Base Url = http://localhost:8080/pentaho/, Solution Path = C:\Pentaho\dry-runs\biserver-ee\pentaho-solutions Oct 20, 2008 9:40:01 AM org.apache.coyote.http11.Http11BaseProtocol start INFO: Starting Coyote HTTP/1.1 on http-8080 Oct 20, 2008 9:40:01 AM org.apache.jk.common.ChannelSocket init INFO: JK: ajp13 listening on /0.0.0.0:8009 Oct 20, 2008 9:40:01 AM org.apache.jk.server.JkMain start INFO: Jk running ID=0 time=0/16 config=null Oct 20, 2008 9:40:01 AM org.apache.catalina.storeconfig.StoreLoader load INFO: Find registry server-registry.xml at classpath resource Oct 20, 2008 9:40:01 AM org.apache.catalina.startup.Catalina start INFO: Server startup in 32656 ms

    Pentaho BI Platform Tracking | 8 years ago | Golda David
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'hibernate.pro_audit' doesn't exist
  2. 0

    Got the following error when I run the SQL script after dropping the already existing one for Hibernate and Quartz. (CE-473 and EE-453 from the Ci build Creating Hibernate Repository... ERROR 1146 (42S02) at line 13: Table 'hibernate.pro_schedule' doesn't exist After this started the PCI got the following error 09:39:35,937 ERROR [Logger] Error: Pentaho 09:39:35,937 ERROR [Logger] misc-org.pentaho.platform.engine.services.audit.AuditSQLEntry: Table 'hibernate.pro_audit' doesn't exist com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'hibernate.pro_audit' doesn't exist at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) at org.pentaho.platform.engine.services.audit.AuditSQLEntry.auditAll(AuditSQLEntry.java:110) at org.pentaho.platform.engine.core.audit.AuditEntry.auditAll(AuditEntry.java:58) at org.pentaho.platform.engine.core.audit.AuditEntry.auditJobDuration(AuditEntry.java:47) at org.pentaho.platform.engine.core.audit.AuditHelper.audit(AuditHelper.java:83) at org.pentaho.platform.engine.core.system.BaseSession.<init>(BaseSession.java:59) at org.pentaho.platform.engine.core.system.StandaloneSession.<init>(StandaloneSession.java:57) at org.pentaho.platform.engine.core.system.StandaloneSession.<init>(StandaloneSession.java:53) at org.pentaho.platform.engine.core.system.StandaloneSession.<init>(StandaloneSession.java:49) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:313) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:246) at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:131) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022) at org.apache.catalina.core.StandardHost.start(StandardHost.java:736) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:448) at org.apache.catalina.core.StandardServer.start(StandardServer.java:700) at org.apache.catalina.startup.Catalina.start(Catalina.java:552) 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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433) 09:39:35,968 ERROR [Logger] Error end: 09:39:35,968 ERROR [Logger] Error: Pentaho 09:39:35,968 ERROR [Logger] misc-org.pentaho.platform.engine.core.audit.AuditHelper: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Can't call rollback when autocommit=true org.pentaho.platform.api.engine.AuditException: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Can't call rollback when autocommit=true at org.pentaho.platform.engine.services.audit.AuditSQLEntry.auditAll(AuditSQLEntry.java:116) at org.pentaho.platform.engine.core.audit.AuditEntry.auditAll(AuditEntry.java:58) at org.pentaho.platform.engine.core.audit.AuditEntry.auditJobDuration(AuditEntry.java:47) at org.pentaho.platform.engine.core.audit.AuditHelper.audit(AuditHelper.java:83) at org.pentaho.platform.engine.core.system.BaseSession.<init>(BaseSession.java:59) at org.pentaho.platform.engine.core.system.StandaloneSession.<init>(StandaloneSession.java:57) at org.pentaho.platform.engine.core.system.StandaloneSession.<init>(StandaloneSession.java:53) at org.pentaho.platform.engine.core.system.StandaloneSession.<init>(StandaloneSession.java:49) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:313) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:246) at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:131) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022) at org.apache.catalina.core.StandardHost.start(StandardHost.java:736) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:448) at org.apache.catalina.core.StandardServer.start(StandardServer.java:700) at org.apache.catalina.startup.Catalina.start(Catalina.java:552) 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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433) Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Can't call rollback when autocommit=true at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:888) at com.mysql.jdbc.Connection.rollback(Connection.java:5257) at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:288) at org.pentaho.platform.engine.services.audit.AuditSQLEntry.auditAll(AuditSQLEntry.java:114) ... 34 more 09:39:36,000 ERROR [Logger] Error end: Pentaho BI Platform server is ready. (Pentaho Platform Engine Core 2.0.0-SNAPSHOT.development) Base Url = http://localhost:8080/pentaho/, Solution Path = C:\Pentaho\dry-runs\biserver-ee\pentaho-solutions Oct 20, 2008 9:40:01 AM org.apache.coyote.http11.Http11BaseProtocol start INFO: Starting Coyote HTTP/1.1 on http-8080 Oct 20, 2008 9:40:01 AM org.apache.jk.common.ChannelSocket init INFO: JK: ajp13 listening on /0.0.0.0:8009 Oct 20, 2008 9:40:01 AM org.apache.jk.server.JkMain start INFO: Jk running ID=0 time=0/16 config=null Oct 20, 2008 9:40:01 AM org.apache.catalina.storeconfig.StoreLoader load INFO: Find registry server-registry.xml at classpath resource Oct 20, 2008 9:40:01 AM org.apache.catalina.startup.Catalina start INFO: Server startup in 32656 ms

    Pentaho BI Platform Tracking | 8 years ago | Golda David
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'hibernate.pro_audit' doesn't exist
  3. 0

    Currently, a StandaloneSession is created during PentahoSystem.init() which in turn calls into BaseSession constructor which calls AuditHelper. When using MySQL, and possibly other databases, the AuditHelper will attempt an SQL INSERT into a table that does not yet exist. (That table is created later as part of HibernateUtil's initialization.) Per Marc, create a SystemStartupSession that subclasses StandaloneSession and does no audit logging. Have PentahoSystem.init() use the new SystemStartupSession. In addition, move audit logging calls out of BaseSession constructor and destroy methods, into the concrete classes that need the audit calls--that would be all but SystemStartupSession. Here's an example of a stack trace that you would get on the first startup of the platform running against MySQL: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'hibernate.pro_audit' doesn't exist at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) at org.pentaho.platform.engine.services.audit.AuditSQLEntry.auditAll(AuditSQLEntry.java:110) at org.pentaho.platform.engine.core.audit.AuditEntry.auditAll(AuditEntry.java:58) at org.pentaho.platform.engine.core.audit.AuditEntry.auditJobDuration(AuditEntry.java:47) at org.pentaho.platform.engine.core.audit.AuditHelper.audit(AuditHelper.java:83) at org.pentaho.platform.engine.core.system.BaseSession.<init>(BaseSession.java:59) at org.pentaho.platform.engine.core.system.StandaloneSession.<init>(StandaloneSession.java:57) at org.pentaho.platform.engine.core.system.StandaloneSession.<init>(StandaloneSession.java:53) at org.pentaho.platform.engine.core.system.StandaloneSession.<init>(StandaloneSession.java:49) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:313) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:246) at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:131)

    Pentaho BI Platform Tracking | 8 years ago | Mat Lowery
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'hibernate.pro_audit' doesn't exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Currently, a StandaloneSession is created during PentahoSystem.init() which in turn calls into BaseSession constructor which calls AuditHelper. When using MySQL, and possibly other databases, the AuditHelper will attempt an SQL INSERT into a table that does not yet exist. (That table is created later as part of HibernateUtil's initialization.) Per Marc, create a SystemStartupSession that subclasses StandaloneSession and does no audit logging. Have PentahoSystem.init() use the new SystemStartupSession. In addition, move audit logging calls out of BaseSession constructor and destroy methods, into the concrete classes that need the audit calls--that would be all but SystemStartupSession. Here's an example of a stack trace that you would get on the first startup of the platform running against MySQL: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'hibernate.pro_audit' doesn't exist at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) at org.pentaho.platform.engine.services.audit.AuditSQLEntry.auditAll(AuditSQLEntry.java:110) at org.pentaho.platform.engine.core.audit.AuditEntry.auditAll(AuditEntry.java:58) at org.pentaho.platform.engine.core.audit.AuditEntry.auditJobDuration(AuditEntry.java:47) at org.pentaho.platform.engine.core.audit.AuditHelper.audit(AuditHelper.java:83) at org.pentaho.platform.engine.core.system.BaseSession.<init>(BaseSession.java:59) at org.pentaho.platform.engine.core.system.StandaloneSession.<init>(StandaloneSession.java:57) at org.pentaho.platform.engine.core.system.StandaloneSession.<init>(StandaloneSession.java:53) at org.pentaho.platform.engine.core.system.StandaloneSession.<init>(StandaloneSession.java:49) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:313) at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:246) at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:131)

    Pentaho BI Platform Tracking | 8 years ago | Mat Lowery
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'hibernate.pro_audit' doesn't exist
  6. 0

    Inadequate MySQL version (5.0.67)?

    symmetricds | 4 years ago | chenson42
    org.jumpmind.db.sql.SqlException: Unknown table 'SESSION_STATUS' in information_schema

    1 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.MySQLSyntaxErrorException

      Table 'hibernate.pro_audit' doesn't exist

      at com.mysql.jdbc.SQLError.createSQLException()
    2. MySQL jdbc
      PreparedStatement.executeUpdate
      1. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
      2. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
      3. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
      4. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
      5. com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
      6. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
      7. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604)
      8. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519)
      9. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504)
      9 frames
    3. Commons DBCP
      DelegatingPreparedStatement.executeUpdate
      1. org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
      1 frame
    4. org.pentaho.platform
      SolutionContextListener.contextInitialized
      1. org.pentaho.platform.engine.services.audit.AuditSQLEntry.auditAll(AuditSQLEntry.java:110)
      2. org.pentaho.platform.engine.core.audit.AuditEntry.auditAll(AuditEntry.java:58)
      3. org.pentaho.platform.engine.core.audit.AuditEntry.auditJobDuration(AuditEntry.java:47)
      4. org.pentaho.platform.engine.core.audit.AuditHelper.audit(AuditHelper.java:83)
      5. org.pentaho.platform.engine.core.system.BaseSession.<init>(BaseSession.java:59)
      6. org.pentaho.platform.engine.core.system.StandaloneSession.<init>(StandaloneSession.java:57)
      7. org.pentaho.platform.engine.core.system.StandaloneSession.<init>(StandaloneSession.java:53)
      8. org.pentaho.platform.engine.core.system.StandaloneSession.<init>(StandaloneSession.java:49)
      9. org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:313)
      10. org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:246)
      11. org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:131)
      11 frames
    5. Glassfish Core
      Catalina.start
      1. org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
      2. org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
      3. org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
      4. org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
      5. org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
      6. org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926)
      7. org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889)
      8. org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
      9. org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
      10. org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
      11. org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
      12. org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
      13. org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
      14. org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
      15. org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
      16. org.apache.catalina.core.StandardService.start(StandardService.java:448)
      17. org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
      18. org.apache.catalina.startup.Catalina.start(Catalina.java:552)
      18 frames
    6. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames
    7. Glassfish Core
      Bootstrap.main
      1. org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
      2. org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
      2 frames