OneClick install failed running the SA-RPT-MGR.cus script

book

Article ID: 209888

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

OneClick install failed running the SA-RPT-MGR.cus script.

The following is seen in the $SPECROOT/Install-Tools/LOGS/<Spectrum Version>/postinst* script:

********** Started: Fri Mar  5 12:19:10 2021 **********
running Custom Script Install-Tools/CUS/SA-RPT-MGR.cus
 
Error in SRMDb. Please Check /opt/Spectrum/Install-Tools/LOGS/10.4.3.0.21_20210305/SRMDb-results.log for details.

Script Install-Tools/CUS/SA-RPT-MGR.cus has FAILED

A check of the SRMDb-results.log file shows the following:

SRMDb ran with failures
com.aprisma.spectrum.app.repmgr.install.InstallException: Error occurred while migrating the SRM database
 at com.aprisma.spectrum.app.repmgr.install.SRMDb.install(SRMDb.java:164)
 at com.aprisma.spectrum.app.repmgr.install.SRMDb.main(SRMDb.java:82)
Caused by: com.aprisma.spectrum.app.repmgr.install.InstallException: Exception loading remote reporting data
 at com.aprisma.spectrum.app.repmgr.install.SRMDb.MigrateWindowsSRMDatabase(SRMDb.java:341)
 at com.aprisma.spectrum.app.repmgr.install.SRMDb.install(SRMDb.java:160)
 ... 1 more
Caused by: com.aprisma.spectrum.app.repmgr.install.InstallException: Failed to dump source database records to file.
 Please review '/opt/Spectrum/Install-Tools/import_remote_reporting_data.results' file for more detailed error information.
 at com.aprisma.spectrum.app.repmgr.install.SRMDb.MigrateWindowsSRMDatabase(SRMDb.java:336)
 ... 2 more

A check of the import_remote_reporting_data.results shows the following:

Beginning data migration process.
Creating 'reporting' database locally (if necessary)...
'reporting' database created successfully.
exporting reporting data from : ca-oneclick 
source alarminfo table is already compatible with MySQL 5.0. 
mysqldump of source data failed with status: 512 

Cause

During the OneClick/Spectrum Report Manager (SRM) installation, the following screen appears:

This information is only used if you have a separate SRM system and want to migrate the reporting database from this separate system to this system.

In this instance, the user filled out this information but the system was not an SRM system

Environment

Release : 10.4.x

Component : Spectrum Report Manager

Resolution

If you do have a separate SRM system and wish to migrate the reporting database, input the information as required.

If you are not migrating the reporting database, leave all the field blank and just click on the Next button.

Attachments