OPPS. I failed to mention all of the queries are in a <CFTRANSACTION> tag
with the COMMIT or ROLLBACK dependent on a parent <CFTRY> tag to capture
errors. So, each time the insert query is run, it is either committed or
rolled back, on an individual basis. Being in a loop, this prevents an all
or none situation.
This was all working a few days ago. Maybe I'm not holding my mouth right?
Toungue needs to hang out the other side?
John Grubb
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 12, 2000 4:05 PM
To: CF-Talk
Subject: RE: SERVER TIMES OUT ON LONG SCRIPT
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
