Synchronization between PM and OneClick constantly synching and never available.
Article ID: 262572
Updated On:
Products
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
Feedback
