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 220.127.116.11.5 to 18.104.22.168.6 [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:
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 iam.properties 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!