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 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.

Symptoms

Hitting below error about missing IRV Views while using a  DMW Remote Location which successfully connected via DMW to InForm.

DMW-412: Invalid InForm remote location (MYREMOTELOCATION) or study account (MYACCOUNT).
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.

Changes

First time InForm Remote Location is config/setup for this Study.

Cause

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