5 Replies Latest reply on Jun 30, 2010 11:40 AM by eric henrard

    Page customization ends with HTTP 500 on APEX 4.0, 3.2 & 3.0

    jan.navratil
      Hello,

      I'm very pleased how well APEX Listener works with our existing applications (100s of pages). So far we've found only one issue we can't work around:

      The problem occurs when user is trying to save page customization when using APEX Listener.

      Steps to replicate:
      1) Create an APEX page with region and set "Customization" to "Customizable and Shown By Default"
      2) Run the page & click on "Customize" link
      3) The customization pop-up is presented
      4) Click on "Apply changes"
      5) Error: HTTP Status 500 - System Unavailable. Please try again later.
      The Apache Tomcat stdout log is attached bellow.

      When we use Oracle HTTP server (running on the same database) no error occurs.

      Configurations (3 environments with the same results):
      * APEX Listener 0.10.110.10.57
      * Apache Tomcat 6.0.26 (Windows)
      * APEX 3.0.1 & Database 11g Release 1 (Windows)
      * APEX 3.2.1 & Database 11g Release 2 (Linux & Windows)
      * APEX 4.0.0 & Database 11g Release 2 (Windows)

      Thanks for any ideas,

      Jan

      -----

      init: # headers=47
      declare nm owa.vc_arr := ?;
      vl owa.vc_arr := ?;
      begin
      owa.init_cgi_env( ?, nm, vl );
      htp.init; htp.HTBUF_LEN := 63;
      ? := sys_context('USERENV','SID');
      end;
      SID:133
      CALL:
      begin
      FLOWS_030000.wwv_flow_customize.accept(p_session=>?,
      p_flow=>?,
      p_lang=>?,
      p_page=>?,
      p_request=>?,
      p_check=>?);
      commit;
      end;
      BINDS

      p_session:8387122011225562
      p_flow:116
      p_lang:en-us
      p_page:301
      p_request:DOIT
      p_check:227161929735196086
      p_session:8387122011225562
      p_flow:116
      p_lang:en-us
      p_page:301
      p_request:DOIT
      p_check:227161929735196086
      EXEC FAILED:ORA-06550: line 2, column 2:
      PLS-00306: wrong number or types of arguments in call to 'ACCEPT'
      ORA-06550: line 2, column 2:
      PL/SQL: Statement ignored
      ORA-06550: line 2, column 2:
      PLS-00306: wrong number or types of arguments in call to 'ACCEPT'
      ORA-06550: line 2, column 2:
      PL/SQL: Statement ignored
        • 1. Re: Page customization ends with HTTP 500 on APEX 4.0, 3.2 & 3.0
          Salim Hlayel
          I am having similar error when I just click on a different tab.
          My environment is:

          Windows 7 64 bit
          Oracle 11g 11.0.0.7 64 bit
          APEX 4.0
          APEX Listener version :0.10.110.10.57
          Tomcat 6.0.26 64 bit

          init: # headers=48
          declare nm owa.vc_arr := ?;
               vl owa.vc_arr := ?;
          begin
          owa.init_cgi_env( ?, nm, vl );
          htp.init; htp.HTBUF_LEN := 63;
          ? := sys_context('USERENV','SID');
          end;
          SID:123
          CALL:
          begin
          wwv_flow.accept(fmap=>?,
          p_md5_checksum=>?,
          fhdr=>?,
          p_flow_id=>?,
          p_arg_names=>?,
          p_flow_step_id=>?,
          p_request=>?,
          f07=>?,
          f06=>?,
          f05=>?,
          fcud=>?,
          f04=>?,
          p_t03=>?,
          fcs=>?,
          f03=>?,
          p_t02=>?,
          f02=>?,
          p_t01=>?,
          f01=>?,
          p_page_submission_id=>?,
          p_instance=>?);
          commit;
          end;
          BINDS

          fmap:ID
          p_md5_checksum:
          fhdr:Id
          p_flow_id:124
          p_arg_names: {130192630919901213042194243265201302107392199031}
          p_flow_step_id:3
          p_request:
          f07: {}
          f06: {SALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIM}
          f05: {23-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-10}
          fcud:U
          f04: {-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1}
          p_t03:0830-1030
          fcs: {4913A437A8555DFD6256617C43EC4F6E787AF0EA51C4ACD1DEA325BFFFD9FC42E0EA11A98E84AE7637B3CB68DF111DE6772C6EDFAE59C0E9CED6AB1C4808305554F697DC6FE06BC143696B253357E27E8816DB9D3DF502D70A1679AA76F09D725E47D743C504E0663491006196DB4254A7C5258C760B5DA782B993E1C97F9B2108A232F2F223F63C1BA2790DE802E481A292FF419EB323F1C124B6AC5F838C969C0AC36D8E554135B1910E3D0A128AEEF992C7A26A40FCEF24E770D118C2DA77828BDF680A10BD3B694DEAF259360785795C7DBB031B87E3CC578AC0A1EA5C326ED1A02E90B0CB272483E24E38986155E06ED3E1D3EC26FFA850E5285F7AC706}
          f03: {V00011228V00011453V00011570V00011593V00011639V00011694V00011706V00011808V00012024V00012033V00013430V00013507V00013508V00013522V00013826V00014360}
          p_t02:V00010026
          f02: {V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026}
          p_t01:3-FEB-2010
          f01: {15157151581515915160151611516215163151641516515166151671516815169151701517115172}
          p_page_submission_id:2720755601478681
          p_instance:2914143952562994
          fmap:ID
          p_md5_checksum:
          fhdr:Id
          p_flow_id:124
          p_arg_names: {130192630919901213042194243265201302107392199031}
          p_flow_step_id:3
          p_request:
          f07: {}
          f06: {SALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIMSALIM}
          f05: {23-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-1023-FEB-10}
          fcud:U
          f04: {-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1-1}
          p_t03:0830-1030
          fcs: {4913A437A8555DFD6256617C43EC4F6E787AF0EA51C4ACD1DEA325BFFFD9FC42E0EA11A98E84AE7637B3CB68DF111DE6772C6EDFAE59C0E9CED6AB1C4808305554F697DC6FE06BC143696B253357E27E8816DB9D3DF502D70A1679AA76F09D725E47D743C504E0663491006196DB4254A7C5258C760B5DA782B993E1C97F9B2108A232F2F223F63C1BA2790DE802E481A292FF419EB323F1C124B6AC5F838C969C0AC36D8E554135B1910E3D0A128AEEF992C7A26A40FCEF24E770D118C2DA77828BDF680A10BD3B694DEAF259360785795C7DBB031B87E3CC578AC0A1EA5C326ED1A02E90B0CB272483E24E38986155E06ED3E1D3EC26FFA850E5285F7AC706}
          f03: {V00011228V00011453V00011570V00011593V00011639V00011694V00011706V00011808V00012024V00012033V00013430V00013507V00013508V00013522V00013826V00014360}
          p_t02:V00010026
          f02: {V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026V00010026}
          p_t01:3-FEB-2010
          f01: {15157151581515915160151611516215163151641516515166151671516815169151701517115172}
          p_page_submission_id:2720755601478681
          p_instance:2914143952562994
          EXEC FAILED:ORA-06550: line 2, column 2:
          PLS-00306: wrong number or types of arguments in call to 'ACCEPT'
          ORA-06550: line 2, column 2:
          PLS-00306: wrong number or types of arguments in call to 'ACCEPT'
          ORA-06550: line 2, column 2:
          PLS-00306: wrong number or types of arguments in call to 'ACCEPT'
          ORA-06550: line 2, column 2:
          PL/SQL: Statement ignored
          ORA-06550: line 2, column 2:
          PLS-00306: wrong number or types of arguments in call to 'ACCEPT'
          ORA-06550: line 2, column 2:
          PLS-00306: wrong number or types of arguments in call to 'ACCEPT'
          ORA-06550: line 2, column 2:
          PLS-00306: wrong number or types of arguments in call to 'ACCEPT'
          ORA-06550: line 2, column 2:
          PL/SQL: Statement ignored
          • 2. Re: Page customization ends with HTTP 500 on APEX 4.0, 3.2 & 3.0
            Fahd.Mirza
            This seems to be a bug. Have you contacted Oracle Support?

            regards
            • 3. Re: Page customization ends with HTTP 500 on APEX 4.0, 3.2 & 3.0
              jan.navratil
              Just tested with final release of listener (1.10.179.10.43) and it works fine on APEX 4.0 & 11gR2.

              Sorry to see Tomcat is not listed as supported J2EE server anymore :-(

              Jan
              • 4. Re: Page customization ends with HTTP 500 on APEX 4.0, 3.2 & 3.0
                Fadi Samara Guest
                How you tested the last APEX listener w/o Tomcat?
                • 5. Re: Page customization ends with HTTP 500 on APEX 4.0, 3.2 & 3.0
                  eric henrard
                  I have the same issue on tomcat : (Apex Listener 1.10.179.10.43)

                  p_col_nam:RAW_DEM_DDL_DCT
                  EXEC FAILED:ORA-06550: line 2, column 2:
                  PLS-00306: wrong number or types of arguments in call to 'DL_SCH_RLS_MOL_DEM'
                  ORA-06550: line 2, column 2:
                  PL/SQL: Statement ignored
                  ORA-06550: line 2, column 2:
                  PLS-00306: wrong number or types of arguments in call to 'DL_SCH_RLS_MOL_DEM'
                  ORA-06550: line 2, column 2:
                  PL/SQL: Statement ignored

                  I put the old version 0.10.110.10.57 and it works. Do we have any chance to have tomcat support?

                  Regards,

                  Eric.