AppWorx, Dollar Universe and Sysload Community

Expand all | Collapse all

Trying to find $U Node status in SQL database

  • 1.  Trying to find $U Node status in SQL database

    Posted 09-10-2020 10:54 AM
    We have upgraded our $U 6.10.21 install to use an external SQL server database. The connected Node status is displayed in the UVC. I'm trying to create a job in SQL that will alert me when the connected node status is NOT "Connected". The problem I'm having is finding the table/column where that status is stored in the database. I'm positive it has to be in there somewhere. Does anyone know where I need to look?


  • 2.  RE: Trying to find $U Node status in SQL database

    Posted 12-02-2020 06:20 PM
    Hi,

    Sorry for the late.
    Is it still happening ?

    Regards

    ------------------------------
    Main director
    SynApps
    ------------------------------



  • 3.  RE: Trying to find $U Node status in SQL database

    Posted 12-02-2020 09:31 PM
    It's not so much a matter of it "still" happening. The issue is that I do not know where to look in the SQL DB to find the information I need.



    Charlie Barr

    Sr. Application Technical Specialist

    Heartland


    +1 469.294.7626 O
    +1 214.842.0397 M
    charlie.barr@heartland.us


    Global Payments Company

    Upcoming OOO - 12/7/2020 - 12/17/2020
                                 12/28/2020 - 12/31/2020







  • 4.  RE: Trying to find $U Node status in SQL database

    Posted 12-03-2020 10:45 AM
    Ok Just understand the Point.
    The SQL DB is the Univiewer Management Server externat DB Right ? not a $U SQLServer Manager

    But the $U 6.10.21 is what ? UVMS? Console? or DUAS?

    To check the connection beetween DUAS and UVMS , you can try the unims

    To be sure about registering "things" into the UVMS DB, you can unregister then register back the DUAS node (commande unims -unregister or remove the node into the console) (unims -register to add it)

    Beware of the previous version, Perhaps a need to update the UVMS DB structure

    All the Best
    Eric

    ------------------------------
    Main director
    SynApps
    ------------------------------



  • 5.  RE: Trying to find $U Node status in SQL database

    Posted 12-03-2020 11:05 AM
    We are running Dollar Universe 6.10.21
    UVMS - 6.10.21 - 4 node Windows 2016 Cluster with a 4 node Windows 2016 / MSSQL 2017 AWO cluster (NO DERBY DB ON UVMS)
    UVC - 6.10.21 connected to the UVMS Active Cluster member - The UVC shows the connection status of our 73 DUAS agents
    73 DUAS agents (mostly 6.10.21 with the exception of 3 agents running 6.3.21)

    So, the UVC has to be getting the connection status of the DUAS from somewhere. I assumed it comes from the SQL DB used by the UVMS. What I'm trying to do is find a way to report when a DUAS has disconnected from the UVMS. The easiest way I can see to do this is to run a SQL Agent job to query DUAS connection status. But...I do not know where to look for the DUAS connection status in the database.



    Charlie Barr

    Sr. Application Technical Specialist

    Heartland


    +1 469.294.7626 O
    +1 214.842.0397 M
    charlie.barr@heartland.us


    Global Payments Company

    Upcoming OOO - 12/7/2020 - 12/17/2020
                                 12/28/2020 - 12/31/2020







  • 6.  RE: Trying to find $U Node status in SQL database

    Posted 12-03-2020 04:38 PM
    Ok Great,

    So some points:
    * If you are cluster DUAS, don't forget to upgrade both DUAS parts
    * If you have SQLServer, you can check on Console/administration/UVMS left panel the Request of the Host table
    * Note that the status is quite différent. The heartbeat is sent by the DUAS on v6 (push). Not sure that the UVMS do as for the v5 DUAS (pull)
    * When you right click/Engines... what is the automates list result ?

    UVMS on 4 clutered nodes: so 4 UVMS (actif/passif) on 1 SQLS alias ?

    Also, what was the previous version of your UVMS (before upgrading 6.10.21) ?
    Because arround 6.2, UVMS Cluster mode become innoperate and you need to switch all the UVMS to a switch multipart UVMS
    (so unidtl FROMCLUSTER command etc... let you check this into the admin documentation)







    ------------------------------
    Main director
    SynApps
    ------------------------------



  • 7.  RE: Trying to find $U Node status in SQL database

    Posted 12-03-2020 04:52 PM
    Edited by Eric Delawoevre 12-03-2020 04:54 PM
    BUt if you really want to monitor you nodes.
    Well UVMS not fit to do this

    BUT but but.... here a pleasant way to do this:
    Launch the unilst NODE to have your list of your DUAS 6
    <uvmsbindir>/unilst NODE -type DU6 -csv

    Then, if you have an UVMS, it also be important/elegant to have a Management DUAS close to UVMS (use for reporterClient, package cleanup mngt, Maintenance session for the UVMS, etc ...)
    Then you can launch the ./uxlst fnc node=<OneNode>

    This can be easily implemented into your storeProc
    (don't forget to add the user that execute the command into the userpattern)

    That's it ?
    Eric

    ------------------------------
    Main director
    SynApps
    ------------------------------



  • 8.  RE: Trying to find $U Node status in SQL database

    Posted 12-03-2020 04:59 PM
    OK, so do you know where the UVC gets its data for DUAS connection to UVMS? Also, these UVMS and the UVC were purpose built on 6.10.21. There was no upgrade. Only DUAS was upgraded from 6.3.21.



    Charlie Barr

    Sr. Application Technical Specialist

    Heartland


    +1 469.294.7626 O
    +1 214.842.0397 M
    charlie.barr@heartland.us


    Global Payments Company

    Upcoming OOO - 12/7/2020 - 12/17/2020
                                 12/28/2020 - 12/31/2020







  • 9.  RE: Trying to find $U Node status in SQL database

    Posted 12-03-2020 05:38 PM
    Edited by Eric Delawoevre 12-03-2020 05:45 PM
    The DUAS sends the information (v6)
    The UVMS polls the information (v5)
    polling config is into UVMS nodsettings

    UVMS store it into its memory (daemon)
    UVC is just a an interface (but UVC can also be a requester)
    There is no location you can find thet node status

    You can also use the API to interrogate the DUAS via the UVMS

    The SQLDB is somewhat only the verbatim keys that DUAS <--> UVMS contracts during installation/registration

    ------------------------------
    Main director
    SynApps
    ------------------------------



  • 10.  RE: Trying to find $U Node status in SQL database

    Posted 12-03-2020 09:59 PM
    OK, cool. Thank you for your time and help with this. Happy Holidays.



    Charlie Barr

    Sr. Application Technical Specialist

    Heartland


    +1 469.294.7626 O
    +1 214.842.0397 M
    charlie.barr@heartland.us


    Global Payments Company

    Upcoming OOO - 12/7/2020 - 12/17/2020
                                 12/28/2020 - 12/31/2020