Skip to main content
Question

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

  • Dec 4, 2021 5:09 PM UTC
  • 7 replies
  • 743 views
  • Translate All

NAthukorala47
Jr Varsity III
Forum|alt.badge.img

Hi, 

 

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

 

 

Regards

7 replies

Forum|alt.badge.img+12
  • Acumatica Support Team
  • Dec 6, 2021 3:07 AM UTC

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,

Translate

NAthukorala47
Jr Varsity III
Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • Dec 6, 2021 5:51 AM UTC

 

 

Attached the Trace file. 

Translate

NAthukorala47
Jr Varsity III
Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • Dec 6, 2021 5:52 AM UTC
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)

Translate

Forum|alt.badge.img+12
  • Acumatica Support Team
  • Dec 7, 2021 2:54 AM UTC

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,

Translate

NAthukorala47
Jr Varsity III
Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • Dec 9, 2021 11:37 AM UTC

Hi Vijay, 

 

How could we do that?

 

Regards

Nethupul

Translate

Forum|alt.badge.img+12
  • Acumatica Support Team
  • Dec 9, 2021 12:06 PM UTC

Hi Vijay, 

 

How could we do that?

 

Regards

Nethupul

Hi @NAthukorala47 

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

Translate

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • Jan 24, 2022 11:48 PM UTC

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

Translate