OraFAQ Forum: Reports & Discoverer » problem is the export to Excel

Home » Developer & Programmer » Reports & Discoverer » problem is the export to Excel

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

problem is the export to Excel [message #298242]

Tue, 05 February 2008 07:59

amritaseema
Messages: 47
Registered: January 2008

Member

Hi,

The only problem i faced is the export to Excel. The first time I tried to export, nothing happened and my screen went blank. The second time, it ran for about 30 minutes and then I received attached error message.
"QUERY CANCELLED BECAUSE IT EXCEEDED QUERY TIEM LIMIT.."
so any one plzz help me out..

Thanks
Seema

Report message to a moderator

Re: problem is the export to Excel [message #298406 is a reply to message #298242]

Wed, 06 February 2008 01:11

ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India

Senior Member

hi amrita,

If you can use the TOAD then it would be very simple to transfer the data to the excel. Try this

Ashu

Report message to a moderator

Re: problem is the export to Excel [message #298414 is a reply to message #298406]

Wed, 06 February 2008 01:32

amritaseema
Messages: 47
Registered: January 2008

Member

Hi Ashu,
Bt i want to export it from Dicoverer DesKTOP/plus itself.
can u plzzz tell me how to oversome this ERROR...

Thanks
Seema.

Report message to a moderator

Re: problem is the export to Excel [message #298548 is a reply to message #298414]

Wed, 06 February 2008 05:58

srinu2466
Messages: 11
Registered: October 2005

Junior Member

Hi,

Are u used dde package.

Srinu

Report message to a moderator

Re: problem is the export to Excel [message #298556 is a reply to message #298548]

Wed, 06 February 2008 06:36

amritaseema
Messages: 47
Registered: January 2008

Member

Hi,
No i m nt used any dde package.
the report is based on a custom folder and in that smiple sql query is written.

Thanks
Seema

Report message to a moderator

Re: problem is the export to Excel [message #300151 is a reply to message #298556]

Thu, 14 February 2008 07:37

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

Did you retrieve all rows first (before starting the export)?
How many were there?

Report message to a moderator

Re: problem is the export to Excel [message #300823 is a reply to message #300151]

Mon, 18 February 2008 03:25

amritaseema
Messages: 47
Registered: January 2008

Member

ya i retrived all rows based on some conditions.
its nearly around 2290rows

Report message to a moderator

Re: problem is the export to Excel [message #301342 is a reply to message #300823]

Wed, 20 February 2008 02:27

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

That is weird, because the query time limit shouldn't go off for just the export I think. That limit has to do with retrieving rows, not with exporting them.
Still, it might be worth setting the limit higher and find out if the export then works. Or schedule the workbook and export the result, instead of doing it runtime.

Report message to a moderator

Re: problem is the export to Excel [message #380870 is a reply to message #298242]

Tue, 13 January 2009 11:38

anand3175
Messages: 2
Registered: March 2008
Location: USA

Junior Member

I think you have to increase the query run time in discoverer.
Click on Toool Menu and the Option menu.

Then go Query Governer Tab.

Increase the time for running the query in discoverer.

Put that to maximum time.

Prevent queries from running longer then

I guess that will solve your problem.

Report message to a moderator

Previous Topic:	Persian characters in PDF has a problem
Next Topic:	Character Mode Report Print In Landscape

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 08:18:32 CST 2024