Skip to Content
avatar image
Former Member

XML Messages Archiving

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 13, 2015 at 10:25 AM

    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.


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 13, 2015 at 11:21 AM

    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 -> 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

    Add comment
    10|10000 characters needed characters exceeded