Received event handler errors for prod jobs

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

________________________________________________________________ ____________________ ____________________ _____ ________ _______

TEST_JOB                   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 xx.com>

  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 [TEST_JOB 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.