Query error reasons
Datasource unreachable
Databrain could not open a connection to your warehouse.
Reason in E1005 | Diagnostic code | Who can fix it | Does a retry help? |
|---|---|---|---|
DATASOURCE_UNREACHABLE | DBN-WH-001, DBN-WH-003 | Your admin | Yes, unless the cause is SSL |
What this means
Databrain could not open a connection to your warehouse. The warehouse refused the connection, the host name did not resolve, or the network dropped it. Databrain also refuses a host that is private, loopback or not a valid name. A failed SSL handshake uses the same reason with the code DBN-WH-003, and a retry does not help it.
What people see
| Who | Message | Next step |
|---|---|---|
| Admin or API caller | Databrain could not reach the data source. | Ask your admin to check the host, port and network allowlist. |
| Admin or API caller (SSL) | Databrain could not open a secure connection. | Ask your admin to check the SSL settings. |
| Embed viewer | The data can’t be reached right now. | Try again in a few minutes. |
| Embed viewer (SSL) | This chart has a data setup problem. | Contact your admin. |
How to fix it
- Check that the warehouse is running and not paused.
- Go to Datasources, open the datasource and check the host and the port.
- Check that the warehouse’s network allowlist lets Databrain connect.
- For the SSL message, check the SSL mode and the certificate of the datasource.
Warehouse codes behind it
| Warehouse | Codes |
|---|---|
| Network | ECONNREFUSED, ENOTFOUND, EHOSTUNREACH, ENETUNREACH, ECONNRESET, EPIPE |
| MySQL, SingleStore | 2003, 2005, 2006, 2013 |
| PostgreSQL, Redshift, CockroachDB | SQLSTATE 57P01, 57P02, 57P03, 08003, 08006 |
| ClickHouse | 210 (NETWORK_ERROR) |
| BigQuery | backendError, internalError, jobBackendError |
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.