Intermittent "No role access" error when using 'appworx run'

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

When using an 'appworx run' command to request a Job or Process Flow, it may intermittently fail with the below error:

ErrorMsg: AwE-5001 Database Query Error
Details: ORA-20025: No role access to "Agent as "<AGENT NAME>" 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 "AMDEV.AW5", line 116
ORA-06512: at "AMDEV.AWAPI2", line 4369
ORA-06512: at "AMDEV.AWAPI2", line 487
ORA-06512: at "AMDEV.AWAPI2", line 2944
ORA-06512: at "AMDEV.AWAPI2", line 3536
ORA-06512: at "AMDEV.AWAPI2", line 4041
ORA-06512: at "AMDEV.AWOP_API", line 732
ORA-06512: at "AMDEV.AW5", line 107
ORA-06512: at "AMDEV.AW5", line 54
ORA-06512: at line 1
ORA-06512: at "AMDEV.AWDYN", line 19
ORA-06512: at line 1

Environment

Release : 9.3.x, 9.4.x

Component : APPLICATIONS MANAGER

Resolution

NOTE that solution and workaround should ONLY apply if the issue is intermittent. If the issue is not intermittent, the cause is likely a User Group issue.

Solution is under investigation

Workaround:

1. Add the following line to the [default] section of the Remote Agent server's $AW_HOME/site/awenv.ini,  where the Job or Process Flow runs, and save:
   
   DirectDBConnection=Y
   
   
2. Move a copy of the recommended ojdbc jar (oracle jdbc driver) to the Agent's $AW_HOME/web/classes directory
3. Restart Agent processes