A cross query (xquery) between Oracle and Sharepoint executes OK in the Editor. The query itself can take up to 20 mins to run, but does return expected results. After adding this query to an Export Wizard (in Automation) and clicking 'Next' , Toad will hang and eventually crashes. On occasion, Toad will produce the following timeout error rather than hang:
"Schema read error:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding"
WORKAROUND
For automation, use a 'Select to file' to run the query and export to Excel. If the output needs to go to a Sharepointlist, this Excel file can then be queried in an 'Export Wizard' template to export to the Sharepoint list.
STATUS
Issue fixed in version 4.2. The latest release can be downloaded here.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center