Automic Workload Automation

  • 1.  how to fix: Non numeric input 'AH_IDNR' not allowed.

    Posted Oct 04, 2018 02:00 PM

    FAULT_POST_PROCESSING - error in post processing.
    U00020440 Runtime error in object 'JOBS.SQL.ENDTIMES_FOR_CMT_TEST(2)', line '00016': Non numeric input 'AH_IDNR' not allowed.

     

    :SET &HND# = PREP_PROCESS_AGENTGROUP("HOSTG.AE",,ALL)
    :PROCESS &HND#
    : SET &AGENT# = GET_PROCESS_LINE(&HND#,1)
    :ENDPROCESS
    :CLOSE_PROCESS &HND#

     

    :SET &REP_HND# = CREATE_PROCESS(NEW)
    !:SET &RET# = PUT_PROCESS_LINE(&REP_HND#,"ALIAS NAME;STATUS_TEXT;END_TIME;STATUS")
    :SET &RET# = PUT_PROCESS_LINE(&REP_HND#,"END_TIME;ALIAS NAME;PARENT NAME;STATUS")

    :SET &HND# = PREP_PROCESS_REPORT(,&$RESTART_RUNID#, "REP","??*","COL=DELIMITER,DELIMITER=*;*")
    :PROCESS &HND#


    : SET &AH_RUNID# = GET_PROCESS_LINE(&HND#,1)
    !: SET &ACT_TIME# = GET_STATISTIC_DETAIL(&AH_RUNID#,ACTIVATION_TIME)
    !: SET &START_TIME# = GET_STATISTIC_DETAIL(&AH_RUNID#,START_TIME)
    : SET &END_TIME# = GET_STATISTIC_DETAIL(&AH_RUNID#,END_TIME)
    : SET &ALIAS# = GET_STATISTIC_DETAIL(&AH_RUNID#,ALIAS)
    : SET &PARENT_ACT# = GET_STATISTIC_DETAIL(&AH_RUNID#,PARENT_ACT)
    : SET &PARENT_NAME# = GET_STATISTIC_DETAIL(&PARENT_ACT#,NAME)
    : SET &STATUS# = GET_STATISTIC_DETAIL(&AH_RUNID#,STATUS)
    : SET &STATUS# = FORMAT(&STATUS#)
    : SET &STATUS_TEXT# = GET_MSG_TXT(&STATUS#)
    !: SET &RET# = PUT_PROCESS_LINE(&REP_HND#,"&ALIAS#;&STATUS_TEXT#;&END_TIME#;&STATUS#")
    : SET &RET# = PUT_PROCESS_LINE(&REP_HND#,"&END_TIME#;&ALIAS#;&PARENT_NAME#;&STATUS#")
    :ENDPROCESS
    :CLOSE_PROCESS &HND#

     

    :SET &RET# = WRITE_PROCESS(&REP_HND#,&REPORT#,&AGENT#,LOGIN.AUTOMICV12,OVERWRITE)
    :CLOSE_PROCESS &REP_HND#



  • 2.  Re: how to fix: Non numeric input 'AH_IDNR' not allowed.

    Posted Oct 04, 2018 02:17 PM

    Hi RogerShirley603913,

     

    I saw that this was posted under that Automic Community space with the category of "Applications Manager" for it but looking at your content, it appear to be of the Automation Engine and have moved the post to the CA Automic Workload Automation to better reach the product user audience.



  • 3.  Re: how to fix: Non numeric input 'AH_IDNR' not allowed.

    Posted Oct 04, 2018 02:50 PM

    What does it return if you put in a print after this line:

     

    : SET &AH_RUNID# = GET_PROCESS_LINE(&HND#,1)

     

    I would see if that is returning a valid runid

     



  • 4.  Re: how to fix: Non numeric input 'AH_IDNR' not allowed.

    Posted Oct 05, 2018 10:40 AM

    Hi

     

    Assumption: the error message is caused by this line - as michael already stated.

    : SET &AH_RUNID# = GET_PROCESS_LINE(&HND#,1)

     

    If it returns a valid runid and the errormessage still appears you can try

     

    * avoiding blanks using

    STR_RTRIM(String)

    STR_LTRIM(String)

     

    and check it with:

    ISNUMERIC(String)

     

    * and  converting it with

    :set &AH_RUNID# = CONVERT(unsigned,&AH_RUNID#)

     

    cheers, Wolfgang



  • 5.  Re: how to fix: Non numeric input 'AH_IDNR' not allowed.

    Posted Nov 06, 2018 04:34 PM

    Hi RogerShirley603913 

    Were you able to find out the cause of the issue with the suggestion provided by Michael & Wolfgang?