After OIM+OIA Integration, Import Combo Job Fails with "ORA-12899: value too large for column" (Doc ID 1554426.1)

Last updated on OCTOBER 03, 2016

Applies to:

Oracle Identity Analytics - Version 11.1.1.5.1 and later
Information in this document applies to any platform.

Symptoms

In an integrated OIM11gR2 BP04 with OIA 11.1.1.5 environment, getting following error when combo import job is run:

ERROR [ConcurrentAccountImporterHelper] SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [72000]; error code [12899]; ORA-12899: value too large for column "RBACXSERVICE"."ACCOUNTS"."ACCESS_POLICY_NAME" (actual: 31, maximum: 30)
; nested exception is java.sql.BatchUpdateException: ORA-12899: value too large for column "RBACXSERVICE"."ACCOUNTS"."ACCESS_POLICY_NAME" (actual: 31, maximum: 30)



Changes

 OIM and OIA integrated with Preferred method.

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