Which IIQ version are you inquiring about?
8.4
Please share any images or screenshots, if relevant.
[Please insert images here, otherwise delete this section]
Please share any other relevant files that may be required (for example, logs).
[Please insert files here, otherwise delete this section]
Share all details about your problem, including any error messages you may have received.
2025-11-04T04:32:36,728 WARN Thread-99016 engine.jdbc.spi.SqlExceptionHelper:137 - SQL Error: 1792, SQLState: 25006 2025-11-04T04:32:36,728 ERROR Thread-99016 engine.jdbc.spi.SqlExceptionHelper:142 - Cannot execute statement in a READ ONLY transaction. 2025-11-04T04:32:36,728 ERROR Thread-99016 sailpoint.task.IdentityRefreshExecutor:1649 - RefreshWorker 1 exception: org.hibernate.exception.GenericJDBCException: could not extract ResultSet sailpoint.tools.GeneralException: org.hibernate.exception.GenericJDBCException: could not extract ResultSet at sailpoint.persistence.HibernatePersistenceManager.lockObject(HibernatePersistenceManager.java:996) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] at sailpoint.persistence.ClassPersistenceManager.lockObject(ClassPersistenceManager.java:254) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] at sailpoint.server.InternalContext.lockObject(InternalContext.java:677) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] at sailpoint.api.ObjectUtil.lockObjectInternal(ObjectUtil.java:2404) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] at sailpoint.api.ObjectUtil.lockObject(ObjectUtil.java:2292) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] at sailpoint.api.ObjectUtil.lockObject(ObjectUtil.java:2378) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] at sailpoint.api.ObjectUtil.lockIdentityById(ObjectUtil.java:2584) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] at sailpoint.api.ObjectUtil.lockIdentity(ObjectUtil.java:2672) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] at sailpoint.api.ObjectUtil.lockIdentity(ObjectUtil.java:2694) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] at sailpoint.task.IdentityRefreshExecutor$RefreshWorker.refreshAndProcess(IdentityRefreshExecutor.java:1589) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] at sailpoint.task.IdentityRefreshExecutor$RefreshWorkerPool.queue(IdentityRefreshExecutor.java:1928) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] at sailpoint.request.IdentityRefreshRequestExecutor.refresh(IdentityRefreshRequestExecutor.java:487) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] at sailpoint.request.IdentityRefreshRequestExecutor.execute(IdentityRefreshRequestExecutor.java:209) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] at sailpoint.request.RequestHandler.run(RequestHandler.java:163) [identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] Caused by: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not extract ResultSet at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1602) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at sailpoint.persistence.HibernatePersistenceManager.lockObject(HibernatePersistenceManager.java:1086) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] at sailpoint.persistence.HibernatePersistenceManager.lockObject(HibernatePersistenceManager.java:989) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] … 13 more Caused by: org.hibernate.exception.GenericJDBCException: could not extract ResultSet at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.getResultSet(Loader.java:2304) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2057) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2019) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.doQuery(Loader.java:948) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.doList(Loader.java:2850) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.doList(Loader.java:2832) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2664) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.list(Loader.java:2659) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:506) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1414) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1625) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1593) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at sailpoint.persistence.HibernatePersistenceManager.lockObject(HibernatePersistenceManager.java:1086) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] at sailpoint.persistence.HibernatePersistenceManager.lockObject(HibernatePersistenceManager.java:989) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] … 13 more Caused by: java.sql.SQLException: Cannot execute statement in a READ ONLY transaction. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130) ~[mysql-connector-java-8.0.33.jar:8.0.33] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.33.jar:8.0.33] at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916) ~[mysql-connector-java-8.0.33.jar:8.0.33] at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972) ~[mysql-connector-java-8.0.33.jar:8.0.33] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) ~[commons-dbcp2-2.9.0.jar:2.9.0] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) ~[commons-dbcp2-2.9.0.jar:2.9.0] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.getResultSet(Loader.java:2304) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2057) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2019) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.doQuery(Loader.java:948) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.doList(Loader.java:2850) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.doList(Loader.java:2832) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2664) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.Loader.list(Loader.java:2659) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:506) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1414) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1625) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1593) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final] at sailpoint.persistence.HibernatePersistenceManager.lockObject(HibernatePersistenceManager.java:1086) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] at sailpoint.persistence.HibernatePersistenceManager.lockObject(HibernatePersistenceManager.java:989) ~[identityiq.jar:8.4 Build bdd0ed4de58-20230919-192552] … 13 more