1 Reply Latest reply on Aug 29, 2014 10:43 AM by Kris Verlaenen

    Error while starting server and starting Process Definition from KIE

    Pavan Kumar Mantha Newbie

      Hi All,

      I have recently downloaded jbpm6.0 and integrated with MySql, but when i start JBoss Server 7.1 i get the below errors in server console.

       

      17:50:39,607 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (MSC service thread 1-8) HHH000299: Could not complete schema update: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'sequences' in information_schema

          at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [rt.jar:1.7.0_05]

          at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) [rt.jar:1.7.0_05]

          at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [rt.jar:1.7.0_05]

          at java.lang.reflect.Constructor.newInstance(Constructor.java:525) [rt.jar:1.7.0_05]

          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:1052)

          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)

          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)

          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:2619)

          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2569)

          at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1521)

          at org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:340)

          at org.hibernate.tool.hbm2ddl.DatabaseMetadata.initSequences(DatabaseMetadata.java:149) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:70) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:63) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:196) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:178) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:457) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1737) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:84) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:904) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:889) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]

          at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:73) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]

          at org.jboss.as.jpa.service.PersistenceUnitServiceImpl.createContainerEntityManagerFactory(PersistenceUnitServiceImpl.java:162) [jboss-as-jpa-7.1.1.Final.jar:7.1.1.Final]

          at org.jboss.as.jpa.service.PersistenceUnitServiceImpl.start(PersistenceUnitServiceImpl.java:85) [jboss-as-jpa-7.1.1.Final.jar:7.1.1.Final]

          at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811)

          at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746)

          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [rt.jar:1.7.0_05]

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.7.0_05]

          at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_05]

       

      also below is the error when i start the process definition or process instance.

       

      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'taskimpl0_.id' in 'field list'

          at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [rt.jar:1.7.0_05]

          at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) [rt.jar:1.7.0_05]

          at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [rt.jar:1.7.0_05]

          at java.lang.reflect.Constructor.newInstance(Constructor.java:525) [rt.jar:1.7.0_05]

          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:1052)

          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)

          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)

          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.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)

          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_05]

          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_05]

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_05]

          at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_05]

          at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

          ... 107 more

       

       

      Please find the detailed Server.log attached.


      Thanks

      Pavan Kumar Mantha