000034775 - Indirect Relationship Processing SQLException ORA-12899 value too large for column in RSA Identity Governance and Lifecycle

Document created by RSA Customer Support Employee on Feb 7, 2017Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000034775
Applies ToRSA Product Set: Identity Governance and Lifecycle
RSA Product/Service Type: Appliance
RSA Version/Condition: 7.0.1
IssueAn Indirect Relationship Processing failure displats the following error in the aveksaServer.log:
01/23/2017 15:16:26.407 ERROR (Exec Task Consumer#0) [com.aveksa.server.xfw.TaskExecutor] Failed method=Execute 
ExecutionTask[TaskID=251222 RunID=101923 Source=2962 Type=EntitlementExplosionProcessing Status=InProgress]
com.aveksa.server.xfw.ExecutionException: com.aveksa.server.db.PersistenceException:
java.sql.SQLException: ORA-12899: value too large for column "AVUSER"."GTT_CE_INDIRECTS"."ROOTCHILDNAME" (actual: 263, maximum: 256)
ORA-06512: at "AVUSER.CE_ACCOUNTS", line 402
ORA-06512: at "AVUSER.CE_ACCOUNTS", line 973
ORA-06512: at "AVUSER.COMMON_EXPLODER", line 298
ORA-06512: at "AVUSER.COMMON_EXPLODER", line 117
ORA-06512: at line 1
at com.aveksa.server.xfw.EntitlementExplosionProcessingExecutor.executeTask(EntitlementExplosionProcessingExecutor.java:54)
at com.aveksa.server.xfw.TaskExecutor.execute(TaskExecutor.java:99)
at com.aveksa.server.xfw.ExecutionTaskQueue$Worker.run(ExecutionTaskQueue.java:116)
at java.lang.Thread.run(Thread.java:745)
CauseAn entitlement name is over 254 characters in width. This may be due to bad data coming in from a collection run or an issue with your database schema.
ResolutionPlease open a case with RSA Customer Support to help review the data and determine the best course of action.