Automic Workload Automation

  • Private Community

  • 1.  Database table that include status text for each return code

    Posted Jan 19, 2017 12:09 PM

    Database table that include status text for each return code
    example:
    1800 is ENDED_NOT_OK

    v10: uc_msg
    v11 and up: uc_msgtx



  • 2.  Database table that include status text for each return code

    Posted Jan 19, 2017 12:46 PM
    In my V11 system I did not find a UC_MSGTX table, but I did find a MSGTX table.  And keep in mind that the messages in this table are templates;

    e.g. SYS-ALIVE flag for Agent '&01' was set to '&02'.


  • 3.  Database table that include status text for each return code

    Posted Jan 19, 2017 04:04 PM
    petwir
     It's MSGTX for v11. 


  • 4.  Database table that include status text for each return code

    Posted Jan 25, 2017 09:45 AM

    SELECT * FROM MSGTX with(nolock)

    WHERE MSGTX_MSGL_Short = 'E'



  • 5.  Database table that include status text for each return code

    Posted Jan 26, 2017 07:47 AM

    There is a script function so retrieve the text for System Return Codes of Executable Objects:

    GET_MSG_TXT (Number, [Insert])

    https://docs.automic.com/documentation/webhelp/english/AWA/11.2/AE/11.2/All%20Guides/help.htm#ucaafb.htm%3FTocPath%3DAutomation%2520Engine%2520Script%2520Guide%7COrdered%2520by%2520Function%7CError%2520Handling%2520and%2520Messages%7C_____7

     

    So there is no need to do it via SQL. The SQL may needs to be adapted in newer version. The Script function will be (hopefully) compatible.




  • 6.  Re: Database table that include status text for each return code

    Posted Apr 25, 2019 05:15 AM

    Hi all

     

    as prophet Joseph predicted the MSGTX field in V12.2. got empty.

     

    I searched in UC_MSG* tables and every table with MSL in description but no luck...

     

    Does anyone have a hint for the new location of the list?

     

    THX a lot


    Wolfgang



  • 7.  Re: Database table that include status text for each return code

    Posted Apr 26, 2019 02:39 AM

    Dear Wolfgang,

    I heard that they put the messages in a flat file, so they are no longer available in the database.

    I had a quick look on the engine installation and I think it's the file uc.msl in the AE-folder server/bin, but I am not sure.

    Not the best innovation...

    Take care,

    Nicole



  • 8.  Re: Database table that include status text for each return code

    Posted Apr 26, 2019 03:26 PM

    Ahoi Nicole,

     

    indeed its in UC.MSL :-)

    THX a lot for your hint!

     

    I checked it, its since Operations manager V8 in this file... so thats a good plan B (or Z) using this file!

     

    Anyway I am still courious why and where it was (re-)moved...

     

    cheers, Wolfgang