Recurring Payment jobs fails with ORA-01502 ORA-06512 partition of such index is in unusable state errors (Doc ID 474862.1)

Last updated on JANUARY 10, 2017

Applies to:

Siebel Comm Self-Service Manager - Version 5.1 and later
Information in this document applies to any platform.
Area(s):eaPay/Payment Module/ePayment Mgr
Release(s):V3 (Siebel Self-Service)
Database(s):All Supported Databases
App Server OS(s):All Supported Platforms
Latest release tested against:V3 (Siebel Self-Service)
Keywords:Q103525, recurring payment, ORA-01502, ORA-06512, partition of such index is in unusable state

Applicable Products
eaPay for Solaris (SOL2.2)

This document was previously published as Siebel FAQ 429.


Symptoms

Recurring Payment jobs fail with ORA-01502 ORA-06512 partition of such index is in unusable state errors.

User runs recurring payment and it fails with the following error:

RecurPaymentTask was done with an error at 01/05/2004 05:16:57.
The error message is : SchedulePaymentPlugIn.preSchedulePayment General exception SchedulePaymentPlugIn.preSchedulePayment General exception EJB Exception: ; nested exception is: javax.ejb.EJBException - with nested exception: [java.rmi.RemoteException: EJB Exception: ; nested exception is: javax.ejb.EJBException: java.rmi.RemoteException: java.sql.SQLException: ORA-01502: index 'EBPP.retail_26_IDX_1' or partition of such index is in unusable state ORA-06512: at "EBPP.hl_ok_retail_26", line 7 ORA-06512: at "EBPP.retail", line 196 ORA-06512: at line 1 ]

Start server side stack trace:
java.rmi.RemoteException: EJB Exception: ; nested exception is: javax.ejb.EJBException - with nested exception:
[java.rmi.RemoteException: EJB Exception: ; nested exception is: javax.ejb.EJBException: java.rmi.RemoteException: java.sql.SQLException: ORA-01502: index 'EBPP.retail_26_IDX_1' or partition of such index is in unusable state ORA-06512: at "EBPP.hl_ok_retail_26", line 7 ORA-06512: at "EBPP.retail", line 196 ORA-06512: at line 1 ]

java.rmi.RemoteException: EJB Exception: ; nested exception is: javax.ejb.EJBException: java.rmi.RemoteException: java.sql.SQLException: ORA-01502: index 'EBPP.retail_26_IDX_1' or partition of such index is in unusable state ORA-06512: at "EBPP.hl_ok_retail_26", line 7 ORA-06512: at "EBPP.retail", line 196 ORA-06512: at line 1

javax.ejb.EJBException: java.rmi.RemoteException: java.sql.SQLException: ORA-01502: index 'EBPP.retail_26_IDX_1' or partition of such index is in unusable state ORA-06512: at "EBPP.hl_ok_retail_26", line 7 ORA-06512: at "EBPP.retail", line 196 ORA-06512: at line 1

at com.edocs.services.application.AppIndexVolMgr.getHitList(AppIndexVolMgr.java:708)
at com.edocs.services.application.AppIndexVolMgr_fcksga_EOImpl.getHitList(AppIndexVolMgr_fcksga_EOImpl.java:127)
at com.edocs.services.application.EdocsDataSource.getDocumentSummary(EdocsDataSource.java:76)
at com.edocs.services.application.EdocsDataSource_ylgfph_EOImpl.getDocumentSummary(EdocsDataSource_ylgfph_EOImpl.java:81)
at com.edocs.services.application.EdocsDataSource_ylgfph_EOImpl_WLSkel.invoke(Unknown Source)
at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:305)
at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:274)
at weblogic.rmi.internal.BasicServerRef.dispatch(BasicServerRef.java:167)
at weblogic.rmi.internal.ServerRequest.sendOneWayRaw(ServerRequest.java:92)
at weblogic.rmi.internal.ServerRequest.sendReceive(ServerRequest.java:112)
at weblogic.rmi.internal.BasicRemoteRef.invoke(BasicRemoteRef.java:136)
at weblogic.rmi.internal.ProxyStub.invoke(ProxyStub.java:35)
at $Proxy164.getDocumentSummary(Unknown Source)
at com.edocs.ps.toyota.tasks.payment.recur_payment.ToyotaRecurringPaymentPlugIn.getSummary(ToyotaRecurringPaymentPlugIn.java:390)
at com.edocs.ps.toyota.tasks.payment.recur_payment.ToyotaRecurringPaymentPlugIn.preSendEmail(ToyotaRecurringPaymentPlugIn.java:171)
at com.edocs.tasks.payment.recur_payment.RecurPaymentTask.schedulePayments(RecurPaymentTask.java:971)
at com.edocs.tasks.payment.recur_payment.RecurPaymentTask.executeTask(RecurPaymentTask.java:1045)
at com.edocs.tasks.payment.recur_payment.RecurPaymentTask.executeTask(RecurPaymentTask.java:272)
at com.edocs.tasks.payment.PaymentTask.doProcessTask(PaymentTask.java:12)
at com.edocs.pwc.tasks.CommonTask.processTask(CommonTask.java:248)
at com.edocs.tasks.payment.recur_payment.RecurPaymentTask_6tlbd3_EOImpl.processTask(RecurPaymentTask_6tlbd3_EOImpl.java:37)
at com.edocs.tasks.payment.recur_payment.RecurPaymentTask_6tlbd3_EOImpl_WLSkel.invoke(Unknown Source)
at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:305)
at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:274)
at weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.java:22)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)

--------------- nested within: ------------------
javax.ejb.EJBException - with nested exception: [java.rmi.RemoteException: EJB Exception: ; nested exception is: javax.ejb.EJBException: java.rmi.RemoteException: java.sql.SQLException: ORA-01502: index 'EBPP.retail_26_IDX_1' or partition of such index is in unusable state ORA-06512: at "EBPP.hl_ok_retail_26", line 7 ORA-06512: at "EBPP.retail", line 196 ORA-06512: at line 1

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