Indexer Job fails with Error ORA-01031 insufficient privileges (Doc ID 474655.1)

Last updated on JUNE 22, 2016

Applies to:

Siebel Comm Self-Service Manager - Version 5.1 and later
Information in this document applies to any platform.
Area(s):eaDirect/BillDirect/eStatement Mgr
Release(s):V4 (Siebel Self-Service)
Database(s):Oracle
App Server OS(s):All Supported Platforms
Latest release tested against:V4 (Siebel Self-Service)
Keywords:Q103560, ORA-01031 insufficient privileges

This document was previously published as Siebel FAQ 443.


Symptoms

ORA-01031 insufficient privileges error from Indexer job.

The Indexer job generated the following error messages in the WebSphere Application Server log:


[1/22/04 11:46:50:749 EST] 4b93b9 ExceptionUtil X CNTR0020E: Non-application exception occurred while processing method createIndexSummary on bean BeanId(eadirect#ejb-application.jar#AppIndexVolMgr, fa00333e4e): javax.ejb.EJBException: java.rmi.RemoteException: java.sql.SQLException: ORA-01031: insufficient privileges
ORA-06512: at "EDX_DBA.IDX_TBL_MGR", line 320
ORA-06512: at "EDX_DBA.IDX_TBL_MGR", line 1722
ORA-06512: at line 1

at com.edocs.services.application.AppIndexVolMgr.createIndexSummary(AppIndexVolMgr.java:334)
at com.edocs.services.application.EJSRemoteStatefulIAppIndexVolMgr.createIndexSummary(EJSRemoteStatefulIAppIndexVolMgr.java:25)
at com.edocs.services.application._IAppIndexVolMgr_Stub.createIndexSummary(_IAppIndexVolMgr_Stub.java:263)
at com.edocs.tasks.ixloader.IXLoader.processTask(IXLoader.java:596)
at com.edocs.pwc.tasks.EJSRemoteStatefulITask.processTask(EJSRemoteStatefulITask.java:85)
at com.edocs.pwc.tasks._EJSRemoteStatefulITask_Tie._invoke(_EJSRemoteStatefulITask_Tie.java:108)
at com.ibm.CORBA.iiop.ExtendedServerDelegate.dispatch(ExtendedServerDelegate.java:532)
at com.ibm.CORBA.iiop.ORB.process(ORB.java:2395)
at com.ibm.CORBA.iiop.OrbWorker.run(OrbWorker.java:186)
at com.ibm.ejs.oa.pool.ThreadPool$PooledWorker.run(ThreadPool.java:104)
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:138)

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