OAE jobs aborting or unknown status: ErrorMsg: AwE-5001 Database Query Errors

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

OAE jobs aborting or unknown status: ErrorMsg: AwE-5001 Database Query Errors

Environment

Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:

Resolution

Detailed Description and Symptoms

After upgrading to Applications Manager v8 to SP13 Oracle OAE jobs are either Aborting or going into an 'Unknown' status.

Investigation

After inspecting the OAE_Objects.sql we found that there were changes made to the files in recent Service Packs and they were not applied to the application during the upgrade. 

Solution

New files were forwarded and the triggers were updated successfully.