My Oracle Support Banner

Rule Membership for Role and Admin Role Throwing: oracle.iam.identity.exception.OrganizationManagerException: java.sql.SQLException: Exceeded maximum VARRAY limit (Doc ID 2678536.1)

Last updated on JUNE 08, 2020

Applies to:

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


In an OIM environment with more than 4000 Organizations


an administrator tries to create a Role or Admin Role Rule Membership that contains the Organization field.


On trying to create the rule the following error is thrown in the logs:

java.sql.SQLException: Exceeded maximum VARRAY limit


and the following error will be thrown in the logs:


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(




The same error will be thrown by schedule jobs Refresh Role Membership and Refresh Admin-Role Memberships if when we create the rule membership we d






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.