How To Fix BW_BICS_EQ104 - Delete related GW service to stop external usage (/iwfnd/main_service)

BW_BICS_EQ104 - Overview

• Message type: E = Error

• Message class: BW_BICS_EQ - Easy Query Messages

• Message number: 104

• Message text: Delete related GW service to stop external usage (/iwfnd/main_service)

What causes this issue?

The OData flag is cleared.

System Response

Clearing this flag does not delete the related gateway service. The
gateway service still exists.

How to fix this error?

The service need to be removed from gateway catalog with transaction
/IWFND/MAINT_SERVICE to end the external usage.
The service gets deleted if the query is deleted.

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.

BW_BICS_EQ104 - Details

• The SAP error message BW_BICS_EQ104 indicates that there is an issue related to the Gateway (GW) service in the context of SAP BW (Business Warehouse) and its integration with external systems. This error typically arises when there is an attempt to delete or modify a BW query that is still being accessed or utilized by an external service.
  
  Cause:
  The error message BW_BICS_EQ104 is triggered when:
  
  An attempt is made to delete a BW query or related object that is currently being used by an external service.
  The Gateway service (IWFND) is still active and connected to the BW query, preventing the deletion.
  There may be lingering connections or sessions that are still utilizing the query.
  
  
  Solution:
  To resolve this error, you can follow these steps:
  
  
  Identify Active Connections:
  
  Use transaction code /IWFND/MAINT_SERVICE to check the active services and their status.
  Look for any services that are linked to the BW query you are trying to delete.
  
  
  
  Delete or Deactivate the