Support Article
ORA-01031: insufficient privileges
SA-106254
Summary
The PersistClusterState agent activity fails with Oracle insufficient privileges error.
Error Messages
[EDULER_THREAD_POOL_4] [STANDARD] [ ] [ ] (a.DatastoreMetadataServiceImpl) ERROR - Error querying indices metadata from db
com.pega.pegarules.pub.database.DatabaseException: Error querying index metadata: code: 1031 SQLState: 42000 Message: ORA-01031: insufficient privileges
DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
| SQL Code: 1031 | SQL State: 42000
at com.pega.platform.datastore.metadata.RDBMetadataAPIImpl.getDatabaseIndices(RDBMetadataAPIImpl.java:181) ~[datastore.jar:?]
at com.pega.platform.datastore.metadata.RDBMetadataAPIImpl.getDatabaseIndices(RDBMetadataAPIImpl.java:95) ~[datastore.jar:?]
at com.pega.platform.logicaldatastore.metadata.DatastoreMetadataServiceImpl.getDatastoreIndices(DatastoreMetadataServiceImpl.java:70) ~[logical-datastore.jar:?]
at com.pega.pegarules.management.internal.system.operations.ClusterManagementAPI.getTableIndices(ClusterManagementAPI.java:395) ~[prprivate-management.jar:?]
at com.pega.pegarules.management.internal.system.operations.ClusterManagementAPI.getSystemStateOfAllNodesInCluster(ClusterManagementAPI.java:325) ~[prprivate-management.jar:?]
at com.pega.pegarules.management.internal.system.operations.ClusterManagementAPI.getSystemState(ClusterManagementAPI.java:170) ~[prprivate-management.jar:?]
at com.pega.pegarules.management.internal.system.operations.ClusterManagementAPI.persistClusterState(ClusterManagementAPI.java:907) ~[prprivate-management.jar:?]
at com.pega.pegarules.management.internal.system.operations.ClusterManagementAPI.persistClusterState(ClusterManagementAPI.java:884) ~[prprivate-management.jar:?]
Steps to Reproduce
Install Pega Platform 8.3.1.
Root Cause
A defect in Pegasystems’ code or rules.
The insufficient privilege error occurs when the user does not have the 'Analyze Any' privileges.
The Deployment Guides mention that this privilege is required; however, this is a DBA privilege which is not granted to the user.
It is determined that the call made is performing more than needed. Hence, the 'Analyze Any' privilege is required.
Resolution
This featuer is implmented in the following:
- Pega Platform 8.1.8
- Pega Platform 8.2.6
- Pega Platform 8.3.2
- Pega Platform 8.4
- Pega Platform 8.4.1
Published April 25, 2020 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.