Item_total Not Updated For Loaded Usages When Usage Loading (Pin_rel) Hits Ora Error 00028 (Doc ID 1366233.1)

Last updated on MARCH 28, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 to 7.3.1.0.0 [Release 7.3.1]
Information in this document applies to any platform.

Symptoms


It was observed that when there error during usage loading (via pin_rel) from the batch pipeline into BRM database, the usage events are created in BRM but the item_total is not updated accordingly.

here the error message from rel.pinlog


Error 06/02/11 12:12:21:0149 PM ( 1306987941149 ) T:Update SP Thread 1 REL RELUpdaterThread 1:S24CJ0:UnknownProgramName:0:Update SP Thread 1:0:1306987941:0
ORA-00028: your session has been killed

Error 06/02/11 12:12:21:0250 PM ( 1306987941250 ) T:main REL IREL 1:S24CJ0:UnknownProgramName:0:main:1:1306986751:0
Error encountered in the Update Stored Procedure: 8000
The update stored procedure encountered an error.
Error 06/02/11 12:12:21:0251 PM ( 1306987941251 ) T:main REL IREL 1:S24CJ0:UnknownProgramName:0:main:1:1306986751:0
Exiting with return code: 8

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