Nevermind that, due to a typo it wasn't fully running the processing code. I'll try setting QUERYTIMEOUT next.
Thanks, -Ian On 01/06/16 11:30, Ian Evans wrote: > Robert, > > Thanks for the advice. The code was located in the sql query action > "results" pane, and so I first tried moving the code to a separate > results action after the query. With a few tweaks to account for that, > it worked just fine. I had no idea the query results processing fell > inside the timeout limits for a query. > > Thanks, > -Ian > > On 01/05/16 17:01, Robert Shubert wrote: >> In TS 7, timeouts are now standard errors so they can be caught. However, >> they don't always throw correctly and I believe this is what you are seeing. >> >> Try setting QUERYTIMEOUT much higher (like 900) and running your TAF again. >> >> Robert >> >> -----Original Message----- >> From: Ian Evans [mailto:[email protected]] >> Sent: Tuesday, January 05, 2016 4:22 PM >> To: [email protected] >> Subject: TeraScript-Talk: Strange empty error >> >> I'm experiencing a strange, empty error when trying to process a few >> thousand records of data. >> >> I am pulling a few thousand rows (2000-3000) from a SQL Server database, and >> then transforming that data, adding the transformed rows into a separate >> array to dump into a tab-delimited file. >> >> When I limit the SQL query to less than ~1300 records, it works fine. >> When I remove the limit, or raise it much higher, after about a minute or >> two, it returns an error with an empty stack trace (see attached >> screenshot.) When I comment out the processing code, and return something >> simple, such as the number of rows, or the returned rows themselves, it >> works fine. >> >> Because the error being returned is devoid of any helpful information, I >> cannot pinpoint what aspect of the processing code is causing the error, if >> it's the code at all. Is there an expression that is choking on a particular >> value in one of the rows? Is it having a stack overflow? Is it just taking >> too long to process all the records? I have no idea where to start >> troubleshooting this. >> >> Has anybody encountered this error before? >> >> >> >> ---------------------------------------- >> >> To unsubscribe from this list, please send an email to >> [email protected] with "unsubscribe terascript-talk" in the body. >> >> >> >> >> ---------------------------------------- >> >> To unsubscribe from this list, please send an email to >> [email protected] with "unsubscribe terascript-talk" in the body. >> >> > > > > ---------------------------------------- > > To unsubscribe from this list, please send an email to > [email protected] with "unsubscribe terascript-talk" in the body. > > ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe terascript-talk" in the body.
