IIS 5 & IIS 6
Strangle Application Pool issuse, maybe!
Last post Nov 28, 2008 12:24 PM by chriskentfield
Sep 09, 2008 03:42 AM|art99|LINK
We have a load balanced environment running a 64 bit VB ASP.Net 2 application on windows 2003 64 SP 2 with IIS 6. Every now and again, which can be a day to a week; we randomly encounter on one of the servers the follow error which can only be sorted by
restarting the application pool.
Conversion from string "08/09/2008 15:57:01" to type 'Date' is not valid. ===========================================================
Microsoft.VisualBasic.CompilerServices.Conversions.ToDate(String Value) at CompanyX.SQL.GetSqlValue(Object oValue, String sType) at ProductX.Booking.CalculatePayments(BookingComponent oComponent) at ProductX.PropertyBooking.Calculate() at ProductX.TPSupport.Price(Booking
oBooking, ArrayList aOnlineSearchIDs, String Source) at ProductX.Booking.CreateBooking(ArrayList aOnlineSearchIDs, Boolean bFlightIncluded, Boolean ClearAllFlights) at PXOnline.cbResults.Book(String Type, Int32 iOnlineSearchID) at PXOnline.cbResults.Page_Load(Object
sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
This error points to a single line of code which converts a Sting to a Date and works throughout the application without a problem until the application pool starts playing up, but I have no evidence that it is the application pool only other than a recycle
stops the error. The line of code will process Dates millions of times a day across the load balanced servers and as you can see the error is incorrect as the date is valid. If a run the same command on one of the other servers it works fine.
All servers are running the same code are identical in spec and have the same service patches installed.
Any ideas, or am I barking up the wrong tree thinking it’s something to do with IIS?
Sep 09, 2008 03:49 AM|art99|LINK
many thanks for moving this post to the correct forum
Sep 25, 2008 02:54 PM|ducktaped|LINK
Sep 25, 2008 02:56 PM|ducktaped|LINK
art99... or anyone else... did you every figure this one out. I have the same problem
Sep 29, 2008 04:31 AM|art99|LINK
For some reason the SP had not been wrapped up in a transaction so when the block was happening it was bombing out half way through with incomplete data which was causing the error message.
We have modified the SP and fine tuned the blocking processes with the following Select and Update hints, WITH (NOLOCK) and WITH (ROWLOCK) respectively, Since then we have not had a recurrence of the problem.
Oct 28, 2008 07:48 PM|art99|LINK
Have to report that even though the SQL Server blocking issue is fixed the error "Converson from string...." has reared its head a again.
Nov 28, 2008 12:24 PM|chriskentfield|LINK