TMS 4.5.2: SQLERROR ORA-04068: EXISTING STATE OF PACKAGES HAS BEEN DISCARDED (Doc ID 1077065.1)

Last updated on NOVEMBER 07, 2014

Applies to:

Oracle Thesaurus Management System - Version 4.5.2 and later
Information in this document applies to any platform.
***Checked for relevance on 24-APR-2012***
***Checked for relevance on 07-Nov-2014***

Symptoms


Running Oracle Clinical 4.5.2 with TMS 4.5.2.

Batch validation failing during TMS deriviation

i.e:

Submit job per: 


submitted batch validation job... end of job shows:

Modified Univariate Validation Resolution
No modified univariate question definitions since last execution.
TMS Thesaurus Validation Execution
calling TMS_OCL_DERV.DERIVATION first time
Error during TMS Thesaurus Validation
Derivation Procedure Execution
Validation Procedure Execution
No patients have modified data since last batch validation run.
Only procedures needing execution over all patients, if any, will be run.
TMS Thesaurus Validation Execution
exec_tms_procs second time

Successful TMS Thesaurus Validation

Batch Validation completed successfully at 19-MAR-2010 14:26:40.

*** NOTE: Batch Validation Completed with warnings due to TMS or Procedure execution or generation
SQL error during TMS Thesaurus Validation: SQLERROR ORA-04068: existing state of packages has been discarded
ORA-04063: pa

(NOTE: This is the way it is shown truncated in log)

Changes

Unknown.

Cause

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