Understanding Mailbox Message Life Cycle in SB2Bi - What to expect and what you will see?

Body

In this blog i am posting step by step details with screenshots to understand completely about the mailbox message life cycle and associated workflow.

1. Created a simple business process to a message to a mailbox (/BALA). MessageID 11439 is created against this BP execution.

2. Once message added to mailbox successfully we should be able to see the below entry in the mailbox message management screen.

3. Also we should be able to see the below entry in the ARCHIVE_INFO table. The business process is not indexed so it shows ARCHIVE_FLAG as -1 and ARCHIVE_DATE null.

4. When the schedule index business process runs the business process and document gets 10 year lifespan. This is by design.

5. Next when the schedule backup service runs the business process will be archived. But it still shows purge date as 10 years ahead.

6. We should be able to see the business process even now as it has got 10 year lifespan due to message associated has 10 year lifespan. This BP will exist in the system until the message gets deleted. So we are still seeing the message in the mailbox.

7. Even if the Message extracted and extract count is zero still we should be able to see the message via UI.

8. When schedule purge business process runs it still does NOT delete as the lifespan is 10 years ahead.

9. Then deleted the message using mailbox delete service. An entry added to BPMV_REIDX to reset the 10 year lifespan back to original lifespan.

10. Ran index business process that resets the lifespan back to original lifespan.

11. Ran backup/purge. The business process and document removed from the system.

Please note that deleting the mailbox message from a mailbox using mailbox delete service will not delete the document from the system, but it simply deletes the link to the document on the mailbox. The deletion of the document associated with the message and business process will actually taken care by the regular system clean up processes (index/archive/purge).

Also refer the related blog post here - https://www-304.ibm.com/connections/blogs/SterlingB2B/entry/why_is_there_a_need_to_schedule_the_mailboxdeleteservice_business_process_in_ibm_sterling_b2b_integrator?lang=en_us