Payment by check not working for me

AbleMods · Post by **AbleMods** » Fri Dec 14, 2007 11:48 am

I'm getting the following event log error when testing the Payment by Check using PayPal as the gateway. It properly shows the fields for check entry, but dies when you click the 'pay by check' button. The order gets stored and shows a payment capture failed status.

The "Retry Capture" doesn't help - that just posts it as paid even though it never went through.

Thoughts?

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 12/14/2007
Time: 1:47:07 PM
User: N/A
Computer: SOL01
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 12/14/2007 1:47:07 PM
Event time (UTC): 12/14/2007 6:47:07 PM
Event ID: 82517034aa3847ba9fb917abb285b1a8
Event sequence: 5052
Event occurrence: 4
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/1838475879/Root-1-128420692789693476
Trust level: Full
Application Virtual Path: /
Machine name: SOL01

Process information:
Process ID: 424
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:
Exception type: SqlException
Exception message: String or binary data would be truncated.
The statement has been terminated.

Request information:
Request URL: https://www.solunar.com/Checkout/Default.aspx
Request path: /Checkout/Default.aspx
User host address: 76.125.2.102
Is authenticated: True
Authentication Type: Forms
Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:
Thread ID: 7
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteScalar(DbCommand command)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteScalar(DbCommand command)
at CommerceBuilder.Payments.Transaction.Save()
at CommerceBuilder.Common.PersistentCollection`1.Save()
at CommerceBuilder.Payments.Payment.SaveChildren()
at CommerceBuilder.Payments.Payment.BaseSave()
at CommerceBuilder.Payments.Payment.Save()
at CommerceBuilder.Payments.PaymentEngine.DoAuthorize(AuthorizeTransactionRequest request, Boolean async)
at CommerceBuilder.Payments.PaymentEngine.DoAuthorize(AuthorizeTransactionRequest request)
at CommerceBuilder.Payments.Payment.Authorize(Boolean async, String remoteIP)
at CommerceBuilder.Orders.Basket.Checkout(CheckoutRequest checkoutRequest, Boolean validate, Boolean triggerEvents)
at CommerceBuilder.Orders.Basket.Checkout(CheckoutRequest checkoutRequest)
at ASP.CheckPaymentForm.CheckButton_Click(Object sender, EventArgs e)
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.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(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

jmestep · Post by **jmestep** » Fri Dec 14, 2007 1:35 pm

Do you have to have a special configuration in Paypal for payment by check?

AbleMods · Post by **AbleMods** » Fri Dec 14, 2007 1:55 pm

I thought the standard website payments pro included it...

compunerdy · Post by **compunerdy** » Fri Dec 14, 2007 5:16 pm

Are you referring to E-checks?

AbleMods · Post by **AbleMods** » Fri Dec 14, 2007 7:09 pm

yes it allows you to enter bank name, routing number, checking account number etc and draws the payment from your checking rather than a credit card.

Post by **Shopping Cart Admin** » Fri Dec 14, 2007 7:50 pm

Hello All,

E-Check is implemented in Authorize.NET and LinkPoint. If there are additional gateways that support it, we'll add it. But it's not an oft requested feature.

AbleMods · Post by **AbleMods** » Sat Dec 15, 2007 7:26 am

Thank you for the clarification Mike.

It may not be possible, but it sure would be a great feature down the road to make the method setup know which methods are supported by which gateways. That way a user can't add an unsupported gateway i.e. I won't shoot my foot off as much as usual

jmestep · Post by **jmestep** » Sat Dec 15, 2007 8:26 am

Joe, if you do get in to E Check make sure you read all the small print. In most of the programs the check isn't guaranteed until it clears the bank so you wouldn't want to ship the order until then.

AbleMods · Post by **AbleMods** » Sat Dec 15, 2007 10:17 am

Yeah, back in the days of my PayPal BuyNow buttons, PayPal was pretty good about letting me know a check payment was made and when it actually cleared.

It would seem to me that giving the visitor more payment options would be a good thing - has that been true from your experience?

jmestep · Post by **jmestep** » Sat Dec 15, 2007 12:23 pm

Yes, you are right-giving them more payment methods is a good thing. When we tried an online-check method, we lost a chunk because someone thought the checks were OK and went ahead and sent the product. People who mail a check know they have to wait for the check to clear. People who used electronic checks thought their product would be shipped out right away. For us, it turned out to be more of a hassle to wait for the check to clear, so we did get a check authorization machine, but the protection doesn't cover online checks, checks without name and address printed on the check, and other criteria.
Online checks- people can submit them using someone else's bank account or even using info from blank checks that come with charge account statements.
We tried eBillMe for a while and that check method is where the customer gets an email with payment info after placing an order and then they log in to their own online banking and pay the bill. That way, the checks are guaranteed. We just didn't have very many customers using it. You can check on that from http://www.ebillme.com. They have a module for Able 5.5, but I don't know if it would integrate with AC7. Some large websites, like TigerDirect offer that method.

AbleMods · Post by **AbleMods** » Sat Dec 15, 2007 1:05 pm

Excellent info. I think I'll ponder some more on it before opening that door.

I have several customers who have expressed grave concerns about entering their CC info online. Accepting checks isn't going to alleviate that concern.

compunerdy · Post by **compunerdy** » Sun Dec 16, 2007 1:12 am

With my current store we use paypal pro exclusively and if a customer paid with a e-check it would mark it as paid so we would have to watch the e-mails closely or check paypal to see which where e-checks. I dont know if it is possible to setup a store to mark a paypal e-check as pending and then update it to paid when it clears or not. It sure would be a nice addition if it did.