Support Article
Exceptions occur when executing Job[pyPersistClusterState]
Summary
For the 'ANALYZE ANY' privilege, SQLSyntaxErrorException occurs when executing Job[pyPersistClusterState].
Error Messages
[fault (self-tuning)'] [STANDARD] [PegaRULES:8] (a.DatastoreMetadataServiceImpl) ERROR - Error querying indices metadata from db
com.pega.pegarules.pub.database.DatabaseException: Error querying index metadata: code: 1031 SQLState: 42000 Mssage: ORA-01031: insufficient privileges
DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
| SQL Code: 1031 | SQL State: 42000
...
[fault (self-tuning)'] [STANDARD] [PegaRULES:8] (gicalDataStoreExceptionWrapper) ERROR - 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
From: (BPQD3AHIXWY7QMDR25NMZ7407ZWPTARZXA)
Caused by SQL Problems.
Problem #1, SQLState 42000, Error code 1031: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
...
[fault (self-tuning)'] [STANDARD] [PegaRULES:8] (perations.ClusterManagementAPI) ERROR - Error retrieving database indices
com.pega.platform.datastore.ConfigurationException: Problem running a query
at com.pega.platform.logicaldatastore.exception.LogicalDataStoreExceptionWrapper.classifyLegacyExceptionToDataStoreException(LogicalDataStoreExceptionWrapper.java:62) ~[logical-datastore.jar:?]
...
[fault (self-tuning)'] [STANDARD] [PegaRULES:8] (JobScheduler) ERROR - Exception in executing Job[pyPersistClusterState]
com.pega.platform.executor.jobscheduler.scheduler.JobExecutionException: Activity execution failed with [User marked activity execution to failed with message [ Error querying index metadata: code: 1031 SQLState: 42000 Message: ORA-01031: insufficient privileges
]]
Steps to Reproduce
- Install Pega Platform 8.3.1 step by step using the guide.
- Do not add any additional privileges to the base user.
Root Cause
The 'Approximate' argument in the getIndexInfo caused wasteful analytic operations to run on the database. This information is not required and hampers performance.
Resolution
On the new versions of the Pega Platform, the ANALYZE ANY privilege is not required.
This feature is implemented in the following:
- Pega Platform 8.1.8
- Pega Platform 8.2.6
- Pega Platform 8.3.2
- Pega Platform 8.4
Published April 9, 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.