Question

Auto Allocation of project Transactions are Failed, when Release Subcontract Bill

  • 4 December 2021
  • 7 replies
  • 79 views

Userlevel 1
Badge

Hi, 

 

We have created a Subcontract and when release it, system is showing a Error.

 

 

Regards


7 replies

Userlevel 7
Badge +8

Hi @NAthukorala47 

This may require one to check the specific Project detail/configuration to review further. Please send the Trace log to see if it gives any additional information. 

Regards,

Userlevel 1
Badge

 

 

Attached the Trace file. 

Userlevel 1
Badge
Error: LINQ fallback! Consider rewriting your query.
Graph: null
LINQ Model: value(PX.Data.SQLTree.SQLQueryable`1[PX.Data.PXResult`1[PX.Objects.CN.JointChecks.AP.DAC.JointPayee]]) => Any()
at PX.Data.SQLTree.SQLinqExecutor.ExecuteScalar[T](QueryModel queryModel)
at Remotion.Linq.Clauses.StreamedData.StreamedScalarValueInfo.ExecuteScalarQueryModel[T](QueryModel queryModel, IQueryExecutor executor)
at Remotion.Linq.Clauses.StreamedData.StreamedScalarValueInfo.ExecuteQueryModel(QueryModel queryModel, IQuer ... (see full message text in the details section)
 Send
  Raised At: 12/6/2021 11:17:57 AM Screen: AP.30.10.00 Command: Release  
 Details:

12/6/2021 11:17:57 AM Error:
LINQ fallback! Consider rewriting your query.
Graph: null
LINQ Model: value(PX.Data.SQLTree.SQLQueryable`1[PX.Data.PXResult`1[PX.Objects.CN.JointChecks.AP.DAC.JointPayee]]) => Any()
   at PX.Data.SQLTree.SQLinqExecutor.ExecuteScalar[T](QueryModel queryModel)
   at Remotion.Linq.Clauses.StreamedData.StreamedScalarValueInfo.ExecuteScalarQueryModel[T](QueryModel queryModel, IQueryExecutor executor)
   at Remotion.Linq.Clauses.StreamedData.StreamedScalarValueInfo.ExecuteQueryModel(QueryModel queryModel, IQueryExecutor executor)
   at Remotion.Linq.QueryProviderBase.System.Linq.IQueryProvider.Execute[TResult](Expression expression)
   at PX.Objects.CN.JointChecks.AP.GraphExtensions.InvoiceEntry.ApInvoiceEntryExt.UpdateDocumentFormLayout(APInvoice invoice, Boolean isBill)
   at PX.Data.PXRowSelected.Invoke(PXCache sender, PXRowSelectedEventArgs e)
   at PX.Objects.CN.Subcontracts.AP.GraphExtensions.ApInvoiceEntryExt.APInvoice_RowSelected(PXCache cache, PXRowSelectedEventArgs args, PXRowSelected baseHandler)
   at PX.Data.PXRowSelected.Invoke(PXCache sender, PXRowSelectedEventArgs e)
   at PX.Data.PXCache.OnRowSelected(Object item)
   at PX.Data.PXCache`1.set_Current(Object value)
   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.PXFormDataProvider.DataBind()
   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)
   at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)
   at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)
   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)

Userlevel 7
Badge +8

Hi @NAthukorala47 

I could not find further details from the Trace. I suggest support team should be able to check the Project configuration and assist. One need to logon and check specific Project setup.

Regards,

Userlevel 1
Badge

Hi Vijay, 

 

How could we do that?

 

Regards

Nethupul

Userlevel 7
Badge +8

Hi Vijay, 

 

How could we do that?

 

Regards

Nethupul

Hi @NAthukorala47 

You can contact Acumatica support to get this investigated further. 
Regards,

Userlevel 6
Badge

Hi @NAthukorala47 were you able to get this resolved with Support’s help? Thanks!

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 — 2020  Acumatica, Inc. All rights reserved