My Oracle Support Banner

T2T Fails with 'Error, an error occured while trying to fetch data from the source DB' (Doc ID 2456804.1)

Last updated on MARCH 08, 2019

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) 8.0.x, when attempting to execute a T2T data load, some but not all records are loaded and the following error occurs in the <infodom>_<batch_name>_<misdate>_1_Task1_ttl.log from $FIC_DB_HOME/log/t2t:

Log Message here 1: Thu Aug 02 11:51:53 2018||SEVERE||ClsUBatchLoader::LoadData, Error, an error occured while trying to fetch data from the source DB
Log Message here 1: Thu Aug 02 11:51:53 2018||SEVERE||Back from loader : rows loaded -> 626688
Log Message here 1: Thu Aug 02 11:51:53 2018||DEBUG||Back from loader : rows rejected -> 0
Log Message here 1: Thu Aug 02 11:51:53 2018||DEBUG||Back from loader : Total number of src rows ->0
Log Message here 1: Thu Aug 02 11:51:53 2018||DEBUG||ClsUTableToTableLoad::updateETLLoadHistory, INFO, insert query for ETLLoadHistory table : INSERT into ETLLoadHistory values('OFSALMINFO_T2T_FEM_OFF_BALANCE_SHEET_2_20180430_1','Task1','OFSALMINFO','STAGE',1,'FEM_OFF_BALANCE_SHEET','T2T_FEM_OFF_BALANCE_SHEET_2',to_date('20180430','YYYYMMDD'),to_date('2018-8-2 11:48:00','yyyy-mm-dd HH24:mi:ss'),to_date('2018-8-2 11:51:00','yyyy-mm-dd HH24:mi:ss'),0,0,0,0,'LF',0,'',626688,null,null,null,null,null,'T2T_FEM_OFF_BALANCE_SHEET_2',0,'NO')
Log Message here 1: Thu Aug 02 11:51:53 2018||SEVERE||ClsUTableToTableLoad::ExtractLoad, Error, unable to perform table to table load
Log Message here 1: Thu Aug 02 11:51:53 2018||INFO||Status from extract load ... 1
Log Message here 1: Thu Aug 02 11:51:53 2018||DEBUG||T2TLoad::main, INFO, Status Returned from Table To Table Loading: 1


In the example above, there are 737,431 records in the source table but only 626,688 are loaded.

There are no records in the rejected records table <target_table>$.  You do not understand why all rows are not loaded.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.