Home » Developer & Programmer » Reports & Discoverer » long running report (forms n reports 10g windows server2003)
long running report [message #473424] Sat, 28 August 2010 03:10 Go to next message
USER20
Messages: 27
Registered: August 2010
Location: INDIA
Junior Member
Hii..
I am running my report on web called through forms.
I am having one report that takes 25 minutes to generate.Meanwhile no other user or even same user is able to generate any other report..Is this phenomena normal?
I have forms n reports on one server and database on another and having around 20 users.

Re: long running report [message #473425 is a reply to message #473424] Sat, 28 August 2010 03:49 Go to previous messageGo to next message
ranamirfan
Messages: 529
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Check your Report Query how much take time to run at SQL prompt.
Re: long running report [message #473426 is a reply to message #473425] Sat, 28 August 2010 03:55 Go to previous messageGo to next message
USER20
Messages: 27
Registered: August 2010
Location: INDIA
Junior Member
It has a simple query but has many formula.But that is not my concern for the time being.I want to know that if am runnig this report will i able to run any other report at the same time?
If yes then what settings i need to change...
Re: long running report [message #473427 is a reply to message #473426] Sat, 28 August 2010 04:09 Go to previous messageGo to next message
ranamirfan
Messages: 529
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Yes,you can run another report at same time on web.

Use '_Blank' to open documents in a new web browser.
Web.Show_Document('http://hoitvoltes5:9002/reports/rwservlet?usr'||'&report='||v_report_name||'&desformat='||v_format||'&companyid='||:voucher.companyid||'&vouno='||:voucher.vouno,'_blank');


Re: long running report [message #473431 is a reply to message #473427] Sat, 28 August 2010 04:32 Go to previous messageGo to next message
USER20
Messages: 27
Registered: August 2010
Location: INDIA
Junior Member
thanx i will check it and get back to you on monday.
Re: long running report [message #473438 is a reply to message #473431] Sat, 28 August 2010 05:38 Go to previous messageGo to next message
USER20
Messages: 27
Registered: August 2010
Location: INDIA
Junior Member
Ok..i just incorporated what you said...It is now opening in new window but it generates the data only after the first report has generated the data..So is it not possible that to simultaneosusly generate it?
Re: long running report [message #473468 is a reply to message #473438] Sat, 28 August 2010 13:27 Go to previous messageGo to next message
Littlefoot
Messages: 19474
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you talk to your DBA? What did he/she say about reports server configuration?

[Updated on: Sat, 28 August 2010 13:27]

Report message to a moderator

Re: long running report [message #473524 is a reply to message #473468] Mon, 30 August 2010 00:28 Go to previous message
USER20
Messages: 27
Registered: August 2010
Location: INDIA
Junior Member
My dba is new to forms and report..So if know which things need to be configured i can do it..
Previous Topic: select weeks number per months and year as 1 .....52 week on matrix report 6i (merged)
Next Topic: Ora-0999: Unimplemented Error Patches enquiry
Goto Forum:
  


Current Time: Thu Aug 21 07:56:10 CDT 2014

Total time taken to generate the page: 0.10701 seconds