KNOWLEDGE BASE

Error "Query text limit of 67108864 bytes exceeded" When Run Flow By Tableau Prep Builder


Published: 28 May 2020
Last Modified Date: 28 May 2020

Issue

Upon running a flow the following error occurs:

Error Failure evaluating to database: [5] hyper_execute_query: 0 Query text limit of 67108864 bytes exceeded when run flow

Environment

  • Tableau Prep Builder

Resolution

Current possible workaround is reducing the query length generated by Tableau Prep Builder in some way. For example:
  • Reduce the fields in a pivot step
  • Reduce the number of pivot steps in a flow
  • Make calculation formula shorter

Cause

The flow generates more than 67108864 byte which is a limitation of current product that it can not be executed. This issue is under investigation by Tableau Development team.
 
Did this article resolve the issue?