ARCHIVE JOB RUNS fails with an error

Products

• CA Workload Automation AE - Scheduler (AutoSys)
• Autosys Workload Automation

Issue/Introduction

The command archive_events fails with the following error while archiving the job_runs.

$ archive_events -A -j 3 -B 10000

CAUAJM_I_60014 Archiving Job Runs...
CAUAJM_E_18416 Event Server: <examplecompany.example.com>  Failed Query: <BEGIN :RetVal := UJO_CLEANUP_JOBRUNS (:I_endtime, :I_batch_size, :I_delete_orphans); END; <<1595188915,10000,1>>>
CAUAJM_E_18402 ORA-06550: line 1, column 18:
PLS-00306: wrong number or types of arguments in call to 'UJO_CLEANUP_JOBRUNS'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
CAUAJM_I_18403 Processing OCI function ODEFIN(34)
CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.
CAUAJM_E_18401 Function <doExecute> invoked from <execute> failed <892>
CAUAJM_E_18416 Event Server: <examplecompany.example.com>  Failed Query: <BEGIN :RetVal := UJO_CLEANUP_JOBRUNS (:I_endtime, :I_batch_size, :I_delete_orphans); END; <<1595188915,10000,1>>>
........
......
....

Environment

Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)

Cause

The error occurred due to corruption or changes made to the database function: UJO_CLEANUP_JOBRUNS on the CA Workload Automation AE database.

Resolution

Execute the RefreshAEDB.pl. It will refresh the Workload Automation AE database. See Refresh a CA Workload Automation AE Database for more details.

Additional Information

The script needs to be executed on both the database individually in dual event server environments.