Identity Applications 4.7.2 Upgrade

Hello,

We upgraded IDM Engine from 4.6.3 > 4.7 > 4.7.2 and eDir 9.1.2. We followed the same sequence for Identity Applications upgrade 4.6.3 > 4.7 > 4.7.2. PostgreSQL was upgraded to 9.6. But when running tomcat, we are having following errors in catalina.out.

2019-01-24 16:41:33,013 ERROR [liquibase] (localhost-startStop-1) liquibase: Change Set AlterUiItem47.xml::2800::IDMRBPM failed. Error: ERROR: insert or update on table "ui_item_categories" violates foreign key constraint "fk_uiitemcat_
itemcat"
Detail: Key (categories)=(18) is not present in table "item_category". [Failed SQL: INSERT INTO public.UI_ITEM_CATEGORIES (ui_item, categories) VALUES ('30', '18')]
2019-01-24 16:41:33,016 INFO [liquibase] (localhost-startStop-1) liquibase: Successfully released change log lock
2019-01-24 16:41:33,019 ERROR [com.sssw.fw.servlet.EboBootServlet] (localhost-startStop-1) [RBPM] Runtime exception initializing.
com.netiq.persist.PersistenceException: ERROR: insert or update on table "ui_item_categories" violates foreign key constraint "fk_uiitemcat_itemcat"
Detail: Key (categories)=(18) is not present in table "item_category".

at com.novell.soa.persist.DatabaseSchemaUpdate.updateSchema(DatabaseSchemaUpdate.java:443)
at com.novell.soa.persist.DatabaseSchemaUpdate.validateDatabaseSchema(DatabaseSchemaUpdate.java:240)
at com.sssw.fw.servlet.EboBootServlet.init(EboBootServlet.java:116)
at com.sssw.portal.servlet.EboPortalBootServlet.init(EboPortalBootServlet.java:63)
at javax.servlet.GenericServlet.init(GenericServlet.java:158)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1144)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:983)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4978)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5290)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:985)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
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: liquibase.exception.MigrationFailedException: Migration failed for change set AlterUiItem47.xml::2800::IDMRBPM:
Reason: liquibase.exception.DatabaseException: ERROR: insert or update on table "ui_item_categories" violates foreign key constraint "fk_uiitemcat_itemcat"
Detail: Key (categories)=(18) is not present in table "item_category". [Failed SQL: INSERT INTO public.UI_ITEM_CATEGORIES (ui_item, categories) VALUES ('30', '18')]
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:619)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:79)
at liquibase.Liquibase.update(Liquibase.java:214)
at liquibase.Liquibase.update(Liquibase.java:192)
at liquibase.Liquibase.update(Liquibase.java:188)
at liquibase.Liquibase.update(Liquibase.java:181)
at com.novell.soa.persist.DatabaseSchemaUpdate.updateSchema(DatabaseSchemaUpdate.java:434)
... 20 more
Caused by: liquibase.exception.DatabaseException: ERROR: insert or update on table "ui_item_categories" violates foreign key constraint "fk_uiitemcat_itemcat"
Detail: Key (categories)=(18) is not present in table "item_category". [Failed SQL: INSERT INTO public.UI_ITEM_CATEGORIES (ui_item, categories) VALUES ('30', '18')]
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:309)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:113)
at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1277)
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1259)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:582)
... 27 more
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "ui_item_categories" violates foreign key constraint "fk_uiitemcat_itemcat"
Detail: Key (categories)=(18) is not present in table "item_category".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:303)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:289)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:266)
:
----