Default Views Return Error
(Doc ID 1358395.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Clinical - Version: 4.6.1
Information in this document applies to any platform.
On : 4.6.1 version, Data Extract and View Maintenance
When attempting to View the Data in the Data Extract View Definition,
the following error occurs.
Error fetching query
The issue can be reproduced at will with the following steps:
1. Login to OC
2. Navigation : Definition -> Data Extract View Definition Builder -> View Definitions
3. Select the View name & Click on the View data button
Error fetching query appears
Also, you'll find the following error in the output file:
===> Processing DCM E_SUBJMGMT
processing domain JVSTUDY dcm 142101 study 1
rxcdxbvb_pc_stmt_03 executed successfully.
rxcdxbvb_pc_stmt_19 executed successfully.
Create view texts invoked with sid 1 study JVSTUDY, mode INCREMENTAL vb enabled?
rxcdxbvb_pc_stmt_20 executed successfully.
rxcdxbvb_pc_stmt_21 executed successfully.
Invoking create_db_view_textsrxcdxbvb_pc_stmt_01 executed successfully.
create_db_view_texts invoked with
---> study id 1
---> study JVSTUDY
---> mode INCREMENTAL
Error VB_PKG:add quest colTERM:
---ORA-06502: PL/SQL: numeric or value error: character string buffer too small
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.|