APEX Static Application / Workspace Files Fail after Upgrade to ORDS - REST Services Work
(Doc ID 2444096.1)
Last updated on FEBRUARY 09, 2023
Applies to:
Oracle Application Express (APEX) - Version 5.1 and laterOracle REST Data Services - Version 18.1.1 to 18.1.1
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Workspace and application static files are failing after upgrading APEX to 18.1, and ORDS to 18.1.1.
Prior to the upgrade (APEX 5.1 / ORDS 3.0.12) the static files were running as expected.
Looking at the access.log for the installation WLS, the requests show 404 not found:
<IPADDRESS> - - [28/Aug/2018:13:57:16 -0700] "GET /apex/f?p=112:1:18596450898142::::: HTTP/1.1" 200 11504
<IPADDRESS> - - [28/Aug/2018:13:57:16 -0700] "GET /i/libraries/apex/minified/widget.treeView.min.js?v=18.1.0.00.45 HTTP/1.1" 200 66465
<IPADDRESS> - - [28/Aug/2018:13:57:16 -0700] "GET /apex/services/r/112/files/static/v3/app-icon.css?version=Release 1.0 HTTP/1.1" 404 378882
<IPADDRESS> - - [28/Aug/2018:13:57:28 -0700] "GET /apex/f?p=4000:9:12799533089038::NO::FB_FLOW_ID,FB_FLOW_PAGE_ID:112,1 HTTP/1.1" 200 47843
<IPADDRESS> - - [28/Aug/2018:13:57:32 -0700] "GET /apex/f?p=4000:40:12799533089038::NO::: HTTP/1.1" 200 40584
<IPADDRESS> - - [28/Aug/2018:13:57:36 -0700] "GET /apex/f?p=4000:9:12799533089038::NO::FB_FLOW_ID,FB_FLOW_PAGE_ID:112,1 HTTP/1.1" 200 47843
<IPADDRESS> - - [28/Aug/2018:13:57:37 -0700] "GET /apex/f?p=4000:312:12799533089038::NO:RP:: HTTP/1.1" 200 96223
<IPADDRESS>- - [28/Aug/2018:13:57:41 -0700] "GET /apex/f?p=4000:1500:12799533089038::NO::P1500_SHOW: HTTP/1.1" 200 64517
<IPADDRESS> - - [28/Aug/2018:13:57:41 -0700] "GET /apex/services/r/112/files/static/v3/app-icon.svg HTTP/1.1" 404 378882
Other ORDS services run successfully, and can also be seen in the access.log:
<IPADDRESS> - - [28/Aug/2018:13:57:05 -0700] "GET /apex/services/restapi/health_check HTTP/1.0" 200 6
<IPADDRESS> - - [28/Aug/2018:13:57:07 -0700] "GET /apex/services/restapi/health_check HTTP/1.0" 200 6
Other information
- REST services run successfully, indicating that the REST users are configured correctly.
- Running the ORDS validation did not resolve the problem:
java -jar ords.war validate --database apex
Changes
Upgraded ORDS and / or APEX or performed some type of database migration, such as a database refresh.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |