IBM Support

External Purge causing Deadlocks on database and throwing "Queue Full" errors Deleting Docs from disk

Troubleshooting


Problem

Customer is using the External Purge and has the Document Storage set to file system. The external purge is deleting data from the database faster than it can delete the documents from the file system. This is causing a number of errors in the logs and also some deadlocks on the Oracle database.

Symptom

[2016-10-24 16:41:55.393] ERROR [ConsumerTask] PURGE ERROR While
generating Document On Disk List
[2016-10-24 16:41:55.393] ERROR [1477327315393] Queue full
[2016-10-24 16:41:55.393] ERRORDTL [1477327315393]java.lang.
IllegalStateException: Queue full
[2016-10-24 16:41:55.393] ERROR 000000000000 GLOBAL_SCOPE
[ConsumerTask] PURGE ERROR While generating Document On Disk List
[2016-10-24 16:41:55.393] ERROR The following error occurred:
[2016-10-24 16:41:55.393] ERROR Attempting to recover

[{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Data management - Purge","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"5.2.3;5.2.4;5.2.5","Edition":"All Editions","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.

Document Information

Modified date:
04 March 2019

UID

swg21996596

Page Feedback