3600520 - Error "Failed to access ESH search service" when validate S/4HANA On-Premise connection in Datasphere

When validate the S/4HANA On-Premise connection in Datasphere, below error message is displayed in the details:

Model Import: Failed to access ESH search service. Please heck if the user has the required privileges in the backend system
Reason: 404: Not Found

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."  

SAP Datasphere

1. Select the checkbox in front of the connection to S/4HANA On-Premise.
2. Click Validate button.

ESH search service - ESH_SEARCH_SRV is not active in the S/4HANA On-Premise.

1. Run transaction code /n/iwfnd/maint_service.
2. Search ESH_SEARCH_SRV.
   
3. Make sure service ESH_SEARCH_SRV exists under Technical Name ZESH_SEARCH_SRV, Version 1, External Service Name: ESH_SEARCH_SRV.
4. If the service has not yet been set up:
   1. Click "Add Service" button.
   2. Filter with System Alias:  LOCAL, External Service Name: ESH_SEARCH_SRV, Version: 1. Click "Get Services" button.
      
   3. Select the found service and click on "Add Selected Services".
      
   4. In the following dialog box, confirm the proposed default settings. 
      
   5. Service 'ESH_SEARCH_SRV' was created and metadata was loaded successfully.
      
5. Go back to /n/iwfnd/maint_service, click on Technical Name ZESH_SEARCH_SRV to show the details in the bottom in the page.
6. Put the cursor on "Status" icon, make sure it is "Service is active". 
   
7. If not, click "ICF Node" button, select "Activate".
   
8. Click "ICF Node" button, select "Configure(SICF)". Make sure the service sap/opu/odata/sap/esh_search_srv is active.
   
9. Go back to /n/iwfnd/maint_service, select ESH_SEARCH_SRV, click "SAP Gateway Client".
   
10. Click "Execute" button, and make sure the execution is successful(status code: 200).
    

SAP Notes 3081998 Metadata import of CSN entities from SAP S/4HANA, on-premise edition to SAP Datasphere Cloud - central initial note

Connection error, remote source,  ESH search service, , sap/opu/odata, SAP Notes 0003081998, SAP Notes 0003463326. , KBA , DS-DI-CON , Connections , BC-EIM-ESH , NetWeaver Enterprise Search , DS-MD-ESH , Repository Explorer , Problem