Invalid InForm Remote Location: ORA-20009 Mandatory Tables Or Views Are Missing (IRV Views); ORA-06512: At DMW_ACCESS And DMW_IA_UTILS
(Doc ID 2304421.1)
Last updated on DECEMBER 03, 2019
Applies to:Oracle Health Sciences Data Management Workbench - Version 2.4.6 and later
Information in this document applies to any platform.
Hitting below error about missing IRV Views while using a DMW Remote Location which successfully connected via DMW to InForm.
Error message (possibly from remote server): ORA-20009: Not a properly configured study account. Mandatory tables or views are missing
ORA-06512: at "<MYREMOTELOCATION>.DMW_ACCESS", line 218
ORA-06512: at "<MYREMOTELOCATION>.DMW_IA_UTILS", line 107
This was the first time user tried to setup the DMW-InForm Connection against this study so we cannot say of it was working earlier or not. Other Trials and InForm Remote Locations are working OK.
User is trying with the right Remote Study Account Name, I also tried and faced the same error. and Connection is working fine. I tested from Administrator tab.
First time InForm Remote Location is config/setup for this Study.
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