Which IIQ version are you inquiring about?
8.5p2
Hi!
I’m getting error in step 5 of the 8.5p2 patch application. Can you guys help me figure it out?
------------------------------------
Executing IdentityIQ Patch [8.5p2]
LCM Enabled. Importing LCM Patch [8.5p2]
AI Disabled.
FAM Disabled.
CAM Disabled.
PAM Disabled.
[1/5] Execute: DataOwnerCertificationUpgrader
- Elapsed Time: 95 milliseconds
[2/5] Include: WEB-INF/config/patch/identityiq-8.5p2-objects.xml
- Elapsed Time: 1 seconds
[3/5] Execute: PopulationNameDecoderUpgrader
- Processing GroupDefinitions…16 objects.
- 6% - 1 of 16 processed (15 remaining)
- 18% - 3 of 16 processed (13 remaining)
- 31% - 5 of 16 processed (11 remaining)
- 43% - 7 of 16 processed (9 remaining)
- 56% - 9 of 16 processed (7 remaining)
- 68% - 11 of 16 processed (5 remaining)
- 81% - 13 of 16 processed (3 remaining)
- 93% - 15 of 16 processed (1 remaining)
- 100% - 16 of 16 processed (0 remaining)
- Elapsed Time: 174 milliseconds
[4/5] Execute: SMSResetConfigUpgrader
- Elapsed Time: 23 milliseconds
[5/5] Include: WEB-INF/config/patch/identityiq-lcm-8.5p2-objects.xml
- Elapsed Time: 511 milliseconds
2026-08-06T18:54:08,616 WARN ServerThread engine.jdbc.spi.SqlExceptionHelper:137 - SQL Error: 17002, SQLState: 08006
2026-08-06T18:54:08,619 ERROR ServerThread engine.jdbc.spi.SqlExceptionHelper:142 - IO Error: Socket read interrupted
2026-08-06T18:54:08,622 ERROR ServerThread sailpoint.server.Servicer:1171 - Unable to execute service: Cache
org.hibernate.exception.JDBCConnectionException: could not get next iterator result
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
at org.hibernate.internal.IteratorImpl.next(IteratorImpl.java:131)
at sailpoint.persistence.HibernatePersistenceManager$ProjectionResultIterator.next(HibernatePersistenceManager.java:2784)
at sailpoint.persistence.HibernatePersistenceManager$ProjectionResultIterator.next(HibernatePersistenceManager.java:2770)
at sailpoint.persistence.HibernatePersistenceManager.search(HibernatePersistenceManager.java:2229)
at sailpoint.persistence.ClassPersistenceManager.search(ClassPersistenceManager.java:347)
at sailpoint.server.InternalContext.search(InternalContext.java:959)
at sailpoint.server.AbstractSailPointContext.search(AbstractSailPointContext.java:293)
at sailpoint.api.CorrelationModel.loadRoleProjectionsAndInheritance(CorrelationModel.java:460)
at sailpoint.api.CorrelationModel.loadRoleLoadData(CorrelationModel.java:436)
at sailpoint.api.CorrelationModel.prepare(CorrelationModel.java:357)
at sailpoint.api.CorrelationModel.refresh(CorrelationModel.java:306)
at sailpoint.server.CacheService.execute(CacheService.java:273)
at sailpoint.server.Servicer.execute(Servicer.java:1168)
at sailpoint.server.Servicer.processServices(Servicer.java:1119)
at sailpoint.server.Servicer.run(Servicer.java:837)
Caused by: java.sql.SQLRecoverableException: IO Error: Socket read interrupted
at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1092)
at oracle.jdbc.driver.OracleStatement.fetchMoreRows(OracleStatement.java:3478)
at oracle.jdbc.driver.InsensitiveScrollableResultSet.fetchMoreRows(InsensitiveScrollableResultSet.java:742)
at oracle.jdbc.driver.InsensitiveScrollableResultSet.absoluteInternal(InsensitiveScrollableResultSet.java:698)
at oracle.jdbc.driver.InsensitiveScrollableResultSet.next(InsensitiveScrollableResultSet.java:412)
at org.apache.commons.dbcp2.DelegatingResultSet.next(DelegatingResultSet.java:1160)
at org.apache.commons.dbcp2.DelegatingResultSet.next(DelegatingResultSet.java:1160)
at org.hibernate.internal.IteratorImpl.postNext(IteratorImpl.java:85)
at org.hibernate.internal.IteratorImpl.next(IteratorImpl.java:126)
… 14 more
Caused by: java.io.InterruptedIOException: Socket read interrupted
at oracle.net.nt.TimeoutSocketChannel.handleInterrupt(TimeoutSocketChannel.java:319)
at oracle.net.nt.TimeoutSocketChannel.read(TimeoutSocketChannel.java:242)
at oracle.net.ns.NSProtocolNIO.doSocketRead(NSProtocolNIO.java:673)
at oracle.net.ns.NIOPacket.readHeader(NIOPacket.java:269)
at oracle.net.ns.NIOPacket.readPacketFromSocketChannel(NIOPacket.java:201)
at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:143)
at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:116)
at oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel(NIONSDataChannel.java:91)
at oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:791)
at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:449)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:410)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270)
at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1079)
… 22 more
2026-08-06T18:54:08,650 ERROR ServerThread sailpoint.api.SailPointFactory:468 - Could not close context: Unable to rollback against JDBC Connection
sailpoint.tools.GeneralException: Unable to rollback against JDBC Connection
at sailpoint.persistence.HibernatePersistenceManager.close(HibernatePersistenceManager.java:671)
at sailpoint.persistence.ClassPersistenceManager.close(ClassPersistenceManager.java:232)
at sailpoint.server.InternalContext.close(InternalContext.java:616)
at sailpoint.api.SailPointFactory.releaseContext(SailPointFactory.java:465)
at sailpoint.api.SailPointFactory.releaseContext(SailPointFactory.java:492)
at sailpoint.api.SailPointFactory.releaseContext(SailPointFactory.java:488)
at sailpoint.server.Servicer.processServices(Servicer.java:1136)
at sailpoint.server.Servicer.run(Servicer.java:837)
Caused by: org.hibernate.TransactionException: Unable to rollback against JDBC Connection
at org.hibernate.resource.jdbc.internal.AbstractLogicalConnectionImplementor.rollback(AbstractLogicalConnectionImplementor.java:127)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.rollback(JdbcResourceLocalTransactionCoordinatorImpl.java:304)
at org.hibernate.engine.transaction.internal.TransactionImpl.rollback(TransactionImpl.java:142)
at sailpoint.persistence.HibernatePersistenceManager.close(HibernatePersistenceManager.java:661)
… 7 more
Caused by: java.sql.SQLRecoverableException: Closed Connection
at oracle.jdbc.driver.PhysicalConnection.getAutoCommit(PhysicalConnection.java:2150)
at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:2279)
at org.apache.commons.dbcp2.DelegatingConnection.rollback(DelegatingConnection.java:781)
at org.apache.commons.dbcp2.DelegatingConnection.rollback(DelegatingConnection.java:781)
at sailpoint.persistence.ConnectionWrapper.rollback(ConnectionWrapper.java:191)
at org.hibernate.resource.jdbc.internal.AbstractLogicalConnectionImplementor.rollback(AbstractLogicalConnectionImplementor.java:121)
… 10 more
-----------------
Upgrade Summary
Elapsed Time: 14 seconds
Log Location: /opt/sailpoint/tomcat/webapps/ROOT/WEB-INF/bin/patch_8_5p2_080626_185354.log
Commands Executed: 5
- Execute: DataOwnerCertificationUpgrader [OK] (95ms)
- Include: WEB-INF/config/patch/identityiq-8.5p2-objects.xml [OK] (1s)
- Execute: PopulationNameDecoderUpgrader [OK] (174ms)
- Execute: SMSResetConfigUpgrader [OK] (23ms)
- Include: WEB-INF/config/patch/identityiq-lcm-8.5p2-objects.xml [OK] (511ms)