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

ESB 8.0 JDBC pools - Data not logging to SQL server DBtables

  • 1.  ESB 8.0 JDBC pools - Data not logging to SQL server DBtables

    Posted Wed August 04, 2010 04:13 PM

    Hello wM Techies,

    Problem : Logging is not happening at RDBMS (SQL Server 2005)

    Error: wm.prt.admin:startup wm.prt.admin:startup
    [101.518] Exception: Unable to connect to database!

    1. Installed wM ESB 8.0 IS and configured JDBC pools (Document History, ISCoreAudit, ISInternal, ProcessAudit and Xref).
    2. Tested all pool alias succesfully.

    But when ever the IS was restarted i am noticing above error. And session, error and TXIN logs were writing to files. WMSERVICE, WMSESSION and WMERROR doesn’t have any entries into the tables.

    Surprisingly there were no errors noticed other than the above. No error/exception at pool alias (TEST succesfull).

    Can any one through a light on this issue and suggest if any parameters should set at extended settings.


    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: ESB 8.0 JDBC pools - Data not logging to SQL server DBtables

    Posted Wed August 04, 2010 04:55 PM

    Please check all the logging settings for IS 8.x:

    The solution to this problem is to activate the service logger to use the Database
    Integration Server > Administration > Settings > Logging > Service Logger > Edit … > Destination Database

    HTH,
    RMG


    #webMethods
    #Integration-Server-and-ESB


  • 3.  RE: ESB 8.0 JDBC pools - Data not logging to SQL server DBtables

    Posted Wed August 04, 2010 05:13 PM

    Hi All, Problem was solved wM 8.0 introduced Audit logging settings.

    ISAdmin>Settings>logging>LoggerList

    Edit logging to Database or File.

    Thankyou.


    #webMethods
    #Integration-Server-and-ESB


  • 4.  RE: ESB 8.0 JDBC pools - Data not logging to SQL server DBtables

    Posted Wed August 04, 2010 05:30 PM