Print status description with the help of status code

Discussion created by Srikanth_Veeraraghavan_9912 on Jan 17, 2018
Latest reply on Jan 26, 2018 by Wolfgang_Brueckler_1288

Like • Show 0 Likes0
Comment • 8

Hi There,
We do have system return codes for all the objects executed in a workflow ( ranging between 1000 - 3000 ). Now that I am using "GET_UC_OBJECT_STATUS" to get the System return code. Is there anyway we can print the description of the return codes and display to the user so that they can easily interpret?

Outcomes

8 Replies

Wolfgang_Brueckler_1288 Jan 17, 2018 11:17 AM
Good Morning,

the fastest way would be sharing this link:
https://docs.automic.com/documentation/webhelp/english/ALL/components/AE/11.2/All%20Guides/help.htm#ucaaiy.htm

:-)

cheers, Wolfgang
Like • Show 1 Like1
Actions
Srikanth_Veeraraghavan_9912 Jan 17, 2018 10:27 AM
I guessed someone would come with that reply :wink:
Like • Show 0 Likes0
Actions
Wolfgang_Brueckler_1288 Jan 17, 2018 11:18 AM
within DB (12.1) i only found some breadcrumbs but no complete list in tables:

UC_SGRP
UC_ZUTYP

possibly that helps..

cheers, Wolfgang
Like • Show 0 Likes0
Actions
Pete Wirfs Jan 17, 2018 5:32 PM
I've used the GET_MSG_TXT() function;

https://docs.automic.com/documentation/webhelp/english/ALL/components/AE/11.2/All%20Guides/help.htm#ucaafb.htm

1 person found this helpful
Like • Show 1 Like1
Actions
Wolfgang_Brueckler_1288 Jan 17, 2018 6:15 PM
This works?

Yeah indeed.
Great Idea, Pete THX!!

cheers, Wolfgang
Like • Show 0 Likes0
Actions
Wolfgang_Brueckler_1288 Jan 17, 2018 7:03 PM
...and here is the script to create a VARA containing a full List ;-)

! Set parameter section START :SET &CREATE_LIST_IN_VARA# = "Y" :SET &VARAPATH# = "/JOBS/SCRIPTING/STATUS_CODES" :SET &VARANAME# = "VARA.ALL_STATUS_CODES" ! Parameter Section END ! :SET &MAX_COUNT# = 1999 :SET &MIN_COUNT# = 1300 :SET &COUNTER# = &MIN_COUNT# :SET &COUNTER# = FORMAT(&COUNTER#, "0000") ! :IF &CREATE_LIST_IN_VARA# = "Y" : SET &OHIDNR# = GET_OH_IDNR(&VARANAME#) : IF &OHIDNR# <> 0 : DELETE_VAR &VARANAME# : PRINT "Content of VARA &VARANAME# deleted" : ELSE : SET &RET# = CREATE_OBJECT("VARA", &VARANAME#, &VARAPATH#, "&VARANAME# created by &$NAME# &$RESTART_RUNID#") : IF &RET# = 0 : PRINT "VARA &VARANAME# in &VARAPATH# successfully created." : ELSE : PRINT "RC create VARA: &RET#" : ENDIF : ENDIF :ENDIF :PRINT "===============================================================" ! ! :WHILE &COUNTER# <= &MAX_COUNT# : SET &MSG_TEXT# = GET_MSG_TXT(&COUNTER#) ! check if a Status Code - Text is defined : SET &CHECK_STRING# = STR_STARTS_WITH(&MSG_TEXT#, "U0000") : IF &CHECK_STRING# EQ "N" : IF &CREATE_LIST_IN_VARA# = "Y" : PUT_VAR &VARANAME#, &COUNTER#, &MSG_TEXT# : ENDIF : PRINT "Status NR: &COUNTER# -- Text: &MSG_TEXT#" : ENDIF : SET &COUNTER# = ADD(&COUNTER#, 1) : SET &COUNTER# = FORMAT(&COUNTER#, "0000") :ENDWHILE

cheers, Wolfgang
Like • Show 0 Likes0
Actions
Srikanth_Veeraraghavan_9912 Jan 18, 2018 9:17 AM
@Pete Wirfs Thank you. It worked !
Like • Show 1 Like1
Actions
Wolfgang_Brueckler_1288 Jan 26, 2018 9:13 PM
Fot the sake of completeness - I found an SQL on the ground of my toolbox to list all stati:

select MSGTX_MSG_IDNR, MSGTX_TEXT from MSGTX where MSGTX_MSGL_short = 'E' and MSGTX_MSG_IDNR >1300 and MSGTX_MSG_IDNR <2000
if you want them in german, guess what..
Yes- change E against D :-)

cheers, Wolfgang
Like • Show 1 Like1
Actions

Incoming Links

Oracle SQL statement for daily total object execution statistics

Print status description with the help of status code

Outcomes

Related Content

Recommended Content

Incoming Links