Specified query not executable here - pentaho reporting

Question

So I've designed a report in Pentaho Report Designer 3.9 and previewed it and ran it on my machine and everything works fine.

I have an input paramater that is a dropdown list and gets its values from a query called Vertical-List.

Now the drop down works on my machine. However, when I publish the report to the Online interface and try to access it, I get a message that says "The Specified query 'Vertical-List' is not executable here". I don't know what that means and what to do. It worked this morning and suddenly it stopped working.

Please help a brother out.

here is the query that generates the drop down

SELECT
     `verticals`.`vertical_id`,
     `verticals`.`vertical_name`
FROM
     `verticals`

Answer 1

Double check your datasource and query, especially the parameters. If you have parameters, remember that a parameter is read in the Pentaho Report Designer as ${parameter_name}.

Also double check that you have defined the datasource in your BI Server.