Hi Team,

We're seeing the ff error below when attempting to refresh an Excel sheet pulling data from an OData source from PPM.

This was working prior to v24.3 upgrade.

From what I can see, the underlying datasource is fine and can return data when ran directly against the database. The self-service portlet is populating correctly as well.

From the logs, we're seeing a lot of entries similar to the following.

ERROR JSESSIONID=9A2D18A0C77DE4BB30223E359367E576.prod_5,USERNAME=:http-nio-8084-exec-52:(SQLDatasourceODataService.java:368):2024/09/12-12:03:26.032 SAST: Error when parsing a Number field from SQL Datasource to OData number, for value:ZAR1,000
ERROR JSESSIONID=9A2D18A0C77DE4BB30223E359367E576.prod_5,USERNAME=:http-nio-8084-exec-52:(SQLDatasourceODataService.java:368):2024/09/12-12:03:26.033 SAST: Error when parsing a Number field from SQL Datasource to OData number, for value:ZAR0

On the datasource, all the relevant fields have the column type = 'Text' so it shouldn't be converting into a number.

Any guidance would be appreciated.