webMethods

webMethods

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

How to clear JDBC connection queue with out server restart?

  • 1.  How to clear JDBC connection queue with out server restart?

    Posted Thu July 19, 2012 11:25 AM

    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]


    #webMethods-Archive
    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: How to clear JDBC connection queue with out server restart?

    Posted Thu July 19, 2012 02:56 PM

    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


    #Integration-Server-and-ESB
    #webMethods
    #webMethods-Archive


  • 3.  RE: How to clear JDBC connection queue with out server restart?

    Posted Tue October 09, 2012 09:06 AM

    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]


    #Integration-Server-and-ESB
    #webMethods
    #webMethods-Archive