Follow

Reveal Dashboard showing “[HYC00] [Kinetica][ODBC] (11470) Transactions are not supported. (11470) (SQLSetConnnectAttr(SQL_ATTR_AUTOCOMMIT))”

Incident Synopsis

Reveal Dashboard slices are showing “[HYC00] [Kinetica][ODBC] (11470) Transactions are not supported. (11470) (SQLSetConnnectAttr(SQL_ATTR_AUTOCOMMIT))”

 

Problem/Question

Some of slices in Reveal Dashboard are not displaying and showing error “[HYC00] [Kinetica][ODBC] (11470) Transactions are not supported. (11470) (SQLSetConnnectAttr(SQL_ATTR_AUTOCOMMIT))".

 User is not able to see tables when creating new slice.

 

Problem Detail

Prior the problem database cluster underwent migration activity.

Logfile of Reveal confirmed the error similar like following.

Log location: /opt/gpudb/connectors/reveal/logs/gpudb-reveal.log

 

2020-07-14 01:40:53,745:ERROR:root:(pyodbc.Error) ('HYC00', '[HYC00] [Kinetica][ODBC] (11470) Transactions are not supported. (11470) (SQLSetConnnectAttr(SQL_ATTR_AUTOCOMMIT))')
Traceback (most recent call last):
File "/opt/gpudb/connectors/reveal/lib/python2.7/site-packages/caravel-0.11.0-py2.7.egg/caravel/views.py", line 1940, in kinetica_tables
'tables': database.all_table_names(),
File "/opt/gpudb/connectors/reveal/lib/python2.7/site-packages/caravel-0.11.0-py2.7.egg/caravel/models.py", line 583, in all_table_names
return sorted(self.inspector.get_table_names(schema))
… 

 

Environment

Kinetica On-prem 7.x

 

Cause

odbc.ini configuration file in the new cluster was missing ReadOnly=1 entry.

 

Solution/Answer

Configuration of odbc connection for Reveal is located at /opt/gpudb/connectors/odbc/etc/odbc.ini

You would see under [READONLY_GPUDB_DSN] section.

Example of missing entries look like below:

[READONLY_GPUDB_DSN]
Description=ReadOnly Kinetica Connection
Driver=/opt/gpudb/connectors/odbc/lib/libKineticaODBC.so
URL=https://localhost:8082/gpudb-0
SslCACertPath=/opt/gpudb/certs
SslAllowHostMismatch=1
UID=
PWD=
#ReadOnly=1
Timeout=0
Locale=en-US

 

You would want to unmark #ReadOnly=1 or add the entry ReadOnly=1 if not existing. e.g.,

[READONLY_GPUDB_DSN]
Description=ReadOnly Kinetica Connection
Driver=/opt/gpudb/connectors/odbc/lib/libKineticaODBC.so
URL=https://localhost:8082/gpudb-0
SslCACertPath=/opt/gpudb/certs
SslAllowHostMismatch=1
UID=
PWD=
ReadOnly=1
Timeout=0
Locale=en-US

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Article is closed for comments.