000034745 - RSA Identity Governance and Lifecycle Identity Data Unification fails with ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind in

Document created by RSA Customer Support Employee on May 30, 2017
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000034745
Applies ToRSA Product Set: RSA Identity Governance and Lifecycle
RSA Product/Service Type: Appliance
RSA Version/Condition: 7.0
Platform: Linux
O/S Version: SUSE Linux
IssueAn Identity Collector fails in step 4/10 Process Unified User Data.  The aveksaServer.log file records the following error:
01/20/2017 11:52:59.667 INFO (Exec Task Consumer#7) [com.aveksa.server.xfw.UnificationExecutor] Failed method=Process subTask=CompleteMergeTasks Default User Population, 8620 
com.aveksa.server.db.PersistenceException: java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind 
ORA-06512: at "AVUSER.UNFC_USERS", line 1036 
ORA-06512: at "AVUSER.UNFC_USERS", line 840 
ORA-06512: at "AVUSER.UNFC_PROCESSOR", line 136 
ORA-06512: at "AVUSER.UNFC_PROCESSOR", line 27
CauseFor the Collector, the values being collected for IS_TERMINATED are not BOOLEAN.  For example, the value should be a single character, and in the range 1, 0, Y or N.
 
ResolutionThe source data being collected for the attribute IS_TERMINATED needs to be modified so that it is a BOOLEAN.

Attachments

    Outcomes