KNOWLEDGE BASE

"hyper_execute_query: 0 canceled DataServiceFailure" occurred when viewing dashboard or during extract refreshing


Published: 01 Mar 2021
Last Modified Date: 14 Jul 2021

Issue

The following error occurred when viewing a dashboard, changing the filter, or during the extract refresh.

"An error occurred while communicating with data source 'xxx'

[xxxx] hyper_execute_query: 0 canceled

DataServiceFailure"


or

"[xxxx] hyper_execute_query: 0 Could not execute the given query.
The result status code is 7.
canceled"

 

Environment

  • Tableau Server 2020.1
  • Extract datasource

Resolution

Check the system resource/memory usage and increase Tableau Server's RAM.

Cause

It is possible that the hyper process is being restarted because of the insufficient RAM.

The following message can be found in Tableau Server's hyper's log just before the error occured.
+ hyper_0_2021_02_22_00_00_00.log
{"ts":"2021-02-22T16:04:10.723","pid":3608,"tid":"1278","sev":"info","req":"-","sess":"-","k":"srm-internal","v":{"msg":"Resource Manager: Exceeded allowed memory usage across all processes. Memory info: 17,686,609,920 bytes (current process);30,687,830,016 bytes (Tableau total); 33,131,044,864 bytes (total of all processes); 13 (info count)"}}
 
Did this article resolve the issue?