DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Report server Hanging frequently...........

hariharan.thyagarajanJan 9 2009 — edited Jan 13 2009

Hi All

The problem is report server hanging let me tel u in detail below:

We query whether the reports has executed successfully or not by using the below command in IE

http://<SeverIp>:7778/reports/rwservlet/showjobs?server=reportservername

While querying this we get the results of past jobs and current jobs

In our case the issue is we run the report through forms (frmweb.exe),

If we run 10 reports(short reports not long running reports) there will be same number of javaw.exe connections active while the reports are running in the database

our problem is when 2 r 3 reports gets hanged the other reports gets in queue and not executed successfully so to overcome this we altered the ENGINE LIFE to 1 in the report sever .conf file in the below given line...

<engine id="rwEng" class="oracle.reports.engine.EngineImpl" initEngine="1" maxEngine="1" minEngine="0" engLife="1" maxIdle="30" callbackTimeOut="90000"></engine>

by setting this parameter we came across other problem, When a report is fired and it fails due to some reason the javaw,exe process in the database gets disapperaed and the while querying the report status thro show jobs we c the report is still running ..in the current jobs....I try to kill the job but resulted in negative and not able to kill ,...so atlast we restart the report server

Is there any we can overcome the problem by altering any parameters or any other way to kill the jobs which results in hanging as per the scenario explained above in the application server other than restarting the whole report server engine

Can u tel me the outcomes and break-out by setting the parameter ENGINELIFE to 1 in the report server conf file will changing the parameters

I tried increasing the report sever engines but in vain..no solution to the above scenario yielded..

Pls help in thiis issue.....

Thanks in anticipation

Regards
Hariharan.T