Here is the response from Google in our integration panel...
...and here is the XML response:265163950479301
Time of occurrence: May 15, 2009 12:42:46 AM EDT
Error: We encountered an error trying to access your server at https://www.poolgeek.com/Checkout/Googl ... tener.ashx -- the error we got is Send failed with code: 500. Response body was: <html> <head> <title>The UPDATE statement conflicted with the FOREIGN KEY constraint "ac_Countries_ac_Addresses_FK1". The conflict occurred in database "AbleCommerce", table "dbo.ac_Countries", column 'CountryCode'.<br>The statement has been terminated.</title> <style> body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;} p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px} b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px} H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red } H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon } pre {font-family:"Lucida Console";font-size: .9em} .marker {font-weight: bold; color: black;text-decoration: none;} .version {color: gray;} .error {margin-bottom: 10px;} .expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; } </style> </head> <body bgcolor="white"> <span><H1>Server Error in '/' Application.<hr width=100% size=1 color=silver></H1> <h2> <i>The UPDATE statement conflicted with the FOREIGN KEY constraint "ac_Countries_ac_Addresses_FK1". The conflict occurred in database "AbleCommerce", table "dbo.ac_Countries", column 'CountryCode'.<br>The statement has been terminated.</i> </h2></span> <font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif "> <b> Description: </b>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. <br><br> <b> Exception Details: </b>System.Data.SqlClient.SqlException: The UPDATE statement conflicted with the FOREIGN KEY constraint "ac_Countries_ac_Addresses_FK1". The conflict occurred in database "AbleCommerce", table "dbo.ac_Countries", column 'CountryCode'.<br>The statement has been terminated.<br><br> <b>Source Error:</b> <br><br> <table width=100% bgcolor="#ffffcc"> <tr> <td> <code><pre> Line 39: NewOrderNotification N1 = (NewOrderNotification)EncodeHelper.Deserialize(RequestXml, typeof(NewOrderNotification)); Line 40: NewOrderHandler nhandler = new NewOrderHandler(N1); <font color=red>Line 41: nhandler.Process(); </font>Line 42: break; Line 43: case "risk-information-notification":</pre></code> </td> </tr> </table> <br> <b> Source File: </b> d:\Websites\PoolGeekUpgrade\Checkout\Google\NotificationListener.ashx<b> Line: </b> 41 <br><br> <b>Stack Trace:</b> <br><br> <table width=100% bgcolor="#ffffcc"> <tr> <td> <code><pre> [SqlException (0x80131904): The UPDATE statement conflicted with the FOREIGN KEY constraint "ac_Countries_ac_Addresses_FK1". The conflict occurred in database "AbleCommerce", table "dbo.ac_Countries", column 'CountryCode'. The statement has been terminated.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +196 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +68 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +199 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2408 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +147 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1095 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +314 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +413 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +130 Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteNonQuery(DbCommand command) +131 Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(DbCommand command) +131 CommerceBuilder.Data.Database.ExecuteNonQuery(DbCommand command) +245 CommerceBuilder.Users.Address.Save() +2144 CommerceBuilder.Common.PersistentCollection`1.Save() +67 CommerceBuilder.Users.User.SaveChildren() +59 CommerceBuilder.Users.User.BaseSave() +5172 CommerceBuilder.Users.User.Save() +824 CommerceBuilder.Payments.Providers.GoogleCheckout.AC.NewOrderHandler.Process() +721 NotificationListner.ProcessRequest(HttpContext context) in d:\Websites\PoolGeekUpgrade\Checkout\Google\NotificationListener.ashx:41 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +456 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +65 </pre></code> </td> </tr> </table> <br> <hr width=100% size=1 color=silver> <b>Version Information:</b> Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433 </font> </body> </html> <!-- [SqlException]: The UPDATE statement conflicted with the FOREIGN KEY constraint "ac_Countries_ac_Addresses_FK1". The conflict occurred in database "AbleCommerce", table "dbo.ac_Countries", column 'CountryCode'. The statement has been terminated. 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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteNonQuery(DbCommand command) at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(DbCommand command) at CommerceBuilder.Data.Database.ExecuteNonQuery(DbCommand command) at CommerceBuilder.Users.Address.Save() at CommerceBuilder.Common.PersistentCollection`1.Save() at CommerceBuilder.Users.User.SaveChildren() at CommerceBuilder.Users.User.BaseSave() at CommerceBuilder.Users.User.Save() at CommerceBuilder.Payments.Providers.GoogleCheckout.AC.NewOrderHandler.Process() at NotificationListner.ProcessRequest(HttpContext context) in d:\Websites\PoolGeekUpgrade\Checkout\Google\NotificationListener.ashx:line 41 at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --><!-- This error page might contain sensitive information because ASP.NET is configured to show verbose error messages using <customErrors mode="Off"/>. Consider using <customErrors mode="On"/> or <customErrors mode="RemoteOnly"/> in production environments.-->
Code: Select all
<?xml version="1.0" encoding="UTF-8"?>
<new-order-notification xmlns="http://checkout.google.com/schema/2" serial-number="265163950479301-00001-7">
<timestamp>2009-05-15T01:45:07.197Z</timestamp>
<shopping-cart>
<items>
<item>
<item-name>SunHeater InGround Solar Heater</item-name>
<item-description>SunHeater InGround Solar Heater is a great choice for any inground pool, heating the water naturally with sun exposure instead of using costly traditional heaters. Its simple design routes water from your pool through a series of tubes that pick up the heat generated by the sun and returns it to ...</item-description>
<quantity>4</quantity>
<unit-price currency="USD">221.74</unit-price>
<merchant-private-item-data>
<basketItemId>43101</basketItemId>
<productId>3829</productId>
<orderItemType>Product</orderItemType>
<shippable>Yes</shippable>
<taxCodeId>1</taxCodeId>
<weight>0</weight>
<wrapStyleId>0</wrapStyleId>
<optionList>
</optionList>
<giftMessage>
</giftMessage>
<lineMessage>
</lineMessage>
<lastModifiedDate>5/14/2009 8:31:54 PM</lastModifiedDate>
<orderBy>1</orderBy>
<parentItemId>258423</parentItemId>
<sku>SHIGSH</sku>
<wishlistItemId>0</wishlistItemId>
<basketItemKitProducts>
<kitProductId>15213</kitProductId>
</basketItemKitProducts>
</merchant-private-item-data>
</item>
</items>
<merchant-private-data>
<BasketId>43101</BasketId>
<BasketContentHash>D4DAF0A862BE890BF830A23377446786</BasketContentHash>
</merchant-private-data>
<cart-expiration>
<good-until-date>2009-05-15T02:01:54.166Z</good-until-date>
</cart-expiration>
</shopping-cart>
<order-adjustment>
<merchant-calculation-successful>true</merchant-calculation-successful>
<merchant-codes />
<total-tax currency="USD">0.0</total-tax>
<shipping>
<merchant-calculated-shipping-adjustment>
<shipping-name>Flat Rate Shipping</shipping-name>
<shipping-cost currency="USD">0.0</shipping-cost>
</merchant-calculated-shipping-adjustment>
</shipping>
<adjustment-total currency="USD">0.0</adjustment-total>
</order-adjustment>
<buyer-id>268526393959508</buyer-id>
<google-order-number>265163950479301</google-order-number>
<buyer-shipping-address>
<company-name></company-name>
<contact-name>Buyers Name</contact-name>
<email>xxxxxxxxx@gmail.com</email>
<phone></phone>
<fax></fax>
<address1>Buyers Address</address1>
<address2></address2>
<country-code>CA</country-code>
<city>Midland</city>
<region>ON</region>
<postal-code>L4R 4A6</postal-code>
</buyer-shipping-address>
<buyer-billing-address>
<company-name></company-name>
<contact-name>Buyers Name</contact-name>
<email>xxxxxxxs@gmail.com</email>
<phone>xxx xxx-xxxx</phone>
<fax></fax>
<address1>Buyers Address</address1>
<address2></address2>
<country-code>CA</country-code>
<city>Midland</city>
<region>ON</region>
<postal-code>L4R 4A6</postal-code>
</buyer-billing-address>
<buyer-marketing-preferences>
<email-allowed>true</email-allowed>
</buyer-marketing-preferences>
<order-total currency="USD">886.96</order-total>
<fulfillment-order-state>NEW</fulfillment-order-state>
<financial-order-state>REVIEWING</financial-order-state>
</new-order-notification>
Scott