Incremental ETL Failed With the Error " ORA-01405: fetched column value is NULL" (Doc ID 1559831.1)

Last updated on MAY 10, 2017

Applies to:

Oracle Argus Insight - Version 6.0.5 and later
Information in this document applies to any platform.
***Checked for relevance on 10-MAY-2017***
***Checked for relevance on 06-Jul-2015***

Symptoms

Incremental ETL FAILED to complete with the following error:
 
 Total ETL Time => 0 Hours 16 Mins 4 Seconds
 
 ETL Start Time => 04-JUN-2013 11:00:11 PM
 ETL End Time => 04-JUN-2013 11:16:15 PM
 
 Error Message = ORA-01405: fetched column value is NULL
 ORA-06512: at "SYS.DBMS_CRYPTO_FFI", line 159
 ORA-06512: at "SYS.DBMS_CRYPTO", line 86
 ORA-06512: at "SM_MART.PKG_SM_STORM", line 332

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms