Unable To Download Data In Query Builder. Able To Download In SQL Query. Receive Error "nnn" (Doc ID 2627313.1)

Last updated on FEBRUARY 09, 2023

Applies to:

Symptoms

In APEX 19.1 trying to download the results of a query from the Query Builder interface results in the error:

Internal Error
Contact your application administrator. Details about this incident are available via debug id <nnn>.

Customer is in SQL Workshop > Utilities > Query Builder where the results of a query are shown.
Clicking on the Download link at the bottom of the page causes the failure.

The problem occurs for any query and is not table specific.

When reviewing the debug output for the failure in Debug Messages, the following is seen:

560000 559 12/12/2019 5:15:59.455386 PM -05:00 0.01958 0.00007 CGI: PATH_INFO = /wwv_flow.show?p_flow_id=4500&p_flow_step_id=1002&p_instance=<instanceid>&p_debug=&p_widget_action=FLOW_EXCEL_OUTPUT_R4345425019330550_en&p_request=PLUGIN%3Dy5Pn-saSIurSQSEpslbzWez6EJIAbjdpnoIQ-R8Tt0o 4500 1002 15876296605238 <USERNAME> 9 1052427403550970 %ERROR.raise_masked_internal_error:1510
%PLUGIN.ajax_region:2177
%PLUGIN.ajax_callback:3064
%.show:4481
:37
560001 559 12/12/2019 5:15:59.455455 PM -05:00 0.01965 0.00005 GET https://HOSTNAME/pls/apex
REMOTE_ADDR=10.46.221.13
REMOTE_USER=APEX_PUBLIC_USER
REFERER=https://HOSTNAME/f?p=4500:1002:15876296605238:LOAD:NO::P1002_QUERY_ID,P1002_SCHEMA:<NUM>,APEX_MIS
4500 1002 15876296605238 <USERNAME> 9 <NUM>
560002 559 12/12/2019 5:15:59.455502 PM -05:00 0.01969 0.00002 SID=1
USER=APEX_PUBLIC_USER
INSTANCE=1
4500 1002 15876296605238 <USERNAME> 9 <NUM>
560003 559 12/12/2019 5:15:59.455518 PM -05:00 0.01971 0.02071 Region id "4345425019330550" not found in g_plugs(count=39) 4500 1002 <NUM> <USERNAME> 1 <NUM>
560004 559 12/12/2019 5:15:59.476232 PM -05:00 0.04043 0.00005 Error: Internal Error 4500 1002 <NUM> <USERNAME> 1 <NUM> %ERROR.debug_error:1654
%ERROR_DEV.internal_error_handler:52
:5
SYS.DBMS_SYS_SQL.execute:2120
SYS.WWV_DBMS_SQL_APEX_190100.execute:599
%DYNAMIC_EXEC.run_block5:2486
%DYNAMIC_EXEC.execute_plsql_code:1476
%ERROR.exec_error_handling_callback:798
%ERROR.internal_get_error:980
%ERROR.internal_add_error:1039
%ERROR.raise_internal_error:1431
%ERROR.raise_masked_internal_error:1512
%PLUGIN.ajax_region:2177
%PLUGIN.ajax_callback:3064
%.show:4481
:37
560005 559 12/12/2019 5:15:59.476281 PM -05:00 0.04047 0.00004 - additional_info: Contact your application administrator.
Details about this incident are available via debug id "559". 4500 1002 <NUM> <USERNAME> 4 <NUM>
560006 559 12/12/2019 5:15:59.476316 PM -05:00 0.04051 0.00003 - display_location: ON_ERROR_PAGE 4500 1002 <NUM> <USERNAME> 4 <NUM>
560007 559 12/12/2019 5:15:59.476346 PM -05:00 0.04054 0.00003 - is_internal_error: true 4500 1002 <NUM> <USERNAME> 4 <NUM>
560008 559 12/12/2019 5:15:59.476376 PM -05:00 0.04057 0.00003 - apex_error_code: APEX.ERROR.INTERNAL 4500 1002 <NUM> <USERNAME> 4 <NUM>
560009 559 12/12/2019 5:15:59.476408 PM -05:00 0.0406 0.00003 - error_backtrace: ----- PL/SQL Call Stack -----
  object line object
  handle number name
53eb78300 971 package body APEX_190100.WWV_FLOW_ERROR.INTERNAL_GET_ERROR
53eb78300 1039 package body APEX_190100.WWV_FLOW_ERROR.INTERNAL_ADD_ERROR
53eb78300 1431 package body APEX_190100.WWV_FLOW_ERROR.RAISE_INTERNAL_ERROR
53eb78300 1512 package body APEX_190100.WWV_FLOW_ERROR.RAISE_MASKED_INTERNAL_ERROR
5143d0400 2177 package body APEX_190100.WWV_FLOW_PLUGIN.AJAX_REGION
5143d0400 3064 package body APEX_190100.WWV_FLOW_PLUGIN.AJAX_CALLBACK
506970b40 4481 package body APEX_190100.WWV_FLOW.SHOW
54b782f00 37 anonymous block
4500 1002 <NUM> <USERNAME> 4 <NUM>
560010 559 12/12/2019 5:15:59.476438 PM -05:00 0.04063 - component: APEX_APPLICATION_PAGE_REGIONS (4345425019330550) 4500 1002 <NUM> <USERNAME> 4 <NUM>

Other information
__________________

If the following steps have been performed, the error does not occur:
*  Go to SQL Workshop > Object Browser and select an object that fails (ex. WIA_REG)
*  Click on the Data tab, and click on the Query button.
*  Select the columns and run the query.

The file is created in the downloads folder on the PC.
The problem is specific to the Query Builder interface.

Cause

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