Some charts (Pivot Table) suddenly error. Cannot use 'View chart in Explore' for the whole dashboard.

[LeoDiep]

Hi everyone, I am using Superset version 1.5.0 on AWS EC2 Linux and connect to AWS Athena to query database, python 3.8. It's been okay for 5 months and suddently I got this problem yesterday.

When go to the dashboard or hit F5 to refresh, there is a notification on the bottom right said 'Error loading chart datasources. Filters may not work correctly.'

One of my dashboard has several charts appear error to load (only Pivot Table chart). 'Unexpected error: An error occurred while rendering the visualization: TypeError: Cannot read properties of undefined (reading 'Num. of Deal') -- 'Num. of Deal' is the name of metric'

Plus, in the error dashboard I cannot use 'View chart in Explore', including normal charts which are not error. Notification appear said: 'An error occurred while opening Explore'.

Additional context

• I ran back up version '1 week ago' of that Superset in another EC2 and that dashboard work well, there is no error at all.

• I have tried remove all the filter of the error dashboard, didn't solve the problem. I have detele error charts from that dashboard, didn't solved.

• I try delete the dataset of error chart and create a new one, visualize it as Pivot Table then it work on another dashboard. But when bring it to the error dashboard, the error occur again. If I try visualize that dataset as Pivot Table v2, it can appear on the error dashboard, but the 'View chart in Explore' function still didn't work.

• Other dashboard are normal with no error. Other Pivot Table charts on other dashboards are alsonormal.

Please help me fix it. Thank you so much.