How To Fix RSO_CTC124 - Source system &1 is still connected to receiver system &2

SAP Error Message - Details

• Message type: E = Error

• Message class: RSO_CTC - Message class for CTC related messages

• Message number: 124

• Message text: Source system &1 is still connected to receiver system &2

What causes this issue?

While checking if
<DS:TX.RSO_TSPREFIX_RENAME>the transfer structure prefix</> &V3& can be
used for the connection between the BW source system &V1& and the BW
(receiving) system &V2& an error occurred: the two system are still
connected. This must not be, because changing the TSPREFIX on BW side
only will lead to an inconsistency. Instead, the change of the TSPREFIX
in BW must be propagated later into the source system, and this cannot
happen, if the connection is still present in the source system.

System Response

The processing is stopped.

How to fix this error?

Disconnect the BW source system &V1& from BW system by executing the
task
<DS:TX.RSO_BIW_DISCONNECT>CL_RSO_BIW_DISCONNECT</> in the BW system.
Afterwards the prefix check/rename task can be executed and finally the
systems can be connected again.

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 RSO_CTC124 - Source system &1 is still connected to receiver system &2 ?

  The SAP error message RSO_CTC124 indicates that there is an issue with the connection between a source system and a receiver system in the context of SAP BW (Business Warehouse) or SAP BI (Business Intelligence). This error typically arises when there is an attempt to disconnect or delete a connection that is still in use.
  Cause:
  The error message "Source system &1 is still connected to receiver system &2" usually occurs due to one of the following reasons:
  
  Active Connections: There are active data transfers or processes that are still using the connection between the source and receiver systems.
  Open Sessions: There may be open sessions or transactions that are utilizing the connection, preventing it from being disconnected.
  Data Transfer Processes (DTPs): If there are ongoing DTPs or InfoPackage processes that are using the connection, it cannot be removed or modified.
  Incorrect Configuration: There might be configuration issues in the source or receiver system that are causing the connection to remain active.
  
  Solution:
  To resolve the RSO_CTC124 error, you can follow these steps:
  
  
  Check Active Processes:
  
  Go to the transaction code SM37 to check for any active jobs or processes that are using the connection. If you find any, you may need to wait for them to complete or terminate them if they are stuck.
  
  
  
  Review Data Transfer Processes:
  
  Check if there are any Data Transfer Processes (DTPs) or InfoPackages that are currently running. You can do this in the Data Warehousing Workbench (transaction code RSA1).
  If there are active DTPs, you may need to wait for them to finish or cancel them.
  
  
  
  Check for Open Sessions:
  
  Ensure that there are no open sessions in the source or receiver system that are using the connection. You can check this in transaction SM04 or AL08.
  
  
  
  System Logs:
  
  Review the system logs for any additional error messages or warnings that might provide more context about the issue.
  
  
  
  Configuration Review:
  
  Verify the configuration settings for the source and receiver systems to ensure they are correctly set up and there are no discrepancies.
  
  
  
  Restart the Systems:
  
  If the issue persists and you have the necessary permissions, consider restarting the source or receiver system to clear any lingering connections.
  
  
  
  Contact SAP Support:
  
  If you are unable to resolve the issue with the above steps, consider reaching out to SAP Support for further assistance.
  
  
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with relevant transaction codes such as RSA1 (Data Warehousing Workbench), SM37 (Job Monitoring), SM04 (User Overview), and AL08 (Global User Overview).
  Documentation: Review SAP documentation related to data transfer processes and system connections for best practices and troubleshooting tips.
  SAP Notes: Check for any relevant SAP Notes that may address this specific error or provide additional troubleshooting steps.
  
  By following these steps, you should be able to identify and resolve the issue causing the RSO_CTC124 error message.