Hi Nikhil, >From which code base you are trying to run Pentaho reports? Make sure your code base is openmf ( https://github.com/openMF/incubator-fineract/tree/mifosplatform-17.07.01.RELEASE )
Regards, Sampath *Conflux Technologies Pvt Ltd <http://www.confluxtechnologies.com/> *#304, 2nd Floor, 7th Main Road HRBR Layout 1st Block Bengaluru, Karnataka, 560043 INDIA Disclaimer: The information contained in this e-mail message and any files/attachment transmitted with it is confidential and for the sole use of the intended recipient(s) or entity identified. If you are not the intended recipient, please email: [email protected] and destroy/delete all copies and attachment thereto along with the original message. Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and is unlawful. The recipient acknowledges that Conflux Technologies Private Limited or its subsidiaries and associated companies are unable to exercise control or ensure or guarantee the integrity of/over the contents of the information contained in e-mail transmissions. Before opening any attachments, please check. On Fri, Aug 4, 2017 at 9:10 PM, Nikhil Pawar <[email protected]> wrote: > 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 >
