dosubot[bot] commented on issue #34816: URL: https://github.com/apache/superset/issues/34816#issuecomment-3213761593
<!-- Greeting --> Hi @truongnt! I'm [Dosu](https://go.dosu.dev/dosubot) and Iām helping the superset team. <!-- Answer --> The DPY-1001 error ("not connected to database") during Oracle visualization in Superset is likely caused by a configuration or environment issue, not a bug in Superset itself. Superset manages Oracle connections the same way for both querying and visualization, using SQLAlchemy engines and context managers for resource handling. Any difference in behavior is usually due to how the Oracle driver (oracledb/cx_Oracle) is set up or how the custom configuration is loaded in Docker Compose. For Docker Compose setups, make sure your custom configuration (including the cx_Oracle/oracledb aliasing) is placed in `/app/docker/pythonpath_dev/superset_config_docker.py`, as this is the location included in PYTHONPATH and imported by Superset. If you put it elsewhere, it may not be loaded, which can cause driver issues during visualization even if querying works ["custom config location"](https://github.com/apache/superset/discussions/25487). No recent changes or documentation address this error directly, and there are no known code differences in how Superset handles Oracle connections for visualization vs. querying ["connection handling"](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/models/core.py). Double-check your config file placement and ensure the Docker environment is loading your Oracle driver aliasing everywhere Superset runs. If the error persists, check Superset logs for a full stacktrace to pinpoint where the connection drops. <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/6f3b0a5e-9ce8-48e8-a8b7-396ff038009c?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/6f3b0a5e-9ce8-48e8-a8b7-396ff038009c?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/6f3b0a5e-9ce8-48e8-a8b7-396ff038009c?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/6f3b0a5e-9ce8-48e8-a8b7-396ff038009c?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/6f3b0a5e-9ce8-48e8-a8b7-396ff038009c?feedback_type=hallucination) | [Report š](https://app.dosu.dev/response-feedback/6f3b0a5e-9ce8-48e8-a8b7-396ff038009c?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/6f3b0a5e-9ce8-48e8-a8b7-396ff038009c?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=githu b) [](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/issues/34816) -- 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]
