1 Reply Latest reply on Nov 24, 2010 7:56 AM by Salim Hlayel

    APEX Listener 1.1 SEVER ERROR

    Salim Hlayel
      Hi I getting following error: HTTP Status 500 - System Unavailable. Please try again later.

      I am using Apex Listener 1.1 EA, APEX 4.0.2, Oracle DB 10G R2 and GlassFish 3.0.1

      The log file has the following:

      [#|2010-11-24T10:49:52.330+0400|SEVERE|glassfish3.0.1|javax.enterprise.system.std.com.sun.enterprise.v3.services.impl|_ThreadID=26;_ThreadName=Thread-1;|_init_: # headers=46
      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:184
      CALL:
      begin
      f(success_msg=>?,
      p=>?);
      commit;
      end;
      BINDS

      success_msg:Region Updated. Multi row update region columns processed. Report attributes set./573C195DB5F09EB3BB0A08FAA12F41DE/
      p:4000:4150:2656485536027170::NO:::
      EXEC FAILED:ORA-20867: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
      ORA-06512: at "APEX_040000.WWV_FLOW_DISP_PAGE_PLUGS", line 2641
      ORA-06512: at "APEX_040000.WWV_FLOW_DISP_PAGE_PLUGS", line 3531
      ORA-06512: at "APEX_040000.WWV_FLOW_DISP_PAGE_PLUGS", line 376
      ORA-06512: at "APEX_040000.WWV_FLOW", line 3702
      ORA-06512: at "APEX_040000.WWV_FLOW", line 2855
      ORA-06512: at "APEX_040000.WWV_FLOW", line 12311
      ORA-06512: at "APEX_040000.F", line 267
      ORA-06512: at "APEX_040000.F", line 294
      ORA-06512: at line 2
      |#]

      [#|2010-11-24T10:49:52.330+0400|SEVERE|glassfish3.0.1|javax.enterprise.system.std.com.sun.enterprise.v3.services.impl|_ThreadID=26;_ThreadName=Thread-1;|ORA-20867: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
      ORA-06512: at "APEX_040000.WWV_FLOW_DISP_PAGE_PLUGS", line 2641
      ORA-06512: at "APEX_040000.WWV_FLOW_DISP_PAGE_PLUGS", line 3531
      ORA-06512: at "APEX_040000.WWV_FLOW_DISP_PAGE_PLUGS", line 376
      ORA-06512: at "APEX_040000.WWV_FLOW", line 3702
      ORA-06512: at "APEX_040000.WWV_FLOW", line 2855
      ORA-06512: at "APEX_040000.WWV_FLOW", line 12311
      ORA-06512: at "APEX_040000.F", line 267
      ORA-06512: at "APEX_040000.F", line 294
      ORA-06512: at line 2
      |#]

      [#|2010-11-24T10:49:55.783+0400|SEVERE|glassfish3.0.1|javax.enterprise.system.std.com.sun.enterprise.v3.services.impl|_ThreadID=25;_ThreadName=Thread-1;|_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:184
      CALL:
      begin
      f(success_msg=>?,
      p=>?);
      commit;
      end;
      BINDS

      success_msg:Region Updated. Multi row update region columns processed. Report attributes set./573C195DB5F09EB3BB0A08FAA12F41DE/
      p:4000:4150:2656485536027170::NO:::
      EXEC FAILED:ORA-20867: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
      ORA-06512: at "APEX_040000.WWV_FLOW_DISP_PAGE_PLUGS", line 2641
      ORA-06512: at "APEX_040000.WWV_FLOW_DISP_PAGE_PLUGS", line 3531
      ORA-06512: at "APEX_040000.WWV_FLOW_DISP_PAGE_PLUGS", line 376
      ORA-06512: at "APEX_040000.WWV_FLOW", line 3702
      ORA-06512: at "APEX_040000.WWV_FLOW", line 2855
      ORA-06512: at "APEX_040000.WWV_FLOW", line 12311
      ORA-06512: at "APEX_040000.F", line 267
      ORA-06512: at "APEX_040000.F", line 294
      ORA-06512: at line 2
      |#]