BPM kie-server

[Mark Rody]

Seems to be a simple question, but I can’t figure it out.

On the demo it setups up a default-kieserver, but the process under the Capabilities is disabled.
I can’t find anywhere in config that it should be disabled.

I even add the system property to set it to false.
<property name="org.jbpm.server.ext.disabled" value="false”/>

I am running the latest 7.55 version.

Then we I tried to add a new server, I can’t figure out how to add the remote server. So kind of stuck.

Ideas on where the configuration lives to get the process capability enabled?

Thanks
Mark

[waytoultim...@gmail.com]

Hello Mark,

By default org.jbpm.server.ext.disabled is set to false, so it shouldn't disabled unless there is some error while connecting to the kie-server. Can you cross-check the server logs for any errors?

Are you running both business-central and kie-server in the same wildfly instance or in seperate instances?

You can use the below endpoint to verify all capabilities enabled for your system.

~~~

http://SERVER:PORT/kie-server/services/rest/server

~~~

Regards,

Sudhish

[Mark Rody]

I know that is should be set to false and I also tried to set it to false again in system props.

I am running both business-central and kie-server on the same wildly instance. 

I am able to connect to the kie-server:

<response type="SUCCESS" msg="Kie Server info">

<kie-server-info>

<capabilities>KieServer</capabilities>

<capabilities>BRM</capabilities>

<capabilities>CaseMgmt</capabilities>

<capabilities>BPM-UI</capabilities>

<capabilities>BRP</capabilities>

<capabilities>DMN</capabilities>

<capabilities>Swagger</capabilities>

<location>http://localhost:8080/kie-server/services/rest/server</location>

<messages>

<content>Error when initializing server extension of type jBPM KIE Server extension due to Unable to create EntityManagerFactory due to [PersistenceUnit: org.jbpm.domain] Unable to build Hibernate SessionFactory</content>

<severity>ERROR</severity>

<timestamp>2021-06-28T08:41:26.807-06:00</timestamp>

</messages>

<messages>

<content>Server KieServerInfo{serverId='default-kieserver', version='7.55.0.Final', name='default-kieserver', location='http://localhost:8080/kie-server/services/rest/server', capabilities=[KieServer, BRM, CaseMgmt, BPM-UI, BRP, DMN, Swagger]', messages=null', mode=DEVELOPMENT}started successfully at Mon Jun 28 08:41:47 MDT 2021</content>

<severity>INFO</severity>

<timestamp>2021-06-28T08:41:47.988-06:00</timestamp>

</messages>

<mode>DEVELOPMENT</mode>

<name>default-kieserver</name>

<id>default-kieserver</id>

<version>7.55.0.Final</version>

</kie-server-info>

</response>

I found no errors in the server log that would indicate that there was something wrong.

thanks

Mark

--
You received this message because you are subscribed to the Google Groups "jBPM Setup" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbpm-setup+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jbpm-setup/e64a8dc0-aecb-40c6-8ca2-456d70ff95fbn%40googlegroups.com.

[Ultimate Freedom]

Hello,

From the output shared it looks like the kie-server extension is failing with the below error.

~~~

Error when initializing server extension of type jBPM KIE Server extension due to Unable to create EntityManagerFactory due to [PersistenceUnit: org.jbpm.domain] Unable to build Hibernate SessionFactory

~~~

Is there any error stack in server logs? Else enabling debug logs for package "org.kie" may help.

Are you using any external DB?

Regards,

Sudhish 

[Mark Rody]

Ah….

Server.log

2021-06-28 08:41:26,804 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ServerService Thread Pool -- 94) Table "SYNONYMS" not found; SQL statement:

SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, TYPE_CAT, TYPE_SCHEM, TYPE_NAME, SELF_REFERENCING_COL_NAME, REF_GENERATION, SQL FROM (SELECT SYNONYM_CATALOG TABLE_CAT, SYNONYM_SCHEMA TABLE_SCHEM, SYNONYM_NAME as TABLE_NAME, TYPE_NAME AS TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, TYPE_NAME TYPE_SCHEM, TYPE_NAME AS TYPE_NAME, TYPE_NAME SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION, NULL AS SQL FROM INFORMATION_SCHEMA.SYNONYMS WHERE SYNONYM_CATALOG LIKE ? ESCAPE ? AND SYNONYM_SCHEMA LIKE ? ESCAPE ? AND SYNONYM_NAME LIKE ? ESCAPE ? AND (false)  UNION SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, TYPE_NAME TYPE_SCHEM, TYPE_NAME, TYPE_NAME SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION, SQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG LIKE ? ESCAPE ? AND TABLE_SCHEMA LIKE ? ESCAPE ? AND TABLE_NAME LIKE ? ESCAPE ? AND (TABLE_TYPE IN(?, ?)) ) ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME [42102-197]

2021-06-28 08:41:26,807 ERROR [org.kie.server.services.impl.KieServerImpl] (ServerService Thread Pool -- 94) 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:817)

        at org.kie.server.services.jbpm.JbpmKieServerExtension.configureServices(JbpmKieServerExtension.java:232)

        at org.kie.server.services.jbpm.JbpmKieServerExtension.init(JbpmKieServerExtension.java:195)

        at org.kie.server.services.impl.KieServerImpl.init(KieServerImpl.java:170)

        at org.kie.server.services.impl.KieServerImpl.init(KieServerImpl.java:138)

        at org.kie.server.services.impl.KieServerLocator$KieServerLocatorHelper.<clinit>(KieServerLocator.java:25)

        at org.kie.server.services.impl.KieServerLocator.getInstance(KieServerLocator.java:32)

        at org.kie.server.remote.rest.common.Bootstrap.contextInitialized(Bootstrap.java:51)

        at io.undertow.servlet.core.ApplicationListeners.contextInitialized(ApplicationListeners.java:187)

        at io.undertow.servlet.core.DeploymentManagerImpl$1.call(DeploymentManagerImpl.java:217)

        at io.undertow.servlet.core.DeploymentManagerImpl$1.call(DeploymentManagerImpl.java:186)

        at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:42)

        at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)

        at org.wildfly.extension.undertow.security.SecurityContextThreadSetupAction.lambda$create$0(SecurityContextThreadSetupAction.java:105)

        at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1541)

        at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1541)

        at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1541)

        at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1541)

        at io.undertow.servlet.core.DeploymentManagerImpl.deploy(DeploymentManagerImpl.java:252)

        at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:96)

        at org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:78)

        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

        at java.util.concurrent.FutureTask.run(FutureTask.java:266)

        at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)

        at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1982)

        at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486)

        at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1377)

        at java.lang.Thread.run(Thread.java:748)

        at org.jboss.threads.JBossThread.run(JBossThread.java:485)

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.createEntityManagerFactory(JbpmKieServerExtension.java:822)

        at org.kie.server.services.jbpm.JbpmKieServerExtension.build(JbpmKieServerExtension.java:815)

        ... 28 more

Caused by: org.hibernate.exception.SQLGrammarException: Error accessing table metadata

        at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106)

        at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)

I am just using the demo H2 database.

Thanks

Mark

[Ultimate Freedom]

Hi Mark,

Is it possible for you to share complete server logs and H2 datasource configuration from standalone file used to review?

Regards,

Sudhish

[Mark Rody]

[Ultimate Freedom]

Hi Mark,

Did you download the full installer or minimal installer?

I tried with a full installer and faced a similar issue in my logs, it may be a bug.  

Generally I use Download jBPM 7.55.0.Final server (single zip) distribution, may be you can also try with "Download jBPM 7.55.0.Final server (single zip) distribution" and directly starting it with "jbpm-server/bin/standalone.sh"? 

I am not sure if they still ship DDL script although documentation says so [1].

[1] https://docs.jbpm.org/7.55.0.Final/jbpm-docs/html_single/#_jbpm_database_schema_scripts_ddl_scripts

Regards,

Sudhish

On Mon, Jun 28, 2021 at 11:02 PM Mark Rody <mr...@llnw.com> wrote:

I have simply downloaded 7.55, ran install.demo.noeclipse and start.demo.noeclipse.

I haven’t found the ddl files in the download. Where are those located? I am used to using mysql so I just wanted to demo 7.x. We are currently running 6.5 so need to updated and see what all I need to do.

Thanks for the help.

Mark

[Mark Rody]

I installedl the full installer.

I can look in git for the ddl. 

I will try with the other distribution.

Thanks

Mark

[Mark Rody]

Hi there, it is something with the full-installer.

Works with  Download jBPM 7.55.0.Final server (single zip) distribution

Also with the full-installer it is loading jbpm-console.war vs business-central.war. (Another bug?)

Thanks

Mark

[Ultimate Freedom]

Hi Mark,

Thanks for the confirmation.

I have created a JIRA to track the issues. You can add your observation as well. Let the product team confirm if it's a bug or if we are missing something.

[1] https://issues.redhat.com/browse/JBPM-9801

[2] https://issues.redhat.com/browse/JBPM-9800

Regards,

Sudhish