4 Replies Latest reply: Mar 6, 2013 8:38 AM by 980407 RSS

    Report Server Hangs.

    980407
      Hello,

      My client is using Oracle Application Server 10g (10.1.2.0.2) on Windows 2003 Server.
      They are facing report hanging problem. Some times reports runs successfully, but most of the times report server got hanged (because of connection timeout) and then they have to restart report server forcefully.

      I am attaching configuration file, snapshots of failed jobs and server logs. Please help us to analyse and solve the issue.

      Thanks & Regards,
      Sharjeel

      P.S. Reports are not very heavy to load, and takes maximum of 2 minutes when they runs successfully.
        • 1. Re: Report Server Hangs.
          Paul M.
          Some times reports runs successfully, but most of the times report server got hanged (because of connection timeout)
          Does "connection timeout" mean that you get an error ? If so, which one ? Or it simply hangs ?

          Your scenario is similar to the one in Re: Forms and Reports Server standalone : actually I had that problem in older versions, and never in 10.1.2.

          Anyway, what are the values of engine parameters in <reports server>.conf file, in ORACLE_HOME\reports\conf ?
          I am attaching configuration file, snapshots of failed jobs and server logs.
          Well, where are they?
          • 2. Re: Report Server Hangs.
            980407
            Hello Paul,

            I have raised service request. They have recommended following work-around.
            Step 1: Apply following patchset/opatches.
            1.     Upgrade OAS from 10.1.2.0.2 to 10.1.2.3
            https://updates.oracle.com/Orion/PatchDetails/process_form?patch_num=5983622

            2.     Install the OPatch from patch 6880880
            https://updates.oracle.com/download/6880880.html

            3.     Install Forms Bundle Patch: Patch 9593176
            https://updates.oracle.com/download/9593176.html

            4.     Install Forms Patch:14614795
            https://updates.oracle.com/download/14614795.html

            5.     Install Report Bundle Patch: Patch 9774440
            https://updates.oracle.com/Orion/PatchDetails/process_form?patch_num=9774440

            Step 2: The following resource change and clean up will solve most corruption, intermittent crash, and limitation issues.
            1.     Rename the report server's .dat file found under the midtier OH (<rwserver name>.dat)

            2.     Change
            <engine id="rwEng" class="oracle.reports.engine.EngineImpl" initEngine="1" maxEngine="5" minEngine="0" engLife="50" maxIdle="30" callbackTimeOut="90000"
            engineResponseTimeOut="10">
            To
            <engine class="oracle.reports.engine.EngineImpl" " initEngine="2" maxEngine="4" minEngine="2" engLife="5" maxIdle="30" callbackTimeOut="180000" engineResponseTimeOut="10" jvmOptions="-Xmx512M -Xms128M -Xss512k">

            3.     <connection maxConnect="200" idleTimeOut="120">

            4.     Stop and start report server to get these changes into effect.

            5.     Test again to see if this resolves your issue.

            Regards,
            Sharjeel
            • 3. Re: Report Server Hangs.
              980407
              Following is server configuration.

              <engine id="rwEng" class="oracle.reports.engine.EngineImpl" initEngine="1" maxEngine="5" minEngine="0" engLife="50" maxIdle="30" callbackTimeOut="90000" engineResponseTimeOut="10">
              <!--property name="sourceDir" value="your reports source directory"/-->
              <!--property name="tempDir" value="your reports temp directory"/-->
              <!--property name="keepConnection" value="yes"/-->
              </engine>
              <engine id="rwURLEng" class="oracle.reports.urlengine.URLEngineImpl" initEngine="1" maxEngine="1" minEngine="0" engLife="50" maxIdle="30" callbackTimeOut="60000"/>
              • 4. Re: Report Server Hangs.
                980407
                Solved by Technical Service Request.