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
