OraFAQ Forum: Reports & Discoverer » long running report

Home » Developer & Programmer » Reports & Discoverer » long running report (forms n reports 10g windows server2003)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

long running report [message #473424]

Sat, 28 August 2010 03:10

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.

Report message to a moderator

Re: long running report [message #473425 is a reply to message #473424]

Sat, 28 August 2010 03:49

ranamirfan
Messages: 500
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Check your Report Query how much take time to run at SQL prompt.

Report message to a moderator

Re: long running report [message #473426 is a reply to message #473425]

Sat, 28 August 2010 03:55

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...

Report message to a moderator

Re: long running report [message #473427 is a reply to message #473426]

Sat, 28 August 2010 04:09

ranamirfan
Messages: 500
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');

Report message to a moderator

Re: long running report [message #473431 is a reply to message #473427]

Sat, 28 August 2010 04:32

USER20
Messages: 27
Registered: August 2010
Location: INDIA

Junior Member

thanx i will check it and get back to you on monday.

Report message to a moderator

Re: long running report [message #473438 is a reply to message #473431]

Sat, 28 August 2010 05:38

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?

Report message to a moderator

Re: long running report [message #473468 is a reply to message #473438]

Sat, 28 August 2010 13:27

Littlefoot
Messages: 16963
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

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..

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 21 09:38:48 CDT 2013

Total time taken to generate the page: 0.15960 seconds