My Oracle Support Banner

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

Last updated on OCTOBER 09, 2018

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***


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.

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


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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