Hi Divya,
Thanks for sharing the logs unfortunately I don't see any additional
information in it. Can you please try following:
1) Enable trace logging on Drillbit side for Rpc package? You can do so by
adding below block in logback.xml file location under conf directory and then
restart the Drillbit process.
2) Enable DrillClient logging which can be done from ODBC Data Source
Administrator-->configure-->
LoggingOptions-->Choose logging level to LOG_TRACE and provide a directory to
write log files.
Please share logging captured from step 1 and 2 and also configuration file to
know more about the setup.
<logger name="org.apache.drill.exec.rpc" additivity="false">
<level value="trace" />
<appender-ref ref="FILE" />
</logger>
Thanks,
Sorabh
________________________________
From: Divya Gehlot <[email protected]>
Sent: Tuesday, May 8, 2018 8:29:26 PM
To: Sorabh Hamirwasia
Cc: [email protected]
Subject: Re: tableau drill connection - handshake time out error
Hi Sorabh,
On the machine where Tableau Desktop is installed , I am able to login through
Drill Explorer .
Neither able to login throug tableau desktop nor tableau server.
I did enabled ODBC tracing and here is link[1] of the tracing log .
Here is the error which I could see at tableau side
[MapR][Drill] (40) Handshake timed out (HandshakeTimeout=5) while trying to
connect to local=xxx.xxx.xxx:31010.[2] Check whether Drillbit is running in a
healthy state or increase the timeout.
Unable to connect to the server "xxxx.xxx.xxx".[2] Check that the server is
running and that you have access privileges to the requested database.
[1]
https://pastebin.com/kcwCsPDa<https://urldefense.proofpoint.com/v2/url?u=https-3A__pastebin.com_kcwCsPDa&d=DwMFaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=gRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=vBD-1LbMWUnMeiw3ltxJM2woojrJcry15nhWKxDVMKU&s=UFzN26yrHAc_XjKzK4a_8KmaRd1aSbtfKSmopOPL17A&e=>
[2]Removed the Domain name.
Thanks,
Divya
On 9 May 2018 at 00:55, Sorabh Hamirwasia
<[email protected]<mailto:[email protected]>> wrote:
Hi Divya,
If you are seeing no logs on server side (considering logging is not disabled)
that means issue is on the client side setup. It can be either on Tableau or
with the ODBC driver itself. In your previous thread you mentioned the setup
was working fine when using Drill Explorer. If you were using the same driver
then that points to Tableau side of issue.
Can you provide error which you are seeing on client side ? Also can you try
enable logging [1] for ODBC driver to see if it provides any other information.
[1]:
https://docs.microsoft.com/en-us/sql/odbc/admin/setting-tracing-options?view=sql-server-2017<https://urldefense.proofpoint.com/v2/url?u=https-3A__docs.microsoft.com_en-2Dus_sql_odbc_admin_setting-2Dtracing-2Doptions-3Fview-3Dsql-2Dserver-2D2017&d=DwMFaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=gRpEl0WzXE3EMrwj0KFbZXGXRyadOthF2jlYxvhTlQg&m=vBD-1LbMWUnMeiw3ltxJM2woojrJcry15nhWKxDVMKU&s=Wp6UcHNQiLoP7aeJ4KVRWCxsTaWjsT4Pf1l37780PH4&e=>
Thanks,
Sorabh
________________________________
From: Divya Gehlot <[email protected]<mailto:[email protected]>>
Sent: Tuesday, May 8, 2018 3:05 AM
To: [email protected]<mailto:[email protected]>; Sorabh Hamirwasia
Subject: Re: tableau drill connection - handshake time out error
Hi,
I don't see any entry in drillbit.log and drillbit.out file when I try log in
through tableau.
I tried with Tableau desktop(10.2) and tableau Server (10.5).None worked for me
.
Its the 3 node MapR 5.2 having Drill 1.10.0 version .
Thanks,
Divya
On 4 May 2018 at 01:30, Sorabh Hamirwasia
<[email protected]<mailto:[email protected]>> wrote:
Hi Divya,
Can you please share the error seen on client side and also debug/error logs
from server side (from drillbit.log and drillbit.out) ? Also what is the setup
of your environment ? Are you using Tableau Server or Desktop version ?
Thanks,
Sorabh
________________________________
From: Divya Gehlot <[email protected]<mailto:[email protected]>>
Sent: Wednesday, May 2, 2018 9:23:45 PM
To: [email protected]<mailto:[email protected]>
Subject: Re: tableau drill connection - handshake time out error
Hi ,
Facing strange issue .
Apache Drill is connected to Active directory .I am able to connect apache
Drill through Web UI and Drill Explorer using my account,but unable to
connect to Apache Drill through Tableau using my account getting handshake
error .
However If I use some other account to connect through Apache Drill in
Tableau , able to connect successfully.
What could be the reason that I am unable to connect Apache Drill through
Tableau.
Has anybody face this issue .
I am yet to figure out whether its a Drill issue or Tableau.
Appreciate the help !
Thanks,
Divya
On 2 May 2018 at 22:06, Andries Engelbrecht
<[email protected]<mailto:[email protected]>> wrote:
> Check the health of your storage plugins on the drillbit/server/cluster
> side.
> Run a show schemas in sqlline on the drillbit and see how long it takes to
> get back.
>
>
> --Andries
>
> On 5/2/18, 3:24 AM, "Divya Gehlot"
> <[email protected]<mailto:[email protected]>> wrote:
>
> Hi Robert,
> Thanks for the response.
> It was all working while earlier . I am getting this error past couple
> of
> days .
> As you mentioned check the drill bit health and state of the server
> environment .
> Which configurations do I need check ? Can you please elaborate more.
> I am successfuly able to connevt to Drill through Drill explorer and
> through Web UI of Apache Drill .
> Earlier I was able to connect Drill through tableau without making
> changes
> to Drill configurations .
> I haven't made any changes to Drill configurations also.
> Wondering what triggering handshake error.
>
>
>
> Grateful for your help !
>
> Thanks,
> Divya
>
>
>
> On 2 May 2018 at 17:08, Robert Wu
> <[email protected]<mailto:[email protected]>> wrote:
>
> > Hi Divya,
> >
> > Normally 5 second default for the client server handshake is enough
> for
> > most setup.
> > Since you mentioned that this incident is out of the ordinary, I
> would
> > double check the health of the drillbit and the state of the server
> > environment.
> >
> > ------------------ If you need to modify the handshake timeout value
> > ------------------
> > You can set the HandshakeTimeout value in the AdvancedProperties
> field in
> > the ODBC driver. The default value is 5 seconds.
> > https://urldefense.proofpoint.com/v2/url?u=https-3A__drill.
> apache.org_docs_odbc-2Dconfiguration-2Dreference_&d=DwIFaQ&c=
> cskdkSMqhcnjZxdQVpwTXg&r=Q3Oz5l4W5TvDHNLpOqMYE2AgtKWFE937v89GEHyOVDU&m=
> JWJb4hdyVwAb6BMNHqmYIDRzArDhsA6FtipM3pFd_HE&s=
> TF03KzLjSs9F5UwHg3cjsviPr36hGSYh3tVfjL0H-KQ&e=
> >
> > Are you connecting to drillbit using Tableau's " Other Databases
> (ODBC)"
> > connector or the "Apache Drill" connector?
> >
> > If you are using the "Other Databases (ODBC)" connector in Tableau:
> > And connecting via DSN:
> > Please open the ODBC Administrator (make sure it’s
> the
> > correct bitness) and click on the "System DSN" tab.
> > Then, click on "MapR Drill" and then click the
> > "Configure..." button on the right.
> > Then, please modify the default HandshakeTimeout
> value
> > from 5 seconds to your preference.
> > Then, click the ok button to save the setting.
> >
> > And connecting via Driver:
> > A configuration popup window should appear when you
> try to
> > connect. Add HandshakeTimeout=<value> in the AdvancedProperties
> field.
> >
> > If you are using the Apache Drill connector in Tableau:
> > Then you would need to create a custom settings file for
> Tableau
> > to pick up this information.
> >
> > Best regards,
> >
> > Rob
> >
> > -----Original Message-----
> > From: Divya Gehlot
> <[email protected]<mailto:[email protected]>>
> > Sent: Wednesday, May 2, 2018 12:11 AM
> > To: [email protected]<mailto:[email protected]>
> > Subject: tableau drill connection - handshake time out error
> >
> > Hi ,
> > I am connecting Apache Drill through Tableau 10.X version .
> > I was able to connect successfully for this while Now all of sudden
> I am
> > getting handshake timeout error when I try connect drill through
> tableau.
> > Error :
> > [MapR][Drill] (40) Handshake timed out (HandshakeTimeout=5) while
> trying
> > to connect to local=xx.xx.xx.x:31010. Check whether Drillbit is
> running in
> > a healthy state or increase the timeout.
> >
> > I try adding below configurations in drill-overide.conf also
> #Optional
> > handshakeTimeout in milliseconds. Default is 10000 ms (10
> > seconds)
> > handshakeTimeout: 60000,
> >
> > but it didnt help.
> >
> > Appreciate the help !
> >
> > Thanks,
> > Divya
> >
>
>
>
