Batch Validation Running Very Slow - Stuck At TMS Derivation Step (Doc ID 961015.1)

Last updated on MARCH 23, 2010

Applies to:

Oracle Thesaurus Management System - Version: 4.6
Information in this document applies to any platform.

Goal

Currently every study's batch validation would take 5 - 10 hours to complete or even over 1 day .
The job stuck at "calling TMS_OCL_DERV.DERIVATION first time :" for long long time.

 

This started occurring right after WHO and MedDRA update.


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms