Troubleshooting product slowness due to VMware stray entries
How to confirm the presence of VMware related stray entries?
In MEAM logs, if Top 15 resources with type by monitors count is abnormal, we can confirm that stray entries are present. Refer below for example log.
[com.adventnet.appmanager.util.SupportZipUtil]|[INFO]: Top 15 resources with type by monitors count
RESOURCENAME TYPE COUNT
domain-c123 HAI 2500
datacenter-12 HAI 2500
domain-c124 HAI 2500
The normal count would be less than 10 for each RESOURCENAME.
How to verify any issue exists at present?
Execute the below mentioned query from Applications Manager query tool (directly execute in probe incase of Enterprise setup).
For PGSQL Backend,
SELECT to_timestamp(CREATIONTIME/1000) "MO CREATED ON",RESOURCENAME, DISPLAYNAME, RESOURCEID FROM AM_ManagedObject, AM_HOLISTICAPPLICATION WHERE RESOURCEID=HAID AND GROUPTYPE IN (3, 1009, 1010, 1012) ORDER BY CREATIONTIME DESC
For MSSQL Backend,
SELECT dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (CREATIONTIME/1000),'1970-01-01 00:00:00') "MO CREATED ON",RESOURCENAME, DISPLAYNAME, RESOURCEID FROM AM_ManagedObject, AM_HOLISTICAPPLICATION WHERE RESOURCEID=HAID AND GROUPTYPE IN (3, 1009, 1010, 1012) ORDER BY CREATIONTIME DESC
This query will show the last time of creation for the VMware related entries. If any duplicated are entries created at present (or) very recently, further troubleshooting is needed. If this occurred long before or just before the upgrade to version 17.x, then no existing issue is present. We can perform cleanup.
How to execute cleanup queries?
For PGSQL Backend,
1. Shutdown the Applications Manager service.
2. Take a backup of Applications Manager database.
3. Connect to the Database by following this steps.
4. Execute the queries attached in the vmware_cleanup.txt one by one.
5. Start the Applications Manager service.
For MSSQL Backend,
1. Shutdown the Applications Manager service.
2. Take a backup of Applications Manager database.
3. Connect to the Database using SQL Server Management Studio.
4. Execute the queries attached in the vmware_cleanup.txt one by one.
5. Start the Applications Manager service.
New to ADSelfService Plus?
Related Articles
How to setup VMware Horizon version 8 monitor with Applications Manager
VMware Horizon is a Desktop as a Service(DaaS) solution that helps you achieve Desktop and Application virtualization. Prerequisites: Powershell with version above 5.1 VMware PowerCLI Module Note: Since this uses Powershell, Horizon monitoring is ...Unable to add hosts due to stray entries in tables ( for Server Monitors)
Navigate to Settings -> Tools -> Support -> Database Summary to access the query tool. Now execute the below queries one by one and share the query result to appmanager-support@manageengine.com select * from Node where NAME like '%Host_Name%' or NAME ...Real User Monitor (RUM) - Troubleshooting
If the monitor has not polled data for a long time, follow the below steps for troubleshooting. Step 1: Check the RUM Agent configuration Real User Monitor requires the RUM Agent to be installed and mapped to the Applications Manager. Refer this help ...Troubleshooting Server error responses
When encountering the following server error responses—Bad Gateway (502), Service Unavailable (503), and Gateway Timeout (504)—it typically indicates issues with the server hosting the URL. Troubleshooting Review your server's access logs for the 30 ...AWS EKS Troubleshooting FAQs
AWS EKS monitor can be configured only if you have already added an Amazon monitor in Applications Manager. Ensure that you have met the pre-requisites for the Amazon monitor before monitoring Elastic Kubernetes Service in Applications Manager. How ...