Automic Workload Automation

  • 1.  U00003434 Server routine 'UCGENX_R/PSCRIPT'

    Posted Feb 03, 2017 07:23 AM
    Hi there,

    does any one know what this server routine does?
    The reason I ask is that I do see many "U00003434 Server routine 'UCGENX_R/PSCRIPT' required 'n' minutes and 'n' seconds for processing" in my AE server logs.

    Is there a place where I can find documentation on all 'Server routines' ?



  • 2.  U00003434 Server routine 'UCGENX_R/PSCRIPT'

    Posted Feb 03, 2017 07:30 AM
    Hi,

    afaik it is executed if an event is triggered (aka !Process). I could not find it in the documentation.

    Chris


  • 3.  U00003434 Server routine 'UCGENX_R/PSCRIPT'

    Posted Feb 03, 2017 07:44 AM
    So, if this Server routine generally requires between 1 and 2 minutes for processing, where or how should I investigate what causes such poor performance?

    Examples:
    20170202/093154.174  -  U00003434 'UCGENX_R/PSCRIPT' required '1' minutes and '50,594' seconds for processing.
    20170202/082302.108  -  U00003434 'UCGENX_R/PSCRIPT' required '1' minutes and '53,250' seconds for processing.


  • 4.  U00003434 Server routine 'UCGENX_R/PSCRIPT'

    Posted Feb 03, 2017 10:44 AM
    You can check ...
    • what kind of processing is done within your !Process scripts. Maybe a long running activate_uc_object without wait.
    • the reports of your Events and its child-tasks (child task statistics) for any hints.
    • the Automation Engine logs for any long running SQL statements.


  • 5.  U00003434 Server routine 'UCGENX_R/PSCRIPT'

    Posted Feb 06, 2017 03:32 AM
    Hi Christian,
    since we have thousands of jobs/scripts running all the time, it can be difficult to determine what kind of processing is causing the issue.



  • 6.  U00003434 Server routine 'UCGENX_R/PSCRIPT'

    Posted Feb 06, 2017 07:56 AM
    You can use the statistic search and filter for objects of type !EVNT.
    You can also query these Jobs in SQL:

    with triggered_events as (
        select (evnt.ah_timestamp4 - evnt.ah_timestamp1)
                * 24 * 60 * 60 runtime_in_seconds
            , parent.ah_name
            , parent.ah_alias
            , parent.ah_client
        from ah evnt left join ah
              parent on evnt.ah_parentprc = parent.ah_idnr
        where evnt.ah_otype='!EVNT'
    )
    select *
    from triggered_events
    where runtime_in_seconds > 60;