1 Reply Latest reply on Aug 7, 2018 2:53 PM by Jeff Strauss

    How can i debug "test connection" in data source section?

    Amit Gelber

      can't figure out why i can't connect.

      trying to connect to Microsoft Analysis Services with no success.

       

      where can i find logs for this?

      installed every possible driver.

       

      Thanks. Screen Shot 2018-08-07 at 13.11.43.png

        • 1. Re: How can i debug "test connection" in data source section?
          Jeff Strauss

          Where you can look are two places within your logs directory on the server itself.  For me, it's g:\tableau\tableau server.

           

          G:\Tableau\Tableau Server\data\tabsvc\logs\vizportal\vizportal-x.log - this handles the incoming request, but doesn't provide so much useful info:

          2018-08-07 16:45:06.307 -0500 (-,-,-,W2oS4sQef6sb@mkbqgvJEQAAA94,1:-4c8d7696:164ec78a722:-7d24) catalina-exec-4 : INFO  com.tableausoftware.app.vizportal.LoggingInterceptor - Request received: /v1/checkConnection

          2018-08-07 16:45:06.311 -0500 (Internal,jstrauss,W5bPx1YSRji8n7tHscPTfw,W2oS4sQef6sb@mkbqgvJEQAAA94,1:-4c8d7696:164ec78a722:-7d24) catalina-exec-4 : INFO  com.tableausoftware.api.webclient.remoting.SimpleRemoteCallProxy - WebClient API: Calling checkConnection

          2018-08-07 16:45:06.312 -0500 (Internal,jstrauss,W5bPx1YSRji8n7tHscPTfw,W2oS4sQef6sb@mkbqgvJEQAAA94,1:-4c8d7696:164ec78a722:-7d24) catalina-exec-4 : INFO  com.tableausoftware.instrumentation.InstrumentationUtil - Instrumenting 'public com.tableausoftware.api.webclient.viewmodels.CheckConnectionViewModel com.tableausoftware.api.webclient.impl.WebClientAppService.checkConnection(com.tableausoftware.domain.user.IAuthenticatedUser, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.Boolean, java.lang.String, java.lang.String)' as 'com.tableausoftware.instrumentation:00=api,01=webClient,name=checkConnection,type=methods'.

          2018-08-07 16:45:06.326 -0500 (Internal,jstrauss,W5bPx1YSRji8n7tHscPTfw,W2oS4sQef6sb@mkbqgvJEQAAA94,1:-4c8d7696:164ec78a722:-7d24) catalina-exec-4 : INFO  com.tableausoftware.sos.Registry - creating initial binding for datasource_reduced; config:TypeConfiguration[m_type=datasource_reduced,m_cache=noop,m_primary=db,m_secondaries=[],m_triggers={},m_batchSize=<null>,m_gracePeriod=<null>]

           

           

          The log that has a bit more detail is at: G:\Tableau\Tableau Server\data\tabsvc\logs\vizqlserver\tabprotosrv_vizportal_x-x.txt

          {"ts":"2018-08-07T16:45:06.879","pid":37344,"tid":"9528","sev":"warn","req":"-","sess":"-","site":"-","user":"-","k":"msg","v":"throw DataSourceException (type=BadPassword): [DataDirect][ODBC Greenplum Wire Protocol driver]Socket closed.\n[DataDirect][ODBC Greenplum Wire Protocol driver]Socket closed.\n[DataDirect][ODBC Greenplum Wire Protocol driver][Greenplum]FATAL: password authentication failed for user \"userid_report_utility\"(File auth.c; Line 326; Routine auth_failed; )\n","ctx":{"client-type":"vizportal","procid":"2684","requestID":"-","sessionid":"DBE2BDE2BA714CDE8976C099281BC046-1:1","tid":"14064","username":"jstrauss"}}