My Oracle Support Banner

InForm Data Load Job Hangs on IRV_SV_SUBJECTVISITS Or IRV_SV_SUBJECT_FORMS (Doc ID 2730585.1)

Last updated on MARCH 29, 2021

Applies to:

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

Symptoms

An InForm data load job is hanging. At the end of the log it shows:

Processing for Table IRV_SV_SUBJECTVISITS at XX-XXX-XXXX XX:XX:XX

OR

Processing for Table IRV_SV_SUBJECT_FORMS at XX-XXX-XXXX XX:XX:XX

The job may eventually complete, but takes hours.

Previously the jobs had been completing in a reasonable amount of time.

Changes

In InForm 6.2+, there were changes made to some of the IRV views that DMW queries. These changes involve the addition of a parallel hint.

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
Changes
Cause
Solution
References


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