3 Replies Latest reply: Nov 17, 2012 12:51 AM by Mehabub Sheikh RSS

    4.2 - Data Loading Page Type

    Mehabub Sheikh
      Hi,

      I had created pages using data load page wizard. I had put transformation rules SQL Query returning single value. I could see that it has transformed the data as per my rules.
      When I run that with CSV, I could see that it has transformed the data as per my rules. But after clicking load data button file I am getting data upload failed error.
      I enabled debug and following is the error message from accept phase

      ......error_backtrace: ORA-06512: at "APEX_040200.WWV_FLOW_DATA_UPLOAD", line 3112 ORA-06512: at "APEX_040200.WWV_FLOW_DATA_UPLOAD", line 3813 ORA-06512: at "APEX_040200.WWV_FLOW_PROCESS_NATIVE", line 213 ORA-06512: at "APEX_040200.WWV_FLOW_PROCESS_NATIVE", line 262 ORA-06512: at "APEX_040200.WWV_FLOW_PLUGIN", line 1808 ORA-06512: at "APEX_040200.WWV_FLOW_PROCESS", line 452

      Also I could see from error tabs in the debug page
      Data Loading Failed ORA-00040: active time limit exceeded - call aborted

      Could you please help?

      Thanks,
      Mehabub

      Edited by: Mehabub Sheikh on Sep 5, 2012 3:14 AM

      Edited by: Mehabub Sheikh on Sep 5, 2012 6:27 AM