KNOWLEDGE BASE

Unable To Run Flow Connecting To Tableau Cloud By Tableau Prep Builder Command Line On Proxy Configured Environment


Published: 27 Nov 2020
Last Modified Date: 08 Jul 2022

Issue

When running a flow which includes connection to Tableau Cloud by Tableau Prep Builder Command Line (CLI), the flow fails if a proxy server is configured. The flow successfully can be run by Tableau Prep Builder GUI.

Environment

  • Tableau Prep Builder

Resolution

Option 1
Edit tableau-prep-cli.bat to include the proxy server information as below:
  1. Go to C:\Program Files\Tableau\Tableau Prep Builder <version>\scripts by Windows Explorer.
  2. Copy tableau-prep-cli.bat and save with an another name to create a backup copy.
  3. Open tableau-prep-cli.bat by a text editor.
  4. Set DEFAULT_JVM_OPT with replacing values for DproxyHost and DproxyPort with the appropriate values for your environment, then save the file
    @rem Add default JVM options here. You can also use JAVA_OPTS and TPREP_CLI_APP_OPTS to pass JVM options to this script.
    set DEFAULT_JVM_OPTS=-DproxySet=true -DproxyHost=<Host name or IP address of the proxy server> -DproxyPort=<port number of the proxy server>
    

Option 2
Edit "net.properties" to configure proxy information.

Note: If you don’t have write permissions on this file, use the system file settings to enable them.

Warning: Make sure to only include the hostname. For example,  if the proxy server address is http://myproxy:8888, then it should be http.proxyHost=myproxy in the example below.

  1. In your file directory, verify the version of Java used to run Tableau Prep Builder.
    • Windows example: C:\Program Files\Tableau\Tableau Prep Builder <Version>\Plugins\jre\
  2. In the Java locations directory, select the conf folder. If this directory doesn’t exist, then create one.  By default the location is: C:\Program Files\Tableau\Tableau Prep Builder<version>\Plugins\jre\conf   
  3. In the conf folder, locate the net.properties file, and open it in a text editor. If this file doesn’t exist, then create one by the same name.
  4. Modify or create the following values in net.properties file and save it:
    • http.proxyPort=<your proxy port>
    • http.proxyHost=<your proxy host address>
    • http.nonProxyHosts=localhost|127.*|[::1]|<your proxy host address>
    • https.proxyPort=<your proxy port>
    • https.proxyHost=<your proxy host address>
  5. Run the flow again with Tableau Prep Command Line.

Cause

Tableau Prep's Java is not using the system proxy.
Did this article resolve the issue?