0 Replies Latest reply: Nov 7, 2013 10:53 AM by user2366205 Branched from an earlier discussion. RSS

    Re: Apex Listener 2.0 and Websphere 8.0

    user2366205

      Did you have any success getting it to work on Websphere 8?

       

      I have the following envorinment:

       

      Websphere: 8.0.5

      JRE: IBM J9 VM (build 2.6, JRE 1.6.0 AIX ppc64-64 Compressed References 20130702_154829 (JIT enabled, AOT enabled)

      APEX: 4.2.2.00.11

      APEX Listener: 2.0.5.287.04.27

       

      The APEX Listener is deployed under the context /zast. APEX is configured to use the context /itest for images, so an application itest.war is deployed under this context which contains all the images etc. in its root directory.

       

      And here is the configuration (i have replaced critical information with ###):

      defaults.xml

      <?xml version="1.0" encoding="UTF-8" standalone="no"?>

      <!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">

      <properties>

      <comment>Saved on Mon Nov 04 11:47:04 CEST 2013</comment>

      <entry key="debug.printDebugToScreen">true</entry>

      <entry key="security.disableDefaultExclusionList">false</entry>

      <entry key="db.password">###</entry>

      <entry key="cache.maxEntries">500</entry>

      <entry key="error.maxEntries">50</entry>

      <entry key="security.maxEntries">2000</entry>

      <entry key="cache.directory">/tmp/apex/cache</entry>

      <entry key="jdbc.DriverType">thin</entry>

      <entry key="log.maxEntries">50</entry>

      <entry key="db.hostname">testdbserver</entry>

      <entry key="jdbc.MaxConnectionReuseCount">1000</entry>

      <entry key="log.logging">true</entry>

      <entry key="jdbc.InitialLimit">3</entry>

      <entry key="jdbc.MaxLimit">10</entry>

      <entry key="cache.monitorInterval">60</entry>

      <entry key="cache.expiration">7</entry>

      <entry key="jdbc.statementTimeout">900</entry>

      <entry key="jdbc.MaxStatementsLimit">10</entry>

      <entry key="db.sid">ZAST</entry>

      <entry key="misc.defaultPage">apex</entry>

      <entry key="misc.compress"/>

      <entry key="jdbc.MinLimit">1</entry>

      <entry key="cache.type">lru</entry>

      <entry key="cache.caching">false</entry>

      <entry key="db.port">1521</entry>

      <entry key="error.keepErrorMessages">true</entry>

      <entry key="cache.procedureNameList"/>

      <entry key="cache.duration">days</entry>

      <entry key="jdbc.InactivityTimeout">1800</entry>

      <entry key="debug.debugger">true</entry>

      </properties>

       

       

       

      Every time i try to access /zast a white page is shown. The HTTP response status header says "Service Unavailable - 503".

       

      Here are some scenarios i have tested:

       

      Scenario 1Scenario 1
      URLhttp://testserver:10003/zast
      ResultA white page is shown and i won't get redirected to /f?p=4550. HTTP Status is 503.
      Debug
      [07.11.13 16:31:37:491 CET] 00000036 SystemOutO Request Path passes syntax validation
      [07.11.13 16:31:37:491 CET] 00000036 SystemOutO Mapping request to database pool: PoolMap [_poolName=apex, _regex=null, _workspaceIdentifier=null, _failed=false, _lastUpdate=-1, _template=null, _type=REGEX]
      [07.11.13 16:31:37:492 CET] 00000036 SystemOutO Applied database connection info
      [07.11.13 16:31:37:492 CET] 00000036 SystemOutO Attempting to process with PL/SQL Gateway
      [07.11.13 16:31:37:492 CET] 00000036 SystemOutO ==== Processing Request: ====
      [07.11.13 16:31:37:493 CET] 00000036 SystemOutO GET /zast/
      [07.11.13 16:31:37:493 CET] 00000036 SystemOutO ==== Headers in Request ====
      [07.11.13 16:31:37:493 CET] 00000036 SystemOutO Host: testserver:10003
      [07.11.13 16:31:37:493 CET] 00000036 SystemOutO User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:25.0) Gecko/20100101 Firefox/25.0
      [07.11.13 16:31:37:493 CET] 00000036 SystemOutO Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
      [07.11.13 16:31:37:493 CET] 00000036 SystemOutO Accept-Language: de-de,de;q=0.8,en-us;q=0.5,en;q=0.3
      [07.11.13 16:31:37:494 CET] 00000036 SystemOutO Accept-Encoding: gzip, deflate
      [07.11.13 16:31:37:494 CET] 00000036 SystemOutO DNT: 1
      [07.11.13 16:31:37:495 CET] 00000036 SystemOutO Cookie: ORA_WWV_USER_61924365747959=ORA_WWV-R2B7b3+htbFQw5wkAlz3X17i; sessionCode=788901199; WWV_CUSTOM-F_1644981216445723978_148=-1; TJE=; TE3=N0:C N1:E N2:E N3:C N4:C N5:C N6:C N7:C N8:C N9:C N10:C N11:C N12:C N13:C N14:C N15:C N16:C N17:C N18:C N19:C N20:C N21:C N22:C N23:C N24:C N25:C N26:C N27:C N28:C N29:C N30:C N31:C N32:C N33:C N34:C N35:C N36:C N37:C; LtpaToken2=HvC2dwbSoEwQdn/3/6g9L4g3h8a/wPFQjveJFMqbNklNXLgw1cIdk10I6xDRwDt2E5nhhw4m8rjbFcPBO632T7lwVYPDFrgIVkV9Vr6sxm6Jps0LiYPcRbX/k3t7oUS28FNZEuJlavPQ0Wr91zYl6wXXhKuZ24+1ADmmIDvbhPiT/4go4oiJwDyNha1okco+T2SDTGizm+ibi8sLgWXY76cTPboW81McUqqSSL5JHz5MJlkodLqFybrebw/TiD8FJ0qxkb4UXht0L0PSrdqkOj0pBwsmliXDhie4wRN61ewAl4HN2thYVzIg9QoZUgD9ADztuhNUVKF1r+pVu9f7XRs2N6fva5DqpqNm9uhrijE=
      [07.11.13 16:31:37:495 CET] 00000036 SystemOutO Connection: keep-alive
      [07.11.13 16:31:37:495 CET] 00000036 SystemOutO ==== Cookies in Request ====
      [07.11.13 16:31:37:495 CET] 00000036 SystemOutO ORA_WWV_USER_61924365747959 =  ORA_WWV-R2B7b3+htbFQw5wkAlz3X17i
      [07.11.13 16:31:37:495 CET] 00000036 SystemOutO sessionCode =  788901199
      [07.11.13 16:31:37:495 CET] 00000036 SystemOutO WWV_CUSTOM-F_1644981216445723978_148 =  -1
      [07.11.13 16:31:37:496 CET] 00000036 SystemOutO TJE =
      [07.11.13 16:31:37:496 CET] 00000036 SystemOutO TE3 =  N0:C N1:E N2:E N3:C N4:C N5:C N6:C N7:C N8:C N9:C N10:C N11:C N12:C N13:C N14:C N15:C N16:C N17:C N18:C N19:C N20:C N21:C N22:C N23:C N24:C N25:C N26:C N27:C N28:C N29:C N30:C N31:C N32:C N33:C N34:C N35:C N36:C N37:C
      [07.11.13 16:31:37:496 CET] 00000036 SystemOutO LtpaToken2 =  HvC2dwbSoEwQdn/3/6g9L4g3h8a/wPFQjveJFMqbNklNXLgw1cIdk10I6xDRwDt2E5nhhw4m8rjbFcPBO632T7lwVYPDFrgIVkV9Vr6sxm6Jps0LiYPcRbX/k3t7oUS28FNZEuJlavPQ0Wr91zYl6wXXhKuZ24+1ADmmIDvbhPiT/4go4oiJwDyNha1okco+T2SDTGizm+ibi8sLgWXY76cTPboW81McUqqSSL5JHz5MJlkodLqFybrebw/TiD8FJ0qxkb4UXht0L0PSrdqkOj0pBwsmliXDhie4wRN61ewAl4HN2thYVzIg9QoZUgD9ADztuhNUVKF1r+pVu9f7XRs2N6fva5DqpqNm9uhrijE=
      [07.11.13 16:31:37:496 CET] 00000036 SystemOutO Using default page: apex
      [07.11.13 16:31:37:506 CET] 00000036 SystemOutO isValidRequest(), procedure name: <apex>
      [07.11.13 16:31:37:506 CET] 00000036 SystemOutO Validating: apex
      [07.11.13 16:31:37:582 CET] 00000036 SystemOutO *** Total number of arguments: 1
      [07.11.13 16:31:37:589 CET] 00000036 SystemOutO SID: 682
      [07.11.13 16:31:37:590 CET] 00000036 SystemOutO Parse: 0 ms
      [07.11.13 16:31:37:590 CET] 00000036 SystemOutO -----

      begin

      apex;

      commit;

        end;

      [07.11.13 16:31:37:590 CET] 00000036 SystemOutO *** Total number of arguments: 1
      [07.11.13 16:31:37:630 CET] 00000036 SystemOutO Exec: 40 ms
      [07.11.13 16:31:37:637 CET] 00000036 SystemOutO Got results length: 0
      [07.11.13 16:31:37:637 CET] 00000036 SystemOutO ==== Headers from Results ====
      [07.11.13 16:31:37:637 CET] 00000036 SystemOutO Setting Content-Type (Content-type): text/html; charset=UTF-8
      [07.11.13 16:31:37:638 CET] 00000036 SystemOutO Adding cache-control: no-cache, no-store, max-age=0, must-revalidate
      [07.11.13 16:31:37:638 CET] 00000036 SystemOutO Adding pragma: no-cache
      [07.11.13 16:31:37:638 CET] 00000036 SystemOutO Adding Set-Cookie: ORA_WWV_USER_61924365747959=ORA_WWV-K2tryGBPWvqqinNhpOmFNXVg; path=/zast; HttpOnly
      [07.11.13 16:31:37:638 CET] 00000036 SystemOutO Redirecting to: f?p=4550:1:17245839054939
      [07.11.13 16:31:37:643 CET] 00000036 SystemOutO ==== Request Processed ====
      [07.11.13 16:31:37:643 CET] 00000036 SystemOutO Processed PL/SQL Gateway request
      CommentAs seen APEX generates a redirect f?p=4550:1:17245839054939 but it never gets through to the client.

       

       

       

      Scenario 2Scenario 2
      URLhttp://testserver:10003/zast/f?p=4550
      ResultA white page is shown. HTTP Status is 503.
      Debug
      [07.11.13 16:33:36:046 CET] 00000036 SystemOutO Request Path passes syntax validation
      [07.11.13 16:33:36:047 CET] 00000036 SystemOutO Mapping request to database pool: PoolMap [_poolName=apex, _regex=null, _workspaceIdentifier=null, _failed=false, _lastUpdate=-1, _template=null, _type=REGEX]
      [07.11.13 16:33:36:047 CET] 00000036 SystemOutO Applied database connection info
      [07.11.13 16:33:36:047 CET] 00000036 SystemOutO Attempting to process with PL/SQL Gateway
      [07.11.13 16:33:36:048 CET] 00000036 SystemOutO ==== Processing Request: ====
      [07.11.13 16:33:36:048 CET] 00000036 SystemOutO GET /zast/f?p=4550
      [07.11.13 16:33:36:048 CET] 00000036 SystemOutO ==== Headers in Request ====
      [07.11.13 16:33:36:048 CET] 00000036 SystemOutO Host: testserver:10003
      [07.11.13 16:33:36:049 CET] 00000036 SystemOutO User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:25.0) Gecko/20100101 Firefox/25.0
      [07.11.13 16:33:36:049 CET] 00000036 SystemOutO Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
      [07.11.13 16:33:36:049 CET] 00000036 SystemOutO Accept-Language: de-de,de;q=0.8,en-us;q=0.5,en;q=0.3
      [07.11.13 16:33:36:049 CET] 00000036 SystemOutO Accept-Encoding: gzip, deflate
      [07.11.13 16:33:36:049 CET] 00000036 SystemOutO DNT: 1
      [07.11.13 16:33:36:049 CET] 00000036 SystemOutO Cookie: ORA_WWV_USER_61924365747959=ORA_WWV-K2tryGBPWvqqinNhpOmFNXVg; sessionCode=788901199; WWV_CUSTOM-F_1644981216445723978_148=-1; TJE=; TE3=N0:C N1:E N2:E N3:C N4:C N5:C N6:C N7:C N8:C N9:C N10:C N11:C N12:C N13:C N14:C N15:C N16:C N17:C N18:C N19:C N20:C N21:C N22:C N23:C N24:C N25:C N26:C N27:C N28:C N29:C N30:C N31:C N32:C N33:C N34:C N35:C N36:C N37:C; LtpaToken2=HvC2dwbSoEwQdn/3/6g9L4g3h8a/wPFQjveJFMqbNklNXLgw1cIdk10I6xDRwDt2E5nhhw4m8rjbFcPBO632T7lwVYPDFrgIVkV9Vr6sxm6Jps0LiYPcRbX/k3t7oUS28FNZEuJlavPQ0Wr91zYl6wXXhKuZ24+1ADmmIDvbhPiT/4go4oiJwDyNha1okco+T2SDTGizm+ibi8sLgWXY76cTPboW81McUqqSSL5JHz5MJlkodLqFybrebw/TiD8FJ0qxkb4UXht0L0PSrdqkOj0pBwsmliXDhie4wRN61ewAl4HN2thYVzIg9QoZUgD9ADztuhNUVKF1r+pVu9f7XRs2N6fva5DqpqNm9uhrijE=
      [07.11.13 16:33:36:050 CET] 00000036 SystemOutO Connection: keep-alive
      [07.11.13 16:33:36:050 CET] 00000036 SystemOutO ==== Cookies in Request ====
      [07.11.13 16:33:36:050 CET] 00000036 SystemOutO ORA_WWV_USER_61924365747959 =  ORA_WWV-K2tryGBPWvqqinNhpOmFNXVg
      [07.11.13 16:33:36:050 CET] 00000036 SystemOutO sessionCode =  788901199
      [07.11.13 16:33:36:050 CET] 00000036 SystemOutO WWV_CUSTOM-F_1644981216445723978_148 =  -1
      [07.11.13 16:33:36:050 CET] 00000036 SystemOutO TJE =
      [07.11.13 16:33:36:050 CET] 00000036 SystemOutO TE3 =  N0:C N1:E N2:E N3:C N4:C N5:C N6:C N7:C N8:C N9:C N10:C N11:C N12:C N13:C N14:C N15:C N16:C N17:C N18:C N19:C N20:C N21:C N22:C N23:C N24:C N25:C N26:C N27:C N28:C N29:C N30:C N31:C N32:C N33:C N34:C N35:C N36:C N37:C
      [07.11.13 16:33:36:050 CET] 00000036 SystemOutO LtpaToken2 =  HvC2dwbSoEwQdn/3/6g9L4g3h8a/wPFQjveJFMqbNklNXLgw1cIdk10I6xDRwDt2E5nhhw4m8rjbFcPBO632T7lwVYPDFrgIVkV9Vr6sxm6Jps0LiYPcRbX/k3t7oUS28FNZEuJlavPQ0Wr91zYl6wXXhKuZ24+1ADmmIDvbhPiT/4go4oiJwDyNha1okco+T2SDTGizm+ibi8sLgWXY76cTPboW81McUqqSSL5JHz5MJlkodLqFybrebw/TiD8FJ0qxkb4UXht0L0PSrdqkOj0pBwsmliXDhie4wRN61ewAl4HN2thYVzIg9QoZUgD9ADztuhNUVKF1r+pVu9f7XRs2N6fva5DqpqNm9uhrijE=
      [07.11.13 16:33:36:051 CET] 00000036 SystemOutO request parameter: p=4550
      [07.11.13 16:33:36:051 CET] 00000036 SystemOutO isValidRequest(), procedure name: <f>
      [07.11.13 16:33:36:051 CET] 00000036 SystemOutO Validating: f
      [07.11.13 16:33:36:054 CET] 00000036 SystemOutO *** Total number of arguments: 15
      [07.11.13 16:33:36:060 CET] 00000036 SystemOutO SID: 682
      [07.11.13 16:33:36:060 CET] 00000036 SystemOutO Parse: 0 ms
      [07.11.13 16:33:36:061 CET] 00000036 SystemOutO -----

      begin

      f(p=>?);

      commit;

        end;

      [07.11.13 16:33:36:061 CET] 00000036 SystemOutO *** Total number of arguments: 15
      [07.11.13 16:33:36:061 CET] 00000036 SystemOutO {p=4550}
      [07.11.13 16:33:36:061 CET] 00000036 SystemOutO p=4550
      [07.11.13 16:33:36:061 CET] 00000036 SystemOutO p= 4550
      [07.11.13 16:33:36:074 CET] 00000036 SystemOutO Exec: 13 ms
      [07.11.13 16:33:36:083 CET] 00000036 SystemOutO Got results length: 0
      [07.11.13 16:33:36:083 CET] 00000036 SystemOutO ==== Headers from Results ====
      [07.11.13 16:33:36:083 CET] 00000036 SystemOutO Redirecting to: f?p=4550:1:
      [07.11.13 16:33:36:087 CET] 00000036 SystemOutO ==== Request Processed ====
      [07.11.13 16:33:36:088 CET] 00000036 SystemOutO Processed PL/SQL Gateway request
      CommentAPEX tries a redirect to page 1 but it never gets through to the client.

       

       

       

      Scenario 3Scenario 3
      URLhttp://testserver:10003/zast/f?p=1
      ResultThis is a test application. A white page is shown. HTTP Status is 503
      Debug
      [07.11.13 16:42:19:997 CET] 00000037 SystemOutO Request Path passes syntax validation
      [07.11.13 16:42:19:998 CET] 00000037 SystemOutO Mapping request to database pool: PoolMap [_poolName=apex, _regex=null, _workspaceIdentifier=null, _failed=false, _lastUpdate=-1, _template=null, _type=REGEX]
      [07.11.13 16:42:19:998 CET] 00000037 SystemOutO Applied database connection info
      [07.11.13 16:42:19:998 CET] 00000037 SystemOutO Attempting to process with PL/SQL Gateway
      [07.11.13 16:42:19:998 CET] 00000037 SystemOutO ==== Processing Request: ====
      [07.11.13 16:42:19:998 CET] 00000037 SystemOutO GET /zast/f?p=1
      [07.11.13 16:42:19:998 CET] 00000037 SystemOutO ==== Headers in Request ====
      [07.11.13 16:42:19:998 CET] 00000037 SystemOutO Host: testserver:10003
      [07.11.13 16:42:19:998 CET] 00000037 SystemOutO User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:25.0) Gecko/20100101 Firefox/25.0
      [07.11.13 16:42:19:998 CET] 00000037 SystemOutO Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
      [07.11.13 16:42:19:999 CET] 00000037 SystemOutO Accept-Language: de-de,de;q=0.8,en-us;q=0.5,en;q=0.3
      [07.11.13 16:42:19:999 CET] 00000037 SystemOutO Accept-Encoding: gzip, deflate
      [07.11.13 16:42:19:999 CET] 00000037 SystemOutO DNT: 1
      [07.11.13 16:42:19:999 CET] 00000037 SystemOutO Cookie: ORA_WWV_USER_61924365747959=ORA_WWV-dkPm20GRWz02G7z+f3D/OvV4; sessionCode=788901199; WWV_CUSTOM-F_1644981216445723978_148=-1; TJE=; TE3=N0:C N1:E N2:E N3:C N4:C N5:C N6:C N7:C N8:C N9:C N10:C N11:C N12:C N13:C N14:C N15:C N16:C N17:C N18:C N19:C N20:C N21:C N22:C N23:C N24:C N25:C N26:C N27:C N28:C N29:C N30:C N31:C N32:C N33:C N34:C N35:C N36:C N37:C; LtpaToken2=HvC2dwbSoEwQdn/3/6g9L4g3h8a/wPFQjveJFMqbNklNXLgw1cIdk10I6xDRwDt2E5nhhw4m8rjbFcPBO632T7lwVYPDFrgIVkV9Vr6sxm6Jps0LiYPcRbX/k3t7oUS28FNZEuJlavPQ0Wr91zYl6wXXhKuZ24+1ADmmIDvbhPiT/4go4oiJwDyNha1okco+T2SDTGizm+ibi8sLgWXY76cTPboW81McUqqSSL5JHz5MJlkodLqFybrebw/TiD8FJ0qxkb4UXht0L0PSrdqkOj0pBwsmliXDhie4wRN61ewAl4HN2thYVzIg9QoZUgD9ADztuhNUVKF1r+pVu9f7XRs2N6fva5DqpqNm9uhrijE=
      [07.11.13 16:42:19:999 CET] 00000037 SystemOutO Connection: keep-alive
      [07.11.13 16:42:19:999 CET] 00000037 SystemOutO ==== Cookies in Request ====
      [07.11.13 16:42:19:999 CET] 00000037 SystemOutO ORA_WWV_USER_61924365747959 =  ORA_WWV-dkPm20GRWz02G7z+f3D/OvV4
      [07.11.13 16:42:19:999 CET] 00000037 SystemOutO sessionCode =  788901199
      [07.11.13 16:42:19:999 CET] 00000037 SystemOutO WWV_CUSTOM-F_1644981216445723978_148 =  -1
      [07.11.13 16:42:19:999 CET] 00000037 SystemOutO TJE =
      [07.11.13 16:42:19:999 CET] 00000037 SystemOutO TE3 =  N0:C N1:E N2:E N3:C N4:C N5:C N6:C N7:C N8:C N9:C N10:C N11:C N12:C N13:C N14:C N15:C N16:C N17:C N18:C N19:C N20:C N21:C N22:C N23:C N24:C N25:C N26:C N27:C N28:C N29:C N30:C N31:C N32:C N33:C N34:C N35:C N36:C N37:C
      [07.11.13 16:42:19:999 CET] 00000037 SystemOutO LtpaToken2 =  HvC2dwbSoEwQdn/3/6g9L4g3h8a/wPFQjveJFMqbNklNXLgw1cIdk10I6xDRwDt2E5nhhw4m8rjbFcPBO632T7lwVYPDFrgIVkV9Vr6sxm6Jps0LiYPcRbX/k3t7oUS28FNZEuJlavPQ0Wr91zYl6wXXhKuZ24+1ADmmIDvbhPiT/4go4oiJwDyNha1okco+T2SDTGizm+ibi8sLgWXY76cTPboW81McUqqSSL5JHz5MJlkodLqFybrebw/TiD8FJ0qxkb4UXht0L0PSrdqkOj0pBwsmliXDhie4wRN61ewAl4HN2thYVzIg9QoZUgD9ADztuhNUVKF1r+pVu9f7XRs2N6fva5DqpqNm9uhrijE=
      [07.11.13 16:42:19:999 CET] 00000037 SystemOutO request parameter: p=1
      [07.11.13 16:42:19:999 CET] 00000037 SystemOutO isValidRequest(), procedure name: <f>
      [07.11.13 16:42:20:000 CET] 00000037 SystemOutO Validating: f
      [07.11.13 16:42:20:003 CET] 00000037 SystemOutO *** Total number of arguments: 15
      [07.11.13 16:42:20:045 CET] 00000037 SystemOutO SID: 682
      [07.11.13 16:42:20:045 CET] 00000037 SystemOutO Parse: 0 ms
      [07.11.13 16:42:20:046 CET] 00000037 SystemOutO -----

      begin

      f(p=>?);

      commit;

        end;

      [07.11.13 16:42:20:046 CET] 00000037 SystemOutO *** Total number of arguments: 15
      [07.11.13 16:42:20:046 CET] 00000037 SystemOutO {p=1}
      [07.11.13 16:42:20:046 CET] 00000037 SystemOutO p=1
      [07.11.13 16:42:20:047 CET] 00000037 SystemOutO p= 1
      [07.11.13 16:42:20:062 CET] 00000037 SystemOutO Exec: 15 ms
      [07.11.13 16:42:20:067 CET] 00000037 SystemOutO Got results length: 0
      [07.11.13 16:42:20:067 CET] 00000037 SystemOutO ==== Headers from Results ====
      [07.11.13 16:42:20:067 CET] 00000037 SystemOutO Redirecting to: f?p=1:1:
      [07.11.13 16:42:20:069 CET] 00000037 SystemOutO ==== Request Processed ====
      [07.11.13 16:42:20:070 CET] 00000037 SystemOutO Processed PL/SQL Gateway request
      CommentAPEX tries a redirect to page 1 but it never gets through to the client.

       

       

       

       

      Scenario 4Scenario 4
      URLhttp://testserver:10003/zast/f?p=2
      Result

      An application with the id 2 does not exist. Here things are starting to get interesting because i actually get a valid response (Status 200)

      The HTML content reads as follows:

      =======================

      Error   Error processing request.

      ORA-01403: no data found

      OK

      =======================

      Even the image of a red stop sign with a white X is displayed (/itest/error.gif).

      Debug
      [07.11.13 16:44:16:390 CET] 00000037 SystemOutO Request Path passes syntax validation
      [07.11.13 16:44:16:390 CET] 00000037 SystemOutO Mapping request to database pool: PoolMap [_poolName=apex, _regex=null, _workspaceIdentifier=null, _failed=false, _lastUpdate=-1, _template=null, _type=REGEX]
      [07.11.13 16:44:16:391 CET] 00000037 SystemOutO Applied database connection info
      [07.11.13 16:44:16:391 CET] 00000037 SystemOutO Attempting to process with PL/SQL Gateway
      [07.11.13 16:44:16:391 CET] 00000037 SystemOutO ==== Processing Request: ====
      [07.11.13 16:44:16:391 CET] 00000037 SystemOutO GET /zast/f?p=2
      [07.11.13 16:44:16:391 CET] 00000037 SystemOutO ==== Headers in Request ====
      [07.11.13 16:44:16:391 CET] 00000037 SystemOutO Host: testserver:10003
      [07.11.13 16:44:16:391 CET] 00000037 SystemOutO User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:25.0) Gecko/20100101 Firefox/25.0
      [07.11.13 16:44:16:391 CET] 00000037 SystemOutO Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
      [07.11.13 16:44:16:391 CET] 00000037 SystemOutO Accept-Language: de-de,de;q=0.8,en-us;q=0.5,en;q=0.3
      [07.11.13 16:44:16:391 CET] 00000037 SystemOutO Accept-Encoding: gzip, deflate
      [07.11.13 16:44:16:391 CET] 00000037 SystemOutO DNT: 1
      [07.11.13 16:44:16:394 CET] 00000037 SystemOutO Cookie: ORA_WWV_USER_61924365747959=ORA_WWV-dkPm20GRWz02G7z+f3D/OvV4; sessionCode=788901199; WWV_CUSTOM-F_1644981216445723978_148=-1; TJE=; TE3=N0:C N1:E N2:E N3:C N4:C N5:C N6:C N7:C N8:C N9:C N10:C N11:C N12:C N13:C N14:C N15:C N16:C N17:C N18:C N19:C N20:C N21:C N22:C N23:C N24:C N25:C N26:C N27:C N28:C N29:C N30:C N31:C N32:C N33:C N34:C N35:C N36:C N37:C; LtpaToken2=HvC2dwbSoEwQdn/3/6g9L4g3h8a/wPFQjveJFMqbNklNXLgw1cIdk10I6xDRwDt2E5nhhw4m8rjbFcPBO632T7lwVYPDFrgIVkV9Vr6sxm6Jps0LiYPcRbX/k3t7oUS28FNZEuJlavPQ0Wr91zYl6wXXhKuZ24+1ADmmIDvbhPiT/4go4oiJwDyNha1okco+T2SDTGizm+ibi8sLgWXY76cTPboW81McUqqSSL5JHz5MJlkodLqFybrebw/TiD8FJ0qxkb4UXht0L0PSrdqkOj0pBwsmliXDhie4wRN61ewAl4HN2thYVzIg9QoZUgD9ADztuhNUVKF1r+pVu9f7XRs2N6fva5DqpqNm9uhrijE=
      [07.11.13 16:44:16:395 CET] 00000037 SystemOutO Connection: keep-alive
      [07.11.13 16:44:16:395 CET] 00000037 SystemOutO ==== Cookies in Request ====
      [07.11.13 16:44:16:395 CET] 00000037 SystemOutO ORA_WWV_USER_61924365747959 =  ORA_WWV-dkPm20GRWz02G7z+f3D/OvV4
      [07.11.13 16:44:16:395 CET] 00000037 SystemOutO sessionCode =  788901199
      [07.11.13 16:44:16:395 CET] 00000037 SystemOutO WWV_CUSTOM-F_1644981216445723978_148 =  -1
      [07.11.13 16:44:16:395 CET] 00000037 SystemOutO TJE =
      [07.11.13 16:44:16:395 CET] 00000037 SystemOutO TE3 =  N0:C N1:E N2:E N3:C N4:C N5:C N6:C N7:C N8:C N9:C N10:C N11:C N12:C N13:C N14:C N15:C N16:C N17:C N18:C N19:C N20:C N21:C N22:C N23:C N24:C N25:C N26:C N27:C N28:C N29:C N30:C N31:C N32:C N33:C N34:C N35:C N36:C N37:C
      [07.11.13 16:44:16:396 CET] 00000037 SystemOutO LtpaToken2 =  HvC2dwbSoEwQdn/3/6g9L4g3h8a/wPFQjveJFMqbNklNXLgw1cIdk10I6xDRwDt2E5nhhw4m8rjbFcPBO632T7lwVYPDFrgIVkV9Vr6sxm6Jps0LiYPcRbX/k3t7oUS28FNZEuJlavPQ0Wr91zYl6wXXhKuZ24+1ADmmIDvbhPiT/4go4oiJwDyNha1okco+T2SDTGizm+ibi8sLgWXY76cTPboW81McUqqSSL5JHz5MJlkodLqFybrebw/TiD8FJ0qxkb4UXht0L0PSrdqkOj0pBwsmliXDhie4wRN61ewAl4HN2thYVzIg9QoZUgD9ADztuhNUVKF1r+pVu9f7XRs2N6fva5DqpqNm9uhrijE=
      [07.11.13 16:44:16:396 CET] 00000037 SystemOutO request parameter: p=2
      [07.11.13 16:44:16:396 CET] 00000037 SystemOutO isValidRequest(), procedure name: <f>
      [07.11.13 16:44:16:396 CET] 00000037 SystemOutO Validating: f
      [07.11.13 16:44:16:407 CET] 00000037 SystemOutO *** Total number of arguments: 15
      [07.11.13 16:44:16:412 CET] 00000037 SystemOutO SID: 682
      [07.11.13 16:44:16:415 CET] 00000037 SystemOutO Parse: 0 ms
      [07.11.13 16:44:16:415 CET] 00000037 SystemOutO -----

      begin

      f(p=>?);

      commit;

        end;

      [07.11.13 16:44:16:415 CET] 00000037 SystemOutO *** Total number of arguments: 15
      [07.11.13 16:44:16:415 CET] 00000037 SystemOutO {p=2}
      [07.11.13 16:44:16:416 CET] 00000037 SystemOutO p=2
      [07.11.13 16:44:16:472 CET] 00000037 SystemOutO p= 2
      [07.11.13 16:44:16:490 CET] 00000037 SystemOutO Exec: 17 ms
      [07.11.13 16:44:16:530 CET] 00000037 SystemOutO Got results length: 311
      [07.11.13 16:44:16:531 CET] 00000037 SystemOutO ==== Headers from Results ====
      [07.11.13 16:44:16:531 CET] 00000037 SystemOutO Setting Content-Type (Content-type): text/html; charset=UTF-8
      [07.11.13 16:44:16:534 CET] 00000037 SystemOutO ==== Request Processed ====
      [07.11.13 16:44:16:535 CET] 00000037 SystemOutO Processed PL/SQL Gateway request
      CommentThis is the first time APEX does not try to generate a redirect but only set some content type and here i actually get a valid HTML response.

       

       

       

      So it is not the case that the application is not running. I clearly get a sign of life from APEX so the application "works" and it gets a connection to the database. Also the images are working. To me it seems that there is something strange going on between the connection of the APEX Listener and the databsse.

       

       

      The funny thing is that the same APEX Listener with the same image application and the same database connection works just perfectly in a locally installed Tomcat 7...