search cancel

sharepoint probe QOS entries show invalid samplevalue errors in qos_processor

book

Article ID: 202072

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

The qos_processor probe is throwing a number of invalid sample value errors.
Jul 27 15:11:09:046 [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
Jul 27 15:11:09:046 [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
Jul 27 15:11:09:046 [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
Jul 27 15:11:09:046 [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
 
Jul 27 15:11:09:046 [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

Jul 27 15:11:09:046 [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
Jul 27 15:11:09:046 [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
Jul 27 15:11:09:046 [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

Cause

- sharepoint probe QOS missing unit values

Environment

Release : 9.2.0

Component : UIM - SHAREPOINT

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, Deactivate the sharepoint probe.

Then rt-click and delete it.

Delete the sharepoint probe folder on the robot.

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

Attachments

sharepoint_1605791733027.zip get_app
qos_processor_1603482229739.zip get_app