Hi,
i thought this gonna be easy but nay nay.
i created a interactive Grid report page with multiple default report options saved under "Action Menu" as well as Primary Report. However, when i tried to create like 9 or more than different default reports under the action menu it throws Ajax error attached.
There is only one table with 42 columns associated with the report query. Though some have only 2 columns displayed, also they have filter which is based on one column only.
Its interesting because i tried to create the same issue based on EMP table(open Apex workspace) and can create and save more than 11 default reports under action menu without any issue - so i wonder if its the number of columns in my base table(42 columns etc)
.....whats going on here - its weird.
i'll appreciate if someone could explain why creating multiple default Reports( 10 or more etc) under Action Menu doesnt work in interactive grid like interactive report or is there a limit?
..then on closing and trying to open the page again it throws then below error annoying crazy error -
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Error during rendering of region "Capital Management".
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Technical Info (only visible for developers)
-
is_internal_error: true
-
apex_error_code: APEX.REGION.UNHANDLED_ERROR
-
ora_sqlcode: -6502
-
ora_sqlerrm: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
-
component.type: APEX_APPLICATION_PAGES
-
component.id: 500000000040
-
component.name: LookupManagement
-
error_backtrace:
ORA-06512: at "APEX_050100.WWV_FLOW_DISP_PAGE_PLUGS", line 997
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
so again i tried to select only like 10 columns from the base table and recreate 15 default reports under action menu but the same error pops up after creating the 11th default report - so painful stuff.
Universal theme - Apex 5.1.x
thanks.