Lets see your code. On Sat, 13 Jul 2002, Tony Schreiber wrote:
> 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 > > > > > > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
