Hello to everyone,
I’m trying to deploy a Bonita 6.1.1 Tomcat bundle in Windows 7 and my BD is running over a 9.1 postgres. I followed all the steps described in http://documentation.bonitasoft.com/tomcat-bundle-0
But when I start my server I receive this:
GRAVE: org.postgresql.util.PSQLException: ERROR: type “longvarchar” does not exist Position: 132 org.bonitasoft.engine.services.SPersistenceException: org.postgresql.util.PSQLException: ERROR: type “longvarchar” does not exist Position: 132
Ideas?
Thanks in advance
Hello again,
I have done 2 changes to:
1 add plpgsql as Language to my 2 BD’s
2 modify the setenv.bat, because by default come with
DB_OPTS="-Dsysprop.bonita.db.vendor=h2"
So I replace h2 with postgres.
Now the Non transactional BD configured in <TOMCAT_HOME>/conf/Catalina/localhost/bonita.xml file is generated with 68 empty tables.
The TA data source (managed by Bitronix) configured in <TOMCAT_HOME>/conf/bitronix-resources.properties file. Is’nt generated and I get this errors
Bonita Log:
7-dic-2013 12:11:21 org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener contextInitialized
GRAVE: Error while initializing the Engine
org.bonitasoft.engine.platform.PlatformNotFoundException: Can't start or stop platform if it is not created
GRAVE: 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.
Catalina Log:
DVERTENCIA: Scoping types to session factory org.hibernate.impl.SessionFactoryImpl@c50561 after already scoped org.hibernate.impl.SessionFactoryImpl@e43b44
17-dic-2013 12:11:14 net.sf.ehcache.config.CacheConfiguration isEternalValueConflictingWithTTIOrTTL
ADVERTENCIA: Cache 'null' is set to eternal but also has TTI/TTL set. To avoid this warning, clean up the config removing conflicting values of eternal, TTI and TTL. Effective configuration for Cache 'null' will be eternal='true', timeToIdleSeconds='0', timeToLiveSeconds='0'.
17-dic-2013 12:11:14 net.sf.ehcache.config.CacheConfiguration isEternalValueConflictingWithTTIOrTTL
ADVERTENCIA: Cache 'null' is set to eternal but also has TTI/TTL set. To avoid this warning, clean up the config removing conflicting values of eternal, TTI and TTL. Effective configuration for Cache 'null' will be eternal='true', timeToIdleSeconds='0', timeToLiveSeconds='0'.
17-dic-2013 12:11:14 net.sf.ehcache.config.CacheConfiguration isEternalValueConflictingWithTTIOrTTL
ADVERTENCIA: Cache 'null' is set to eternal but also has TTI/TTL set. To avoid this warning, clean up the config removing conflicting values of eternal, TTI and TTL. Effective configuration for Cache 'null' will be eternal='true', timeToIdleSeconds='0', timeToLiveSeconds='0'.
17-dic-2013 12:11:14 net.sf.ehcache.config.CacheConfiguration isEternalValueConflictingWithTTIOrTTL
ADVERTENCIA: Cache 'null' is set to eternal but also has TTI/TTL set. To avoid this warning, clean up the config removing conflicting values of eternal, TTI and TTL. Effective configuration for Cache 'null' will be eternal='true', timeToIdleSeconds='0', timeToLiveSeconds='0'.
17-dic-2013 12:11:14 org.hibernate.util.JDBCExceptionReporter logExceptions
ADVERTENCIA: SQL Error: 0, SQLState: 42P01
17-dic-2013 12:11:14 org.hibernate.util.JDBCExceptionReporter logExceptions
GRAVE: ERROR: relation "platform" does not exist
Position: 237
17-dic-2013 12:11:21 org.hibernate.util.JDBCExceptionReporter logExceptions
ADVERTENCIA: SQL Error: 0, SQLState: 42P01
17-dic-2013 12:11:21 org.hibernate.util.JDBCExceptionReporter logExceptions
GRAVE: ERROR: relation "sequence" does not exist
Position: 13
17-dic-2013 12:11:21 org.hibernate.util.JDBCExceptionReporter logExceptions
ADVERTENCIA: SQL Error: 0, SQLState: 42P01
17-dic-2013 12:11:21 org.hibernate.util.JDBCExceptionReporter logExceptions
GRAVE: ERROR: relation "platform" does not exist
Position: 237
17-dic-2013 12:11:22 org.apache.catalina.startup.HostConfig deployDirectory
Hi,
Have you thought about taking a look at this sample: http://documentation.bonitasoft.com/red-hat-oracle-jvm-jboss-postgresql
I know you are using windows, but since this sample have a lot ot details, it can brings you some light.
Hello Rafael, thanks for your answer, I’m working with windows and with the Tomcat bundle, nevertheless, I took a look to what you suggested me, but I couldn’t find anything new.
Thanks again.