Troubleshooting
Problem
Indexing fails with ERROR SQL Error Code: 942 ERROR SQL State: 42000 java.sql.SQLException: ORA-00942: table or view does not exist
Symptom
ERROR 000000000000 GLOBAL_SCOPE
BPMovingService-> .indexBusinessProcess(). Error Detected While Running
Index Business Process
[2008-01-04 10:51:06.174] ERROR SQL Error Code: 942
[2008-01-04 10:51:06.174] ERROR SQL State: 42000
java.sql.SQLException: ORA-00942: table or view does not exist
Cause
This problem could occur if you removed CREATE and DROP grants.
Resolving The Problem
Check if Database has correct rights. Add the correct grants back as needed.
See Windows Cluster Environment Installation (V5.2.6 or later) > Configuring an Oracle instance for the required privileges.
Historical Number
TRB2092
Was this topic helpful?
Document Information
Modified date:
28 February 2019
UID
swg21561330