3 Replies Latest reply: Mar 16, 2013 2:48 PM by carlos cortez RSS

    Configuration to avoid reports 11g timeout

    carlos cortez
      Hello,

      We are about to put in production some reports that takes about 1 hour to process, we are using weblogic 10.3.6 and forms11g 11.1.1.6 over linux 5

      Which parameters and components should i modify to avoid timeouts :)

      Regards
      Carlos
        • 1. Re: Configuration to avoid reports 11g timeout
          user1935693
          Hi,

          Are you getting timeout errors now? If so, what errors? What is generating them, Forms or Reports? In the Form, can you set the Report object's Communication Mode to Asynchronous so that the Form doesn't have to wait for the report to finish?

          If the timeout is being generated withing Reports, then I would post over in the Reports forum.

          HTH,
          Brian
          • 2. Re: Configuration to avoid reports 11g timeout
            carlos cortez
            Hi,

            The error i'm getting is this one:

            [2013-03-15T10:47:59.9613-06:00] [OHS] [ERROR:32] [OHS-9999] [core.c] [host_id: lacslvsiuvas004] [host_addr: 10.235.57.213] [tid: 47743130196288] [user: oracle] [ecid: 004pz_L0o5S3BD__HPO5yf0000nS000j^O] [rid: 0] [VirtualHost: main] ap_proxy: trying POST /reports/rwservlet at backend host 10.235.57.213/9002; got exception 'Backend Server not responding'; state: reading status line or response headers from WLS (wrote? Y read? N); not failing over because method not idempotent, referer: http://host:8888/reports/rwservlet/getjobid142237522?server=server_name

            i think is something about WLIOTimeoutSecs parameter
            • 3. Re: Configuration to avoid reports 11g timeout
              carlos cortez
              After increase WLIOTimeoutSecs parameter and set the Idempotent parameter to OFF, all is working fine :)

              Regards
              Carlos