CA Service Management

 View Only
Expand all | Collapse all

SDM CORA API STOPPED WORKING

  • 1.  SDM CORA API STOPPED WORKING

    Posted Jul 08, 2019 10:28 AM
    CORA API seems to stop working and we cannot create CI related data. In the logs we can see errors about CORA. The customer has a testenvironment that is similar to production with a copy of the database etc. In test we cannot see the problem. In production we can see plenty of launchit.exe in memory but not in test. Also Microsoft SQL Management Studio and Client Connectivity tools are version 17.9.1 in test but 17.9 in production. If I recyle SDM the CORA API will work again for some time. SDM is version 17.1.

    Error messages in logfiles:

    06/19 11:47:17.16 SRV3111 mdb_registration_ 7160 ERROR mdb_registration.c 935 Unable to initial CORA API. RC: 470200
    06/19 11:47:17.16 SRV3111 mdb_registration_ 7160 ERROR mdb_registration.c 937 CORA Error Message:Cora not initialized yet!
    06/19 11:47:17.16 SRV3111 bpvirtdb_srvr 8336 SIGNIFICANT vdbmisc.c 1887 Requested 50 keys but received 0 keys only

    19/06/24 19:48:49: [           3280] ERROR Cora.SqlSrvr                    - 48287352 SQLSRVR::logon Unknown Error [sqlclass.cpp:128]19/06/24 19:48:49: [           3280] ERROR Cora.SqlSrvr                    - 48287352 SQLSRVR::logon Unknown Error [sqlclass.cpp:128]19/06/24 19:48:49: [           3280] ERROR Cora.SqlSrvr                    - 48287352 Throwing CCoraException((LONG) CORA_ERROR_CCORAMSS_INIT, (PCHAR)_datasource.GetLastErrorMsg())sqlclass.cpp/130 [sqlclass.cpp:130]19/06/24 19:48:49: [           3280] ERROR Cora.SqlSrvr                    - 48287352 SQLSRVR::logon catching (...) [sqlclass.cpp:135]19/06/24 19:48:49: [           3280] ERROR Cora.SqlSrvr                    - 48287352 SQLSRVR::logon throwing 470224 [sqlclass.cpp:136]19/06/24 19:48:49: [           3280] ERROR Cora.SqlSrvr                    - 48287352 Throwing CCoraException((LONG) CORA_ERROR_CCORAMSS_INIT, (PCHAR)_datasource.GetLastErrorMsg())sqlclass.cpp/139 [sqlclass.cpp:139]19/06/24 19:48:49: [           3280] ERROR Cora.CCoraMss                   - 48286192 CCoraMss::DbConnect catching cre [coramss.cpp:511]19/06/24 19:48:49: [           3280] ERROR Cora.CCoraMss                   - 48286192 Throwing crecoramss.cpp/512 [coramss.cpp:512]19/06/24 19:48:49: [           3280] ERROR Cora.CCoraApi                   - 48143048 ca_reg_initW catching cre [coraapi.cpp:1675]


  • 2.  RE: SDM CORA API STOPPED WORKING

    Broadcom Employee
    Posted Jul 08, 2019 01:01 PM
    When you run the PDM_STATUS command when the issue occurs, do you see the mdb_registration_nxd process listed as started?

    In the NX.ENV file, is the @NX_DB_NODE variable defined as the actual DB server host name or an alias?

    ------------------------------
    Paul Coccimiglio
    Principal Support Engineer
    Broadcom Inc.
    ------------------------------



  • 3.  RE: SDM CORA API STOPPED WORKING

    Posted Jul 08, 2019 03:42 PM
    Hi Paul,

    The process is listed as running and NX_DB_NODE represent the actual hostname of the SQL-server.​


  • 4.  RE: SDM CORA API STOPPED WORKING

    Broadcom Employee
    Posted Jul 10, 2019 12:47 PM
    Andreas..........

    Ensure that you have the latest patch applied for the version of SDM installed.

    If that does not help, I would suggest opening a Support Case for further analysis.

    ------------------------------
    Paul Coccimiglio
    Principal Support Engineer
    Broadcom Inc.
    ------------------------------



  • 5.  RE: SDM CORA API STOPPED WORKING

    Posted Jul 10, 2019 01:40 PM
    I have opened a case and will apply the RU3 patch after the change freeze period.


  • 6.  RE: SDM CORA API STOPPED WORKING

    Broadcom Employee
    Posted Jul 11, 2019 09:03 AM
    You could also try to recycle the process and see it that helps by running the following commands in sequence:

    pdm_bounce mdb_registration_nxd
    pdm_refresh


    ------------------------------
    ===
    Kind Regards,
    Brian
    ------------------------------



  • 7.  RE: SDM CORA API STOPPED WORKING

    Posted Jul 12, 2019 08:24 AM
    Hi Paul,

    I can try that. Why do you think all the launchit.exe in memory are stuck? Do you know what SDM use them for?


  • 8.  RE: SDM CORA API STOPPED WORKING

    Posted Jul 12, 2019 08:24 AM
    Hi Brian,

    I can try that. What do you think about all the launchit.exe in memory? Why are they stuck and can these two problems be related?


  • 9.  RE: SDM CORA API STOPPED WORKING
    Best Answer

    Broadcom Employee
    Posted Jul 12, 2019 08:57 AM
    Hi Andreas,

    Launchit.exe has nothing to do with the CORA APi issue. It appears you have some Event(s) or Notification Method(s) that calls launchit.exe to execute or run external applications\programs on  regular bases. You would need to check if any Event or Notification Method defined is configured to call launchit.exe.

    ------------------------------
    ===
    Kind Regards,
    Brian
    ------------------------------



  • 10.  RE: SDM CORA API STOPPED WORKING

    Posted Jul 12, 2019 11:56 AM

    Hi Brian,

    Thank you for the clarification. I will check that. I ran the pdm_bounce command but I had to recyle the whole SDM for CORA to work again temporary.