HomeHome Product Discus... Product Discus...SmithCartSmithCart Error processing payment - Authorize.net Error processing payment - Authorize.net
Previous
 
Next
New Post
10/2/2013 3:14 PM
 
Get this error no matter what whether in test mode or live for Authorize.net payment gateway. 

Error processing payment. Please try again. SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

Please advise.

Dustin
 
New Post
10/3/2013 12:24 PM
 
Hi Dustin,

Could you please provide what version of the Cart and DNN you are currently running? In addition, if you could please provide a screen shot of the error in your DNN event viewer it will help to further determine the cause of the issue.

Please let me know if you have anymore questions. Thank you!
 
New Post
10/3/2013 12:39 PM
 
Using lastest version of cart 5.64 and DNN 7.0.5

This is the error in the Event Viewer:

Cart Error: at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc, Boolean sync, TaskCompletionSource`1 completion, Int32 startRpc, Int32 startParam) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at Smith.DNN.Modules.BuyNow.SqlDataProvider.AddCustomerAdmin(CustomerInfo info) at Smith.DNN.Modules.BuyNow.Confirm.a(PaymentStatus A_0, Boolean A_1) at Smith.DNN.Modules.BuyNow.Confirm.Submit() at Smith.DNN.Modules.BuyNow.Confirm.btnSubmit_Click(Object sender, EventArgs e)

Server Name: CT389

Screen shots of the cart error are attached.
 
 Login to download attachment
New Post
10/3/2013 4:24 PM
 
Hi Dustin,

I tested the issue and I was able to complete a one time transaction using Auth.net in the latest version of the cart. May I ask if you have any recurring billing settings configured? I believe the issue your experiencing exists in 5.64 and has since been resolved in 5.65. I recommend installing 5.65 and the issue should be resolved.

Please note: It is always highly recommend that you have a full backup stored before upgrading the cart

Please let me know if you have anymore questions. Thank you!
 
New Post
10/3/2013 4:57 PM
 
 I just purchased the license this week off of the DNN store and the only version available for download is version 5.64. Please send me version 5.65 and license key if needed for that version.

dustin
 
New Post
10/3/2013 5:23 PM
 
Hi Dustin,

I have given you access to our downloads page at the link below. You will have access for three months which is the warranty included with your SmithCart purchase. We release new versions of the cart frequently with bug fixes, security patches and new features which provides a level of protection for your ecommerce site.

http://www.smith-consulting.com/Support/SmithCartDownloads.aspx

Please let me know if you have anymore questions. We appreciate your business very much. Thank you!
 
New Post
10/3/2013 6:17 PM
 
I have upgrade the cart and get the same exact error.

Dustin
 
New Post
10/3/2013 6:27 PM
 
I now believe my client has been giving me the wrong API Login and Transaction Key. Ill look into this further please don;t worry about exploring this issue further.

Dustin
 
New Post
10/4/2013 2:31 PM
 
Thanks Dustin. Let us know if we can help with anything else.
 
New Post
11/1/2013 3:12 PM
 
I'm getting this same error. I'm on SC 5.64 and DNN 7.0.06. 

I've gotten the API Login and Transaction Key straight from Auth.net so I'm pretty sure they are good. 

I do not have recurring billing. Can you give me access to download the latest version to see if this fixes it?

Thanks,

Tom
 
 Login to download attachment
New Post
11/1/2013 3:50 PM
 
Hi Tom,

For access to v5.65 of the Cart you will need access to the SmithCart Downloads page. Please submit a ticket to our Licensing Dept at the following link and we will check on your upgrade eligibility - http://www.smith-consulting.com/Suppo...

Thanks!
 
New Post
11/2/2013 8:13 AM
 
Upgraded to 5.65. Still getting the same error. 

What's next?

Tom
 
New Post
11/4/2013 12:51 PM
 
Hi Tom,

Are you using a live or test Auth.net account?

Is Auth.net virtaul terminal set to "Test Mode"?

Do you have "Test Mode" enabled or disabled in your Cart?

Are there any errors being logged to your DNN Event Viewer?

Thanks!
 
New Post
11/4/2013 1:13 PM
 
Kevin Carlson wrote:
Hi Tom,

Are you using a live or test Auth.net account?

Is Auth.net virtaul terminal set to "Test Mode"?

Do you have "Test Mode" enabled or disabled in your Cart?

Are there any errors being logged to your DNN Event Viewer?

Thanks!

 I am using a Live account. Your question on whether Virtual Terminal is in Test Mode is somewhat confusing. Virtual Terminal seems to be a way to manually enter a CC transaction and doesn't have a Test Mode that I can see. The account itself is in Test Mode however so I assume that's what you mean.

The Cart is also in Test Mode. Should one of the two Test Modes be switched off?

Yes, I get the following in the Event log when this happens.

Cart Error: at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc, Boolean sync, TaskCompletionSource`1 completion, Int32 startRpc, Int32 startParam) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at Smith.DNN.Modules.BuyNow.SqlDataProvider.AddCustomerAdmin(CustomerInfo info) at Smith.DNN.Modules.BuyNow.RegistrationController.AddCustomerAdmin(CustomerInfo info) at Smith.DNN.Modules.BuyNow.Confirm.ProcessStatus(PaymentStatus status, Boolean success) at Smith.DNN.Modules.BuyNow.Confirm.Submit() at Smith.DNN.Modules.BuyNow.Confirm.btnSubmit_Click(Object sender, EventArgs e)

Server Name: Generic171


 
New Post
11/4/2013 3:00 PM
 
Hi Tom,

Since real money gets moved when tesing with a live account, to test transactions you need to use a test account from authorize.net that you get here http://developer.authorize.net/testaccount/

Not your live account in test mode, there is a difference

The following forum post should also help: also http://www.smith-consulting.com/forums/forumid/1/postid/232/scope/posts.aspx#232

If your Auth.net live account is in "Test Mode", the Cart shoud NOT have "Test Mode" enabled.

Hope this helps!
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCart Error processing payment - Authorize.net Error processing payment - Authorize.net