Skip to main content
Question

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

  • December 4, 2021
  • 7 replies
  • 646 views
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

    V
    Acumatica Employee
    Forum|alt.badge.img+12
    • vkumar
    • Acumatica Support Team
    • December 6, 2021

    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,

    VijayKumarU
    NAthukorala47
    Jr Varsity III
    Forum|alt.badge.img
    • NAthukorala47
    • Author
    • Jr Varsity III
    • December 6, 2021

     

     

    Attached the Trace file. 

    1 Attachments
    NAthukorala47
    Jr Varsity III
    Forum|alt.badge.img
    • NAthukorala47
    • Author
    • Jr Varsity III
    • December 6, 2021
    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)
    V
    Acumatica Employee
    Forum|alt.badge.img+12
    • vkumar
    • Acumatica Support Team
    • December 7, 2021

    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,

    VijayKumarU
    NAthukorala47
    Jr Varsity III
    Forum|alt.badge.img
    • NAthukorala47
    • Author
    • Jr Varsity III
    • December 9, 2021

    Hi Vijay, 

     

    How could we do that?

     

    Regards

    Nethupul

    V
    Acumatica Employee
    Forum|alt.badge.img+12
    • vkumar
    • Acumatica Support Team
    • December 9, 2021

    Hi Vijay, 

     

    How could we do that?

     

    Regards

    Nethupul

    Hi @NAthukorala47 

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

    VijayKumarU
    Chris Hackett
    Chris Hackett
    Community Manager
    Forum|alt.badge.img
    • Chris Hackett
    • Acumatica Community Manager
    • January 24, 2022

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

    Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
    C
    Terms & ConditionsCookie settingsAccessibility statement
    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