Nihii Respected Contributor.
Respected Contributor.
411 views

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)
:
----
Labels (1)
0 Likes
1 Reply
Nihii Respected Contributor.
Respected Contributor.

Re: Identity Applications 4.7.2 Upgrade

We manually inserted value 18 into table "item_category" using pgAdmin and then restarted tomcat. This fixed the issue.

Thanks
Nihit
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.