September 11, 2010

Message: Sys.WebForms.PageRequestManagerServerErrorException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_dashCommerce_Store_Order_dashCommerce_Store_OrderStatusDescriptor". The conflict occurred in database "dashecommdemo", table "dbo.dashCommerce_Store_OrderStatusDescriptor", column 'OrderStatusDescriptorId'. The statement has been terminated. Line: 4723 Char: 21 Code: 0

When I clicked on ADD To Cart Button (In Production Environment On Godaddy),Nothing happened. Cart.aspx was supposed to open but it din't
I was using GoogleChrome
Then I used IE and got the following JAVASCRIPT Error


Webpage error details


User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET4.0C; .NET4.0E)
Timestamp: Sat, 11 Sep 2010 05:28:42 UTC




Message: Sys.WebForms.PageRequestManagerServerErrorException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_dashCommerce_Store_Order_dashCommerce_Store_OrderStatusDescriptor". The conflict occurred in database "dashecommdemo", table "dbo.dashCommerce_Store_OrderStatusDescriptor", column 'OrderStatusDescriptorId'.
The statement has been terminated.
Line: 4723
Char: 21
Code: 0
URI: http://97.74.62.114/dash-ecommerce-demo/ScriptResource.axd?d=P2OP40wYcXO4xgSz-sTYe98qh5lbZfZWwd5mUwizyYvyV3a1zAk8Ko9VNf_pWykKVz058PQuQN61ASAMlEOs76z9CKj1lO2uATKfrnFSqzc1&t=286d196


I checked dashCommerce_Store_OrderStatusDescriptor'data on database server by executing below query
select * from dashCommerce_Store_OrderStatusDescriptor

No rows were selected.
I ran below query to Insert the base data in the table


/****** Object:  Table [dbo].[dashCommerce_Store_OrderStatusDescriptor]    Script Date: 02/11/2008 09:46:50 ******/
INSERT [dbo].[dashCommerce_Store_OrderStatusDescriptor] ([OrderStatusDescriptorId], [Name], [CreatedBy], [ModifiedBy]) VALUES (100, N'Received Payment, Processing Order', N'SYSTEM', N'SYSTEM')
INSERT [dbo].[dashCommerce_Store_OrderStatusDescriptor] ([OrderStatusDescriptorId], [Name], [CreatedBy], [ModifiedBy]) VALUES (200, N'Gathering Items from Inventory', N'SYSTEM', N'SYSTEM')
INSERT [dbo].[dashCommerce_Store_OrderStatusDescriptor] ([OrderStatusDescriptorId], [Name], [CreatedBy], [ModifiedBy]) VALUES (300, N'Order - Partial Shipment', N'SYSTEM', N'SYSTEM')
INSERT [dbo].[dashCommerce_Store_OrderStatusDescriptor] ([OrderStatusDescriptorId], [Name], [CreatedBy], [ModifiedBy]) VALUES (400, N'Order - Complete Shipment', N'SYSTEM', N'SYSTEM')
INSERT [dbo].[dashCommerce_Store_OrderStatusDescriptor] ([OrderStatusDescriptorId], [Name], [CreatedBy], [ModifiedBy]) VALUES (500, N'Order Fully Refunded', N'SYSTEM', N'SYSTEM')
INSERT [dbo].[dashCommerce_Store_OrderStatusDescriptor] ([OrderStatusDescriptorId], [Name], [CreatedBy], [ModifiedBy]) VALUES (600, N'Order Partially Refunded', N'SYSTEM', N'SYSTEM')
INSERT [dbo].[dashCommerce_Store_OrderStatusDescriptor] ([OrderStatusDescriptorId], [Name], [CreatedBy], [ModifiedBy]) VALUES (9999, N'Not Processed', N'SYSTEM', N'SYSTEM')
GO



Now It works

No comments:

Post a Comment