dosubot[bot] commented on issue #32258: URL: https://github.com/apache/superset/issues/32258#issuecomment-2658537024
<!-- Greeting --> Hey there, @shqcheng! I'm here to help you with any bugs, questions, or contributions you have for Superset. Let's get to the bottom of this together! <!-- Answer --> I found a similar closed issue related to Oracle database errors in Apache Superset. The issue titled "SQL Lab: Oracle Error (cx_Oracle.DatabaseError) ORA-12505: TNS:listener does not currently know of SID given in connect descriptor" did not have a solution found in the comments <sup>[[1]](https://github.com/apache/superset/issues/1761)</sup>. For your specific issue with the UNION operation and the use of SYSDATE resulting in "Database error" or "Network error," common causes could include: 1. **Database Errors:** - `SYNTAX_ERROR`: There might be a syntax error in the SQL query. - `CONNECTION_INVALID_HOSTNAME_ERROR`: The hostname provided can't be resolved. - `CONNECTION_PORT_CLOSED_ERROR`: The port is closed. - `CONNECTION_HOST_DOWN_ERROR`: The host might be down, and can't be reached on the provided port. 2. **Network Errors:** - `FRONTEND_NETWORK_ERROR`: General network error on the frontend. - `FRONTEND_TIMEOUT_ERROR`: The frontend request timed out. - `BACKEND_TIMEOUT_ERROR`: The backend request timed out. These errors are mapped to specific issue codes that provide more detailed descriptions of the problems encountered <sup>[[2]](https://github.com/apache/superset/blob/master/superset/errors.py)</sup><sup>[[3]](https://github.com/apache/superset/blob/master/superset-frontend/packages/superset-ui-core/src/query/types/Query.ts)</sup>. You might want to check the database connection settings, ensure that the database server is reachable, and verify that there are no syntax errors in your SQL queries. <!-- 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/42d90af9-2ecd-478d-8d5a-edb2a51dc1d9?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/42d90af9-2ecd-478d-8d5a-edb2a51dc1d9?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/42d90af9-2ecd-478d-8d5a-edb2a51dc1d9?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/42d90af9-2ecd-478d-8d5a-edb2a51dc1d9?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/42d90af9-2ecd-478d-8d5a-edb2a51dc1d9?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/42d90af9-2ecd-478d-8d5a-edb2a51dc1d9?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/42d90af9-2ecd-478d-8d5a-edb2a51dc1d9?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]
