# i changed the database from h2 to postgresql, portal is not working ? **URL:** \ **Category:** Q&A\ **Created:** [29 May 2020 08:19 UTC](https://community.ofelia.com/t/i-changed-the-database-from-h2-to-postgresql-portal-is-not-working/10196 "2020-05-29T08:19:46Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![prathyusha0525\_13847](https://avatars.discourse-cdn.com/v4/letter/p/6de8d8/32.png) [@prathyusha0525\_13847](https://community.ofelia.com/u/prathyusha0525_13847)\ **Post date:** [29 May 2020 08:19 UTC](https://community.ofelia.com/t/i-changed-the-database-from-h2-to-postgresql-portal-is-not-working/10196/1 "2020-05-29T08:19:46Z")
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**   ---
**Author:** ![romain.bioteau](https://dub1.discourse-cdn.com/flex013/user_avatar/community.ofelia.com/romain.bioteau/32/720_2.png) [@romain.bioteau](https://community.ofelia.com/u/romain.bioteau)\ **Post date:** [29 May 2020 08:53 UTC](https://community.ofelia.com/t/i-changed-the-database-from-h2-to-postgresql-portal-is-not-working/10196/2 "2020-05-29T08:53:18Z")
Did you follow the [documentation](https://documentation.bonitasoft.com/bonita/7.10/ubuntu-openjdk-tomcat-postgresql)? Are you setuping a production environment or trying to update the Studio embedded runtime ? ---
**Author:** ![prathyusha0525\_13847](https://avatars.discourse-cdn.com/v4/letter/p/6de8d8/32.png) [@prathyusha0525\_13847](https://community.ofelia.com/u/prathyusha0525_13847)\ **Post date:** [29 May 2020 09:46 UTC](https://community.ofelia.com/t/i-changed-the-database-from-h2-to-postgresql-portal-is-not-working/10196/3 "2020-05-29T09:46:52Z")
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**   ---
**Author:** ![romain.bioteau](https://dub1.discourse-cdn.com/flex013/user_avatar/community.ofelia.com/romain.bioteau/32/720_2.png) [@romain.bioteau](https://community.ofelia.com/u/romain.bioteau)\ **Post date:** [30 May 2020 08:27 UTC](https://community.ofelia.com/t/i-changed-the-database-from-h2-to-postgresql-portal-is-not-working/10196/4 "2020-05-30T08:27:03Z")
Did you use ` `start-bonita.sh` ` or ` `start-bonita.bat`` to start your platform ? Are you using a Studio environment or a standalone tomcat ? ---
**Author:** ![prathyusha0525\_13847](https://avatars.discourse-cdn.com/v4/letter/p/6de8d8/32.png) [@prathyusha0525\_13847](https://community.ofelia.com/u/prathyusha0525_13847)\ **Post date:** [1 June 2020 04:46 UTC](https://community.ofelia.com/t/i-changed-the-database-from-h2-to-postgresql-portal-is-not-working/10196/5 "2020-06-01T04:46:34Z")
Hi _romain.bioteau,_ i am using studio environment and also used **start-bonita.bat** to start platform ---
**Author:** ![romain.bioteau](https://dub1.discourse-cdn.com/flex013/user_avatar/community.ofelia.com/romain.bioteau/32/720_2.png) [@romain.bioteau](https://community.ofelia.com/u/romain.bioteau)\ **Post date:** [1 June 2020 11:13 UTC](https://community.ofelia.com/t/i-changed-the-database-from-h2-to-postgresql-portal-is-not-working/10196/6 "2020-06-01T11:13:19Z")
It is not supported to change the database in the dev (studio) environment. Please use a [standalone tomcat bundle](https://www.bonitasoft.com/downloads) and follow the documentation to setup Postgres. ---
**Author:** ![prathyusha0525\_13847](https://avatars.discourse-cdn.com/v4/letter/p/6de8d8/32.png) [@prathyusha0525\_13847](https://community.ofelia.com/u/prathyusha0525_13847)\ **Post date:** [2 June 2020 06:06 UTC](https://community.ofelia.com/t/i-changed-the-database-from-h2-to-postgresql-portal-is-not-working/10196/7 "2020-06-02T06:06:35Z")
Ok thank you, i will try using tomcat bundle