Getting error while scheduling reports in csv/image/text

[devysh1907]

[2024-12-11 09:54:00,353: INFO/ForkPoolWorker-2] Getting chart from https://******.com/api/v1/chart/234/data/?format=csv&type=post_processed&force=true as user dev.saxena
SupersetError(message='[Errno 110] Connection timed out', error_type=<SupersetErrorType.REPORT_NOTIFICATION_ERROR: 'REPORT_NOTIFICATION_ERROR'>, level=<ErrorLevel.ERROR: 'error'>, extra=None)
[2024-12-11 09:57:58,626: WARNING/ForkPoolWorker-3] SupersetError(message='[Errno 110] Connection timed out', error_type=<SupersetErrorType.REPORT_NOTIFICATION_ERROR: 'REPORT_NOTIFICATION_ERROR'>, level=<ErrorLevel.ERROR: 'error'>, extra=None)
A downstream exception occurred while generating a report: e9c93bfb-a6dd-49c5-ba75-ee5fa7067206. [SupersetError(message='[Errno 110] Connection timed out', error_type=<SupersetErrorType.REPORT_NOTIFICATION_ERROR: 'REPORT_NOTIFICATION_ERROR'>, level=<ErrorLevel.ERROR: 'error'>, extra=None)]
Traceback (most recent call last):
File "/app/superset/tasks/scheduler.py", line 90, in execute
AsyncExecuteReportScheduleCommand(
File "/app/superset/commands/report/execute.py", line 721, in run
raise ex
File "/app/superset/commands/report/execute.py", line 717, in run
ReportScheduleStateMachine(
File "/app/superset/commands/report/execute.py", line 678, in run
state_cls(
File "/app/superset/commands/report/execute.py", line 582, in next
raise first_ex
File "/app/superset/commands/report/execute.py", line 551, in next
self.send()
File "/app/superset/commands/report/execute.py", line 451, in send
self._send(notification_content, self._report_schedule.recipients)
File "/app/superset/commands/report/execute.py", line 440, in _send
raise ReportScheduleSystemErrorsException(errors=notification_errors)
superset.commands.report.exceptions.ReportScheduleSystemErrorsException: [SupersetError(message='[Errno 110] Connection timed out', error_type=<SupersetErrorType.REPORT_NOTIFICATION_ERROR: 'REPORT_NOTIFICATION_ERROR'>, level=<ErrorLevel.ERROR: 'error'>, extra=None)]
[2024-12-11 09:57:58,683: ERROR/ForkPoolWorker-3] A downstream exception occurred while generating a report: e9c93bfb-a6dd-49c5-ba75-ee5fa7067206. [SupersetError(message='[Errno 110] Connection timed out', error_type=<SupersetErrorType.REPORT_NOTIFICATION_ERROR: 'REPORT_NOTIFICATION_ERROR'>, level=<ErrorLevel.ERROR: 'error'>, extra=None)]
Traceback (most recent call last):

[dosubot[bot]]

The '[Errno 110] Connection timed out' error when scheduling reports in CSV/Image/Text format in Superset is likely due to an invalid connection to an email server. This error can occur if the outbound email configuration is incorrect. To troubleshoot, you should confirm that your SMTP settings are correct by sending a test email. Here's a simple test for an unauthenticated SMTP service running on port 25:

import smtplib
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText

from_email = 'superset_emails@example.com'
to_email = 'your_email@example.com'
msg = MIMEMultipart()
msg['From'] = from_email
msg['To'] = to_email
msg['Subject'] = 'Superset SMTP config test'
message = 'It worked'
msg.attach(MIMEText(message))
mailserver = smtplib.SMTP('smtpmail.example.com', 25)
mailserver.sendmail(from_email, to_email, msg.as_string())
mailserver.quit()

If this test fails, you may need to adjust your SMTP settings or use a different set of SMTP credentials. Additionally, ensure that your network configuration allows outgoing SMTP connections, as some cloud providers block port 25 by default.

Moreover, the error might also be related to a timeout occurring during the report generation process itself, such as when generating a CSV. The Superset integration tests indicate that a SoftTimeLimitExceeded exception can be raised if the report generation exceeds the allowed time limit. This could be another reason for the timeout error, and you might need to investigate the report generation process to ensure it completes within the expected time frame ^[1][2].

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}