AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica OData wit...
You do not have acc...
 
Notifications
Clear all

Questions You do not have access to this entity set.

 
Acumatica OData with Microsoft Excel and Power BI
Last Post by ZachKarpinski 5 years ago
3 Posts
2 Users
1 Reactions
3,320 Views
RSS
ZachKarpinski
Posts: 2
 ZachKarpinski
Topic starter
August 12, 2020 2:42 pm
(@zachkarpinski)
New Member
Joined: 5 years ago
<m:error xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
<m:code/>
<m:message xml:lang="en-US">An error has occurred.</m:message>
<m:innererror>
<m:message>You do not have access to this entity set.</m:message>
<m:type>PX.Data.PXException</m:type>
<m:stacktrace/>
</m:innererror>
</m:error>

For the last few days I've been fighting with this error on a couple of my OData feeds.  The GIs work fine but when they are queried via OData they mysteriously started throwing this error.  I have the same screens on my development environment and OData worked fine there.  After trying other admin accounts, exhaustively reviewing security roles, GI changes (via audit history)  and a number of other useless changes that didn't help, I managed to figure out how to make this stop happening.  If it helps, both of the affected GIs are considered Primary List screens (Sales Orders/Payments and Applications).

This post isn't so much asking for help as it is documenting a potential fix for something I had zero luck finding an answer to online.  Google has no results for an exact search term matching the Topic title.  Neither do Stack Overflow or the Acumatica Knowledgebase.  I thought it might help someone if I shared the error, how I think it was caused and how I ended up fixing by brute force trial and error.   

How it was caused (partially/maybe):

Last week I noticed our Acumatica Site Map was kind of a mess and it was slowing down some of the work I needed to do.  I was just having a hard time locating some GIs while browsing for them with the "Inquire Title" search.  Sure I could have searched for them in the site search, but I digress...

With the help of a coworker we started moving things from the random places they ended up to where the default tree structure suggests they should live.  Among the many screens that we moved (all Generic Inquiries), the two OData feeds that stopped working were impacted.  Despite having these in the right place I believe how I moved some of the screens caused this error.  Instead of using the Generic Inquiry interface to change the location, I did a lot of cut and pasting in the Site Map screen (image attached).  

image

While I believe the above played some role in causing the error, I have not been able to figure out how to reproduce it.  I tried moving a regular GI around (not a Primary List screen) and it worked with OData no matter what I did.   While I really want to get to the bottom of what scenario causes this, I don't have time right now.  Maybe it is a Primary List thing, I just do not know.

An additional factor may have been using the Edit menu option in the modern UI to get missing menu elements back where they should be.  I had to do this in a number of places and I know for a fact Payments and Applications was part of these changes.  It was missing from Receivables -> Transactions as well as Sales Orders -> Transactions.  I have yet tried to reproduce the issue with a site map cut/paste and editing the menu.

 

How I fixed it? 

Once it dawned on me that the day these OData feeds stopped working was also the day we were working on the Site Map, I thought it had to be related to that.  Both screens had the right configuration defaults for Location, Workspace and Category when compared to my unmodified dev site map.  The Expose to OData box was still checked.  At first glance I was convinced these were both setup right.  Despite that conviction I used the Generic Inquiry screen's "Site Map Location" field to move one of them to a different location and saved it.  Then I moved it back to Primary Lists and saved it.  After the move/move back operation the OData feed started to work again.

Maybe someone has an idea for why this might occur, if so I'd love to hear it.  If nothing else I think it is entirely possible someone else might run into this some day and I hope this post saves that person a lot of time.  


Topic Tags
OData site map Generic Inquiry
2 Replies
Tim Rodman
Posts: 3199
 Tim Rodman
Admin
September 29, 2020 2:50 pm
(@timrodman)
Famed Member
Joined: 10 years ago

@zachkarpinski Thank you so much for this post. When I started the forums here, my main motivation was to collect more of these kinds of "micro blog posts", things that were too small for a full blog post, but that had a technical phrase for people to find via a Google search. You just did exactly that. Love it! Awesome!

What version of Acumatica are you using? I wonder if it's a version that still has the Classic UI lurking under the hood. In 2019 R2 they ripped out the Classic UI completely.


Reply
ZachKarpinski
 ZachKarpinski
(@zachkarpinski)
Joined: 5 years ago

New Member
Posts: 2
September 29, 2020 4:07 pm
Reply toTim RodmanTim Rodman

@timrodman I should have mentioned that, oops.  We're on 2019 R1 still.  When I originally posted this I believe we were specifically on 19.115.


Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Related Topics
  • Refreshing Odata GI TAbles in Excel not showing newly created GIs with Expose via OData selected
    3 years ago
  • OData Error when Pulling into Power BI
    3 years ago
  • connecting Acumatica to Google Sheets via Odata feed
    3 years ago
  • Excel Odata - Underlying Connection was closed.
    5 years ago
  • Error for certain users when refreshing data in Excel
    7 years ago
Topic Tags:  OData (6) , site map (2) , Generic Inquiry (41) ,
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,528 Topics
  • 10.9 K Posts
  • 13 Online
  • 2,412 Members
Our newest member: Peter Paasch
Latest Post: Credit Reference Report Needed
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

  • Tim Rodman
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2026 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×