Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more
AI OnAI Off
Error happens on OrderContext when use WCF service
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); }
Jul 19, 2013 15:35
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
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?