Query in Grafana fails to return data when a filter is added, "get failed with status code 400"

Products

• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)
• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

When creating or updating a dashboard in Grafana, the recordset is empty, "No Data", when a filter is added no matter the column to filter on or value.

The error received is "get failed with status code 400"

 

Environment

DX UIM 23.4 CU5 

Grafana, any version, using OData

Cause

If the query or parameter values contain spaces, Grafana must encode them so that they are valid in the URL.  APIs like OData expects it to be %20 in place of the space when the url is formed.

By default, Grafana datasources are configured to use the Plus(+) separator instead of the Percentage(%20).

Resolution

Change the value of "URL pace coding" under Connections --> Data sources --> <Connection Name> --> Additional Settings

From Plus (+) to Percent (%20)