MySQL script to create all the missing initial outages
Article ID: 193984
Updated On:
Products
Issue/Introduction
The number of devices in the JasperReports Availability report do not match with the number of device in Global Collection.
Environment
CA Spectrum 10.3.x
Cause
The initial outage is missing for some models, hence they are not displayed in the JasperReports Availability Group report
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
Feedback
