My Oracle Support Banner

Getting error on Ingestion of TBML Data File (Doc ID 2834715.1)

Last updated on JANUARY 25, 2022

Applies to:

Oracle Financial Services Behavior Detection Platform - Version 8.0 and later
Information in this document applies to any platform.

Symptoms

Client is trying to ingest DocumentaryCollectionContractEvent_20211230_DLY_01.dat, records are rejected stating
"CTUF9194C0688/21~2~BOOK~20210909~~9194~IDC~~~~~CTUF9194C0688/21~20210617~~20220219~~~~USD~83000~~~~~~~~~~~T24~~~~~~~~~~~~~~~~~~~~~0~250001~~~~~~~~~~~~DLY~20211230~~~ failed DB validation. Reason: java.sql.SQLException: ORA-12899: value too large for column "OFSAAFCCMJS"."DOCMNTRY_COLL_CNTRCT_EVENT"."DOC_COLL_CNTRCT_INTRL_ID" (actual: 17, maximum: 16)
. Record will be rejected"

Although the records are of length 16, client is getting this error., tried increasing length in data map to 17 and as per log statistics "Total number of records: 100, loaded: 100, rejected: 0" no records are rejected but still there is a row rejected.

In this matter asking what to do as the data file contains the column having 16 characters string still they are getting this error.

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


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