DMW-Inform Connectivity ORA-20200: ERROR: getRemoteLoc:Getting Remote location and connection details PLS-00352: Unable to access another database 'XYZ' (Doc ID 2181260.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.4 and later
Information in this document applies to any platform.

Symptoms

InForm > DMW data load is failing and the following error occurs:


Error from OWB/CDR DB Server-PLSQL Operator: statement:"begin CDR_WCE6_21021_1.PLSQL_UTIL_PROG_PKG.PROCESSPLSQLUTILJOB ; end;" caught:java.sql.SQLException: ORA-20200: *** ERROR: getRemoteLoc:Getting Remote location and connection details - ORA-06550: line 1, column 7:
PLS-00352: Unable to access another database 'MyDBAlias'
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DMW_XXX@MyDBAlias' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "APPS.CDR_ATK_UTILS", line 866
ORA-06512: at "APPS.DME_INFORM_MODEL", line 2886
ORA-06512: at "APPS.CDR_EXE_RUNTIME", line 11780
ORA-06512: at "CDR_WCE6_21021_1.PLSQL_UTIL_PROG_PKG", line 4
ORA-06512: at line 1


The issue can be reproduced at will with the following steps:
1. Submit DMW data load
2. Check the job log


Changes

 A new remote location was created using an already-existing hostname/read-only database schema combination. To do this required resetting the password which invalidated the original remote location that is attached to the study.

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