Default Views Return Error (Doc ID 1358395.1)

Last updated on MARCH 06, 2024

Applies to:

Symptoms

====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
-----------------------
Error fetching query


STEPS
-----------------------
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?
Y
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
Error VB_PKG:75501:
---nQuestion_id
Error VB_PKG:230701:
---nDCM_Question_id
Error VB_PKG:VALUE_TEXT:
---vAttribute_name
Error VB_PKG:CHAR:

Cause

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