Hi Peter, I think the reports are failing because you are using a PostgreSQL database and the reports you are using are for MariaDB. The SQL queries for the reports are MariaDB/MySQL compatible and will fail when using a PostgreSQL database.
1. Try using a MariaDB database 2. Or if you insist on PostgreSQL, you may need to change the queries of the individual reports to PostgreSQL compatible queries. Regards. Honest Chirozva Technical Consultant TAAT Consulting ________________________________ From: PETER KIPROP <kipropli...@gmail.com> Sent: Tuesday, April 30, 2024 2:52:36 PM To: dev@fineract.apache.org <dev@fineract.apache.org> Subject: PENTAHO REPORTS - Postgres Hello Dev, I am trying to run pentaho reports with mifos, The deployment was successful but i am facing a query error as attached below, The sample report i am running is as below https://localhost:8443/Re-Bank/api/v1/runreports/Client%20Listing(Pentaho)?tenantIdentifier=default&locale=en&dateFormat=dd%20MMMM%20yyyy&R_selectOffice=1&output-type=PDF
