Plateau Report Designer Error SAP DBTech JDBC: [339]: invalid number: Cannot convert string ' to int

[cristinaruiz]

Hello all. I am facing a weird issue with a report in LMS. The report works fine in the the Preview instance filtering by any parameter. If we upload it to the Prod instance and filter by user or Organization, all good. But If we want to use the year selector (2024/2025) we get this error, only for 2025. 2024 extracts the data correctly.

Checking the log here are some lines about that error of "cannot convert string...". Find attached the complete log. Honestly, I don't know where else to look at. The sql query works fine in Test, but only Prod and 2025 fails. Any ideas???

Thanks everyone

Caused by: com.plateau.common.core.api.util.exceptions.MultipleExceptionsException
at com.plateau.common.reportservice.impl.DefaultReportRunner.checkFailingReports(DefaultReportRunner.java:276)
at com.plateau.common.reportservice.impl.DefaultReportRunner.run(DefaultReportRunner.java:214)
... 35 more
Suppressed: org.eclipse.birt.report.engine.api.EngineException: Cannot execute the statement.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
SQL error #1:SAP DBTech JDBC: [339]: invalid number: Cannot convert string '113487.06' to int
;
com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [339]: invalid number: Cannot convert string '113487.06' to int
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1245)
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1224)

#plateaureportdesigner SAP SuccessFactors Learning