Error From PIN_REL : "Error encountered in the Database Load Utility: 5002"
Last updated on DECEMBER 08, 2017
Applies to:Oracle Communications Billing and Revenue Management - Version 220.127.116.11.1 to 18.104.22.168.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.
When loading rated output files using PIN_REL, the following error was encountered :
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:
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
RECORD_NUMBER2 NEXT * WHT CHARACTER
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
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms