Query error reasons
Result over the Databrain limit
The result is larger than Databrain returns for one chart.
Reason in E1005 | Diagnostic code | Who can fix it | Does a retry help? |
|---|---|---|---|
LIMIT_EXCEED | DBN-QRY-004 | Your admin | No |
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
| Who | Message | Next step |
|---|---|---|
| Admin or API caller | The 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 viewer | This chart has a data setup problem. | Contact your admin. |
How to fix it
- Add a filter or a shorter date range.
- 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.