Showing results for 
Search instead for 
Did you mean: 

Web Tools COD-Based Order Throws Exception

Former Member
0 Kudos

After trying to place an online order via COD, I received this error:

Version 2007.0.625.0

Message Cannot insert the value NULL into column 'AccountExpiration', table 'B1WebTools_625.dbo.UsersWallet'; column does not allow nulls. INSERT fails. The statement has been terminated.

Source .Net SqlClient Data Provider

Stack at SQL, IDataParameter[] parameters, String connectionstring)

at netpoint.api.account.NPWallet.Save()

at ThirdMind.commerce.controls.PaymentBlock.AddPayment()

at ThirdMind.commerce.controls.PaymentBlock.SubmitPayment()

at ThirdMind.commerce.billing.a(Object A_0, ImageClickEventArgs A_1)

at System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e)

at System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument)

at System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)

at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)

at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)

at System.Web.UI.Page.ProcessRequestMain

Is it possible that the UsersWallet table structure needs to be updated to allow the AccountExpiration field to have NULLs, or is it simply a bug? In either case, is this fixed in a later version?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Micheal,

This is a known issue with 625.

The bug has been fixed, but it would require and upgrade.

Answers (0)