Skip to Content

Query error reasons

Query error reasons

What each reason in an E1005 query error means, and who can fix it

When a chart, an embed or the API cannot get data, the error has the code E1005 and a details.reason that names the cause:

{
  "code": "E1005",
  "message": "The data source did not answer in time.",
  "hint": "Ask your admin to check that the warehouse is running and reachable.",
  "details": {
    "reason": "DATASOURCE_TIMEOUT",
    "errorCode": "DBN-WH-007",
    "retryable": true,
    "ref": "A1B2C3"
  }
}
  • reason is the cause. Use it in code to decide what to show.
  • errorCode is the diagnostic code, with its own page.
  • retryable is true when the same request can work on a later try.
  • ref finds the log line in Settings > Diagnostics > Logs.

Embed viewers never see host, user or table names. They see a short message and, for causes only an admin can fix, “This chart has a data setup problem.” The admin text stays on the error.

Reasons

ReasonNameWhat this meansDiagnostic code
DATASOURCE_UNREACHABLEDatasource unreachableDatabrain could not open a connection to your warehouse.DBN-WH-001, DBN-WH-003
DATASOURCE_TIMEOUTDatasource timed outYour warehouse did not answer in time.DBN-WH-007
AUTH_FAILEDWarehouse login rejectedYour warehouse rejected the user name, password or key that Databrain signs in with.DBN-WH-002
PERMISSION_DENIEDPermission deniedThe Databrain user in your warehouse cannot read a table that the query uses.DBN-WH-005
SCHEMA_TABLE_NOT_FOUNDTable or column not foundA table or column that the query reads is not in your warehouse.DBN-QRY-002
DATABASE_NOT_FOUNDDatabase not foundThe database named in the datasource settings is not in your warehouse.DBN-WH-008
DATASOURCE_NOT_FOUNDDatasource not foundThe datasource of this metric no longer exists in Databrain.DBN-CFG-006
QUERY_INVALIDQuery syntax errorYour warehouse could not run the query because the SQL has a syntax error.DBN-QRY-001
QUERY_TIMEOUTQuery timed outThe query ran too long and was stopped.DBN-QRY-003
QUEUE_TIMEOUTQuery engine busyThe query engine was busy, so the query did not start.DBN-SYS-001
DATASOURCE_BUSYDatasource busyYour warehouse was busy or refused the query because a limit was reached.DBN-WH-004
RESULT_TOO_LARGEResult too largeYour warehouse refused to return the result because it is too large.DBN-WH-009
LIMIT_EXCEEDResult over the Databrain limitThe result is larger than Databrain returns for one chart.DBN-QRY-004
UNRESOLVED_VARIABLEVariable with no valueThe SQL of the metric has a variable that has no value.DBN-CFG-002
TABLE_APP_FILTER_NOT_APPLIEDTable filter not appliedA table filter from the guest token could not be applied, so the query did not run.DBN-TEN-202
QUERY_REFUSEDQuery refusedDatabrain did not run the query.DBN-CFG-002
SERVICE_UNAVAILABLEFile query service downDatabrain’s file query service, which runs queries on Amazon S3 and CSV datasources, did not answer.DBN-SYS-001
HASURA_TIMEOUTDatabrain service timed outA Databrain service took too long to answer.DBN-SYS-001
No reasonUnknown causeDatabrain does not know the cause. The message is “An error occurred while fetching data from the database.”DBN-SYS-000

An error with no reason still has a ref. Search for it in Settings > Diagnostics > Logs, or send it to support.

On this page