How do I Initialize the Reporting Database for Specific Landscapes?
search cancel

How do I Initialize the Reporting Database for Specific Landscapes?

book

Article ID: 23199

calendar_today

Updated On: 10-19-2023

Products

Spectrum Network Observability

Issue/Introduction

The document explains how to initialize the Reporting Database for Specific Landscapes, remove all data from the reporting database, and pull event data from the Archive Manager.

Environment

Release: 22.2.x, 21.2.x
Component: SPCRPT

Resolution

1. Stop the Spectrum Tomcat service ($SPECROOT/tomcat/bin/stopTomcat.sh)

2. Run: RpmgrInitializeLandscape (Ensure there was no error)

3. Start the Spectrum Tomcat service ($SPECROOT/tomcat/bin/startTomcat.sh)

 

Navigate to the $SPECROOT//bin directory and run the following script:

RpmgrInitializeLandscape

Usage:


RpmgrInitializeLandscape <username> <password> [-skipInitialHistory] [-initHist <# of days>] [-all] [<landscape1> <landscape2> ...]

       -skipInitialHistory   

The Report Manager does not retrieve or store events during event processing that has occurred before the utility has run. This flag overrides -initHist <# of days> if it is also included in the command line.

     -initHist <# of days>

The Report Manager imports existing historical events from the Archive Manager, for the number of days specified.  The number should be less than or equal to the number of days worth of event data stored in the Archive Manager (the default is 45 days).  This can be verified from the "MAX_EVENT_DAYS" field in the file <$SPECROOT>/SS/DDM/.configrc

      -all

The Report Manager removes data for all landscapes in the reporting database.

       <landscape1> <landscape N > Report Manager removes data for each landscape specified.

The following sample command would remove the reporting data for all landscapes and import 45 days of events from the Archive Manager.

       RpmgrInitializeLandscape.sh root <password> -initHist 45 -all (Linux)

       RpmgrInitializeLandscape.exe root <password> -initHist 45 -all (Windows)

       RpmgrInitializeLandscape.sh root <password> -initHist 45 <landscape name> (Linux)

       RpmgrInitializeLandscape.exe root <password> -initHist 45 <landscape name> (Windows)

** The script runs to completion quite quickly, removing all the specified reporting data, however, the Spectrum Tomcat service will need to be restarted afterward to begin the import of events from the Archive manager.  This can take a long time, depending on the number and size of landscapes events being imported.  

Additional Information

Please reference the "Initialize the Database for Specific Landscapes" section of the documentation for more information.