Synchronization Failure between NetOps Spectrum and NetOps Performance Management
search cancel

Synchronization Failure between NetOps Spectrum and NetOps Performance Management

book

Article ID: 144256

calendar_today

Updated On:

Products

CA Spectrum DX NetOps CA Performance Management - Usage and Administration

Issue/Introduction

The following error was found in the Spectrum Tomcat log file:

(http-nio-8080-exec-22) (NetqosSyncLog) - (ERROR) - pushRequest failed:
Caused by: java.lang.NumberFormatException: For input string: "2173368368"


A similar error is shown in the NetOps Portal log file \CA\Performance\DM\wrapper-*.log:

Environment

Spectrum and PM all versions

Cause

2173368368 is an invalid UNIX_TIMESTAMP in the NetOps Portal netqosportal Database

Resolution

Run the following script to gather the NetOps Portal documentation:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/performance-management/22-2/troubleshooting/unable-to-resolve-issue.html

Open the netqosportal.sql file and find the "2173368368" in order to know the table name, example:

LOCK TABLES `dst_domain` WRITE;
/*!40000 ALTER TABLE `dst_domain` DISABLE KEYS */;
INSERT INTO `dst_domain` VALUES (3,'2','ip',3,1,1579647225,2173368368,NULL,NULL,NULL,NULL
/*!40000 ALTER TABLE `dst_domain` ENABLE KEYS */;
UNLOCK TABLES;


In this case the table is "dst_domain"

Then  follow these steps to update the changedon row:

  1. Launch the MySQL command prompt

    # mysql -u<user> -p<password> netqosportal​

    Where <user> is the username and <password> is the password to login to MySQL server, and netqosportal is the database name.

  2. Run the following MySQL queries:

    mysql> select from_unixtime(changedon) from dst_domain;
    
    mysql> update dst_domain set changedon=UNIX_TIMESTAMP();
    
    mysql> select from_unixtime(changedon) from dst_domain;​

    Note: Repeat the procedure for whole tables found in netqosportal.sql file

  3. On the NetOps Portal web page -> Administration -> Data Sources, select "Spectrum Infrastructure Manager" and Perform a Full Resynchronization