I have the last AC 7.0
Data base - SQL2000
when I try click to details in Coupon Usage section retunt the error -
Code: Select all
Ambiguous column name 'OrderId'.
Description: 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.
Exception Details: System.Data.SqlClient.SqlException: Ambiguous column name 'OrderId'.
Source Error:
Line 75: {
Line 76: CouponSummary summary = (CouponSummary)dataItem;
Line 77: return OrderDataSource.LoadForCouponCode(summary.CouponCode, summary.StartDate, summary.EndDate, "OrderId ASC");
Line 78: }
Line 79: </script>
Source File: d:\....\Admin\Reports\CouponUsageDetail.aspx Line: 77
Stack Trace:
[SqlException (0x80131904): Ambiguous column name 'OrderId'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +925466
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31
System.Data.SqlClient.SqlDataReader.get_MetaData() +62
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1005
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +7
Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteReader(DbCommand command, CommandBehavior cmdBehavior) +133
Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(DbCommand command) +143
CommerceBuilder.Orders.OrderDataSource.LoadForCouponCode(String couponCode, DateTime startDate, DateTime endDate, String sortExpression) +1045
ASP.admin_reports_couponusagedetail_aspx.GetCouponOrders(Object dataItem) in d:\...\Admin\Reports\CouponUsageDetail.aspx:77
ASP.admin_reports_couponusagedetail_aspx.__DataBinding__control21(Object sender, EventArgs e) in d:\...\Admin\Reports\CouponUsageDetail.aspx:162
System.Web.UI.Control.OnDataBinding(EventArgs e) +99
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +47
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
System.Web.UI.WebControls.GridView.DataBind() +4
System.Web.UI.Control.DataBindChildren() +204
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +216
System.Web.UI.Control.DataBind() +12
System.Web.UI.WebControls.Repeater.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem) +130
System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource) +454
System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) +53
System.Web.UI.WebControls.Repeater.DataBind() +72
ASP.admin_reports_couponusagedetail_aspx.ReportButton_Click(Object sender, EventArgs e) in d:\...\Admin\Reports\CouponUsageDetail.aspx:70
ASP.admin_reports_couponusagedetail_aspx.Page_Load(Object sender, EventArgs e) in d:\...\Admin\Reports\CouponUsageDetail.aspx:35
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +33
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436
