InForm Data Load Job Hangs on IRV_SV_SUBJECTVISITS Or IRV_SV_SUBJECT_FORMS
(Doc ID 2730585.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Life Sciences Data Management Workbench - Version 2.4.8.5 and laterOracle Life 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 |