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

SAP Error Message - Details

• 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.

Smart SAP Assistant

• What is the cause and solution for SAP error message BW_BICS_EQ104 - Delete related GW service to stop external usage (/iwfnd/main_service) ?

  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 Service:
  
  If you find that the service is still active, you can either deactivate or delete it.
  To delete the service, select the service and choose the delete option.
  If you want to deactivate it temporarily, you can do so to ensure that no external calls are made to the BW query.
  
  
  
  Check for Open Sessions:
  
  Ensure that there are no open sessions or connections that might be using the BW query.
  You can check for active sessions in transaction code SM04 or AL08.
  
  
  
  Retry Deletion:
  
  Once you have ensured that there are no active connections or services using the BW query, try to delete the query again.
  
  
  
  Restart Gateway Services (if necessary):
  
  If the issue persists, consider restarting the Gateway services to clear any lingering connections.
  
  
  
  Related Information:
  
  
  Transaction Codes:
  
  /IWFND/MAINT_SERVICE: Manage OData services.
  SM04: User sessions overview.
  AL08: Overview of all users logged into the system.
  
  
  
  Documentation:
  
  Refer to SAP Help Portal for detailed documentation on BW queries and Gateway services.
  Check SAP Notes for any specific patches or updates related to this error.
  
  
  
  Best Practices:
  
  Regularly monitor and manage Gateway services to avoid conflicts with BW queries.
  Ensure proper documentation and communication when making changes to BW queries that might affect external services.
  
  
  
  By following these steps, you should be able to resolve the BW_BICS_EQ104 error and successfully manage your BW queries and Gateway services.