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 or MasterData]: 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%"
• The serialization via ST failed

• 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
  1. /n/IWFND/V4_ADMIN
  2. Expand node "Service Groups"
  3. Find node "CDI_CDS" and double click it
  4. Find the CDS name -> click 'Service Test' -> 'Gateway Client'
  5. Click 'Entity Set' -> Choose the correct Entity set, e.g. Fact or MasterData
  6. Execute
  7. ~status_code is not 0 with the error below:
     'Use ADT feed reader \"SAP Gateway Error Log\" or run transaction /IWFND/ERROR_LOG on SAP Gateway hub system and search for entries with the timestamp above for more details",

Based on the message in Gateway Client test, run transaction /n/IWFND/ERROR_LOG to get more details:

1. Error : Property <field name> has invalid value 'x'
   • 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.
     
     
2. Error: Value N is not a valid truth value according to the XML format for ABAP with CX_SY_CONVERSION_NO_BOOLEAN
   • There's a Y or N value for a field type Boolean. Only 'X' or ' ' is valid for a Boolean field in OData service.
   • Section 'REF_NAME' points out the name of the issued CDS field 

1. For Error: Property <field name> has invalid value 'x'
   • 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).
        
        
2. For Error: Value N is not a valid truth value
   1. Check the definition of the CDS field based on value of 'REF_NAME' in /n/IWFND/ERROR_LOG to verify if it's a Boolean type;
   2. Check the data using SE16 to verify its value is 'N';
   3. Manually add the conversion below (via Custom CDS View app in a Cloud system):
      • case <field name>
        when 'Y'
        then 'X'
        else ' '
        end as <a new field name>

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.

2849242 - Error Property 'ProjectVisibility' has invalid value 'N' when creating a Custom CDS view using I_EngagementProject as data source

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