Intermittent "Internal connection fatal error" and various other errors
Posted on 2011-05-12
About two of these per hour during business hours. About half or more are "Internal connection fatal error"; a list of others is available on request.
A SQL connection object is opened and closed (barring errors) for exactly one stored procedure call at a time.
Most of the CPU time on both the web server and the database server is spent populating work tables, exporting a Crystal Reports form to PDF, and sending the PDF to the web user as a download. Reports with a large volume of data are more prone to error, but tiny database calls (e.g. returning all data from a single table with less than 10 rows) also sometimes run into errors.