Banner Job Capture randomly aborts with Role access error

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Banner Job Captures intermittently Aborts due to a role access error.

Example of error found in Agent logs below:

ErrorMsg: AwE-9999 Internal error
Details: null
java.sql.SQLException: ORA-20025: No role access to "Agent as "BANNER_AGENT" rtype=N edit=N my_dba=N my useq=*-5-6 user_seq_to_check: -6.2 user_seq_to_check: -9-11 all user_seq: 1: 2: 3: 4: awop: "
ORA-06512: at "APPWORX.AWAPI2", line 477
ORA-06512: at "APPWORX.AWAPI2", line 2921
ORA-06512: at "APPWORX.AWAPI2", line 3513
ORA-06512: at "APPWORX.AWAPI2", line 4009
ORA-06512: at "APPWORX.AWOP_API", line 732
ORA-06512: at "APPWORX.AWOP_API", line 804
ORA-06512: at line 1

Example of error found in RMI logs below:

ErrorMsg: AwE-5001 Database Query Error (8/28/19 12:32 PM)
Details: awop_api.aw_request_direct
0 module: IN:VARCHAR2:java.lang.String:USER
1 jobId: IN:OUT:NUMERIC::null
2 requestor: IN:VARCHAR2:java.lang.String:add-USER
3 printer: IN:VARCHAR2::null
4 copies: IN:NUMERIC::null
5 queue: IN:VARCHAR2::null
6 restartOnAbort: IN:VARCHAR2::null
7 startDate: IN:TIMESTAMP::null
8 outputFunction: IN:VARCHAR2:java.lang.String:STORE
9 priority: IN:NUMERIC:java.math.BigDecimal:50
10 maxRunTime: IN:NUMERIC::null
11 dbLogin: IN:VARCHAR2::null
12 agent: IN:VARCHAR2:java.lang.String:BANNER_AGENT
13 abortQueue: IN:VARCHAR2::null
14 loadDefaults: IN:VARCHAR2:java.lang.String:N
15 viewName: IN:VARCHAR2::null
16 printOption: IN:VARCHAR2::null
17 predecessors: IN:VARCHAR2::null
18 statusName: IN:VARCHAR2:java.lang.String:N
19 prompts: IN:VARCHAR2:java.lang.String:
20 xmlArgs: IN:CLOB:java.lang.String:<?xml version="1.0" encoding="iso-8859-15" ?><data>

Environment

Release : 9.3 & 9.3.1

Component : APPLICATIONS MANAGER

Resolution

This behavior is fixed in Applications Manager version 9.3.2.