Active Directory Account Data Collectors are failing in pre-processing in RSA Identity Governance & Lifecycle
Originally Published: 2017-08-01
Article Number
Applies To
RSA Version/Condition: 7.0.1, 7.0.2
Issue
01/05/2017 07:52:15.266 ERROR (Exec Task Consumer#0) [com.aveksa.server.xfw.TaskExecutor] Failed method=Execute ExecutionTask[TaskID=159 RunID=71 Source=5 Type=DataObjectProcessing Status=InProgress] com.aveksa.server.xfw.ExecutionException: com.aveksa.server.collector.DataProcessorException: com.aveksa.server.db.PersistenceException: java.sql.SQLDataException: ORA-01861: literal does not match format string ORA-06512: at "AVUSER.ADC_NORMALIZE", line 148 ORA-06512: at "AVUSER.ADC_NORMALIZE", line 1447 ORA-06512: at "AVUSER.ADC_DATA_COLLECTOR", line 218 ORA-06512: at "AVUSER.ADC_DATA_COLLECTOR", line 466 ORA-06512: at line 1
Cause
This error usually indicates that we are trying to collect something into a Date Field, but it is exceeding the Oracle's Max value.
Resolution
Related Articles
Account Collector for Authentication Manager is not reading Disabled Accounts correctly in Identity Geovernance and Lifecy… Number of Views Cannot avoid circuit breaker abort for scheduled Identity Data Collector (IDC) collections in RSA Identity Governance & Li… Number of Views The RSA Governance & Lifecycle Raw Data table for collection run IDs is empty Number of Views How to make the Oracle INITCAP function work to format raw data collected from a csv file during Identity Data Collection … Number of Views Identity Data Collector (IDC) collection fails with the error: "ORA-00918: column ambiguously defined" during the Identit… Number of Views
Don't see what you're looking for?
