Skip to main content
Question

OData returning error to only specific users

  • November 21, 2023
  • 7 replies
  • 174 views

This past weekend, we just upgraded to Acumatica 2023 R1 (23.111.0019). We have an Excel app that retrieves some information from a Generic Inquiry through an OData request. It uses a specific account we created just for OData, so disregarding who is using it, it ends up submitting the request using this OData account.

We’re aware of a known issue related to OData on our new version of Acumatica, but the error mentioned in the post is not exactly what we’re receiving as a response. And OData requests are actually working for some users.

https://community.acumatica.com/generic-inquiries-and-dashboards-236/known-issue-after-an-upgrade-to-acumatica-2023-r1-update-10-11-12-or-2023-r2-update-2-retrieving-data-through-the-gi-based-odata-could-stop-working-20099?tid=20099&fid=236


Everything has been working fine until after the upgrade, when we realized that the Excel app stopped working only for some users. We haven’t found a cause for this but we’re sure it’s not related to IP filters or individual account rights. For the users not able to use it, it returns the following error:

{

  "odata.error":{

    "code":"","message":{

      "lang":"en-US","value":"An error has occurred."

    },"innererror":{

      "message":"en-us\r\nParameter name: locale","type":"System.ArgumentOutOfRangeException","stacktrace":"   at PX.Api.Shared.WebApi.HttpRequestMessageExtensions.SetLocaleScope(HttpRequestMessage request)\r\n   at PX.Api.OData.Controllers.GenericInquiryController.<Get>d__3.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Threading.Tasks.TaskHelpersExtensions.<CastToObject>d__1`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__1.MoveNext()\r\n--- End of stack trace from prev

ious location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__5.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__3.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilter

AsyncCore>d__3.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__15.MoveNext()"

    }

  }

}

 

Any idea of what could be causing this to only specific users and how we could fix it?

 

Thanks in advance

7 replies

darylbowman
Captain II
Forum|alt.badge.img+13

From the error, it looks like it would have something to do with the locale of a parameter. This would make the most sense (to me) for a date parameter.

This would also make sense given that user’s could have different locale settings on their machines depending upon their preference.

Try checking the Windows Time & Language preferences for these users and see if anything is awry.

(Windows 11)

 


  • Author
  • Freshman II
  • 5 replies
  • November 24, 2023

Hi Daryl,

Thanks for your suggestion. Unfortunately I was not able to find any discrepancies on this matter on the computers I checked where we’re having these problems.


darylbowman
Captain II
Forum|alt.badge.img+13

Does the GI you're exposing have parameters?


  • Author
  • Freshman II
  • 5 replies
  • November 30, 2023

It doesn’t. We already tried including and removing parameters in the GI. It didn’t seem to affect, returning the same error response.


Forum|alt.badge.img
  • Freshman I
  • 14 replies
  • November 30, 2023

I have the same error. Has anything been figured out?


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2751 replies
  • December 20, 2023

Hi @jchavez were you able to find a solution? Thank you!


RohitRattan88
Acumatica Moderator
Forum|alt.badge.img+4
  • Acumatica Moderator
  • 253 replies
  • December 21, 2023

@jchavez Could you maybe share your OData query?
Are all users using the same Excel version? OS?
Was there an office/excel update recently that could cause this? Windows Update?
Are you able to get results using POSTMAN on those user’s computers?


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings