salesforce probe value extractor metric storing negative numeric values

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

The salesforce probe value extractor QOS "'QOS_SALESFORCE_QYERY_OBJ_RETURNED_VAL' is storing negative numeric values into the DB and the customer doesn't know what to do with it.

 

 

 

As per documentation, The Test Value Extractor is to check the extracted value from the queries result objects.

 

The object value should be stored under the following QOS Metric: 

 

 

 

When the customer uses this For example with the query below:

 

QUERY: select id, Name, LicenseDefinitionKey, MonthlyloginsUsed, MonthlyLoginsEntitlement, Systemmodstamp from UserLicense

VALUE EXTRACTOR: UserLicense.(0).Name

RESULT: IDENTITY 

the actual QOS Stored in the DB is a numeric negative value that cannot be used:

 

Environment

Release : 20.4

Component : UIM - SALESFORCE

Resolution

The returned value by the query must be numeric. 

This is why this issue is occurring. 

 

See the below example of the probe working as expected if the returned value is numeric:

 

 

 

If an alphanumeric value is returned by the query, then this issue happens.