My Oracle Support Banner

Default Views Return Error (Doc ID 1358395.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Clinical - Version: 4.6.1 and later   [Release: 4.6 and later ]
Information in this document applies to any platform.


====Issue Clarification====

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
Error VB_PKG:add quest colTERM:
---ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Error VB_PKG:75501:
Error VB_PKG:230701:


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.