ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Migrate Report Data from a Previous Report Manager Installation


Article ID: 208257


Updated On:


CA Spectrum


In DX NetOps Spectrum 20.2.7 (aka 10.4.3), you can migrate data from the old SRM (Spectrum Report Manager) installation. This feature was missing in the previous Spectrum releases in a new installation, it was only available in the in-place upgrade.


Release : 20.2

Component : Spectrum Report Manager


During the installation of OneClick with Spectrum Report Manager, you are prompted to migrate report data from a remote (source) reporting database to the new DX NetOps Spectrum reporting database. The prompt applies to upgrade situations where data from a previous installation is preserved. This migration is optional. Therefore, you can either accept or decline the migration.

If you prefer to migrate data, enable access to the source report database from the remote server as described below.

Follow these steps: 

1. Launch a MySQL client session on the source server with root account credentials. For example:
$ ./mysql --defaults-file=../my-spectrum.cnf -uroot -proot reporting -A (Linux)
$ ./mysql.exe -uroot -proot reporting (Windows)

2. Let data be extracted from the source database by a remote account. You can provide temporary access to a remote root account.
For example, if the DX NetOps Spectrum target OneClick Linux server is named, issue the following command at the MySQL command line:
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'' IDENTIFIED BY '<remoterootpassword>';

Note: Provide the fully qualified hostname.

3. Verify that this new permission is available to all existing sessions by issuing the following command:

4. (Windows Only) Verify that Windows Firewall settings on the source server allow remote connections to MySQL.

a. Click Start, Control Panel, and then Windows Firewall.
b. Under the Exceptions tab, click Add Port and configure values as follows:

  • Enter MySQL for the name.
  • Enter 3306 for the Port Number.
  • Select TCP.

c. (Optional) Click Change to restrict the scope of access to MySQL.
d. Specify the location of your DX NetOps Spectrum server.
4. Configure the option to allow remote connections to MySQL only from the migration destination server. For more information, see Windows Help and Support.

Access to the report database on the Windows server is enabled.

Prepare for the Migration

Before you start migrating the data, verify the connection between the source and destination server databases. Verify that the data you plan to migrate is updated.
Follow these steps: 

1. Verify the database connection to the remote host containing data that you plan to migrate. Issue the following command on the DX NetOps Spectrum server:
$ telnet <remote-srm-host> 3306

The following message indicates that the permissions have been set properly:

Escape character is '^]'. 7
4.1.11-nt î&#9786;  t#J0Mu'] ,&#9787;   #2p^giYa]0t{
&#9644;  &#9786;&#9830;#08S01Bad handshakeConnection closed by foreign host.

The following message indicates that the permissions have not been set correctly:

Q   &#9830;#HY000Host '' is not allowed to connect to this MySQL server Connection closed by foreign host.

If you are unable to connect to the MySQL server, verify that your MySQL permissions are configured correctly on your previous SRM MySQL database. Verify that the privileges are flushed before you reattempt to connect.

2. Stop all reporting processes on the remote, source server by removing all entries from the Spectrum Report Manager Admin Tools, DX NetOps Spectrum Status option.

3. Wait for 5 minutes to verify that any outstanding data changes are committed to the report database.
The root database account on the remote destination server can extract report data on the source server.
The connection is verified.


During the Spectrum Report Manager installation, the following screens will be displayed

Supply the information of the previous SRM.

Additional Information