Hello,

I had a quick question regarding Pentaho reports which are displayed in
reports section.
For eg:
*Report>Loans>Active Loans-Details(Pentaho)*

I get an error when I access these Pentaho reports:
*org.apache.tomcat.jdbc.pool.interceptor.SlowQueryReport reportFailedQuery*
*WARNING: Failed Query Report SQL=select x.* from ((NULL)) x; *

I observed that* report_sql* for *report_type=PENTAHO* in *strechy_report
table* is null.

I did some analysis by adding debug statements in the code and found that
report sql was being fetched using:

"*select report_sql as the_sql from stretchy_report where report_name =
'Active Loans - Summary(Pentaho)*"

this results in : "*select x.* from ((NULL)) x* " and thus the error

Please correct me if I am wrong.
Kindly let me know, if I am missing some configuration somewhere.

Regards,
Nikhil

Reply via email to