Hi,

We are getting the following error (not always, but often) when attempting to process a recurring order. It occurs in the checkoutreview.aspx.cs logic and only for a recurring order product. The error is on line 469.

Can you please provide insight as to why this may occur, and a possible fix, as it is causing significant issues for our customers...

Server Error in '/store' Application.

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
The statement has been terminated.

Source Error:



Line 467: OrderNumber = AppLogic.GetNextOrderNumber();

Line 468: }

Line 469: String status = Gateway.MakeOrder(String.Empty, AppLogic.TransactionMode(), cart, OrderNumber, String.Empty, String.Empty, String.Empty, String.Empty);

Line 470: if (status == AppLogic.ro_3DSecure)

Line 471: { // If credit card is enrolled in a 3D Secure service (Verified by Visa, etc.)


Source File: d:\domains\safetyculture.com.au\wwwroot\store\chec koutreview.aspx.cs Line: 469

Stack Trace:



[SqlException (0x80131904): The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

The statement has been terminated.]

AspDotNetStorefrontCore.DB.ExecuteSQL(String Sql) +229

AspDotNetStorefrontGateways.Gateway.MakeOrder(Stri ng PaymentGatewayToUse, String TransactionMode, ShoppingCart cart, Int32 OrderNumber, String CAVV, String ECI, String XID, String RecurringSubscriptionID) +15783

AspDotNetStorefront.checkoutreview.ProcessCheckout () in d:\domains\safetyculture.com.au\wwwroot\store\chec koutreview.aspx.cs:469

AspDotNetStorefront.checkoutreview.ContinueCheckou t() in d:\domains\safetyculture.com.au\wwwroot\store\chec koutreview.aspx.cs:158

AspDotNetStorefront.checkoutreview.btnContinueChec kout1_Click(Object sender, EventArgs e) in d:\domains\safetyculture.com.au\wwwroot\store\chec koutreview.aspx.cs:145

System.EventHandler.Invoke(Object sender, EventArgs e) +0

System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105

System.Web.UI.WebControls.Button.RaisePostBackEven t(String eventArgument) +107

System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +7

System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +11

System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +174

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5087