Virtual Happy Hour is canceled this month (March) due to Good Friday.
Try our conversational search powered by Generative AI!
AI OnAI Off
Virtual Happy Hour is canceled this month (March) due to Good Friday.
Probably the SqlContext and/or DataContext are null? This can also happen when you use a scheduled job e.g.
try adding this before calling the order repository:
if (SqlContext.Current == null) { SqlContext.Current = new SqlContext(ConfigurationManager.ConnectionStrings["EcfSqlConnection"].ConnectionString); } if (DataContext.Current == null) { DataContext.Current = new DataContext(ConfigurationManager.ConnectionStrings["EcfSqlConnection"].ConnectionString); }
Under the commerce site, i want to expose some data to the other party by WCF service.
it give me the error :
at Mediachase.BusinessFoundation.Data.Sql.SqlCommandBuilder..ctor(String table)
at Mediachase.BusinessFoundation.Data.Sql.SelectCommandBuilder..ctor(String tableName, FilterElementCollection filters, SortingElementCollection sorting)
at Mediachase.BusinessFoundation.Data.DataHelper.List(String tableName, Int32 maxCount, FilterElementCollection filters, SortingElementCollection sorting)
at Mediachase.BusinessFoundation.Data.DataHelper.List(String tableName, Int32 maxCount, FilterElement[] filters)
at Mediachase.BusinessFoundation.Data.DataHelper.List(String tableName, FilterElement[] filters)
at Mediachase.Commerce.Orders.Managers.Sql.OrderGroupNote_row.List(FilterElement[] filters)
at Mediachase.Commerce.Orders.OrderNoteCollection.LoadOrderNotes()
at Mediachase.Commerce.Orders.OrderGroup.PopulateCollections(DataTableCollection tables, String filter)
at Mediachase.Commerce.Orders.PurchaseOrder.PopulateCollections(DataTableCollection tables, String filter)
at Mediachase.Commerce.Orders.OrderGroup.PopulateCollection[T](ClassInfo classInfo, MetaStorageCollectionBase`1 collection, DataSet dataSet)
at Mediachase.Commerce.Orders.PurchaseOrder.Search(OrderSearch search, Int32& totalRecords)
at Mediachase.Commerce.Orders.OrderContext.FindPurchaseOrders(OrderSearchParameters parameters, OrderSearchOptions options, Int32& totalRecords)
at Mediachase.Commerce.Orders.OrderContext.FindPurchaseOrders(OrderSearchParameters parameters, OrderSearchOptions options)
at JBHiFi.CMS.Web.Helpers.Commerce.OrderGroupCommerceHelper.GetOrders(Nullable`1 start, Nullable`1 end, Nullable`1 orderId, Nullable`1 status) in c:\Work\JBHiFi\JBHifi.com.au\trunk\source\JBHiFi.CMS.Web.Helpers\Commerce\OrderGroupCommerceHelper.cs:line 39
at JBHiFi.CMS.Web.Repository.OrderGroups.OrderRepository.GetOrders(Nullable`1 start, Nullable`1 end, Nullable`1 orderId, Nullable`1 status) in c:\Work\JBHiFi\JBHifi.com.au\trunk\source\JBHiFi.CMS.Web.Repository\OrderGroups\OrderRepository.cs:line 188
at JBHiFi.CMS.Web.Business.Integration.FulFilmentService.FormOrdersFromCarts(Nullable`1 start, Nullable`1 end, Nullable`1 orderId, Nullable`1 status) in c:\Work\JBHiFi\JBHifi.com.au\trunk\source\JBHiFi.CMS.Web.Business\Integration\FulFilmentService.cs:line 40
at JBHiFi.CMS.Web.Services.OrderService.GetOrders(Nullable`1 start, Nullable`1 end, Nullable`1 orderId, Nullable`1 status) in c:\Work\JBHiFi\JBHifi.com.au\trunk\source\JBHiFi.CMS.Web.Services\OrderService.svc.cs:line 22
at SyncInvokeGetOrders(Object , Object[] , Object[] )
at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
this error only happens when i try to call the order repository in wcf, I have a test page /handlers/TestCustomer.ashx, the order repository works fine, the commerce site have share all the same configs/web.config files.
can anyone have the same issue as me in this case?