8.4p2 - patch deployment "iiq patch 8.4p2" - errors

IdentityIQ (IIQ) IIQ Discussion and Questions
1

Which IIQ version are you inquiring about?

IdentityIQ 8.4p2
During patch: 8.4p2 deployment.
Apache Tomcat/9.0.106
JAVA_VERSION=17.0.14
Database: PostgreSQL15 (local database)
Driver jar file: postgresql-42.7.7.jar
Windows 11 (it’s my local PC)

Fresh Installation of IIQ 8.4 and then p2 deployment.

Please share any images or screenshots, if relevant.

Here we can observe: schema_version updated to 8.4.88 (which is 8.4p2), that means schema upgrade(upgrade_identityiq_tables-8.4p2.postgresql) is successful.

image
image637×403 8.04 KB

Please share any other relevant files that may be required (for example, logs).

iiq patch 8.4p2 - console output

C:\Users\Chaithu\Downloads\apache-tomcat-9.0.106-windows-x64\apache-tomcat-9.0.106\webapps\identityiq\WEB-INF\bin>iiq patch 8.4p2
adding exports for Java 17
------------------------------------
 Executing IdentityIQ Patch [8.4p2]
------------------------------------
LCM Disabled.
AI Disabled.
FAM Disabled.
CAM Disabled.
PAM Disabled.


[1/8] Execute: WebResourcesUpgrader
    - Removing rights for WebResource of url systemSetup/messageBusConfig.*
    - Removing ActiveMQ from Debug WebResource
    - Removing rights for WebResource of url debug/activemq.*
    - Modifying rights for WebResource of url debug/connections.* to ViewAccessConnectionsPage,FullAccessDebugPage
    - Elapsed Time: 83 milliseconds

[2/8] Execute: AccessHistoryWriterServiceUpgrader
2025-07-04T00:09:35,419  WARN main engine.jdbc.spi.SqlExceptionHelper:137 - SQL Error: 0, SQLState: 22003
2025-07-04T00:09:35,421 ERROR main engine.jdbc.spi.SqlExceptionHelper:142 - Bad value for type long : import sailpoint.object.*;
        import sailpoint.tools.Util;
        import sailpoint.web.messages.MessageKeys;
        if (Util.otob(taskDefinition.getArgument("exclusions"))){
          report.setDisablePreview(true);
          report.setDisablePreviewMessage(MessageKeys.REPT_CERT_PREVIEW_DISABLED_EXCLUSIONS);
        } else {
          report.setDisablePreview(false);
          report.setDisablePreviewMessage(null);
        }
2025-07-04T00:09:35,425 ERROR main sailpoint.tools.xml.ReferenceSerializer:118 - Error resolving references to tag='Reference' class='sailpoint.object.Rule' name=Certification Report Customizer' id='c0a800b197d0142c8197d0a47cbf022f' exception='sailpoint.tools.GeneralException: Could not read entity state from ResultSet : EntityKey[sailpoint.object.Rule#c0a800b197d0142c8197d0a47cbf022f]'
2025-07-04T00:09:35,487  WARN main engine.jdbc.spi.SqlExceptionHelper:137 - SQL Error: 0, SQLState: 22003
2025-07-04T00:09:35,487 ERROR main engine.jdbc.spi.SqlExceptionHelper:142 - Bad value for type long : import sailpoint.object.*;
        import sailpoint.reporting.ReportingLibrary;

        ObjectConfig identityConfig = ObjectConfig.getObjectConfig(Identity.class);
        List standardAttributes = new ArrayList();
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("firstname"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("lastname"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("displayName"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("email"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("manager"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("inactive"));

        ReportingLibrary.addAttributes(context, report, Identity.class, standardAttributes, null,
          "Identity Attributes", locale, "id");

        List extendedAttrs = new ArrayList();
        for(ObjectAttribute att : identityConfig.getSearchableAttributes()){
          if (!att.isStandard())
            extendedAttrs.add(att);
        }

        for(ObjectAttribute att : identityConfig.getMultiAttributeList()){
            extendedAttrs.add(att);
C:\Users\Chaithu\Downloads\apache-tomcat-9.0.106-windows-x64\apache-tomcat-9.0.106\webapps\identityiq\WEB-INF\bin>

C:\Users\Chaithu\Downloads\apache-tomcat-9.0.106-windows-x64\apache-tomcat-9.0.106\webapps\identityiq\WEB-INF\bin>
          "Identity Extended Attributes", locale, "id");
2025-07-04T00:09:35,487 ERROR main sailpoint.tools.xml.ReferenceSerializer:118 - Error resolving references to tag='Reference' class='sailpoint.object.Rule' name=Identity Report Form Customizer' id='c0a800b197d0142c8197d0a47b08020c' exception='sailpoint.tools.GeneralException: Could not read entity state from ResultSet : EntityKey[sailpoint.object.Rule#c0a800b197d0142c8197d0a47b08020c]'
2025-07-04T00:09:35,487  WARN main engine.jdbc.spi.SqlExceptionHelper:137 - SQL Error: 0, SQLState: 22003
2025-07-04T00:09:35,487 ERROR main engine.jdbc.spi.SqlExceptionHelper:142 - Bad value for type long : import sailpoint.object.*;
        import sailpoint.reporting.ReportingLibrary;

        ObjectConfig identityConfig = ObjectConfig.getObjectConfig(Identity.class);
        List standardAttributes = new ArrayList();
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("firstname"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("lastname"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("displayName"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("email"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("manager"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("inactive"));

        ReportingLibrary.addAttributes(context, report, IdentityEntitlement.class, standardAttributes, "identity",
          "Identity Attributes", locale, "id");


        List extendedAttrs = new ArrayList();
        for(ObjectAttribute att : identityConfig.getSearchableAttributes()){
          if (!att.isStandard())
            extendedAttrs.add(att);
        }

        for(ObjectAttribute att : identityConfig.getMultiAttributeList()){
            extendedAttrs.add(att);
        }

        ReportingLibrary.addAttributes(context, report, IdentityEntitlement.class, extendedAttrs, "identity",
          "Identity Extended Attributes", locale, "id");
2025-07-04T00:09:35,487 ERROR main sailpoint.tools.xml.ReferenceSerializer:118 - Error resolving references to tag='Reference' class='sailpoint.object.Rule' name=Identity Entitlement Identity Report Form Customizer' id='c0a800b197d0142c8197d0a47b89020f' exception='sailpoint.tools.GeneralException: Could not read entity state from ResultSet : EntityKey[sailpoint.object.Rule#c0a800b197d0142c8197d0a47b89020f]'
2025-07-04T00:09:35,502  WARN main engine.jdbc.spi.SqlExceptionHelper:137 - SQL Error: 0, SQLState: 22003
2025-07-04T00:09:35,502 ERROR main engine.jdbc.spi.SqlExceptionHelper:142 - Bad value for type long : import sailpoint.object.*;
        import sailpoint.reporting.ReportingLibrary;

        ObjectConfig linkConfig = ObjectConfig.getObjectConfig(Link.class);
        ReportingLibrary.addAttributes(context, report, Link.class, linkConfig.getSearchableAttributes(), null,
          "Account Properties", locale);
2025-07-04T00:09:35,502 ERROR main sailpoint.tools.xml.ReferenceSerializer:118 - Error resolving references to tag='Reference' class='sailpoint.object.Rule' name=Account Report Form Customizer' id='c0a800b197d0142c8197d0a47bda0211' exception='sailpoint.tools.GeneralException: Could not read entity state from ResultSet : EntityKey[sailpoint.object.Rule#c0a800b197d0142c8197d0a47bda0211]'
2025-07-04T00:09:35,565  WARN main engine.jdbc.spi.SqlExceptionHelper:137 - SQL Error: 0, SQLState: 22003
2025-07-04T00:09:35,565 ERROR main engine.jdbc.spi.SqlExceptionHelper:142 - Bad value for type long : import sailpoint.object.*;
        import sailpoint.reporting.ReportingLibrary;

        ObjectConfig linkConfig = ObjectConfig.getObjectConfig(Link.class);
        ReportingLibrary.addAttributes(context, report, Link.class, linkConfig.getSearchableAttributes(), null,
          "Privileged Account Attributes", locale, "id");


        ObjectConfig identityConfig = ObjectConfig.getObjectConfig(Identity.class);
        List standardAttributes = new ArrayList();
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("firstname"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("lastname"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("displayName"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("email"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("manager"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("inactive"));

        ReportingLibrary.addAttributes(context, report, Identity.class, standardAttributes, "identity",
          "Identity Properties", locale, "id");

        List extendedAttrs = new ArrayList();
        for(ObjectAttribute att : identityConfig.getSearchableAttributes()){
          if (!att.isStandard())
            extendedAttrs.add(att);
        }

        for(ObjectAttribute att : identityConfig.getMultiAttributeList()){
            extendedAttrs.add(att);
        }

        ReportingLibrary.addAttributes(context, report, Identity.class, extendedAttrs, "identity",
          "Identity Extended Properties", locale, "id");
2025-07-04T00:09:35,565 ERROR main sailpoint.tools.xml.ReferenceSerializer:118 - Error resolving references to tag='Reference' class='sailpoint.object.Rule' name=Privileged Access Report Customizer' id='c0a800b197d0142c8197d0a47d950247' exception='sailpoint.tools.GeneralException: Could not read entity state from ResultSet : EntityKey[sailpoint.object.Rule#c0a800b197d0142c8197d0a47d950247]'
2025-07-04T00:09:35,565  WARN main engine.jdbc.spi.SqlExceptionHelper:137 - SQL Error: 0, SQLState: 22003
2025-07-04T00:09:35,565 ERROR main engine.jdbc.spi.SqlExceptionHelper:142 - Bad value for type long : import java.util.*;
       import sailpoint.object.*;
       import sailpoint.tools.Message;
       List messages = new ArrayList();

       Form.Section section = form.getSection("Privileged Account Attributes");
       if (section != null) {
         boolean found = false;
         for(FormItem item : section.getItems()){
           Field field = (Field)item;
           if(field.getValue() != null && !field.getValue().equals("") && !field.getValue().equals("null")) {
             found = true;
           }
         }

         if (!found) {
           messages.add(Message.localize("rept_priv_access_err_no_attr"));
         }
       } else {
         messages.add(Message.localize("rept_priv_attr_setup_needed"));
       }

       return messages;
2025-07-04T00:09:35,565 ERROR main sailpoint.tools.xml.ReferenceSerializer:118 - Error resolving references to tag='Reference' class='sailpoint.object.Rule' name=Privileged Access Report Validation Rule' id='c0a800b197d0142c8197d0a47dbe0248' exception='sailpoint.tools.GeneralException: Could not read entity state from ResultSet : EntityKey[sailpoint.object.Rule#c0a800b197d0142c8197d0a47dbe0248]'

-----------------
 Upgrade Summary
-----------------
     Elapsed Time: 11 seconds
     Log Location: C:\Users\Chaithu\Downloads\apache-tomcat-9.0.106-windows-x64\apache-tomcat-9.0.106\webapps\identityiq\WEB-INF\bin\patch_8_4p2_070425_000925.log
Commands Executed: 1
        - Execute: WebResourcesUpgrader [OK] (83ms)


----------------------------------------------------------------------------
 FAILURE: An unexpected error occurred: Found loading entities during flush
----------------------------------------------------------------------------
2025-07-04T00:09:36,475 ERROR main sailpoint.server.upgrade.Upgrader:1132 - Found loading entities during flush
sailpoint.tools.GeneralException: Found loading entities during flush
        at sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersistenceManager.java:586) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at sailpoint.persistence.ClassPersistenceManager.commitTransaction(ClassPersistenceManager.java:211) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at sailpoint.server.InternalContext.commitTransaction(InternalContext.java:601) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at sailpoint.server.upgrade.AccessHistoryWriterServiceUpgrader.removeAccessHistorySvc(AccessHistoryWriterServiceUpgrader.java:51) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at sailpoint.server.upgrade.AccessHistoryWriterServiceUpgrader.performUpgrade(AccessHistoryWriterServiceUpgrader.java:22) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at sailpoint.server.upgrade.framework.BaseUpgrader.execute(BaseUpgrader.java:138) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at sailpoint.server.ImportCommand$Execute.execute(ImportCommand.java:2249) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at sailpoint.server.upgrade.Upgrader.executeCommand(Upgrader.java:1978) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at sailpoint.server.upgrade.Upgrader.executeUpgraderGroup(Upgrader.java:1845) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at sailpoint.server.upgrade.Upgrader.executeAndUpdateVersion(Upgrader.java:1823) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at sailpoint.server.upgrade.Upgrader.executeHibernateCommands(Upgrader.java:1221) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at sailpoint.server.upgrade.Upgrader.execute(Upgrader.java:1110) [identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at sailpoint.server.upgrade.Patcher.main(Patcher.java:45) [identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[?:?]
        at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
        at java.lang.reflect.Method.invoke(Method.java:569) ~[?:?]
        at sailpoint.launch.Launcher.main(Launcher.java:248) [identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
Caused by: java.lang.IllegalStateException: Found loading entities during flush
        at sailpoint.persistence.SailPointInterceptor.preFlush(SailPointInterceptor.java:500) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at org.hibernate.event.internal.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:79) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:102) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1362) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:453) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3212) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2380) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:447) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:183) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:281) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersistenceManager.java:571) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        ... 17 more
2025-07-04T00:09:36,500 ERROR main sailpoint.server.upgrade.Patcher:48 - Found loading entities during flush
sailpoint.tools.GeneralException: Found loading entities during flush
        at sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersistenceManager.java:586) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at sailpoint.persistence.ClassPersistenceManager.commitTransaction(ClassPersistenceManager.java:211) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at sailpoint.server.InternalContext.commitTransaction(InternalContext.java:601) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at sailpoint.server.upgrade.AccessHistoryWriterServiceUpgrader.removeAccessHistorySvc(AccessHistoryWriterServiceUpgrader.java:51) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at sailpoint.server.upgrade.AccessHistoryWriterServiceUpgrader.performUpgrade(AccessHistoryWriterServiceUpgrader.java:22) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at sailpoint.server.upgrade.framework.BaseUpgrader.execute(BaseUpgrader.java:138) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at sailpoint.server.ImportCommand$Execute.execute(ImportCommand.java:2249) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at sailpoint.server.upgrade.Upgrader.executeCommand(Upgrader.java:1978) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at sailpoint.server.upgrade.Upgrader.executeUpgraderGroup(Upgrader.java:1845) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at sailpoint.server.upgrade.Upgrader.executeAndUpdateVersion(Upgrader.java:1823) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at sailpoint.server.upgrade.Upgrader.executeHibernateCommands(Upgrader.java:1221) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at sailpoint.server.upgrade.Upgrader.execute(Upgrader.java:1110) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at sailpoint.server.upgrade.Patcher.main(Patcher.java:45) [identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[?:?]
        at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
        at java.lang.reflect.Method.invoke(Method.java:569) ~[?:?]
        at sailpoint.launch.Launcher.main(Launcher.java:248) [identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
Caused by: java.lang.IllegalStateException: Found loading entities during flush
        at sailpoint.persistence.SailPointInterceptor.preFlush(SailPointInterceptor.java:500) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        at org.hibernate.event.internal.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:79) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:102) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1362) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:453) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3212) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2380) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:447) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:183) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:40) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:281) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
        at sailpoint.persistence.HibernatePersistenceManager.commitTransaction(HibernatePersistenceManager.java:571) ~[identityiq.jar:8.4p2 Build a559eb467b2-20241211-210440]
        ... 17 more

Share all details about your problem, including any error messages you may have received.

I have started helping @bikashagarwalla1 by setting up similar setup in my local PC and it is a continuation of other ticket: Using Aurora PostGreSQL for IIQ 8.4

note:
it’s a fresh installation, no data apart from spadmin.

please refer above mention ticket for iiq.properties and log traces during application startup on IIQ 8.4.

steps followed:
IIQ 8.4 setup up and running.

  1. stop application server
  2. copied identityiq-8.4p2.jar to identityiq deployment folder
  3. jar -xvf identityiq-8.4p2.jar
  4. executed the upgrade script \i upgrade_identityiq_tables-8.4p2.postgresql – we can observe the schema_version update to 8.4.88 as show above screenshot. (no errors)
  5. iiq patch 8.4p2 – failed, please find above console output.
2

I’ve managed to fix the patch deployment. I redid everything, and the new changes made a big difference for a successful deployment.

NEW CHANGES:

  1. LCM Module Enabled.

import init-lcm.xml

  1. Disabled Messaging services from UI
    (Gear Icon – Global Settings – Messaging Configuration)
  2. Disabled Access History from UI
    (Gear Icon – Global Settings – Access History Configuration)
  3. Disabled Data Extract from UI
    {Gear Icon – Global Settings – Data Extract Configuration}

patch console output:

Patch [8.4p2] applied successfully!

C:\Users\Chaithu\Downloads\apache-tomcat-9.0.106-windows-x64\apache-tomcat-9.0.106\webapps\identityiq\WEB-INF\bin>iiq patch 8.4p2
adding exports for Java 17
------------------------------------
 Executing IdentityIQ Patch [8.4p2]
------------------------------------
LCM Enabled.  Importing LCM Patch [8.4p2]
AI Disabled.
FAM Disabled.
CAM Disabled.
PAM Disabled.


[1/9] Execute: WebResourcesUpgrader
    - Removing rights for WebResource of url systemSetup/messageBusConfig.*
    - Removing ActiveMQ from Debug WebResource
    - Removing rights for WebResource of url debug/activemq.*
    - Modifying rights for WebResource of url debug/connections.* to ViewAccessConnectionsPage,FullAccessDebugPage
    - Elapsed Time: 61 milliseconds

[2/9] Execute: AccessHistoryWriterServiceUpgrader
    - Elapsed Time: 32 milliseconds

[3/9] Execute: EmbeddedBrokerServiceUpgrader
    - Elapsed Time: 0 milliseconds

[4/9] Execute: DataExtractCfgUpgrader
    - Elapsed Time: 15 milliseconds

[5/9] Execute: MessageBusUpgrader
    - Removing ViewAccessActiveMQPage from DebugPagesReadOnlyAccess
    - Removing FullAccessMessageBusConfiguration from MessageBusAdministrator
    - Removing FullAccessMessageBusConfiguration from DataExtractAdministrator
    - Removing FullAccessMessageBusConfiguration from AccessHistoryAdministrator
    - Removing FullAccessMessageBusConfiguration SPRight
    - Removing ViewAccessActiveMQPage SPRight
2025-07-04T22:06:06,259  WARN main engine.jdbc.spi.SqlExceptionHelper:137 - SQL Error: 0, SQLState: 22003
2025-07-04T22:06:06,259 ERROR main engine.jdbc.spi.SqlExceptionHelper:142 - Bad value for type long : import sailpoint.object.*;
        import sailpoint.tools.Util;
        import sailpoint.web.messages.MessageKeys;
        if (Util.otob(taskDefinition.getArgument("exclusions"))){
          report.setDisablePreview(true);
          report.setDisablePreviewMessage(MessageKeys.REPT_CERT_PREVIEW_DISABLED_EXCLUSIONS);
        } else {
          report.setDisablePreview(false);
          report.setDisablePreviewMessage(null);
        }
2025-07-04T22:06:06,269 ERROR main sailpoint.tools.xml.ReferenceSerializer:118 - Error resolving references to tag='Reference' class='sailpoint.object.Rule' name=Certification Report Customizer' id='c0a8466a97d61e7a8197d67eb260022f' exception='sailpoint.tools.GeneralException: Could not read entity state from ResultSet : EntityKey[sailpoint.object.Rule#c0a8466a97d61e7a8197d67eb260022f]'
2025-07-04T22:06:06,332  WARN main engine.jdbc.spi.SqlExceptionHelper:137 - SQL Error: 0, SQLState: 22003
2025-07-04T22:06:06,332 ERROR main engine.jdbc.spi.SqlExceptionHelper:142 - Bad value for type long : import sailpoint.object.*;
        import sailpoint.reporting.ReportingLibrary;

        ObjectConfig identityConfig = ObjectConfig.getObjectConfig(Identity.class);
        List standardAttributes = new ArrayList();
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("firstname"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("lastname"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("displayName"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("email"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("manager"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("inactive"));

        ReportingLibrary.addAttributes(context, report, Identity.class, standardAttributes, null,
          "Identity Attributes", locale, "id");

        List extendedAttrs = new ArrayList();
        for(ObjectAttribute att : identityConfig.getSearchableAttributes()){
          if (!att.isStandard())
            extendedAttrs.add(att);
        }

        for(ObjectAttribute att : identityConfig.getMultiAttributeList()){
            extendedAttrs.add(att);
        }

        ReportingLibrary.addAttributes(context, report, Identity.class, extendedAttrs, null,
          "Identity Extended Attributes", locale, "id");
2025-07-04T22:06:06,332 ERROR main sailpoint.tools.xml.ReferenceSerializer:118 - Error resolving references to tag='Reference' class='sailpoint.object.Rule' name=Identity Report Form Customizer' id='c0a8466a97d61e7a8197d67eb0ca020c' exception='sailpoint.tools.GeneralException: Could not read entity state from ResultSet : EntityKey[sailpoint.object.Rule#c0a8466a97d61e7a8197d67eb0ca020c]'
2025-07-04T22:06:06,348  WARN main engine.jdbc.spi.SqlExceptionHelper:137 - SQL Error: 0, SQLState: 22003
2025-07-04T22:06:06,348 ERROR main engine.jdbc.spi.SqlExceptionHelper:142 - Bad value for type long : import sailpoint.object.*;
        import sailpoint.reporting.ReportingLibrary;

        ObjectConfig identityConfig = ObjectConfig.getObjectConfig(Identity.class);
        List standardAttributes = new ArrayList();
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("firstname"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("lastname"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("displayName"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("email"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("manager"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("inactive"));

        ReportingLibrary.addAttributes(context, report, IdentityEntitlement.class, standardAttributes, "identity",
          "Identity Attributes", locale, "id");


        List extendedAttrs = new ArrayList();
        for(ObjectAttribute att : identityConfig.getSearchableAttributes()){
          if (!att.isStandard())
            extendedAttrs.add(att);
        }

        for(ObjectAttribute att : identityConfig.getMultiAttributeList()){
            extendedAttrs.add(att);
        }

        ReportingLibrary.addAttributes(context, report, IdentityEntitlement.class, extendedAttrs, "identity",
          "Identity Extended Attributes", locale, "id");
2025-07-04T22:06:06,348 ERROR main sailpoint.tools.xml.ReferenceSerializer:118 - Error resolving references to tag='Reference' class='sailpoint.object.Rule' name=Identity Entitlement Identity Report Form Customizer' id='c0a8466a97d61e7a8197d67eb122020f' exception='sailpoint.tools.GeneralException: Could not read entity state from ResultSet : EntityKey[sailpoint.object.Rule#c0a8466a97d61e7a8197d67eb122020f]'
2025-07-04T22:06:06,348  WARN main engine.jdbc.spi.SqlExceptionHelper:137 - SQL Error: 0, SQLState: 22003
2025-07-04T22:06:06,348 ERROR main engine.jdbc.spi.SqlExceptionHelper:142 - Bad value for type long : import sailpoint.object.*;
        import sailpoint.reporting.ReportingLibrary;

        ObjectConfig linkConfig = ObjectConfig.getObjectConfig(Link.class);
        ReportingLibrary.addAttributes(context, report, Link.class, linkConfig.getSearchableAttributes(), null,
          "Account Properties", locale);
2025-07-04T22:06:06,348 ERROR main sailpoint.tools.xml.ReferenceSerializer:118 - Error resolving references to tag='Reference' class='sailpoint.object.Rule' name=Account Report Form Customizer' id='c0a8466a97d61e7a8197d67eb1780211' exception='sailpoint.tools.GeneralException: Could not read entity state from ResultSet : EntityKey[sailpoint.object.Rule#c0a8466a97d61e7a8197d67eb1780211]'
2025-07-04T22:06:06,410  WARN main engine.jdbc.spi.SqlExceptionHelper:137 - SQL Error: 0, SQLState: 22003
2025-07-04T22:06:06,410 ERROR main engine.jdbc.spi.SqlExceptionHelper:142 - Bad value for type long : import sailpoint.object.*;
        import sailpoint.reporting.ReportingLibrary;

        ObjectConfig linkConfig = ObjectConfig.getObjectConfig(Link.class);
        ReportingLibrary.addAttributes(context, report, Link.class, linkConfig.getSearchableAttributes(), null,
          "Privileged Account Attributes", locale, "id");


        ObjectConfig identityConfig = ObjectConfig.getObjectConfig(Identity.class);
        List standardAttributes = new ArrayList();
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("firstname"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("lastname"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("displayName"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("email"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("manager"));
        standardAttributes.add(identityConfig.getObjectAttributeMap().get("inactive"));

        ReportingLibrary.addAttributes(context, report, Identity.class, standardAttributes, "identity",
          "Identity Properties", locale, "id");

        List extendedAttrs = new ArrayList();
        for(ObjectAttribute att : identityConfig.getSearchableAttributes()){
          if (!att.isStandard())
            extendedAttrs.add(att);
        }

        for(ObjectAttribute att : identityConfig.getMultiAttributeList()){
            extendedAttrs.add(att);
        }

        ReportingLibrary.addAttributes(context, report, Identity.class, extendedAttrs, "identity",
          "Identity Extended Properties", locale, "id");
2025-07-04T22:06:06,410 ERROR main sailpoint.tools.xml.ReferenceSerializer:118 - Error resolving references to tag='Reference' class='sailpoint.object.Rule' name=Privileged Access Report Customizer' id='c0a8466a97d61e7a8197d67eb2f40247' exception='sailpoint.tools.GeneralException: Could not read entity state from ResultSet : EntityKey[sailpoint.object.Rule#c0a8466a97d61e7a8197d67eb2f40247]'
2025-07-04T22:06:06,426  WARN main engine.jdbc.spi.SqlExceptionHelper:137 - SQL Error: 0, SQLState: 22003
2025-07-04T22:06:06,426 ERROR main engine.jdbc.spi.SqlExceptionHelper:142 - Bad value for type long : import java.util.*;
       import sailpoint.object.*;
       import sailpoint.tools.Message;
       List messages = new ArrayList();

       Form.Section section = form.getSection("Privileged Account Attributes");
       if (section != null) {
         boolean found = false;
         for(FormItem item : section.getItems()){
           Field field = (Field)item;
           if(field.getValue() != null && !field.getValue().equals("") && !field.getValue().equals("null")) {
             found = true;
           }
         }

         if (!found) {
           messages.add(Message.localize("rept_priv_access_err_no_attr"));
         }
       } else {
         messages.add(Message.localize("rept_priv_attr_setup_needed"));
       }

       return messages;
2025-07-04T22:06:06,426 ERROR main sailpoint.tools.xml.ReferenceSerializer:118 - Error resolving references to tag='Reference' class='sailpoint.object.Rule' name=Privileged Access Report Validation Rule' id='c0a8466a97d61e7a8197d67eb3160248' exception='sailpoint.tools.GeneralException: Could not read entity state from ResultSet : EntityKey[sailpoint.object.Rule#c0a8466a97d61e7a8197d67eb3160248]'
    - Elapsed Time: 774 milliseconds

[6/9] Execute: ProxyApplicationUpgrader
    - Elapsed Time: 16 milliseconds

[7/9] Include: WEB-INF/config/patch/identityiq-8.4p2-objects.xml
    - Elapsed Time: 1 seconds

[8/9] Execute: AHDETasksUpgrader
    - forcePublishWrapper attribute now set to false on Configuration DataExtractConfiguration
    - dequeueRetryWaitInterval attribute removed from RequestDefinition Data Extract Partition
    - numDequeueRetries attribute removed from RequestDefinition Data Extract Partition
    - Elapsed Time: 32 milliseconds

[9/9] Include: WEB-INF/config/patch/identityiq-lcm-8.4p2-objects.xml
    - Elapsed Time: 204 milliseconds

-----------------
 Upgrade Summary
-----------------
     Elapsed Time: 12 seconds
     Log Location: C:\Users\Chaithu\Downloads\apache-tomcat-9.0.106-windows-x64\apache-tomcat-9.0.106\webapps\identityiq\WEB-INF\bin\patch_8_4p2_070425_220556.log
Commands Executed: 9
        - Execute: WebResourcesUpgrader                                  [OK] (61ms)
        - Execute: AccessHistoryWriterServiceUpgrader                    [OK] (32ms)
        - Execute: EmbeddedBrokerServiceUpgrader                         [OK] (0ms)
        - Execute: DataExtractCfgUpgrader                                [OK] (15ms)
        - Execute: MessageBusUpgrader                                    [OK] (774ms)
        - Execute: ProxyApplicationUpgrader                              [OK] (16ms)
        - Include: WEB-INF/config/patch/identityiq-8.4p2-objects.xml     [OK] (1s)
        - Execute: AHDETasksUpgrader                                     [OK] (32ms)
        - Include: WEB-INF/config/patch/identityiq-lcm-8.4p2-objects.xml [OK] (204ms)


-------------------------------------
 Patch [8.4p2] applied successfully!
-------------------------------------