cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Refresh application scores task generates ORA-01000 error

Refresh application scores task generates ORA-01000 error

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

Labels (2)
Version history
Revision #:
2 of 2
Last update:
‎Mar 15, 2023 09:22 PM
Updated by:
 
Contributors