Loading Aggregated Data To A Custom Table Using The DBLoader Utility Results In Error

(Doc ID 757902.1)

Last updated on SEPTEMBER 23, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 to 7.3.1.0.1 [Release 7.3.1]
Information in this document applies to any platform.
***Checked for relevance on 28-Oct-2013***


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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms