org.bonitasoft.console.common.server.utils.DefaultTenantIdException

Submitted by konstantin.dedi... on Thu, 11/20/2014 - 11:02

I'm try to install bonita using this manual http://documentation.bonitasoft.com/ubuntu-openjdk-tomcat-mysql

list of my tomacat7 libs:

root@bonita:/usr/share/tomcat7/lib# ls -al 4096 Nov 19 10:41 . 4096 Nov 18 18:53 .. 44 Apr 8 2014 annotations-api.jar -> ../../java/tomcat-annotations-api-7.0.28.jar 3923 Nov 19 10:41 bonita-jboss-h2-mbean-1.0.0.jar 4168 Nov 19 10:41 bonita-tomcat-h2-listener-1.0.1.jar 3416 Nov 18 19:05 bonita-tomcat-valve-6.0.35.jar 294654 Nov 18 19:05 btm-2.1.3.jar 3177 Nov 18 19:05 btm-tomcat55-lifecycle-2.1.3.jar 34 Apr 8 2014 catalina-ant.jar -> ../../java/catalina-ant-7.0.28.jar 40 Apr 8 2014 catalina-ha.jar -> ../../java/tomcat-catalina-ha-7.0.28.jar 37 Apr 8 2014 catalina.jar -> ../../java/tomcat-catalina-7.0.28.jar 37 Apr 8 2014 catalina-tribes.jar -> ../../java/catalina-tribes-7.0.28.jar 27 Apr 8 2014 commons-dbcp.jar -> ../../java/commons-dbcp.jar 27 Apr 8 2014 commons-pool.jar -> ../../java/commons-pool.jar 32 Apr 8 2014 el-api.jar -> ../../java/tomcat-el-api-2.2.jar root root 1469903 Nov 19 10:41 h2-1.3.170.jar 38 Apr 8 2014 jasper-el.jar -> ../../java/tomcat-jasper-el-7.0.28.jar 35 Apr 8 2014 jasper.jar -> ../../java/tomcat-jasper-7.0.28.jar 33 Apr 8 2014 jsp-api.jar -> ../../java/tomcat-jsp-api-2.2.jar 15071 Nov 18 19:05 jta-1.1.jar 960374 Nov 18 18:57 mysql-connector-java-5.1.34-bin.jar 37 Apr 8 2014 servlet-api.jar -> ../../java/tomcat-servlet-api-3.0.jar 25496 Nov 18 19:05 slf4j-api-1.6.1.jar 8890 Nov 19 10:41 slf4j-jdk14-1.6.1.jar 32 Apr 8 2014 tomcat-api.jar -> ../../java/tomcat-api-7.0.28.jar 35 Apr 8 2014 tomcat-coyote.jar -> ../../java/tomcat-coyote-7.0.28.jar 36 Apr 8 2014 tomcat-i18n-es.jar -> ../../java/tomcat-i18n-es-7.0.28.jar 36 Apr 8 2014 tomcat-i18n-fr.jar -> ../../java/tomcat-i18n-fr-7.0.28.jar 36 Apr 8 2014 tomcat-i18n-ja.jar -> ../../java/tomcat-i18n-ja-7.0.28.jar 33 Apr 8 2014 tomcat-util.jar -> ../../java/tomcat-util-7.0.28.jar

tomcat7 starting error log:

INFO: Platform is already initialized. org.bonitasoft.engine.exception.CreationException: Platform Creation failed. at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:169) at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createAndInitializePlatform(PlatformAPIImpl.java:210) at org.bonitasoft.engine.PlatformTenantManager.createPlatform(PlatformTenantManager.java:43) at org.bonitasoft.engine.EngineInitializer.initPlatform(EngineInitializer.java:142) at org.bonitasoft.engine.EngineInitializer.initializeEngine(EngineInitializer.java:93) at org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener.contextInitialized(EngineInitializerListener.java:43) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4790) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5284) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:875) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:618) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:650) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1582) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: org.bonitasoft.engine.platform.SPlatformCreationException: Unable to create platform tables : com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LONGVARCHAR, filename VARCHAR(255) NOT NULL, value_ LONGVARBINARY NOT NULL, ' at line 4 at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.createPlatformTables(PlatformServiceImpl.java:151) at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:152) ... 18 more Caused by: org.bonitasoft.engine.services.SPersistenceException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LONGVARCHAR, filename VARCHAR(255) NOT NULL, value_ LONGVARBINARY NOT NULL, ' at line 4 at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.doExecuteSQLThroughJDBC(AbstractHibernatePersistenceService.java:858) at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.doExecuteSQL(AbstractHibernatePersistenceService.java:812) at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.executeSQL(AbstractDBPersistenceService.java:251) at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.createStructure(AbstractDBPersistenceService.java:183) at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.createPlatformTables(PlatformServiceImpl.java:142) ... 19 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LONGVARCHAR, filename VARCHAR(255) NOT NULL, value_ LONGVARBINARY NOT NULL, ' at line 4 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) at com.mysql.jdbc.Util.getInstance(Util.java:360) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:265) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:265) at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.doExecuteSQLThroughJDBC(AbstractHibernatePersistenceService.java:845) ... 23 more

Nov 20, 2014 12:11:47 PM org.bonitasoft.engine.EngineInitializer initializeEngine INFO: Starting platform... Nov 20, 2014 12:11:47 PM org.bonitasoft.engine.EngineInitializer startPlatform INFO: Starting platform... Nov 20, 2014 12:11:47 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions WARN: SQL Error: 1146, SQLState: 42S02 Nov 20, 2014 12:11:47 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions ERROR: Table 'bonita.platform' doesn't exist Nov 20, 2014 12:11:47 PM org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl afterTransaction INFO: HHH000106: Forcing container resource cleanup on transaction completion Nov 20, 2014 12:11:47 PM org.bonitasoft.engine.EngineInitializer initializeEngine INFO: Exception while initializing the engine: org.bonitasoft.engine.platform.PlatformNotFoundException: Can't start or stop platform if it is not created Nov 20, 2014 12:11:47 PM org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener contextInitialized SEVERE: Error while initializing the Engine org.bonitasoft.engine.platform.PlatformNotFoundException: Can't start or stop platform if it is not created at org.bonitasoft.engine.PlatformTenantManager.updatePlatform(PlatformTenantManager.java:51) at org.bonitasoft.engine.PlatformTenantManager.startPlatform(PlatformTenantManager.java:61) at org.bonitasoft.engine.EngineInitializer.startPlatform(EngineInitializer.java:149) at org.bonitasoft.engine.EngineInitializer.initializeEngine(EngineInitializer.java:102) at org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener.contextInitialized(EngineInitializerListener.java:43) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4790) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5284) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:875) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:618) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:650) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1582) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745)

Nov 20, 2014 12:11:47 PM org.bonitasoft.console.common.server.servlet.PlatformTenantListener contextInitialized SEVERE: Error while initializing the default tenant org.bonitasoft.engine.platform.NodeNotStartedException: The current node has not been started yet. Method PlatformAPI.startNode() must be called previously. at org.bonitasoft.engine.api.impl.ServerAPIImpl.checkMethodAccessibility(ServerAPIImpl.java:292) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:281) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:128) at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:88) at com.sun.proxy.$Proxy5.login(Unknown Source) at org.bonitasoft.console.common.server.servlet.PlatformTenantListener.initializeDefaultTenant(PlatformTenantListener.java:61) at org.bonitasoft.console.common.server.servlet.PlatformTenantListener.contextInitialized(PlatformTenantListener.java:44) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4790) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5284) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:875) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:618) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:650) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1582) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745)

Nov 20, 2014 12:11:47 PM org.apache.catalina.startup.HostConfig deployDirectory INFO: Deploying web application directory /var/lib/tomcat7/webapps/ROOT Nov 20, 2014 12:11:47 PM org.apache.coyote.AbstractProtocol start INFO: Starting ProtocolHandler ["http-bio-8080"] Nov 20, 2014 12:11:47 PM org.apache.catalina.startup.Catalina start INFO: Server startup in 15055 ms

Log in or register to post comments
4517 reads

2 answers

Submitted by antoine.mottier on Thu, 11/20/2014 - 19:00

This one is the BEST answer!

Can you check that on the running server the JVM system property sysprop.bonita.db.vendor is set to mysql? (you can use JVisualVM or JConsole).

Also note that, as the first startup failed, you should clean up the Bonita home folder as it becomes out of sync compare to database content: Bonita home has been initialized whereas database as not been initialized due to data source configuration issue (or any connection / configuration issue).

Easy way to do the cleanup is simply to remove Bonita home folder and replace it with a clean one. Remember that if you set the db.vendor property in <bonita.home>\server\platform\conf\bonita-platform.properties file you should set it again.

If you don't want to go with the "delete" and "replace" solution, you can remove the following folder under bonita.home:

client/tenants
server/tenants
server/platform/tmp
server/platform/work

Log in or register to post comments
561 reads

Comments

Submitted by konstantin.dedi... on Thu, 11/20/2014 - 21:11

Sorry, I'm not familiar with java. How can I check sysprop.bonita.db.vendor ?

Permalink

Submitted by konstantin.dedi... on Fri, 11/21/2014 - 08:06

root@bonita:~# jinfo 16989 Attaching to process ID 16989, please wait... Debugger attached successfully. Server compiler detected. JVM version is 24.72-b04 Java System Properties:

java.runtime.name = Java(TM) SE Runtime Environment java.vm.version = 24.72-b04 sun.boot.library.path = /usr/lib/jvm/java-7-oracle/jre/lib/amd64 shared.loader = /var/lib/tomcat7/shared/classes,/var/lib/tomcat7/shared/*.jar btm.root = /opt/bonita/btm java.vendor.url = http://java.oracle.com/ java.vm.vendor = Oracle Corporation path.separator = : file.encoding.pkg = sun.io java.vm.name = Java HotSpot(TM) 64-Bit Server VM java.util.logging.config.file = /var/lib/tomcat7/conf/logging.properties tomcat.util.buf.StringCache.byte.enabled = true sun.os.patch.level = unknown sun.java.launcher = SUN_STANDARD user.country = US user.dir = /var/lib/tomcat7 java.vm.specification.name = Java Virtual Machine Specification java.runtime.version = 1.7.0_72-b14 java.awt.graphicsenv = sun.awt.X11GraphicsEnvironment os.arch = amd64 java.endorsed.dirs = /usr/share/tomcat7/endorsed line.separator =

java.io.tmpdir = /tmp/tomcat7-tomcat7-tmp java.vm.specification.vendor = Oracle Corporation java.util.logging.manager = org.apache.juli.ClassLoaderLogManager java.naming.factory.url.pkgs = org.apache.naming os.name = Linux sun.jnu.encoding = UTF-8 java.library.path = /usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib tomcat.util.scan.DefaultJarScanner.jarsToSkip = bootstrap.jar,commons-daemon.jar,tomcat-juli.jar,annotations-api.jar,el-api.jar,jsp-api.jar,servlet-api.jar,catalina.jar,catalina-ant.jar,catalina-ha.jar,catalina-tribes.jar,jasper.jar,jasper-el.jar,ecj-.jar,tomcat-api.jar,tomcat-util.jar,tomcat-coyote.jar,tomcat-dbcp.jar,tomcat-jni.jar,tomcat-spdy.jar,tomcat-i18n-en.jar,tomcat-i18n-es.jar,tomcat-i18n-fr.jar,tomcat-i18n-ja.jar,tomcat-juli-adapters.jar,catalina-jmx-remote.jar,catalina-ws.jar,tomcat-jdbc.jar,commons-beanutils.jar,commons-codec.jar,commons-collections.jar,commons-dbcp.jar,commons-digester.jar,commons-fileupload.jar,commons-httpclient.jar,commons-io.jar,commons-lang.jar,commons-logging.jar,commons-math.jar,commons-pool.jar,jstl.jar,geronimo-spec-jaxrpc.jar,wsdl4j.jar,ant.jar,ant-junit.jar,aspectj.jar,jmx.jar,h2.jar,hibernate.jar,httpclient.jar,jmx-tools.jar,jta.jar,log4j.jar,mail.jar,slf4j.jar,xercesImpl.jar,xmlParserAPIs.jar,xml-apis.jar,dnsns.jar,ldapsec.jar,localedata.jar,sunjce_provider.jar,sunmscapi.jar,sunpkcs11.jar,jhall.jar,tools.jar,sunec.jar,zipfs.jar,apple_provider.jar,AppleScriptEngine.jar,CoreAudio.jar,dns_sd.jar,j3daudio.jar,j3dcore.jar,j3dutils.jar,jai_core.jar,jai_codec.jar,mlibwrapper_jai.jar,MRJToolkit.jar,vecmath.jar,junit.jar,junit-.jar,ant-launcher.jar java.class.version = 51.0 java.specification.name = Java Platform API Specification sun.management.compiler = HotSpot 64-Bit Tiered Compilers os.version = 3.2.0-4-amd64 user.home = /usr/share/tomcat7 user.timezone = Europe/Kiev catalina.useNaming = true java.awt.printerjob = sun.print.PSPrinterJob file.encoding = UTF-8 java.specification.version = 1.7 catalina.home = /usr/share/tomcat7 user.name = tomcat7 java.class.path = /usr/share/tomcat7/bin/bootstrap.jar:/usr/share/tomcat7/bin/tomcat-juli.jar java.naming.factory.initial = org.apache.naming.java.javaURLContextFactory package.definition = sun.,java.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper. java.vm.specification.version = 1.7 sun.arch.data.model = 64 sun.java.command = org.apache.catalina.startup.Bootstrap start java.home = /usr/lib/jvm/java-7-oracle/jre user.language = en java.specification.vendor = Oracle Corporation awt.toolkit = sun.awt.X11.XToolkit java.vm.info = mixed mode db.vendor = ${sysprop.bonita.db.vendor:h2} java.version = 1.7.0_72 java.ext.dirs = /usr/lib/jvm/java-7-oracle/jre/lib/ext:/usr/java/packages/lib/ext sun.boot.class.path = /usr/lib/jvm/java-7-oracle/jre/lib/resources.jar:/usr/lib/jvm/java-7-oracle/jre/lib/rt.jar:/usr/lib/jvm/java-7-oracle/jre/lib/sunrsasign.jar:/usr/lib/jvm/java-7-oracle/jre/lib/jsse.jar:/usr/lib/jvm/java-7-oracle/jre/lib/jce.jar:/usr/lib/jvm/java-7-oracle/jre/lib/charsets.jar:/usr/lib/jvm/java-7-oracle/jre/lib/jfr.jar:/usr/lib/jvm/java-7-oracle/jre/classes java.awt.headless = true server.loader = /var/lib/tomcat7/server/classes,/var/lib/tomcat7/server/.jar java.vendor = Oracle Corporation catalina.base = /var/lib/tomcat7 file.separator = / java.vendor.url.bug = http://bugreport.sun.com/bugreport/ common.loader = ${catalina.base}/lib,${catalina.base}/lib/.jar,${catalina.home}/lib,${catalina.home}/lib/.jar,/var/lib/tomcat7/common/classes,/var/lib/tomcat7/common/*.jar bonita.home = /opt/bonita/bonita_home-6.3.8 sun.io.unicode.encoding = UnicodeLittle sun.font.fontmanager = sun.awt.X11FontManager sun.cpu.endian = little bitronix.tm.configuration = /opt/bonita/btm/conf/bitronix-config.properties package.access = sun.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper. sun.cpu.isalist =

VM Flags:

-Djava.util.logging.config.file=/var/lib/tomcat7/conf/logging.properties -Djava.awt.headless=true -Xmx128m -XX:+UseConcMarkSweepGC -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Dbonita.home=/opt/bonita/bonita_home-6.3.8 -Dbtm.root=/opt/bonita/btm -Dbitronix.tm.configuration=/opt/bonita/btm/conf/bitronix-config.properties -Dfile.encoding=UTF-8 -Xshare:auto -Xms1024m -Xmx1024m -XX:MaxPermSize=256m -XX:+HeapDumpOnOutOfMemoryError -Djava.endorsed.dirs=/usr/share/tomcat7/endorsed -Dcatalina.base=/var/lib/tomcat7 -Dcatalina.home=/usr/share/tomcat7 -Djava.io.tmpdir=/tmp/tomcat7-tomcat7-tmp

Permalink

Submitted by konstantin.dedi... on Fri, 11/21/2014 - 08:13

So, I changed <bonita.home>\server\platform\conf\bonita-platform.properties to mysql and it's works! Thanks

Permalink

Submitted by eberli on Thu, 12/18/2014 - 14:40

The documentation is not complete regarding setenv.sh - you need to include the DB_OPTS variable in CATALINA_OPTS:

open /usr/share/tomcat7/bin/setenv.sh and change the line starting with 'CATALINA_OPTS= ' to this:

CATALINA_OPTS="${CATALINA_OPTS} ${BONITA_HOME} ${BTM_OPTS} ${DB_OPTS} -Dfile.encoding=UTF-8 -Xshare:auto -Xms1024m -Xmx1024m -XX:MaxPermSize=256m -XX:+HeapDumpOnOutOfMemoryError"

Of course yo need to make sure you have defined DB_OPTS before CATALINA_OPTS

Log in or register to post comments
535 reads

Comments

Submitted by antoine.mottier on Thu, 12/18/2014 - 15:11

Thanks a lot for your feedback. I update the script example on version 6.3 documentation page in order to include the DB_OPTS

Note that documentation page for version 6.4 has been fully rewrite and now use the setenv.sh provided in deploy bundle.

Permalink

Submitted by eberli on Fri, 12/19/2014 - 08:54

thanks - that was fast!

Permalink