OFSAAI T2T Batch Failing - No Specific Error in Log (Doc ID 1600493.1)

Last updated on OCTOBER 04, 2016

Applies to:

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

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) infrastructure, when attempting to run a Table to Table (T2T) batch, the following error occurs in the log file in $FIC_DB_HOME/log/t2t:

ERROR
Log Message here 1: Wed 13 Nov 2013 12:51:57 AM GMT||DEBUG||Executing Insert Query
Log Message here 1: Wed 13 Nov 2013 01:00:32 AM GMT||SEVERE||ClsUDBConnect::executeInsertQuery, Error, unable to execute the insert query. ERROR Message:
Log Message here 1: Wed 13 Nov 2013 01:00:32 AM GMT||DEBUG||ClsUBatchLoader::Bulk : Error Messaage :
Log Message here 1: Wed 13 Nov 2013 01:00:32 AM GMT||DEBUG||ClsUTableToTableLoad::Bulk, Failed, no. of rows loaded: 0
Log Message here 1: Wed 13 Nov 2013 01:00:32 AM GMT||DEBUG||ClsUTableToTableLoad::updateETLLoadHistory, INFO, insert query for ETLLoadHistory table : INSERT into ETLLoadHistory values('RBSDOM_OFSAA_MMR_NWB_Cont_Results_20130628_5','Task1','RBSDOM','OFSAA_LOCAL_SP_T2T_Stream_1',1,'FCT_COMMON_ACCOUNT_SUMMARY','MMR_NWB_Contracts',to_date('20130628','YYYYMMDD'),to_date('2013-11-13 0:50:00','yyyy-mm-dd HH24:mi:ss'),to_date('2013-11-13 1:0:00','yyyy-mm-dd HH24:mi:ss'),5444934,0,0,1,'LF',0,'',0,null,null,null,null,null,'MMR_NWB_Contracts',0,'NO')
Log Message here 1: Wed 13 Nov 2013 01:00:32 AM GMT||SEVERE||ClsUTableToTableLoad::ExtractLoad, Error, unable to perform direct table to table load
Log Message here 1: Wed 13 Nov 2013 01:00:32 AM GMT||INFO||Status from extract load ... 1


The log file indicates there is an error but no error message is listed.

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