3 Replies Latest reply on Jul 27, 2015 11:34 AM by Jeff Strauss

    TabJolt Issues

    Ralino da Costa
      •         Hi,

       

      We have tried configuring TabJolt on a Windows machine.

       

       

       

      Steps Followed

       

       

       

      1. Changed the HostUrl to the Tableau Sever URL that internal Users use.Although we use SSL, I didn't use the "https:" in the hosturl.  { xyz is the Worker where processes run"}

       

             Enabled the JMX counter by uncommented the XML tags

       

       

       

      3. Added a single View from the "default" site in the "vizpool.csv" file

       

       

       

      4. Specified an Admin account

       

       

       

      However, I'm seeing error when I try and run "TabJolt.

       

       

       

      ________________________Error Log ___________________________________

       

       

       

      FATAL [setUp Thread Group 1-1] com.tableausoftware.test.server.perfTestSuite.LoadSessionSetup (LoadSessionSetup.java:45)   - Failed to set up load test session. Stopping the test run.

       

      java.lang.StringIndexOutOfBoundsException: String index out of range: -1

       

      at java.lang.String.substring(Unknown Source)

       

      at com.tableausoftware.vizportal.test.webClientApi.WebClientApiResponse.createViewModel(WebClientApiResponse.java:79)

       

      at com.tableausoftware.vizportal.test.webClientApi.WebClientApiResponse.createViewModel(WebClientApiResponse.java:61)

       

      at com.tableausoftware.vizportal.test.webClientApi.GetServerSettingsUnauthenticatedResponse.(GetServerSettingsUnauthenticatedResponse.java:30)

       

      FATAL [setUp Thread Group 1-1] com.tableausoftware.test.server.perfTestSuite.LoadSessionSetup (LoadSessionSetup.java:45)   - Failed to set up load test session. Stopping the test run.

      java.lang.StringIndexOutOfBoundsException: String index out of range: -1

      at java.lang.String.substring(Unknown Source)

      at com.tableausoftware.vizportal.test.webClientApi.WebClientApiResponse.createViewModel(WebClientApiResponse.java:79)

      at com.tableausoftware.vizportal.test.webClientApi.WebClientApiResponse.createViewModel(WebClientApiResponse.java:61)

      at com.tableausoftware.vizportal.test.webClientApi.GetServerSettingsUnauthenticatedResponse.(GetServerSettingsUnauthenticatedResponse.java:30)

       

      -


      start processing perf counters and run result----


       

      Finish processeing all Jmeter perf result samples.

       

      Finished processing all perf counter records

       

      Failed to process perf counters and run result.

       

      org.postgresql.util.PSQLException: ERROR: division by zero

       

        Where: SQL statement "UPDATE test_runs

       

                      SET TPS_average=(

       

                                   totalSamples/totalseconds

       

                               )

       

                      WHERE id=runId"

       

      PL/pgSQL function "sp_update_test_run_stats" line 116 at SQL statement

       

              at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx

       

      ecutorImpl.java:2161)

       

              at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor

       

      Impl.java:1890)

       

      ___________________________________________________________

       

       

       

      Any help will be appreciated.

      Ralino

       

       

      This e-mail may contain confidential or privileged information. If

      you think you have received this e-mail in error, please advise the

      sender by reply e-mail and then delete this e-mail immediately.

      Thank you. Aetna

       

        • 1. Re: TabJolt Issues
          Jeff Strauss

          carry over from the earlier post.

           

           

          I see the confusion.  There are 2 postgres repositories.  tabjolt uses it own local repository to record performance metrics about the server capacity and rendering times.  But then within the serverconfig.yaml it points at the internal Tableau postgres in order to be able to retrieve metadata about the reports that you specify inside of vizpool.csv


          so did you enable the tabadmin dbpass to allow the readonly id to tap into the Tableau postgres?  this is what's needed within the yaml file.

          • 2. Re: TabJolt Issues
            Ralino da Costa

            This is the default configuration from the ServerTestConfig.yaml

             

             

            1. server database connection information

                database:

                    connectionString: jdbc:postgresql://%s:%s

                    serverName: 10.17.136.103

                    port: 8060

                    databaseName: workgroup

                    userName: readonly

                    password: readonly

                    driver: org.postgresql.Driver

                    unicode: true

                    encoding: utf-8

             

            So, do we need to update this section with the PostgresQL DB info which is used by the Tableau server..?

             

            I didn’t see any mention of the same in the Installation document.

             

            Kindly let me know the steps that you mentioned about using Dbpass etc.

             

            Regards,

             

            Ralino

            • 3. Re: TabJolt Issues
              Jeff Strauss

              Change the servername IP to where your Tableau server is at.  I'm not sure if this really matters or not, but the default IP didn't resolve to anything here, so I'm under the impression that it's an IP at Tableau which they use.

               

              Refer to this article for dbpass.  I think it's necessary for tabjolt to be able to tap into the internal PG repository.

              tabadmin commands