Error on upgrading from Gold R10 to 11

[Scrollwoman]

I'm missing something and its driving me crazy. I am upgrading from Gold R10SR1 with a Windows Server 2012 and I can't seem to get around this error. any ideas?

An error has occured at https://www....../Admin/orders/default.aspx
Exception: Exception of type 'System.Web.HttpUnhandledException' was thrown. Stack Trace: at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) Inner Exception: Property accessor 'ShipmentStatus' on object 'CommerceBuilder.Orders.Order' threw the following exception:'could not load an entity: [CommerceBuilder.Orders.OrderShipment#5181][SQL: SELECT ordershipm0_.OrderShipmentId as OrderShi1_41_0_, ordershipm0_.OrderId as OrderId41_0_, ordershipm0_.WarehouseId as Warehous3_41_0_, ordershipm0_.ShipToFirstName as ShipToFi4_41_0_, ordershipm0_.ShipToLastName as ShipToLa5_41_0_, ordershipm0_.ShipToCompany as ShipToCo6_41_0_, ordershipm0_.ShipToAddress1 as ShipToAd7_41_0_, ordershipm0_.ShipToAddress2 as ShipToAd8_41_0_, ordershipm0_.ShipToCity as ShipToCity41_0_, ordershipm0_.ShipToProvince as ShipToP10_41_0_, ordershipm0_.ShipToPostalCode as ShipToP11_41_0_, ordershipm0_.ShipToCountryCode as ShipToC12_41_0_, ordershipm0_.ShipToPhone as ShipToP13_41_0_, ordershipm0_.ShipToFax as ShipToFax41_0_, ordershipm0_.ShipToEmail as ShipToE15_41_0_, ordershipm0_.ShipToResidence as ShipToR16_41_0_, ordershipm0_.ShipMethodId as ShipMet17_41_0_, ordershipm0_.ShipMethodName as ShipMet18_41_0_, ordershipm0_.ShipMessage as ShipMes19_41_0_, ordershipm0_.ShipDate as ShipDate41_0_, ordershipm0_.S...' Inner Exception Stack Trace: at System.ComponentModel.ReflectPropertyDescriptor.GetValue(Object component) at System.Web.UI.DataBinder.GetPropertyValue(Object container, String propName) at System.Web.UI.DataBinder.Eval(Object container, String[] expressionParts) at ASP.admin_orders_default_aspx.__DataBinding__control60(Object sender, EventArgs e) at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.Control.DataBindChildren() at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.Control.DataBindChildren() at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.WebControls.GridView.CreateRow(Int32 rowIndex, Int32 dataSourceIndex, DataControlRowType rowType, DataControlRowState rowState, Boolean dataBind, Object dataItem, DataControlField[] fields, TableRowCollection rows, PagedDataSource pagedDataSource) at System.Web.UI.WebControls.GridView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding) at CommerceBuilder.UI.WebControls.SortedGridView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding) at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data) at System.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable data) at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) at System.Web.UI.WebControls.DataBoundControl.PerformSelect() at System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() at System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() at System.Web.UI.Control.EnsureChildControls() at System.Web.UI.WebControls.GridView.get_Rows() at AbleCommerce.Admin.Orders._Default.Page_PreRender(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Inner Exception: Property accessor 'ShipmentStatus' on object 'CommerceBuilder.Orders.Order' threw the following exception:'could not load an entity: [CommerceBuilder.Orders.OrderShipment#5181][SQL: SELECT ordershipm0_.OrderShipmentId as OrderShi1_41_0_, ordershipm0_.OrderId as OrderId41_0_, ordershipm0_.WarehouseId as Warehous3_41_0_, ordershipm0_.ShipToFirstName as ShipToFi4_41_0_, ordershipm0_.ShipToLastName as ShipToLa5_41_0_, ordershipm0_.ShipToCompany as ShipToCo6_41_0_, ordershipm0_.ShipToAddress1 as ShipToAd7_41_0_, ordershipm0_.ShipToAddress2 as ShipToAd8_41_0_, ordershipm0_.ShipToCity as ShipToCity41_0_, ordershipm0_.ShipToProvince as ShipToP10_41_0_, ordershipm0_.ShipToPostalCode as ShipToP11_41_0_, ordershipm0_.ShipToCountryCode as ShipToC12_41_0_, ordershipm0_.ShipToPhone as ShipToP13_41_0_, ordershipm0_.ShipToFax as ShipToFax41_0_, ordershipm0_.ShipToEmail as ShipToE15_41_0_, ordershipm0_.ShipToResidence as ShipToR16_41_0_, ordershipm0_.ShipMethodId as ShipMet17_41_0_, ordershipm0_.ShipMethodName as ShipMet18_41_0_, ordershipm0_.ShipMessage as ShipMes19_41_0_, ordershipm0_.ShipDate as ShipDate41_0_, ordershipm0_.S...' Inner Exception Stack Trace: at System.ComponentModel.ReflectPropertyDescriptor.GetValue(Object component) at System.Web.UI.DataBinder.GetPropertyValue(Object container, String propName) at System.Web.UI.DataBinder.Eval(Object container, String[] expressionParts) at ASP.admin_orders_default_aspx.__DataBinding__control60(Object sender, EventArgs e) at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.Control.DataBindChildren() at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.Control.DataBindChildren() at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.WebControls.GridView.CreateRow(Int32 rowIndex, Int32 dataSourceIndex, DataControlRowType rowType, DataControlRowState rowState, Boolean dataBind, Object dataItem, DataControlField[] fields, TableRowCollection rows, PagedDataSource pagedDataSource) at System.Web.UI.WebControls.GridView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding) at CommerceBuilder.UI.WebControls.SortedGridView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding) at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data) at System.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable data) at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) at System.Web.UI.WebControls.DataBoundControl.PerformSelect() at System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() at System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() at System.Web.UI.Control.EnsureChildControls() at System.Web.UI.WebControls.GridView.get_Rows() at AbleCommerce.Admin.Orders._Default.Page_PreRender(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Inner Exception: Property accessor 'ShipmentStatus' on object 'CommerceBuilder.Orders.Order' threw the following exception:'could not load an entity: [CommerceBuilder.Orders.OrderShipment#5181][SQL: SELECT ordershipm0_.OrderShipmentId as OrderShi1_41_0_, ordershipm0_.OrderId as OrderId41_0_, ordershipm0_.WarehouseId as Warehous3_41_0_, ordershipm0_.ShipToFirstName as ShipToFi4_41_0_, ordershipm0_.ShipToLastName as ShipToLa5_41_0_, ordershipm0_.ShipToCompany as ShipToCo6_41_0_, ordershipm0_.ShipToAddress1 as ShipToAd7_41_0_, ordershipm0_.ShipToAddress2 as ShipToAd8_41_0_, ordershipm0_.ShipToCity as ShipToCity41_0_, ordershipm0_.ShipToProvince as ShipToP10_41_0_, ordershipm0_.ShipToPostalCode as ShipToP11_41_0_, ordershipm0_.ShipToCountryCode as ShipToC12_41_0_, ordershipm0_.ShipToPhone as ShipToP13_41_0_, ordershipm0_.ShipToFax as ShipToFax41_0_, ordershipm0_.ShipToEmail as ShipToE15_41_0_, ordershipm0_.ShipToResidence as ShipToR16_41_0_, ordershipm0_.ShipMethodId as ShipMet17_41_0_, ordershipm0_.ShipMethodName as ShipMet18_41_0_, ordershipm0_.ShipMessage as ShipMes19_41_0_, ordershipm0_.ShipDate as ShipDate41_0_, ordershipm0_.S...' Inner Exception Stack Trace: at System.ComponentModel.ReflectPropertyDescriptor.GetValue(Object component) at System.Web.UI.DataBinder.GetPropertyValue(Object container, String propName) at System.Web.UI.DataBinder.Eval(Object container, String[] expressionParts) at ASP.admin_orders_default_aspx.__DataBinding__control60(Object sender, EventArgs e) at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.Control.DataBindChildren() at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.Control.DataBindChildren() at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.WebControls.GridView.CreateRow(Int32 rowIndex, Int32 dataSourceIndex, DataControlRowType rowType, DataControlRowState rowState, Boolean dataBind, Object dataItem, DataControlField[] fields, TableRowCollection rows, PagedDataSource pagedDataSource) at System.Web.UI.WebControls.GridView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding) at CommerceBuilder.UI.WebControls.SortedGridView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding) at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data) at System.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable data) at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) at System.Web.UI.WebControls.DataBoundControl.PerformSelect() at System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() at System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() at System.Web.UI.Control.EnsureChildControls() at System.Web.UI.WebControls.GridView.get_Rows() at AbleCommerce.Admin.Orders._Default.Page_PreRender(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

[mazhar]

It seems like some of your order has missing shipping details. If you run following query on your database it will tell you about order items pointing to invalid order shipments.

Code: Select all

SELECT OI.OrderItemId, OI.OrderId, OI.Name, OI.OrderShipmentId
FROM ac_OrderItems AS OI
LEFT OUTER JOIN ac_OrderShipments AS S ON S.OrderShipmentId = OI.OrderShipmentId
WHERE S.OrderShipmentId IS NULL AND OI.OrderShipmentId > 0

[Scrollwoman]

Actually, we just had the same thing happen on a site in R10SR1. We can't see any orders in Admin. This is the same thing that happened when I tried the upgrade. I read another post about the trust relationships and application pool, but we haven't changed anything on this site or app pool. It is in full trust with application pool user profile as false. The upgraded site did not change when changing those settings or using a machine key. The error code above was from clicking on Orders in admin. I'm thinking that it may be a possible encryption issue with the SQL server?

[AbleMods]

In general, the error is saying "We were expecting this order to have a record in the OrderShipments table with ShipmentId = 5181 but when we searched the ac_OrderShipments table, we could not find it."

There are several reasons I can think of for that error:

1. Mazhar's query above will show you any order items that have been assigned to a shipment that no longer exists. That's the most common cause. If you find any at all, you've got some data integrity issues and those have to be cleaned up. Usually this happens when customizations are poorly designed and break the schema design implemented by the app.

2. This also could be a SQL permissions issue. If someone has been modifying SQL permissions, it is quite possible they have broken the store connection to the database. The database user account must have dbo permissions to all tables in the store database.

3. Indexes are corrupted/damaged in the SQL database. A Database Administrator can help you reorganize/reindex all the tables in the database or contact your hosting provider to discuss having this procedure done.

4. An external process is accessing the store database directly and manipulating (deleting) records without going through the AbleCommerce data access layer. This should be stopped immediately as it will only make data corruption worse in the store database. AbleCommerce uses a sophisticated data access layer and the data should only be manipulated in specific ways to prevent confusing the application.

Based on my experience, my money is on #1. Good luck

[Scrollwoman]

Thank you guys so much!

The issue was with the dbo user. I ended up deleting the user and recreating it in the database. It showed through server permissions within the SQL server that all was well. I had looked at that before, but if you clicked on the effective user permissions for that user, it said the user did not not exist, even though it seemed to be there.

[AbleMods]

Glad to help