My Oracle Support Banner

OIA Combo Import From OIM Fails With "ERROR- ORA-01795: maximum number of expressions in a list is 1000" (Doc ID 1598874.1)

Last updated on JUNE 14, 2017

Applies to:

Oracle Identity Analytics - Version to [Release 11gR2]
Information in this document applies to any platform.


In an OIM11gR2 and OIM11gPS1 BP05 environment, when an "Import of Users, Accounts and Entitlements" job is run in Full Mode, it fails with following exception:

ERROR   Error retrieving exception; nested exception is org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar [];
nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred while applying a parameter map.
--- Check the findRoleGrantsByIds-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000



This issue happens only in OIA11gPS1 BP05 or later when following batch sizes are increased to a value more than 1000 defined in for import jobs:




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.