Home » Developer & Programmer » Reports & Discoverer » problem is the export to Excel
icon7.gif  problem is the export to Excel [message #298242] Tue, 05 February 2008 07:59 Go to next message
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

Re: problem is the export to Excel [message #298406 is a reply to message #298242] Wed, 06 February 2008 01:11 Go to previous messageGo to next message
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
icon9.gif  Re: problem is the export to Excel [message #298414 is a reply to message #298406] Wed, 06 February 2008 01:32 Go to previous messageGo to next message
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.
Re: problem is the export to Excel [message #298548 is a reply to message #298414] Wed, 06 February 2008 05:58 Go to previous messageGo to next message
srinu2466
Messages: 11
Registered: October 2005
Junior Member
Hi,

Are u used dde package.

Srinu
icon9.gif  Re: problem is the export to Excel [message #298556 is a reply to message #298548] Wed, 06 February 2008 06:36 Go to previous messageGo to next message
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
Re: problem is the export to Excel [message #300151 is a reply to message #298556] Thu, 14 February 2008 07:37 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Did you retrieve all rows first (before starting the export)?
How many were there?
icon5.gif  Re: problem is the export to Excel [message #300823 is a reply to message #300151] Mon, 18 February 2008 03:25 Go to previous messageGo to next message
amritaseema
Messages: 47
Registered: January 2008
Member
ya i retrived all rows based on some conditions.
its nearly around 2290rows
Re: problem is the export to Excel [message #301342 is a reply to message #300823] Wed, 20 February 2008 02:27 Go to previous messageGo to next message
skooman
Messages: 912
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.
Re: problem is the export to Excel [message #380870 is a reply to message #298242] Tue, 13 January 2009 11:38 Go to previous message
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.




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


Current Time: Thu Dec 08 20:12:26 CST 2016

Total time taken to generate the page: 0.10364 seconds