search cancel

Received event handler errors for prod jobs

book

Article ID: 243938

calendar_today

Updated On:

Products

CA Workload Automation AE

Issue/Introduction

Users received the following while running production jobs

Job Name                                                         Last Start           Last End             ST/Ex Run/Ntry Pri/Xit

________________________________________________________________ ____________________ ____________________ _____ ________ _______

GWMMM_CD_NOMQT_WIRES_LOGS_TO_DB_PODANODE2_2016                   06/10/2022 05:35:02  06/10/2022 05:35:05  SU    274624461/1 0      

 

  Status/[Event]  Time                 Ntry ES  ProcessTime           Machine

  --------------  --------------------- --  --  --------------------- ----------------------------------------

  STARTING        06/10/2022 05:35:01    1  PD  06/10/2022 05:35:01   xx.com

  RUNNING         06/10/2022 05:35:02    1  PD  06/10/2022 05:35:05   xx.com

    <Executing at WPA11BWMMSAP02V>

  SUCCESS         06/10/2022 05:35:05    1  PD  06/10/2022 05:35:06   xx.com

  [STARTJOB]      06/10/2022 05:36:00    0  ER  06/10/2022 05:44:06  

    <Event was scheduled based on job definition.>

  [*** ALARM ***]

    EVENT_HDLR_ERROR  06/10/2022 05:44:06    0  PD  06/10/2022 05:44:19  

    <An error occurred while processing event <PA60kyt9vk00> for job [GWMMM_CD_NOMQT_WIRES_LOGS_TO_DB_PODANODE2_2016 208921.274624461.0].>

 

Please let me know what caused this and if there is anything we can do to prevent this.

Environment

Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)

Resolution

Oracle marked a procedure as invalid and the first time AE tried to use it it encountered an error.  Subseqent calls worked fine, so Oracle must have recompiled it.  

To avoid the issue, check for invalid objects in the Oracle database before starting AutoSys.