My Oracle Support Banner

How To Recreate Remote Location To Avoid Issues In DMW/Inform Configuration (Doc ID 2502202.1)

Last updated on JUNE 05, 2019

Applies to:

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

Symptoms

On : 2.4.8.1 version, Administration, InForm 6.1.1.1, DB version of the InForm study 11.2.0.4 .

ISSUE
======
DMW TEST: Issue in configuring Inform configuration

Configuring InForm for a Data Model: Currently the issue is they are not getting any error the page keep on loading forever and there are no errors/exceptions thrown.

DMW-087: Invalid InForm remote location (<REMOTE_LOCATION_NAME>) or study account (<SCHEMA_NAME>). Error message (possibly from remote server): ORA-6550: line 1, column 7:
PLS-00352: Unable to access another database <REMOTE_LOCATION_NAME> ORA-06550: line 1, column 7 PLS-201 invalid identifier <SCHEMA_NAME>@<REMOTE_LOCATION_NAME> must be declared ORA-6550: line 1, column 7: PL/SQL: statement ignored.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. The customer gives the remote location, Remote study account name and all other required parameters
and
2. Click save , the page keeps on loading forever.

3. An example was reproduced with below details:

Activity: Inform Configuration for  the study in training environment
Activity Start: 5:25PM EST
Activity Finished: 5:30PM EST (note that page keep on loading forever and there are no errors/exceptions thrown)

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.