[jBPM] - Re: Problem in deploying Process from guvnor to JBPM Console
by Guido Zerbinati
Guido Zerbinati [https://community.jboss.org/people/gzer] created the discussion
"Re: Problem in deploying Process from guvnor to JBPM Console"
To view the discussion, visit: https://community.jboss.org/message/736831#736831
--------------------------------------------------------------
Yes, I've seen. I've downloaded (hopefully ;-)) all the newest release (JBPM, Guvnor, etc) and the newest jbpmistaller project from GITHUB; found all the libraries and reinstall everything. Now jpbm console is version 2.3.2 SNAPSHOT, Drools is 5.4 and so on... Seems that all is working well... designing flows on guvnor and packaging them make them appears on jbpm console... Have to say that it'has been a a little too much difficult but I think I'm getting through it. So by now I can start seeing JBPM in action. By the way if someone wants the full ZIP package to install the demo with the latest version of all this stuff I can provide it (it's huge so you have to give me some kind of FTP access or so on)...
Thanks for support... Hope that now I can start doing more interesting questions..... ;-)!!!!
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/736831#736831]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&con...]
12 years, 4 months
[jBPM] - Re: Loading processInstance/session via JPA, workItem executes before able to register workItems
by Marcus Portmann
Marcus Portmann [https://community.jboss.org/people/marcusportmann] created the discussion
"Re: Loading processInstance/session via JPA, workItem executes before able to register workItems"
To view the discussion, visit: https://community.jboss.org/message/736669#736669
--------------------------------------------------------------
Hi Ryan,
I encountered the same problem but am still working on finding a solution.
I believe that the problem is a result of a race condition where when a persistent knowledge session is unmarshalled as part of the call-chain for *JPAKnowledgeService.loadStatefulKnowledgeSession(...)* the "timer job" infrastructure is initialised and any pending "timer jobs" are immediatelly executed before the knowledge session is completely initialised. In my case what happens is that a TimerJobInstance executes before the following line is executed in the *initKsession* method for the *SingleSessionCommandService* class so the CommandService for my *TimerJobFactoryManager* instance is still null.
((AcceptsTimerJobFactoryManager) ((InternalKnowledgeRuntime) ksession).getTimerService()).getTimerJobFactoryManager().setCommandService( this );
The issue seems to be that timer job instances should not executed until the knowledge session is completely initialised. This initialisation should include things like registering the work item handlers which should solve your problem.
I believe that the knowledge session itself needs some sort of "resume" method so that it can be instructed when to resume once it has been completely initialised. This "resume" method would kick-off any timer jobs. Unfortunately I am not familiar enough with the Drools/JBPM code-base to suggest how this should be implemented.
Regards,
Marcus
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/736669#736669]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&con...]
12 years, 4 months
[EJB3] - Runtime Exception while creating EJB Object
by Hushen Savani
Hushen Savani [https://community.jboss.org/people/hushen.savani] created the discussion
"Runtime Exception while creating EJB Object"
To view the discussion, visit: https://community.jboss.org/message/648806#648806
--------------------------------------------------------------
Hi Community,
I have developed an application with *Java 1.6*, *EJB-2.1*. The application is deployed on *JBossAS-5.1.0*. The application has been running very smooth for long a time. But for last two days, I found following sort of Runtime Exception while creating EJB Local Object/Local Home:
*Log Snippet-1*:
2012-01-25 17:09:02,896 ERROR [STDERR] (WorkerThread#4[127.0.0.1:47153])
Caused by: java.lang.NullPointerException
2012-01-25 17:09:02,896 ERROR [STDERR] (WorkerThread#4[127.0.0.1:47153])
at
org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyF
actory.java:343)
2012-01-25 17:09:02,896 ERROR [STDERR] (WorkerThread#4[127.0.0.1:47153])
at
org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:133)
2012-01-25 17:09:02,896 ERROR [STDERR] (WorkerThread#4[127.0.0.1:47153])
at $Proxy257.create(Unknown Source)
*Log Snippet-2*:
java.lang.NullPointerException
at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:457)
at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:103)
at $Proxy263.getDynamicLoopMessage_Generalized(Unknown Source)
*Log Snippet-3*:
2012-01-17 16:44:49,063 ERROR [org.jboss.ejb.plugins.LogInterceptor] (WorkerThread#5[192.168.1.76:19743]) RuntimeException in method: public abstract com.elitecore.billingengine.utils.BEResultObject com.elitecore.billingengine.ejb.billpreview.interfaces.IBillPreviewSessionLocal.doBasePriceCalculation(com.elitecore.billingengine.utils.BEHashMap):
java.lang.NullPointerException
at com.elitecore.billingengine.ejb.billpreview.sessionfacade.BillPreviewSessionFacade.doBasePriceCalculation(BillPreviewSessionFacade.java:357)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
Also, the whole server.log is attached with this thread. Pls. suggest some pointers on the same.
Thank you.
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/648806#648806]
Start a new discussion in EJB3 at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&con...]
12 years, 5 months
[jBPM] - Exception on starting JBoss
by Laura delli Paoli
Laura delli Paoli [https://community.jboss.org/people/lauradp] created the discussion
"Exception on starting JBoss"
To view the discussion, visit: https://community.jboss.org/message/743989#743989
--------------------------------------------------------------
Hello everybody, I'm very new to jBPM and I'm trying to make JBoss AS7 working with jBPM 5.3.
When I start the server with the attacched configuration file (standalone-jbpm.xml), I get the following error (see attacched console.txt for fulltrace) and I can access to the JBoss console, but If I type http://localhost:8080/jbpm-console http://localhost:8080/jbpm-console and fill "admin/admin" as username/password the browser locks on the login page.
Can anyone help me?
Regards
Laura
16:11:54,445 INFO [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015876: Starting deployment of "drools-guvnor.war"
16:12:29,967 ERROR [org.reflections.Reflections] (MSC service thread 1-4) 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:/C:/eseguibili/jboss-as-7.1.1/bin/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$Worker.runTask(Unknown Source) [rt.jar:1.6.0_32]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [rt.jar:1.6.0_32]
at java.lang.Thread.run(Unknown Source) [rt.jar:1.6.0_32]
16:12:30,013 ERROR [org.reflections.Reflections] (MSC service thread 1-4) 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:/C:/eseguibili/jboss-as-7.1.1/bin/content/jbpm-gwt-console.war/WEB-INF/lib/activity-monitor-ui-lib-1.1.1.Final.jar/
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$Worker.runTask(Unknown Source) [rt.jar:1.6.0_32]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [rt.jar:1.6.0_32]
at java.lang.Thread.run(Unknown Source) [rt.jar:1.6.0_32]
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/743989#743989]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&con...]
12 years, 5 months
[jBPM] - Error deploying jbpm-gwt-console.war IN JBOSS 7.1 Thunder
by Sukumaran Raghavan
Sukumaran Raghavan [https://community.jboss.org/people/suku_1983] created the discussion
"Error deploying jbpm-gwt-console.war IN JBOSS 7.1 Thunder"
To view the discussion, visit: https://community.jboss.org/message/724805#724805
--------------------------------------------------------------
Hi,
I was trying to setup JBPM 5.2 in JBoss AS7 thunder with MySql.
I used part of the ant scripts and performed some of the steps manually. Everything runs well when i use JBoss 7.0.2.
However when i use 7.1 Thunder, the deployment of the console war fails. Error details below
18:10:07,929 INFO [org.jboss.web] (MSC service thread 1-7) JBAS018210: Registering web context: /jbpm-gwt-console-server
18:10:09,783 ERROR [org.reflections.Reflections] (MSC service thread 1-7) 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.10.Final.jar:]
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1102) [jbossweb-7.0.10.Final.jar:]
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3655) [jbossweb-7.0.10.Final.jar:]
at org.apache.catalina.core.StandardContext.start(StandardContext.java:3873) [jbossweb-7.0.10.Final.jar:]
at org.jboss.as.web.deployment.WebDeploymentService.start(WebDeploymentService.java:90) [jboss-as-web-7.1.0.Final.jar:7.1.0.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$Worker.runTask(ThreadPoolExecutor.java:886) [classes.jar:1.6.0_26]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [classes.jar:1.6.0_26]
at java.lang.Thread.run(Thread.java:680) [classes.jar:1.6.0_26]
Anyone facing the same issue? Any clues would save a lot of time for me :)
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/724805#724805]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&con...]
12 years, 5 months
[jBPM] - Error - Table 'jbpm5.task' doesn't exist after trying to set mysql db
by Shamal Karunarathne
Shamal Karunarathne [https://community.jboss.org/people/shamalk] created the discussion
"Error - Table 'jbpm5.task' doesn't exist after trying to set mysql db"
To view the discussion, visit: https://community.jboss.org/message/743804#743804
--------------------------------------------------------------
Hi,
I followed the instructions in [ http://docs.jboss.org/jbpm/v5.3/userguide/ch.installer.html#d0e469 http://docs.jboss.org/jbpm/v5.3/userguide/ch.installer.html#d0e469] to use mysql as the database. but then I get this error when starting jboss. could you help me to fix this please?
19:25:46,592 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/jbpm-human-task-war]] (MSC service thread 1-1) StandardWrapper.Throwable: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614) [hibernate-entitymanager-3.4.0.GA.jar:]
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:76) [hibernate-entitymanager-3.4.0.GA.jar:]
at org.jbpm.task.service.persistence.TaskPersistenceManager.getUnescalatedDeadlinesList(TaskPersistenceManager.java:174) [jbpm-human-task-core-5.3.0.Final.jar:]
at org.jbpm.task.service.persistence.TaskPersistenceManager.getUnescalatedDeadlines(TaskPersistenceManager.java:146) [jbpm-human-task-core-5.3.0.Final.jar:]
at org.jbpm.task.service.TaskServiceSession.scheduleUnescalatedDeadlines(TaskServiceSession.java:231) [jbpm-human-task-core-5.3.0.Final.jar:]
at org.jbpm.task.service.TaskService.initialize(TaskService.java:116) [jbpm-human-task-core-5.3.0.Final.jar:]
at org.jbpm.task.service.TaskService.initialize(TaskService.java:101) [jbpm-human-task-core-5.3.0.Final.jar:]
at org.jbpm.task.service.TaskService.<init>(TaskService.java:79) [jbpm-human-task-core-5.3.0.Final.jar:]
at org.jbpm.task.servlet.HumanTaskServiceServlet.init(HumanTaskServiceServlet.java:127) [classes:]
at javax.servlet.GenericServlet.init(GenericServlet.java:242) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1202) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1102) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3631) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
at org.apache.catalina.core.StandardContext.start(StandardContext.java:3844) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
at org.jboss.as.web.deployment.WebDeploymentService.start(WebDeploymentService.java:70) [jboss-as-web-7.0.2.Final.jar:7.0.2.Final]
at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1824)
at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1759)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [:1.6.0_33]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [:1.6.0_33]
at java.lang.Thread.run(Thread.java:680) [:1.6.0_33]
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.loader.Loader.doList(Loader.java:2235) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.loader.Loader.list(Loader.java:2124) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:67) [hibernate-entitymanager-3.4.0.GA.jar:]
... 18 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jbpm5.task' doesn't exist
at sun.reflect.GeneratedConstructorAccessor17.newInstance(Unknown Source) [:1.6.0_33]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) [:1.6.0_33]
at java.lang.reflect.Constructor.newInstance(Constructor.java:513) [:1.6.0_33]
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:2624)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2293)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.loader.Loader.getResultSet(Loader.java:1812) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.loader.Loader.doQuery(Loader.java:697) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.loader.Loader.doList(Loader.java:2232) [hibernate-core-3.3.2.GA.jar:]
... 26 more
19:25:46,650 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/jbpm-human-task-war]] (MSC service thread 1-1) Servlet /jbpm-human-task-war threw load() exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jbpm5.task' doesn't exist
at sun.reflect.GeneratedConstructorAccessor17.newInstance(Unknown Source) [:1.6.0_33]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) [:1.6.0_33]
at java.lang.reflect.Constructor.newInstance(Constructor.java:513) [:1.6.0_33]
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:2624)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2293)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.loader.Loader.getResultSet(Loader.java:1812) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.loader.Loader.doQuery(Loader.java:697) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.loader.Loader.doList(Loader.java:2232) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.loader.Loader.list(Loader.java:2124) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) [hibernate-core-3.3.2.GA.jar:]
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:67) [hibernate-entitymanager-3.4.0.GA.jar:]
at org.jbpm.task.service.persistence.TaskPersistenceManager.getUnescalatedDeadlinesList(TaskPersistenceManager.java:174) [jbpm-human-task-core-5.3.0.Final.jar:]
at org.jbpm.task.service.persistence.TaskPersistenceManager.getUnescalatedDeadlines(TaskPersistenceManager.java:146) [jbpm-human-task-core-5.3.0.Final.jar:]
at org.jbpm.task.service.TaskServiceSession.scheduleUnescalatedDeadlines(TaskServiceSession.java:231) [jbpm-human-task-core-5.3.0.Final.jar:]
at org.jbpm.task.service.TaskService.initialize(TaskService.java:116) [jbpm-human-task-core-5.3.0.Final.jar:]
at org.jbpm.task.service.TaskService.initialize(TaskService.java:101) [jbpm-human-task-core-5.3.0.Final.jar:]
at org.jbpm.task.service.TaskService.<init>(TaskService.java:79) [jbpm-human-task-core-5.3.0.Final.jar:]
at org.jbpm.task.servlet.HumanTaskServiceServlet.init(HumanTaskServiceServlet.java:127) [classes:]
at javax.servlet.GenericServlet.init(GenericServlet.java:242) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1202) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1102) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3631) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
at org.apache.catalina.core.StandardContext.start(StandardContext.java:3844) [jbossweb-7.0.1.Final.jar:7.0.2.Final]
at org.jboss.as.web.deployment.WebDeploymentService.start(WebDeploymentService.java:70) [jboss-as-web-7.0.2.Final.jar:7.0.2.Final]
at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1824)
at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1759)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [:1.6.0_33]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [:1.6.0_33]
at java.lang.Thread.run(Thread.java:680) [:1.6.0_33]
19:25:46,744 INFO [org.jboss.web] (MSC service thread 1-1) registering web context: /jbpm-human-task-war
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/743804#743804]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&con...]
12 years, 5 months