My Oracle Support Banner

Loading Aggregated Data To A Custom Table Using The DBLoader Utility Results In Error (Doc ID 757902.1)

Last updated on OCTOBER 26, 2018

Applies to:

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

Symptoms

While using BRM aggregation functionality in pipeline. after aggregating the data,  attempt was being made to add the data to a custom table using DBLoader utility.

Unable to load this data in the custom table and the following errors appear in the console:-

> ./bin/dbLoader -r ./conf/AGGR/dbLoader.reg
This is dbLoader, Version 6.7 10005
Copyright (c) 1999 - 2004 Portal Software, Inc.

*** Log not initialised.
*** Tried to write message '[T:1] ERR_CREATE_OBJECT_FAILED'
*** argument (0): .ProcessLog.Module


*** Log not initialised.
*** Tried to write message '[T:1] INF_DBL_START'
*** argument (0): 6.7 10003


*** Log not initialised.
*** Tried to write message '[T:1] INF_COPYRIGHT'
*** argument (0): (c) 1998 - 2004 Portal Software. All rights reserved.


*** Log not initialised.
*** Tried to write message '[T:1] INF_LOADING_DATA_PLUGIN'
*** argument (0): .DataPool.Database.Module
*** argument (1): 10006


*** Log not initialised.
*** Tried to write message '[T:1] INF_DATABASE_OPENED'
*** argument (0): DNADB3
*** argument (1): UNKNOWN
*** argument (2): INTEGRATE4

do not need to sort USAGE_STAT_1601

split USAGE_STAT_1601 into pieces of 40000
1
start working out 1 control files
data file './aggreGate/USAGE_STAT_1601_1.dat' opened

*** Log not initialised.
*** Tried to write message '[T:1] INF_FILE_OPENED'
*** argument (0): ./aggreGate/USAGE_STAT_1601_1.dat


*** Log not initialised.
*** Tried to write message '[T:1] INF_DATABASE_CONNECTION_DO'
*** argument (0): USAGE_STAT


*** Log not initialised.
*** Tried to write message '[T:1] INF_BEGIN_DB_TRANSACTION'


*** Log not initialised.
*** Tried to write message '[T:1] INF_LOCKING_TABLE'
*** argument (0): USAGE_STAT


*** Log not initialised.
*** Tried to write message '[T:1] INF_TABLE_LOCKED'
*** argument (0): USAGE_STAT

Loading records 1 - 1000

*** Log not initialised.
*** Tried to write message '[T:1] INF_DB_TRANSACTION_STATISTIC'
*** argument (0): Records=1, Good=1, Bad=0, Agg 0, Percentage=100%, Performance=1 R/s


*** Log not initialised.
*** Tried to write message '[T:1] INF_COMMIT_DB_TRANSACTION'


*** Log not initialised.
*** Tried to write message '[T:1] INF_MOVE_FILES'
*** argument (0): ./aggreGate/USAGE_STAT_1601_1.dat
*** argument (1): ./aggreGate/archive/USAGE_STAT_1601_1.arc


*** Log not initialised.
*** Tried to write message '[T:1] INF_MOVE_FILES'
*** argument (0): ./aggreGate/USAGE_STAT_1601_1.ctl
*** argument (1): ./aggreGate/archive/USAGE_STAT_1601_1.ctl

dbLoader 6.7 10005 successfully finished at Mon Dec 1 13:59:53 2008


*** Log not initialised.
*** Tried to write message '[T:1] INF_UNLOADING_DATA_PLUGIN'
*** argument (0): .DataPool.Database.Module


*** Log not initialised.
*** Tried to write message '[T:1] INF_SORT_TIME'
*** argument (0): 0


*** Log not initialised.
*** Tried to write message '[T:1] INF_DBL_STOP'
*** argument (0): 6.7 10003


*** Log not initialised.
*** Tried to write message '[T:1] INF_COPYRIGHT'
*** argument (0): (c) 1998 - 2004 Portal Software. All rights reserved.

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

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