3506732 - ODataQuery service ( CDS based) : The argument 'XXXXXX' cannot be interpreted as a number

Run OData service <ODataQuery service ( CDS based) > hitting error, example in Gateway Error log:

.ERROR_CONTEXT    
..ERROR_INFO    The argument 'XXXXXX' cannot be interpreted as a number
..ERROR_RESOLUTION    
...SAP_NOTE    See SAP Note 1797736 for error analysis
...LINK_TO_SAP_NOTE    https://service.sap.com/sap/support/notes/1797736
..Exceptions    
.../IWCOR/CX_DS_INTERNAL_ERROR    
....Text    In the context of Data Services an unknown internal server error occurred
....Source    
.....Program    SAPMHTTP
...CX_SY_NO_HANDLER    
....Text    An exception with the type CX_ST_DESERIALIZATION_ERROR was raised, but was not handled locally or declared in a RAISING clause.
....Attributes    
.....CLASSNAME    CX_ST_DESERIALIZATION_ERROR
....Source    
.....Program    /IWBEP/CL_MGW_DATA_HELPER=====CP
.....Include    /IWBEP/CL_MGW_DATA_HELPER=====CM004
.....Line    1
...CX_ST_DESERIALIZATION_ERROR    
....Text    An error occurred when deserializing in the simple transformation program /IWBEP/ST_ANY_DATA
....Attributes    
.....CLASSNAME    CX_XSLT_DESERIALIZATION_ERROR
.....ST_PROGNAME    /IWBEP/ST_ANY_DATA
.....XML_OFFSET    114
.....XML_PATH    ANY_DATA(1)item(1)FISCYEARPER(3)
....Source    
.....Program    /IWBEP/CL_MGW_DATA_HELPER=====CP
.....Include    /IWBEP/CL_MGW_DATA_HELPER=====CM004
.....Line    29
...CX_XSLT_DESERIALIZATION_ERROR    
....Text    Error during deserialization
....Attributes    
.....CLASSNAME    CX_SY_CONVERSION_NO_NUMBER
.....TREE_POSITION    ???.1.3
....Source    
.....Program    /IWBEP/ST_ANY_DATA============XT
.....Include    /IWBEP/ST_ANY_DATA============XT
.....Line    7
...CX_SY_CONVERSION_NO_NUMBER    
....Text    The argument 'XXXXXX' cannot be interpreted as a number
....Attributes    
.....VALUE    000.2023
....Source    
.....Program    /IWBEP/ST_ANY_DATA============XT
.....Include    /IWBEP/ST_ANY_DATA============XT
.....Line    7


OData is generated via CDS view with annotation: 

• @OData.publish: true
  
  

Date-based dimension is mapped as Edm.Int32, $metadata result:

<Property Name="XXXXX" Type="Edm.Int32" sap:aggregation-role="dimension" sap:label="XXXXX" sap:creatable="false" sap:updatable="false"/>  

• SAP Gateway (OData)
• ODataQuery service ( CDS based)

/IWCOR/CX_DS_INTERNAL_ERROR  , CX_SY_CONVERSION_NO_NUMBER, CX_XSLT_DESERIALIZATION_ERROR , CL_NAT_GENERIC_MPC, CL_NAT_GENERIC_DPC , KBA , OPU-GW-COR , Framework , BW-BEX-OT-BICS-EQ , oDATA Query / (Easy Query) , Problem