How To Fix ESH_SQL_SEARCH071 - Last change of CDS entity &1 (connector: &2) has been done by user &3

SAP Error Message - Details

• Message type: E = Error

• Message class: ESH_SQL_SEARCH - ESH SQL Search

• Message number: 071

• Message text: Last change of CDS entity &1 (connector: &2) has been done by user &3

What causes this issue?

Last change of CDS-entity <(>&<)>1 (connector name:<(>&<)>2) has been
done by user <(>&<)>3

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?

If you want to check the CDS entity you can display the DDL definition
in the Data Dictionary (DDIC) as follows:
Open the Data Dictionary (SE11)
Select the radio button 'View' and enter the name of the corresponding
SQL view which is associated with the CDS entity.
You can derive the SQL view name as follows:
Get the corresponding search connector name, for example
CD$ALL~ESH_U_MATERIAL~, and take the name part which is delimited by the
characters '~', e.g. in the example: ESH_U_MATERIAL
Display the CDS view. The Data Dictionary will display the fields of the
search connector.
With double click on the content of the DDL source you can jump into the
definition of the CDS entity

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 ESH_SQL_SEARCH071 - Last change of CDS entity &1 (connector: &2) has been done by user &3 ?

  The SAP error message ESH_SQL_SEARCH071 indicates that there is an issue related to the last change of a Core Data Services (CDS) entity in the context of the SAP Enterprise Search (SAP ESH). This message typically arises when there is a discrepancy in the metadata of the CDS entity, particularly in relation to the user who last modified it.
  
  Cause:
  
  User Modification: The error suggests that the CDS entity was last modified by a user who may not have the necessary permissions or is not recognized in the current context.
  Metadata Inconsistency: There may be inconsistencies in the metadata of the CDS entity, possibly due to changes made in the underlying database or in the CDS definition itself.
  Transport Issues: If the CDS entity was transported from one system to another (e.g., from development to production), there might be issues related to the transport that could lead to this error.
  
  
  Solution:
  
  Check User Permissions: Ensure that