It’s is a generic error and probably a Qry timeout situation, but probably need
more info to figure it out.
1. Probably first important to understand was version of TS are your running?
2. In order to trouble shoot, are you writing out the comma delimited as your
are processing?
If so there could be a clue there if you see that it always stops at the same
place?
3. Do you have debug turned on and are you getting any information from that?
If debug is turned on, also look in the terascript log in the log folder in
your configuration folder
of your main TS folder under programs.
4. You mentioned only a minute or two, which is a lot less than the normal
query timeout
which is 300 seconds, but double check the QUERYTIMEOUT=300 value in the
server.ini.
You could try increasing that it you think that your timing out at your current
set limit.
Please update with any of the above information.
Finding the exact reason for the crash is of course the best route, but another
work around
could be using a For loop and just structuring it so you process 1000-1200 at a
time.
Sincerely,
John
__________________________________________________
John Carrieri
Chairman
U. Inc.
__________________________________________________
#1 in College Search - http://www.colleges.com <http://www.colleges.com/>
Together We Save™ - http://www.greennet.com <http://www.greennet.com/>
__________________________________________________
“If you can not measure it, you can not improve it.”-Lord Kelvin
__________________________________________________
> On Jan 5, 2016, at 4:22 PM, Ian Evans <[email protected]> wrote:
>
> 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.
> <Screenshot_20160105_160644.png>
----------------------------------------
To unsubscribe from this list, please send an email to [email protected]
with "unsubscribe terascript-talk" in the body.
