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 184.108.40.206 and later
Oracle Health Sciences InForm - Version 6.2 and later
Information in this document applies to any platform.
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
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.
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.
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