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

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

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:

java.sql.SQLException: ORA-20144: No matching responsibility for Resp:, Appl: and User:

 

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
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:RESP
 2 resp_appl_name: IN:OUT:VARCHAR2:java.lang.String:APPL_NAME
 3 user_name: IN:OUT:VARCHAR2:java.lang.String:APPS
 4 application: IN:OUT:VARCHAR2:java.lang.String:MSC
 5 program: IN:OUT:VARCHAR2:java.lang.String: PROG
 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, replacing the values with the actual values found in the error:

appworx_oae_pk.check_triple_debug('<user_name>','<resp_appl_name>','<resp_name>','<program>','Y');

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('APPS','APPL_NAME','RESP','PROG','Y');
end;

 

If there is no match you will have similar returned:

set serveroutput on size 100000
begin
appworx_oae_pk.check_triple_debug('APPS','APPL_NAME','RESP','PROG','Y');
end;

Check triple debug
Looking for user:APPS Appl:APPL_NAME Resp:RESP

List of valid:
For program:
PROG
User: Appl: Resp:

NO match found for:
User:APPS Appl:APPL_NAME Resp:RESP

PL/SQL procedure successfully completed.

Resolution

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.