1 Reply Latest reply on Nov 18, 2016 12:20 PM by Jason McCann

TabJolt install error: Unable to write to TEMP environment variable

Jason McCann Nov 17, 2016 7:28 AM

Hello all,

When running the TabJolt install I receive a message "Unable to write to TEMP environment variable" (appears around the time postgres is being installed)

The install does complete successfully and I'm presented with the configuration screens. I fill those out and attempt to run a load.

At first I receive a handful of errors:

C:\Tabjolt>go --t=\testplans\ViewInteractVizLoadTest.jmx --d=30 --c=1 --r=30sec1thread

[2016-11-17 08:19:32,856] Perf harness is started with parameters: --rootPath=C:\Tabjolt --t=\testplans\ViewInteractVizLoadTest.jmx --d=30 --c=1 --r=30sec1thread

[2016-11-17 08:19:32,997] Loading PerfTestConfig yaml file C:\Tabjolt\config\PerfTestConfig.yaml

[2016-11-17 08:19:33,059] Loading ServerTestConfig yaml file C:\Tabjolt\config\ServerTestConfig.yaml

Error Unable to get instances for category Processor of host TABLEAU-SERVER. Skip collecting perf counters for the category. Exception Message: Access is denied

Error Unable to get instances for category Memory of host TABLEAU-SERVER. Skip collecting perf counters for the category. Exception Message: Access is denied

Error Unable to get instances for category Network Interface of host TABLEAU-SERVER. Skip collecting perf counters for the category. Exception Message: Access is denied

Error Unable to get instances for category Process of host TABLEAU-SERVER. Skip collecting perf counters for the category. Exception Message: Access is denied

Error Unable to get instances for category LogicalDisk of host TABLEAU-SERVER. Skip collecting perf counters for the category. Exception Message: Access is denied

-------------start collecting JMX counters--------------

Output File:C:\Tabjolt/results/2016-11-17_08-19-32/jmxcounter.tsv

-------------start collecting Zabbix counters--------------

Output File:C:\Tabjolt/results/2016-11-17_08-19-32/zabbixcounter.tsv

-------------start windows performance counters collection-------------

Output File:c:\tabjolt/results/2016-11-17_08-19-32/wincounter.tsv

INFO [2016-11-17 08:19:35,259][main] (PerfRunHelper.java:347) - -------------start Jmeter load test run-------------

INFO [2016-11-17 08:19:35,259][main] (PerfRunHelper.java:348) - Output file: C:\Tabjolt/results/2016-11-17_08-19-32/result-TABJOLT-SERVER-0.jtl

INFO [2016-11-17 08:19:35,259][main] (PerfRunHelper.java:349) - Command: [C:\Tabjolt/bin/jmeter.bat, , , , , , -n, -t=C:\Tabjolt\\testplans\ViewInteractVizLoadTest.jmx, -j=C:\Tabjolt/logs/jmeter_2016-11-17_08-19-32.log, -JthreadCount=1, -Jduration=30, -JloginWeight=1.0, -JconfigFolderPath=C:\Tabjolt/config/, -Jlogpath=C:\Tabjolt/results/2016-11-17_08-19-32/result-TABJOLT-SERVER-0.jtl, , ]

Created the tree successfully using C:\Tabjolt\\testplans\ViewInteractVizLoadTest.jmx

Starting the test @ Thu Nov 17 08:19:35 CST 2016 (1479392375904)

Waiting for possible shutdown message on port 4445

ERROR [2016-11-17 08:19:36,342][main] (PostgresDBHelper.java:55) - unable to create connection with DB

org.postgresql.util.PSQLException: Connection to localhost:48123 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:252)

at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:67)

at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:216)

at org.postgresql.Driver.makeConnection(Driver.java:406)

at org.postgresql.Driver.connect(Driver.java:274)

at java.sql.DriverManager.getConnection(DriverManager.java:664)

at java.sql.DriverManager.getConnection(DriverManager.java:247)

at com.tableausoftware.test.tools.ResultProcessor.PostgresDBHelper.getInstance(PostgresDBHelper.java:47)

at com.tableausoftware.test.tools.ResultProcessor.DBHelperFactory.getDBHelperInstance(DBHelperFactory.java:29)

at com.tableausoftware.test.tools.ResultProcessor.ResultProcessor.<init>(ResultProcessor.java:103)

at com.tableausoftware.test.tools.perfRunHarness.Main.startPerfResultsSaver(Main.java:278)

at com.tableausoftware.test.tools.perfRunHarness.Main.runOneTest(Main.java:238)

at com.tableausoftware.test.tools.perfRunHarness.Main.main(Main.java:140)

Caused by: java.net.ConnectException: Connection refused: connect

at java.net.DualStackPlainSocketImpl.connect0(Native Method)

at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)

at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)

at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)

at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)

at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)

at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)

at java.net.Socket.connect(Socket.java:589)

at org.postgresql.core.PGStream.<init>(PGStream.java:64)

at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:133)

... 12 more

ERROR [2016-11-17 08:19:36,342][main] (ResultProcessor.java:105) - Unable to get DB Helper instance