Can't exit error popup for Pivot Grid - Dynamic Security Error

[jamhos]

Description

When we overcomplicated our security roles, I got a popup on the Pivot Grid "Unable to query data for Pivot Grid" - this is fine (same as Excel).

BUT I am unable to exit the popup - clicking OK just keeps generating unlimited numbers of the same popup so I have to force-quit Tabular Editor.

Tabular Editor 3 Version

3.14.0

Screenshots

Steps to Reproduce

1. Create some complicated roles that conflict
2. Test them in the Pivot Grid using a measure or two
3. Impersonate a role that triggers the role conflict
4. Unable to exit error message

Expected behavior

The error message is correct - but I would expect it to then revert to eg. a non-impersonated role, or somehow allow the user to go back and fix the issue rather than force-quit.

Crash Report

No response

Windows Version

11

[otykier]

I believe this issue should be fixed in the newest version of TE3 (3.16.2). Could you try to download it from here: https://docs.tabulareditor.com/te3/other/downloads.html

Let us know if it still doesn’t work. Thanks!

[jamhos]

Thanks @otykier, I've updated to the latest version (3.16.2).

I accidentally tested two scenarios here. Scenario 1:

• Create Pivot Grid as "admin" user (without any RLS issues)
• Switch to user with RLS issues
• Receive two popups at once (see below screenshot) - if I click Ignore on the first (Unhandled Exception), then OK on the second (Unable to change impersonation), I can successfully continue what I'm doing in TE. Clicking 'Abort' immediately exits TE.
• If I then try again to impersonate the user, I receive the "unable to change" popup without the "unhandled exception" (so would appear to only be on the first attempt).

Scenario 2:

• Already impersonating a user in TE (successfully).
• Add broken RLS to user (via AD roles).
• Refresh pivot grid.
• This results in the "unhandled exception encountered" popup. Clicking 'Ignore' essentially replicates the initial reported issue (it keeps appearing). Clicking 'Abort' exits TE immediately.

I think the updated program definitely handles the error better (Scenario 1 is far more likely to occur, and it's possible to not crash out of TE), but ideally I would just receive the "Unable to change impersonation" popup and continued from there. Error log from unhandled exception: Error Report.txt

Hope that's enough info! Thanks again.

[otykier]

Thanks a lot for providing this additional information. We'll see if we can improve this experience over all.