How to rebuild the Spectrum Report Manager SRM reporting database from scratch

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

This document explains how to rebuild the Spectrum Report Manager reporting database from scratch without reinstallation. 

Environment

Spectrum 10.x / 21.x / 22.x Report Manager

Cause

Sometimes, when the size of the SRM DB becomes very large, or data integrity has become an issue, it becomes necessary to rebuild it from scratch. 

Resolution

1. Log into the Spectrum Report Manager system as the user that owns the Spectrum installation

2. Shutdown processd

    a. For Windows, stop the Spectrum processd service

    b. For Linux, su to the root user and run; $SPECROOT/lib/SDPM/processd.pl stop

 

3. After shutting down processd, ensure MySQL is shutdown

4. Shutdown tomcat

5. Remove the ib_logfile* and ibdata files from the $SPECROOT/mysql/data directory

6. Remove the contents $SPECROOT/mysql/data/reporting directory but leave the reporting directory folder.

7. Start processd

    a. For Windows, start the Spectrum processd service

    b. For Linux, su to the root user and run $SPECROOT/lib/SDPM/processd.pl start

 

8. Ensure MySql is running

9. Start tomcat if not already running

10. Log into the OneClick Web pages as an ADMIN user

11. Click on Administration -> Report Manager -> Business Objects Integration link

12. Configure the Business Objects Integration

13. Click on the SPECTRUM Status link

14. Select the Landscapes to monitor and click on the "Update Monitored Servers" button

(You may receive an error "Unable to access the SRM preferences" when trying to enable monitor option, if this happens please follow KB 29380)

The current information in the Archive Manager (DDM) databases on the landscapes selected to monitor will rebuild the Spectrum Report Manager reporting database from scratch.

 

15. If you see CORBA DOES_NOT_EXIST exceptions in the Tomcat log afterwards please follow KB 8424.

Additional Information

For error "Unable to access the SRM preferences" when clicking on "Update Monitored Servers" button

https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=29380

 

For error "java. lang. String messageFormatID="CsCEventDomain. getNextEventListByAttrFilter. requestID. DOES_NOT_EXIST"

https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=8424