How To Fix ESH_ENG_CDSVAL_ES044 - 'filteringAttribute.displayPosition': Duplicate value &2 (&1)

SAP Error Message - Details

• Message type: E = Error

• Message class: ESH_ENG_CDSVAL_ES - ES-CDS/ABAP: Validation of domain @EnterpriseSearch

• Message number: 044

• Message text: 'filteringAttribute.displayPosition': Duplicate value &2 (&1)

What causes this issue?

Value &V1& is defined several times for
@EnterpriseSearch.filteringAttribute.displayPosition; or, the same value
is used with @EnterpriseSearch.filteringFacet.displayPosition.
As the UI can display a mixed list of filtering means (facet and
attribute filter), the display positions can be interpreted overarching
across both annotations.

System Response

The display order of all elements with the duplicate position counter is
undefined.
The system will nevertheless activate and run the view for Enterprise
Search.

How to fix this error?

Check whether the position counter can be made unambiguous.

Procedure for System Administrators

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message ESH_ENG_CDSVAL_ES044 - 'filteringAttribute.displayPosition': Duplicate value &2 (&1) ?

  The SAP error message ESH_ENG_CDSVAL_ES044 indicates that there is a duplicate value in the context of a filtering attribute in a Core Data Services (CDS) view. This error typically arises when the same value is being assigned to multiple entries in a filtering attribute, which is not allowed.
  Cause:
  
  Duplicate Values: The error is triggered when the same value is assigned to more than one entry in the filtering attribute's display position.
  Incorrect Data Model: The underlying data model may have duplicates that are not being handled correctly.
  Configuration Issues: There may be issues in the configuration of the CDS view or the associated annotations that lead to this duplication.
  
  Solution:
  
  
  Check for Duplicates: Review the data in the underlying tables or views to identify any duplicate entries that may be causing the issue. You can use SQL queries to find duplicates based on the filtering attribute.
  
  
  Adjust Display Positions: If you are defining display positions for filtering attributes in your CDS view, ensure that each display position is unique. Modify the annotations to assign unique display positions to each entry.
  
  
  Modify the CDS View: If the duplicates are legitimate and should be handled differently, consider modifying the CDS view to aggregate or filter the data appropriately to avoid duplicates.
  
  
  Review Annotations: Check the annotations in your CDS view definition. Ensure that the annotations related to filtering attributes are correctly defined and do not lead to conflicts.
  
  
  Testing: After making changes, test the CDS view to ensure that the error is resolved and that the filtering attributes behave as expected.
  
  
  Related Information:
  
  SAP Documentation: Refer to the official SAP documentation for Core Data Services and filtering attributes for more detailed information on how to define and manage these attributes.
  SAP Community: Engage with the SAP Community forums to see if others have encountered similar issues and what solutions they have implemented.
  Debugging Tools: Utilize SAP debugging tools to trace the execution of the CDS view and identify where the duplication is occurring.
  
  By following these steps, you should be able to resolve the ESH_ENG_CDSVAL_ES044 error and ensure that your CDS view functions correctly without duplicate filtering attributes.