KNOWLEDGE BASE

Error "Could not find match for <Database Name>" Exporting Oracle Based Flow Output Via Command Line


Published: 21 Sep 2018
Last Modified Date: 21 Jan 2019

Issue

A flow based on an Oracle data source can be run via the Tableau Prep UI, but fails when run via the command line (tableau-prep-cli.bat) with the following error: 
Could not find match for <database name>

Environment

  • Tableau Prep 2018.2.3 - 2018.3.1
  • Oracle

Resolution

Option 1:

  1. Upgrade to Tableau Prep 2018.3.2 or a newer version. For more information, see Install Tableau Prep.
  2. In Tableau Prep, provide all connection information in the Server field in the form <ServerName:Port/Service>. Leave fields Port and Service empty.
  3. In the .json file, provide the connection information in a single line "hostname":" ServerName:Port/Service".

See the following Community post for details, Trying to schedule a Tableau Prep workflow with Oracle data source.

Option 2:

As a workaround, specify the port number in the Tableau Prep GUI, or run the flow directly in Tableau Prep. 
 

Cause

This behavior is related to known issue ID 825086 and was resolved in the 2018.3.2 release of Tableau Prep, and all more recent versions.

Did this article resolve the issue?