Search code examples
pentaho

Specified query not executable here - pentaho reporting

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`
Solution

  • 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.