While all the relevant fields from data source have the column type = 'Text', PPM is trying to convert them into number, showing error: Error when parsing a Number field from SQL Datasource to OData number.

Environment

PPM 24.3
 

Situation

The following error is shown from Excel when refreshing Excel sheet with data from OData datasource:



When looking into serverLog, the following stack trace can be found:

ERROR JSESSIONID=69FB722203DC146F1560E3BEE829CDCA.prod_5,USERNAME=:http-nio-8084-exec-51:(SQLDatasourceODataService.java:379):2024/09/12-13:09:49.002 SAST: Error when parsing a Date field with date format 'yyyy-MM-dd' from SQL Datasource to OData number, for value: 
ERROR JSESSIONID=69FB722203DC146F1560E3BEE829CDCA.prod_5,USERNAME=:http-nio-8084-exec-51:(SQLDatasourceODataService.java:368):2024/09/12-13:09:49.002 SAST: Error when parsing a Number field from SQL Datasource to OData number, for value:ZAR0
[...]
ERROR JSESSIONID=69FB722203DC146F1560E3BEE829CDCA.prod_5,USERNAME=:http-nio-8084-exec-51:(SQLDatasourceODataService.java:368):2024/09/12-13:09:49.008 SAST: Error when parsing a Number field from SQL Datasource to OData number, for value:ZAR0
ERROR JSESSIONID=69FB722203DC146F1560E3BEE829CDCA.prod_5,USERNAME=:http-nio-8084-exec-51:(ODataServletErrorProcessor.java:68):2024/09/12-13:09:49.017 SAST: Error in ODataServlet
java.lang.RuntimeException: Wrong value for property!
    at com.microfocus.ppm.odata.service.EntityBasedODataService$2.readEntityCollection(EntityBasedODataService.java:268)
    at org.apache.olingo.server.core.ODataDispatcher.handleEntityCollectionDispatching(ODataDispatcher.java:539)
[...]
Caused by: Wrong value for property!
    at org.apache.olingo.server.core.serializer.json.ODataJsonSerializer.writePropertyValue(ODataJsonSerializer.java:791)
[...]
Caused by: org.apache.olingo.commons.api.edm.EdmPrimitiveTypeException: The value type class java.lang.String is not supported.
    at org.apache.olingo.commons.core.edm.primitivetype.EdmDate.internalValueToString(EdmDate.java:107)
[...]
STATUS JSESSIONID=60172895F4B9E6960F87A67A0DE97739.prod_5,USERNAME= server:http-nio-8084-exec-7:(StreamEncoder.java:221):2024/09/12-13:09:50.076 SAST: Sep 12, 2024 1:09:50 PM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet [ODataLinkServlet] in context with path [/itg] threw exception
An unknown error has occurred. For more information, please contact your administrator and provide the following GUID number:
GUID=BBFED3AD-084E-E584-5D1B-25C677AC369B     
Generated Time=2024/09/12-13:09:50.068 SAST
nested detail:Executing an update/delete query

Cause

Error was thrown when date column is empty.

Read full article