Fail to execute kie execution server and kie workbench on same server

706 views

Skip to first unread message

Nick

unread,

Oct 23, 2015, 9:34:05 AM10/23/15

to jBPM Usage

Hi,

I follow the instructions given at http://mswiderski.blogspot.be/2015/10/installing-kie-server-and-workbench-on.html to install kie execution server and kie workbench on same server.

My machine's OS is Windows.

I have set the following system properties in setenv.bat script inside TOMCAT_HOME/bin, however, it seems still tries to use dialect: org.hibernate.dialect.H2Dialect

-Dorg.kie.server.persistence.ds=java:comp/env/jdbc/jbpm

-Dorg.kie.server.persistence.dialect=org.hibernate.dialect.MySQL5Dialect

But I got the following error:

23-Oct-2015 21:00:59.353 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version: Apache Tomcat/8.0.28

23-Oct-2015 21:00:59.358 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Oct 7 2015 18:25:21 UTC

23-Oct-2015 21:00:59.362 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number: 8.0.28.0

23-Oct-2015 21:00:59.364 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Windows 10

23-Oct-2015 21:00:59.365 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 10.0

23-Oct-2015 21:00:59.366 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64

23-Oct-2015 21:00:59.367 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: C:\Java\jdk1.8.0_65\jre

23-Oct-2015 21:00:59.368 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0_65-b17

23-Oct-2015 21:00:59.370 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation

23-Oct-2015 21:00:59.372 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: C:\Java\apache-tomcat-8.0.28-windows-x64\apache-tomcat-8.0.28

23-Oct-2015 21:00:59.373 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: C:\Java\apache-tomcat-8.0.28-windows-x64\apache-tomcat-8.0.28

23-Oct-2015 21:00:59.375 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=C:\Java\apache-tomcat-8.0.28-windows-x64\apache-tomcat-8.0.28\conf\logging.properties

23-Oct-2015 21:00:59.376 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager

23-Oct-2015 21:00:59.378 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx512M

23-Oct-2015 21:00:59.380 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:MaxPermSize=512m

23-Oct-2015 21:00:59.381 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dbtm.root=C:\Java\apache-tomcat-8.0.28-windows-x64\apache-tomcat-8.0.28

23-Oct-2015 21:00:59.383 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.jbpm.cdi.bm=java:comp/env/BeanManager

23-Oct-2015 21:00:59.384 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dbitronix.tm.configuration=C:\Java\apache-tomcat-8.0.28-windows-x64\apache-tomcat-8.0.28/conf/btm-config.properties

23-Oct-2015 21:00:59.387 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djbpm.tsr.jndi.lookup=java:comp/env/TransactionSynchronizationRegistry

23-Oct-2015 21:00:59.389 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.security.auth.login.config=C:\Java\apache-tomcat-8.0.28-windows-x64\apache-tomcat-8.0.28/webapps/kie-wb/WEB-INF/classes/login.config

23-Oct-2015 21:00:59.392 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.kie.server.persistence.ds=java:comp/env/jdbc/jbpm

23-Oct-2015 21:00:59.393 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.kie.server.persistence.tm=org.hibernate.service.jta.platform.internal.BitronixJtaPlatform

23-Oct-2015 21:00:59.395 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.kie.server.persistence.dialect=org.hibernate.dialect.MySQL5Dialect

23-Oct-2015 21:00:59.397 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.kie.server.id=tomcat-kieserver

23-Oct-2015 21:00:59.398 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.kie.server.location=http://localhost:8080/kie-server/services/rest/server

23-Oct-2015 21:00:59.400 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.kie.server.controller=http://localhost:8080/kie-wb/rest/controller

23-Oct-2015 21:00:59.401 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.endorsed.dirs=C:\Java\apache-tomcat-8.0.28-windows-x64\apache-tomcat-8.0.28\endorsed

23-Oct-2015 21:00:59.406 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=C:\Java\apache-tomcat-8.0.28-windows-x64\apache-tomcat-8.0.28

23-Oct-2015 21:00:59.408 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=C:\Java\apache-tomcat-8.0.28-windows-x64\apache-tomcat-8.0.28

23-Oct-2015 21:00:59.409 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=C:\Java\apache-tomcat-8.0.28-windows-x64\apache-tomcat-8.0.28\temp

23-Oct-2015 21:00:59.411 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded APR based Apache Tomcat Native library 1.1.33 using APR version 1.5.1.

23-Oct-2015 21:00:59.413 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].

23-Oct-2015 21:01:00.613 INFO [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized (OpenSSL 1.0.1m 19 Mar 2015)

23-Oct-2015 21:01:01.040 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-apr-8080"]

23-Oct-2015 21:01:01.102 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-apr-8009"]

23-Oct-2015 21:01:01.102 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 3092 ms

23-Oct-2015 21:01:01.211 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service Catalina

23-Oct-2015 21:01:01.211 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.0.28

23-Oct-2015 21:01:01.305 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive C:\Java\apache-tomcat-8.0.28-windows-x64\apache-tomcat-8.0.28\webapps\kie-server.war

23-Oct-2015 21:01:01.544 INFO [localhost-startStop-1] bitronix.tm.integration.tomcat55.BTMLifecycleListener.lifecycleEvent Starting Bitronix Transaction Manager

23-Oct-2015 21:01:01.655 INFO [localhost-startStop-1] bitronix.tm.BitronixTransactionManager.logVersion Bitronix Transaction Manager version 2.1.4

23-Oct-2015 21:01:01.664 INFO [localhost-startStop-1] bitronix.tm.Configuration.buildServerIdArray JVM unique ID: <tomcat-btm-node0>

23-Oct-2015 21:01:01.695 WARNING [localhost-startStop-1] bitronix.tm.journal.DiskJournal.open active log file is unclean, did you call BitronixTransactionManager.shutdown() at the end of the last run?

23-Oct-2015 21:01:01.695 INFO [localhost-startStop-1] bitronix.tm.resource.ResourceLoader.init reading resources configuration from C:\Java\apache-tomcat-8.0.28-windows-x64\apache-tomcat-8.0.28/conf/resources.properties

23-Oct-2015 21:01:11.532 INFO [localhost-startStop-1] bitronix.tm.recovery.Recoverer.run recovery committed 0 dangling transaction(s) and rolled back 0 aborted transaction(s) on 1 resource(s) [jdbc/jbpm] (restricted to serverId 'tomcat-btm-node0')

23-Oct-2015 21:01:24.392 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.

23-Oct-2015 21:01:25.115 INFO [localhost-startStop-1] org.kie.server.services.Bootstrap.contextInitialized KieServer (id tomcat-kieserver (name tomcat-kieserver)) started initialization process

23-Oct-2015 21:01:25.756 INFO [localhost-startStop-1] org.kie.server.services.impl.storage.KieServerState.<init> Added default controller located at http://localhost:8080/kie-wb/rest/controller

23-Oct-2015 21:01:25.881 INFO [localhost-startStop-1] org.kie.server.services.impl.KieServerImpl.<init> Server Default Extension has been successfully registered as server extension

23-Oct-2015 21:01:25.881 INFO [localhost-startStop-1] org.kie.server.services.impl.KieServerImpl.<init> Drools KIE Server extension has been successfully registered as server extension

23-Oct-2015 21:01:27.426 INFO [localhost-startStop-1] org.hibernate.annotations.common.Version.<clinit> HCANN000001: Hibernate Commons Annotations {4.0.2.Final}

23-Oct-2015 21:01:27.458 INFO [localhost-startStop-1] org.hibernate.Version.logVersion HHH000412: Hibernate Core {4.2.20.Final}

23-Oct-2015 21:01:27.489 INFO [localhost-startStop-1] org.hibernate.cfg.Environment.<clinit> HHH000206: hibernate.properties not found

23-Oct-2015 21:01:27.489 INFO [localhost-startStop-1] org.hibernate.cfg.Environment.buildBytecodeProvider HHH000021: Bytecode provider name : javassist

23-Oct-2015 21:01:27.651 INFO [localhost-startStop-1] org.hibernate.ejb.Ejb3Configuration.configure HHH000204: Processing PersistenceUnitInfo [

name: org.jbpm.domain

...]

23-Oct-2015 21:01:29.487 INFO [localhost-startStop-1] org.hibernate.dialect.Dialect.<init> HHH000400: Using dialect: org.hibernate.dialect.H2Dialect

23-Oct-2015 21:01:29.541 WARN [localhost-startStop-1] org.hibernate.dialect.H2Dialect.<init> HHH000431: Unable to determine H2 database version, certain features may not work

23-Oct-2015 21:01:31.881 INFO [localhost-startStop-1] org.hibernate.engine.transaction.internal.TransactionFactoryInitiator.initiateService HHH000268: Transaction strategy: org.hibernate.engine.transaction.internal.jta.CMTTransactionFactory

23-Oct-2015 21:01:31.924 INFO [localhost-startStop-1] org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory.<init> HHH000397: Using ASTQueryTranslatorFactory

23-Oct-2015 21:01:33.772 INFO [localhost-startStop-1] org.hibernate.tool.hbm2ddl.SchemaUpdate.execute HHH000228: Running hbm2ddl schema update

23-Oct-2015 21:01:33.772 INFO [localhost-startStop-1] org.hibernate.tool.hbm2ddl.SchemaUpdate.execute HHH000102: Fetching database metadata

23-Oct-2015 21:01:33.819 ERROR [localhost-startStop-1] org.hibernate.tool.hbm2ddl.SchemaUpdate.execute HHH000319: Could not get database metadata

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'sequences' in information_schema

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:422)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)

at com.mysql.jdbc.Util.getInstance(Util.java:387)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:941)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3870)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3806)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2470)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2617)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2546)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2504)

at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1370)

at com.mysql.jdbc.jdbc2.optional.StatementWrapper.executeQuery(StatementWrapper.java:669)

at bitronix.tm.resource.jdbc.JdbcStatementHandle.executeQuery(JdbcStatementHandle.java:83)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:497)

at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)

at com.sun.proxy.$Proxy47.executeQuery(Unknown Source)

at org.hibernate.tool.hbm2ddl.DatabaseMetadata.initSequences(DatabaseMetadata.java:177)

at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:91)

at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:83)

at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:221)

at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:203)

at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:509)

at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1799)

at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:96)

at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:915)

at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:900)

at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:76)

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

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

at org.kie.server.services.impl.KieServerImpl.<init>(KieServerImpl.java:93)

at org.kie.server.services.impl.KieServerLocator.<clinit>(KieServerLocator.java:20)

at org.kie.server.services.Bootstrap.contextInitialized(Bootstrap.java:50)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4738)

at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5181)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)

at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)

at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1798)

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:745)

23-Oct-2015 21:01:33.834 ERROR [localhost-startStop-1] org.hibernate.tool.hbm2ddl.SchemaUpdate.execute HHH000299: Could not complete schema update