1 Reply Latest reply: Oct 1, 2013 5:36 AM by Hilary Farrell-Oracle RSS

    [BUG] ORA-20876: Stop APEX Engine when show charts on Apex 4.2.3

    jsqfel

      Hello,

       

      Important message to APEX DEV TEAM.

       

      I found bug on Apex 4.2.3, when page show charts debugger generate exception:  ORA-20876: Stop APEX Engine


      Full debug stack reproduced on apex.oracle.com in Sample Database Application:

      I only run application in latest Chrome, without any code modyfication.

       

      0.010660.00009S H O W: application="9520" page="1" workspace="" request="APXWGT" session="109791390375302"4

      1

      0.010740.00088Reset NLS settings4

      9

      0.011620.00017alter session set NLS_LANGUAGE="AMERICAN"4

      2

      0.011790.00014alter session set NLS_TERRITORY="AMERICA"4

      2

      0.011940.00013alter session set NLS_CALENDAR="GREGORIAN"4

      1

      0.012070.00016alter session set NLS_SORT="BINARY"4

      2

      0.012220.00012alter session set NLS_COMP="BINARY"4

      1

      0.012350.00003...NLS: Set Decimal separator="."4

      0

      0.012370.00081...NLS: Set NLS Group separator=","4

      9

      0.013180.00056...NLS: Set g_nls_date_format="DD-MON-RR"4

      6

      0.013740.00081...NLS: Set g_nls_timestamp_format="DD-MON-RR HH.MI.SSXFF AM"4

      9

      0.014550.00026...NLS: Set g_nls_timestamp_tz_format="DD-MON-RR HH.MI.SSXFF AM TZR"4

      3

      0.014810.00758...Setting session time_zone to +00:004

      81

      0.022390.00410Application 9520, Authentication: PLUGIN, Page Template: 560455072830634601164

      44

      0.026490.00329Authentication check: Application Express Accounts (NATIVE_APEX_ACCOUNTS)4

      35

      0.029790.00009...fetch session state from database4

      1

      0.029880.00081fetch items (exact)4

      9

      0.030690.00009... sentry+verification success4

      1

      0.030780.00053...Session ID 109791390375302 can be used4

      6

      0.031320.00020...Setting session time_zone to +00:004

      2

      0.031510.00049...Check for session expiration:4

      5

      0.032000.00017Session: Fetch session header information4

      2

      0.032170.00027SESSION Language (xxx@xxx): wwv_flow.g_browser_language=en maplang=en4

      3

      0.032450.00018alter session set nls_language="AMERICAN"4

      2

      0.032610.00004alter session set nls_territory="AMERICA"4

      0

      0.032650.00008NLS: CSV charset=WE8MSWIN12524

      1

      0.032720.00002...NLS: Set Decimal separator="."4

      0

      0.032750.00007...NLS: Set NLS Group separator=","4

      1

      0.032820.00008...NLS: Set g_nls_date_format="DD-MON-RR"4

      1

      0.032890.00007...NLS: Set g_nls_timestamp_format="DD-MON-RR HH.MI.SSXFF AM"4

      1

      0.032960.00005...NLS: Set g_nls_timestamp_tz_format="DD-MON-RR HH.MI.SSXFF AM TZR"4

      0

      0.033000.00011Setting NLS_DATE_FORMAT to application date format: DS4

      1

      0.033110.00013Setting NLS_TIMESTAMP_FORMAT to application timestamp format: DS4

      1

      0.033250.00102Setting NLS_TIMESTAMP_TZ_FORMAT to application timestamp time zone format: DS4

      11

      0.034260.00040...NLS: Set g_nls_date_format="DS"4

      4

      0.034660.00047...NLS: Set g_nls_timestamp_format="DS"4

      5

      0.035130.00059...NLS: Set g_nls_timestamp_tz_format="DS"4

      6

      0.035730.00609NLS: Language=en4

      65

      0.041830.00005Branch point: Before Header4

      1

      0.041870.00939Run APXWGT request4

      100

      0.051270.00754...Execute Statement: select sum(o.order_total) total, 10000 max, 0 low, sum(o.order_total) high from demo_orders o where order_timestamp >= to_date(to_char(sysdate,'YYYYMM')||'01','YYYYMMDD')4

      80

      0.058810.00066Stop APEX Engine detected4

      7

      0.059470.00003...Error data:4

      0

      0.059500.00003......message: AJAX call returned server error ORA-20876: Stop APEX Engine for chart5.4

      0

      0.059530.00003......is_internal_error: true4

      0

      0.059550.00003......apex_error_code: APEX.AJAX_SERVER_ERROR4

      0

      0.059580.00003......ora_sqlcode: -208764

      0

      0.059610.00003......ora_sqlerrm: ORA-20876: Stop APEX Engine4

      0

      0.059630.00080......error_backtrace: ORA-06512: at "APEX_040200.WWV_FLOW", line 3254 ORA-06512: at "APEX_040200.WWV_FLOW_FLASH_CHART5", line 6941 ORA-06512: at "APEX_040200.WWV_FLOW_AJAX", line 2934

      9

      0.060440.00017...Execute Error Handling Callout defined on Page or Application Level4

      2

      0.060610.00138...Execute Statement: begin declare l_error wwv_flow_error_api.t_error; begin l_error := wwv_flow_error_api.g_error; wwv_flow_error_api.g_error_result := sample_pkg.demo_error_handling ( p_error => l_error ); end; end;4

      15

      0.061980.00037Stop APEX Engine detected4

      4

      0.062360.00007Stop APEX Engine detected4

      1

      0.06242-Final commit4-

       

      Regards.