Description: An incorrect SQL Archiving script is documented in the BusinessConnect Interior Server Administration Manual Appendix A "Database Schema Definition" Section "Audit Schema Details" subsection "BC_MESSAGES" table. Symptoms: SQL script does not archive database correctly. Cause: Incorrect script documentation.
Resolution
The incorrect script documented is:
Select * from BC_MESSAGES where STATUS IN (
(
select STATUS from BC_TRANSACTIONS where BC_TRANS_ID = BC_MESSAGES.BC_TRANS_ID AND
ts <= TO_TIMESTAMP(<from date>, 'YYYY-MM-DD HH24:MI:SS.FF') AND