A Job with REQUEST JOB condition type intermittently fails with a FIN-DB ERROR status.
Article ID: 87878
Updated On:
Products
CA Automic Applications Manager (AM)
Issue/Introduction
Error Message :
jdbc:oracle:thin:@host:1521:automic:AM
java.sql.SQLException: ORA-20025: No role access to "Agent as "AM_AGENT" rtype=N edit=N my_dba=N my useq=*-5-6-9-11 all user_seq: 1: 2: 3: 4: awop: "
After upgrading to AM v8.0.15 SP15 or AM v9.0.1 SP1 some jobs that have a REQUEST JOB condition occasionally fail and go into a FIN-DB ERROR status in the backlog. You will see errors similar to these in the RmiServer debug log:
Changes made in v8.0.15 and v9.0.1 to the following SQL scripts caused the intermittent issue with jobs with REQUEST JOB conditions only:
jdbc:oracle:thin:@host:1521:automic:AM
java.sql.SQLException: ORA-20025: No role access to "Agent as "AM_AGENT" rtype=N edit=N my_dba=N my useq=*-5-6-9-11 all user_seq: 1: 2: 3: 4: awop: "
After upgrading to AM v8.0.15 SP15 or AM v9.0.1 SP1 some jobs that have a REQUEST JOB condition occasionally fail and go into a FIN-DB ERROR status in the backlog. You will see errors similar to these in the RmiServer debug log:
ErrorMsg: AwE-5001 Database Query Error (7/21/15 8:10 AM)
Details: aw5.aw_condition_action
0 jobid: IN:NUMERIC:java.math.BigDecimal:208870752
1 condition_order: IN:NUMERIC:java.math.BigDecimal:2
2 action: IN:VARCHAR2:java.lang.String:REQUEST JOB
3 performed: IN:OUT:VARCHAR2:java.lang.String:A
4 actionArg: IN:VARCHAR2:java.lang.String:-m GET_PSD_LOG_FTP -u APPWORX -iic 208870752.00 -o USMLIU209 -c 1 -q DBA_BATCH -f PRINT -p TEST -arg automic\[email protected] _NULL_ PUT /dlog/ PSD.log \ USMLIU209_PSD.log ASCII _NULL_ _NULL_ _NULL_ _NULL_
5 results: OUT:NUMERIC::null
6 text: OUT:VARCHAR2::null
jdbc:oracle:thin:@usmliu205.automic.com:1521:apworxq:APPWORX
java.sql.SQLException: ORA-20025: No role access to "Agent as "USMLIU209" rtype=N edit=N my_dba=N my useq=*-5-6-9-11 all user_seq: 1: 2: 3: 4: awop: "
ORA-06512: at "APPWORX.AWAPI2", line 4436
ORA-06512: at "APPWORX.AWOP_API", line 675
ORA-06512: at "APPWORX.AW5", line 2762
ORA-06512: at line 1
Details: aw5.aw_condition_action
0 jobid: IN:NUMERIC:java.math.BigDecimal:208870752
1 condition_order: IN:NUMERIC:java.math.BigDecimal:2
2 action: IN:VARCHAR2:java.lang.String:REQUEST JOB
3 performed: IN:OUT:VARCHAR2:java.lang.String:A
4 actionArg: IN:VARCHAR2:java.lang.String:-m GET_PSD_LOG_FTP -u APPWORX -iic 208870752.00 -o USMLIU209 -c 1 -q DBA_BATCH -f PRINT -p TEST -arg automic\[email protected] _NULL_ PUT /dlog/ PSD.log \ USMLIU209_PSD.log ASCII _NULL_ _NULL_ _NULL_ _NULL_
5 results: OUT:NUMERIC::null
6 text: OUT:VARCHAR2::null
jdbc:oracle:thin:@usmliu205.automic.com:1521:apworxq:APPWORX
java.sql.SQLException: ORA-20025: No role access to "Agent as "USMLIU209" rtype=N edit=N my_dba=N my useq=*-5-6-9-11 all user_seq: 1: 2: 3: 4: awop: "
ORA-06512: at "APPWORX.AWAPI2", line 4436
ORA-06512: at "APPWORX.AWOP_API", line 675
ORA-06512: at "APPWORX.AW5", line 2762
ORA-06512: at line 1
Changes made in v8.0.15 and v9.0.1 to the following SQL scripts caused the intermittent issue with jobs with REQUEST JOB conditions only:
aw_operation_body.sql
awapi_body.sql
awapi_spec.sql
awapi_body.sql
awapi_spec.sql
Environment
Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:
Component:
Cause
Cause type:
Defect
Root Cause: Refer to Description.
Defect
Root Cause: Refer to Description.
Resolution
This field was added on 30/03/2017. This article has not been updated yet. Refer to the "Description" or "Workaround" sections for solution information.
Fix Status: Released
Fix Version(s):
Applications Manager 9.1.0 - already available
Applications Manager 8.0.16 - already available
Fix Status: Released
Fix Version(s):
Applications Manager 9.1.0 - already available
Applications Manager 8.0.16 - already available
Additional Information
Workaround :
N/A
N/A
Feedback
Yes
No
Powered by
