My Oracle Support Banner

Unable To Load A Batch Rated Output File Through REL Following A DB Crash (Doc ID 2051064.1)

Last updated on APRIL 16, 2018

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

We experienced a crash of our DB server in our production environment on Aug 27.
After that DB crash we found that one batch rated output file didn't get fully loaded into BRM by REL.
The corresponding entry in the BATCH_T table is showing a status 8192.
We tried reload the events normally by using the same command to process the original event file as indicated in the BRM documentation but it doesn't work.
When we try processing the file again REL indicates that the file is already being processed by another REL instance:

Error 08/31/15 1:40:46:0754 AM ( 1441006846754 ) T:main REL IREL 1:sss6230:UnknownProgramName:0:main:7:1441006846:0
  Error encountered in the REL Driver: 1030
The file is currently being processed by another REL session: /opt/portal/7.5/ST_CUSTOM/apps/st_pin_rel/st_load_voice_usages/data/tmp/AMAVoice_P_U150827000065AMA.out
Error 08/31/15 1:40:46:0754 AM ( 1441006846754 ) T:main REL IREL 1:sss6230:UnknownProgramName:0:main:7:1441006846:0
  Exiting with return code: 1

How to load this batch rated output file into BRM?
 

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
References


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