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

[#1]

Article Number

000034745

Applies To

RSA Product Set: RSA Identity Governance and Lifecycle
RSA Product/Service Type: Appliance
RSA Version/Condition: 7.0
Platform: Linux
O/S Version: SUSE Linux

Issue

An 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

Cause

For 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.
 

Resolution

The source data being collected for the attribute IS_TERMINATED needs to be modified so that it is a BOOLEAN.