Cannot Run Validation Procedures error calling proc_get_long_text ORA-01041: hostdef extension doesn't exist (Doc ID 800823.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Clinical - Version: 4.5.3 and later   [Release: 4.5.3 and later ]
Information in this document applies to any platform.
.
***Checked for relevance on 20-Sep-2010***
***Checked for relevance on 12-Apr-2012***

Symptoms

You are attempting to run individual or batch validation procedures. Instead of running to completion you receive the following error messages:

In the Output file:




LOG FILE includes:

 



Connected to database.
Job started.
Database state set to P
Starting 3GL command...
3GL/PLSQL Command started. PID saved.
OS User=mbahm
proc_get_long_text: Open cursor.

Parse Error Offset (if applicable) is: 13
ORA-01041: internal error. hostdef extension doesn't exist

Rolling back due to error.
ORA-01041: internal error. hostdef extension doesn't exist

Logging off Oracle.
ORA-01041: internal error. hostdef extension doesn't exist

Command finished
Error:Command exited with FAILURE status. Exit code=1
Completed with FAILURE status.



Another symptom of this conflict is that you are unable to generate DCM layouts.


NAVIGATION / REPLICATION PATH / CONFIGURATION CONTROL:
Responsibility: OC
Base Release/Patchset: 4.5.3

1. Run a batch validation session


OCCURRENCE PATTERNS: consistent, after upgrading a db server to 10G and later rebooting.
WORKAROUNDS: not aware of any
WHAT IS WORKING: everything else seems to be working fine

Connecting... Connected.
Batch Start: 01-APR-2009 12:34:49
Batch Validation at XXXXX for Study 124567 owned by XXXXX
Number of patients with modified data: 25

DVG, DVG Subset, Thesaurus Resolution
3 DVG discrepancies processed, 0 became obsolete, 0 changed to DVG Subset
0 DVG Subset discrepancies processed, 0 became obsolete
0 Thesaurus Terms discrepancies processed, 0 became obsolete
0 Data Type discrepancies processed, 0 became obsolete
0 Length discrepancies processed, 0 became obsolete

Modified Univariate Validation Resolution
No modified univariate question definitions since last execution.
TMS Thesaurus Validation Execution
calling TMS_OCL_DERV.DERIVATION first time
Processing Complete
Successful TMS Thesaurus Validation

Derivation Procedure Execution
Validation Procedure Execution
Procedure N_AEACNO(241501), version 0 start time is 01-APR-2009 12:34:57
Procedure N_AEACNO: Failed in execute_single_procedure
Batch Validation aborted due to an error
error calling proc_get_long_text

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