Query error reasons
Variable with no value
The SQL of the metric has a variable that has no value.
Reason in E1005 | Diagnostic code | Who can fix it | Does a retry help? |
|---|---|---|---|
UNRESOLVED_VARIABLE | DBN-CFG-002 | Your admin | No |
What this means
The SQL of the metric has a variable that has no value. A {{variable}} in the SQL got no value from a filter or a default. The query did not run. The error lists the variable names and keeps the older code E1001 in details.legacyCode.
What people see
| Who | Message | Next step |
|---|---|---|
| Admin or API caller | This query has variables with no value: <names>. | Add a dashboard filter for each variable, or give it a default value. Variable names are case-sensitive. |
| Embed viewer | This chart has a data setup problem. | Contact your admin. |
How to fix it
- Add a dashboard filter for each variable in the error, or give the variable a default value.
- Check the spelling: variable names are case-sensitive.
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.