org.postgresql.util.PSQLException: ERROR: relation "act_id_property" does not exist

Hi everyone,

I have create new schema called “flowable” under flowable database. When I try to run spring boot api, i get the following error:

2021-04-01 10:51:20.798 INFO 66749 — [ main] l.c.StandardChangeLogHistoryService : Creating database history table with name: flowable.flw_ev_databasechangelog
2021-04-01 10:51:20.820 INFO 66749 — [ main] l.c.StandardChangeLogHistoryService : Reading from flowable.flw_ev_databasechangelog
2021-04-01 10:51:20.900 INFO 66749 — [ main] liquibase.changelog.ChangeSet : Table FLW_EVENT_DEPLOYMENT created
2021-04-01 10:51:20.922 INFO 66749 — [ main] liquibase.changelog.ChangeSet : Table FLW_EVENT_RESOURCE created
2021-04-01 10:51:20.946 INFO 66749 — [ main] liquibase.changelog.ChangeSet : Table FLW_EVENT_DEFINITION created
2021-04-01 10:51:20.955 INFO 66749 — [ main] liquibase.changelog.ChangeSet : Index ACT_IDX_EVENT_DEF_UNIQ created
2021-04-01 10:51:20.985 INFO 66749 — [ main] liquibase.changelog.ChangeSet : Table FLW_CHANNEL_DEFINITION created
2021-04-01 10:51:20.994 INFO 66749 — [ main] liquibase.changelog.ChangeSet : Index ACT_IDX_CHANNEL_DEF_UNIQ created
2021-04-01 10:51:20.997 INFO 66749 — [ main] liquibase.changelog.ChangeSet : ChangeSet org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml::1::flowable ran successfully in 126ms
2021-04-01 10:51:21.010 INFO 66749 — [ main] l.lockservice.StandardLockService : Successfully released change log lock
2021-04-01 10:51:21.013 INFO 66749 — [ main] o.f.e.impl.EventRegistryEngineImpl : EventRegistryEngine default created
2021-04-01 10:51:21.013 INFO 66749 — [ main] o.f.s.SpringProcessEngineConfiguration : Executing configure() of class org.flowable.idm.engine.configurator.IdmEngineConfigurator (priority:150000)
2021-04-01 10:51:21.044 ERROR 66749 — [ main] o.f.i.engine.impl.db.IdmDbSchemaManager : Could not get property from table ACT_ID_PROPERTY

org.postgresql.util.PSQLException: ERROR: relation “act_id_property” does not exist
Position: 20
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164) ~[postgresql-42.2.19.jar:42.2.19]
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114) ~[postgresql-42.2.19.jar:42.2.19]
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) ~[HikariCP-3.4.5.jar:na]
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) ~[HikariCP-3.4.5.jar:na]

Any idea what I have done wrong? or what is missing here?

Thanks