T2T Batch Failed With Datatype Mismatch and ORA-12899 (Doc ID 2774672.1)

Last updated on SEPTEMBER 18, 2023

Applies to:

Symptoms

When running T2T_CUSTOM_SWAPS_CONTRACTS to load data, the following error occurs.

Error:
Batch Monitor shows:
53786 [10862] Fetched information regarding the given Information Domain INFORM 2021-04-21 14:03:24
53787 [10900] Loading Failed, exceeded the reject threshold FATAL 2021-04-21 14:03:26
53788 [14407] No. of records failed for issues like datatype mismatch->0 INFORM 2021-04-21 14:03:26
53789 [14408] Back from loader:rows loaded->0 INFORM 2021-04-21 14:03:26
53790 [14880] Back from Loader: Rows Rejected-> 91001 INFORM 2021-04-21 14:03:26
53791 [10865] Loading Failed.

/ftpshare/logs/<AS_OF_DATE>/<INFODOM>/LOAD DATA/LOAD DATA_<BATCH NAME>_Task30_T2TCPP.log shows:
LOG ERRORS INTO STG_SWAPS_CONTRACTS$ ('<BATCH_NAME>') REJECT LIMIT UNLIMITED
[21-04-21 19:03:26 GMT PM][SEVERE][BACKEND][OFSAA][T2TCPP] ClsUBatchLoader::LoadData, BATCH MODE, Loading Failed, Number of erroneous records exceeded the reject limit
[21-04-21 19:03:26 GMT PM][INFO][BACKEND][OFSAA][T2TCPP] ClsUBatchLoader::LoadData, BATCH MODE, No. of records failed for other reasons (INSERT statement preparation, Datatype mismatch etc.) : 0


select * from  STG_SWAPS_CONTRACTS$  where  ORA_ERR_TAG$ ='<BATCH NAME>' shows:
"D_LAST_ACTIVITY_DATE","F_DVP_RVP_IND","V_LEAD_BANK_ID","F_CCP_ACCEPT_CASH_VM_IND","N_CUSIP","V_CUSIP_DESC"
12899,"ORA-12899: value too large for column ""ATOMIC"".""STG_SWAPS_CONTRACTS"".""F_EXCHG_OF_PRINCIPAL"" (actual: 8, maximum: 1)


 

Changes

Cause

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