How To Fix RS_ADSO_MODEL104 - Partitioning criteria &1: Illegal character in value: &2

SAP Error Message - Details

• Message type: E = Error

• Message class: RS_ADSO_MODEL - Messages related to the Datastore Object Backend

• Message number: 104

• Message text: Partitioning criteria &1: Illegal character in value: &2

What causes this issue?

The definition of partition values contains illegal characters.
The following characters are not allowed: ',', '$', '('<(>,<)> '-', and
'*'

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Please correct the definition of your partition values

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RS_ADSO_MODEL104 - Partitioning criteria &1: Illegal character in value: &2 ?

  The SAP error message RS_ADSO_MODEL104 indicates that there is an issue with the partitioning criteria in an Advanced DataStore Object (ADSO). Specifically, it points out that there is an illegal character in the value of the partitioning criteria.
  Cause:
  The error typically arises when:
  
  The partitioning criteria defined for the ADSO contains characters that are not allowed. This could be due to special characters, spaces, or other invalid inputs.
  The data being loaded into the ADSO contains values that do not conform to the expected format or character set for the partitioning criteria.
  
  Solution:
  To resolve the RS_ADSO_MODEL104 error, you can take the following steps:
  
  
  Check Partitioning Criteria:
  
  Review the partitioning criteria defined for the ADSO. Ensure that it only includes valid characters (typically alphanumeric characters and underscores).
  Remove any special characters or spaces from the partitioning criteria.
  
  
  
  Validate Data:
  
  Inspect the data being loaded into the ADSO. Look for any values that might contain illegal characters as defined by the partitioning criteria.
  Cleanse the data to remove or replace any invalid characters before loading it into the ADSO.
  
  
  
  Adjust Data Source:
  
  If the data source is external, ensure that the data being extracted does not contain illegal characters. You may need to apply transformations or filters to clean the data before it reaches the ADSO.
  
  
  
  Test Changes:
  
  After making the necessary adjustments, test the data load process again to ensure that the error is resolved.
  
  
  
  Consult Documentation:
  
  Refer to SAP documentation or community forums for any specific guidelines related to partitioning criteria in ADSOs, as there may be additional constraints or best practices to follow.
  
  
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that might address this specific error or provide additional context.
  Data Modeling: Familiarize yourself with the data modeling concepts in SAP BW/4HANA or SAP BW on HANA, especially regarding ADSOs and their configuration.
  Error Logs: Review the error logs for more detailed information about the context in which the error occurred, which can help in diagnosing the issue.
  
  By following these steps, you should be able to identify and rectify the cause of the RS_ADSO_MODEL104 error in your SAP environment.