akshayjamwal07 commented on issue #4933: Parse JSON result returned from a SELECT query in SQL Lab. URL: https://github.com/apache/incubator-superset/issues/4933#issuecomment-387343591 I am working oracle database. The queries that are parsing the json column in oracle are not working in Superset. It keeps on running on the front end. On the server console, it is giving an exception that it is not connected to Oracle(whereas it is connected). Attaching the exception log below- ``` 2018-05-08 02:28:48,338:ERROR:sqlalchemy.pool.QueuePool:Exception during reset or similar Traceback (most recent call last): File "/private/var/root/venv/lib/python3.6/site-packages/superset/sql_lab.py", line 224, in execute_sql data = db_engine_spec.fetch_data(cursor, query.limit) File "/private/var/root/venv/lib/python3.6/site-packages/superset/db_engine_specs.py", line 314, in fetch_data return cursor.fetchmany(limit) cx_Oracle.OperationalError: ORA-03113: end-of-file on communication channel Process ID: 6429 Session ID: 770 Serial number: 15629 During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/private/var/root/venv/lib/python3.6/site-packages/sqlalchemy/pool.py", line 703, in _finalize_fairy fairy._reset(pool) File "/private/var/root/venv/lib/python3.6/site-packages/sqlalchemy/pool.py", line 873, in _reset pool._dialect.do_rollback(self) File "/private/var/root/venv/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 457, in do_rollback dbapi_connection.rollback() cx_Oracle.OperationalError: ORA-03114: not connected to ORACLE. ``` The query that I am using is correct and giving me results from Oracle. There is something wrong with Superset, the exception messages are incorrect and the query is not getting executed.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
