This discussion is archived
4 Replies Latest reply: Mar 6, 2013 8:38 AM by 980407 RSS

Report Server Hangs.

980407 Newbie
Currently Being Moderated
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. Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Solved by Technical Service Request.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points