DNA Job Aborts in Applications Manager due to "Error executing procedure"

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

A DNA Job may fail with the following error:

Error executing procedure: proc_DNAJOB

Below is an example of the error as seen in the MS_QRSLT.lis file:

                                                                           Elapsed    Return     Checkpoint
    Start Date/Time         Stop Date/Time            Minutes    Code        Information
10-13-2022 20:43:04     10-13-2022 20:48:19   5.250        1              Error executing procedure: proc_DNAJOB

  Prog Info  : 
  (NTWkNode=14452, OraUID=123, OraSession=)
RETURNCODE=1

Environment

Release : 9.3.x, 9.4.x

Component : CA Automic Applications Manager (AM)

Resolution

The error is coming from DNA and the DNA database. It is recommended that the above error is reported to Fiserv's Support team for further review.