5 Replies Latest reply on Nov 10, 2016 6:14 PM by Gbenga Ajakaye

    Static Files Do Not Display After Upgrade from APEX 4.2 to 5.0

    Erick Diaz

      Hi,

       

      Database 11.2.0.4.0

      ORDS 2.0.10.289.08.09

      APEX 5.0.4.00.12

      WebLogic 10.3.6.0

       

      I just finished upgrading two databases on a same server (DEV and UAT) from APEX 4.2 to APEX 5.0 and configuring ORDS 2.0. Both environments are displaying the APEX images correctly but, one of them (UAT) is not loading static files. I can see the files (or images) on Shared Components but they are failing to load when running the application. E.g.

       

      This works (DEV):

      http://<server_name>:9004/ords/apexdev/ws_dev1/r/224/files/static/v2Y/PA_Logo.jpg

       

      This doesn’t work (UAT):

      http://<server_name>:9004/ords/apexuat/ws_uat1/r/224/files/static/v2Y/PA_Logo.jpg

       

      I enabled the ORDS debug tracking and this is what I get:

       

      404 - Not Found
      Request Path passes syntax validation
      Mapping request to database pool: PoolMap [_failed=false, _lastUpdate=1478709621845, _pattern=/apexuat/, _poolName=UAT, _regex=null, _type=BASE_PATH, _workspaceIdentifier=null, _serviceName=null]
      Applied database connection info
      Attempting to process with PL/SQL Gateway
      Not processed as PL/SQL Gateway request
      Attempting to process as a RESTful Service
      Determining if request can be dispatched as a Tenanted RESTful Service
      Request path has one path segment, continuing processing
      No Tenant Principal established yet, continuing processing
      APEX_LISTENER pool exists, continuing processing
      No matching tenant found for: ws_uat1, cannot dispatch
      No candidate found for: GET ws_uat1/r/224/files/static/v2Y/PA_Logo.jpg in context: http://orawebt:9004/ords/apexuat/
      WebException [statusCode=404]
        at oracle.dbtools.rt.web.WebException.webException(WebException.java:343)
        at oracle.dbtools.rt.web.WebException.notFound(WebException.java:297)
        at oracle.dbtools.rt.web.RequestDispatchers.dispatch(RequestDispatchers.java:78)
        at oracle.dbtools.rt.web.ETags.checkPrecondition(ETags.java:53)
        at oracle.dbtools.rt.web.HttpEndpointBase.restfulServices(HttpEndpointBase.java:426)
        at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:164)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
        at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
        at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
        at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:184)
        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3750)
        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)
        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
        at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
        at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)
        at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
        at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1499)
        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:263)
        at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
      

       

      Everything went well during both APEX upgrade or ORDS configuration (no errors). Also, as mentioned in other threads, I already executed @apex_rest_config.sql on both databases.

       

      Any ideas what may be happening? Please let me know if additional information is needed.

       

      Thank you,

       

      Erick