Spectrum Data Source synchronization failure - Unable to Contact

Products

• Network Observability
• Spectrum
• CA Performance Management

Issue/Introduction

Spectrum Data Source synchronization failure - Unable to Contact error

The Spectrum DS test is successful.

Error in the /opt/CA/PerformanceCenter/DM/logs/DMService.log file:

Data source DS(4) Spectrum@OneClickserver encountered an error while processing a sync request. Check the logs for that product to determine the cause of the problem within the data source.  The following stack trace shows the context of the sync request:
jakarta.xml.ws.WebServiceException: Could not send Message.

Caused by: java.net.http.HttpTimeoutException: HttpTimeoutException invoking https://OneClickserver:8443/axis2/services/ProductSync2WS: Timeout

Error in the $SPECROOT/tomcat/logs/catalina.out file:

System.err - com.mysql.cj.jdbc.exceptions.CommunicationException: Communication link failure

Environment

Spectrum and PM 24.3.3

Cause

MySQL server is hung.

Fails to connect to the MySQL command prompt:

cd $SPECROOT/mysql/bin/

./mysql --defaults-file=../my-spectrum.cnf -uroot -p<password>

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/DxNetOps/Spectrum/mysql/tmp/mysql/sock' (2)

Resolution

Restart the Tomcat and MySQL server services.

1. Stop the Spectrum Tomcat service

$SPECROOT/tomcat/bin/stopTomcat.sh

2. Ensure the Spectrum Tomcat service is successfully stopped

ps -ef | grep -i tomcat | grep -v webtomcat

If the tomcat process is still running/hung, kill it.

3. Stop the MySQL server service

cd $SPECROOT/bin

./cmdC localhost 2 MYSQL

4. Start the MySQL server service

cd $SPECROOT/bin

./launchinstdbapp localhost MYSQL y MYSQL.OUT 

5. Start the Spectrum Tomcat service

$SPECROOT/tomcat/bin/startTomcat.sh

For your reference:

How can I start and stop processes that are running under processd in Spectrum? 
https://knowledge.broadcom.com/external/article?articleId=41428