KNOWLEDGE BASE

Error "We don't have credentials of all connections in tfl/tflx file." When Running a Flow Connection to Apache Drill


Published: 04 Dec 2019
Last Modified Date: 30 Dec 2019

Issue

Running a flow connecting to Apache Drill using ZooKeeper from command line would fail and the following error message might occur:

We don't have credentials of all connections in tfl/tflx file. The following connection(s) were not found: hostname:xxxx

Environment

  • Tableau Prep Builder
  • Apache Drill

Resolution

Ensure "port": "31010" is included in the credential .json file. See below an example of a created credential file: 
{
"inputConnections":[
  {
    "hostname":"hostname:xxxx",
    "port": "31010",
    "username": "xxxx",
    "password": "xxxx"
  }
]
}

Cause

Tableau Prep Builder needs port of 31010 to communicate with Apache Drill.

Additional Information

For additional information about this topic see: Ports Used by Drill in the Apache Drill documentation. 
Did this article resolve the issue?