The standard archive procedure documented in Appendix A of the BusinessConnect Interior Server Administration Guide will not archive records associated with the CMI protocol. This can cause large buildup of data in the BC audit tables even when archiving regularly.
In the documentation, the standard query for archiving includes this qualifier: STATUS IN ('COMPLETED','ERROR')
This qualifier will not catch records in the associated tables associated with the CMI protocol, because the CMI protocol uses REQ_COMPLETED as the completion stage rather than COMPLETED
Issue/Introduction
Special Considerations archiving records using the ConfigStore Management Interface (CMI). The standard archive procedure documented in Appendix A of the BusinessConnect interior Server Administration guide will not archive CMI correctly
Environment
all platforms
Resolution
To resolve this issue, make sure the relevant queries use this qualifier instead: STATUS IN ('COMPLETED','REQ_COMPLETED','ERROR'). Tjhoi