[jboss-user] [jBPM] - deploy the jbpm-console in jBoss AS 7.1

[joploya]

joploya [https://community.jboss.org/people/joploya] created the discussion

"deploy the jbpm-console in jBoss AS 7.1"

To view the discussion, visit: https://community.jboss.org/message/764956#764956

--------------------------------------------------------------
Hello,

To explain the situation :
- I have a jboss server (7.1)
- I created two mySQL schemas : jbpm-test and jbpm-console-test
- I modify both persistence.xml files of human task web service and console server to persist datas in this databases.
- I deploy the human task well

ERROR [org.jboss.msc.service.fail] (MSC service thread 1-7) MSC00001: Failed to start service jboss.persistenceunit."jbpm-gwt-console-server.war#org.jbpm.persistence.jpa": org.jboss.msc.service.StartException in service jboss.persistenceunit."jbpm-gwt-console-server.war#org.jbpm.persistence.jpa": Failed to start service
          at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1767) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]
          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [rt.jar:1.7.0_07]
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.7.0_07]
          at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_07]
Caused by: javax.persistence.PersistenceException: [PersistenceUnit: org.jbpm.persistence.jpa] Unable to build EntityManagerFactory
          at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:914)
          at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:889)
          at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:73)
          at org.jboss.as.jpa.service.PersistenceUnitServiceImpl.createContainerEntityManagerFactory(PersistenceUnitServiceImpl.java:162)
          at org.jboss.as.jpa.service.PersistenceUnitServiceImpl.start(PersistenceUnitServiceImpl.java:85)
          at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]
          at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]
          ... 3 more
Caused by: org.hibernate.HibernateException: Errors in named queries: ProcessInstancesWaitingForEvent
          at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:494)
          at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1737)
          at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:84)
          at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:904)
          ... 9 more

In attachement there is the full stack trace of the deployement of jbpm-gwt-console-server.war. And the part datasource of standalone.xml file of jBoss.

Can somebody tell me what I do wrong please?

Thank you very much for helping.

Regards,

Joploya
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/764956#764956]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[Maciej Swiderski]

Maciej Swiderski [https://community.jboss.org/people/swiderski.maciej] created the discussion

"Re: deploy the jbpm-console in jBoss AS 7.1"

To view the discussion, visit: https://community.jboss.org/message/765069#765069

--------------------------------------------------------------
it is because you don't have ProcessInstanceInfo configured in your persistence.xml (extract from log file):

org.hibernate.hql.internal.ast.QuerySyntaxException: ProcessInstanceInfo is not mapped

check if you have <mapping-file>META-INF/ProcessInstanceInfo.hbm.xml</mapping-file> in persistence.xml

HTH
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/765069#765069]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[joploya]

joploya [https://community.jboss.org/people/joploya] created the discussion

"Re: deploy the jbpm-console in jBoss AS 7.1"

To view the discussion, visit: https://community.jboss.org/message/766229#766229

--------------------------------------------------------------
Thanks for your reply.

I think ProcessInstanceInfo is mapped because it appear in the persistence.xml file. But I just see that, indeed, the table processInsatnceInfo is not created in the database.
I have no idea why. I can find the class in the libs so it is not due to a missing element.

I give you the war in attachement with the model of the generated tables. If it can give you more clues.

Regards

Loading Image... Loading Image...
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/766229#766229]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[Maciej Swiderski]

Maciej Swiderski [https://community.jboss.org/people/swiderski.maciej] created the discussion

"Re: deploy the jbpm-console in jBoss AS 7.1"

To view the discussion, visit: https://community.jboss.org/message/766239#766239

--------------------------------------------------------------
since you run on JPA1 you should remove processinstanceinfo class from persistence.xml and put this instead: <mapping-file>META-INF/ProcessInstanceInfo.hbm.xml</mapping-file>

hth
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/766239#766239]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[joploya]

joploya [https://community.jboss.org/people/joploya] created the discussion

"Re: deploy the jbpm-console in jBoss AS 7.1"

To view the discussion, visit: https://community.jboss.org/message/766243#766243

--------------------------------------------------------------
I made the change and deploy the war again but now I have another error : there is a problem with the version of mapping entity.
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/766243#766243]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[Maciej Swiderski]

Maciej Swiderski [https://community.jboss.org/people/swiderski.maciej] created the discussion

"Re: deploy the jbpm-console in jBoss AS 7.1"

To view the discussion, visit: https://community.jboss.org/message/766308#766308

--------------------------------------------------------------
looking at your logs it looks like you don't have jbpm console security realm defined in your standalone.xml file. Here is an extract of standalone.xml provided with jbpm installer



<security-domain name="jbpm-console" cache-type="default">
    <authentication>
        <login-module code="UsersRoles" flag="required">
            <module-option name="usersProperties" value="${jboss.server.config.dir}/users.properties"/>
            <module-option name="rolesProperties" value="${jboss.server.config.dir}/roles.properties"/>
        </login-module>
    </authentication>
</security-domain>



please take a look at the one that comes with installer to make sure you have all configuration required.

HTH
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/766308#766308]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[sagar dhumal]

sagar dhumal [https://community.jboss.org/people/dsagar1234] created the discussion

"Re: deploy the jbpm-console in jBoss AS 7.1"

To view the discussion, visit: https://community.jboss.org/message/806182#806182

--------------------------------------------------------------
Thanks a lot *Maciej. Thats the solution i was looking for...
*
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/806182#806182]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]