Solved

An unhandled exception has occurred in the function 'MoveNext'. Please see the trace log for more details.

  • 23 March 2024
  • 1 reply
  • 44 views

Userlevel 2
Badge

When Adding shipment to the SO Invoice by Add Order action we are getting this subjected error.

Below is the trace.

LINQ fallback! Consider rewriting your query. Graph: Wrapper.PX.Objects.SO.Cst_SOInvoiceEntry LINQ Model: value(PX.Data.SQLTree.SQLQueryable`1[PX.Data.PXResult`1[PX.Objects.SO.SOOrderShipment]]) => Concat(value(PX.Data.SQLTree.SQLQueryable`1[PX.Data.PXResult`1[PX.Objects.SO.SOOrderShipment]])) Base BQL: Select2<SOOrderShipment, InnerJoin<SOOrder, On<TypeArray<Field<SOOrderShipment.orderType>.IsRelatedTo<SOOrder.orderType>, Field<SOOrderShipment.orderNbr>.IsRelatedTo<SOOrder.orderNbr>>>, InnerJoin<SOOrderType, On<TypeArray<Field<SOOrderShipment.orderType>.IsRelatedTo<SOOrderType.orderType>>>, InnerJoin<SOShipment, On<SOShipment.shipmentNbr, Equal<SOOrderShipment.shipmentNbr>, And<SOShipment.shipmentType, Equal<SOOrderShipment.shipmentType>>>>>>, Where<SOOrderShipment.customerID, Equal<Current<ARInvoice.customerID>>, And<SOOrderShipment.hold, Equal<boolFalse>, And<SOOrderShipment.confirmed, Equal<boolTrue>, And<SOOrderType.aRDocType, Equal<Current<ARInvoice.docType>>, And<Where<SOOrderShipment.invoiceNbr, IsNull, Or<SOOrderShipment.invoiceNbr, Equal<Current<ARInvoice.refNbr>>>>>>>>>, OrderBy<Asc<SOOrderShipment.orderType, Asc<SOOrderShipment.orderNbr, Asc<SOOrderShipment.shippingRefNoteID>>>>> at Remotion.Linq.Clauses.StreamedData.StreamedSequenceInfo.ExecuteQueryModel(QueryModel queryModel, IQueryExecutor executor) at Remotion.Linq.QueryProviderBase.System.Linq.IQueryProvider.Execute[TResult](Expression expression) at Remotion.Linq.QueryableBase`1.GetEnumerator() at PX.Objects.SO.SOInvoiceEntry.<sHipmentlist>d__149.MoveNext() at System.Linq.Enumerable.<OfTypeIterator>d__95`1.MoveNext() at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at _CustomMethod(Object , Object[] ) at PX.Data.PXView.InvokeDelegate(Object[] parameters) at PX.Data.PXView.Select(Object[] currents, Object[] parameters, Object[] searches, String[] sortcolumns, Boolean[] descendings, PXFilterRow[] filters, Int32& startRow, Int32 maximumRows, Int32& totalRows) at PX.Data.PXGraph.ExecuteSelect(String viewName, Object[] currents, Object[] parameters, Object[] searches, String[] sortcolumns, Boolean[] descendings, PXFilterRow[] filters, Int32& startRow, Int32 maximumRows, Int32& totalRows) at PX.Data.PXGraph.ExecuteSelect(String viewName, Object[] parameters, Object[] searches, String[] sortcolumns, Boolean[] descendings, PXFilterRow[] filters, Int32& startRow, Int32 maximumRows, Int32& totalRows) at PX.Web.UI.PXBaseDataSource.ExecuteSelect(String viewName, DataSourceSelectArguments arguments, PXDSSelectArguments pxarguments) at PX.Web.UI.PXDataSource.ExecuteSelect(String viewName, DataSourceSelectArguments arguments, PXDSSelectArguments pxarguments) at PX.Web.UI.PXDataSourceView.Select(DataSourceSelectArguments arguments, PXDSSelectArguments swarguments, DataSourceViewSelectCallback callback) at PX.Web.UI.PXGrid.PerformSelect() at System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() at PX.Web.UI.PXGrid.PX.Web.UI.IPXDataBoundControl.EnsureDataBoundInternal() at PX.Web.UI.PXCallbackManager.CollectDataControls(Dictionary`2 controlsDic, List`1 controlsList) at PX.Web.UI.PXCallbackManager.RenderClientData(PXCallbackResultMethod resultMethod, XmlWriter writer) at PX.Web.UI.PXCallbackManager.GetCallbackResultInternal(PXCallbackResultMethod resultMethod) at PX.Web.UI.PXCallbackManager.GetCallbackResult(PXCallbackResultMethod resultMethod) at System.Web.UI.Page.RenderCallback() 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 PX.Web.UI.PXPage.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error) at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb) at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)

 

Kindly support to resolve this.

 

Regards

Prasad 

icon

Best answer by darylbowman 29 March 2024, 20:25

View original

1 reply

Badge +11

I can’t be certain without seeing the Trace Log myself, but I suspect this is not actually the error. LINQ fallback is a common trace log entry which does not usually cause on-screen errors. I would look back through the Trace Log entries before this one and see if there are any other significant errors.

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved