TabJolt install error: Unable to write to TEMP environment variable
Jason McCann Nov 17, 2016 7:28 AMHello 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
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,357][main] (Main.java:286) - Failed to process perf counters and run result.
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
INFO [2016-11-17 08:19:36,357][Thread-1] (PerfRunMonitor.java:37) - Starting Perfrun monitor thread
Then the test looks to run and complete without issue. However, when I try to open the PerformanceViz my password is rejected; using the credentials listed in PerfTestConfig.yaml.
I've attempted to uninstall and reinstall. I've also installed TabJolt on another machine but end with the same result. I've confirmed that my user can write to the directory listed in the TEMP environment variable.
Suggestions?