Synchronization Failure between NetOps Spectrum and NetOps Performance Management

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