KNOWLEDGE BASE

Refreshing Flow Output From Command Line Error "The following connection(s) were not found: <data source server>"


Published: 28 Nov 2019
Last Modified Date: 09 Mar 2020

Issue

When refreshing flow output files from the command line, the following error may occur:

"We don't have credentials of all connections in tfl/tflx file. The following connection(s) were not found: <data source server>"

Environment

  • Tableau Prep Builder
  • Windows
  • Command Line Interface
  • Flow connecting to databases

Resolution

Ensure the connection details in the credentials .json file is set up the EXACT same way as the connection string to the database server when the Tableau flow file (.tfl) was initially created. Meaning, if the connection string to the database server does not have a port/service, then do not include a port/service value in the .json credentials file under Input Connections.

Steps to check:
  1. Open the flow in Tableau Prep Builder.
  2. Select the connection to the database > Edit connection.
  3. Choose the database server specified under Server.
  4. Open your .json credentials file.
  5. Pay attention to the Input Connections and make sure it matches the Edit Connection details in the flow.
  6. If there are NO ports specified in Edit Connections, then do NOT specify a port in json credentials file.

Cause

When you run the process, the hostname, port and username provided in the credentials .json file is used to find the matching connection in the Tableau flow file (tfl) and update it before running the process
Did this article resolve the issue?