Bahmni custom SQL report breaking

Good day everyone,

One of our bahmni reports (a custom SQL report) is breaking and returning the error messages below. We can run the same SQL successfully directly on MySQL cli from the server, the problem occurs in Bahmni irrespective of the format of the report we select. Because the issue only occurs for a specific date range, we do suspect an issue with the data, but we are unable to trace the problem because the exact SQL runs fine and returns the expected result in MySQL cli. We have searched and couldn’t find a reference to this error on the forum. Have you ever encountered this issue? Could you please point us to how to dig further and/or resolve the issue?

2021-06-24 16:07:15,611 ERROR [bahmnireports][org.bahmni.reports.web.MainReportController] Error running report
java.lang.ArrayIndexOutOfBoundsException: 0
	at net.sf.jasperreports.engine.util.ParagraphUtil.getFirstTabStop(
	at net.sf.jasperreports.engine.fill.TextMeasurer.renderNextLine(

can you replicate the problem in or in