Query failed at data fetching stage. Please contact support

Products

• DX OpenExplore
• Observability

Issue/Introduction

Facing an intermittent issue of Jenkins job failing with QueryExecutionError, job status returned is 200. 

\"errorType\":\"QueryExecutionError\",\"errorMessage\":\"Query execution failed: Query failed at data fetching stage. Please contact support.\"}

Other APIs that gets executed sequentially via a jenkins job for monitoring complete.

Job is not retried as the Status returned is 200 indicating a successful pull.

Sample Request:
```
api/v2/chart/api {"sourceHost":"<hostName>","startTime":<epochTime>,"endTime":<epochTime>,"payloadJsonTemplate":"{\"q\": \"<validatedWQL>",\"s\": ${startTime},\"e\": ${endTime},\"g\": \"m\"}","metricPath":"data.timeseries[0].data"}

Resolution

Jenkins Job returns a status of 200, when the query portion of the job completes successfully. The status is not updated however when the data fetching stage fails.

Parse results for "QueryExecutionError" to know when job needs to be re-ran.

Additional Information

If issue continues or to investigate backend issues that may be impacting the data fetch stage, please open a ticket with Support@Broadcom.

Please provide the below information to investigate this issue.

• Exact date(s) and times(s) of failed jobs.
• Number of Queries Per Seconds (QPS) that are being ran at the time the data fetch stage fails.
• Request Query and/or cURL command ran.
• Cluster and Tenant name.