Errors Importing Transactions Using UCM Import MAXIMUM ERROR COUNT EXCEEDED (Doc ID 2894520.1)

Last updated on JULY 19, 2024

Applies to:

Symptoms

Importing transactions with large datafile that have 300,000 - 400,000 records.

From 30764283.log
Extracted dDocName :ZJKPHGXCKI
submit.argument1 : ICMTransactionImport_CWM_TXN_DTL_20220812184649.zip
submit.argument2 : 56914977
retainFile : N
retrieved File : destinationFileName:ICMTransactionImport_CWM_TXN_DTL_20220812184649.zip
------------------------------------------
... etc ...

Starting the SQL Loader

SQL*Loader: Release 19.0.0.0.0 - Production on Sun Aug 14 23:42:12 2022
Version 19.5.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.

Path used: Conventional
Commit point reached - logical record count 12
Commit point reached - logical record count 24
Commit point reached - logical record count 36
Commit point reached - logical record count 48
Commit point reached - logical record count 60
Commit point reached - logical record count 72
Commit point reached - logical record count 84
Commit point reached - logical record count 96
Commit point reached - logical record count 108
Commit point reached - logical record count 120
Commit point reached - logical record count 132
Commit point reached - logical record count 144
Commit point reached - logical record count 156

Table CN_TP_TRANSACTIONS_STAGING_T:
99 Rows successfully loaded.

From CnTxnInterface.log
...
Record 150: Rejected - Error on table CN_TP_TRANSACTIONS_STAGING_T, column SOURCE_TRX_NUMBER.

ORA-12899: value too large for column ??? ( actual: 31, maximum: 30)

MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run.

Table CN_TP_TRANSACTIONS_STAGING_T:
99 Rows successfully loaded.
51 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded becaue all fields were null

Space allocated for bind array: 1017744 bytes ( 12 rows )
Red buffer bytes: 1048576

Total logical records skipped: 1
Total logical records read: 156
Total logical records rejected: 51
Total logical records discarded: 0

Run began on Sun Aug 14 23:42:12 2022
Run ended on Sun Aug 14 23:42:14 2022

Cause

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