Error when running Sales by Product report

[jonw2m]

There are no status Id's on any orders that does not exist on order status page.
Any suggestions will help.

Thank you,

An error has occured at https://www.xxxx.xx/Admin/Reports/SalesByProduct.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: could not execute query [ SELECT this_.ProductId as y0_, sum(this_.Quantity) as y1_, sum((this_.Price * this_.Quantity)) as y2_, this_.ProductId as y3_ FROM ac_OrderItems this_ inner join ac_Orders o1_ on this_.OrderId=o1_.OrderId WHERE (o1_.OrderStatusId = @p0 or o1_.OrderStatusId = @p1 or o1_.OrderStatusId = @p2 or o1_.OrderStatusId = @p3 or o1_.OrderStatusId = @p4 or o1_.OrderStatusId = @p5 or o1_.OrderStatusId = @p6 or o1_.OrderStatusId = @p7 or o1_.OrderStatusId = @p8 or o1_.OrderStatusId = @p9 or o1_.OrderStatusId = @p10 or o1_.OrderStatusId = @p11 or o1_.OrderStatusId = @p12 or o1_.OrderStatusId = @p13 or o1_.OrderStatusId = @p14 or o1_.OrderStatusId = @p15 or o1_.OrderStatusId = @p16 or o1_.OrderStatusId = @p17 or o1_.OrderStatusId = @p18 or o1_.OrderStatusId = @p19 or o1_.OrderStatusId = @p20 or o1_.OrderStatusId = @p21 or o1_.OrderStatusId = @p22 or o1_.OrderStatusId = @p23 or o1_.OrderStatusId = @p24 or o1_.OrderStatusId = @p25 or o1_.OrderStatusId = @p26 or o1_.OrderStatusId = @p27 or o1_.OrderStatusId = @p28 or o1_.OrderStatusId = @p29 or o1_.OrderStatusId = @p30 or o1_.OrderStatusId = @p31 or o1_.OrderStatusId = @p32 or o1_.OrderStatusId = @p33 or o1_.OrderStatusId = @p34 or o1_.OrderStatusId = @p35 or o1_.OrderStatusId = @p36) and o1_.OrderDate >= @p37 and o1_.OrderDate <= @p38 GROUP BY this_.ProductId ] Name:cp0 - Value:CommerceBuilder.Orders.OrderStatus Name:cp1 - Value:CommerceBuilder.Orders.OrderStatus Name:cp2 - Value:CommerceBuilder.Orders.OrderStatus Name:cp3 - Value:CommerceBuilder.Orders.OrderStatus Name:cp4 - Value:CommerceBuilder.Orders.OrderStatus Name:cp5 - Value:CommerceBuilder.Orders.OrderStatus Name:cp6 - Value:CommerceBuilder.Orders.OrderStatus Name:cp7 - Value:CommerceBuilder.Orders.OrderStatus Name:cp8 - Value:CommerceBuilder.Orders.OrderStatus Name:cp9 - Value:CommerceBuilder.Orders.OrderStatus Name:cp10 - Value:CommerceBuilder.Orders.OrderStatus Name:cp11 - Value:CommerceBuilder.Orders.OrderStatus Name:cp12 - Value:CommerceBuilder.Orders.OrderStatus Name:cp13 - Value:CommerceBuilder.Orders.OrderStatus Name:cp14 - Value:CommerceBuilder.Orders.OrderStatus Name:cp15 - Value:CommerceBuilder.Orders.OrderStatus Name:cp16 - Value:CommerceBuilder.Orders.OrderStatus Name:cp17 - Value:CommerceBuilder.Orders.OrderStatus Name:cp18 - Value:CommerceBuilder.Orders.OrderStatus Name:cp19 - Value:CommerceBuilder.Orders.OrderStatus Name:cp20 - Value:CommerceBuilder.Orders.OrderStatus Name:cp21 - Value:CommerceBuilder.Orders.OrderStatus Name:cp22 - Value:CommerceBuilder.Orders.OrderStatus Name:cp23 - Value:CommerceBuilder.Orders.OrderStatus Name:cp24 - Value:CommerceBuilder.Orders.OrderStatus Name:cp25 - Value:CommerceBuilder.Orders.OrderStatus Name:cp26 - Value:CommerceBuilder.Orders.OrderStatus Name:cp27 - Value:CommerceBuilder.Orders.OrderStatus Name:cp28 - Value:CommerceBuilder.Orders.OrderStatus Name:cp29 - Value:CommerceBuilder.Orders.OrderStatus Name:cp30 - Value:CommerceBuilder.Orders.OrderStatus Name:cp31 - Value:CommerceBuilder.Orders.OrderStatus Name:cp32 - Value:CommerceBuilder.Orders.OrderStatus Name:cp33 - Value:CommerceBuilder.Orders.OrderStatus Name:cp34 - Value:CommerceBuilder.Orders.OrderStatus Name:cp35 - Value:CommerceBuilder.Orders.OrderStatus Name:cp36 - Value:CommerceBuilder.Orders.OrderStatus Name:cp37 - Value:1/1/2013 5:00:00 AM Name:cp38 - Value:7/23/2013 4:59:59 AM [SQL: SELECT this_.ProductId as y0_, sum(this_.Quantity) as y1_, sum((this_.Price * this_.Quantity)) as y2_, this_.ProductId as y3_ FROM ac_OrderItems this_ inner join ac_Orders o1_ on this_.OrderId=o1_.OrderId WHERE (o1_.OrderStatusId = @p0 or o1_.OrderStatusId = @p1 or o1_.OrderStatusId = @p2 or o1_.OrderStatusId = @p3 or o1_.OrderStatusId = @p4 or o1_.OrderStatusId = @p5 or o1_.OrderStatusId = @p6 or o1_.OrderStatusId = @p7 or o1_.OrderStatusId = @p8 or o1_.OrderStatusId = @p9 or o1_.OrderStatusId = @p10 or o1_.OrderStatusId = @p11 or o1_.OrderStatusId = @p12 or o1_.OrderStatusId = @p13 or o1_.OrderStatusId = @p14 or o1_.OrderStatusId = @p15 or o1_.OrderStatusId = @p16 or o1_.OrderStatusId = @p17 or o1_.OrderStatusId = @p18 or o1_.OrderStatusId = @p19 or o1_.OrderStatusId = @p20 or o1_.OrderStatusId = @p21 or o1_.OrderStatusId = @p22 or o1_.OrderStatusId = @p23 or o1_.OrderStatusId = @p24 or o1_.OrderStatusId = @p25 or o1_.OrderStatusId = @p26 or o1_.OrderStatusId = @p27 or o1_.OrderStatusId = @p28 or o1_.OrderStatusId = @p29 or o1_.OrderStatusId = @p30 or o1_.OrderStatusId = @p31 or o1_.OrderStatusId = @p32 or o1_.OrderStatusId = @p33 or o1_.OrderStatusId = @p34 or o1_.OrderStatusId = @p35 or o1_.OrderStatusId = @p36) and o1_.OrderDate >= @p37 and o1_.OrderDate <= @p38 GROUP BY this_.ProductId] Inner Exception Stack Trace: at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Criteria.CriteriaLoader.List(ISessionImplementor session) at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) at NHibernate.Impl.CriteriaImpl.List(IList results) at NHibernate.Impl.CriteriaImpl.List[T]() at CommerceBuilder.Reporting.ReportDataSource.GetProductBreakdownSummary(DateTime fromDate, DateTime toDate, Int32 vendorId, String sortExpression) at AbleCommerce.Admin.Reports.ProductBreakdown.BindReport() at AbleCommerce.Admin.Reports.ProductBreakdown.Page_Load(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Inner Exception: could not execute query [ SELECT this_.ProductId as y0_, sum(this_.Quantity) as y1_, sum((this_.Price * this_.Quantity)) as y2_, this_.ProductId as y3_ FROM ac_OrderItems this_ inner join ac_Orders o1_ on this_.OrderId=o1_.OrderId WHERE (o1_.OrderStatusId = @p0 or o1_.OrderStatusId = @p1 or o1_.OrderStatusId = @p2 or o1_.OrderStatusId = @p3 or o1_.OrderStatusId = @p4 or o1_.OrderStatusId = @p5 or o1_.OrderStatusId = @p6 or o1_.OrderStatusId = @p7 or o1_.OrderStatusId = @p8 or o1_.OrderStatusId = @p9 or o1_.OrderStatusId = @p10 or o1_.OrderStatusId = @p11 or o1_.OrderStatusId = @p12 or o1_.OrderStatusId = @p13 or o1_.OrderStatusId = @p14 or o1_.OrderStatusId = @p15 or o1_.OrderStatusId = @p16 or o1_.OrderStatusId = @p17 or o1_.OrderStatusId = @p18 or o1_.OrderStatusId = @p19 or o1_.OrderStatusId = @p20 or o1_.OrderStatusId = @p21 or o1_.OrderStatusId = @p22 or o1_.OrderStatusId = @p23 or o1_.OrderStatusId = @p24 or o1_.OrderStatusId = @p25 or o1_.OrderStatusId = @p26 or o1_.OrderStatusId = @p27 or o1_.OrderStatusId = @p28 or o1_.OrderStatusId = @p29 or o1_.OrderStatusId = @p30 or o1_.OrderStatusId = @p31 or o1_.OrderStatusId = @p32 or o1_.OrderStatusId = @p33 or o1_.OrderStatusId = @p34 or o1_.OrderStatusId = @p35 or o1_.OrderStatusId = @p36) and o1_.OrderDate >= @p37 and o1_.OrderDate <= @p38 GROUP BY this_.ProductId ] Name:cp0 - Value:CommerceBuilder.Orders.OrderStatus Name:cp1 - Value:CommerceBuilder.Orders.OrderStatus Name:cp2 - Value:CommerceBuilder.Orders.OrderStatus Name:cp3 - Value:CommerceBuilder.Orders.OrderStatus Name:cp4 - Value:CommerceBuilder.Orders.OrderStatus Name:cp5 - Value:CommerceBuilder.Orders.OrderStatus Name:cp6 - Value:CommerceBuilder.Orders.OrderStatus Name:cp7 - Value:CommerceBuilder.Orders.OrderStatus Name:cp8 - Value:CommerceBuilder.Orders.OrderStatus Name:cp9 - Value:CommerceBuilder.Orders.OrderStatus Name:cp10 - Value:CommerceBuilder.Orders.OrderStatus Name:cp11 - Value:CommerceBuilder.Orders.OrderStatus Name:cp12 - Value:CommerceBuilder.Orders.OrderStatus Name:cp13 - Value:CommerceBuilder.Orders.OrderStatus Name:cp14 - Value:CommerceBuilder.Orders.OrderStatus Name:cp15 - Value:CommerceBuilder.Orders.OrderStatus Name:cp16 - Value:CommerceBuilder.Orders.OrderStatus Name:cp17 - Value:CommerceBuilder.Orders.OrderStatus Name:cp18 - Value:CommerceBuilder.Orders.OrderStatus Name:cp19 - Value:CommerceBuilder.Orders.OrderStatus Name:cp20 - Value:CommerceBuilder.Orders.OrderStatus Name:cp21 - Value:CommerceBuilder.Orders.OrderStatus Name:cp22 - Value:CommerceBuilder.Orders.OrderStatus Name:cp23 - Value:CommerceBuilder.Orders.OrderStatus Name:cp24 - Value:CommerceBuilder.Orders.OrderStatus Name:cp25 - Value:CommerceBuilder.Orders.OrderStatus Name:cp26 - Value:CommerceBuilder.Orders.OrderStatus Name:cp27 - Value:CommerceBuilder.Orders.OrderStatus Name:cp28 - Value:CommerceBuilder.Orders.OrderStatus Name:cp29 - Value:CommerceBuilder.Orders.OrderStatus Name:cp30 - Value:CommerceBuilder.Orders.OrderStatus Name:cp31 - Value:CommerceBuilder.Orders.OrderStatus Name:cp32 - Value:CommerceBuilder.Orders.OrderStatus Name:cp33 - Value:CommerceBuilder.Orders.OrderStatus Name:cp34 - Value:CommerceBuilder.Orders.OrderStatus Name:cp35 - Value:CommerceBuilder.Orders.OrderStatus Name:cp36 - Value:CommerceBuilder.Orders.OrderStatus Name:cp37 - Value:1/1/2013 5:00:00 AM Name:cp38 - Value:7/23/2013 4:59:59 AM [SQL: SELECT this_.ProductId as y0_, sum(this_.Quantity) as y1_, sum((this_.Price * this_.Quantity)) as y2_, this_.ProductId as y3_ FROM ac_OrderItems this_ inner join ac_Orders o1_ on this_.OrderId=o1_.OrderId WHERE (o1_.OrderStatusId = @p0 or o1_.OrderStatusId = @p1 or o1_.OrderStatusId = @p2 or o1_.OrderStatusId = @p3 or o1_.OrderStatusId = @p4 or o1_.OrderStatusId = @p5 or o1_.OrderStatusId = @p6 or o1_.OrderStatusId = @p7 or o1_.OrderStatusId = @p8 or o1_.OrderStatusId = @p9 or o1_.OrderStatusId = @p10 or o1_.OrderStatusId = @p11 or o1_.OrderStatusId = @p12 or o1_.OrderStatusId = @p13 or o1_.OrderStatusId = @p14 or o1_.OrderStatusId = @p15 or o1_.OrderStatusId = @p16 or o1_.OrderStatusId = @p17 or o1_.OrderStatusId = @p18 or o1_.OrderStatusId = @p19 or o1_.OrderStatusId = @p20 or o1_.OrderStatusId = @p21 or o1_.OrderStatusId = @p22 or o1_.OrderStatusId = @p23 or o1_.OrderStatusId = @p24 or o1_.OrderStatusId = @p25 or o1_.OrderStatusId = @p26 or o1_.OrderStatusId = @p27 or o1_.OrderStatusId = @p28 or o1_.OrderStatusId = @p29 or o1_.OrderStatusId = @p30 or o1_.OrderStatusId = @p31 or o1_.OrderStatusId = @p32 or o1_.OrderStatusId = @p33 or o1_.OrderStatusId = @p34 or o1_.OrderStatusId = @p35 or o1_.OrderStatusId = @p36) and o1_.OrderDate >= @p37 and o1_.OrderDate <= @p38 GROUP BY this_.ProductId] Inner Exception Stack Trace: at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Criteria.CriteriaLoader.List(ISessionImplementor session) at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) at NHibernate.Impl.CriteriaImpl.List(IList results) at NHibernate.Impl.CriteriaImpl.List[T]() at CommerceBuilder.Reporting.ReportDataSource.GetProductBreakdownSummary(DateTime fromDate, DateTime toDate, Int32 vendorId, String sortExpression) at AbleCommerce.Admin.Reports.ProductBreakdown.BindReport() at AbleCommerce.Admin.Reports.ProductBreakdown.Page_Load(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Inner Exception: could not execute query [ SELECT this_.ProductId as y0_, sum(this_.Quantity) as y1_, sum((this_.Price * this_.Quantity)) as y2_, this_.ProductId as y3_ FROM ac_OrderItems this_ inner join ac_Orders o1_ on this_.OrderId=o1_.OrderId WHERE (o1_.OrderStatusId = @p0 or o1_.OrderStatusId = @p1 or o1_.OrderStatusId = @p2 or o1_.OrderStatusId = @p3 or o1_.OrderStatusId = @p4 or o1_.OrderStatusId = @p5 or o1_.OrderStatusId = @p6 or o1_.OrderStatusId = @p7 or o1_.OrderStatusId = @p8 or o1_.OrderStatusId = @p9 or o1_.OrderStatusId = @p10 or o1_.OrderStatusId = @p11 or o1_.OrderStatusId = @p12 or o1_.OrderStatusId = @p13 or o1_.OrderStatusId = @p14 or o1_.OrderStatusId = @p15 or o1_.OrderStatusId = @p16 or o1_.OrderStatusId = @p17 or o1_.OrderStatusId = @p18 or o1_.OrderStatusId = @p19 or o1_.OrderStatusId = @p20 or o1_.OrderStatusId = @p21 or o1_.OrderStatusId = @p22 or o1_.OrderStatusId = @p23 or o1_.OrderStatusId = @p24 or o1_.OrderStatusId = @p25 or o1_.OrderStatusId = @p26 or o1_.OrderStatusId = @p27 or o1_.OrderStatusId = @p28 or o1_.OrderStatusId = @p29 or o1_.OrderStatusId = @p30 or o1_.OrderStatusId = @p31 or o1_.OrderStatusId = @p32 or o1_.OrderStatusId = @p33 or o1_.OrderStatusId = @p34 or o1_.OrderStatusId = @p35 or o1_.OrderStatusId = @p36) and o1_.OrderDate >= @p37 and o1_.OrderDate <= @p38 GROUP BY this_.ProductId ] Name:cp0 - Value:CommerceBuilder.Orders.OrderStatus Name:cp1 - Value:CommerceBuilder.Orders.OrderStatus Name:cp2 - Value:CommerceBuilder.Orders.OrderStatus Name:cp3 - Value:CommerceBuilder.Orders.OrderStatus Name:cp4 - Value:CommerceBuilder.Orders.OrderStatus Name:cp5 - Value:CommerceBuilder.Orders.OrderStatus Name:cp6 - Value:CommerceBuilder.Orders.OrderStatus Name:cp7 - Value:CommerceBuilder.Orders.OrderStatus Name:cp8 - Value:CommerceBuilder.Orders.OrderStatus Name:cp9 - Value:CommerceBuilder.Orders.OrderStatus Name:cp10 - Value:CommerceBuilder.Orders.OrderStatus Name:cp11 - Value:CommerceBuilder.Orders.OrderStatus Name:cp12 - Value:CommerceBuilder.Orders.OrderStatus Name:cp13 - Value:CommerceBuilder.Orders.OrderStatus Name:cp14 - Value:CommerceBuilder.Orders.OrderStatus Name:cp15 - Value:CommerceBuilder.Orders.OrderStatus Name:cp16 - Value:CommerceBuilder.Orders.OrderStatus Name:cp17 - Value:CommerceBuilder.Orders.OrderStatus Name:cp18 - Value:CommerceBuilder.Orders.OrderStatus Name:cp19 - Value:CommerceBuilder.Orders.OrderStatus Name:cp20 - Value:CommerceBuilder.Orders.OrderStatus Name:cp21 - Value:CommerceBuilder.Orders.OrderStatus Name:cp22 - Value:CommerceBuilder.Orders.OrderStatus Name:cp23 - Value:CommerceBuilder.Orders.OrderStatus Name:cp24 - Value:CommerceBuilder.Orders.OrderStatus Name:cp25 - Value:CommerceBuilder.Orders.OrderStatus Name:cp26 - Value:CommerceBuilder.Orders.OrderStatus Name:cp27 - Value:CommerceBuilder.Orders.OrderStatus Name:cp28 - Value:CommerceBuilder.Orders.OrderStatus Name:cp29 - Value:CommerceBuilder.Orders.OrderStatus Name:cp30 - Value:CommerceBuilder.Orders.OrderStatus Name:cp31 - Value:CommerceBuilder.Orders.OrderStatus Name:cp32 - Value:CommerceBuilder.Orders.OrderStatus Name:cp33 - Value:CommerceBuilder.Orders.OrderStatus Name:cp34 - Value:CommerceBuilder.Orders.OrderStatus Name:cp35 - Value:CommerceBuilder.Orders.OrderStatus Name:cp36 - Value:CommerceBuilder.Orders.OrderStatus Name:cp37 - Value:1/1/2013 5:00:00 AM Name:cp38 - Value:7/23/2013 4:59:59 AM [SQL: SELECT this_.ProductId as y0_, sum(this_.Quantity) as y1_, sum((this_.Price * this_.Quantity)) as y2_, this_.ProductId as y3_ FROM ac_OrderItems this_ inner join ac_Orders o1_ on this_.OrderId=o1_.OrderId WHERE (o1_.OrderStatusId = @p0 or o1_.OrderStatusId = @p1 or o1_.OrderStatusId = @p2 or o1_.OrderStatusId = @p3 or o1_.OrderStatusId = @p4 or o1_.OrderStatusId = @p5 or o1_.OrderStatusId = @p6 or o1_.OrderStatusId = @p7 or o1_.OrderStatusId = @p8 or o1_.OrderStatusId = @p9 or o1_.OrderStatusId = @p10 or o1_.OrderStatusId = @p11 or o1_.OrderStatusId = @p12 or o1_.OrderStatusId = @p13 or o1_.OrderStatusId = @p14 or o1_.OrderStatusId = @p15 or o1_.OrderStatusId = @p16 or o1_.OrderStatusId = @p17 or o1_.OrderStatusId = @p18 or o1_.OrderStatusId = @p19 or o1_.OrderStatusId = @p20 or o1_.OrderStatusId = @p21 or o1_.OrderStatusId = @p22 or o1_.OrderStatusId = @p23 or o1_.OrderStatusId = @p24 or o1_.OrderStatusId = @p25 or o1_.OrderStatusId = @p26 or o1_.OrderStatusId = @p27 or o1_.OrderStatusId = @p28 or o1_.OrderStatusId = @p29 or o1_.OrderStatusId = @p30 or o1_.OrderStatusId = @p31 or o1_.OrderStatusId = @p32 or o1_.OrderStatusId = @p33 or o1_.OrderStatusId = @p34 or o1_.OrderStatusId = @p35 or o1_.OrderStatusId = @p36) and o1_.OrderDate >= @p37 and o1_.OrderDate <= @p38 GROUP BY this_.ProductId] Inner Exception Stack Trace: at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Criteria.CriteriaLoader.List(ISessionImplementor session) at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) at NHibernate.Impl.CriteriaImpl.List(IList results) at NHibernate.Impl.CriteriaImpl.List[T]() at CommerceBuilder.Reporting.ReportDataSource.GetProductBreakdownSummary(DateTime fromDate, DateTime toDate, Int32 vendorId, String sortExpression) at AbleCommerce.Admin.Reports.ProductBreakdown.BindReport() at AbleCommerce.Admin.Reports.ProductBreakdown.Page_Load(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

[Katie]

There are no status Id's on any orders that does not exist on order status page.

Can you clarify? As far as I know, this report works fine. Please also list the build number you are using.

[jmestep]

Katie, I meant to ask Jon about this, but asked the wrong Jo(h)n. (We have 4 of them now!). I looked in one site that had a problem with the Sales By Product report when we first did an upgrade from Able 5 cfm to Gold. We had to jump thru all kinds of hoops to get their data in and there were some duplicate order statuses to start with, as we had seen in other sites going from Able 5 to Able 7. When I checked that report on Monday, I got an error like the above- it might have been the same site. I talked to the guy who did the data and we looked and the duplicate order statuses (by name) were gone. He did some comparison in the database and found one anomaly and fixed that, so maybe that is why the site is OK today.

[Katie]

Ok. Thanks for letting me know.

Wow. AC5 Coldfusion...that's going really far back.

[jmestep]

I know. It was a real pain. I talked to Jon about this and the report is working now because he was able to reset the date selection to get past the problem. He narrowed it down so that there was one day's orders in January that was breaking it and I think it was probably a data anomaly.

[AbleMods]

I have a client unable to run this report in Gold R4 - it appears that they are exceeding the maximum possible value for the totalQuantity using an int type.

I was able to modify the report to use a startDate of current month instead of 1st day of current year. This at least lets the report load so they can set a date range. But they're only able to run 2-3 months at a time due to their enormous sales volume. Anything more and the report crashes.