Invalid InForm Remote Location 'XYZ' Or Study Account 'XYZ'. A Remote Location Fails But Rest Work OK Within Same Study

(Doc ID 2301005.1)

Last updated on JULY 13, 2018

Applies to:

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

Symptoms

Hit errors trying to do an InForm Metadata load. For a previously configured InForm connection the rest of the remote locations to this InForm study are now functioning within DMW, however this specific InFormURL cannot be connected to in a web browser.

ERRORS
========

1. Per DMW UI. When trying to review the MetaData comparison with the DMW UI the following javascript error message Alerts Screen:

DMW-067 Invalid InForm remote location '###' or study account '###'.
Error message (possibly from remote server)
ORA-06550 line 1, column 7: PLS-00352 Unable to access another database INF_1303_1932642320_1 must be declared
ORA-06550 line 1, column 7: Statement ignored


2. When trying to run a Manual InForm Data Load, per log, the following error occurs:

Start of Processing PLSQL_UTIL_PROG job id = 1932748661

***************************************************************************
InForm Datasource Information
InForm Datasource ID: 16834
Remote Location Object ID: 1932642319
Remote Location Name: DMWACC0541001UAT
InForm Trial Account: DBAC0541001UAT
InForm Trial Lifecycle: Development
InForm Version: 6.1.1.1.27
Blind Hidden Items?: NO
***************************************************************************

Error from OWB/CDR DB Server-PLSQL Operator: statement:"begin CDR_W517_BF7F71_1.PLSQL_UTIL_PROG_PKG.PROCESSPLSQLUTILJOB ; end;" caught:java.sql.SQLException: ORA-20200: *** ERROR: getRemoteLoc:Getting Remote location and connection details - User-Defined Exception
ORA-06512: at "APPS.CDR_ATK_UTILS", line 866
ORA-06512: at "APPS.DME_INFORM_MODEL", line 2577
ORA-06512: at "APPS.CDR_EXE_RUNTIME", line 11790
ORA-06512: at "CDR_W517_BF7F71_1.PLSQL_UTIL_PROG_PKG", line 4
ORA-06512: at line 1

Execution Status : Failed :: Job Status: Failure :: 08-24-2017 12:04:29

 

 

 

 

Changes

The study was re-deployed. We had to “check out” the data model to update the Business Area name, and this necessitated the re-install. After it, the job to load InForm data from InForm Trial to DMW failed and then, the InForm Data Model will not install.

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