i changed the database from h2 to postgresql, portal is not working ?

2020-05-29 13:22:23.329 +0530 FINE (main) org.jboss.narayana.tomcat.jta.TransactionLifecycleListener Initializing Narayana
2020-05-29 13:22:23.712 +0530 INFO (main) com.arjuna.ats.arjuna ARJUNA012170: TransactionStatusManager started on port 57339 and host 127.0.0.1 with service com.arjuna.ats.arjuna.recovery.ActionStatusService
2020-05-29 13:22:25.885 +0530 INFO (localhost-startStop-1) org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita] No Spring WebApplicationInitializer types detected on classpath
2020-05-29 13:22:26.073 +0530 INFO (localhost-startStop-1) org.bonitasoft.platform.setup.ScriptExecutor configuration for Database vendor: postgres
2020-05-29 13:22:26.077 +0530 INFO (localhost-startStop-1) org.bonitasoft.platform.setup.PlatformSetup System property org.bonitasoft.platform.setup.folder is set to C:\BonitaStudioCommunity-7.10.4\workspace\tomcat\server\..\setup
2020-05-29 13:22:26.084 +0530 INFO (localhost-startStop-1) org.bonitasoft.platform.setup.PlatformSetup Connected to 'postgres' database with url: 'jdbc:postgresql://localhost:5432/bonita_eng' with user: 'postgres'
2020-05-29 13:22:26.204 +0530 INFO (localhost-startStop-1) org.bonitasoft.platform.setup.PlatformSetup Platform is already created.
2020-05-29 13:22:26.208 +0530 INFO (localhost-startStop-1) org.bonitasoft.platform.setup.PlatformSetup Upgrading default configuration with files from folder: C:\BonitaStudioCommunity-7.10.4\workspace\tomcat\server\..\setup\platform_conf\initial
2020-05-29 13:22:26.251 +0530 INFO (localhost-startStop-1) org.bonitasoft.engine.EngineInitializer Initializing Bonita Engine...
2020-05-29 13:22:35.837 +0530 INFO (localhost-startStop-1) org.bonitasoft.engine.configuration.monitoring.MeterRegistryFactory Publishing monitoring metrics to : io.micrometer.jmx.JmxMeterRegistry
2020-05-29 13:22:39.843 +0530 WARNING (localhost-startStop-1) org.bonitasoft.engine.platform.impl.PlatformServiceImpl THREAD_ID=21 | HOSTNAME=LAPTOP-H5MBPPO2 | Can't cache the platform, maybe the platform cache service is not started yet: The cache is not started, call start() on the cache service
2020-05-29 13:22:39.867 +0530 WARN (localhost-startStop-1) org.hibernate.engine.jdbc.spi.SqlExceptionHelper SQL Error: 0, SQLState: 42883
2020-05-29 13:22:39.867 +0530 ERROR (localhost-startStop-1) org.hibernate.engine.jdbc.spi.SqlExceptionHelper ERROR: operator does not exist: integer = boolean
  Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
  Position: 374
2020-05-29 13:22:39.872 +0530 SEVERE (localhost-startStop-1) org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita] Exception sending context initialized event to listener instance of class [org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener]
java.lang.RuntimeException: Error while initializing the Engine
    at org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener.contextInitialized(EngineInitializerListener.java:34)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4699)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5165)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:743)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:719)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:705)
    at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:614)
    at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1823)
    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:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
Caused by: org.bonitasoft.engine.platform.PlatformNotFoundException: Cannot determine if the default tenant is created
    at org.bonitasoft.engine.api.impl.PlatformAPIImpl.isPlatformInitialized(PlatformAPIImpl.java:361)
    at org.bonitasoft.engine.EngineInitializer.initializeEngine(EngineInitializer.java:67)
    at org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener.contextInitialized(EngineInitializerListener.java:32)
    ... 13 more
Caused by: org.bonitasoft.engine.persistence.SBonitaReadException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
    at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectOne(AbstractHibernatePersistenceService.java:414)
    at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectOne(AbstractHibernatePersistenceService.java:330)
    at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.isDefaultTenantCreated(PlatformServiceImpl.java:396)
    at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:286)
    at org.bonitasoft.engine.api.impl.PlatformAPIImpl.isPlatformInitialized(PlatformAPIImpl.java:359)
    ... 15 more
Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
    at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123)
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91)
    at org.hibernate.loader.Loader.getResultSet(Loader.java:2066)
    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863)
    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)
    at org.hibernate.loader.Loader.doQuery(Loader.java:910)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)
    at org.hibernate.loader.Loader.doList(Loader.java:2554)
    at org.hibernate.loader.Loader.doList(Loader.java:2540)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)
    at org.hibernate.loader.Loader.list(Loader.java:2365)
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)
    at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236)
    at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1300)
    at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
    at org.hibernate.internal.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:966)
    at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectOne(AbstractHibernatePersistenceService.java:410)
    ... 19 more
Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = boolean
  Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
  Position: 374

 

Did you follow the documentation ?

Are you setuping a production environment or trying to update the Studio embedded runtime ?

hi romain.bioteau, i followed the bonita documentation and connected to the postgres database but portal is not working. i am getting below exception 

Caused by: org.bonitasoft.engine.platform.PlatformNotFoundException: Cannot determine if the default tenant is created
 

Did you use ` start-bonita.sh ` or ` start-bonita.bat` to start your platform ?

Are you using a Studio environment or a standalone tomcat ?

Hi romain.bioteau,

i am using studio environment and also used start-bonita.bat to start platform

It is not supported to change the database in the dev (studio) environment. Please use a standalone tomcat bundle and follow the documentation to setup Postgres.

Ok thank you, i will try using tomcat bundle