A reasonable guess:
Servers have a limit on the number of transactions they can handle at one
time without doing a commit. I don't remember specifics, so I'm not even
going to guess at the size. From what I can see, this sounds like the
server is filling up its transaction buffer and dumping you.
You could do a commit after every X records, but that has a problem too; if
your script crashes in the middle, you have some records that have been
processed and some that haven't. With a file of 225K lines, that could get
a little hairy to find the stopping point.
Personally, I'd break the big file apart into smaller ones that the server
can handle.
Brian
-----Original Message-----
From: John Grubb [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 12, 2000 3:31 PM
To: CF-Talk
Subject: SERVER TIMES OUT ON LONG SCRIPT
I am running a script that, basically, loops over a file of about 225,000
lines (opened via <CFFILE>), parses the separate data elements from the
fields in each line, puts each substring in a variable, then does an insert
query of that record, using the variables, into a couple of tables in an MS
SQL 2000 database. Once the entire file has been read, parsed and inserted,
I clear the file variable, send a javascript document.write to an html fram
to show the progressopen the next template (have also used a <CFINCLUDE>),
which resets some flags in the database via an UPDATE.
After the insert query, I get the following error:
Error Occurred While Processing Request
Error Diagnostic Information
Request canceled or ignored by serverServer busy or unable to fulfill
request. The server is unable to fulfill your request due to
extremely high traffic or an unexpected internal error. Please attempt your
request again (if you are repeatedly unsuccessful you
should notify the site administrator). (Location Code: 26)
Please inform the site administrator that this error has occurred (be sure
to include the contents of this page in your message to the
administrator).
Any ideas?
John Grubb
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
