IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

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.


#TechXchangePresenter
 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 07:50 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

    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


    #webMethods
    #Integration-Server-and-ESB


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

    Posted Thu February 28, 2013 10:34 AM

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


    #webMethods
    #Integration-Server-and-ESB


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

    Posted Wed April 24, 2013 05:59 AM

    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


    #Integration-Server-and-ESB
    #webMethods


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

    Posted Wed April 24, 2013 12:37 PM

    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


    #Integration-Server-and-ESB
    #webMethods