My Oracle Support Banner

DMW: Inform Loads Failing "PLS-00352: Unable to access another database", "ORA-20200: *** ERROR: InForm_Data_Submit:InForm_Data_SubmitError comparing metadata" (Doc ID 2870288.1)

Last updated on MAY 17, 2022

Applies to:

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

Symptoms

DMW 3.1.0, you encounter the following error message during Inform Loads:


ERROR
=====
Job failed with error(s).
ORA-20200: *** ERROR: InForm_Data_Submit:InForm_Data_SubmitError comparing metadata: E:1:Invalid InForm remote location (<remote_location_number>) or study account ('<study_account>').
Error message (possibly from remote server):
ORA-06550: line 1, column 7:
PLS-00352: Unable to access another database 'INF_<database_link>' - User-Defined Exception
ORA-06512: at "APPS.CDR_ATK_UTILS", line 866
ORA-06512: at "APPS.DME_INFORM_MODEL", line 3346
ORA-06512: at "APPS.CDR_EXE_RUNTIME", line 16102
ORA-06512: at "CDR_WCE6_21021_1.PLSQL_UTIL_PROG_PKG", line 4
ORA-06512: at line 1
:: 04-27-2022 02:27:33
Closed connection after completing ZZ user operation :: 04-27-2022 02:27:33

 

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


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