cancel
Showing results for 
Search instead for 
Did you mean: 

job SAP_BC_XMB_DELETE_100 running for long time

Former Member
0 Kudos

Hi All ,

Job SAP_BC_XMB_DELETE_100 is running in two steps :

1 RSXMB_DELETE_MESSAGES

2 RSXMB_TABLE_SWITCH

it is running for long period and getting failed for RSXMB_TABLE_SWITCH .

Please Help.

Thanks,

Swapnil

Accepted Solutions (0)

Answers (1)

Answers (1)

Eoin_Kierans
Product and Topic Expert
Product and Topic Expert
0 Kudos

With what error did the switch job terminate? Were there any dumps in transaction ST22 at the time the switch procedure terminated?

Was there sufficient space available for the messages to be copied to the active container? When the switch procedure starts, messages are copied from the SXMSPMAST to SXMSPMAST2 or vice versa, only when the switch procedure is finished is the inactive container dropped, the table from which messages were copied.

By using the parameter MOVE_INSTEAD_OF_COPY this problem can be overcome, messages are deleted as soon as they are copied across rather than waiting for the procedure to complete, therefore saving on DB space consumption.