Azure AD aggregation issue - could not load an entity: [sailpoint.object.Identity#]

IdentityIQ (IIQ) IIQ Discussion and Questions
1

IIQ 8.4p3

Hi,

One of the Azure account aggregation failed with below message:

ERROR QuartzScheduler_Worker-2 sailpoint.api.Aggregator:1916 - Exception during aggregation of xyz. Reason: could not load an entity: [sailpoint.object.Identity#xyz] at sailpoint.persistence.HibernatePersistenceManager.getObjectById(HibernatePersistenceManager.java:694) ~[identityiq.jar:8.4p3 Build 30f52882581-20250902-165538]
at sailpoint.persistence.ClassPersistenceManager.getObjectById(ClassPersistenceManager.java:265) ~[identityiq.jar:8.4p3 Build 30f52882581-20250902-165538]
at sailpoint.server.InternalContext.getObjectById(InternalContext.java:643) ~[identityiq.jar:8.4p3 Build 30f52882581-20250902-165538]
at sailpoint.api.Identitizer.refresh(Identitizer.java:2331) ~[identityiq.jar:8.4p3 Build 30f52882581-20250902-165538]
at sailpoint.api.Aggregator.finishLastIdentity(Aggregator.java:4825) [identityiq.jar:8.4p3 Build 30f52882581-20250902-165538]
at sailpoint.api.Aggregator.aggregateAccount(Aggregator.java:3713) [identityiq.jar:8.4p3 Build 30f52882581-20250902-165538]
at sailpoint.api.Aggregator.aggregateAccounts(Aggregator.java:3404) [identityiq.jar:8.4p3 Build 30f52882581-20250902-165538]
at sailpoint.api.Aggregator.primaryAccountAggregation(Aggregator.java:2988) [identityiq.jar:8.4p3 Build 30f52882581-20250902-165538]
at sailpoint.api.Aggregator.aggregateApplication(Aggregator.java:2836) [identityiq.jar:8.4p3 Build 30f52882581-20250902-165538]
at sailpoint.api.Aggregator.phaseAggregate(Aggregator.java:2703) [identityiq.jar:8.4p3 Build 30f52882581-20250902-165538]
at sailpoint.api.Aggregator.execute(Aggregator.java:2200) [identityiq.jar:8.4p3 Build 30f52882581-20250902-165538]
at sailpoint.task.ResourceIdentityScan.doUnpartitioned(ResourceIdentityScan.java:251) [identityiq.jar:8.4p3 Build 30f52882581-20250902-165538]
at sailpoint.task.ResourceIdentityScan.execute(ResourceIdentityScan.java:231) [identityiq.jar:8.4p3 Build 30f52882581-20250902-165538]
at sailpoint.api.TaskManager.runSync(TaskManager.java:981) [identityiq.jar:8.4p3 Build 30f52882581-20250902-165538]
at sailpoint.api.TaskManager.runSync(TaskManager.java:764) [identityiq.jar:8.4p3 Build 30f52882581-20250902-165538]
at sailpoint.scheduler.JobAdapter.execute(JobAdapter.java:128) [identityiq.jar:8.4p3 Build 30f52882581-20250902-165538]
at org.quartz.core.JobRunShell.run(JobRunShell.java:202) [quartz-2.3.2.jar:?]
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) [quartz-2.3.2.jar:?]
Caused by: org.hibernate.exception.GenericJDBCException: could not load an entity: [sailpoint.object.Identity#0a7f8a049bc81e0e819bff7569183fa8]
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.loader.Loader.loadEntity(Loader.java:2426) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:72) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:61) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.persister.entity.AbstractEntityPersister.doLoad(AbstractEntityPersister.java:4442) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:4432) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:569) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:537) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:208) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:332) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.event.internal.DefaultLoadEventListener.doOnLoad(DefaultLoadEventListener.java:108) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:74) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:113) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.fireLoadNoChecks(SessionImpl.java:1186) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1175) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.access$2100(SessionImpl.java:193) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.doLoad(SessionImpl.java:2786) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.lambda$load$1(SessionImpl.java:2767) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.perform(SessionImpl.java:2723) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.load(SessionImpl.java:2767) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.get(SessionImpl.java:983) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at sailpoint.persistence.HibernatePersistenceManager.getObjectById(HibernatePersistenceManager.java:692) ~[identityiq.jar:8.4p3 Build 30f52882581-20250902-165538]
… 17 more
Caused by: java.sql.SQLException: Not a navigable ResultSet.
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121) ~[mysql-connector-j-9.3.0.jar:9.3.0]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-j-9.3.0.jar:9.3.0]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:81) ~[mysql-connector-j-9.3.0.jar:9.3.0]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:55) ~[mysql-connector-j-9.3.0.jar:9.3.0]
at com.mysql.cj.jdbc.result.ResultSetImpl.next(ResultSetImpl.java:1807) ~[mysql-connector-j-9.3.0.jar:9.3.0]
at org.apache.commons.dbcp2.DelegatingResultSet.next(DelegatingResultSet.java:1160) ~[commons-dbcp2-2.9.0.jar:2.9.0]
at org.apache.commons.dbcp2.DelegatingResultSet.next(DelegatingResultSet.java:1160) ~[commons-dbcp2-2.9.0.jar:2.9.0]
at org.hibernate.loader.Loader.getRowsFromResultSet(Loader.java:1035) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.loader.Loader.processResultSet(Loader.java:990) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.loader.Loader.doQuery(Loader.java:959) ~[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.doQueryAndInitializeNonLazyCollections(Loader.java:319) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.loader.Loader.loadEntity(Loader.java:2422) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:72) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:61) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.persister.entity.AbstractEntityPersister.doLoad(AbstractEntityPersister.java:4442) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:4432) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:569) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:537) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:208) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:332) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.event.internal.DefaultLoadEventListener.doOnLoad(DefaultLoadEventListener.java:108) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:74) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:113) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.fireLoadNoChecks(SessionImpl.java:1186) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1175) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.access$2100(SessionImpl.java:193) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.doLoad(SessionImpl.java:2786) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.lambda$load$1(SessionImpl.java:2767) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.perform(SessionImpl.java:2723) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.load(SessionImpl.java:2767) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at org.hibernate.internal.SessionImpl.get(SessionImpl.java:983) ~[hibernate-core-5.4.27.Final.jar:5.4.27.Final]
at sailpoint.persistence.HibernatePersistenceManager.getObjectById(HibernatePersistenceManager.java:692) ~[identityiq.jar:8.4p3 Build 30f52882581-20250902-165538]
… 17 more

Though next aggregations ran successfully, can anyone help with the cause and what can be done to avoid it in future?

2

@himabindu306 Is this error coming frequently or just one off case?

3

@himabindu306 it likely occurred due to a momentary connection issue or a race condition in the connection pool. Once the failed connection was evicted and a fresh one was obtained, subsequent operations worked fine.

Can you also review and share the identity: 0a7f8a049bc81e0e819bff7569183fa8 ?Does it have any corrupt data?

4

Hello Himabindhu. The key error I noticed is java.sql.SQLException: Not a navigable ResultSet from the MySQL JDBC driver. The could not load an entity message appears to be Hibernate wrapping that JDBC failure, so this does not look like an Azure AD source-side issue.

Since the later aggregations completed successfully, it may have been a transient database or JDBC issue. I would suggest checking the IIQ and database logs around that time and confirming that mysql-connector-j-9.3.0 is the intended driver for your IIQ 8.4p3 environment.

5

Thank you for the response Neelmadhav, we have seen the issue for first time and the user data looks fine and is not corrupted.

6

@himabindu306 It seems some issue with identity level , can you please run the aggregation of same identity from other source application is it working?
For azure single identity aggregation working?
Does user already have azure account in sailpoint?
If user already having and the issue is coming for only single application then delete the link from sailpoint ui and save identity then retry.
If still issue is coming then try to run IDX support plugin task it will correct the identity.
If still issue is there then we need to add more logs , for one org i have seen that some role throwing the error and then we find one single role creating this problem.
As you already mentioned this aggregation work in next aggregation that means this identity being used or something on that instace , try to reproduce this issue with above process.
Majorly these issue are due to data or identity locked or decache related only

7

You might check the 8.5p2 release notes. I think they addressed this in that patch.

8

@himabindu306 Is this error still coming or it was just one off case?