Search Using CatalogService API Fails with ORA-01795 (Doc ID 1952673.1)

Last updated on OCTOBER 04, 2016

Applies to:

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

Symptoms

Exception

ORA-01795 maximum number of expressions in a list is 1000

is thrown from database when executing search using CatalogService API.

Stacktrace:

java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
...
    at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
    at oracle.iam.catalog.repository.DBRepository.populateTheHierarchicalDataForCatalog(DBRepository.java:3684)
    at oracle.iam.catalog.util.Utility.getCatalogVoFromResultSet(Utility.java:186)
    at oracle.iam.catalog.repository.DBRepository.executeFindClosedCatalog(DBRepository.java:2616)
    at oracle.iam.catalog.repository.DBRepository.findCatalog(DBRepository.java:2501)
    at oracle.iam.catalog.impl.CatalogServiceImpl.findCatalog(CatalogServiceImpl.java:260)
...

Cause

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 hundreds of Community platforms