You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "siyu1212 (via GitHub)" <gi...@apache.org> on 2025/07/21 10:16:43 UTC

[D] Transaction heatmap unable to show in one of many accounts [superset]

GitHub user siyu1212 created a discussion: Transaction heatmap unable to show in one of many accounts

In this Superset instance, we have added probably around 10 users with developer rights and admin rights. However, there is 1 user account, for the transaction heat map would keep showing up this "Unexpected Error".
Have tried removing and adding that 1 user account, the rest of the 9 users have no issue. Any advice.
<img width="1918" height="1308" alt="image-sel_transcation_heatmap_issue(1)" src="https://github.com/user-attachments/assets/a81a287a-1f7c-469f-ae72-3ce4778354d5" />
<img width="1918" height="1308" alt="image-sel_transcation_heatmap_issue(1)" src="https://github.com/user-attachments/assets/12ac41b7-ddd8-4051-ac5e-7203a0d0f849" />


GitHub link: https://github.com/apache/superset/discussions/34249

----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [D] Transaction heatmap unable to show in one of many accounts [superset]

Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
GitHub user dosubot[bot] added a comment to the discussion: Transaction heatmap unable to show in one of many accounts

<!-- Greeting -->
Hi @siyu1212! I'm [Dosu](https://go.dosu.dev/dosubot) and I’m helping the superset team.

<!-- Answer -->
This kind of user-specific "Unexpected Error" in Superset is often caused by differences in permissions, group memberships, or row-level security (RLS) filters. Even if the user has developer or admin rights, it's possible that their access to the underlying dataset(s) for the heatmap is restricted, or that an RLS filter is applied to their account or group, blocking data access and causing the chart to fail to load ([source](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/security/manager.py)).

Here are some steps to help diagnose and resolve the issue:

- Compare the affected user's roles, group memberships, and dataset permissions with a user who can see the heatmap. Make sure the problematic user has access to the same datasets and dashboards.
- Check if any RLS filters are applied to the dataset powering the heatmap. If so, verify whether the affected user is subject to stricter filters or exclusions.
- Review the Superset backend logs right after reproducing the error with the affected user. The logs usually contain a more detailed error message or stack trace, which can pinpoint permission or RLS issues ([source](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/views/base.py)).
- Clear the user's session and browser cache, then have them log out and back in. If the user was deleted and re-added, lingering session or database references can sometimes cause persistent errors ([discussion](https://github.com/apache/superset/discussions/32808)).
- If the problem persists, try the affected account on a different browser or device to rule out client-side issues.

If you find a specific permission or RLS rule causing the problem, updating the user's roles, group memberships, or dataset access should resolve it. Let me know if you find anything specific in the logs or permission settings!


<!-- Dosu Comment Footer -->
*To reply, just mention [@dosu](https://go.dosu.dev/dosubot).*

---
<sup>How did I do? [Good](https://app.dosu.dev/response-feedback/d3a905c3-4c3f-4dc4-a925-f156dd995fa6?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/d3a905c3-4c3f-4dc4-a925-f156dd995fa6?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/d3a905c3-4c3f-4dc4-a925-f156dd995fa6?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/d3a905c3-4c3f-4dc4-a925-f156dd995fa6?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/d3a905c3-4c3f-4dc4-a925-f156dd995fa6?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/d3a905c3-4c3f-4dc4-a925-f156dd995fa6?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/d3a905c3-4c3f-4dc4-a925-f156dd995fa6?feedback_type=other)</sup>&nbsp;&nbsp;[![Join Discord](https://img.shields.io/badge/join-5865F2?logo=discord&logoColor=white&label=)](https://go.dosu.dev/discord-bot)&nbsp;[![Sh
 are on X](https://img.shields.io/badge/X-share-black)](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/discussions/34249)

GitHub link: https://github.com/apache/superset/discussions/34249#discussioncomment-13832531

----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [D] Transaction heatmap unable to show in one of many accounts [superset]

Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
GitHub user dosubot[bot] edited a comment on the discussion: Transaction heatmap unable to show in one of many accounts

<!-- Greeting -->
Hi @siyu1212! I'm [Dosu](https://go.dosu.dev/dosubot) and I’m helping the superset team.

<!-- Answer -->
This kind of user-specific "Unexpected Error" in Superset is often caused by differences in permissions, group memberships, or row-level security (RLS) filters. Even if the user has developer or admin rights, it's possible that their access to the underlying dataset(s) for the heatmap is restricted, or that an RLS filter is applied to their account or group, blocking data access and causing the chart to fail to load ([source](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/security/manager.py)).

Here are some steps to help diagnose and resolve the issue:

- Compare the affected user's roles, group memberships, and dataset permissions with a user who can see the heatmap. Make sure the problematic user has access to the same datasets and dashboards.
- Check if any RLS filters are applied to the dataset powering the heatmap. If so, verify whether the affected user is subject to stricter filters or exclusions.
- Review the Superset backend logs right after reproducing the error with the affected user. The logs usually contain a more detailed error message or stack trace, which can pinpoint permission or RLS issues ([source](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/views/base.py)).
- Clear the user's session and browser cache, then have them log out and back in. If the user was deleted and re-added, lingering session or database references can sometimes cause persistent errors ([discussion](https://github.com/apache/superset/discussions/32808)).
- If the problem persists, try the affected account on a different browser or device to rule out client-side issues.

If you find a specific permission or RLS rule causing the problem, updating the user's roles, group memberships, or dataset access should resolve it. Let me know if you find anything specific in the logs or permission settings!


<!-- Dosu Comment Footer -->
*To reply, just mention [@dosu](https://go.dosu.dev/dosubot?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=reply-with-mention&utm_term=apache%2Fsuperset).*

---

Share context across your team and agents. Try [Dosu](https://dosu.dev?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-tagline&utm_term=apache%2Fsuperset).

[![Leave Feedback](https://img.shields.io/badge/Leave%20Feedback-555555?style=flat)](https://app.dosu.dev/response-feedback?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-feedback&utm_term=apache%2Fsuperset&message_id=d3a905c3-4c3f-4dc4-a925-f156dd995fa6) [![Learn about superset with Dosu](https://img.shields.io/badge/Learn%20about%20superset%20with%20Dosu-2f7b3f?style=flat&logo=data%3Aimage%2Fsvg%2Bxml%3Bbase64%2CPHN2ZyB3aWR0aD0iODYiIGhlaWdodD0iODkiIHZpZXdCb3g9IjAgMCA4NiA4OSIgZmlsbD0ibm9uZSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj48cGF0aCBkPSJNNS4yOTIzNiAxMi43OTI4TDE3Ljc1OTMgNi42ODE4OFY3Mi41NjY3TDUuMjkyMzYgODQuMDYxOFYxMi43OTI4WiIgZmlsbD0iI0I0QkI5MSIvPjxwYXRoIGQ9Ik0xOC4yNTc1IDczLjExOTZMNTkuMTMyOSA3Mi43NDhMNTEuNzAxMSA4Mi40MDk1TDI5LjAzMzggODYuMjkxTDYuMjM5NjIgODUuMTU1NEwxOC4yNTc1IDczLjExOTZaIiBmaWxsPSIjNzc4NTYxIi8%2BPHBhdGggZD0iTTE3LjQ5MTYgMy43MzYzM0wzLjU4NTU3IDEyLjcwOTlWODMuNTc5MkMzLjU4NTU3IDg0Ljc1NDIgNC4
 5ODU2MyA4NS4zNjUyIDUuODQ3MDUgODQuNTY2TDE5LjYyOTYgNzEuNzgwMSIgc3Ryb2tlPSJibGFjayIgc3Ryb2tlLXdpZHRoPSI2LjQyODQ0IiBzdHJva2UtbGluZWNhcD0icm91bmQiLz48bWFzayBpZD0iZG9zdS1kLWN1dG91dCIgZmlsbD0id2hpdGUiPjxwYXRoIGZpbGwtcnVsZT0iZXZlbm9kZCIgY2xpcC1ydWxlPSJldmVub2RkIiBkPSJNNDAuNzA0IDAuNTE4MDY2SDE3LjA0MzlWNzYuMjIyMUg0MC43MDRINDIuNTgwNUg0Ny44MDEzQzY4LjcwNjQgNzYuMjIyMSA4NS42NTMzIDU5LjI3NTIgODUuNjUzMyAzOC4zNzAxQzg1LjY1MzMgMTcuNDY1IDY4LjcwNjMgMC41MTgwNjYgNDcuODAxMyAwLjUxODA2Nkg0Mi41ODA1SDQwLjcwNFoiLz48L21hc2s%2BPHBhdGggZmlsbC1ydWxlPSJldmVub2RkIiBjbGlwLXJ1bGU9ImV2ZW5vZGQiIGQ9Ik00MC43MDQgMC41MTgwNjZIMTcuMDQzOVY3Ni4yMjIxSDQwLjcwNEg0Mi41ODA1SDQ3LjgwMTNDNjguNzA2NCA3Ni4yMjIxIDg1LjY1MzMgNTkuMjc1MiA4NS42NTMzIDM4LjM3MDFDODUuNjUzMyAxNy40NjUgNjguNzA2MyAwLjUxODA2NiA0Ny44MDEzIDAuNTE4MDY2SDQyLjU4MDVINDAuNzA0WiIgZmlsbD0iI0YzRjZGMSIvPjxwYXRoIGQ9Ik0xNy4wNDM5IDAuNTE4MDY2Vi02LjU3OTE5SDkuOTQ2NjlWMC41MTgwNjZIMTcuMDQzOVpNMTcuMDQzOSA3Ni4yMjIxSDkuOTQ2NjlWODMuMzE5NEgxNy4wNDM5Vjc2LjIyMjFaTTE3LjA0MzkgNy42MTUzMkg0MC43MDRWLTYuNT
 c5MTlIMTcuMDQzOVY3LjYxNTMyWk0yNC4xNDEyIDc2LjIyMjFWMC41MTgwNjZIOS45NDY2OVY3Ni4yMjIxSDI0LjE0MTJaTTQwLjcwNCA2OS4xMjQ5SDE3LjA0MzlWODMuMzE5NEg0MC43MDRWNjkuMTI0OVpNNDIuNTgwNSA2OS4xMjQ5SDQwLjcwNFY4My4zMTk0SDQyLjU4MDVWNjkuMTI0OVpNNDcuODAxMyA2OS4xMjQ5SDQyLjU4MDVWODMuMzE5NEg0Ny44MDEzVjY5LjEyNDlaTTc4LjU1NiAzOC4zNzAxQzc4LjU1NiA1NS4zNTU1IDY0Ljc4NjcgNjkuMTI0OSA0Ny44MDEzIDY5LjEyNDlWODMuMzE5NEM3Mi42MjYxIDgzLjMxOTQgOTIuNzUwNSA2My4xOTQ5IDkyLjc1MDUgMzguMzcwMUg3OC41NTZaTTQ3LjgwMTMgNy42MTUzMkM2NC43ODY2IDcuNjE1MzIgNzguNTU2IDIxLjM4NDcgNzguNTU2IDM4LjM3MDFIOTIuNzUwNUM5Mi43NTA1IDEzLjU0NTMgNzIuNjI2IC02LjU3OTE5IDQ3LjgwMTMgLTYuNTc5MTlWNy42MTUzMlpNNDIuNTgwNSA3LjYxNTMySDQ3LjgwMTNWLTYuNTc5MTlINDIuNTgwNVY3LjYxNTMyWk00MC43MDQgNy42MTUzMkg0Mi41ODA1Vi02LjU3OTE5SDQwLjcwNFY3LjYxNTMyWiIgZmlsbD0iYmxhY2siIG1hc2s9InVybCgjZG9zdS1kLWN1dG91dCkiLz48cGF0aCBkPSJNNjguOTIxNSAzNi4wMTM1QzY4LjkyMTUgMzYuMDEzNSA2NS43MzY5IDQ5LjQ3MzggNTEuNDIzMSA0OS40NzM4QzM3LjEwOTMgNDkuNDczOCAzMi41Nzg3IDM3LjM1OTYgMzIuNTc4NyAzNi4wMTM1IiBzdHJva2U9ImJsYWNrIiB
 zdHJva2Utd2lkdGg9IjcuNjkxNjEiIHN0cm9rZS1saW5lY2FwPSJyb3VuZCIgc3Ryb2tlLWxpbmVqb2luPSJyb3VuZCIvPjxwYXRoIGQ9Ik0wLjM0ODYzMyA4NS40OTQ2QzAuMzQ4NjMzIDg1LjQ5NDYgMjkuNDg1NiA4NS44MzA5IDM0LjgwOSA4NS42OThDNDQuODMzNyA4NS40NDc3IDUxLjI4NzIgODQuNDAyIDU3LjUyNjkgNzguOTcyNEM2Mi44MTI5IDc0LjM3MjcgNzUuMTM0MiA1OS42ODM2IDc1LjEzNDIgNTkuNjgzNiIgc3Ryb2tlPSJibGFjayIgc3Ryb2tlLXdpZHRoPSI2LjE2NDgyIi8%2BPC9zdmc%2B)](https://github.dosu.com/apache/superset?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-learn-repo&utm_term=apache%2Fsuperset) [![Add Dosu to your team](https://img.shields.io/badge/Add%20Dosu%20to%20your%20team-1f6feb?style=flat)](https://app.dosu.dev/signup?referrer=openSource&source=github-footer&utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-add-team&utm_term=apache%2Fsuperset)

GitHub link: https://github.com/apache/superset/discussions/34249#discussioncomment-13832531

----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org