My Oracle Support Banner

"Exceeded maximum VARRAY limit" Error When HelpDesk Admin Users Searches For Users & Organizations With More Than 4000 Entries (Doc ID 2496543.1)

Last updated on MAY 14, 2019

Applies to:

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


In OIG 12c, HelpDesk Admin users unable to search Users & Organizations when there are more than 4000 Users Or Organizations in the system. The following error is thrown in the log file. The issue does not occur with "xelsysadm" user. But with any user that has "HelpDesk" admin role.

[2018-11-26T18:13:16.478-05:00] [oim_server1] [ERROR] [] [oracle.iam.oimdataproviders.impl] [tid: [ACTIVE].ExecuteThread: '32' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <USER_ID>] [ecid: 6b9aaf63-c092-4ba3-a45c-9041a6e03af0-0000012f,0] [APP: oim] [partition-name: DOMAIN] [tenant-name: GLOBAL] [DSID: 0000MTIHe5oECS8Lrih8iY1Rz7mJ000001] 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.platform.entitymgr.impl.EntityManagerImpl.findEntities(


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.