Csaba K
2013-03-14 11:41:35 UTC
Csaba K [https://community.jboss.org/people/chabee] created the discussion
"MySQL database connection error"
To view the discussion, visit: https://community.jboss.org/message/802643#802643
--------------------------------------------------------------
*Hy all!*
*I am trying to change H2 database to MySQL database. I installed a MySQL server and went through http://docs.jboss.com/jbpm/v5.4/userguide/ch.installer.html#d0e609 http://docs.jboss.com/jbpm/v5.4/userguide/ch.installer.html#d0e609 on this description. I started jboss AS7 and MySQL server also, I opened http://localhost:8080/jbpm-console/ http://localhost:8080/jbpm-console/.*
*After I logged in I got this error:*
2013-03-14 12:21:41,711 [DEBUG] new subscription: appContext.model.listener -> org.jboss.bpm.console.client.task.AssignedTasksView$***@119
2013-03-14 12:21:41,713 [DEBUG] New Subscription: appContext.model.listener
2013-03-14 12:21:42,221 [DEBUG] GET: http://localhost:8080/gwt-console-server/rs/tasks/admin http://localhost:8080/gwt-console-server/rs/tasks/admin
2013-03-14 12:21:53,134 [ERROR] <ul><li>URL: ' http://localhost:8080/gwt-console-server/rs/tasks/admin http://localhost:8080/gwt-console-server/rs/tasks/admin'
<li>Action: 'org.jboss.bpm.console.client.task.LoadTasksAction'
<li>Exception: 'class com.google.gwt.http.client.RequestException'</ul>
HTTP 500: <html><head><title>JBoss Web/7.0.13.Final - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 500 - </h1><HR size="1" noshade="noshade"><p><b>type</b> Exception report</p><p><b>message</b> <u></u></p><p><b>description</b> <u>The server encountered an internal error () that prevented it from fulfilling this request.</u></p><p><b>exception</b> <pre>org.jboss.resteasy.spi.UnhandledException: java.lang.RuntimeException: Session was not initialized, check previous errors in log
org.jboss.resteasy.core.SynchronousDispatcher.handleApplicationException(SynchronousDispatcher.java:340)
org.jboss.resteasy.core.SynchronousDispatcher.handleException(SynchronousDispatcher.java:214)
org.jboss.resteasy.core.SynchronousDispatcher.handleInvokerException(SynchronousDispatcher.java:190)
org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:540)
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:502)
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)
org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)
</pre></p><p><b>root cause</b> <pre>java.lang.RuntimeException: Session was not initialized, check previous errors in log
org.jbpm.integration.console.StatefulKnowledgeSessionUtil.getStatefulKnowledgeSession(StatefulKnowledgeSessionUtil.java:89)
org.jbpm.integration.console.SessionInitializer.<init>(SessionInitializer.java:25)
org.jbpm.integration.console.TaskManagement.<init>(TaskManagement.java:52)
org.jbpm.integration.console.ManagementFactory.createTaskManagement(ManagementFactory.java:26)
org.jbpm.integration.console.ManagementFactory.createTaskManagement(ManagementFactory.java:19)
org.jboss.bpm.console.server.TaskListFacade.getTaskManagement(TaskListFacade.java:72)
org.jboss.bpm.console.server.TaskListFacade.getTasksForIdRef(TaskListFacade.java:101)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:616)
org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:155)
org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:257)
org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:222)
org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:211)
org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:525)
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:502)
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)
org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)
</pre></p><p><b>note</b> <u>The full stack trace of the root cause is available in the JBoss Web/7.0.13.Final logs.</u></p><HR size="1" noshade="noshade"><h3>JBoss Web/7.0.13.Final</h3></body></html>
com.google.gwt.http.client.RequestException:
*HTTP 500:Â *
h1. *HTTP Status 500 -*
----
*type* Exception report
*message*
*description* The server encountered an internal error () that prevented it from fulfilling this request.
*exception*
*org.jboss.resteasy.spi.UnhandledException: java.lang.RuntimeException: Session was not initialized, check previous errors in log
     org.jboss.resteasy.core.SynchronousDispatcher.handleApplicationException(SynchronousDispatcher.java:340)
     org.jboss.resteasy.core.SynchronousDispatcher.handleException(SynchronousDispatcher.java:214)
     org.jboss.resteasy.core.SynchronousDispatcher.handleInvokerException(SynchronousDispatcher.java:190)
     org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:540)
     org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:502)
     org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)
     org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
     org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
     org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
     javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
     org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)
*
*root cause*
*java.lang.RuntimeException: Session was not initialized, check previous errors in log
     org.jbpm.integration.console.StatefulKnowledgeSessionUtil.getStatefulKnowledgeSession(StatefulKnowledgeSessionUtil.java:89)
     org.jbpm.integration.console.SessionInitializer.<init>(SessionInitializer.java:25)
     org.jbpm.integration.console.TaskManagement.<init>(TaskManagement.java:52)
     org.jbpm.integration.console.ManagementFactory.createTaskManagement(ManagementFactory.java:26)
     org.jbpm.integration.console.ManagementFactory.createTaskManagement(ManagementFactory.java:19)
     org.jboss.bpm.console.server.TaskListFacade.getTaskManagement(TaskListFacade.java:72)
     org.jboss.bpm.console.server.TaskListFacade.getTasksForIdRef(TaskListFacade.java:101)
     sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
     sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     java.lang.reflect.Method.invoke(Method.java:616)
     org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:155)
     org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:257)
     org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:222)
     org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:211)
     org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:525)
     org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:502)
     org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)
     org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
     org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
     org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
     javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
     org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)
*
*note* The full stack trace of the root cause is available in the JBoss Web/7.0.13.Final logs.
----
h3. *JBoss Web/7.0.13.Final*
   at Unknown.$fillInStackTrace_1(JsArrayString.java:42)
   at Unknown.$RequestException(StackTraceCreator.java:366)
   at Unknown.onResponseReceived_5(AbstractRESTAction.java:93)
   at Unknown.$fireOnResponseReceived(Request.java:287)
   at Unknown.onReadyStateChange_0(RequestBuilder.java:393)
   at Unknown.anonymous(XMLHttpRequest.java:258)
   at Unknown.entry0(Impl.java:146)
   at Unknown.anonymous(Impl.java:56)
*As I've seen the error log there are two kind of exceptions:*
*First:*
2:15:13,030 ERROR [org.reflections.Reflections] (MSC service thread 1-2) could not create Vfs.Dir from url. ignoring the exception and continuing: org.reflections.ReflectionsException: could not create Dir using org.jboss.errai.bus.server.service.metadata.VFSUrlType from url vfs:/content/jbpm-gwt-console.war/WEB-INF/classes/
   at org.reflections.vfs.Vfs.fromURL(Vfs.java:99) [reflections-0.9.5-RC2_jboss-SP1.jar:]
   at org.reflections.vfs.Vfs.fromURL(Vfs.java:89) [reflections-0.9.5-RC2_jboss-SP1.jar:]
   at org.reflections.Reflections.scan(Reflections.java:136) [reflections-0.9.5-RC2_jboss-SP1.jar:]
   at org.jboss.errai.bus.server.service.metadata.MetaDataScanner.<init>(MetaDataScanner.java:83) [errai-bus-1.1-Final.jar:1.1-Final]
   at org.jboss.errai.bus.server.service.metadata.MetaDataScanner.createInstance(MetaDataScanner.java:95) [errai-bus-1.1-Final.jar:1.1-Final]
   at org.jboss.errai.bus.server.service.metadata.MetaDataScanner.createInstance(MetaDataScanner.java:87) [errai-bus-1.1-Final.jar:1.1-Final]
   at org.jboss.errai.bus.server.service.ErraiServiceConfiguratorImpl.<init>(ErraiServiceConfiguratorImpl.java:58) [errai-bus-1.1-Final.jar:1.1-Final]
   at org.jboss.errai.bus.server.service.ErraiServiceConfiguratorImpl$$FastClassByGuice$$b6139751.newInstance(<generated>)
   at com.google.inject.internal.cglib.reflect.FastConstructor.newInstance(FastConstructor.java:40) [guice-2.0.jar:]
   at com.google.inject.DefaultConstructionProxyFactory$1.newInstance(DefaultConstructionProxyFactory.java:60) [guice-2.0.jar:]
   at com.google.inject.ConstructorInjector.construct(ConstructorInjector.java:85) [guice-2.0.jar:]
   at com.google.inject.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:111) [guice-2.0.jar:]
   at com.google.inject.FactoryProxy.get(FactoryProxy.java:56) [guice-2.0.jar:]
   at com.google.inject.SingleParameterInjector.inject(SingleParameterInjector.java:42) [guice-2.0.jar:]
   at com.google.inject.SingleParameterInjector.getAll(SingleParameterInjector.java:66) [guice-2.0.jar:]
   at com.google.inject.ConstructorInjector.construct(ConstructorInjector.java:84) [guice-2.0.jar:]
   at com.google.inject.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:111) [guice-2.0.jar:]
   at com.google.inject.ProviderToInternalFactoryAdapter$1.call(ProviderToInternalFactoryAdapter.java:45) [guice-2.0.jar:]
   at com.google.inject.InjectorImpl.callInContext(InjectorImpl.java:811) [guice-2.0.jar:]
   at com.google.inject.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:42) [guice-2.0.jar:]
   at com.google.inject.Scopes$1$1.get(Scopes.java:54) [guice-2.0.jar:]
   at com.google.inject.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:48) [guice-2.0.jar:]
   at com.google.inject.FactoryProxy.get(FactoryProxy.java:56) [guice-2.0.jar:]
   at com.google.inject.InjectorImpl$4$1.call(InjectorImpl.java:758) [guice-2.0.jar:]
   at com.google.inject.InjectorImpl.callInContext(InjectorImpl.java:804) [guice-2.0.jar:]
   at com.google.inject.InjectorImpl$4.get(InjectorImpl.java:754) [guice-2.0.jar:]
   at com.google.inject.InjectorImpl.getInstance(InjectorImpl.java:793) [guice-2.0.jar:]
   at org.jboss.errai.bus.server.servlet.AbstractErraiServlet.buildService(AbstractErraiServlet.java:133) [errai-bus-1.1-Final.jar:1.1-Final]
   at org.jboss.errai.bus.server.servlet.AbstractErraiServlet.init(AbstractErraiServlet.java:104) [errai-bus-1.1-Final.jar:1.1-Final]
   at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1202) [jbossweb-7.0.13.Final.jar:]
   at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1102) [jbossweb-7.0.13.Final.jar:]
   at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3655) [jbossweb-7.0.13.Final.jar:]
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:3873) [jbossweb-7.0.13.Final.jar:]
   at org.jboss.as.web.deployment.WebDeploymentService.start(WebDeploymentService.java:90) [jboss-as-web-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.6.0_24]
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.6.0_24]
   at java.lang.Thread.run(Thread.java:679) [rt.jar:1.6.0_24]
*And the second is a MySQL exception, there a lots of tables missings like:*
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'sequences' in information_schema
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [rt.jar:1.6.0_24]
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) [rt.jar:1.6.0_24]
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [rt.jar:1.6.0_24]
   at java.lang.reflect.Constructor.newInstance(Constructor.java:532) [rt.jar:1.6.0_24]
   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:3609)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
   at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1557)
   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.6.0_24]
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.6.0_24]
   at java.lang.Thread.run(Thread.java:679) [rt.jar:1.6.0_24]
*My questions are:*
*Should I create the MySQL DB schema (I thin I should), and if I should where can I find an SQL script for this?*
*The first error also caused by the DB error?*
Thanks for your help!
Best Regards,
Csaba
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/802643#802643]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]
"MySQL database connection error"
To view the discussion, visit: https://community.jboss.org/message/802643#802643
--------------------------------------------------------------
*Hy all!*
*I am trying to change H2 database to MySQL database. I installed a MySQL server and went through http://docs.jboss.com/jbpm/v5.4/userguide/ch.installer.html#d0e609 http://docs.jboss.com/jbpm/v5.4/userguide/ch.installer.html#d0e609 on this description. I started jboss AS7 and MySQL server also, I opened http://localhost:8080/jbpm-console/ http://localhost:8080/jbpm-console/.*
*After I logged in I got this error:*
2013-03-14 12:21:41,711 [DEBUG] new subscription: appContext.model.listener -> org.jboss.bpm.console.client.task.AssignedTasksView$***@119
2013-03-14 12:21:41,713 [DEBUG] New Subscription: appContext.model.listener
2013-03-14 12:21:42,221 [DEBUG] GET: http://localhost:8080/gwt-console-server/rs/tasks/admin http://localhost:8080/gwt-console-server/rs/tasks/admin
2013-03-14 12:21:53,134 [ERROR] <ul><li>URL: ' http://localhost:8080/gwt-console-server/rs/tasks/admin http://localhost:8080/gwt-console-server/rs/tasks/admin'
<li>Action: 'org.jboss.bpm.console.client.task.LoadTasksAction'
<li>Exception: 'class com.google.gwt.http.client.RequestException'</ul>
HTTP 500: <html><head><title>JBoss Web/7.0.13.Final - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 500 - </h1><HR size="1" noshade="noshade"><p><b>type</b> Exception report</p><p><b>message</b> <u></u></p><p><b>description</b> <u>The server encountered an internal error () that prevented it from fulfilling this request.</u></p><p><b>exception</b> <pre>org.jboss.resteasy.spi.UnhandledException: java.lang.RuntimeException: Session was not initialized, check previous errors in log
org.jboss.resteasy.core.SynchronousDispatcher.handleApplicationException(SynchronousDispatcher.java:340)
org.jboss.resteasy.core.SynchronousDispatcher.handleException(SynchronousDispatcher.java:214)
org.jboss.resteasy.core.SynchronousDispatcher.handleInvokerException(SynchronousDispatcher.java:190)
org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:540)
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:502)
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)
org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)
</pre></p><p><b>root cause</b> <pre>java.lang.RuntimeException: Session was not initialized, check previous errors in log
org.jbpm.integration.console.StatefulKnowledgeSessionUtil.getStatefulKnowledgeSession(StatefulKnowledgeSessionUtil.java:89)
org.jbpm.integration.console.SessionInitializer.<init>(SessionInitializer.java:25)
org.jbpm.integration.console.TaskManagement.<init>(TaskManagement.java:52)
org.jbpm.integration.console.ManagementFactory.createTaskManagement(ManagementFactory.java:26)
org.jbpm.integration.console.ManagementFactory.createTaskManagement(ManagementFactory.java:19)
org.jboss.bpm.console.server.TaskListFacade.getTaskManagement(TaskListFacade.java:72)
org.jboss.bpm.console.server.TaskListFacade.getTasksForIdRef(TaskListFacade.java:101)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:616)
org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:155)
org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:257)
org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:222)
org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:211)
org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:525)
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:502)
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)
org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)
</pre></p><p><b>note</b> <u>The full stack trace of the root cause is available in the JBoss Web/7.0.13.Final logs.</u></p><HR size="1" noshade="noshade"><h3>JBoss Web/7.0.13.Final</h3></body></html>
com.google.gwt.http.client.RequestException:
*HTTP 500:Â *
h1. *HTTP Status 500 -*
----
*type* Exception report
*message*
*description* The server encountered an internal error () that prevented it from fulfilling this request.
*exception*
*org.jboss.resteasy.spi.UnhandledException: java.lang.RuntimeException: Session was not initialized, check previous errors in log
     org.jboss.resteasy.core.SynchronousDispatcher.handleApplicationException(SynchronousDispatcher.java:340)
     org.jboss.resteasy.core.SynchronousDispatcher.handleException(SynchronousDispatcher.java:214)
     org.jboss.resteasy.core.SynchronousDispatcher.handleInvokerException(SynchronousDispatcher.java:190)
     org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:540)
     org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:502)
     org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)
     org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
     org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
     org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
     javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
     org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)
*
*root cause*
*java.lang.RuntimeException: Session was not initialized, check previous errors in log
     org.jbpm.integration.console.StatefulKnowledgeSessionUtil.getStatefulKnowledgeSession(StatefulKnowledgeSessionUtil.java:89)
     org.jbpm.integration.console.SessionInitializer.<init>(SessionInitializer.java:25)
     org.jbpm.integration.console.TaskManagement.<init>(TaskManagement.java:52)
     org.jbpm.integration.console.ManagementFactory.createTaskManagement(ManagementFactory.java:26)
     org.jbpm.integration.console.ManagementFactory.createTaskManagement(ManagementFactory.java:19)
     org.jboss.bpm.console.server.TaskListFacade.getTaskManagement(TaskListFacade.java:72)
     org.jboss.bpm.console.server.TaskListFacade.getTasksForIdRef(TaskListFacade.java:101)
     sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
     sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     java.lang.reflect.Method.invoke(Method.java:616)
     org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:155)
     org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:257)
     org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:222)
     org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:211)
     org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:525)
     org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:502)
     org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)
     org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
     org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
     org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
     javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
     org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)
*
*note* The full stack trace of the root cause is available in the JBoss Web/7.0.13.Final logs.
----
h3. *JBoss Web/7.0.13.Final*
   at Unknown.$fillInStackTrace_1(JsArrayString.java:42)
   at Unknown.$RequestException(StackTraceCreator.java:366)
   at Unknown.onResponseReceived_5(AbstractRESTAction.java:93)
   at Unknown.$fireOnResponseReceived(Request.java:287)
   at Unknown.onReadyStateChange_0(RequestBuilder.java:393)
   at Unknown.anonymous(XMLHttpRequest.java:258)
   at Unknown.entry0(Impl.java:146)
   at Unknown.anonymous(Impl.java:56)
*As I've seen the error log there are two kind of exceptions:*
*First:*
2:15:13,030 ERROR [org.reflections.Reflections] (MSC service thread 1-2) could not create Vfs.Dir from url. ignoring the exception and continuing: org.reflections.ReflectionsException: could not create Dir using org.jboss.errai.bus.server.service.metadata.VFSUrlType from url vfs:/content/jbpm-gwt-console.war/WEB-INF/classes/
   at org.reflections.vfs.Vfs.fromURL(Vfs.java:99) [reflections-0.9.5-RC2_jboss-SP1.jar:]
   at org.reflections.vfs.Vfs.fromURL(Vfs.java:89) [reflections-0.9.5-RC2_jboss-SP1.jar:]
   at org.reflections.Reflections.scan(Reflections.java:136) [reflections-0.9.5-RC2_jboss-SP1.jar:]
   at org.jboss.errai.bus.server.service.metadata.MetaDataScanner.<init>(MetaDataScanner.java:83) [errai-bus-1.1-Final.jar:1.1-Final]
   at org.jboss.errai.bus.server.service.metadata.MetaDataScanner.createInstance(MetaDataScanner.java:95) [errai-bus-1.1-Final.jar:1.1-Final]
   at org.jboss.errai.bus.server.service.metadata.MetaDataScanner.createInstance(MetaDataScanner.java:87) [errai-bus-1.1-Final.jar:1.1-Final]
   at org.jboss.errai.bus.server.service.ErraiServiceConfiguratorImpl.<init>(ErraiServiceConfiguratorImpl.java:58) [errai-bus-1.1-Final.jar:1.1-Final]
   at org.jboss.errai.bus.server.service.ErraiServiceConfiguratorImpl$$FastClassByGuice$$b6139751.newInstance(<generated>)
   at com.google.inject.internal.cglib.reflect.FastConstructor.newInstance(FastConstructor.java:40) [guice-2.0.jar:]
   at com.google.inject.DefaultConstructionProxyFactory$1.newInstance(DefaultConstructionProxyFactory.java:60) [guice-2.0.jar:]
   at com.google.inject.ConstructorInjector.construct(ConstructorInjector.java:85) [guice-2.0.jar:]
   at com.google.inject.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:111) [guice-2.0.jar:]
   at com.google.inject.FactoryProxy.get(FactoryProxy.java:56) [guice-2.0.jar:]
   at com.google.inject.SingleParameterInjector.inject(SingleParameterInjector.java:42) [guice-2.0.jar:]
   at com.google.inject.SingleParameterInjector.getAll(SingleParameterInjector.java:66) [guice-2.0.jar:]
   at com.google.inject.ConstructorInjector.construct(ConstructorInjector.java:84) [guice-2.0.jar:]
   at com.google.inject.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:111) [guice-2.0.jar:]
   at com.google.inject.ProviderToInternalFactoryAdapter$1.call(ProviderToInternalFactoryAdapter.java:45) [guice-2.0.jar:]
   at com.google.inject.InjectorImpl.callInContext(InjectorImpl.java:811) [guice-2.0.jar:]
   at com.google.inject.ProviderToInternalFactoryAdapter.get(ProviderToInternalFactoryAdapter.java:42) [guice-2.0.jar:]
   at com.google.inject.Scopes$1$1.get(Scopes.java:54) [guice-2.0.jar:]
   at com.google.inject.InternalFactoryToProviderAdapter.get(InternalFactoryToProviderAdapter.java:48) [guice-2.0.jar:]
   at com.google.inject.FactoryProxy.get(FactoryProxy.java:56) [guice-2.0.jar:]
   at com.google.inject.InjectorImpl$4$1.call(InjectorImpl.java:758) [guice-2.0.jar:]
   at com.google.inject.InjectorImpl.callInContext(InjectorImpl.java:804) [guice-2.0.jar:]
   at com.google.inject.InjectorImpl$4.get(InjectorImpl.java:754) [guice-2.0.jar:]
   at com.google.inject.InjectorImpl.getInstance(InjectorImpl.java:793) [guice-2.0.jar:]
   at org.jboss.errai.bus.server.servlet.AbstractErraiServlet.buildService(AbstractErraiServlet.java:133) [errai-bus-1.1-Final.jar:1.1-Final]
   at org.jboss.errai.bus.server.servlet.AbstractErraiServlet.init(AbstractErraiServlet.java:104) [errai-bus-1.1-Final.jar:1.1-Final]
   at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1202) [jbossweb-7.0.13.Final.jar:]
   at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1102) [jbossweb-7.0.13.Final.jar:]
   at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3655) [jbossweb-7.0.13.Final.jar:]
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:3873) [jbossweb-7.0.13.Final.jar:]
   at org.jboss.as.web.deployment.WebDeploymentService.start(WebDeploymentService.java:90) [jboss-as-web-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.6.0_24]
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.6.0_24]
   at java.lang.Thread.run(Thread.java:679) [rt.jar:1.6.0_24]
*And the second is a MySQL exception, there a lots of tables missings like:*
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'sequences' in information_schema
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [rt.jar:1.6.0_24]
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) [rt.jar:1.6.0_24]
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [rt.jar:1.6.0_24]
   at java.lang.reflect.Constructor.newInstance(Constructor.java:532) [rt.jar:1.6.0_24]
   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:3609)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
   at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1557)
   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.6.0_24]
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.6.0_24]
   at java.lang.Thread.run(Thread.java:679) [rt.jar:1.6.0_24]
*My questions are:*
*Should I create the MySQL DB schema (I thin I should), and if I should where can I find an SQL script for this?*
*The first error also caused by the DB error?*
Thanks for your help!
Best Regards,
Csaba
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/802643#802643]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]