Spectrum Report Manager slow to rebuild the reporting database after running the RpmgrInitializeLandscape

Products

• Network Observability
• Spectrum

Issue/Introduction

We ran the RpmgrInitializeLandscape script to reinitialize the Spectrum Report Manager (SRM) reporting database to rebuild the reporting database from scratch. It took over 5 hours for the reporting database to get rebuilt and caught up on current events.

We have three landscapes in our environment. The Archive Manager database are not that large.

In the catalina.out file, we noticed the following:

- start polling  first landscape (landcape1)  @09:30

- start polling  second landscape (landcape2) @13:21

- start polling third landscape (landcape2) @14:05

What looks like is happening is it will only update the events one landscape at a time.

Environment

Version: Any
Component: Spectrum Report Manager (SRM)

Cause

The logging of events to the reporting database is not multithreading. So the updating of the reporting database events after reinitializing the reporting database will occur one landscape at a time.

Resolution

This is functioning as designed.