Invalid InForm Remote Location: ORA-20009 Mandatory Tables Or Views Are Missing (IRV Views); ORA-06512: At DMW_ACCESS And DMW_IA_UTILS
Last updated on SEPTEMBER 05, 2017
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.
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