REL Throws Error "..partition of such index is in unusable state" (Doc ID 1174850.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.2.1.0.0 to 7.4.0.0.0 [Release 7.2.1 to 7.4.0]
Information in this document applies to any platform.
** Checked for relevance on 01-Jun-2012 **
** Checked for relevance on 04-Sep-2016 **

Symptoms

Rated event loader fails to load a file into database and the REL logs always show the following:

Error 05/10/10 10:42:36:0028 AM ( 1273509756028 ) T:Update SP Thread 3 REL RELUpdaterThread 1:easa02:UnknownProgramName:0:Update SP Thread 3:0:1273509756:0
   ORA-20003: Error -20014error while processing data from event_bal_impacts_t occurred in the update procedure start_obj_id0 = 1412212750799431621 end_obj_id0 = 1412212750799431625 sqlcode = -20014 sqlerrm = ORA-20014: Error -20002 occurred in the update item balances
ORA-20002: Error creating item where item_obj_id0 = 16080244380 item_obj_db = 9 account_obj_id0 = 20161339 bal_grp_obj_id0 = 7064827557 item_obj_db = 9 item_obj_type = /item/sponsor item_obj_rev = 0
ORA-20001: Error selecting from event_t where poid_id0 = 1412212750799431622
ORA-06512: at "PIN203.PIN_REL", line 1811
ORA-01502: index 'PIN203.I_EVENT__ID' or partition of such index is in unusable state
ORA-06512: at "PIN203.PIN_REL", line 2856
ORA
ORA-06512: at "PIN203.PIN_REL", line 3358
ORA-20014: Error -20002 occurred in the update item balancesORA-20002: Error creating item where item_obj_id0 = 16080244380 item_obj_db = 9 account_obj_id0 = 20161339 bal_grp_obj_id0 = 7064827557 item_obj_db = 9 item_obj_type = /item/sponsor item_obj_rev = 0

 

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