1 2 Previous Next 20 Replies Latest reply on Oct 9, 2015 8:54 AM by kaifeng zeng

    Error running TabJolt: Invalid resp body when calling setSheetId

    Toni Juvani

      I'm using the latest TabJolt (downloaded 12th September 2015) to connect to a Tableau Server using a specified user account. All executions end in an error: "Invalid resp body when calling setSheetId".

       

      Output from TabJolt:

       

      C:\tabjolt>go --t=testplans\ViewVizLoadTest.jmx --d=30 --c=1

      Perf harness is started with parameters: --rootPath=C:\tabjolt --t=testplans\ViewVizLoadTest.jmx --d

      =30 --c=1

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

      Output File:c:\tabjolt/results/2015-09-13_09-05-18/wincounter.tsv

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

      Output File:C:\tabjolt/results/2015-09-13_09-05-18/jmxcounter.tsv

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

      Output File:C:\tabjolt/results/2015-09-13_09-05-18/zabbixcounter.tsv

      -------------start Jmeter load test run-------------

      Output file: C:\tabjolt/results/2015-09-13_09-05-18/result.jtl

      Command: [C:\tabjolt/bin/jmeter.bat, -n, -t=C:\tabjolt//testplans\ViewVizLoadTest.jmx, -j=C:\tabjolt

      /logs/jmeter_2015-09-13_09-05-18.log, -JthreadCount=1, -Jduration=30, -JconfigFolderPath=C:\tabjolt/

      config/, -Jlogpath=C:\tabjolt/results/2015-09-13_09-05-18/result.jtl]

      Created the tree successfully using C:\tabjolt//testplans\ViewVizLoadTest.jmx

      Starting the test @ Sun Sep 13 09:05:19 UTC 2015 (1442135119805)

      Waiting for possible shutdown message on port 4445

      SLF4J: Class path contains multiple SLF4J bindings.

      SLF4J: Found binding in [jar:file:/C:/tabjolt/lib/slf4j-nop-1.7.5.jar!/org/slf4j/impl/StaticLoggerBi

      nder.class]

      SLF4J: Found binding in [jar:file:/C:/tabjolt/lib/ext/slf4j-nop-1.7.7.jar!/org/slf4j/impl/StaticLogg

      erBinder.class]

      SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.

      SLF4J: Actual binding is of type [org.slf4j.helpers.NOPLoggerFactory]

      #0      Threads: 1/1    Samples: 1      Latency: 0      Resp.Time: 35   Errors: 1

      #1      Threads: 1/1    Samples: 2      Latency: 0      Resp.Time: 33   Errors: 2

      #2      Threads: 1/1    Samples: 31     Latency: 0      Resp.Time: 31   Errors: 31

      #3      Threads: 1/1    Samples: 33     Latency: 0      Resp.Time: 30   Errors: 33

      #4      Threads: 1/1    Samples: 32     Latency: 0      Resp.Time: 30   Errors: 32

      #5      Threads: 1/1    Samples: 32     Latency: 0      Resp.Time: 30   Errors: 32

      #6      Threads: 1/1    Samples: 32     Latency: 0      Resp.Time: 31   Errors: 32

      #7      Threads: 1/1    Samples: 31     Latency: 0      Resp.Time: 31   Errors: 31

      #8      Threads: 1/1    Samples: 31     Latency: 0      Resp.Time: 32   Errors: 31

      #9      Threads: 1/1    Samples: 32     Latency: 0      Resp.Time: 31   Errors: 32

      #10     Threads: 1/1    Samples: 32     Latency: 0      Resp.Time: 31   Errors: 32

      #11     Threads: 1/1    Samples: 32     Latency: 0      Resp.Time: 30   Errors: 32

      #12     Threads: 1/1    Samples: 33     Latency: 0      Resp.Time: 30   Errors: 33

      #13     Threads: 1/1    Samples: 32     Latency: 0      Resp.Time: 30   Errors: 32

      #14     Threads: 1/1    Samples: 32     Latency: 0      Resp.Time: 30   Errors: 32

      #15     Threads: 1/1    Samples: 31     Latency: 0      Resp.Time: 32   Errors: 31

      #16     Threads: 1/1    Samples: 32     Latency: 0      Resp.Time: 31   Errors: 32

      #17     Threads: 1/1    Samples: 32     Latency: 0      Resp.Time: 31   Errors: 32

      #18     Threads: 1/1    Samples: 32     Latency: 0      Resp.Time: 31   Errors: 32

      #19     Threads: 1/1    Samples: 32     Latency: 0      Resp.Time: 30   Errors: 32

      #20     Threads: 1/1    Samples: 33     Latency: 0      Resp.Time: 30   Errors: 33

      #21     Threads: 1/1    Samples: 32     Latency: 0      Resp.Time: 31   Errors: 32

      #22     Threads: 1/1    Samples: 32     Latency: 0      Resp.Time: 31   Errors: 32

      #23     Threads: 1/1    Samples: 32     Latency: 0      Resp.Time: 31   Errors: 32

      #24     Threads: 1/1    Samples: 32     Latency: 0      Resp.Time: 30   Errors: 32

      #25     Threads: 1/1    Samples: 33     Latency: 0      Resp.Time: 30   Errors: 33

      #26     Threads: 1/1    Samples: 32     Latency: 0      Resp.Time: 31   Errors: 32

      #27     Threads: 1/1    Samples: 33     Latency: 0      Resp.Time: 30   Errors: 33

      #28     Threads: 1/1    Samples: 32     Latency: 0      Resp.Time: 30   Errors: 32

      #29     Threads: 1/1    Samples: 32     Latency: 0      Resp.Time: 31   Errors: 32

      #30     Threads: 1/1    Samples: 32     Latency: 0      Resp.Time: 30   Errors: 32

      Tidying up ...    @ Sun Sep 13 09:05:50 UTC 2015 (1442135150896)

      ... end of run

      Jmeter process has exited. Waiting for the other processes to exit.

      All processes have exited.

      -------------start processing perf counters and run result-------------

      Finished processing all perf counter records

      Finish processeing all Jmeter perf result samples.

      -----------------------------------------------------

      Perf run result have been stored. Please use this RUN ID 28 to view your result in Tableau

       

      Error message in result.jtl stays the same:

       

      <sample t="122" lt="0" ts="1437414972969" s="false" lb="Interact Viz Test" rc="" rm="Failed to finish View Viz Test. Workbook: CompanyNameDashboard; View: CorporateView; IsPublic: false; TopViews: null; Exception: java.lang.Exception: Invalid resp body when calling setSheetId!" tn="InteractVizThreadGroup 1-1" dt="" by="0" ng="1" na="1">

        <sample t="15" lt="0" ts="1437414973066" s="true" lb="init view session. optionalRenderMode: default; isEmbedded: false; noShowVizHome: false" rc="200" rm="done with initializing view session null." tn="InteractVizThreadGroup 1-1" dt="" by="1509" ng="0" na="0"/>

        <sample t="18" lt="0" ts="1437414973081" s="false" lb="init view session. optionalRenderMode: default; isEmbedded: true; noShowVizHome: false" rc="" rm="Timer did not end properly. SubResult EndTime is 0." tn="InteractVizThreadGroup 1-1" dt="" by="0" ng="0" na="0"/>

      </sample>

       

      What I've done so far:

      1. I was using sites, changed to the default site => no effect

      2. I was using SSL, changed to HTTP => no effect

      3. Tried to modify the username to an incorrect one => no change in error message

       

      Content of ServerTestConfig.yaml:

      default {

          # tableau server host name:

          hostUri: http://tableau-dev.utilytics.enoro.com/

       

       

          # HTTP User-Agent

          userAgent: java-client-requests

       

       

          users:

              - !!com.tableausoftware.test.server.configuration.User        

                name: outsystemsuser

                password: xxxxx

      }

       

      Content of vizpool.csv:

      /views/TimeSeriesViewer/TimeSeriesViewer/27

       

      See also attached:

      1. Wireshark capture of unsuccessful test run

      2. Extracted TCP stream from unsuccessful test run

      3. Wireshark capture of a successful open of a workbook with a browser

      4. Extracted TCP stream from a successful open of a workbook with a browser


      Br,

      Toni

        1 2 Previous Next