All Jobs Hit ORA-20001:Error In CDR_on_logon:User Does Not Have Access

(Doc ID 2221120.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Life Sciences Data Hub - Version 2.4.6 and later
Information in this document applies to any platform.

Symptoms

After fixing a DB Connectivity issue (changes on listener.ora and tnsnames.ora), not longer able to run LSH jobs that were working fine before.

Similar to <NOTE:2124700.1> "Error In CDR_on_logon: User Does Not Have Access", but that patch is already applied:
 

select bug_number,language,creation_date from apps.ad_bugs where bug_number='19357286';

ERROR
-----------------------

A) Job Id: 1209256

Execution Status : Initializing :: Job Status: Pending :: 01-04-2017 10:08:02
Execution Status : Obtainservice :: Job Status: Pending :: 01-04-2017 10:08:03
Application is trying to allocate one of the following service instance id(s) for this job.

B) Job Id: 80023
Successfully allocated Service Instance Id 80023 for this job.
Service Instance Id: 80023
Execution Status : Execprepare :: Job Status: Pending :: 01-04-2017 10:08:03
Execution Status : Executing :: Job Status: Executing :: 01-04-2017 10:08:03
DEBUG MESSAGE FROM OWB/CDR DB Server-WF Operator: User defined program returned Failure... <====
Execution Status : Failed :: Job Status: Failure :: 01-04-2017 10:08:06

3. Also, there are errors reported in the OWB log as follows:
oracle.apps.cdr.dbserver.exec.server.CdrOperatorException: while getting connection JobId: oracle.sql.NUMBER@620a3d3b User:"ZZ_CDR_SI_100007" pwdlen:10 caught:java.sql.SQLException:
ORA-00604: error occurred at recursive SQL level 1
ORA-20001: Error in CDR_on_logon: User does not have access
ORA-06512: at line 20
...

2016/12/23-11:49:28-GMT [3C250CCE][CDR_RTREPOS.CDR_RTREPOS] oracle.wh.runtime.platform.adapter.InfrastructureException: RPE-01003: An infrastructure condition prevented the request from completing.
- No more data to read from socket
...
2017/01/04-08:34:57-GMT [20968FDA][CDR_RTREPOS.CDR_RTREPOS] Initializing execution for auditId= 268420 parentAuditId= 268387 topLevelAuditId=268387 taskName=C2:27916_1
2017/01/04-08:34:57-GMT [20968FDA][CDR_RTREPOS.CDR_RTREPOS] oracle.wh.runtime.platform.service.controller.RecoveryInProgress: RPE-01008: Recovery of this request is in progress.
  at oracle.wh.runtime.platform.service.controller.AdapterContextImpl.initialize(AdapterContextImpl.java:1746)
...



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms