Synchronization between PM and OneClick constantly synching and never available.

Products

• CA Performance Management

Issue/Introduction

In Performance Manager: Administration -> Data Sources, we see the Spectrum data source Status constantly as "Synchronizing".

The "Last Polled On" time is several days old.

 

Environment

Release: 21.2.8 through 22.2.6

Cause

Defect: DE560729

Resolution

This issue has been resolved in DX Netops 22.2.7 and later:

Symptom: When many group relationships are deleted in Spectrum and synchronized to NetOps Portal, it can take MySQL a long time to mark the entries in the database for deletion during global synchronization. This is because MySQL fails to use the PRIMARY index when the where clause is above a certain number of comparisons.
Resolution: The SQL call now uses a force index of PRIMARY index, and runs faster.
(22.2.7, DE560729, 33381189)

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/performance-management/22-2/release-notes/fixed-issues.html#concept.dita_dffccc4e37aafcca90f52a0d259b75e6551f37ff_2227

Additional Information

WORKAROUND:

1. Stop tomcat on the OneClick server integrated with the DX Netops Portal.

2. Wait for UPDATEs to complete on portal mysql and throw an error trying to Pull from Spectrum.

a) Check the mysql process listing on the DX Netops Portal:

mysql -t -uroot -p -e "show full processlist;"  > /tmp/proclist.txt

b) The update would look similar to:

| ##### | netqos          | localhost:##### | netqosportal | Query   |    <TimeinSeconds> | updating                    | UPDATE ds_item_members SET UpdatedOn=0 WHERE SourceID=# AND ((ParentTypeName='group' AND ParentLocalID='#####################' AND ChildTypeName='interface' AND ChildLocalID='0x#######') OR (ParentTypeName='group' AND ParentLocalID='######################' AND ChildTypeName='interface' AND ChildLocalID='0x#######') OR.... 

3. Start Tomcat on the OneClick integrated with the DX Netops Portal:

4. Request a full sync with the Spectrum data source in Portal:

5. Wait for the current Global Sync/PUSH to complete

6. See PULL start for Spectrum data source