Pratik A (pratik)
Cognizant Technology Solutions
Strategic Solution Architect
Cognizant Technology Solutions
pratik Member since 2013 13 posts
Cognizant Technology Solutions
Posted: February 27, 2020
Last activity: May 13, 2020
Posted: 27 Feb 2020 6:27 EST
Last activity: 13 May 2020 14:08 EDT

Maintenance job limitation in 8.3.1

Affected jobs pyPersistClusterState and pyClusterAndDBCleaner

A limitation in Platform version 8.3.1 prevents OOTB maintenance jobs from running. This failure can cause excess log messages, and system state diagnostic entries will not be automatically removed that are 30 days older without the fix.

Symptoms (in association with the failed job executions):

  • Unsuccessful job runs (Success rate is 0)
  • Error querying index metadata from db
  • Error retrieving database indices
  • ORA-01031: insufficient privileges (requires ANALYZE ANY)
  • QueueProcessorDelayedMessageService cannot be resolved to a type
  • FUA compilation error against pyClusterAndDBCleaner
  • pyClusterAndDBCleaner Job is failing to process the records

Root cause:

Per discussion with Support Engineers, these are bugs in current platform version: BUG-519827 and BUG-536777.

The issue occurs due to pzclusteranddbcleaner activity being coded with compilation issues. This failure is due to the wrong package usage of QueueProcessorDelayedMessageService class. It should be referred as  com.pega.platform.executor.queueprocessor.internal.QueueProcessorDelayedMessageService  class instead.


The two bugs are fixed in Platform version 8.3.2 and higher.


Meanwhile, follow the below approach so that logs won’t be piled up.

Once platform is upgraded to Pega 8.3.2 or higher, revert both of these changes:

  1. Disable job pyClusterAndDBCleaner
  2. Set pyPersistClusterState job to run weekly, rather than daily
Pega Platform 8.3 System Administration Support Case Exists