Description
After an upgrade to Jakarta or later, instance reports and TableCleaner for the unused v_rrd_* tables are triggering the error:
SEVERE *** ERROR *** ClassUtil - class not found: com.glide.monitor.rrd.VirtualRrdSlowQueriesTable
Steps to Reproduce
Upgrade an instance and notice the Class not Found error within the instance server log thread:
2017-03-28 10:01:17 (657) glide.scheduler.worker.burst.0 glide.scheduler.worker.burst.0 Completed: SMS Sender in 0:00:00.002, next occurrence is 2017-03-28 10:01:39 2017-03-28 10:01:17 (657) glide.scheduler.worker.burst.0 glide.scheduler.worker.burst.0 Bursted Schedule worker shutting down normally 2017-03-28 10:01:17 (657) glide.scheduler.worker.burst.0 glide.scheduler.worker.burst.0 Schedule worker shutdown complete 2017-03-28 10:01:18 (923) worker.1 worker.1 Background message, type:access, message: This item is read-only based on its protection policy. 2017-03-28 10:01:20 (298) worker.1 worker.1 SEVERE *** ERROR *** ClassUtil - class not found: com.glide.monitor.rrd.VirtualRrdSlowQueriesTable 2017-03-28 10:01:20 (312) worker.1 worker.1 SEVERE *** ERROR *** ClassUtil - class not found: com.glide.monitor.rrd.VirtualRrdSlowQueriesTable 2017-03-28 10:01:20 (312) worker.1 worker.1 SEVERE *** ERROR *** ClassUtil - class not found: com.glide.monitor.rrd.VirtualRrdSlowQueriesTable 2017-03-28 10:01:21 (710) worker.1 worker.1 [0:00:00.014] Compacting large row block (file.write: sys_dictionary 10000 rows 160000 saveSize)
Workaround
The v_rrd_slow_event and v_rrd_slow_mutex tables are deprecated in Jakarta but their entries are left in the Dictionary in upgraded instances. This causes the system script include SchemaProcessor to generate table read exceptions.
Express administrators: Contact ServiceNow Customer Support and create an incident for technical support to perform the change.
Enterprise administrators: Modify the script include SchemaProcessor and change Line 49 from:
if (!grtable.isValid())
to
if (!grtable.isValid() || tableName.indexOf('v_rrd') == 0)
Related Problem: PRB905647