Re-initializing of deltas in BW4HANA from S4HANA (For error Subscription for DTP* deleted in source)

[abhilekhsharma57]

Overview:

Re-initializing deltas between S4HANA and BW4HANA is vital for maintaining precise data synchronization. This process entails removing the existing initialization request in BW4HANA, purging previous data from the data targets, and establishing a new initialization. The error message indicates that the subscription for the Data Transfer Process (DTP) has been removed in the source system (S4HANA).

To address this issue, examine the DTP settings in BW4HANA, recreate the subscription if necessary, review system logs for further details, and re-initialize the delta process.

Error Occurred in BW4HANA System:

Subscription for DTP* deleted in source system. The error is due to deletion on subscription in S4 side or the subscription of DTP is mapped to wrong source system.

Check ODQMON by putting data source name in queue and see the subscriptions. 

Solution to the error:

Resolution 1:

Step 1) To delete a subscription in T-Code ODQMON in S4HANA, open ODQMON, select the DataSource, go to the "Subscriptions" tab, and delete the desired subscription. Confirm the deletion by checking the "Queues" tab to ensure the request is inactive. 

Step 2) To initiate a new subscription from BW4HANA to S4HANA, it is essential to delete all existing requests in the target system. If these requests are not removed, you will encounter errors. Therefore, ensure that all pending requests are cleared before proceeding with the new subscription setup. This step is crucial to avoid any interruptions or issues during the process.

Before deleting all the requests in BW side, ensure that you have created a copy of your DSO, ADSO or info objects.

Open the monitor in SAP GUI

Change overall Status to RED 

And delete the requests one by one. Please ensure all the requests are deleted from the target before moving to next step.

Step 3) To begin, manually initiate the Data Transfer Process (DTP) in delta mode using Eclipse. After starting the DTP, check the ODQMON transaction in your S4HANA system to confirm that a new subscription has been created. This verification step is crucial to ensure that the data transfer setup is functioning correctly.

Note** If you continue to encounter errors on the BW4HANA side after completing the previous steps, please run the report RODPS_REPL_TEST in transaction SE38 for the data source on the S4HANA side. This report will help diagnose and resolve any remaining issues with the data transfer process.

Resolution 2:

     Deleting the existing DTP

• Identify the DTP: Locate the Data Transfer Process (DTP) associated with the info provider you want to update.
• Remove from Process Chains: Ensure that the DTP is removed from all related process chains to avoid any disruptions.
• Delete the DTP: Once removed from the process chains, delete the DTP from the system.    

     

      Creating a New Delta DTP

• Create the Delta DTP: Set up a new delta DTP in BW. This DTP will handle the incremental data loads.
• Run Initialization Without Data: Execute the initialization process without transferring any data. This step is crucial as it creates a new subscription in S4HANA.
• Monitor in ODQMON: Check the Operational Delta Queue Monitor (ODQMON) in S4HANA to ensure that new delta records are being captured correctly.

     Handling Potential Data Loss

• Create a Repair DTP: If there's a risk of data loss, create a Repair DTP to perform a full data load. This ensures that all data is transferred accurately.
• Compare Data Volumes: For large data volumes, compare the data in BW and S4HANA to identify any discrepancies or missing records.
• Load Missing Data: Use the Repair DTP with specific selections to load the missing data into BW. This step ensures data consistency between BW and S4HANA.

     Additional Tips

• Regular Monitoring: Continuously monitor the data transfer process to catch any issues early.
• Backup Data: Always have a backup of your data before making significant changes to the DTPs.
• Documentation: Keep detailed documentation of the changes made for future reference and troubleshooting

By following these steps, you can effectively manage your data transfer processes in SAP BW and S4HANA, ensuring data integrity and minimizing the risk of data loss.