[DataConnection.HandleError]:
Query:
INSERT INTO COM_ShoppingCart ([ShoppingCartGUID], [ShoppingCartUserID], [ShoppingCartSiteID], [ShoppingCartLastUpdate], [ShoppingCartCurrencyID], [ShoppingCartPaymentOptionID], [ShoppingCartShippingOptionID], [ShoppingCartBillingAddressID], [ShoppingCartShippingAddressID], [ShoppingCartCustomerID], [ShoppingCartNote], [ShoppingCartCompanyAddressID], [ShoppingCartCustomData], [ShoppingCartContactID], [ShoppingCartCampaignID], [ShoppingCartProgramID], [ShoppingCartDistributorID], [ShoppingCartInventoryType], [BusinessUnitIDForDistributor], [ShoppingCartRequestedDeliveryDate], [ShoppingCartCarrierAccountNumber], [ShoppingCartFranchiseNumber], [ShoppingCartStoreID])
VALUES (@ShoppingCartGUID, @ShoppingCartUserID, @ShoppingCartSiteID, @ShoppingCartLastUpdate, @ShoppingCartCurrencyID, @ShoppingCartPaymentOptionID, @ShoppingCartShippingOptionID, @ShoppingCartBillingAddressID, @ShoppingCartShippingAddressID, @ShoppingCartCustomerID, @ShoppingCartNote, @ShoppingCartCompanyAddressID, @ShoppingCartCustomData, @ShoppingCartContactID, @ShoppingCartCampaignID, @ShoppingCartProgramID, @ShoppingCartDistributorID, @ShoppingCartInventoryType, @BusinessUnitIDForDistributor, @ShoppingCartRequestedDeliveryDate, @ShoppingCartCarrierAccountNumber, @ShoppingCartFranchiseNumber, @ShoppingCartStoreID);
SELECT SCOPE_IDENTITY() AS [ID]
Caused exception:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_COM_ShoppingCart_ShoppingCartCustomerID_COM_Customer". The conflict occurred in database "K11_KDA_QA", table "dbo.COM_Customer", column 'CustomerID'.
The statement has been terminated.
What I have tried:
[DataConnection.HandleError]:
Query:
INSERT INTO COM_ShoppingCart ([ShoppingCartGUID], [ShoppingCartUserID], [ShoppingCartSiteID], [ShoppingCartLastUpdate], [ShoppingCartCurrencyID], [ShoppingCartPaymentOptionID], [ShoppingCartShippingOptionID], [ShoppingCartBillingAddressID], [ShoppingCartShippingAddressID], [ShoppingCartCustomerID], [ShoppingCartNote], [ShoppingCartCompanyAddressID], [ShoppingCartCustomData], [ShoppingCartContactID], [ShoppingCartCampaignID], [ShoppingCartProgramID], [ShoppingCartDistributorID], [ShoppingCartInventoryType], [BusinessUnitIDForDistributor], [ShoppingCartRequestedDeliveryDate], [ShoppingCartCarrierAccountNumber], [ShoppingCartFranchiseNumber], [ShoppingCartStoreID])
VALUES (@ShoppingCartGUID, @ShoppingCartUserID, @ShoppingCartSiteID, @ShoppingCartLastUpdate, @ShoppingCartCurrencyID, @ShoppingCartPaymentOptionID, @ShoppingCartShippingOptionID, @ShoppingCartBillingAddressID, @ShoppingCartShippingAddressID, @ShoppingCartCustomerID, @ShoppingCartNote, @ShoppingCartCompanyAddressID, @ShoppingCartCustomData, @ShoppingCartContactID, @ShoppingCartCampaignID, @ShoppingCartProgramID, @ShoppingCartDistributorID, @ShoppingCartInventoryType, @BusinessUnitIDForDistributor, @ShoppingCartRequestedDeliveryDate, @ShoppingCartCarrierAccountNumber, @ShoppingCartFranchiseNumber, @ShoppingCartStoreID);
SELECT SCOPE_IDENTITY() AS [ID]
Caused exception:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_COM_ShoppingCart_ShoppingCartCustomerID_COM_Customer". The conflict occurred in database "K11_KDA_QA", table "dbo.COM_Customer", column 'CustomerID'.
The statement has been terminated.