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

Symptoms

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(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)

 

 

Note

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

 

 

Changes

 

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
Changes
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.