Skip to Content

Query error reasons

Variable with no value

The SQL of the metric has a variable that has no value.

Reason in E1005Diagnostic codeWho can fix itDoes a retry help?
UNRESOLVED_VARIABLEDBN-CFG-002Your adminNo

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

WhoMessageNext step
Admin or API callerThis 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 viewerThis chart has a data setup problem.Contact your admin.

How to fix it

  1. Add a dashboard filter for each variable in the error, or give the variable a default value.
  2. 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.

On this page