When executing the Refresh Application Scores task, the following error may be encountered:
ERROR QuartzScheduler_Worker-3
sailpoint.api.TaskManager:685 - Exception: [could not execute query]
sailpoint.tools.GeneralException: could not execute query
at sailpoint.server.InternalContext.getObject(InternalContext.java:550)
at sailpoint.api.ScoreKeeper.refreshIndex(ScoreKeeper.java:1665)
at sailpoint.api.ScoreKeeper.scoreApplications(ScoreKeeper.java:1606)
at sailpoint.api.ScoreKeeper.scoreApplications(ScoreKeeper.java:1580)
at sailpoint.task.ApplicationScorer.execute(ApplicationScorer.java:73)
at sailpoint.api.TaskManager.runSync(TaskManager.java:664)
at sailpoint.scheduler.JobAdapter.execute(JobAdapter.java:116)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: sailpoint.tools.GeneralException: could not execute query
at
sailpoint.persistence.HibernatePersistenceManager.getObjects(HibernatePersistenceManager.java:1673)
at
sailpoint.persistence.ClassPersistenceManager.getObjects(ClassPersistenceManager.java:272)
at
sailpoint.server.InternalContext.getObjects(InternalContext.java:821)
at sailpoint.server.InternalContext.getObject(InternalContext.java:538)
... 8 more
Caused by: org.hibernate.QueryTimeoutException: could not execute query
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:124)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2297)
at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2204)
at org.hibernate.loader.Loader.list(Loader.java:2164)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:448)
at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
at
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at
sailpoint.persistence.HibernatePersistenceManager.getObjects(HibernatePersistenceManager.java:1669)
... 11 more
Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded
ORA-01000: maximum open cursors exceeded
This may occur in spite of configuring the Oracle database to support a MAX_CURSORS value as large as 7000. The number of cursors leaked by the Refresh Scorecard Task may be reduced by installing the odbcj6.jar driver provided by Oracle. IdentityIQ installations using MySQL and MSSQLServer do not manifest this open cursor leaking behavior when running the task. This issue is also more pronounced in scenarios where users each have multiple scorecards.
The IIQ 6.2 release has been tested and is known to leak fewer cursors under these circumstances.
ETN 16548