MySQL script to create all the missing initial outages

book

Article ID: 193984

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

The number of devices in the JasperReports Availability report do not match with the number of device in Global Collection.

Cause

The initial outage is missing for some models, hence they are not displayed in the JasperReports Availability Group report

Environment

CA Spectrum 10.3.x

Resolution

Run the attached sql file in the SRM machine. This should create all the missing initial outages. The initial outages should be present for all the models which are present in modeloutage table.

1.Please take the SRM complete dump/backup before running the below script. So that we can roll back for any uncertain issues as the below sql file may take some time depending upon the size of tables and overall mysql performance.

2.Do not stop or kill the script while it is running.

3.Stop the SRM tomcat server.

4. Run the script:

$SPECROOT/mysql/bin/mysql -uroot -proot reporting< PATH_OF_SQL_FILE

eg: /c/win32app/Spectrum/mysql/bin/mysql -uroot -proot reporting < /c/win32app/Spectrum/generate_initial_outages.sql

Additional Information

How to Backup and Restore CA Spectrum Reporting Manager Database

https://knowledge.broadcom.com/external/article?articleId=40262

Attachments

1593362446678__generate_initial_outages.sql get_app