sharepoint probe QOS entries show invalid samplevalue errors in qos_processor

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

The qos_processor probe is throwing a number of invalid sample value errors.

[Qos Message Unmarshaller, qos_processor] Received Qos message with invalid samplevalue: qos: Requests Rejected source: WP001291 target: MOSS2007 - ASP.NET Applications - Requests Rejected_Requests Rejected
[Qos Message Unmarshaller, qos_processor] Received Qos message with invalid samplevalue: qos: Request Wait Time source: WP001291 target: MOSS2007 - ASP.NET Applications - Request Wait Time_Request Wait Time
[Qos Message Unmarshaller, qos_processor] Received Qos message with invalid samplevalue: qos: Requests In Application Queue source: WP001291 target: MOSS2007 - ASP.NET Applications - Requests In Application Queue_Requests In Application Queue
[Qos Message Unmarshaller, qos_processor] Received Qos message with invalid samplevalue: qos: Requests Executing source: WP001291 target: MOSS2007 - ASP.NET Applications - Requests Executing_Requests Executing
[Qos Message Unmarshaller, qos_processor] Received Qos message with invalid samplevalue: qos: NumberOfEventsFound source: WP001291 target: MOSS_ApplicationInstallation - Error communicating with Excel Calculation Services 5239_NumberOfEventsFound
[Qos Message Unmarshaller, qos_processor] Received Qos message with invalid samplevalue: qos: NumberOfEventsFound source: WP001291 target: MOSS_ApplicationInstallation - Error communicating with Excel Calculation Services 5240_NumberOfEventsFound
[Qos Message Unmarshaller, qos_processor] Received Qos message with invalid samplevalue: qos: Requests Rejected source: WP001291 target: MOSS2007 - ASP.NET Applications - Requests Rejected_Requests Rejected
[Qos Message Unmarshaller, qos_processor] Received Qos message with invalid samplevalue: qos: Request Wait Time source: WP001291 target: MOSS2007 - ASP.NET Applications - Request Wait Time_Request Wait Time

Environment

• Release : 9.2.0 or higher
• Component : UIM - SHAREPOINT

Cause

- sharepoint probe QOS missing unit values

Resolution

The attached sharepoint probe version is v1.83 Build 118.

If you need the original configuration because you've customized the probe config, then save off the sharepoint.cfg file for later restoration.

Otherwise,

1. Deactivate the sharepoint probe.
2. Then rt-click and delete it.
3. Delete the sharepoint probe folder on the robot.
4. In the IM the probe may turn yellow, and if it remains that way you can restart the robot to see if that speeds up the refresh.

Data cleanup for sharepoint

select * from s_qos_data where probe = 'sharepoint'
--  save the results/output as reference for the delete from the definition table if you want to delete more slowly/carefully.

--  You can use the following to clean up your DB but be careful as there are quite a number of sharepoint QOS objects.

--  delete from s_qos_data where target like 'MOSS%'
--  delete from s_qos_data where target like 'Performance -%'
--  delete from s_qos_data where target like 'Databases - SQL%'

select * from s_qos_definition where unit = ''

--  if the only qos without unit values is sharepoint QOS, you can use a query like this to delete the sharepoint qos definitions. I ran...
--  delete from s_qos_definition where unit = ''
--  or using the QOS names from the select * from s_qos_data where probe = 'sharepoint' you can delete them like so... 
--  delete from s_qos_definition where name in ('QOS_#_BYTES_IN_ALL_HEAPS'); etc etc

-- Then deactivate and activate the data_engine and do the same for the sharepoint probe(s), and verify the qos 'unit' values are populated.

Then run:

select * from s_qos_definition and examine the sharepoint QOS definitions and they should now show unit values, e.g., s for seconds.

Additional Information

Updated sharepoint probe version attached.

date = 20.10.2020
version = 1.83
build = 118