My Oracle Support Banner

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

Last updated on OCTOBER 27, 2022

Applies to:

Oracle Clinical - Version 4.5.3 and later
Information in this document applies to any platform.


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


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.


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

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