How to clear JDBC connection queue with out server restart?

Hi,

Due to database connectivity issue Integration server stored entries on Queue.
After the connection resume the IS doesn’t log the queue data into DB.
Also I couldn’t clear the queue.

Could anybody tell how to clear the queue with out restarting the server?

Error Details

[TABLE=“class: tableView”]
[TR]
[TD=“class: evenrow-l”]com.wm.app.audit.AuditException: [BAA.0000.0057] Auditing failed. The audit record was written to the failed audit log. com.webmethods.sc.auditing.api.queue.WmAuditQueueException: Failed to insert WmAuditLogEvent onto queue ‘Error Queue’; reason: com.webmethods.lwq.LwqException: Failed to insert additional 1 message(s). Reaching maximum queue size of 10000. Current queue size is 10000 [/TD]
[/TR]
[TR]
[TD=“class: oddrow-l”][4415601]

Thanks
Kesa[/TD]
[/TR]
[/TABLE]

Also are there any thread/service hungs?..Are there any issues with the audit/db and size limits?

There is no way you can clear queues with out a server restart…

HTH,
RMG

Hi,

Even after restart, the error still happens:
[TABLE=“class: tableView, width: 0”]
[TR]
[TD=“class: evenrow-l, bgcolor: #F0F0E0, align: left”]] In logger ‘Service Logger’, failed to insert in queue; reason: Failed to insert WmAuditLogEvent onto queue ‘Service Queue’; reason: com.webmethods.lwq.LwqException: Failed to insert additional 1 message(s). Reaching maximum queue size of 100000. Current queue size is 100000[/TD]
[/TR]
[TR]
[TD=“class: oddrow-l, bgcolor: #E0E0C0, align: left”][186516]2012-10-09 07:01:41 CEST [WmAuditingSC.queue.2030E] Failed to insert WmAuditLogEvent onto queue ‘Service Queue’; reason: com.webmethods.lwq.LwqException: Failed to insert additional 1 message(s). Reaching maximum queue size of 100000
Thanks[/TD]
[/TR]
[/TABLE]

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.