Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

upgrade from 5.0 to 5.1, get ORA-06512: at WWV_FLOW_JSON

Arsen SirekanyanDec 27 2016 — edited Jan 12 2017

Hi all,
I upgraded apex from  5.0.0.00.31 to 5.1.0.00.45. and after that, almost every time I am trying to change a page via navigation tab, it throws an error

Backtrace: ORA-06512: at "APEX_050100.WWV_FLOW_JSON", line 1564

(the same error thrown on some dynamic actions as well)
However I can access any page with direct link, and there are few pages that have not this issue.

The only difference I was able to see is that in a new version the POST REQUEST to /apex/wwv_flow.accept have some parameters encoded in json

  1. p_flow_id:
    107
  2. p_flow_step_id:
    3
  3. p_instance:
    4746202991250
  4. p_page_submission_id:
    52260592556802630767234560264925504825
  5. p_request:
    Расходы
  6. p_reload_on_submit:
    A
  7. p_json:
    {"salt":"52260592556802630767234560264925504825","pageItems":{"itemsToSubmit":"[{\"n\":\"P3_FILE_NAME\",\"v\":\"\"},{\"n\":\"P3_TOV_KOD_TO_REUNION\",\"v\":\"\"}]","protected":"UKL5iHQ-z8Hn-Y4qWBqtqg","rowVersion":""}}

while older one does not

  1. p_flow_id:
    107
  2. p_flow_step_id:
    3
  3. p_instance:
    13840277327714
  4. p_page_submission_id:
    30318411857936
  5. p_request:
    Расходы
  6. p_accept_processing:
    9256737074745171
  7. p_accept_processing:
    100000
  8. p_arg_names:
    7386327071938973
  9. p_arg_names:
    7392226405228019
  10. p_t02:
    0
  11. p_arg_names:
    7527528180131276
  12. p_t03:
     
  13. p_arg_names:
    7567409368417393
  14. p_t04:
     
  15. p_md5_checksum:
     
  16. p_page_checksum:
    RrzBXskSLoBE8ge9Kxy1Bp3J7wo

I thought that problem was in my installation, but the problem occurred on apex.oracle.com  as well.

here are credit lines to it. (Sorry, the application is in mess. I wasn't able to build whole scheme and transfer any data, and it even not in English, but the error is thrown right after your try to change page, so I hope this will be enough)

application id - 112248
workspace TEST_AJAX_ERROR_50_51
user: test_error
pwd: test_error

Thanks,

sample error trace

ElapsedExecutionMessageLevel
0.005420.00154
Reset NLS settings
4
0.006960.00049
alter session set  NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CALENDAR='GREGORIAN' NLS_SORT='BINARY' NLS_COMP='BINARY'
4
0.007450.00003
...NLS: Set Decimal separator="."
4
0.007480.00017
...NLS: Set NLS Group separator=","
4
0.007650.00004
...NLS: Set g_nls_date_format="DD-MON-RR"
4
0.007690.00011
...NLS: Set g_nls_timestamp_format="DD-MON-RR HH.MI.SSXFF AM"
4
0.007790.00155
...NLS: Set g_nls_timestamp_tz_format="DD-MON-RR HH.MI.SSXFF AM TZR"
4
0.009340.00015
...Setting session time_zone to +03:00
4
0.009490.00071
R E Q U E S T accept Продажи
4
0.010200.00371
Metadata: Fetch application definition and shortcuts
4
0.013910.00024
Reset NLS settings
4
0.014150.00026
alter session set  NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CALENDAR='GREGORIAN' NLS_SORT='BINARY' NLS_COMP='BINARY'
4
0.014410.00003
...NLS: Set Decimal separator="."
4
0.014440.00010
...NLS: Set NLS Group separator=","
4
0.014540.00003
...NLS: Set g_nls_date_format="DD-MON-RR"
4
0.014570.00002
...NLS: Set g_nls_timestamp_format="DD-MON-RR HH.MI.SSXFF AM"
4
0.014590.00010
...NLS: Set g_nls_timestamp_tz_format="DD-MON-RR HH.MI.SSXFF AM TZR"
4
0.014690.00004
...Setting session time_zone to +03:00
4
0.014740.00257
NLS: wwv_flow.g_flow_language_derived_from=0: wwv_flow.g_browser_language=en-us
4
0.017300.00089
Authentication check: Application Express Authentication (NATIVE_APEX_ACCOUNTS)
4
0.018190.00084
Session State: fetch from database (exact)
4
0.019030.00004
... sentry+verification success
4
0.019080.00127
...Session ID 4746202991250 can be used
4
0.020340.00007
...Setting session time_zone to +03:00
4
0.020410.00069
...Check for session expiration:
4
0.021100.00184
...Metadata: Fetch Page, Computation, Process, and Branch
4
0.022940.00147
...Parse JSON
4
0.024400.00078
Exception in "final_exception_handler": Sqlerrm: ORA-06502: PL/SQL: numeric or value error Backtrace: ORA-06512: at "APEX_050100.WWV_FLOW_JSON", line 1564 ORA-06512: at "APEX_050100.WWV_FLOW", line 3016 ORA-06512: at "APEX_050100.WWV_FLOW", line 5533 
2
0.025190.00191
Add error onto error stack
4
0.027090.00004
Error: Error processing request.
1
0.027140.00002
- additional_info: ORA-06502: PL/SQL: numeric or value error
4
0.027160.00002
- display_location: ON_ERROR_PAGE
4
0.027180.00003
- is_internal_error: true
4
0.027210.00002
- apex_error_code: APEX.UNHANDLED_ERROR
4
0.027230.00003
- ora_sqlcode: -6502
4
0.027260.00002
- ora_sqlerrm: ORA-06502: PL/SQL: numeric or value error
4
0.027280.00002
- error_backtrace: ORA-06512: at "APEX_050100.WWV_FLOW_JSON", line 1564 ORA-06512: at "APEX_050100.WWV_FLOW", line 3016 ORA-06512: at "APEX_050100.WWV_FLOW", line 5533 
4
0.027300.00003
- component: APEX_APPLICATION_PAGES Типы Товара (107000000003)
4
0.027330.00010
...Show Error on Error Page
4
0.027430.00470
......Performing rollback
4
0.032130.00198
Show page template header
4
0.034110.00016
Load JavaScript file=/i/libraries/jquery/1.12.3/jquery-1.12.3.js?v=5.1.0.00.45
4
0.034270.00008
Load JavaScript file=/i/libraries/jquery/2.2.3/jquery-2.2.3.js?v=5.1.0.00.45
4
0.034350.00014
Set RequireJS define jquery=apex.jQuery
4
0.034500.00011
Load JavaScript file=/i/libraries/apex/core.js?v=5.1.0.00.45
4
0.034610.00008
Load JavaScript file=/i/libraries/apex/debug.js?v=5.1.0.00.45
4
0.034690.00008
Load JavaScript file=/i/libraries/apex/util.js?v=5.1.0.00.45
4
0.034770.00008
Load JavaScript file=/i/libraries/apex/locale.js?v=5.1.0.00.45
4
0.034850.00009
Load JavaScript file=/i/libraries/apex/lang.js?v=5.1.0.00.45
4
0.034940.00008
Load JavaScript file=/i/libraries/apex/message.js?v=5.1.0.00.45
4
0.035020.00008
Load JavaScript file=wwv_flow.js_messages?p_app_id=107&p_lang=en-us&p_version=5.1.0.00.45-30615520&p_builder=Y
4
0.035100.00008
Load JavaScript file=/i/libraries/apex/storage.js?v=5.1.0.00.45
4
0.035170.00008
Load JavaScript file=/i/libraries/apex/navigation.js?v=5.1.0.00.45


This post has been answered by Tony Andrews on Jan 12 2017
Jump to Answer



  

    
    

      
Comments

      

    

    

  

  

  



  

    
    
  

  

    

    

      

        
Locked Post

        

      

      

        
New comments cannot be posted to this locked post.

        

        
      

    

  





        

  

    
    

      
Post Details

      

    

    

  

  


  
    
    
    
      
Locked on Feb 9 2017
      
      
      
    
  
  
    
    
    
      
Added on Dec 27 2016
      
      
      
    
  
  
    
    
    
      
 #apex-5-1, #apex-discussions
      
      
      
    
  
  
    
    
    
      
                           6 comments
      
      
      
    
  
  
    
    
    
      
                       1,175 views