My Oracle Support Banner

"SQLException: Exceeded maximum VARRAY limit" Error With Evaluate Membership Rule When For Few Thousands Of Users (Doc ID 2476975.1)

Last updated on JULY 21, 2020

Applies to:

Identity Manager - Version 12.2.1.3.0 to 12.2.1.3.180920 [Release 12c]
Information in this document applies to any platform.

Symptoms

Using the "Evaluate membership rule now" option creates an exception and does not succeed when the user population is larger than a few thousand.

Steps
1. Create 5K users
2. Create Role with access policies
3. Approve the request which got created while create role.
4. Edit role and add member ship rule with prefix of 5000 users which got created in Step#1 and apply
5. Approve the request which got created in Step#4. UI does not show any error. But you can see below exception on logs.

 

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!


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