Automic Workload Automation

 View Only
  • 1.  UC4 FAILED JOBS

    Posted Jul 02, 2020 04:40 AM
    Hi Team - I've executed below query to pull the list of UC4 failed jobs for SYSDATE-1. 

    But One of the workflow "WORKFLOW.INFA.HUB_MART.FINANCE_PA_INCREMENTAL_NOTIFY" is failed. But its not tracked in our failed query result. 

    Pls below the below query & result set.

    select

    DECODE(ah_QUEUE,

                  'QUEUE.BODI','BODI',

                  'QUEUE.TIBCO','TIBCO',

                  'QUEUE.INFA.EDM.HUB','INFA.EDM.HUB',

                  'QUEUE.ADF','ADF',

                      'QUEUE.INFORMATICA','INFORMATICA',

                      'QUEUE.INFA.EDM.MART','INFA.EDM.MART',

              'CLIENT_QUEUE','CLIENT_QUEUE')AS JOB_QUEUE,

              ah_name as JOB_NAME,

         ah_idnr as RUN_ID,

         ah_timestamp1 as ACTIVATON_TIME,

         ah_timestamp2 as "START_TIME",

         --ah_timestamp3 as post_proc,

         ah_timestamp4 as END_TIME,

         DECODE(ah_status,

                  1900,'ENDED_OK - ended normally',

                  1560,'Workflow is blocked',

                  1850,'ENDED_CANCEL - manually canceled',

                  1851,'ENDED_JP_CANCEL - Workflow canceled manually',

                                          1800,'ENDED_NOT_OK - aborted',

                                          1820,'FAULT_OTHER - Start impossbile. Other error',

                                          1930,'ENDED_SKIPPED - Skipped because of WHEN clause',

                                          1920,'ENDED_INACTIVE - Inactive today because of Calendar') AS JOB_STATUS

    from uc4p.ah

    where ah_otype in ('JOBP','JOBS')

    and ah_status not between 1900 and 1999

    and ah_timestamp2 > sysdate-1

    and ah_client=3000

    and ah_timestamp4 is not null

    order by 1 ASC,5 DESC;








  • 2.  RE: UC4 FAILED JOBS
    Best Answer

    Posted Jul 02, 2020 02:24 PM
    My guess is that there is a problem with your date/time selection rules.  Even though you may think you are only selecting by day, there is also a time-of-day inside of sysdate-1 and ah_timestamp2.   In addition, ah_timestamp2 does not contain local time!  It contains GMT time!   So if you investigate the full details of these values, you'll probably figure this out...

    ------------------------------
    Pete Wirfs
    SAIF Corporation
    Salem Oregon USA
    ------------------------------