I'm not parsing it, I'm letting CFHTTP turn it into a query and referencing the values that way. I've learned that CFHTTP is extremely particular about the files it accepts for a query. But this in the data between double quotes!
I have to assume that it's CFHTTP that chokes because the code writes the temp file just before the CFHTTP call and I can see that when it bombs the temp file just appears. But I have the CFHTTP call in a CFTRY block (because I email myself if there's a problem since this is a regularly scheduled unattended process) and nothing happens. But since the no error is written to the log and the server restarts, I shouldn't expect a throw either. ;p > Lets see you parsing code. Maybe that is the issue. Also what OS are you > using? > > On Sat, 13 Jul 2002, Tony Schreiber wrote: > > > I have a program that process text order files from various Internet > > marketplaces (half.com, Amazon, etc.) and since last night, the script > > that processes the Half.com files was bombing out and causing the server > > to restart: > > > > "Fatal","1776","07/13/02","13:43:23",,"Unknown error threshold reached. > > Restarting service." > > "Information","1796","07/13/02","13:43:26",,"The ColdFusion Application > > Server started." > > > > There is no error logged in the application.log file (CF5) and the error > > presented to the calling page is: > > > > Request canceled or ignored by server Server 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) > > > > Fine. After determining that the code has not changed (hasn't changed in > > months), I started to look at the files that I was processing. Each file > > is first prepped because the column names in the file have spaces (!) then > > are written to a temp file which is then called by CFHTTP to read it in as > > a query object. > > > > I suspected the first file, so I renamed the first two so they wouldn't > > be picked up and the script ran fine. Renamed the second to the last back > > and the script ran fine. Renamed the first back and the script bomb. Ok, > > problem file found. > > > > Looking at the data (names changed to protect the innocent.) It looks ok, > > nothing odd. Oh wait, one section looks like this: > > > > ORDER ID,INVOICE ID,SHIPPING METHOD,CREATE DATE,SHIP_TO > > >NAME,ADDRESS1,ADDRESS2,CITY,STATE,ZIP,COUNTRY,TITLE,CONTRIBUTOR,FORMAT,PRICE,CODE,ITEM > > ID,SELLER NOTES,SHIP_TO_FIRSTNAME,SHIP_TO_LASTNAME,STOREINVID > > 243518165308,211950252252,"Media Mail",07/12/2002 23:32,"First > > Name","123 S. 123st St.","Apt. > > BBB-205","Springfield","IL","98032","USA","The > > Best Of The Rubble Collection Vol. 1...","Various > > Artists","CD",11.55,"604388442126",195979304,"Seller SKU: > > mem-604388442126-2; Product Codes: > > UPC:604388442126","First","Name","mem-604388442126-2" > > > > See those three periods? "..."? I took those out. Saved the file and the > > script ran fine... > > > > HTF can three periods restart my cf server? > > > > Tony Schreiber, Senior Partner Man and Machine, Limited > > mailto:[EMAIL PROTECTED] http://www.technocraft.com > > > > http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion > > http://www.is300.net ___________The Enthusiast's Home of the Lexus IS300 > > http://www.digitacamera.com ______________DigitA Camera Scripts and Tips > > http://www.linklabexchange.com _____________Miata Link ECU Data Exchange > > > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
