3529712 - Remote Table replication fails with error: CX_PARAMETER_INVALID_RANGE Parameter has invalid value 'x'

Snapshot replication of a Remote table for a CDS view from a S/4HANA Public Cloud system, fails with error:

• Error occurred when reading data from entitySet [/ABAP_CDS/%CDSDDLNAME%/Facts]: org.apache.olingo.client.api.communication.
• "code":"CX_PARAMETER_INVALID_RANGE","message":"Parameter has invalid value: Parameter <VALUE> has invalid value x."
• {"ComponentId":"BW-WHM-DBA-ODA","ServiceRepository":"CDI_CDS","ServiceId":"%CDSDDLNAME%"

• SAP S/4HANA OP or Cloud as the source
• SAP Datasphere as the target

• Start the replication from Datasphere
  or
• Start the gateway client test in the backend of S/4 system
  • /n/IWFND/V4_ADMIN
  • Expand node "Service Groups"
  • Find node "CDI_CDS" and double click it
  • Find the CDS name -> click 'Service Test' -> 'Gateway Click'
  • Perform the testing

There's a lowercase 'x' in the source view. For a field with type Edm.Boolean in the OData service, only UPPERCASE 'X' is the valid value.

Check the data of the source view to find out the invalid lowercase 'x':

1. /nSE16 -> input the Sqlview name
2. Execute with mode 'SE16 Standard List' which can display the lowercase 'x' and the UPPERCASE 'X'. ('ALV Grid Display' mode doesn't distinguish the lowercase and UPPERCASE)
3. In the result, sort the issued field with 'Sort Ascending'. The lowercase 'x' will be displayed in the first line
4. Modify this lowercase 'x' to UPPERCASE 'X' from the frontend Fiori or backend (this can be done by customer via Fiori in case of a Cloud system).

For a field with type Edm.Boolean:

• 'X' in the source view will be auto converted to 'true' in OData output
• ' '(INITIAL) in the source view will be auto converted to 'false' in OData output.

remote table, snapshot replication, replication, CDS view, parameter, invalid value , KBA , DS-DI-RT , Remote Tables , Problem