My Oracle Support Banner

Batch Validation Submitted, But Never Completes (Doc ID 1272158.1)

Last updated on FEBRUARY 18, 2019

Applies to:

Oracle Clinical - Version 4.5.3 and later
Information in this document applies to any platform.
***Checked for relevance on 12-JUN-2012***

Goal


Cannot successfully run Batch Validation Job for one particular study via OC/TMS 4.5.2.

Using:

OC > Conduct > Data Valication > Batch Validation


This job previously worked, but now job runs and never completes, so it's necessary to kill the job.

The job output indicates that it was running tms_ocl_derv.derivation when killed.

ie: the last lines of the Batch validation log show error like:

...

TMS Thesaurus Validation Execution
calling TMS_OCL_DERV.DERIVATION first time
Error during TMS Thesaurus Validation
Rolling back due to error
ORA-01041: internal error. hostdef extension doesn't exist

Logging off Oracle.

...


NOTE: the ORA-1041 is caused because job was killed, and not related directly to this problem.

Solution

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