Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only

  • 1.  SQL server dbconnectionwatchdog issue

    Posted Mon December 20, 2021 10:48 AM
    Hi All, 

    We are getting BMXAA7084I and 7088I messages in logs .

    While trying to start the maximo ui server.

    We have clustered environment.

    The database connection has been opened for 596993140 Ms DbConnectionWatchDog : Db connection reference I'd =17 spid =71.

    We tried stoping the db server restarted the db machine but no luck.

    Tried websphere restart not working.
    Error in calling Script Cache for zombie init event for mbo null. It's coming as warning

    Does anyone has faced the same issue?
     

    Please advise.

    #AssetandFacilitiesManagement
    #Maximo


  • 2.  RE: SQL server dbconnectionwatchdog issue

    Posted Wed December 29, 2021 07:41 PM
    It sounds like there are other issues that are preventing the JVM starting.

    You should check the SystemOut.log file.
    The startup messages will go through a standard set of messages.
    There are almost certainly some other messages in the SystemOut.log file that indicate what is going wrong.

    https://www.linkedin.com/pulse/which-log-file-check-when-jvm-starts-up-key-mentioned-mark-robbins/

    The log entries you mentioned are the DB Connection Watchdog reporting that a piece of code has requested a DB connection and not returned it quickly enough.
    I talk about these messages here:
    https://www.linkedin.com/pulse/monitoring-number-db-connections-maximo-uses-mark-robbins/

    If this is still a problem then reach out to me privately and I may be able to look at the log files.
    My email address is in my profile details

    ------------------------------
    Mark Robbins
    Support Lead/Technical Design Authority / IBM Champion 2017 & 2018 & 2019 & 2020 & 2021
    Vetasi Limited
    https://www.linkedin.com/pulse/maximo-support-advice-from-non-ibm-engineer-article-mark-robbins/
    ------------------------------

    Original Message


  • 3.  RE: SQL server dbconnectionwatchdog issue

    Posted Thu January 27, 2022 09:25 AM
    Hi

    Did you every find the cause of this issue
    We have have all of a sudden got this issue after installing ifix15 on Maximo 7.6.1.2

    ------------------------------
    Stephen Christie
    ------------------------------

    Original Message


  • 4.  RE: SQL server dbconnectionwatchdog issue

    Posted Thu January 27, 2022 09:41 AM
    In that case the JVM had "gone rogue" and would not respond to the shutdown commands / windows end task.
    Microsoft Process Explorer was installed on the server and the prcoess was ended using that.

    The JVM restarted after the kill and the investigation stopped once the service was restored.

    If you have taken the steps I recommend above and you still have a problem then feel free to reach out to me and I may be able to do some analysis on your logs.
    My email address is in my profile details or go to my linkedin profile (from the articles) and connect with me.

    ------------------------------
    Mark Robbins
    Support Lead/Technical Design Authority / IBM Champion 2017 & 2018 & 2019 & 2020 & 2021
    Vetasi Limited
    https://www.linkedin.com/pulse/maximo-support-advice-from-non-ibm-engineer-article-mark-robbins/
    ------------------------------

    Original Message