2 Replies Latest reply on Jan 1, 2016 11:44 PM by teedub

    Blank Workspace Login Page 4550:1 after upgrade to apex v5

    teedub

      Using the ords listener(s) standalone.

      redhat linux  2.6.32-279.el6.x86_64

      DB version 11.2.0.4

      apex versions 5.0.2 and 5.0.3

      ords versions 3.0.3.351.13.24 3.0.2.294.08.40 2.0.10.289.08.09

       

      Database and listeners are all on the same server.

       

      Actually the page is not completely blank. Only the login details are missing (ie somewhere to enter workspace and user and password). Paging down I see "Getting Started" and "More Information" and so on, and these links work fine, but the top of the page is blank. 

       

      If I point to an existing application, that works fine; it seems only application 4550 is causing me grief. But I really need to log in and get to see the developer toolbar etc. And cannot do so without having somewhere to do so.

       

      I upgraded from a working 4.1 to 5.0.2; tried the 3 listener versions all with the same result.

      I then patched to 5.0.3 but am still getting the same result.

      So currently http://localhost:8088/i/apex_version.txt gives me Application Express Version:  5.0.3

       

       

      In firebug I see ...

       

      <div id="F4550_P1_USERNAME_CONTAINER" class="a-Form-fieldContainer icon-login-username ">

      <div class="a-Form-inputContainer">

      <label id="F4550_P1_USERNAME_LABEL" class="a-Icon a-Login-iconLabel" for="F4550_P1_USERNAME">Username</label>

      <input type="hidden" value="30251012844458645" name="p_arg_names">

      <input id="F4550_P1_USERNAME" class="text_field" type="text" maxlength="2000" size="40" value="TMW" required="" placeholder="Username" name="p_t03">

      <span class="a-Login-iconValidation a-Icon icon-check"></span>

      </div>

      </div>

       

      and the input type=hidden line is greyed out so maybe this is where the issue lies.

       

      There seems to have been an issue with 4.2 similar to the one that I see. But the workaround for this does not work for me (ie specifying the page number ...4550:1).

       

      I'm somewhat perplexed. Has anyone any thoughts on whether this is a problem with apex or with the listener or with me? And where I should look?

       

      cheers

      ~t

        • 1. Re: Blank Workspace Login Page 4550:1 after upgrade to apex v5
          Kiran Pawar

          Hi teedub,

          teedub wrote:

           

          Using the ords listener(s) standalone.

          redhat linux  2.6.32-279.el6.x86_64

          DB version 11.2.0.4

          apex versions 5.0.2 and 5.0.3

          ords versions 3.0.3.351.13.24 3.0.2.294.08.40 2.0.10.289.08.09

          Database and listeners are all on the same server.

               Thanks for providing detailed environment information.

          In firebug I see ...

          <div id="F4550_P1_USERNAME_CONTAINER" class="a-Form-fieldContainer icon-login-username ">

          ...

          </div>

          and the input type=hidden line is greyed out so maybe this is where the issue lies.

          There seems to have been an issue with 4.2 similar to the one that I see. But the workaround for this does not work for me (ie specifying the page number ...4550:1).

          I'm somewhat perplexed. Has anyone any thoughts on whether this is a problem with apex or with the listener or with me? And where I should look?

               I don't think the problem is with "input type=hidden" or with specific page number (viz. 4550:1) in Oracle APEX either.

           

               For debugging this issue you are facing with ORDS:

           

               In addition to ORDS debugging, I would like you to use the Browser Development Tools/Firebug and check the "Console" tab when page is loaded to check whether there any JS errors after loading the page. Also check the "Network" tab to investigate whether there are 404 or other errors while loading images/js/css files.

           

          Regards,

          Kiran

          • 2. Re: Blank Workspace Login Page 4550:1 after upgrade to apex v5
            teedub

            Hi Kiran

             

            Thank you for your suggestions. Sorry about my delay in replying, new year got in the way.

             

            I neglected to include in my original email that I had tried logging and rummaging through firebug but couldn't find anything. But then again, I have no real idea on what I am looking for. In any case I have included the with-debugging 503 log below.

             

            How do I get rid of the tmw cookies? They are a hangover from the previous incantation. Possibly getting rid of them will help?

             

            And I can't see anything through firebug that looks awry.

             

            I start the standalone using nohup & and so I am sending you the tail of nohup.out. Is this all you required, or is the an additional logfile somewhere?

             

            In fact, I included the whole log as the startup section may be of some use.

             

            2016-01-02 07:06:57.113:INFO::main: Logging initialized @17259ms

            Jan 02, 2016 7:06:58 AM oracle.dbtools.standalone.StandaloneJetty setupDocRoot

            INFO: Disabling document root because the specified folder does not exist: /u01/ords.3.0.3.351.13.24_xe11g_8087/configs/ords/standalone/doc_root

            2016-01-02 07:07:06.046:INFO:oejs.Server:main: jetty-9.2.z-SNAPSHOT

            2016-01-02 07:07:07.776:INFO:/ords:main: INFO: Using configuration folder: /u01/ords.3.0.3.351.13.24_xe11g_8087/configs/ords

            2016-01-02 07:07:07.777:INFO:/ords:main: FINEST: |ApplicationContext [configurationFolder=/u01/ords.3.0.3.351.13.24_xe11g_8087/configs/ords, services=Application Scope]|

            Jan 02, 2016 7:07:08 AM oracle.dbtools.common.config.db.DatabasePools validatePool

            INFO: Validating pool: apex

            Jan 02, 2016 7:07:12 AM oracle.dbtools.common.config.db.DatabasePools validatePool

            INFO: Pool: apex is correctly configured

            Jan 02, 2016 7:07:12 AM oracle.dbtools.common.config.db.DatabasePools validatePool

            INFO: Validating pool: apex_al

            Jan 02, 2016 7:07:12 AM oracle.dbtools.common.config.db.DatabasePools validatePool

            INFO: Pool: apex_al is correctly configured

            Jan 02, 2016 7:07:12 AM oracle.dbtools.common.config.db.DatabasePools validatePool

            INFO: Validating pool: apex_pu

            Jan 02, 2016 7:07:12 AM oracle.dbtools.common.config.db.DatabasePools validatePool

            INFO: Pool: apex_pu is correctly configured

            Jan 02, 2016 7:07:12 AM oracle.dbtools.common.config.db.DatabasePools validatePool

            INFO: Validating pool: apex_rt

            Jan 02, 2016 7:07:12 AM oracle.dbtools.common.config.db.DatabasePools validatePool

            INFO: Pool: apex_rt is correctly configured

            config.dir

            2016-01-02 07:07:14.456:INFO:/ords:main: INFO: Oracle REST Data Services initialized|Oracle REST Data Services version : 3.0.3.351.13.24|Oracle REST Data Services server info: jetty/9.2.z-SNAPSHOT|

            2016-01-02 07:07:14.470:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@6a8bc5d9{/ords,null,AVAILABLE}

            2016-01-02 07:07:14.507:INFO:oejsh.ContextHandler:main: Started o.e.j.s.h.ContextHandler@48027886{/i,null,AVAILABLE}

            2016-01-02 07:07:14.712:INFO:oejs.ServerConnector:main: Started ServerConnector@1f91d41b{HTTP/1.1}{0.0.0.0:8087}

            2016-01-02 07:07:14.715:INFO:oejs.Server:main: Started @35001ms

            Jan 02, 2016 7:09:51 AM oracle.dbtools.common.config.db.DatabasePoolFactory createPool

            INFO: Configuration properties for: apex

            Jan 02, 2016 7:09:51 AM oracle.dbtools.common.config.db.DatabasePoolFactory listConfiguration

            INFO: cache.caching=false

            cache.directory=/tmp/apex/cache

            cache.duration=days

            cache.expiration=7

            cache.maxEntries=500

            cache.monitorInterval=60

            cache.procedureNameList=

            cache.type=lru

            db.hostname=localhost

            db.port=1521

            db.servicename=xe11g

            debug.debugger=true

            debug.printDebugToScreen=true

            error.keepErrorMessages=true

            error.maxEntries=100

            jdbc.DriverType=thin

            jdbc.InactivityTimeout=1800

            jdbc.InitialLimit=3

            jdbc.MaxConnectionReuseCount=1000

            jdbc.MaxLimit=10

            jdbc.MaxStatementsLimit=10

            jdbc.MinLimit=1

            jdbc.statementTimeout=900

            log.logging=true

            log.maxEntries=200

            misc.compress=

            misc.defaultPage=apex

            security.crypto.enc.password=******

            security.crypto.mac.password=******

            security.disableDefaultExclusionList=false

            security.maxEntries=2000

            security.verifySSL=false

            db.password=******

            db.username=APEX_PUBLIC_USER

             

            Jan 02, 2016 7:09:51 AM oracle.dbtools.common.config.db.ConfigurationValues log

            WARNING: *** jdbc.MaxLimit in configuration apex is using a value of 10, this setting may not be sized adequately for a production environment ***

            Jan 02, 2016 7:09:51 AM oracle.dbtools.common.config.db.ConfigurationValues log

            WARNING: *** jdbc.InitialLimit in configuration apex is using a value of 3, this setting may not be sized adequately for a production environment ***

            Jan 02, 2016 7:09:51 AM oracle.ucp.common.UniversalConnectionPoolBase initInactiveConnectionTimeoutTimer

            INFO: inactive connection timeout timer scheduled

            ==== Processing Request: ====

            GET /ords/

            ==== Headers in Request ====

            Accept-Encoding: gzip, deflate

            Accept-Language: en-US,en;q=0.5

            User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:10.0.5) Gecko/20120601 Firefox/10.0.5

            Cookie: ORA_WWV_APP_550=ORA_WWV-SYS7SVp9gZZKGJIA1-7XbZzD; LOGIN_USERNAME_COOKIE=tmw; ORA_WWV_APP_100=ORA_WWV-UUIMw8aSpuYMiRnj8--XFNCR; ORA_WWV_REMEMBER_UN=TMW:tmw; ORA_WWV_USER_63423983649900=ORA_WWV-ksFkks1f8X9GEJl-G2PaXMHT

            Connection: keep-alive

            Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8

            Host: localhost:8087

            ==== Cookies in Request ====

            ORA_WWV_APP_550 =  ORA_WWV-SYS7SVp9gZZKGJIA1-7XbZzD

            LOGIN_USERNAME_COOKIE =  tmw

            ORA_WWV_APP_100 =  ORA_WWV-UUIMw8aSpuYMiRnj8--XFNCR

            ORA_WWV_REMEMBER_UN =  TMW:tmw

            ORA_WWV_USER_63423983649900 =  ORA_WWV-ksFkks1f8X9GEJl-G2PaXMHT

            Using default page: apex

            SID: 9

            isValidRequest(), procedure name: <apex>

            Validating: apex

            *** Total number of arguments: 1

            Parse: 0 ms

            -----

            begin

            apex;

            commit;

              end;

            *** Total number of arguments: 1

            Exec: 3083 ms

            Got results length: 0

            ==== Headers from Results ====

            Setting Content-Type (Content-Type): text/html; charset=utf-8

            Adding Cache-Control: no-store

            Adding Pragma: no-cache

            Adding Expires: Sun, 27 Jul 1997 13:00:00 GMT

            Adding Set-Cookie: ORA_WWV_USER_63423983649900=ORA_WWV-leW_Ilf8vmBGgOAn9LhIC87A; path=/ords; HttpOnly

            Setting Status: 302

            Redirecting to: http://localhost:8087/ords/f?p=4550:1:8599928089409:::::

            ==== Request Processed ====

            ==== Processing Request: ====

            GET /ords/f?p=4550:1:8599928089409:::::

            ==== Headers in Request ====

            Accept-Encoding: gzip, deflate

            Accept-Language: en-US,en;q=0.5

            User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:10.0.5) Gecko/20120601 Firefox/10.0.5

            Cookie: ORA_WWV_APP_550=ORA_WWV-SYS7SVp9gZZKGJIA1-7XbZzD; LOGIN_USERNAME_COOKIE=tmw; ORA_WWV_APP_100=ORA_WWV-UUIMw8aSpuYMiRnj8--XFNCR; ORA_WWV_REMEMBER_UN=TMW:tmw; ORA_WWV_USER_63423983649900=ORA_WWV-leW_Ilf8vmBGgOAn9LhIC87A

            Connection: keep-alive

            Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8

            Host: localhost:8087

            ==== Cookies in Request ====

            ORA_WWV_APP_550 =  ORA_WWV-SYS7SVp9gZZKGJIA1-7XbZzD

            LOGIN_USERNAME_COOKIE =  tmw

            ORA_WWV_APP_100 =  ORA_WWV-UUIMw8aSpuYMiRnj8--XFNCR

            ORA_WWV_REMEMBER_UN =  TMW:tmw

            ORA_WWV_USER_63423983649900 =  ORA_WWV-leW_Ilf8vmBGgOAn9LhIC87A

            SID: 9

            isValidRequest(), procedure name: <f>

            Validating: f

            *** Total number of arguments: 17

            Parse: 0 ms

            -----

            begin

            f(p=>?);

            commit;

              end;

            *** Total number of arguments: 17

            {p=4550:1:8599928089409:::::}

            p= 4550:1:8599928089409:::::

            Exec: 4357 ms

            Got results length: 19801

            ==== Headers from Results ====

            Setting Content-Type (Content-Type): text/html; charset=utf-8

            Adding Cache-Control: no-store

            Adding Pragma: no-cache

            Adding Expires: Sun, 27 Jul 1997 13:00:00 GMT

            Adding X-Frame-Options: DENY

            ==== Request Processed ====