Entitlement List Schedule Job not Working for Target System that has +1million Entitlements (Doc ID 2132528.1)

Last updated on OCTOBER 20, 2016

Applies to:

Identity Manager - Version 11.1.2.2.7 and later
Information in this document applies to any platform.

Symptoms

Entitlement List Schedule Job not working for target system has +1million entitlement

OOTB Oracle DB target system integrated with IDM.
Oracle DB has 3 type of entitlements which are Privileges , Roles and Objects.
Privileges count is around 6000, Roles count is around 12000, Objects count is more than 1300000.

When Running Entitlement List job to refresh entitlements, which are already in lookup, new entitlements not inserting into ent_list table.


Error seen in log when job is run

[2016-04-01T10:07:49.073+03:00] [oim_server1] [ERROR] [] [XELLERATE.SCHEDULER.TASK]... [APP: oim#11.1.2.0.0] Class/Method: tcEntitlementListLoad/getEntitlementForForm encounter some problems: Data Access Error
[2016-04-01T10:07:49.074+03:00] [oim_server1] [ERROR] [] [XELLERATE.SERVER]... [APP: oim#11.1.2.0.0] Class/Method: StatementUtil/setStatement encounter some problems: Dataset is not open[[
com.thortech.xl.dataaccess.tcDataSetException: Dataset is not open
at com.thortech.xl.dataaccess.tcDataSet.checkOpen(tcDataSet.java:4346)
at com.thortech.xl.dataaccess.tcDataSet.getRowCount(tcDataSet.java:467)
at com.thortech.xl.dataobj.StatementUtil.getDataSet(StatementUtil.java:79)
at com.thortech.xl.schedule.tasks.tcEntitlementListLoad.getEntitlementForForm(tcEntitlementListLoad.java:1024)
at com.thortech.xl.schedule.tasks.tcEntitlementListLoad.execute(tcEntitlementListLoad.java:186)
at com.thortech.xl.scheduler.tasks.SchedulerBaseTask.execute(SchedulerBaseTask.java:385)
at oracle.iam.scheduler.vo.TaskSupport.invokeExecute(TaskSupport.java:270)
at oracle.iam.scheduler.vo.TaskSupport.access$000(TaskSupport.java:46)
.
.
2016-04-01T10:07:49.074+03:00] [oim_server1] [ERROR] [] [XELLERATE.SCHEDULER.TASK]... [APP: oim#11.1.2.0.0] Class/Method: tcEntitlementListLoad/processData encounter some problems: Dataset is not open
[2016-04-01T10:07:49.100+03:00] [oim_server1] [ERROR] [] [XELLERATE.JAVACLIENT]... [APP: oim#11.1.2.0.0] Class/Method: tcDataBaseClient/getInterface encounter some problems: RuntimeException encountered. Reconnecting![[
javax.ejb.EJBException: [EJB:010107]The lock request from EJB:tcDataBase with primary key:... timed-out after waiting 0 ms. The transaction or thread requesting the lock was:Name=[EJB com.thortech.xl.ejb.interfaces.tcDataBaseEJB.isOpenx(java.lang.String)],...]).; nested exception is: weblogic.ejb20.locks.LockTimedOutException: [EJB:010107]The lock request from EJB:tcDataBase with primary key:... timed-out after waiting 0 ms. The transaction or thread requesting the lock was:Name=[EJB com.thortech.xl.ejb.interfaces.tcDataBaseEJB.isOpenx(java.lang.String)]...



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms