Setting Max Pooled Statements is a very good change b/c it solves other problems too. If you make a change to your DB and are using SQL Server 2K and it's driver, you will get errors if you change a tables structure w/out resetting the data source in the CF Admin.
By setting the Max Pooled Statements to 0, you don't have to reset the data source. Ryan Duckworth Macromedia ColdFusion Certified Professional Uhlig Communications 10983 Granada Lane Overland Park, KS 66211 (913) 754-4272 -----Original Message----- From: Bert Dawson [mailto:[EMAIL PROTECTED] Sent: Monday, February 07, 2005 9:47 AM To: CF-Talk Subject: Re: "null null The error occurred on line -1." We used to be plagued with null null errors, followed by server hanging or restarting every hour during busy periods. We "fixed" it by setting "Max Pooled Statements" on the advanced dsn page in cfadmin to zero. MM are still trying to figure out why we were getting this, so i suppose its unlikely to be the same problem. But its worth a try. (preferably before embarking on weeks of tweaking around with various java settings, garbage collection, trawling through a "5 years in the making" codebase looking for problems) Cheers Bert On Mon, 7 Feb 2005 09:26:24 -0500, Gaulin, Mark <[EMAIL PROTECTED]> wrote: > Anybody know what this error (reporting by error.Diagnostics) means? > > null null > The error occurred on line -1. > > We got a four of them before a CFMX server stopped responding, but they were spread out over a few minutes. I don't know if it is directly related to the seize up or not, but it sure looks funny. > > Thanks > Mark ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193367 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
