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 JULY 13, 2023
Applies to:
Oracle Life Sciences Data Management Workbench - Version 3.1.0 and laterInformation 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 |