Forum Stats

  • 3,726,961 Users
  • 2,245,298 Discussions
  • 7,852,510 Comments

Discussions

APEX_APPLICATION_TEMP_FILES after upgrading to APEX 20.1 ORA-01403

zagirov
zagirov Member Posts: 48 Blue Ribbon
edited July 2020 in APEX Discussions

Hello!

The problem started after switching from Apex 18.2 to Apex 20.1
Using ORDS 19.4.6 on Tomcat9
The last PSE BUNDLE PATCH_VERSION = 2020.06.25 was successfully installed on APEX

select version, status from dba_registry where comp_id = 'APEX'
VERSION STATUS
------------------------------ -----------
20.1.0.00.13 VALID

The same error occurs in many of my applications, I will clearly show on the application "Sample File Upload and Download"
Page 13 "Project" - Upload File and successfully select the file and click "Apply Changes" I get:

Technical Info (only visible for developers) is_internal_error: true
apex_error_code: APEX.UNHANDLED_ERROR
ora_sqlcode: 100
ora_sqlerrm: ORA-01403: no data found ORA-06512: at "APEX_200100.WWV_FLOW", line 1362
component.type: APEX_APPLICATION_PAGES
component.id: 105000000013
component.name: Project
error_backtrace:
ORA-06512: at "APEX_200100.WWV_FLOW", line 1362
ORA-06512: at "APEX_200100.WWV_FLOW", line 3870

Nothing falls into the temporary table.
How I tried to solve the problem:
1. exec wwv_flow_upgrade.recreate_public_synonyms ('APEX_200100'); - did not help
2. alter user flows_files quota unlimited on users; Doc ID 2681340.1 - did not help
3. d0.sql Enabling LEVEL9 does not add details to my error

How can this problem be solved?

скрин1.JPG

Best Answer

  • zagirov
    zagirov Member Posts: 48 Blue Ribbon
    edited July 2020 Accepted Answer

    "And the casket just opened"

    The problem was an incorrectly configured ORDS. This parameter is in default.xml

    <entry key = "owa.docTable"> ttt.wwdoc_document </entry>

    It is directly intended for "mod_plsql schemas" and conflicts with APEX..

Answers

  • zagirov
    zagirov Member Posts: 48 Blue Ribbon
    edited July 2020

    1. In the new version of Apex, the rows in the flows_files.wwv_flow_file_objects$ table still fall

    but CREATED_BY in ('SYS', 'ADMIN')

    There are no rows created by user APEX_PUBLIC_USER.

    2. After deep debugging, I found 1362 lines of code in the APEX_200100.WWV_FLOW package

      1360 L_FILE_COUNT: = WWV_FLOW_JSON.GET_VARCHAR2 (L_VALUE_PATH || '.fileCount');

      1361 FOR I IN L_FILE_INDEX .. L_FILE_INDEX + L_FILE_COUNT - 1 LOOP

      1362 L_VALUE: = L_VALUE || CASE WHEN L_VALUE IS NOT NULL THEN ':' END ||

      1363 P_FILES (I);

      1364 END LOOP;

    3. Below attached a full listing of the debug sheet with LEVEL9

    init cgi_var_name.count=>52CGI: PATH_INFO = /wwv_flow.acceptPOST http://***.corp/ordsREMOTE_ADDR=172.16.10.247REMOTE_USER=APEX_PUBLIC_USERAPEX_LISTENER_VERSION=19.4.6.r1421859REFERER=http://iis.ufa.tn.corp/ords/f?p=105:13:7150210842260::LEVEL9:RP,13:P13_ID:225054982316088655730525240989796606228&cs=3-QRJCbRaZoLsN7S6ehE-r-imqEg8_om4Idx62Pzc71npofgQjCi_eR3treN0wWpDf64ZK7Z6xYsBVy1ipfDyzgAPEX Version=20.1.0.00.13Patch Version=2020.06.25SID=1162USER=APEX_PUBLIC_USERINSTANCE=1Reset NLS settingsalter session set  NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_SORT='BINARY' NLS_COMP='BINARY' NLS_CALENDAR='GREGORIAN'...NLS: Set Decimal separator="."...NLS: Set NLS Group separator=","...NLS: Set g_nls_date_format="DD-MON-RR"...NLS: Set g_nls_timestamp_format="DD-MON-RR HH.MI.SSXFF AM"...NLS: Set g_nls_timestamp_tz_format="DD-MON-RR HH.MI.SSXFF AM TZR"NLS of database and client differs, characterset conversion neededCSV parameters: enclosed by:<<">>, separated by:<<,>>, escape char:<< >>...Setting session time_zone to +03:00reset_nls_environmentR E Q U E S T accept SAVEresetresetget_apex_pathget_friendly_workspace_url p_url=>,p_absolute_url=>false,g_friendly_url_prefix=>get_workspace(150732114682318709): reusing g_workspaceget_friendly_workspace_url="stroy/r/", sgid=0get_apex_path="/ords/"Metadata: Fetch application definition and shortcutsfetch_flow_infoset_html_escaping_mode p_mode=>Eget_workspace(150732114682318709): reusing g_workspaceget_friendly_workspace_url p_url=>files/static/v1/,p_absolute_url=>false,g_friendly_url_prefix=>stroy/r/get_friendly_workspace_url="stroy/r/files/static/v1/", sgid=0get_friendly_app_url p_application_id=>105,p_url=>files/static/v1/,p_absolute_url=>falseget_friendly_workspace_url p_url=>105/files/static/v1/,p_absolute_url=>false,g_friendly_url_prefix=>stroy/r/get_friendly_workspace_url="stroy/r/105/files/static/v1/", sgid=0set_g_cached_theme p_theme_id=>42,p_application_id=>105,p_security_group_id=>150732114682318709set_g_cached_theme p_theme_id=>42,p_application_id=>105,p_security_group_id=>150732114682318709set_g_cached_theme p_theme_id=>42,p_application_id=>105,p_security_group_id=>150732114682318709set_g_cached_theme p_theme_id=>42,p_application_id=>105,p_security_group_id=>150732114682318709set_g_cached_theme p_theme_id=>42,p_application_id=>105,p_security_group_id=>150732114682318709set_g_cached_theme p_theme_id=>42,p_application_id=>105,p_security_group_id=>150732114682318709set_g_cached_theme p_theme_id=>42,p_application_id=>105,p_security_group_id=>150732114682318709check_request_can_be_processed...check app owner "STROY" is a valid workspace schema in "150732114682318709"is_company_schema p_security_group_id=>150732114682318709,p_schema=>STROY...check app owner is a valid database schemaNLS: wwv_flow.g_flow_language_derived_from=FLOW_PRIMARY_LANGUAGE: wwv_flow.g_browser_language=enalter_session p_language=>en,g_nls_language_set=>alter session set nls_language='AMERICAN' nls_territory='AMERICA'NLS: CSV charset=WE8MSWIN1252...NLS: Set Decimal separator="."...NLS: Set NLS Group separator=","...NLS: Set g_nls_date_format="DD-MON-RR"...NLS: Set g_nls_timestamp_format="DD-MON-RR HH.MI.SSXFF AM"...NLS: Set g_nls_timestamp_tz_format="DD-MON-RR HH.MI.SSXFF AM TZR"reset_nls_environment...metadata, fetch translated app infoauthenticate_and_init_session p_app_id=>105,p_auth_override=>,p_has_safe_url_parameters=>null,p_clone_session=>falseget_current g_instance=>7150210842260set_session_id p_session_id=>7150210842260set_session_id p_session_id=>7150210842260internal_rc_get_authentication p_app_id=>105, p_session_authn_id=>,p_app_security_group_id=>150732114682318709set_g_security_group_id p_security_group_id=>150732114682318709,p_check_host_prefix=>true,p_check_account_status=>trueget_workspace(150732114682318709): reusing g_workspacedoes_url_match_workspace p_security_group_id=>150732114682318709,p_host_prefix=>,l_http_host=>***.corp,p_path_prefix=>STROY,c_path_info=>/wwv_flow.accept... PROXY_AUTHENTICATION not enabled - no path_prefix checkset_workspace_id p_workspace_id=>150732114682318709get_apex_pathget_friendly_workspace_url p_url=>,p_absolute_url=>false,g_friendly_url_prefix=>stroy/r/get_friendly_workspace_url="stroy/r/", sgid=150732114682318709get_apex_path="/ords/"... authentication id=14813892256707778819, sgid=150732114682318709, curr flow sgid=150732114682318709, cookie=ORA_WWV_PACKAGED_APPLICATIONSget_page_info p_application_id=>105,p_page_id=>13,p_security_group_id=>150732114682318709...page info not cached, loading itget_login_url p_user_interface_id=>1140865469284790689,p_application_id=>105,p_security_group_id=>150732114682318709get_home_url p_user_interface_id=>1140865469284790689,p_application_id=>105,p_security_group_id=>150732114682318709invalid_session_type=LOGIN,LOGIN=,URL=f?p=&APP_ID.:LOGIN:&SESSION.init_authentication_globals p_mode=>0,p_dynamic_roles=>,p_namespaces=>... RAS is disabled at instance level... page is public:false, public auth:falserejoin_existing_sessions c_platform_rejoin_sessions=>P,p_app_id=>105,p_app_browser_frame=>D,p_app_rejoin_existing_sessions=>P,p_page_info.rejoin_existing_sessions=>> APEX_APPLICATION_AUTH Application Express Accountsadd_standard_headers p_app_response_headers=>add_header p_key=>X-Content-Type-Options,p_name=>X-Content-Type-Options,p_value=>nosniff,p_overwrite=>true,p_is_sticky=>trueadd_header p_key=>X-Xss-Protection,p_name=>X-Xss-Protection,p_value=>1; mode=block,p_overwrite=>true,p_is_sticky=>true...session id given - no rejoiningset_session_id p_session_id=>7150210842260set_session_id p_session_id=>7150210842260builtin_cookie_sentry p_cookie_name=>ORA_WWV_PACKAGED_APPLICATIONSget_by_cookie_name p_cookie_name=>ORA_WWV_PACKAGED_APPLICATIONSsession cookie value for ORA_WWV_PACKAGED_APPLICATIONS=ORA_WWV-TRwsGXcZQNt-2H9H7fptP7d8to_int_cookie_value p_pub_cookie_value=>ORA_WWV-TRwsGXcZQNt-2H9H7fptP7d8,p_cookie_name=>ORA_WWV_PACKAGED_APPLICATIONS... session=7150210842260, user=ADMIN, sgid=150732114682318709, auth_id= (from cache)... ok, session id and security group id matches... set user and session id in package globalsset_user p_user=>ADMINset_user p_user=>ADMINset_g_security_group_id p_security_group_id=>150732114682318709,p_check_host_prefix=>true,p_check_account_status=>true... already set - exitset_db_session_infoget_workspace(150732114682318709): reusing g_workspacedo_get_plugin_cache_idx p_app_id=>105,p_app_security_group_id=>150732114682318709,p_plugin_type=>AUTHENTICATION TYPE,p_name=>NATIVE_APEX_ACCOUNTScheck session integrity: security group id matchesSession State: fetch from database (exact)set_session_id p_session_id=>7150210842260set_session_id p_session_id=>7150210842260... id=3260704072945623852, name=P13_ID, value=****... id=14813892866117778827, name=P101_USERNAME, value=****execute_native_session_sentry p_type=>NATIVE_APEX_ACCOUNTS... sentry success, no verification specified... sentry+verification successcreate_or_reuse_session p_clone_session=>falseset_session_id p_session_id=>7150210842260set_session_id p_session_id=>7150210842260...Session ID 7150210842260 can be usedinit_session p_sessionid=>init_cacheset_session_id p_session_id=>7150210842260set_session_id p_session_id=>7150210842260check session integrity: security group id matches< APEX_APPLICATION_AUTH Application Express Accountsget_by_cookie_name p_cookie_name=>ORA_WWV_USER_61813407686501session cookie value for ORA_WWV_USER_61813407686501=ORA_WWV-_bpUArC6XU5XPzzLq2zmrMaCto_int_cookie_value p_pub_cookie_value=>ORA_WWV-_bpUArC6XU5XPzzLq2zmrMaC,p_cookie_name=>ORA_WWV_USER_61813407686501... loading from session table... saved g_builder_session... session=17139727710672, user=ADMIN, sgid=150732114682318709, auth_id= (from db)get_builder_session_id: builder session=17139727710672...Setting session time_zone to +03:00check_session_timeoutset_session_id p_session_id=>7150210842260set_session_id p_session_id=>7150210842260...Check for session expiration:update_idle_timeout g_current_session.max_idle_sec=>43200,g_current_session.cookie_value=>TRwsGXcZQNt-2H9H7fptP7d8GfaAm_C3,g_current_session.idle_timeout_on=>02-JUL-20... updated idle timeout in 1 session...Metadata: Fetch Page, Computation, Process, and Branchfetch_step_infoset_g_cached_theme p_theme_id=>42,p_application_id=>105,p_security_group_id=>150732114682318709set_g_cached_theme p_theme_id=>42,p_application_id=>105,p_security_group_id=>150732114682318709set_g_cached_theme p_theme_id=>42,p_application_id=>105,p_security_group_id=>150732114682318709set_g_cached_theme p_theme_id=>42,p_application_id=>105,p_security_group_id=>150732114682318709set_g_cached_theme p_theme_id=>42,p_application_id=>105,p_security_group_id=>150732114682318709set_g_cached_theme p_theme_id=>42,p_application_id=>105,p_security_group_id=>150732114682318709set_g_cached_theme p_theme_id=>42,p_application_id=>105,p_security_group_id=>150732114682318709add_header p_key=>Cache-Control,p_name=>Cache-Control,p_value=>no-store,p_overwrite=>true,p_is_sticky=>trueadd_header p_key=>Pragma Cache-Control,p_name=>Pragma,p_value=>no-cache,p_overwrite=>true,p_is_sticky=>trueadd_header p_key=>Expires,p_name=>Expires,p_value=>Sun, 27 Jul 1997 13:00:00 GMT,p_overwrite=>true,p_is_sticky=>trueadd_header p_key=>X-Frame-Options,p_name=>X-Frame-Options,p_value=>DENY,p_overwrite=>true,p_is_sticky=>true...Parse JSON{"salt":"282021143933510725668491645768953273157","pageItems":{"itemsToSubmit":[{"n":"P13_ID","v":"225054982316088655730525240989796606228","ck":"Agw3dx2s3wqUs7NHV3XoJZquw_dsJhDa2OwUNtbJy8sI_XuC7o0quO80djDuIcgysxXw_Jz7bKWrqCnaMEcUsA"},{"n":"P13_PROJECT","v":"ACME Web Express Configuration"},{"n":"P13_TASK_NAME","v":"Create pilot workspace"},{"n":"P13_START_DATE","v":"25-JUN-20"},{"n":"P13_END_DATE","v":"25-JUN-20"},{"n":"P13_STATUS","v":"Closed"},{"n":"P13_ASSIGNED_TO","v":"John Watson"},{"n":"P13_COST","v":"100"},{"n":"P13_BUDGET","v":"100"},{"n":"P13_PROJECT_ICON","v":""},{"n":"P13_ICON_COMMENTS","v":"Project Icon","ck":"N-OB9rR0Gn5igZXkrFoUqtu2BfJbRH5bWxQhiU62LAOIhTwBHrGkHfY18Rn1Ko4lZA90yq7h5Aetc8448zH9cw"},{"n":"P13_FILE","v":"C:\\fakepath\\вузы.txt","fileIndex":1,"fileCount":1},{"n":"P13_FILE_DESCRIPTION","v":""}],"protected":"8vbJHeMMPTm7D6uBmJjfK80f3OJpPtYx7hob0Caa9S8","rowVersion":"oNJmaahHuHSdXrH4b-G7NuWlSJcl-l4wpUv7AGCHcqVs_-2wOaOr3znDmzxZ9bkQMuy5xbAo1rR4s_ltnQ5ofA","formRegionChecksums":[]}}parse_page_items_json_object p_only_items_of_current_page=>true,p_all_protected_items_required=>true,p_no_ssp_items=>false,p_files.count=>0......Validate item page affinityget_decrypted_protected_items p_salt=>282021143933510725668491645768953273157set_session_id p_session_id=>7150210842260set_session_id p_session_id=>7150210842260......Read Page Item values and validate protected itemsfind_item_by_name p_name=>P13_IDfind_item_by_index_in_page: initialized cache for 105:13: 14 entries, 28 indexes.........Name=P13_ID (id=3260704072945623852), value=***, checksum=Agw3dx2s3wqUs7NHV3XoJZquw_dsJhDa2OwUNtbJy8sI_XuC7o0quO80djDuIcgysxXw_Jz7bKWrqCnaMEcUsAget_protected_item_checksum p_item=>P13_ID,p_value=>225054982316088655730525240989796606228set_session_id p_session_id=>7150210842260set_session_id p_session_id=>7150210842260lov_checksum("22505498231608865573052524098979660622813P13_ID282021143933510725668491645768953273157" - len 86)="Agw3dx2s3wqUs7NHV3XoJZquw_dsJhDa2OwUNtbJy8sI_XuC7o0quO80djDuIcgysxXw_Jz7bKWrqCnaMEcUsA"... item checksum=Agw3dx2s3wqUs7NHV3XoJZquw_dsJhDa2OwUNtbJy8sI_XuC7o0quO80djDuIcgysxXw_Jz7bKWrqCnaMEcUsAfind_item_by_name p_name=>P13_PROJECT.........Name=P13_PROJECT (id=3260704269109623852), value=***, checksum=find_item_by_name p_name=>P13_TASK_NAME.........Name=P13_TASK_NAME (id=3260704456974623853), value=***, checksum=find_item_by_name p_name=>P13_START_DATE.........Name=P13_START_DATE (id=3260704672884623855), value=***, checksum=find_item_by_name p_name=>P13_END_DATE.........Name=P13_END_DATE (id=3260704853833623855), value=***, checksum=find_item_by_name p_name=>P13_STATUS.........Name=P13_STATUS (id=3260705062378623855), value=***, checksum=find_item_by_name p_name=>P13_ASSIGNED_TO.........Name=P13_ASSIGNED_TO (id=3260705272505623855), value=***, checksum=find_item_by_name p_name=>P13_COST.........Name=P13_COST (id=3260705460559623855), value=***, checksum=find_item_by_name p_name=>P13_BUDGET.........Name=P13_BUDGET (id=3260705654168623856), value=***, checksum=find_item_by_name p_name=>P13_PROJECT_ICON.........Name=P13_PROJECT_ICON (id=3262117171963146727), value=, checksum=find_item_by_name p_name=>P13_ICON_COMMENTS.........Name=P13_ICON_COMMENTS (id=3262127558530098476), value=***, checksum=N-OB9rR0Gn5igZXkrFoUqtu2BfJbRH5bWxQhiU62LAOIhTwBHrGkHfY18Rn1Ko4lZA90yq7h5Aetc8448zH9cwget_protected_item_checksum p_item=>P13_ICON_COMMENTS,p_value=>Project Iconset_session_id p_session_id=>7150210842260set_session_id p_session_id=>7150210842260lov_checksum("Project Icon13P13_ICON_COMMENTS282021143933510725668491645768953273157" - len 70)="N-OB9rR0Gn5igZXkrFoUqtu2BfJbRH5bWxQhiU62LAOIhTwBHrGkHfY18Rn1Ko4lZA90yq7h5Aetc8448zH9cw"... item checksum=N-OB9rR0Gn5igZXkrFoUqtu2BfJbRH5bWxQhiU62LAOIhTwBHrGkHfY18Rn1Ko4lZA90yq7h5Aetc8448zH9cwfind_item_by_name p_name=>P13_FILEException in "final_exception_handler":Error Stack: ORA-01403: no data foundORA-06512: at "APEX_200100.WWV_FLOW", line 1362Backtrace: ORA-06512: at "APEX_200100.WWV_FLOW", line 1362ORA-06512: at "APEX_200100.WWV_FLOW", line 3870setting g_primary_language := enAdd error onto error stack... get_component -> APEX_APPLICATION_PAGES ProjectError: Error processing request.- additional_info: Contact your application administrator.Details about this incident are available via debug id "2202807".- display_location: ON_ERROR_PAGE- is_internal_error: true- is_common_runtime_error: false- apex_error_code: APEX.UNHANDLED_ERROR- ora_sqlcode: 100- ora_sqlerrm: ORA-01403: no data foundORA-06512: at "APEX_200100.WWV_FLOW", line 1362- error_backtrace: ORA-06512: at "APEX_200100.WWV_FLOW", line 1362ORA-06512: at "APEX_200100.WWV_FLOW", line 3870- component: APEX_APPLICATION_PAGES Project (105000000013)...Show Error on Error Page......Performing rollbackreset p_keep_sticky_headers=>truerender_error_pageresetresetadd_header p_key=>Content-Type,p_name=>Content-Type,p_value=>text/html; charset=utf-8,p_overwrite=>true,p_is_sticky=>falsewrite_headers p_close_header_section=>falseAPEX-DEBUG-ID=2202807,level=ERRORadd_header p_key=>APEX-Debug-ID,p_name=>APEX-Debug-ID,p_value=>2202807,level=ERROR,p_overwrite=>true,p_is_sticky=>truewrite_headers p_close_header_section=>falseAPEX-DEBUG-ID=2202807,level=ERRORadd_header p_key=>APEX-Debug-ID,p_name=>APEX-Debug-ID,p_value=>2202807,level=ERROR,p_overwrite=>true,p_is_sticky=>truewrite_headers p_close_header_section=>trueAPEX-DEBUG-ID=2202807,level=ERRORadd_header p_key=>APEX-Debug-ID,p_name=>APEX-Debug-ID,p_value=>2202807,level=ERROR,p_overwrite=>true,p_is_sticky=>trueget_grid_template p_page_template_id=>1928224859549228908emit_page_headerShow page template headeris_desktop_ui p_application_id=>105,p_page_id=>13,p_security_group_id=>150732114682318709get_ui_type p_application_id=>105,p_page_id=>13,p_security_group_id=>150732114682318709get_page_info p_application_id=>105,p_page_id=>13,p_security_group_id=>150732114682318709...page info not cached, loading it... ui type name=DESKTOPloadresetIgnore concatenated files of application because we are running in debug mode or from BuilderIgnore concatenated files for APEX libraries because we are running in debug modeget_file_url p_url=>/i201/app_ui/css/Core.css?v=20.1.0.00.13get_file_url p_url=>/i201/app_ui/css/Theme-Standard.css?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/jquery-ui/1.12.1/jquery-ui-apex.css?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/jquery/3.5.1/jquery-3.5.1.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/jquery/3.5.1/jquery-3.5.1.js?v=20.1.0.00.13add_requirejs_define p_module=>jquery,p_js_expression=>apex.jQueryget_file_url p_url=>/i201/libraries/apex/core.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/core.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/debug.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/debug.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/util.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/util.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/locale.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/locale.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/lang.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/lang.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/message.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/message.js?v=20.1.0.00.13get_file_url p_url=>wwv_flow.js_messages?p_app_id=105&p_lang=en&p_version=20.1.0.00.13-11588761186919&p_builder=YLoad JavaScript file=wwv_flow.js_messages?p_app_id=105&p_lang=en&p_version=20.1.0.00.13-11588761186919&p_builder=Yget_file_url p_url=>/i201/libraries/apex/storage.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/storage.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/navigation.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/navigation.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/event.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/event.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/server.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/server.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/page.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/page.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/region.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/region.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/item.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/item.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/apex_5_0.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/apex_5_0.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/widget.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/widget.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/widget.util.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/widget.util.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/clipboard.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/clipboard.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/dynamic_actions_core.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/dynamic_actions_core.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/dynamic_actions.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/dynamic_actions.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/session.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/session.js?v=20.1.0.00.13is_desktop_ui p_application_id=>105,p_page_id=>13,p_security_group_id=>150732114682318709get_ui_type p_application_id=>105,p_page_id=>13,p_security_group_id=>150732114682318709get_page_info p_application_id=>105,p_page_id=>13,p_security_group_id=>150732114682318709... ui type name=DESKTOPget_file_url p_url=>/i201/libraries/jquery-ui/1.12.1/jquery-ui-apex.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/jquery-ui/1.12.1/jquery-ui-apex.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/actions.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/actions.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/hammer/2.0.8/hammer-2.0.8.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/hammer/2.0.8/hammer-2.0.8.js?v=20.1.0.00.13add_requirejs_define p_module=>hammerjs,p_js_expression=>Hammerget_file_url p_url=>/i201/libraries/apex/widget.checkboxAndRadio.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/widget.checkboxAndRadio.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/widget.datepicker.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/widget.datepicker.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/widget.popupLov.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/widget.popupLov.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/widget.selectList.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/widget.selectList.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/widget.textarea.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/widget.textarea.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/widget.yesNo.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/widget.yesNo.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/widget.menu.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/widget.menu.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/widget.popup.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/widget.popup.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/widget.toggleCore.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/widget.toggleCore.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/widget.collapsible.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/widget.collapsible.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/widget.starRating.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/widget.starRating.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/tooltipManager.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/tooltipManager.js?v=20.1.0.00.13get_file_url p_url=>/i201/libraries/apex/theme.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/theme.js?v=20.1.0.00.13handle_common_placeholders p_placeholder=>#RTL_CLASS#handle_common_placeholders p_placeholder=>#TEXT_DIRECTION#handle_common_placeholders p_placeholder=>#TITLE#handle_common_placeholders p_placeholder=>#APEX_CSS#handle_common_placeholders p_placeholder=>#THEME_CSS#set_g_cached_theme p_theme_id=>42,p_application_id=>105,p_security_group_id=>150732114682318709get_file_url p_url=>/i201/libraries/font-apex/2.1/css/font-apex.min.css?v=20.1.0.00.13get_file_url p_url=>/i201/themes/theme_42/1.5/css/Core.css?v=20.1.0.00.13handle_common_placeholders p_placeholder=>#TEMPLATE_CSS#handle_common_placeholders p_placeholder=>#THEME_STYLE_CSS#fetch_value_by_id p_item_id=>42get_file_url p_url=>/i201/themes/theme_42/1.5/css/Vita.css?v=20.1.0.00.13handle_common_placeholders p_placeholder=>#APPLICATION_CSS#get_file_url p_url=>/i201/pkgapp_ui/css/5.0.css?v=20.1.0.00.13handle_common_placeholders p_placeholder=>#PAGE_CSS#handle_common_placeholders p_placeholder=>#FAVICONS#handle_common_placeholders p_placeholder=>#PAGE_CSS_CLASSES#set_g_cached_theme p_theme_id=>42,p_application_id=>105,p_security_group_id=>150732114682318709fetch_value_by_id p_item_id=>42set_g_cached_theme p_theme_id=>42,p_application_id=>105,p_security_group_id=>150732114682318709handle_common_placeholders p_placeholder=>#TEXT_DIRECTION#handle_common_placeholders p_placeholder=>#ONLOAD#handle_common_placeholders p_placeholder=>#FORM_OPEN#Rendering form open tag and internal valuesis_jqm_ui p_application_id=>105,p_page_id=>13,p_security_group_id=>150732114682318709get_ui_type p_application_id=>105,p_page_id=>13,p_security_group_id=>150732114682318709get_page_info p_application_id=>105,p_page_id=>13,p_security_group_id=>150732114682318709... ui type name=DESKTOPget_screen_reader_modeget_high_contrast_modeperform p_process_point=>AFTER_ERROR_HEADERProcesses - point: AFTER_ERROR_HEADERhandle_common_placeholders p_placeholder=>#REGION_POSITION_01#handle_common_placeholders p_placeholder=>#SUCCESS_MESSAGE#handle_common_placeholders p_placeholder=>#NOTIFICATION_MESSAGE#handle_common_placeholders p_placeholder=>#GLOBAL_NOTIFICATION#handle_common_placeholders p_placeholder=>#REGION_POSITION_02#perform p_process_point=>BEFORE_ERROR_FOOTERProcesses - point: BEFORE_ERROR_FOOTERemit_footerShow page footerShow page tempate footerhandle_common_placeholders p_placeholder=>#FORM_CLOSE#Rendering form close tag and page checksumhandle_common_placeholders p_placeholder=>#DEVELOPER_TOOLBAR#get_builder_session_id: builder session=17139727710672get_builder_preference p_name=>WINDOW_MGMT_MODEget_url_to_current_pageprepare_url p_url=>f?p=105:13:7150210842260:::::,p_url_charset=>,p_checksum_type=>,p_save_session_state_yn=>N,p_triggering_element=>this,p_dialog=>null,p_rejoin_public_only=>false,p_plain_url=>falseget_page_info p_application_id=>105,p_page_id=>13,p_security_group_id=>150732114682318709rejoin_existing_sessions c_platform_rejoin_sessions=>P,p_app_id=>105,p_app_browser_frame=>D,p_app_rejoin_existing_sessions=>P,p_page_info.rejoin_existing_sessions=>url_checksum p_string=>,p_checksum_level=>3,p_bookmark_checksum_function=>SH1set_session_id p_session_id=>7150210842260set_session_id p_session_id=>7150210842260... computed checksum=""get_file_url p_url=>/i201/libraries/apex/widget.menu.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/widget.menu.js?v=20.1.0.00.13get_file_url p_url=>/i201/apex_ui/js/devToolbar.js?v=20.1.0.00.13Load JavaScript file=/i201/apex_ui/js/devToolbar.js?v=20.1.0.00.13handle_common_placeholders p_placeholder=>#APEX_JAVASCRIPT#handle_common_placeholders p_placeholder=>#GENERATED_CSS#handle_common_placeholders p_placeholder=>#THEME_JAVASCRIPT#set_g_cached_theme p_theme_id=>42,p_application_id=>105,p_security_group_id=>150732114682318709get_file_url p_url=>/i201/libraries/apex/widget.stickyWidget.js?v=20.1.0.00.13Load JavaScript file=/i201/libraries/apex/widget.stickyWidget.js?v=20.1.0.00.13get_file_url p_url=>/i201/themes/theme_42/1.5/js/theme42.js?v=20.1.0.00.13Load JavaScript file=/i201/themes/theme_42/1.5/js/theme42.js?v=20.1.0.00.13handle_common_placeholders p_placeholder=>#TEMPLATE_JAVASCRIPT#handle_common_placeholders p_placeholder=>#APPLICATION_JAVASCRIPT#handle_common_placeholders p_placeholder=>#PAGE_JAVASCRIPT#handle_common_placeholders p_placeholder=>#GENERATED_JAVASCRIPT#get_workspace(150732114682318709): reusing g_workspaceemit_generated_javascriptemit_linksis_jqm_ui p_application_id=>105,p_page_id=>13,p_security_group_id=>150732114682318709get_ui_type p_application_id=>105,p_page_id=>13,p_security_group_id=>150732114682318709get_page_info p_application_id=>105,p_page_id=>13,p_security_group_id=>150732114682318709... ui type name=DESKTOPservice "iis.ufa.transneft.ru" is already active. No need to switch.teardown g_db_session_cleanup_has_run=>false,g_db_session_cleanup_code=>close_cached_cursorsclear_contextdelete_temp_request_files g_temp_request_files.count=>0Session Statisticsconsistent gets               :         125execute count                 :         851opened cursors current        :           0parse count (total)           :       1,256physical reads                :          22redo size                     :     878,004sorts (disk)                  :           0sorts (memory)                :           8Memory Usage (total + top 20) :   3,711,776WWV_FLOW_META_DATA            :     589,640WWV_FLOW_API                  :     483,168WWV_RENDER_REPORT3            :     330,480WWV_FLOW                      :     318,280WWV_FLOW_INTERACTIVE_GRID     :     272,056WWV_FLOW_DISP_PAGE_PLUGS      :     217,864WWV_FLOW_META_DATA            :     206,168WWV_FLOW_IR_RENDER            :     185,256WWV_FLOW_IR                   :     122,152WWV_FLOW_TEMPLATES_UTIL       :     113,272REGIME.ALLENERGO              :     104,808WWV_FLOW_UTILITIES            :     102,736BUDGET.BUDZ                   :      97,144WWV_FLOW_WORKSHEET_API        :      88,928WWV_FLOW_DML                  :      88,048WWV_FLOW_SESSION              :      84,000WWV_FLOW_SECURITY             :      80,560WWV_FLOW_SESSION_STATE        :      78,160WWV_FLOW_FND_USER_INT         :      77,416REGIME.RP                     :      71,640reset_globalsEnd Page Processing
  • AndyH
    AndyH Member Posts: 619 Gold Badge
    edited July 2020

    Quick thought, given your location does the filename include language-specific characters? If so, does it work with non-language specific characters? e.g. does the filename 'a.txt' work?

  • zagirov
    zagirov Member Posts: 48 Blue Ribbon
    edited July 2020

    no "sss.txt" it doesn't work either

  • AndyH
    AndyH Member Posts: 619 Gold Badge
    edited July 2020

    Sorry, no more ideas here.

    There was once a bug with the Data Upload in APEX 5 where it would create ORA-01403 if you chose to use APEX_APPLICATION_TEMP_FILES instead of the deprecated WWV_FLOW_FILES but that must have been fixed many releases ago and I don't think that you are using Data Upload anyway.

    Actually, having looked again at your debug I don't think that this is files related - the debug seems to show APEX looking through the page items in the JSON for submitting but failing to find your P13_FILE as a page item?

  • zagirov
    zagirov Member Posts: 48 Blue Ribbon
    edited July 2020

    The sad thing is that when I just want to add a static file to any of my applications in Application Builder, I get the same error.

    listing3.PNG

    CGI: PATH_INFO = /wwv_flow.acceptPOST http://***.corp/ordsREMOTE_ADDR=172.16.10.123REMOTE_USER=APEX_PUBLIC_USERAPEX_LISTENER_VERSION=19.4.6.r1421859REFERER=http://host/ords/f?p=4000:271:15276221239664:::271&p_dialog_cs=64fTWNsZ-b0XJY5Eg650NB6Ddm5XO3voCSrxX1AbyjrLKhkcuq9p17nf2M2PEDuCsbCnopKb38XoBPenpUu99gHTTP_COOKIE=SESSIONID=13096029251463; HASHEDSESSIONID=172.16.10.123APEX Version=20.1.0.00.13Patch Version=2020.06.25SID=1310USER=APEX_PUBLIC_USERINSTANCE=1Error: Error processing request.- additional_info: Contact your application administrator.- display_location: ON_ERROR_PAGE- is_internal_error: true- is_common_runtime_error: false- apex_error_code: APEX.UNHANDLED_ERROR- ora_sqlcode: 100- ora_sqlerrm: ORA-01403: no data foundORA-06512: at "APEX_200100.WWV_FLOW", line 1362- error_backtrace: ORA-06512: at "APEX_200100.WWV_FLOW", line 1362ORA-06512: at "APEX_200100.WWV_FLOW", line 3870- component: APEX_APPLICATION_PAGES Upload Static Application File(s) (4000000000271)

    @joelkallman-Oracle

    https://community.oracle.com/people/Pierre%20Yotti

    https://community.oracle.com/people/Hilary+Farrell-Oracle

    How to get around this situation?

  • zagirov
    zagirov Member Posts: 48 Blue Ribbon
    edited July 2020 Accepted Answer

    "And the casket just opened"

    The problem was an incorrectly configured ORDS. This parameter is in default.xml

    <entry key = "owa.docTable"> ttt.wwdoc_document </entry>

    It is directly intended for "mod_plsql schemas" and conflicts with APEX..

Sign In or Register to comment.