[GitHub] akshayjamwal07 commented on issue #4933: Parse JSON result returned from a SELECT query in SQL Lab.

[GitBox <gi...@apache.org>]

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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org