How to clear JDBC connection queue with out server restart?

,
1

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

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
[4415601]

Thanks
Kesa

2

Just enable an disable the adapter connection with the issue. That should work.

3

Hi Sam,

I guess Kesavaraman is referrin g to the audit logging done by IS and not of a specific adapter. We have also faced this issue sometimes when the audit queue gets full and the IS starts writing this data to the FailedAuditlog file in IS/logs folder.

The only way we were able to resolve this was by restarting the IS. Is there any other way this can be achieved?

Thanks,
Saurabh

4

Yes only with restart IS will help to clear any stale connections (also make the Adapter fixes are up to date) and in order to connection reset.

HTH
RMG