1 Reply Latest reply: Dec 12, 2012 10:52 AM by BernardB RSS

    Strange Error During Page Load in Debug Mode (only) - Please Help!

    BernardB
      Hi All,

      Data base version: oracle 11g
      Apex version: Apex 4.1.1
      Webserver: Apache

      Need help with how to troubleshoot a Critical problem. The following error only occurs during page load in "Debug" mode. And, only occurs on a specific page within the application. A web page is served-up containing the following message and the application is blocked from running the page. The browser's (IE 8.0) back button must be clicked to proceed outside of "Debug" mode.

      "Error occurred while painting error page: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06502: PL/SQL: numeric or value error: character string buffer too small"

      Debug log follows:

      "S H O W: application="2006" page="6" workspace="" request="" session="500549669426301"
      ...

      ...
      Computation point: Before Header
      ...Perform computation of item: APP_SERVER, type=FUNCTION_BODY
      ...Performing function body computation
      ...Execute Statement: declare function x return varchar2 is begin return owa_util.get_cgi_env('SERVER_NAME'); return null; end; begin wwv_flow.g_computation_result_vc := x; end;
      ......Result = 156.9.122.214
      ...Session State: Save "APP_SERVER" - saving same value: "156.9.122.214"
      Processes - point: BEFORE_HEADER
      ...Process "GET_POSITION" - Type: PLSQL
      ...Execute Statement: begin wwv_flow.g_boolean := :F109_POSITION_ID IS NULL and :APP_PAGE_ID != 101; end;
      ......Result = FALSE
      ......Skip because condition or authorization evaluates to FALSE
      ...Process "Get JARS Sifter Log File Record Count" - Type: PLSQL
      ...Execute Statement: begin DECLARE vcnt NUMBER := 0; BEGIN d('Get JARS Sifter Log File Record Count'); Select count(*) into vcnt From JARS.JARS_SIFTER_LOG Where moveid = to_number(:P6_MOVEID) and sifter_status IN ('F','J'); :F1000_P6_SIFTER_LOG_COUNT := to_char(vcnt); END; end;
      Custom: Get JARS Sifter Log File Record Count
      ...Process "Set PTM Planned Trip Status" - Type: PLSQL
      ......Skip because condition or authorization evaluates to FALSE
      ...compatibility mode - do not set mime type
      ...compatibility mode - do not set additional http headers
      ...close http header
      ...metadata, fetch item type settings
      ...metadata, fetch items
      Show page template header
      Rendering form open tag and internal values
      Add error onto error stack
      ...Error data:
      ......message: Error processing request.
      ......additional_info: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
      ......display_location: ON_ERROR_PAGE
      ......is_internal_error: true
      ......apex_error_code: APEX.UNHANDLED_ERROR
      ......ora_sqlcode: -6502
      ......ora_sqlerrm: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
      ......error_backtrace: ORA-06512: at "APEX_040100.WWV_FLOW", line 3027 ORA-06512: at "APEX_040100.WWV_FLOW", line 7867
      ...Show Error on Error Page
      ......Performing rollback
      Rendering form open tag and internal values
      ...Unhandled Error while painting error page: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06502: PL/SQL: numeric or value error: character string buffer too small
      ...Error Backtrace: ORA-06512: at "APEX_040100.WWV_FLOW", line 2707 ORA-06512: at "APEX_040100.WWV_FLOW_ERROR", line 185
      End Page Rendering"

      Thanks!
      Bernard