XML Messages Archiving

[Former Member]

Hello Experts,

While Archiving XML Messages through SARA transaction using BC_XMB, the write program which is triggered is RSXMB_ARCHIVE_MESSAGES. This program doesn't have any date field instead it has some random numbers. What are those random numbers and how the procedure is going. Can anyone please help?

[former_member334189]

Hello Arpan,

whenever a message is received by the central Integration Server (Abap) or a local Integration Engine (Abap) a random numer 0..99 is assigned to it. This number becomes a property of the individual message and stays valid for its entire life cycle.

Using these randomly assigned numbers it is possible to divide the set of all messages into
100 disjoint subsets.

In PI archving always starts with the oldest messages and then moves forward in time.

Putting this together the built-in parallelizer for archving can fire up multiple parallel writers where each writer handles all messages of a particular subset. If, for example, 4 writers have been started in parallel the first one will archive all messages having random number 00..24 beginning with the oldest messages and moving forward in time. The second writer will handle messages having random numer 25..49. Writers 3 and 4 handle ranges 50..74 and 75..99.

We strongly recommend scheduling write processes using transaction SXMS_ADMI_ARCH (SXMB_ADMIN -> Integration Engine -> Administration menu, -> Schedule Archiving Job) rather than SARA. This way a proper setting for the random numbers is created when write jobs are scheduled. For your reference please check documentation at
http://help.sap.com/saphelp_nwpi71/helpdata/en/0e/80553b4d53273de10000000a114084/frameset.htm -> section 'Scheduling Archiving Jobs'

However, in case of a huge backlog you can also schedule report RSXMB_ARCHIVE_MESSAGES directly usign approriate variants for random numbers. For more details please check KBA 1883012, items 6)-8).

Best regards,

     Harald Keimer

     PI Development Support

     SAP SE, Walldorf

Message was edited by: Harald Keimer

[iaki_vila]

Hi Arpan,

If you go to the table SXMSPMAST (Integration Engine: Message Queue (Master)) you can find a field called RND_NUMBER, this field is he field with you can filter with selection range number. The second selection is if you want to test or to do in real.

Regards.