# Toad automation - Export Wizard

**URL:** <https://forums.toadworld.com/t/toad-automation-export-wizard/39795>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [August 2, 2017, 10:06am UTC](https://forums.toadworld.com/t/toad-automation-export-wizard/39795 "2017-08-02T10:06:34Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![AlexBl](https://avatars.discourse-cdn.com/v4/letter/a/858c86/32.png) [@AlexBl](https://forums.toadworld.com/u/AlexBl)\
**Post date:** [August 2, 2017, 10:06am UTC](https://forums.toadworld.com/t/toad-automation-export-wizard/39795/1 "2017-08-02T10:06:34Z")

</div>

Hello,

I’m trying to export query from my local storage . I would need to create an automation process to be done each week for this query.

After 10 min run I get Error:" Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.’

I tried to run the query in editor and it is done after 5 min.

I tried to increase timeouts times to 9999 at Tools-\>option-\>database-\>Timeouts. - still received the same error

I also restarted the computer - still received the same error.

I tried to export with “Select to File” and the query populated the file correctly.

would you please advice and additional action that can be done.

Thanks,

AlexBl

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [August 2, 2017, 11:41am UTC](https://forums.toadworld.com/t/toad-automation-export-wizard/39795/2 "2017-08-02T11:41:17Z")

</div>

What version of TDP are you using? I assume you are using an export wizard template to export? can you turn on verbose logging, produce the error and then post the automation log so i can have a look? This error means somewhere we are executing on the UI thread and it has time out of 15 minutes. We did work on this recently and I need to see if this is fixed in current code.

---

<div class="post-metadata">

**Author:** ![AlexBl](https://avatars.discourse-cdn.com/v4/letter/a/858c86/32.png) [@AlexBl](https://forums.toadworld.com/u/AlexBl)\
**Post date:** [August 2, 2017, 12:20pm UTC](https://forums.toadworld.com/t/toad-automation-export-wizard/39795/3 "2017-08-02T12:20:05Z")

</div>

I’m using 3.8 Version.

I’m adding the query through export wizard template to export.

I choose add -\> query-\> I paste the query details - \> click “Next”

then after 10 min I receive the error. The file didn’t finish running so I don’t have the log file.

Appreciate your advice

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [August 2, 2017, 1:27pm UTC](https://forums.toadworld.com/t/toad-automation-export-wizard/39795/4 "2017-08-02T13:27:58Z")

</div>

That I recognize and was fixed in TDP 4.2. Can you upgrade? The issue below also included long running query and timing out.

Export Wizard  
N/A  
Corrected an issue that caused Toad to hang after selecting a very large table or a query with a large result set on the Select Objects page of the Export Wizard.  
QAT-8401

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [August 8, 2017, 8:16pm UTC](https://forums.toadworld.com/t/toad-automation-export-wizard/39795/5 "2017-08-08T20:16:17Z")

</div>

Did you get a chance to check out TDP 4.2?

---

<div class="post-metadata">

**Author:** ![AlexBl](https://avatars.discourse-cdn.com/v4/letter/a/858c86/32.png) [@AlexBl](https://forums.toadworld.com/u/AlexBl)\
**Post date:** [August 9, 2017, 6:43am UTC](https://forums.toadworld.com/t/toad-automation-export-wizard/39795/6 "2017-08-09T06:43:34Z")

</div>

Yes, the problem was solved in TDP 4.2. Thank you for your help
