Unprocessed Spectrum Report Manager (SRM) bucket tables are present

Document ID : KB000031361
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem:

There is a backlog of bucket table files located in $SPECROOT/MySQL/data/reporting directory.

These could be labeled as modelavailxxxxxx.MYI/MYD/FRM.

A Null Pointer Exception is thrown in the tomcat log file located in $SPECROOT/tomcat/logs

stdout.log on Windows and catalina.out on *nix.

Caused by: java.lang.NullPointerException
at com.aprisma.spectrum.app.repmgr.dc.event.handler.AvailabilityHandler.isClusterEntityType(AvailabilityHandler.java:1295)
at com.aprisma.spectrum.app.repmgr.dc.event.handler.AvailabilityHandler.handleUnplannedOutageEvent(AvailabilityHandler.java:1234)
at com.aprisma.spectrum.app.repmgr.dc.event.handler.AvailabilityHandler.handleEvent(AvailabilityHandler.java:891)
at com.aprisma.spectrum.app.repmgr.dc.event.handler.AvailabilityHandler.doProcessResultSet(AvailabilityHandler.java:521)
at com.aprisma.spectrum.app.repmgr.dc.event.handler.AvailabilityHandler.access$000(AvailabilityHandler.java:70)
at com.aprisma.spectrum.app.repmgr.dc.event.handler.AvailabilityHandler$HistoricalUpdate.processBucketRecords(AvailabilityHandler.java:418)
at com.aprisma.spectrum.app.repmgr.dc.event.handler.AbstractBucketReader.readBucket(AbstractBucketReader.java:149)
at com.aprisma.spectrum.app.repmgr.dc.event.handler.BucketReaderScheduler$ScheduledReader.run(BucketReaderScheduler.java:133)
at com.aprisma.util.thread.JobQueue.runJobThread(JobQueue.java:237)
at com.aprisma.util.thread.JobQueue.access$000(JobQueue.java:31)
at com.aprisma.util.thread.JobQueue$JobRunnable.run(JobQueue.java:40)
at java.lang.Thread.run(Thread.java:745)

Hypothesis:

This is caused by Spectrum Report Manager (SRM) database corruption.

SRM is looking for a model_key for deleted models but cannot find it.

This causes SRM to issue a null pointer exception (above) and stop processing those buckets.

 

Resolution:

CA Support and Engineering have a fix for this issue.

Patch H03_D97 is available for 9.3 H03.

Please contact CA Support if you require this patch or need it for another version.

Support will cross check to confirm this patch will resolve the issue.