My Oracle Support Banner

Role's Membership Evaluation for more than 4000 Organizations Throws in Logs: Exceeded maximum VARRAY limit [[ java.sql.SQLException: Exceeded maximum VARRAY limit (Doc ID 2663835.1)

Last updated on JANUARY 19, 2022

Applies to:

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

Symptoms

An administrator starts creating a role 

 

 

 

 

on the rule membership section we add a rule that includes Organization

 


 

 

on clicking Add the following error is thrown:

 

 

Logs show the following stack trace:

[2020-04-27T10:19:15.455-06:00] [oim_server1] [ERROR] [] [oracle.iam.oimdataproviders.impl] [tid: [ACTIVE].ExecuteThread: 'XX' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: XXX] [ecid: XXX] [APP: oim] [partition-name: DOMAIN] [tenant-name: GLOBAL] [DSID: XXX] Exceeded maximum VARRAY limit [[

java.sql.SQLException: Exceeded maximum VARRAY limit

at oracle.jdbc.oracore.OracleTypeCOLLECTION.pickle81(OracleTypeCOLLECTION.java:285)

at oracle.jdbc.oracore.OracleTypeADT.pickle81(OracleTypeADT.java:1826)

at oracle.jdbc.oracore.OracleTypeADT.linearize(OracleTypeADT.java:1466)

at oracle.sql.ArrayDescriptor.toBytes(ArrayDescriptor.java:655)

at oracle.sql.ARRAY.toBytes(ARRAY.java:682)

at oracle.jdbc.driver.OraclePreparedStatement.setArrayCritical(OraclePreparedStatement.java:5927)

at oracle.jdbc.driver.OraclePreparedStatement.setARRAYInternal(OraclePreparedStatement.java:5890)

at oracle.jdbc.driver.OraclePreparedStatement.setArray(OraclePreparedStatement.java:5852)

at oracle.jdbc.driver.OraclePreparedStatementWrapper.setArray(OraclePreparedStatementWrapper.java:130)

at weblogic.jdbc.wrapper.PreparedStatement.setArray(PreparedStatement.java:340)

at oracle.iam.oimdataproviders.impl.OIMDataProvider.search(OIMDataProvider.java:1464)

at oracle.iam.oimdataproviders.impl.OIMDataProvider.search(OIMDataProvider.java:1248)

at oracle.iam.oimdataproviders.impl.OIMRoleGrantRelationProvider.navigatePreview(OIMRoleGrantRelationProvider.java:119)

at oracle.iam.identity.rolemgmt.impl.RoleManagerImpl.previewDynamicUserMembership(RoleManagerImpl.java:4302)

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.