8 Replies Latest reply: Aug 12, 2014 1:36 PM by gerhard2001 RSS

    APEX upgrade displaying blank page

    aparm

      Hi there,

      We have upgraded our database and Apex to11g and 4.2.5 respectively, and we have broken Apex, it works using the gateway, but if we try and acces it through our web server, we just get a blank page and I can see the message 'apex undefined' in firebug, I copied the new new images to the web server replacing the old ones, nothing else has changed should work, is there anything more that we need to do on the web server to get it to work? Here is our DAD file

       

      <Location /pls/apex>
      Order deny,allow
      PlsqlDocumentPath docs
      AllowOverride None
      PlsqlDocumentProcedure wwv_flow_file_mgr.process_download
      PlsqlDatabaseConnectString BIU01:1521:DB11G ServiceNameFormat
      PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
      PlsqlAuthenticationMode Basic
      SetHandler pls_handler
      PlsqlDocumentTablename wwv_flow_file_objects$
      PlsqlDatabaseUsername APEX_HTTP_USER
      PlsqlDefaultPage apex
      PlsqlDatabasePassword password
      PlsqlRequestValidationFunction wwv_flow_epg_include_modules.authorize
      Allow from all
      </Location>

      Alias /i/ "D:\OracleHTTP\APEX_IMAGES/"

       

      Thanks

        • 1. Re: APEX upgrade displaying black change
          aparm

          This is an excerpt from the apache error log

           

          [Sun Aug 10 13:03:35 2014] [error] [client 192.168.63.246] [ecid: 1407672215:10.148.168.65:16888:13524:28,0] File does not exist: d:/oraclehttp/apex_images/themes/theme_13/theme_3_1.css

          [Sun Aug 10 13:03:35 2014] [error] [client 192.168.63.246] [ecid: 1407672215:10.148.168.65:16888:13680:32,0] File does not exist: d:/oraclehttp/apex_images/css/apex.min.css

          [Sun Aug 10 13:03:36 2014] [error] [client 192.168.63.246] [ecid: 1407672216:10.148.168.65:16888:13524:29,0] File does not exist: d:/oraclehttp/apex_images/css/apex_ie.min.css

          [Sun Aug 10 13:03:36 2014] [error] [client 192.168.63.246] [ecid: 1407672216:10.148.168.65:16888:13680:33,0] File does not exist: d:/oraclehttp/apex_images/libraries/jquery-ui/1.8.22/themes/base/jquery-ui.min.css

          [Sun Aug 10 13:03:36 2014] [error] [client 192.168.63.246] [ecid: 1407672216:10.148.168.65:16888:17196:29,0] File does not exist: d:/oraclehttp/apex_images/libraries/apex/minified/legacy.min.js

          [Sun Aug 10 13:03:36 2014] [error] [client 192.168.63.246] [ecid: 1407672216:10.148.168.65:16888:17196:30,0] File does not exist: d:/oraclehttp/apex_images/libraries/apex/minified/desktop_all.min.js

          [Sun Aug 10 13:03:36 2014] [error] [client 192.168.63.246] [ecid: 1407672216:10.148.168.65:16888:13524:30,0] File does not exist: d:/oraclehttp/apex_images/kingslogo.gif

          [Sun Aug 10 13:03:36 2014] [error] [client 192.168.63.246] [ecid: 1407672216:10.148.168.65:16888:13680:34,0] File does not exist: d:/oraclehttp/apache/apache/htdocs/favicon.ico

          [Sun Aug 10 13:04:02 2014] [error] [client 10.148.152.193] [ecid: 1407672242:10.148.168.65:16888:17012:34,0] File does not exist: d:/oraclehttp/apex_images/css/apex.min.css

          [Sun Aug 10 13:04:02 2014] [error] [client 10.148.152.193] [ecid: 1407672242:10.148.168.65:16888:18216:35,0] File does not exist: d:/oraclehttp/apex_images/libraries/jquery-ui/1.8.22/themes/base/jquery-ui.min.css

          [Sun Aug 10 13:04:02 2014] [error] [client 10.148.152.193] [ecid: 1407672242:10.148.168.65:16888:17892:38,0] File does not exist: d:/oraclehttp/apex_images/css/apex_builder_ie.min.css

          [Sun Aug 10 13:04:02 2014] [error] [client 10.148.152.193] [ecid: 1407672242:10.148.168.65:16888:18156:34,0] File does not exist: d:/oraclehttp/apex_images/css/apex_ui.min.css

          [Sun Aug 10 13:04:02 2014] [error] [client 10.148.152.193] [ecid: 1407672242:10.148.168.65:16888:17016:35,0] File does not exist: d:/oraclehttp/apex_images/css/apex_builder.min.css

          [Sun Aug 10 13:04:02 2014] [error] [client 10.148.152.193] [ecid: 1407672242:10.148.168.65:16888:14640:30,0] File does not exist: d:/oraclehttp/apex_images/css/apex_ie.min.css

          [Sun Aug 10 13:04:02 2014] [error] [client 10.148.152.193] [ecid: 1407672242:10.148.168.65:16888:17012:35,0] File does not exist: d:/oraclehttp/apex_images/css/apex_builder_ie7.min.css

          [Sun Aug 10 13:04:02 2014] [error] [client 10.148.152.193] [ecid: 1407672242:10.148.168.65:16888:18216:36,0] File does not exist: d:/oraclehttp/apex_images/libraries/apex/minified/desktop_all.min.js

          [Sun Aug 10 13:04:02 2014] [error] [client 10.148.152.193] [ecid: 1407672242:10.148.168.65:16888:14640:31,0] File does not exist: d:/oraclehttp/apex_images/libraries/apex/minified/widget.textarea.min.js

          [Sun Aug 10 13:04:02 2014] [error] [client 10.148.152.193] [ecid: 1407672242:10.148.168.65:16888:18156:35,0] File does not exist: d:/oraclehttp/apex_images/libraries/apex/minified/legacy.min.js

          [Sun Aug 10 13:04:02 2014] [error] [client 10.148.152.193] [ecid: 1407672242:10.148.168.65:16888:14640:32,0] File does not exist: d:/oraclehttp/apex_images/libraries/apex/minified/builder.min.js

          [Sun Aug 10 13:04:02 2014] [error] [client 10.148.152.193] [ecid: 1407672242:10.148.168.65:16888:14640:33,0] File does not exist: d:/oraclehttp/apex_images/apex_ui/apexlogo.png

          [Sun Aug 10 13:04:02 2014] [error] [client 10.148.152.193] [ecid: 1407672242:10.148.168.65:16888:14640:34,0] File does not exist: d:/oraclehttp/apex_images/f_spacer.gif

           

          some of these references exist and some do not e.g. there is no libraries folder under images, there was in version 4.0, any ideas?

          • 2. Re: APEX upgrade displaying black change
            Earl Lewis

            I assume the application builder is broken as well as your applications. Or is it just your apps?

             

            It's obvious from the error log that the web server can't find the files being requested by the client. Did you follow the step-by-step instructions in the upgrade documentation re: handling of the images?

             

            http://docs.oracle.com/cd/E37097_01/doc/install.42/e35123/otn_install.htm#HTMIG424

             

            Earl

            • 3. Re: APEX upgrade displaying black change
              aparm

              The application builder is broken and the apps, it was working fine with version 4, I have followed the documents, all I needed to do was replace the old images folder with the new one, and that is what I ahve done, so i am puzzled, why is it looking for js scripts and images that don't exists, like the libraries folder?

              • 4. Re: APEX upgrade displaying black change
                jariola

                Hi,

                 

                Check that OS user who run HTTP server have read permission to all image folder files and subfolders

                 

                Regards,
                Jari

                • 5. Re: APEX upgrade displaying black change
                  aparm

                  How do I find the OS user who runs HTTP server, the apache server appears to be running as a service under the windows account., anyway I replaced the contents of the APEX_IMAGES folder and not the folder itself, so it should maintain the same permissions, shouldn't it? Why does apex appear to be looking for files in folders in the APEX_IMAGES folder that do not exist, can anybody explain?

                  • 6. Re: APEX upgrade displaying blank page
                    jariola

                    aparm wrote:

                     

                    Why does apex appear to be looking for files in folders in the APEX_IMAGES folder that do not exist, can anybody explain?

                    Hi,

                     

                    Those files are part of builder / page templates. There is nothing wrong that APEX try find those.

                     

                    Problem is that your install do not contain those files or HTTP server do not have access to serve those.

                    That's why you get errors to Apache log.

                     

                    Unfortunately, I do not know anything about HTTP server config under Windows

                     

                    Regards,

                    Jari

                    • 7. Re: APEX upgrade displaying blank page
                      eomolina

                      Hi aparm, normally when you get a blank page after an upgrade is because some step of the procedure went wrong, must of the times the problem is that images directory content was not correctly copied to the appropiate place.

                       

                      In your case, if the configuration posted is correct you must copy the /images directory content (and all subdirectories) to D:\OracleHTTP\APEX_IMAGES/

                       

                      If you install Database 11g Http server the Apex images have to be pocied to ORACLE_HTTPSERVER_HOME\ohs\images

                       

                      The command to copy files im Windows is:

                       

                      xcopy /E /I ORACLE_HOME\apex\images ORACLE_HTTPSERVER_HOME\ohs\images

                       

                      where ORACLE_HOME\apex\images is the directory where you unzip Apex,and ORACLE_HTTPSERVER_HOME\ohs\images is the images directory of HTTP Server.

                       

                      To be sure, you can try to obtain te content of apex_version.txt: on your browser write http://server:port/i/apex_version.txt

                       

                      You must get the actual Apex version installed.

                      • 8. Re: APEX upgrade displaying blank page
                        gerhard2001

                        It looks like APEX is not finding its images.

                         

                        That happens sometimes, when you upgrading APEX.

                         

                        You should go as OS user oracle to your apex directory, connect there ' sqlplus / sysdba'

                        and execute the command SQL> @apxldimg.sql pass to your image dirctory

                         

                        Gerhard