Question about Note 886102 - Empty the delta queue of the connected SAP source systems

[Former Member]

Dear expert

I'm doing the system refresh from ECC PRD to QAS using the hot backup of PRD

Before i start the database restore i was told to do the following step since this ECC has connection with one BW system

-----------------------Step -----------------------------

2.17 SAP note 886102 scenario C3

Empty the delta queue for all of the connected BW systems.

Execute all delta info packages two times on BW side, to clean up the delta queue in the source system. This is needed, because BDLS cannot rename the still available LUW-s in the qRFC queue.

----------------------Step-----------------------

But unfortunately i missed to execute this step

And the Q11 is now retoreing the backup of the database

My quesion

1. what will be bad consequence due to not execute this step? any way to makeup this error?

Best regards,

[former_member188883 · Accepted solution]

Hi Kate,

The probably issue which I could forsee is data getting wrongly updated into production if RFC connection from ECC to BW is not stopped.

Solution here could be to disable or deletethe RFC connections between ECC and BW before starting the SAP system at database level.

delete from sapr3.rfcdes where rfcdest = '<name>';

Once the system is up and running you can recreate them if required.

Also before starting SAP set the number of batch processes to 0 on the profile at OS level so that any released jobs don't start as soon as SAP is up.

Once the SAP system is up execute BDLS and change the logical system name.

Hope this helps.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak,

we run the following script on the QAS ECC right?

delete from sapr3.rfcdes where rfcdest = '<name>';

what should be the <name>? the logical name of ECC PRD or BW PRD?

Best regards

Kate

[Sriram2009 · Accepted solution]

Hi Kate

In QAS system at OS level you can add enter in the local host file of PRD BW
" system name = different IP address(Not on live PRD BW system)" you can avoid the conflict

BR

SS

[former_member188883 · Accepted solution]

Hi Kate,

RFC name should of BW Production incase you run the script on ECC QAS.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Thank you so much Sriram!

[Former Member · Accepted solution]

Thank you very much Deepak!

[Reagan]

You do not need to delete any connections from RFCDES.

After the restore of database is done you just need to lock all the users before you start SAP.

Also if there are unprocessed LUW entries then read this SAP note

760113 - Delete unprocessed LUWs in the qRFC

Note: I never stopped pr processed the queue before a system copy and I never had any issues with BDLS processing.

Regards

RB

[Former Member]

Thank you very much Reagan.

I will remember to stop all the background job and lock all the user before start sap

Kate