JBPM Process destroy (doesn't persist ) when I Stop and start the KIE execution server

324 views
Skip to first unread message

swapnil irabatti

unread,
Jul 5, 2017, 5:23:36 AM7/5/17
to jBPM Development
Steps what I did
1. Start the kie execution server
2. Start the jbpm process which has human task
3. Stop kie execution server
4. Again start kie execution server
5. Try to claim the human task from the process which I did it in step 2
Here I won't get any human task present not even the process instance.
What I want is even kie execution server restart this process instance state should persist so whenever I restart the server I should get all the processes which are InProgress.
Can anyone help me out?
Thank You...

Maciej Swiderski

unread,
Jul 5, 2017, 5:46:36 AM7/5/17
to swapnil irabatti, jBPM Development
configure db properly as by default it uses in memory db that is lost when you restart server.

Maciej
--
You received this message because you are subscribed to the Google Groups "jBPM Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbpm-developme...@googlegroups.com.
To post to this group, send email to jbpm-dev...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jbpm-development/3ddf87a7-89a3-4a4e-8657-7da400eaa18c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

swapnil irabatti

unread,
Jul 13, 2017, 11:02:53 AM7/13/17
to jBPM Development, swapnilir...@gmail.com
I tried to check some documents on configuring the db but I dent found any except the one which you have written http://mswiderski.blogspot.in/2015/10/installing-kie-server-and-workbench-on.html In this blog there is a command 
  • -Dorg.kie.server.persistence.ds=java:jboss/datasources/jbpmDS
  • -Dorg.kie.server.persistence.dialect=org.hibernate.dialect.MySQL5Dialec

Is this the one which you are talking about or this is nowhere related to my question?
If this is not the one, can you suggest any example or any document
Thank you.

swapnil irabatti

unread,
Jul 17, 2017, 2:27:27 AM7/17/17
to jBPM Development, swapnilir...@gmail.com
Hi,
I created separate JNDI in wildfly, this is what log I got
 
2017-07-17 11:41:53,789 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-7) WFLYJCA0001: Bound data source [java:jboss/jdbc/MySQLDS]

But still, I am not able to persist the processes in my DB.
 
I attached log file, 
I think I am missing something which I am not able to figure out.
This is how I am starting the server

standalone.sh --server-config=standalone-full.xml  -Dorg.kie.server.id=wildfly-kieserver -Dorg.kie.server.location=http://localhost:8081/kie-server/services/rest/server -Dorg.kie.server.persistence.ds=java:jboss/jdbc/MySQLDS -Dorg.kie.server.persistence.dialect=org.hibernate.dialect.MySQL5Dialect
Can anyone help me on it?
server.log

swapnil irabatti

unread,
Jul 18, 2017, 3:11:43 AM7/18/17
to jBPM Development, swapnilir...@gmail.com
I even tried with this

standalone.sh --server-config=standalone-full.xml  -Dorg.kie.server.id=wildfly-kieserver -Dorg.kie.server.location=http://localhost:8081/kie-server/services/rest/server -Dorg.kie.server.persistence.ds=java:jboss/datasources/MySQLDS -Dorg.kie.server.persistence.dialect=org.hibernate.dialect.MySQL5Dialect -Dorg.kie.server.persistence.tm=bitronix.tm.resource.jdbc.lrc.LrcXADataSource

nothing helped...
Can anyone figure out what I am doing wrong?

Thank you...

Maciej Swiderski

unread,
Jul 18, 2017, 4:02:37 AM7/18/17
to jBPM Development
you have removed default data source which is still needed by the app server - java.jboss.datasources.ExampleDS

do add it back next to you MySQL data source and set only these system properties 
-Dorg.kie.server.persistence.ds=java:jboss/jdbc/MySQLDS -Dorg.kie.server.persistence.dialect=org.hibernate.dialect.MySQL5Dialect

Maciej

swapnil irabatti

unread,
Jul 18, 2017, 4:21:34 AM7/18/17
to jBPM Development
This is how I created in standalone-ful.xml

 <subsystem xmlns="urn:jboss:domain:datasources:4.0">
            <datasources>
                <datasource jndi-name="java:jboss/datasources/MySQLDS" pool-name="MySQLDS" enabled="true" use-java-context="true">
                    <connection-url>jdbc:mysql://localhost:3306/rps_am</connection-url>
                    <driver>mysql</driver>
                    <security>
                        <user-name>root</user-name>
                        <password>root</password>
                    </security>
                </datasource>
                <drivers>
                    <driver name="mysql" module="com.mysql.jdbc">
                        <xa-datasource-class>com.mysql.jdbc.Driver</xa-datasource-class>
                    </driver>
                </drivers>
<datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true">
                    <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE</connection-url>
                    <driver>h2</driver>
                    <security>
                        <user-name>sa</user-name>
                        <password>sa</password>
                    </security>
                </datasource>
                <drivers>
                    <driver name="h2" module="com.h2database.h2">
                        <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
                    </driver>
                </drivers>
            </datasources>
        </subsystem>

Is it the correct one I have configured or anything mess?

swapnil irabatti

unread,
Jul 18, 2017, 4:26:31 AM7/18/17
to jBPM Development
I am getting this error:

13:54:53,704 INFO  [org.kie.server.services.impl.KieServerImpl] (ServerService Thread Pool -- 69) Drools KIE Server extension has been successfully registered as server extension
13:54:53,757 INFO  [org.hibernate.jpa.internal.util.LogHelper] (ServerService Thread Pool -- 69) HHH000204: Processing PersistenceUnitInfo [
        name: org.jbpm.domain
        ...]
13:54:53,811 INFO  [org.hibernate.Version] (ServerService Thread Pool -- 69) HHH000412: Hibernate Core {5.1.4.Final}
13:54:53,813 INFO  [org.hibernate.cfg.Environment] (ServerService Thread Pool -- 69) HHH000206: hibernate.properties not found
13:54:53,814 INFO  [org.hibernate.cfg.Environment] (ServerService Thread Pool -- 69) HHH000021: Bytecode provider name : javassist
13:54:53,844 INFO  [org.hibernate.annotations.common.Version] (ServerService Thread Pool -- 69) HCANN000001: Hibernate Commons Annotations {5.0.1.Final}
13:54:54,260 INFO  [org.hibernate.dialect.Dialect] (ServerService Thread Pool -- 69) HHH000400: Using dialect: org.hibernate.dialect.MySQL5Dialect
13:54:54,920 ERROR [org.kie.server.services.impl.KieServerImpl] (ServerService Thread Pool -- 69) Error when initializing server extension of type jBPM KIE Server extension: java.lang.RuntimeException: Unable to create EntityManagerFactory due to [PersistenceUnit: org.jbpm.domain] Unable to build Hibernate SessionFactory
        at org.kie.server.services.jbpm.JbpmKieServerExtension.build(JbpmKieServerExtension.java:701)
        at org.kie.server.services.jbpm.JbpmKieServerExtension.init(JbpmKieServerExtension.java:186)
        at org.kie.server.services.impl.KieServerImpl.<init>(KieServerImpl.java:120)
        at org.kie.server.services.impl.KieServerImpl.<init>(KieServerImpl.java:97)
        at org.kie.server.services.impl.KieServerLocator.<clinit>(KieServerLocator.java:20)
        at org.kie.server.services.Bootstrap.contextInitialized(Bootstrap.java:49)
        at io.undertow.servlet.core.ApplicationListeners.contextInitialized(ApplicationListeners.java:187)
        at io.undertow.servlet.core.DeploymentManagerImpl.deploy(DeploymentManagerImpl.java:198)
        at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:100)
        at org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:82)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:748)
        at org.jboss.threads.JBossThread.run(JBossThread.java:320)
Caused by: javax.persistence.PersistenceException: [PersistenceUnit: org.jbpm.domain] Unable to build Hibernate SessionFactory
        at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.persistenceException(EntityManagerFactoryBuilderImpl.java:953)
        at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:883)
        at org.hibernate.jpa.HibernatePersistenceProvider.createContainerEntityManagerFactory(HibernatePersistenceProvider.java:135)
        at org.kie.server.services.jbpm.JbpmKieServerExtension.build(JbpmKieServerExtension.java:699)
        ... 15 more
Caused by: org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.transaction.jta.platform.spi.JtaPlatform]
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:264)
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:228)
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:207)
        at org.hibernate.resource.transaction.backend.jta.internal.DdlTransactionIsolatorJtaImpl.<init>(DdlTransactionIsolatorJtaImpl.java:34)
        at org.hibernate.tool.schema.internal.Helper.buildDefaultDdlTransactionIsolator(Helper.java:145)
        at org.hibernate.tool.schema.internal.HibernateSchemaManagementTool.getDdlTransactionIsolator(HibernateSchemaManagementTool.java:180)
        at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:90)
        at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:176)
        at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:65)
        at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:459)
        at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:465)
        at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:880)
        ... 17 more
Caused by: org.hibernate.boot.registry.selector.spi.StrategySelectionException: Could not instantiate named strategy class [org.hibernate.engine.transaction.jta.platform.spi.JtaPlatform]
        at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.resolveDefaultableStrategy(StrategySelectorImpl.java:170)
        at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.resolveDefaultableStrategy(StrategySelectorImpl.java:126)
        at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.resolveStrategy(StrategySelectorImpl.java:120)
        at org.hibernate.engine.transaction.jta.platform.internal.JtaPlatformInitiator.initiateService(JtaPlatformInitiator.java:40)
        at org.hibernate.engine.transaction.jta.platform.internal.JtaPlatformInitiator.initiateService(JtaPlatformInitiator.java:26)
        at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:88)
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:254)
        ... 28 more
Caused by: java.lang.InstantiationException: org.hibernate.engine.transaction.jta.platform.spi.JtaPlatform
        at java.lang.Class.newInstance(Class.java:427)
        at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.resolveDefaultableStrategy(StrategySelectorImpl.java:166)
        ... 34 more
Caused by: java.lang.NoSuchMethodException: org.hibernate.engine.transaction.jta.platform.spi.JtaPlatform.<init>()
        at java.lang.Class.getConstructor0(Class.java:3082)
        at java.lang.Class.newInstance(Class.java:412)
        ... 35 more

13:54:54,920 ERROR [org.kie.server.services.impl.KieServerImpl] (ServerService Thread Pool -- 69) Error when initializing server extension of type jBPM KIE Server extension: java.lang.RuntimeException: Unable to create EntityManagerFactory due to [PersistenceUnit: org.jbpm.domain] Unable to build Hibernate SessionFactory
        at org.kie.server.services.jbpm.JbpmKieServerExtension.build(JbpmKieServerExtension.java:701)
        at org.kie.server.services.jbpm.JbpmKieServerExtension.init(JbpmKieServerExtension.java:186)
        at org.kie.server.services.impl.KieServerImpl.<init>(KieServerImpl.java:120)
        at org.kie.server.services.impl.KieServerImpl.<init>(KieServerImpl.java:97)
        at org.kie.server.services.impl.KieServerLocator.<clinit>(KieServerLocator.java:20)
        at org.kie.server.services.Bootstrap.contextInitialized(Bootstrap.java:49)
        at io.undertow.servlet.core.ApplicationListeners.contextInitialized(ApplicationListeners.java:187)
        at io.undertow.servlet.core.DeploymentManagerImpl.deploy(DeploymentManagerImpl.java:198)
        at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:100)
        at org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:82)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:748)
        at org.jboss.threads.JBossThread.run(JBossThread.java:320)
Caused by: javax.persistence.PersistenceException: [PersistenceUnit: org.jbpm.domain] Unable to build Hibernate SessionFactory
        at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.persistenceException(EntityManagerFactoryBuilderImpl.java:953)
        at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:883)
        at org.hibernate.jpa.HibernatePersistenceProvider.createContainerEntityManagerFactory(HibernatePersistenceProvider.java:135)
        at org.kie.server.services.jbpm.JbpmKieServerExtension.build(JbpmKieServerExtension.java:699)
        ... 15 more
Caused by: org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.transaction.jta.platform.spi.JtaPlatform]
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:264)
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:228)
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:207)
        at org.hibernate.resource.transaction.backend.jta.internal.DdlTransactionIsolatorJtaImpl.<init>(DdlTransactionIsolatorJtaImpl.java:34)
        at org.hibernate.tool.schema.internal.Helper.buildDefaultDdlTransactionIsolator(Helper.java:145)
        at org.hibernate.tool.schema.internal.HibernateSchemaManagementTool.getDdlTransactionIsolator(HibernateSchemaManagementTool.java:180)
        at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:90)
        at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:176)
        at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:65)
        at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:459)
        at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:465)
        at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:880)
        ... 17 more
Caused by: org.hibernate.boot.registry.selector.spi.StrategySelectionException: Could not instantiate named strategy class [org.hibernate.engine.transaction.jta.platform.spi.JtaPlatform]
        at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.resolveDefaultableStrategy(StrategySelectorImpl.java:170)
        at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.resolveDefaultableStrategy(StrategySelectorImpl.java:126)
        at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.resolveStrategy(StrategySelectorImpl.java:120)
        at org.hibernate.engine.transaction.jta.platform.internal.JtaPlatformInitiator.initiateService(JtaPlatformInitiator.java:40)
        at org.hibernate.engine.transaction.jta.platform.internal.JtaPlatformInitiator.initiateService(JtaPlatformInitiator.java:26)
        at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:88)
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:254)
        ... 28 more
Caused by: java.lang.InstantiationException: org.hibernate.engine.transaction.jta.platform.spi.JtaPlatform
        at java.lang.Class.newInstance(Class.java:427)
        at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.resolveDefaultableStrategy(StrategySelectorImpl.java:166)
        ... 34 more
Caused by: java.lang.NoSuchMethodException: org.hibernate.engine.transaction.jta.platform.spi.JtaPlatform.<init>()
        at java.lang.Class.getConstructor0(Class.java:3082)
        at java.lang.Class.newInstance(Class.java:412)
        ... 35 more

Maciej Swiderski

unread,
Jul 18, 2017, 8:10:43 AM7/18/17
to swapnil irabatti, jBPM Development
please pay attention to the replies you get - I already mentioned what system properties you should use when it comes to persistence - don’t set the .tm as it is already valid default option since you’re running on wildfly

Maciej
-- 
You received this message because you are subscribed to the Google Groups "jBPM Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbpm-developme...@googlegroups.com.
To post to this group, send email to jbpm-dev...@googlegroups.com.

swapnil irabatti

unread,
Jul 18, 2017, 8:22:49 AM7/18/17
to jBPM Development, swapnilir...@gmail.com
Yes as u mentioned I removed tm system property and tried as u suggested then also I was getting the same error.
Then I downloaded kie-server 7.1.0 final then tried it was working.
Thanks Maciej for your great response.
Keep helping.
Maciej
To unsubscribe from this group and stop receiving emails from it, send an email to jbpm-development+unsub...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages