Indirect Relationship Processing fails with 'ORA-12899 value too large for column' error in RSA Identity Governance & Lifecycle
Originally Published: 2017-02-02
Article Number
Applies To
RSA Version/Condition: 7.0.1
Issue
The following error is logged to the aveksaServer.log file ($AVEKSA_HOME/wildfly/standalone/log/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)
Please refer to RSA Knowledge Base Article 000030327 -- Artifacts to gather in RSA Identity Governance & Lifecycle to find the location of the aveksaServer.log file for your specific deployment if you are on a WildFly cluster or a non-WildFly platform. The aveksaServer.log may also be downloaded from the RSA Identity Governance & Lifecycle user interface (Admin > System > Server Nodes tab > under Logs).
Cause
This is a known issue reported in engineering ticket ACM-71796.
Resolution
- RSA Identity Governance & Lifecycle 7.0.2 P03
- RSA Identity Governance & Lifecycle 7.1.0
Notes
- 000038826 -- Indirect Relationship Processing fails with ORA-30926 and 'ORA-06512: at "AVUSER.CE_USERS" ' errors when collecting Groups in RSA Identity Governance & Lifecycle
- 000034893 -- Indirect Relationship Processing fails with ORA-30926 and 'ORA-06512: at "AVUSER.CE_USERS" ' errors after Migration to 7.0.1 P02 of RSA Identity Governance & Lifecycle ORA-30926
Related Articles
ORA-12899: value too large for column "AVUSER"."STX_450689643"."OBJECT_TYPE" when importing a coverage file into an RSA Id… Number of Views Review escalation workflows do not trigger if review is set to Hold by an escalation workflow after due date in RSA Identi… Number of Views RSA Governance & Lifecycle 7.5.2 Public Database Schema Reference Number of Views Menu bar on the top and footer section in the bottom on the UI are not visible after applying patch in RSA Governance & Li… Number of Views Collector run fails during the data collection task with an ORA-12899 or ORA-01722 error in RSA Governance & Lifecycle Number of Views
Trending Articles
Troubleshooting RSA SecurID Access Identity Router to RSA Authentication Manager test connection failures RSA SecurID Software Token 5.0.2 Downloads for Microsoft Windows RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Governance & Lifecycle 8.0.0 Administrators Guide Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory
Don't see what you're looking for?
