Skip to Content

Query error reasons

Result over the Databrain limit

The result is larger than Databrain returns for one chart.

Reason in E1005Diagnostic codeWho can fix itDoes a retry help?
LIMIT_EXCEEDDBN-QRY-004Your adminNo

What this means

The result is larger than Databrain returns for one chart. The warehouse returned the data, but it is over the size limit that Databrain sets for one response. On a self-hosted install, SQL_RESPONSE_MAX_MB sets this limit.

What people see

WhoMessageNext step
Admin or API callerThe requested data exceeds the maximum size limit. Please refine your query to return fewer columns or use limits/filters to reduce the result set size.None
Embed viewerThis chart has a data setup problem.Contact your admin.

How to fix it

  1. Add a filter or a shorter date range.
  2. Return fewer columns, or group by fewer columns.

Ask for help

Every error has a six-character ref, for example Ref A1B2C3. API callers find it in details.ref. Search for the ref in Settings > Diagnostics > Logs to see the full log line, or send the ref and the time of the error to support.

On this page