Error From PIN_REL : "Error encountered in the Database Load Utility: 5002" (Doc ID 408709.1)

Last updated on MARCH 24, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 6.7.0.1.1 to 7.4.0.0.0 [Release 6.7.0 to 7.4.0]
Oracle Solaris on SPARC (32-bit)
Solaris Operating System (SPARC)
Checked for relevance on 04-Jul-2011
Checked for relevance on 05-Dec-2012.

Symptoms

When loading rated output files using PIN_REL, the following error was encountered :

Error 08/04/05 2:32:28:0228 ( 1123133548229 ) T:main REL IREL 1:dev:UnknownProgramName:0:main:1:1123131720:0
Error encountered in the Database Load Utility: 5002
The following properties key could not be found: 5002
Please update CustomErrorCodes.properties with the appropriate custom error message.
Error 08/04/05 2:32:28:0230 ( 1123133548230 ) T:main REL IREL 1:dev:UnknownProgramName:0:main:1:1123131720:0
Exiting with return code: 5



Looking into *blk.log:

SQL*Loader: Release 9.2.0.5.0 - Production on Thu Aug 4 14:17:39 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Control File: /opt/portal/6.7/apps/pin_rel/dev_200508_N.out.event_bal_impacts_t.ctl
Character Set UTF8 specified for all input.

Data File: /opt/portal/6.7/apps/pin_rel/dev_200508_N.out.event_bal_impacts_t.blk
Bad File: /opt/portal/6.7/apps/pin_rel/dev_200508_N.out.event_bal_impacts_t.blk.bad
Discard File: /opt/portal/6.7/apps/pin_rel/dev_200508_N.out.event_bal_impacts_t.blk.discard
(Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 50
Continuation: none specified
Path used: Direct

Load is UNRECOVERABLE; invalidation redo is produced.

Table EVENT_BAL_IMPACTS_T, partition P_9D, loaded from every logical record.
Insert option in effect for this partition: APPEND

Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
RECORD_TYPE2 FIRST * WHT CHARACTER
(FILLER FIELD)
RECORD_NUMBER2 NEXT * WHT CHARACTER
(FILLER FIELD)
ACCOUNT_OBJ_DB NEXT * WHT CHARACTER
ACCOUNT_OBJ_TYPE NEXT * WHT CHARACTER
ACCOUNT_OBJ_ID0 NEXT * WHT CHARACTER
ACCOUNT_OBJ_REV NEXT * WHT CHARACTER
BAL_GRP_OBJ_DB NEXT * WHT CHARACTER
BAL_GRP_OBJ_TYPE NEXT * WHT CHARACTER
BAL_GRP_OBJ_ID0 NEXT * WHT CHARACTER
BAL_GRP_OBJ_REV NEXT * WHT CHARACTER
ITEM_OBJ_DB NEXT * WHT CHARACTER
ITEM_OBJ_TYPE NEXT * WHT CHARACTER
ITEM_OBJ_ID0 NEXT * WHT CHARACTER
ITEM_OBJ_REV NEXT * WHT CHARACTER
RESOURCE_ID NEXT * WHT CHARACTER
IMPACT_CATEGORY NEXT * WHT CHARACTER
IMPACT_TYPE NEXT * WHT CHARACTER
PRODUCT_OBJ_DB NEXT * WHT CHARACTER
PRODUCT_OBJ_TYPE NEXT * WHT CHARACTER
PRODUCT_OBJ_ID0 NEXT * WHT CHARACTER
PRODUCT_OBJ_REV NEXT * WHT CHARACTER
GL_ID NEXT * WHT CHARACTER
TAX_CODE NEXT * WHT CHARACTER
RATE_TAG NEXT * WHT CHARACTER
LINEAGE NEXT * WHT CHARACTER
NODE_LOCATION NEXT * WHT CHARACTER
QUANTITY NEXT * WHT CHARACTER
AMOUNT NEXT * WHT CHARACTER
AMOUNT_DEFERRED NEXT * WHT CHARACTER
DISCOUNT NEXT * WHT CHARACTER
DISCOUNT_INFO NEXT * WHT CHARACTER
(FILLER FIELD)
OBJ_ID0 NEXT * WHT CHARACTER
REC_ID NEXT * WHT CHARACTER

Record 108590: Rejected - Error on table EVENT_BAL_IMPACTS_T, column AMOUNT.
ORA-01722: invalid number

Record 167412: Rejected - Error on table EVENT_BAL_IMPACTS_T, column AMOUNT.
ORA-01722: invalid number

The following index(es) on table EVENT_BAL_IMPACTS_T were processed:
index PIN.I_EVENT_BAL_IMPACTS__ID partition P_9D loaded successfully with 699093 keys
index PIN.I_EVENT_BI_ACCOUNT_OBJ__ID partition P_9D loaded successfully with 699093 keys
index PIN.I_EVENT_BI_ITEM_OBJ__ID partition P_9D loaded successfully with 699093 keys
index PIN.I_EVENT_BI_BAL_GRP__ID partition P_9D loaded successfully with 699093 keys
index PIN.I_EVENT_BAL_IMPACTS_OBJ_REC_ID partition P_9D loaded successfully with 699093 keys

Table EVENT_BAL_IMPACTS_T, partition P_9D:
699093 Rows successfully loaded.
2 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.

Bind array size not used in direct path.
Column array rows : 5000
Stream buffer bytes: 256000
Read buffer bytes: 1048576

Total logical records skipped: 0
Total logical records read: 699095
Total logical records rejected: 2
Total logical records discarded: 0
Total stream buffers loaded by SQL*Loader main thread: 169
Total stream buffers loaded by SQL*Loader load thread: 673

Run began on Thu Aug 04 14:17:39 2005
Run ended on Thu Aug 04 14:23:22 2005

Elapsed time was: 00:05:43.97
CPU time was: 00:00:21.65





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