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 and later
Information in this document applies to any platform.


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(

at oracle.jdbc.oracore.OracleTypeADT.pickle81(

at oracle.jdbc.oracore.OracleTypeADT.linearize(

at oracle.sql.ArrayDescriptor.toBytes(

at oracle.sql.ARRAY.toBytes(

at oracle.jdbc.driver.OraclePreparedStatement.setArrayCritical(

at oracle.jdbc.driver.OraclePreparedStatement.setARRAYInternal(

at oracle.jdbc.driver.OraclePreparedStatement.setArray(

at oracle.jdbc.driver.OraclePreparedStatementWrapper.setArray(

at weblogic.jdbc.wrapper.PreparedStatement.setArray(



at oracle.iam.oimdataproviders.impl.OIMRoleGrantRelationProvider.navigatePreview(

at oracle.iam.identity.rolemgmt.impl.RoleManagerImpl.previewDynamicUserMembership(


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

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