KNOWLEDGE BASE

Unable to Connect to Tableau Server Issue Occurs When Running Flow With Command Line in Tableau Prep 2023.1.3 and Earlier Versions


Published: 02 Nov 2023
Last Modified Date: 03 Nov 2023

Issue

The below error occurs when running a flow from the command line in Tableau Prep 2023.1.3 or earlier versions. The same flow runs correctly in the Tableau Prep Builder application.

This flow uses a data source from the Tableau Server or publishes data to the Tableau Server.
 

Can't connect to datasource new name. An error occurred while communicating with Tableau Server
No Tableau Server user found.
DataServiceFailure
There was an error with the data source "". Verify that the data source is configured correctly.


 

Environment

  • Tableau Prep Builder 2023.1.3 and before

Resolution

Please consider using the below workarounds for this issue.

Option 1

Use Tableau Prep 2023.2.1 or a later version.  Downloads are available on the Tableau Release page.
 

Option 2

For Tableau Prep 2023.1.3 or former versions, manually delete the Connected Clients in the Tableau Server Settings page and the flow will be okay to run from the command line.

Cause

This issue has been logged in the Known Issue site and has been fixed in Tableau Prep 2023.2.1 and newer:
W-13499848

Additional Information

The below error occurs in the CLI log:

class Error {
class AbstractError {
additionalInfo: {dbname=24, error-message=An error occurred while communicating with Tableau Server
No Tableau Server user found.
DataServiceFailure
There was an error with the data source "". Verify that the data source is configured correctly.,
 query-category=Data, projectName=XXXXXX, datasourceName=XXXXXXXXX, class=sqlproxy, directory=/dataserver, odbc-native-protocol=yes}
id: ConnectionErrorExceptionMsg
message: Unable to connect to data source XXXXXXX。An error occurred while communicating with Tableau Server
No Tableau Server user found.
 DataServiceFailure
There was an error with the data source "". Verify that the data source is configured correctly.
}
  }


When running the flow once using the command line, the Connected Clients on the Tableau Server Setting page will add one client, even though they are all the same client.

Please check the below image.
User-added image

Did this article resolve the issue?