Troubleshooting
Problem
In IBM Sterling B2B Integrator (SBI), some workflows get purged without any issues but many of them are stuck with a 10 year life span and not purged until 10 years.
Symptom
1. There is mailbox delete service Business Process(BP) scheduled to delete messages older than 2 days from the mailbox in SBI.
2. Below sql query shows that there are messages older than two days in some particular mailboxes.
SELECT PATH , COUNT(DOC_ID) FROM MBX_MESSAGE LEFT OUTER JOIN MBX_MAILBOX on MBX_MESSAGE.MAILBOX_ID = MBX_MAILBOX.MAILBOX_ID WHERE DOC_ID IN (SELECT DOC_ID FROM DOCUMENT WHERE CREATE_TIME < GETDATE() - 2) GROUP BY PATH
[{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Data management - Purge","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.4.1","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
08 November 2019
UID
swg21697602