dosubot[bot] commented on issue #31625: URL: https://github.com/apache/superset/issues/31625#issuecomment-2562931284
<!-- Greeting --> Hey @zabullet! I'm here to help you with any bugs, questions, or contributions. Let's tackle this issue together! <!-- Answer --> There are two similar closed issues related to the error you're encountering with scheduled reports in Apache Superset: 1. **Issue #13698**: This issue discusses a similar problem with scheduled reports failing due to a `TypeError` when inserting records into the `report_execution_log` table. The suggested solution was to switch from SQLite to PostgreSQL for metadata, as SQLite doesn't support date-time properly, which causes scheduling problems. Alternatively, there is a fix available for those who want to stay on SQLite <sup>[[1]](https://github.com/apache/superset/issues/13698)</sup>. 2. **Issue #26335**: This issue also highlights a problem with datetime handling in SQLite when using Superset version 4.1.1 and Python 3.10. The error is caused by an attempt to insert a datetime string into a SQLite database, which only accepts Python datetime and date objects. The issue was closed, and the recommended solution was to switch to a more robust database like PostgreSQL <sup>[[2]](https://github.com/apache/superset/issues/25969)</sup>. Switching your metadata database from SQLite to PostgreSQL might resolve the issue you're facing. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/f3358ecc-82dd-4814-8323-96599a4a32c5?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/f3358ecc-82dd-4814-8323-96599a4a32c5?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/f3358ecc-82dd-4814-8323-96599a4a32c5?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/f3358ecc-82dd-4814-8323-96599a4a32c5?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/f3358ecc-82dd-4814-8323-96599a4a32c5?feedback_type=hallucination) | [Other](https://app.dosu.dev/response-feedback/f3358ecc-82dd-4814-8323-96599a4a32c5?feedback_type=other)</sup> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
