You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When I receive a report or alert of a "Chart" report with "CSV" format, the CSV file is missing
How to reproduce the bug
Go to a table chart edit page (url example: /explore/?form_data_key=...&slice_id=1234) of a non empty dataset : the table must contain records
Click on "..." (right top corner) then "Manage email report" > "Set up an email report"
Choose the name and the schedule you want, and select "Formatted CSV attached in email" in Message content then save
Wait for the report to be sent (according to schedule settings)
Open the email received : you can see that the email is empty (there is only the subject and a link in the email body) and no file is attached => the csv file is missing
Screenshots/recordings
Superset version
4.0.1
Python version
I don't know
Node version
I don't know
Browser
Chrome
Additional context
Superset is deployed on AWS ECS with a custom Dockerfile built from the official image of apache/superset:4.0.1
I have checked the logs and no error / python stacktrace are triggered
It looks like the issue with the missing CSV file in email reports/alerts from Apache Superset might be related to the handling of attachments in the email sending process. Here are a few areas to investigate:
CSV Data Generation: Ensure that the CSV content is being generated correctly. The issue might arise if self._content.csv is empty or not set, which would prevent the attachment from being included in the email.
Email Sending Function: The problem could be in how the send_email_smtp function processes attachments. It's called with files=[] and data=content.data, where data should contain the CSV content. If the function doesn't handle this parameter as expected, the attachment might not be added to the email.
Configuration and Logging: Check your Apache Superset and SMTP server configurations for any settings that might affect email attachments. Additionally, enabling more detailed logging in Apache Superset can provide insights. Adjust the logging level to DEBUG to capture detailed information about the email sending process, which could help identify why the CSV file isn't being attached.
To enable detailed logging, adjust the LOG_LEVEL to DEBUG in the Superset configuration file. This will increase log verbosity, providing more information on the email sending process and attachment handling. Be mindful that debug logging can generate a lot of data, so it's best used temporarily for troubleshooting.
These steps should help you narrow down the cause of the issue and find a resolution. If you discover any new details or errors in the logs, sharing those could provide further clues for troubleshooting.
About Dosu
This response is meant to be useful and save you time. It is not meant to be a precise solution, but rather a starting point for your own research.
Help me be more useful! Please leave a 👍 if this is helpful and 👎 if it is irrelevant.
Bug description
When I receive a report or alert of a "Chart" report with "CSV" format, the CSV file is missing
How to reproduce the bug
Screenshots/recordings
Superset version
4.0.1
Python version
I don't know
Node version
I don't know
Browser
Chrome
Additional context
Superset is deployed on AWS ECS with a custom Dockerfile built from the official image of apache/superset:4.0.1
I have checked the logs and no error / python stacktrace are triggered
Checklist
The text was updated successfully, but these errors were encountered: