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.
