Tableau server linux(CentOS7 ) to Exasol connectivity issue

ppalanisamy
Padawan

I have set up Tableau Server in CentOS machine. I configured Exasol 6 version as well.When I check connectivity they iSQL command line the result shows connected and the necessary ports are open but when I run any query nothing happens.. When I check the sessions at Exasol DB level it shows as IDLE. I am stuck at this right now and don't know how to proceed further.attached the screenshot as well.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

exa-Chris
Community Manager
Community Manager

Hi Param,

thank you for the reply, this case has been forwarded to an interal ticket in our myExasol System.
We will run ongoing discussion the commucation through the ticketing system and update here
when a solution has been found. If you do not have access to myExasol. Please contact your
myExasol User Manager. Please direct all further questions to the EXA-Ticket System
For reference on myExasol please see this article:
https://community.exasol.com/t5/community-resources/about-myexasol-accounts/ta-p/39

Rgds

@exa-Chris 
P.S: If you have any further questions on this Topic, please send me a DM

Connecting Customers, Partners, Prospects and Exasolians is my passion. Apart from that I cycle, listen to music, and try to understand what all those technical discussions really mean...

View solution in original post

7 REPLIES 7

exa-Chris
Community Manager
Community Manager

Hi Param, thanks for the question. Let me take this back to our team and come back with an answer.
Exa-Chris

Connecting Customers, Partners, Prospects and Exasolians is my passion. Apart from that I cycle, listen to music, and try to understand what all those technical discussions really mean...

ppalanisamy
Padawan

I installed EXAplus on the same CentOS box and when I connect to the DB it doesn't return anything. It just hangs.When  I check with DBA he says session is there on the DB but its on IDLE state. We don't have any clue why its not reponding.

Charlie
Xpert

how does the ODBC entry look like or can you post the connection string you are using in exaplus?

 

exa-Chris
Community Manager
Community Manager

Hi Param,
I heard that my colleague @exa-Franz also contacted you through a direct message on the community to further investigate the case. We will make sure that the solution will be posted in this thread so we can share it publicly.
Thanks @Charlie for stepping in so quickly 🙂

@exa-Chris 

Connecting Customers, Partners, Prospects and Exasolians is my passion. Apart from that I cycle, listen to music, and try to understand what all those technical discussions really mean...

ppalanisamy
Padawan

here is the odbc.ini file entry

 

# cat /etc/odbc.ini

[ODBC Data Sources]

exasolution-dd_32 = DataDirect (32bit)

exasolution-uo2214lv2_64 = unixODBC 2.2.14 or later, libversion 2 (64bit)

[exasolution-uo2214lv2_64]

DRIVER = /Installs/EXASOL_ODBC-6.2.9/lib/linux/x86_64/libexaodbc-uo2214lv2.so

EXAHOST = 10.46.90.32:3306

EXAUID = tableau_test_p

EXAPWD = test123##

 

[exasolution-uo2214lv2_64-debug]

DRIVER = /Installs/EXASOL_ODBC-6.2.9/lib/linux/x86_64/libexaodbc-uo2214lv2.so

EXAHOST = 10.46.90.32:3306

EXAUID = tableau_test_p

EXAPWD = test123##

EXALOGFILE = /ebay/Installs/EXASOL_ODBC-6.2.9/exaodbc.log

LOGMODE = Debug Comm

ppalanisamy
Padawan

Also the ODBC logs has entries like this after it timed out

15:26:53.596    125741  Received from server:

15:26:53.596    125741   13 attributes, 0 results

15:26:53.596    125741  exaSocket::exaSafeRecv() encrypted

15:26:53.596    125741  exaSocket::exaSafeRecvBase(), timeout=0

15:26:53.596    125741  exaSocket::exaSafeRecv(), totalRead=0, lastRead=165

15:26:53.596    125741  exaGetAnswer::ATTR_SESSIONID: 1683193176614719609

15:26:53.596    125741  exaGetAnswer::ATTR_PROTOCOL_VERSION: 14

15:26:53.596    125741  exaGetAnswer::ATTR_DATA_MESSAGE_SIZE: 67108864

15:26:53.596    125741  exaGetAnswer::ATTR_RELEASE_VERSION: 6.0.6

15:26:53.596    125741  exaGetAnswer::ATTR_RELEASE_REVISION: gbc/exasol/R6.0.6:8170

15:26:53.596    125741  exaGetAnswer::ATTR_MAX_IDENTIFIER_LENGTH: 128, maxIdentifierOctetLen: 512

15:26:53.596    125741  exaGetAnswer::ATTR_MAX_VARCHAR_LENGTH: 2000000

15:26:53.596    125741  exaGetAnswer::ATTR_FEEDBACK_INTERVAL: 1

15:26:53.596    125741  exaGetAnswer::ATTR_TIMEZONE: UTC

15:26:53.596    125741  exaGetAnswer::ATTR_TIMEZONE_BEHAVIOR: INVALID SHIFT AMBIGUOUS ST

15:26:53.596    125741  exaGetAnswer::ATTR_IDENTIFIER_QUOTE_STRING: "

15:26:53.596    125741  exaSocket::Reconnect() success!

15:26:53.596    125741  Protocol V14, Sending packet: type: 32, serial: 9, , CMD_DISCONNECT, encryption=Y(Y), requested by stmt4attr, 0 attributes, 0 bytes of data

15:26:53.596    125741  exaSocket::exaSend() encrypted

15:26:53.596    125741  exaSocket::exaSend() encrypted

15:26:53.596    125741  exaSocket::exaFlush()

15:26:53.596    125741  exaSocket::exaSendBase() msgLen=21, sendBufferPos=21, sendNow==true

15:26:53.596    125741  exaSocket::exaGetAnswer()

15:26:53.596    125741  exaSocket::exaSafeRecv() encrypted

15:26:53.596    125741  exaSocket::exaSafeRecvBase(), timeout=0

15:42:44.695    125741  exaHandle::SetDiagRec() added one new error messages for handle 2: -30139776 HY000 [EXASOL][EXASolution driver]Error in socket read.

15:42:44.695    125741  exaSocket::exaSafeRecvBase(), err 4: POLLIN|POLLERR|POLLHUP

15:42:44.695    125741  SOCKET_ERROR: ErrorRecv

15:42:44.695    125741  exaHandle::SetDiagRec() added one new error messages for handle 2: -409537 08S01 [EXASOL][EXASolution driver]Error receiving message from Exasol. Socket failure. (Session: 1683193176614719609)

15:42:44.695    125741  exaHandle::SetDiagRec() added one new error messages for handle 2: -30139776 HY000 [EXASOL][EXASolution driver]Error code was 0

15:42:44.695    125741  ExecSQL: exaGetAnswer returned an error.

15:42:44.695    125741  exaHandle::SetDiagRec() added one new error messages for handle 2: -48150288 SO100 [EXASOL][EXASolution driver]Server communication error.

15:42:44.695    125741  exaSocket::Reconnect()

15:42:44.695    125741  exaSocket::closeSocket()15:42:45.695    125741   Start resolving hostname 10.46.90.32, connectTimeout=0

15:42:45.695    125741  Original server name: 10.46.90.32

15:42:45.695    125741      10.46.90.32

15:42:45.695    125741  exaSocket::ConnectToServer try to connect to 10.46.90.32. connectTimeout=0

15:42:45.863    125741  exaSocket::ConnectToServer timed_connect returned 0.

15:42:45.863    125741  exaSocket::ConnectToServer errno: Operation now in progress

15:42:45.863    125741  Login: using password authetication

15:42:45.863    125741  exaSocket::Login()

15:42:45.863    125741  AddAttribute ATTR_USERNAME STRING(14) tableau_test_p

15:42:45.863    125741  AddAttribute ATTR_RELEASE_VERSION STRING(5) 6.2.9

15:42:45.863    125741  AddAttribute ATTR_CLIENTOS_USERNAME STRING(4) root

15:42:45.863    125741  AddAttribute ATTR_CLIENTOS STRING(82) x86_64 : Linux : #1 SMP Tue Mar 17 23:49:17 UTC 2020 : 3.10.0-1062.18.1.el7.x86_64

15:42:45.863    125741  AddAttribute ATTR_AUTOCOMMIT BOOL 1

15:42:45.863    125741  AddAttribute ATTR_DRIVERNAME STRING(10) Exasol CLI

15:42:45.863    125741  AddAttribute ATTR_RELEASE_REVISION STRING(60) exasol/db.git+6.2.9:ba1ced5f5863a687d3f33b41a86711a7711ddad5

15:42:45.864    125741  AddAttribute ATTR_CLIENTVERSION STRING(5) 6.2.9

15:42:45.864    125741  AddAttribute ATTR_LANGUAGE STRING(1) C

15:42:45.864    125741  AddAttribute ATTR_NUMERIC_CHARACTERS STRING(2) .,

15:42:45.864    125741  Login: Reconnect for session ID: 1683193176614719609

15:42:45.864    125741  AddAttribute ATTR_SESSIONID INT64 1683193176614719609

exa-Chris
Community Manager
Community Manager

Hi Param,

thank you for the reply, this case has been forwarded to an interal ticket in our myExasol System.
We will run ongoing discussion the commucation through the ticketing system and update here
when a solution has been found. If you do not have access to myExasol. Please contact your
myExasol User Manager. Please direct all further questions to the EXA-Ticket System
For reference on myExasol please see this article:
https://community.exasol.com/t5/community-resources/about-myexasol-accounts/ta-p/39

Rgds

@exa-Chris 
P.S: If you have any further questions on this Topic, please send me a DM

Connecting Customers, Partners, Prospects and Exasolians is my passion. Apart from that I cycle, listen to music, and try to understand what all those technical discussions really mean...

View solution in original post