How can I get param_query_x_ to work properly?

[wrightling]

We recently moved to v26.3.0 and are making use of param_query_x to reuse some of our base queries across various reports. My coworker has some that are working fine.

I spent last night trying to do so - first trying to call a query within a report that has two params, both of which are multiselect dropdowns - I thought the multiselect was what was not working, so I created what I thought was the simplest possible case to test and still can't get it to work.

Here is the query I'm trying to re-use:

select {{ wanumber }} + 1 as the_num - where "wanumber" is a dropdown single select param with 3 possible values (123, 400, and 501).

Here is the query I created that uses the Query Reader data source (same one that works fine for my friend's query):

select the_num
from param_query_1868_{wanumber=123}

Both queries are published.

When I execute the calling query, I get an error message Error running query: Failed loading results for query id 1868. , and when I check in chrome dev tools, the /api/events call simply returns null.

In case helpful, I found this in the redash logs:

[2026-07-16 15:22:32,023][PID:8][INFO][rq.worker] queries: 5e607aee-6cf1-4808-b80c-6de418ece5a9
[2026-07-16 15:22:32,038][PID:39492][INFO][rq.job.redash.tasks.queries.execution] job.func_name=redash.tasks.queries.execution.execute_query job.id=5e607aee-6cf1-4808-b80c-6de418ece5a9 job=execute_query state=load_ds ds_id=9
[2026-07-16 15:22:32,105][PID:39492][INFO][rq.job.redash.tasks.queries.execution] job.func_name=redash.tasks.queries.execution.execute_query job.id=5e607aee-6cf1-4808-b80c-6de418ece5a9 job=execute_query state=executing_query query_hash=3e1fac192c047c49848fdf9bd8b18b1f type=results ds_id=9 job_id=5e607aee-6cf1-4808-b80c-6de418ece5a9 queue=queries query_id=1869 username=wwright@norwex.com
[2026-07-16 15:22:32,133][PID:39492][WARNING][rq.job.redash.tasks.queries.execution] job.func_name=redash.tasks.queries.execution.execute_query job.id=5e607aee-6cf1-4808-b80c-6de418ece5a9 Unexpected error while running query:
Traceback (most recent call last):
File "/app/redash/tasks/queries/execution.py", line 208, in run
data, error = query_runner.run_query(annotated_query, self.user)
~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/app/redash/query_runner/query_results.py", line 176, in run_query
create_tables_from_query_ids(user, connection, query_ids, query_params, cached_query_ids)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/app/redash/query_runner/query_results.py", line 92, in create_tables_from_query_ids
results = get_query_results(user, query[0], False, query[1])
File "/app/redash/query_runner/query_results.py", line 80, in get_query_results
raise Exception("Failed loading results for query id {}.".format(query.id))
Exception: Failed loading results for query id 1868.
[2026-07-16 15:22:32,136][PID:39492][INFO][rq.job.redash.tasks.queries.execution] job.func_name=redash.tasks.queries.execution.execute_query job.id=5e607aee-6cf1-4808-b80c-6de418ece5a9 job=execute_query query_hash=3e1fac192c047c49848fdf9bd8b18b1f ds_id=9 data_length=None error=[Failed loading results for query id 1868.]
[2026-07-16 15:22:32,141][PID:39492][INFO][rq.worker] queries: Job OK (5e607aee-6cf1-4808-b80c-6de418ece5a9)
[2026-07-16 15:22:32,141][PID:39492][INFO][rq.worker] Result is kept for 43200 seconds