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 > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
