Today, I performed another fresh installation. Initially, the application came up and was accessible, even after I had disabled the messaging service from the UI. However, upon restarting the application, I was then unable to access it.
Stack trace:
2025-07-04T17:47:29,110 ERROR main sailpoint.messagebus.impl.ActiveMQMessageServiceManager:120 - The ActiveMQ JDBCAdapter class has not been supplied and broker setup is unable to continue.
2025-07-04T17:47:29,170 ERROR main sailpoint.messagebus.impl.ActiveMQMessageServiceManager:217 - There has been an error when setting up the broker persistence.
sailpoint.tools.GeneralException: The ActiveMQ JDBCAdapter class has not been supplied and broker setup is unable to continue.
at sailpoint.messagebus.impl.ActiveMQMessageServiceManager.startupBrokerService(ActiveMQMessageServiceManager.java:121) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at sailpoint.messagebus.impl.ActiveMQMessageServiceManager.start(ActiveMQMessageServiceManager.java:96) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at sailpoint.server.EmbeddedBrokerService.start(EmbeddedBrokerService.java:53) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at sailpoint.server.Servicer.startStartupService(Servicer.java:384) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at sailpoint.server.Servicer.configureStartup(Servicer.java:367) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at sailpoint.server.Environment.start(Environment.java:455) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at sailpoint.server.SystemStarter.springInit(SystemStarter.java:59) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
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 org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1925) ~[spring-beans-5.2.24.RELEASE.jar:5.2.24.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1867) ~[spring-beans-5.2.24.RELEASE.jar:5.2.24.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1795) ~[spring-beans-5.2.24.RELEASE.jar:5.2.24.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:594) ~[spring-beans-5.2.24.RELEASE.jar:5.2.24.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516) ~[spring-beans-5.2.24.RELEASE.jar:5.2.24.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324) ~[spring-beans-5.2.24.RELEASE.jar:5.2.24.RELEASE]
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) [spring-beans-5.2.24.RELEASE.jar:5.2.24.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) [spring-beans-5.2.24.RELEASE.jar:5.2.24.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) [spring-beans-5.2.24.RELEASE.jar:5.2.24.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:311) [spring-beans-5.2.24.RELEASE.jar:5.2.24.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) [spring-beans-5.2.24.RELEASE.jar:5.2.24.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:897) [spring-beans-5.2.24.RELEASE.jar:5.2.24.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:879) [spring-context-5.2.24.RELEASE.jar:5.2.24.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:551) [spring-context-5.2.24.RELEASE.jar:5.2.24.RELEASE]
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:144) [spring-context-5.2.24.RELEASE.jar:5.2.24.RELEASE]
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:85) [spring-context-5.2.24.RELEASE.jar:5.2.24.RELEASE]
at sailpoint.spring.SpringStarter.start(SpringStarter.java:333) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at sailpoint.web.StartupContextListener.contextInitialized(StartupContextListener.java:91) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552]
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4059) [catalina.jar:9.0.106]
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4501) [catalina.jar:9.0.106]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164) [catalina.jar:9.0.106]
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:599) [catalina.jar:9.0.106]
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:571) [catalina.jar:9.0.106]
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:603) [catalina.jar:9.0.106]
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1174) [catalina.jar:9.0.106]
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1883) [catalina.jar:9.0.106]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539) [?:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:76) [tomcat-util.jar:9.0.106]
at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:123) [?:?]
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1085) [catalina.jar:9.0.106]
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470) [catalina.jar:9.0.106]
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1579) [catalina.jar:9.0.106]
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:312) [catalina.jar:9.0.106]
at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:109) [catalina.jar:9.0.106]
at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:389) [catalina.jar:9.0.106]
at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:336) [catalina.jar:9.0.106]
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:776) [catalina.jar:9.0.106]
at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:721) [catalina.jar:9.0.106]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164) [catalina.jar:9.0.106]
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1203) [catalina.jar:9.0.106]
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1193) [catalina.jar:9.0.106]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:76) [tomcat-util.jar:9.0.106]
at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145) [?:?]
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:749) [catalina.jar:9.0.106]
at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:211) [catalina.jar:9.0.106]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164) [catalina.jar:9.0.106]
at org.apache.catalina.core.StandardService.startInternal(StandardService.java:412) [catalina.jar:9.0.106]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164) [catalina.jar:9.0.106]
at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:874) [catalina.jar:9.0.106]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164) [catalina.jar:9.0.106]
at org.apache.catalina.startup.Catalina.start(Catalina.java:739) [catalina.jar:9.0.106]
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 org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:345) [bootstrap.jar:9.0.106]
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:476) [bootstrap.jar:9.0.106]
2025-07-04T17:47:29,479 ERROR main sailpoint.messagebus.impl.ActiveMQMessageServiceManager:99 - An error has occurred when trying to start the activemq broker: There has been an error when setting up the broker persistence.
2025-07-04T17:47:29,487 ERROR main sailpoint.server.EmbeddedBrokerService:59 - Unable to start EmbeddedBrokerService
2025-07-04T17:47:29,492 WARN main springframework.context.support.ClassPathXmlApplicationContext:559 - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'systemStarter' defined in class path resource [iiqBeans.xml]: Invocation of init method failed; nested exception is sailpoint.tools.GeneralException: Required startup service [EmbeddedBroker] failed to start.
Jul 04, 2025 5:47:29 PM org.apache.catalina.core.StandardContext listenerStart
SEVERE: Exception sending context initialized event to listener instance of class [sailpoint.web.StartupContextListener]
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'systemStarter' defined in class path resource [iiqBeans.xml]: Invocation of init method failed; nested exception is sailpoint.tools.GeneralException: Required startup service [EmbeddedBroker] failed to start.
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1799)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:594)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516)
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:311)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:897)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:879)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:551)
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:144)
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:85)
at sailpoint.spring.SpringStarter.start(SpringStarter.java:333)
at sailpoint.web.StartupContextListener.contextInitialized(StartupContextListener.java:91)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4059)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4501)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:599)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:571)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:603)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1174)
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1883)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:76)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:123)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1085)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1579)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:312)
at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:109)
at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:389)
at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:336)
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:776)
at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:721)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1203)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1193)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:76)
at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145)
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:749)
at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:211)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164)
at org.apache.catalina.core.StandardService.startInternal(StandardService.java:412)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164)
at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:874)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:164)
at org.apache.catalina.startup.Catalina.start(Catalina.java:739)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:569)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:345)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:476)
Caused by: sailpoint.tools.GeneralException: Required startup service [EmbeddedBroker] failed to start.
at sailpoint.server.Servicer.startStartupService(Servicer.java:389)
at sailpoint.server.Servicer.configureStartup(Servicer.java:367)
at sailpoint.server.Environment.start(Environment.java:455)
at sailpoint.server.SystemStarter.springInit(SystemStarter.java:59)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:569)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1925)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1867)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1795)
... 56 more
Caused by: sailpoint.tools.GeneralException: Unable to start EmbeddedBrokerService
at sailpoint.server.EmbeddedBrokerService.start(EmbeddedBrokerService.java:60)
at sailpoint.server.Servicer.startStartupService(Servicer.java:384)
... 66 more
04-Jul-2025 17:43:08.580 SEVERE [main] org.apache.catalina.core.StandardContext.startInternal Context [/identityiq] startup failed due to previous errors
04-Jul-2025 17:43:08.642 WARNING [main] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [identityiq] registered the JDBC driver [org.postgresql.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
04-Jul-2025 17:43:08.642 WARNING [main] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [identityiq] appears to have started a thread named [Log4j2-TF-3-Scheduled-1] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
[email protected]/jdk.internal.misc.Unsafe.park(Native Method)
[email protected]/java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:252)
[email protected]/java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:1679)
[email protected]/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1182)
[email protected]/java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:899)
[email protected]/java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1062)
[email protected]/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1122)
[email protected]/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
[email protected]/java.lang.Thread.run(Thread.java:840)
So, I thought of checking by deploying 8.4p2:
postgres=# \i upgrade_identityiq_tables-8.4p2.postgresql
Password for user identityiq:
You are now connected to database "identityiq" as user "identityiq".
Password for user identityiqah:
You are now connected to database "identityiqah" as user "identityiqah".
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 1
Password for user identityiq:
You are now connected to database "identityiq" as user "identityiq".
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 1
UPDATE 1
UPDATE 0
UPDATE 0
UPDATE 97
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 54
UPDATE 0
UPDATE 0
UPDATE 32
UPDATE 0
UPDATE 55
UPDATE 0
UPDATE 1
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 54
UPDATE 54
UPDATE 18
UPDATE 18
UPDATE 646
UPDATE 646
UPDATE 339
UPDATE 339
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 1
UPDATE 1
IIQ Patch 8.4p2: Failed with the following error. I have created another topic for this 8.4p2 - patch deployment “iiq patch 8.4p2” - errors - IdentityIQ (IIQ) / IIQ Discussion and Questions - SailPoint Developer Community
----------------------------------------------------------------------------
FAILURE: An unexpected error occurred: Found loading entities during flush
----------------------------------------------------------------------------
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: 79 milliseconds
[2/8] Execute: AccessHistoryWriterServiceUpgrader
2025-07-04T18:08:16,392 WARN main engine.jdbc.spi.SqlExceptionHelper:137 - SQL Error: 0, SQLState: 22003
2025-07-04T18:08:16,393 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-04T18:08:16,393 ERROR main sailpoint.tools.xml.ReferenceSerializer:118 - Error resolving references to tag='Reference' class='sailpoint.object.Rule' name=Certification Report Customizer' id='c0a8466a97d51e6f8197d59ea69a022f' exception='sailpoint.tools.GeneralException: Could not read entity state from ResultSet : EntityKey[sailpoint.object.Rule#c0a8466a97d51e6f8197d59ea69a022f]'
2025-07-04T18:08:16,455 WARN main engine.jdbc.spi.SqlExceptionHelper:137 - SQL Error: 0, SQLState: 22003
2025-07-04T18:08:16,455 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-04T18:08:16,455 ERROR main sailpoint.tools.xml.ReferenceSerializer:118 - Error resolving references to tag='Reference' class='sailpoint.object.Rule' name=Identity Report Form Customizer' id='c0a8466a97d51e6f8197d59ea523020c' exception='sailpoint.tools.GeneralException: Could not read entity state from ResultSet : EntityKey[sailpoint.object.Rule#c0a8466a97d51e6f8197d59ea523020c]'
2025-07-04T18:08:16,455 WARN main engine.jdbc.spi.SqlExceptionHelper:137 - SQL Error: 0, SQLState: 22003
2025-07-04T18:08:16,455 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-04T18:08:16,455 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='c0a8466a97d51e6f8197d59ea581020f' exception='sailpoint.tools.GeneralException: Could not read entity state from ResultSet : EntityKey[sailpoint.object.Rule#c0a8466a97d51e6f8197d59ea581020f]'
2025-07-04T18:08:16,471 WARN main engine.jdbc.spi.SqlExceptionHelper:137 - SQL Error: 0, SQLState: 22003
2025-07-04T18:08:16,471 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-04T18:08:16,471 ERROR main sailpoint.tools.xml.ReferenceSerializer:118 - Error resolving references to tag='Reference' class='sailpoint.object.Rule' name=Account Report Form Customizer' id='c0a8466a97d51e6f8197d59ea5cf0211' exception='sailpoint.tools.GeneralException: Could not read entity state from ResultSet : EntityKey[sailpoint.object.Rule#c0a8466a97d51e6f8197d59ea5cf0211]'
2025-07-04T18:08:16,565 WARN main engine.jdbc.spi.SqlExceptionHelper:137 - SQL Error: 0, SQLState: 22003
2025-07-04T18:08:16,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-04T18:08:16,565 ERROR main sailpoint.tools.xml.ReferenceSerializer:118 - Error resolving references to tag='Reference' class='sailpoint.object.Rule' name=Privileged Access Report Customizer' id='c0a8466a97d51e6f8197d59ea7460247' exception='sailpoint.tools.GeneralException: Could not read entity state from ResultSet : EntityKey[sailpoint.object.Rule#c0a8466a97d51e6f8197d59ea7460247]'
2025-07-04T18:08:16,565 WARN main engine.jdbc.spi.SqlExceptionHelper:137 - SQL Error: 0, SQLState: 22003
2025-07-04T18:08:16,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-04T18:08:16,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='c0a8466a97d51e6f8197d59ea7650248' exception='sailpoint.tools.GeneralException: Could not read entity state from ResultSet : EntityKey[sailpoint.object.Rule#c0a8466a97d51e6f8197d59ea7650248]'
-----------------
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_180806.log
Commands Executed: 1
- Execute: WebResourcesUpgrader [OK] (79ms)
----------------------------------------------------------------------------
FAILURE: An unexpected error occurred: Found loading entities during flush
----------------------------------------------------------------------------
2025-07-04T18:08:17,452 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-04T18:08:17,466 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
Conclusion: Given the sufficient evidence, the next step is to raise a support ticket with SailPoint.