We currently get about 400,00 hits per day on a cluster of CF 4 servers we have and about 900,000 transactions per day to our 3 read MS SQL7 databases. I have developed about 40 stored procedures that limited about 90% of the CFQUERIES to Stored procs. My questions is about 20 times a day we get errors that refer to the stored proc and refer to a Communication link failure or a Serialization error. Anyone know what this is? I do not a a pattern between Procs, CF Server, Read Databases, Browsers, Date/Time, or datasource... Just happens on it's own.. Begin the actually message..... Date and Time : 08/17/01 21:36:56 Error Message : ODBC Error Code = 08S01 (Communication link failure)<P> Template Affected: D:\WEBFILES\EGCWEB\WELCOME.HTML Query String : Browser Used: Mozilla/4.0 (compatible; MSIE 5.0; AOL 6.0; Windows 98; DigExt) Error Type : DATABASE HTTP Referer : Diagnostics : ODBC Error Code = 08S01 (Communication link failure)<P> [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.<P><P>SQL = "emp_featured_list"<P>Data Source = "webdb"<P><p>The error occurred while processing an element with a general identifier of (CFSTOREDPROC), occupying document position (44:3) to (44:83) in the template file d:\Webfiles\Tags\Common\featured.cfm.</p> Client IP Address is: 205.188.209.104 Server ID: www2 Generated Content: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
