Hey Luke,

Whenever someone tries to checkout through google, I get this error in the email.

Payment failed for the order# Google Checkout: 644314440621019

Please check the transaction detail in the store admin.

The transaction doesn't get created in store admin either.

I also get this exception stack

Timestamp: 8/3/2009 7:38:50 PM
Message: HandlingInstanceID: 2e36cf49-9cfe-41b5-920f-dc0fe14e7722
An exception of type 'System.NullReferenceException' occurred and was caught.
-----------------------------------------------------------------------------
08/03/2009 12:38:50
Type : System.NullReferenceException, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 Message : Object reference not set to an instance of an object.
Source : App_Web_okz6hghr
Help link :
Data : System.Collections.ListDictionaryInternal
TargetSite : Void ProcessNotification(System.String)
Stack Trace :    at GoogleCheckoutPostHandler.ProcessNotification(String requestXml) in c:\DSC\Web\Store\GoogleCheckoutPostHandler.aspx.cs:line 198
   at GoogleCheckoutPostHandler.Page_Load(Object sender, EventArgs e) in c:\DSC\Web\Store\GoogleCheckoutPostHandler.aspx.cs:line 74

Additional Info:

MachineName : SD9000
TimeStamp : 8/3/2009 7:38:50 PM
FullName : Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null AppDomainName : /LM/W3SVC/1/ROOT-3-128937916680390585
ThreadIdentity :
WindowsIdentity : NT AUTHORITY\NETWORK SERVICE

Category: General
Priority: 0
EventId: 100
Severity: Error
Title:Enterprise Library Exception Handling
Machine: SD9000
Application Domain: /LM/W3SVC/1/ROOT-3-128937916680390585
Process Id: 432
Process Name: c:\windows\system32\inetsrv\w3wp.exe
Win32 Thread Id: 1252
Thread Name:
Extended Properties: Google Order# - 644314440621019




I am not sure what the problem is.

The API callback url is this: https://www.sd9000.com/Store/GoogleCheckoutPostHandler.aspx


and Callback method XML.


Thanks

 

 

This exception simply says there is no such Google Order# - 644314440621019 in the system. Usually Google Checkout sends out "New Order" notification first which creates the order in DotShoppingCart system. Check if you can find any other exceptions happened before this one.

Here

 

Timestamp: 8/3/2009 7:23:35 PM
Message: HandlingInstanceID: 7c34ed05-de1b-4c00-bbb6-867185f2311d
An exception of type 'System.Data.SqlClient.SqlException' occurred and was caught.
----------------------------------------------------------------------------------
08/03/2009 12:23:35
Type : System.Data.SqlClient.SqlException, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 Message : Error converting data type nvarchar to numeric.
Source : .Net SqlClient Data Provider
Help link :
Errors : System.Data.SqlClient.SqlErrorCollection
Class : 16
LineNumber : 63
Number : 50000
Procedure : DSC_Order_AddByExternalData
Server : .\SQLExpress
State : 5
ErrorCode : -2146232060
Data : System.Collections.ListDictionaryInternal
TargetSite : Void OnError(System.Data.SqlClient.SqlException, Boolean)
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 DotShoppingCart.Commercial.Core.Order.Add(String userName, String email, String shippingMethod, Address shippingAddress, Address billingAddress, CheckoutPaymentTypeEnum checkoutPaymentType, CreditCard creditCard, List`1 orderTotals, List`1 items, String customField, Int32 orderStatusId, Nullable`1 referralId)
   at GoogleCheckoutPostHandler.ProcessNotification(String requestXml) in c:\DSC\Web\Store\GoogleCheckoutPostHandler.aspx.cs:line 147
   at GoogleCheckoutPostHandler.Page_Load(Object sender, EventArgs e) in c:\DSC\Web\Store\GoogleCheckoutPostHandler.aspx.cs:line 74

Additional Info:

MachineName : SD9000
TimeStamp : 8/3/2009 7:23:35 PM
FullName : Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null AppDomainName : /LM/W3SVC/1/ROOT-3-128937916680390585
ThreadIdentity :
WindowsIdentity : NT AUTHORITY\NETWORK SERVICE

Category: General
Priority: 0
EventId: 100
Severity: Error
Title:Enterprise Library Exception Handling
Machine: SD9000
Application Domain: /LM/W3SVC/1/ROOT-3-128937916680390585
Process Id: 432
Process Name: c:\windows\system32\inetsrv\w3wp.exe
Win32 Thread Id: 1252
Thread Name:
Extended Properties: HelpLink.ProdName - Microsoft SQL Server HelpLink.ProdVer - 10.00.2531 HelpLink.EvtSrc - MSSQLServer HelpLink.EvtID - 50000 HelpLink.BaseHelpUrl - http://go.microsoft.com/fwlink HelpLink.LinkId - 20476 Google Order# - 644314440621019
 

What's your order number schema? If it consists non numeric characters, you will need to update the store procedure DSC_Order_AddByExternalData. Especially the following line.

 

SET @OrderNumber = CAST(CAST(@OrderNumber AS DECIMAL) + 1 AS NVARCHAR(50)) 

Ya that was the problem. My order number schema is SD#####

 

I fixed the stored procedure, now its working fine.

 

Thanks