FCCM NPRD - Mar 1 Daily Batch Has Failed
(Doc ID 2958026.1)
Last updated on JULY 03, 2023
Applies to:
Oracle Financial Services Crime and Compliance Management Transaction Monitoring Cloud Service - Version NA and laterInformation in this document applies to any platform.
Symptoms
FCCM NPRD Mar 1 Daily batch has failed with below error in UB_AMLDataLoad_220722_2023-03-01_1_TransactionPipeline.log
[ERROR] 2023-06-02 09:54:14.240 [http-nio-8080-exec-5] DataLoadingService - DELETE_CTL_FILE::: Error occurred in deleting existing file: load_data_20230301_stg_casa.ctl
[ERROR] 2023-06-02 09:54:14.240 [http-nio-8080-exec-5] DataLoadingService - DELETE_BAD_CSV_FILE::: Error occurred in deleting existing file: load_data_20230301_stg_casa_bad.csv
[ERROR] 2023-06-02 09:54:14.246 [http-nio-8080-exec-5] DataLoadingService - Some Bad Records
--
[DEBUG] 2023-06-02 09:54:14.096 [http-nio-8080-exec-5] DataLoadingService - Record 1: Rejected - Error on table STG_CASA_TXNS_TEMP_1167929275, column V_SERVICE_CHARGE_CODE.
[DEBUG] 2023-06-02 09:54:14.096 [http-nio-8080-exec-5] DataLoadingService - Field in data file exceeds maximum length
[DEBUG] 2023-06-02 09:54:14.096 [http-nio-8080-exec-5] DataLoadingService - Record 68: Rejected - Error on table STG_CASA_TXNS_TEMP_1167929275, column FIC_MIS_DATE.
[DEBUG] 2023-06-02 09:54:14.096 [http-nio-8080-exec-5] DataLoadingService - ORA-01400: cannot insert NULL into (FIC_MIS_DATE)
[DEBUG] 2023-06-02 09:54:14.097 [http-nio-8080-exec-5] DataLoadingService -
[DEBUG] 2023-06-02 09:54:14.097 [http-nio-8080-exec-5] DataLoadingService - Table STG_CASA_TXNS_TEMP_1167929275:
[DEBUG] 2023-06-02 09:54:14.097 [http-nio-8080-exec-5] DataLoadingService - 66 Rows successfully loaded.
[INFO ] 2023-06-02 09:54:14.097 [http-nio-8080-exec-5] DataLoadingService - Rows successfully loaded : 66
[DEBUG] 2023-06-02 09:54:14.097 [http-nio-8080-exec-5] DataLoadingService - 2 Rows not loaded due to data errors.
[INFO ] 2023-06-02 09:54:14.097 [http-nio-8080-exec-5] DataLoadingService - Rows not loaded due to data errors : 2
[DEBUG] 2023-06-02 09:54:14.097 [http-nio-8080-exec-5] DataLoadingService - 0 Rows not loaded because all WHEN clauses were failed.
[INFO ] 2023-06-02 09:54:14.097 [http-nio-8080-exec-5] DataLoadingService - Rows not loaded because all WHEN clauses were failed : 0
[DEBUG] 2023-06-02 09:54:14.097 [http-nio-8080-exec-5] DataLoadingService - 0 Rows not loaded because all fields were null.
[INFO ] 2023-06-02 09:54:14.097 [http-nio-8080-exec-5] DataLoadingService - Rows not loaded because all fields were null : 0
[DEBUG] 2023-06-02 09:54:14.097 [http-nio-8080-exec-5] DataLoadingService -
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 |