Receive java.sql.SQLException: ORA-20144: No matching responsibility for Resp: error on OAE jobs.

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Receive java.sql.SQLException: ORA-20144: No matching responsibility for Resp: error on OAE jobs.

Environment

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

Resolution

Detailed Description and Symptoms

When trying to intercept or capture jobs from Oracle Application you receive the following error in the AgentService log on the remote server the OAE agent is associated with after it fails:

jdbc:oracle:thin:@APPS01.172.16.147.8:1533:conv01:[email protected]

java.sql.SQLException: ORA-20144: No matching responsibility for Resp:CW NTW SCM Super User Appl:CCWMSC and User:SCPADMIN

ORA-06512: at "APPS.APPWORX_OAE_PK", line 470

ORA-06512: at line 1

 

Investigation

The security triples information is not matching between the job prompts in Applications Manager and it's set up in Concurrent Manager.

TO confirm this is the case please look at the error message you are receiving in the AgentService log:

ErrorMsg: AwE-5001 Database Query Error (5/1/11 10:30 PM)

Details: appworx_oae_pk.aw_submit_conc

 0 jobId: IN:OUT:VARCHAR2:java.lang.String:129634.00

 1 resp_name: IN:OUT:VARCHAR2:java.lang.String:Advanced Supply Chain Planner

 2 resp_appl_name: IN:OUT:VARCHAR2:java.lang.String:MSC

 3 user_name: IN:OUT:VARCHAR2:java.lang.String:SCPADMIN

 4 application: IN:OUT:VARCHAR2:java.lang.String:MSC

 5 program: IN:OUT:VARCHAR2:java.lang.String: CCW_MSC_PO_SCHD_RCPTS

 6 printer: IN:VARCHAR2::null

 7 printer_style: IN:VARCHAR2::null

 8 copies: IN:NUMERIC::null

 9 save_output: IN:VARCHAR2:java.lang.String:Y

 10 print_together: IN:VARCHAR2::null

 11 conc_months: IN:OUT:NUMERIC:java.math.BigDecimal:120

 12 APPLICATION_JOBID: OUT:NUMERIC::null

 13 descr: IN:OUT:VARCHAR2::null

 14 language_territory: IN:OUT:VARCHAR2:java.lang.String:AMERICAN-|-AMERICA

 15 check_triple: IN:VARCHAR2:java.lang.String:Y

 16 xml_tmplt_appl_name: IN:VARCHAR2::null

 17 xml_tmplt_code: IN:VARCHAR2::null

 18 xml_tmplt_lang_terr: IN:VARCHAR2::null

 19 xml_output_format: IN:VARCHAR2::null

 20 org_id: IN:VARCHAR2::null

 21 arg_string: IN:OUT:VARCHAR2:java.lang.String:U

 

To confirm if there is a triples match please run the following package in sqlplus as the APPS user:

Appworx_oae_pk.check_triple_debug(<fnduser_name>,<application>,<responsibility>,<program>,<debug_flag>);

You would need to check in your job and see what you had set up as these values. Looking at the above error message it would be run as such:

set serveroutput on size 100000

begin

appworx_oae_pk.check_triple_debug('SCPADMIN','MSC','Advanced Supply','CCW_MSC_PO_SCHD_RCPTS','Y');

end;

If there is no match you will have similar returned:

SQL> set serveroutput on size 100000

begin

appworx_oae_pk.check_triple_debug ('SCPADMIN','MSC', 'Advanced Supply Chain Planner', ,'CCW_MSC_PO_SCHD_RCPTS','Y');

end;

SQL> 2 3 4 /

Check triple debug

Looking for user:SCPADMIN Appl:MSC Resp:Advanced Supply Chain Planner

List of valid:

For program:

CCW_MSC_PO_SCHD_RCPTS

User: Appl: Resp:

NO match found for:

User:SCPADMIN Appl:MSC Resp:Advanced Supply Chain Planner

  

PL/SQL procedure successfully completed.

 

 

Solution
 

If you receive no matching responsibilities you will need to update the prompts on the job in

Applications Manager to match what is set up within Concurrent Manager.