Tony, I had this happen when using gateway export XLS ...SELECT when the Select included a computation and the results of the computation resulted in a "divide by zero error".
GATEWAY EXPORT XLS <filename> SELECT column1,column2,column3,(column3 / column2)..... If column2 was 0, that throws a divide by zero error. In this case, I didn't want any of that data anyway, so I just changed my program to exclude those rows from the start. I don't know if it's the same issue with XML, but if you're using a computation in your select, that might just be the source of the issue. Now WHY a divide by zero error results in a file that never ends is beyond me, but I'm certain that was the case of my issue. Dawn Hast [email protected] wrote on 12/04/2009 05:02:18 PM: > Hi, > > I am encountering the following problem. > I have created a temporary table. > The next step is an export of this table as a XML-file. > Most of the times it is working well, but sometimes it happens that > the export goes on and on. The only thing that I can do is to > cancel the operation. To give you an idea. Normally the file is a > few hundred KB, but once I saw a file of 247 MB. > When I restart the program the problem has gone for a while and I > cannot find the logic behind it. > Has anyone had this experience too and found out a solution? > > Kind Regards, > > Tony IJntema > > > > > __________ Informatie van ESET NOD32 Antivirus, versie van database > viruskenmerken 4661 (20091204) __________ > > Het bericht is gecontroleerd door ESET NOD32 Antivirus. > > http://www.eset.com DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. Evergreen Packaging is not responsible for any changes made to this message and / or any attachments after sending by Evergreen Packaging. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment.
