search cancel

How to clear out the Report Manager tables

book

Article ID: 40565

calendar_today

Updated On:

Products

CA Spectrum DX NetOps

Issue/Introduction

Question: 

How to clear the data in report manager database

 

 

Resolution

 

1.Stop spectrum tomcat service

 

Windows:

  • click on start
  • click on run
  • type services.msc and enter
  • stop spectrum tomcat service 

 

Unix:

Below command stops spectrum tomcat

  • $SPECROOT/tomcat/bin/stopTomcat.sh

 

2.Initialize the report manager database

 

Windows:

  • open command prompt

click on start

click on run 

type cmd and enter 

  • bash -l 
  • cd bin 
  • ./rpmgrinitializelandscape root root -initHist 45 -all 

 

Unix:

  • cd $SPECROOT/bin
  • ./rpmgrinitializelandscape root root -initHist 45 -all

 

NOTE: This will delete the current data completely and reprocess 45 days from Archive Manager.

To not process data from Archive Manager and to just clear the data:

./rpmgrinitializelandscape root root -all

 

  1. Start spectrum tomcat service

 

Windows:

  • click on start
  • click on run
  • type services.msc and enter
  • start spectrum tomcat service 

 

Unix:

Below command starts spectrum tomcat

 

  • $SPECROOT/tomcat/bin/startTomcat.sh