IBM QRadar

IBM QRadar

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

 View Only
  • 1.  Appplication stuck in "upgrading" after failed upgrade

    Posted Tue December 13, 2022 06:43 AM
    Edited by tysa Wed December 14, 2022 04:06 AM
    Hello, I have one application stuck in "upgrading" for weeks after failed upgrade. I cant now migrate the applications to App Host because systems thinks there is upgrade ongoing. I tried to stop the application via API, but its not possible. Any tips how do I solve this? Thank you!

    1001 | QRadar Assistant | UPGRADING | UPGRADING | 53 | sbbkcns1

    DELETE and STOPPED doesn't work:
    {
      "http_response": {
        "code": 409,
        "message": "The request could not be completed due to a conflict with the current state of the resource"
      },
      "code": 33006,
      "description": "The current state of the application instance does not allow the requested action.",
      "details": {},
      "message": "Application instance is not in the required state, status is UPGRADING"
    }


    ------------------------------
    Tomas Tyser
    ------------------------------


  • 2.  RE: Appplication stuck in "upgrading" after failed upgrade

    Posted Tue December 13, 2022 06:55 AM
    Hi Tomas,

    It sounds like the status in the database is stuck and probably needs to be updated with an AQL query.

    However, if this is a production system (not sure nor the versions you are using), I suggest raising a support ticket to get an IBM support person to resolve, as it is probably in an inconsistent state.

    This is in case there are other parts of the upgrade that have failed (which can happen).

    ------------------------------
    Darren H.
    ------------------------------



  • 3.  RE: Appplication stuck in "upgrading" after failed upgrade

    Posted Thu December 15, 2022 08:11 AM
    Edited by Wendy Batten Thu December 15, 2022 08:10 AM
    Hello Darren, thank you for your reply. This is test environment we are using to test changes before going to production with them. Its running xxx right now. I am able to raise a support ticket, but was wondering if there isn't something I could try myself first. Other then this issue, the rest of the system seems to be fine. But one never know :)

    ------------------------------
    Tomas Tyser
    ------------------------------



  • 4.  RE: Appplication stuck in "upgrading" after failed upgrade

    Posted Tue December 13, 2022 09:16 AM

    @Tomas Tyser We have a support technical note on the error, "Application instance is not in the required state, status is UPGRADING" you can read here that tells you how to set the status and correct the issue. QRadar: Changing the status of an application fails with error "Application instance is not in the required state"

    If you are not comfortable with PSQL or the procedures outlined in this article, you can open a support case for assistance on the issue.



    ------------------------------
    Jonathan Pechta
    QRadar Support Content Lead
    Support forums: ibm.biz/qradarforums
    jonathan.pechta1@ibm.com
    ------------------------------



  • 5.  RE: Appplication stuck in "upgrading" after failed upgrade

    Posted Tue December 13, 2022 09:33 AM
    Hello Jonathan, this is great stuff, thank you very much. My colleague already opened the support case, but I will definitely store this for later and hope to use it some day ;)

    ------------------------------
    Tomas Tyser
    ------------------------------



  • 6.  RE: Appplication stuck in "upgrading" after failed upgrade

    Posted Wed December 14, 2022 04:16 AM
    I was curious so did try it myself. All was ok, but after using 23 to start the app, it gave me error:
    1001 | 1001 | QRadar Assistant | ERROR | ERROR | 2019-04-29 15:04 | sbbkcns1 | LOCAL | 0 | | An error occurred while registering app instance with id 1001 with QRadar.

    I went to Extensions Management and uninstalled the Qradar Assistant, did check via qappmanager and the Qradar Assistant was gone from the list. That was enough for me to be able to migrate the applications from the console to App Host. Mission accomplished :)

    ------------------------------
    Tomas Tyser
    ------------------------------