My Oracle Support Banner

OIG 12c REST / SCIM service to search users shows error : Java.sql.SQLException: Exceeded Maximum VARRAY Limit (Doc ID 2496796.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

Oracle Identity Governance version 12c is used for running user search operation using OIM API (REST / SCIM / JAVA) . 

In this scenario , for a user which has been assigned more than 1000 organizations which in turn are attached to Admin Role OrgAdministrator and "Include Sub-org" option is checked, when searching using SCIM or JAVA api , no results are returned .



When the same user is set without "Include sub-org" results are returned correctly .

Following error is captured in OIM server diagnostic log when the search operation is executed : 

[oracle.iam.oimdataproviders.impl] [tid: [ACTIVE].ExecuteThread: '19' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: EEGOORG001] [ecid:f6ae284d-ca23-4ac7-b764-935eb0faf4b5-0000b385,0] [APP: oim] [partition-name:
DOMAIN] [tenant-name: GLOBAL] Exceeded maximum VARRAY limit [[ java.sql.SQLException: Exceeded maximum VARRAY limit

The above error are listed in various other scenarios which are listed here : 

The scenarios which show this new issue are :

a.) Login as end user to which the sub-orgs are assigned and navigate to Manage - Users and select the search button .

b.) Login as end user to which the sub-orgs are assigned and navigate to Self-Service - My Access

c.) Login as end user to which the sub-orgs are assigned and navigate to Self-Service - My Access - Admin Roles - Select Organization Administrator or User Viewer Roles , observe the lower pane .

No values are being populated for the following columns :


Organization
Parent Organization
Type
Membership Type

Only manage heirarchy is populated . Attachment uploaded illustrating this issue .

d.) Login as end user to which the sub-orgs are assigned and navigate to Manage - Organization - select the search icon .

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.