Skip to content

Operational Maintenance

After setting up the Export as SQL feature in one or more document definitions, the BS2SQL will start initializing. Following initialization, all current documents are pushed to the data warehouse. Then the initial setup is done and BS2SQL will continue watching the queue for documents to process.

If an error occurs during document processing, such as a database connection failure, the document status will be set to failed, and the environment will be marked as suspended. While all document changes are still added to the queue, processing will be paused.

On the BS2SQL setup page, the queue status is displayed. If the status is suspended a suspendedReason will also be displayed. An administrator should examine the error and decide what to do (e.g. it could be that there is an issue with the document). Queue processing can be restarted by clicking the Resume button.