Rollback RSXMB_TABLE_SWITCH

[#1]

Hi all

SAP PI 7.11

SWITCH procedure is active, the report RSXMB_TABLE_SWITCH took approximately 15 days. The active container is 2

90% of messages are marked for archiving. The archiving jobs have not been executed in the last 5 years.I had to schedule the archiving jobs, the archiving jobs and they were working well.

The job SAP_BC_XMB_DELETE_001 was executed but changed the active container to 1. I had to cancel the job.

I can not wait another 15 days for it to finish moving messages from one container to another. How can I rollback switch procedure? How else can I delete the messages that are marked for archiving?

Thanks

[marksmyth]

Hello Alex,

Check note 1883520 PI: How to Deactivate the Switch Deletion Procedure

Also see the wiki Overview of the Switch Deletion Procedure

Regards
Mark

[alex_matuttisanchez]

Hi Mark

Thanks for your answer. I read note 1883520, but it does not indicate how to reverse the switching once it starts. I can let the whole process be completed, but it takes too much time, more than 17 days.

The persistence layer is at 219%, there are marked messages for archiving that need to be deleted, but this step can not be done, until the switching ends.

Regards.

Alex