My Oracle Support Banner

DbLoader is Not Processing Data File When FlushCount Parameter is Set To 0 (Doc ID 2073593.1)

Last updated on JULY 03, 2023

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 and later
Information in this document applies to any platform.

Goal

On : 7.5.0.0.0 version, Test Tools

DbLoader Is Not Processing data File when FlushCount parameter is set to 0.

On production environment we encountered a problem when dbLoader utility is not processing some data file. Only control file was moved to error directory (Data file was still presented in input directory).
When we compare control file from error directory with other archived control files we found difference with "FlushCount" parameter. The FlushCount parameter in problematic control file was set to "0" (FlushCount=0) but in all other files was set to "1" (FlushCount=1).  After changing FlushCount parameter from "0" to "1" data file was successfully loaded.


The question is, why FlushCount parameter was set to 0 ?
 

Solution

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
Goal
Solution


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