9 Replies Latest reply on Mar 3, 2016 11:54 AM by Hugh Nguyen

    Tabjolt error - test_runs" does not exist

    anand.sreeram.0

      Hi I checked postgresdb and test_runs table exist. Any help with below is greatly appreciated.

       

       

       

      Output File:c:\users\asreeram\desktop\tabjolt\tabjolt-master/results/2016-02-02_07-44-49/wincounter.tsv

      INFO  [2016-02-02 07:44:52,685][main] (PerfRunHelper.java:340)   - -------------start Jmeter load test run-------------

      INFO  [2016-02-02 07:44:52,691][main] (PerfRunHelper.java:341)   - Output file: C:\Users\asreeram\Desktop\Tabjolt\tabjolt-master/results/2016-02-02_07-44-49/

      result-WW720L99892B-0.jtl

       

       

      INFO  [2016-02-02 07:44:52,694][main] (PerfRunHelper.java:342)   - Command: [C:\Users\asreeram\Desktop\Tabjolt\tabjolt-master/bin/jmeter.bat, , , , , , -n, -

      t=C:\Users\asreeram\Desktop\Tabjolt\tabjolt-master\testplans\InteractVizloadTest.jmx, -j=C:\Users\asreeram\Desktop\Tabjolt\tabjolt-master/logs/jmeter_2016-02

      -02_07-44-49.log, -JthreadCount=1, -Jduration=2, -JconfigFolderPath=C:\Users\asreeram\Desktop\Tabjolt\tabjolt-master/config/, -Jlogpath=C:\Users\asreeram\Des

      ktop\Tabjolt\tabjolt-master/results/2016-02-02_07-44-49/result-WW720L99892B-0.jtl, ]

       

       

      ERROR [2016-02-02 07:44:52,956][main] (Main.java:275)   - Failed to process perf counters and run result.

      org.postgresql.util.PSQLException: ERROR: relation "test_runs" does not exist

        Position: 13

              at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)

              at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)

              at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

              at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)

        • 1. Re: Tabjolt error - test_runs" does not exist
          Hugh Nguyen

          Have you confirm the settings in PerfRunHarness.properties?

          • 2. Re: Tabjolt error - test_runs" does not exist
            anand.sreeram.0

            Hi Hugh,

             

            Attached is the perfRunHarness properties file. I am able to connect to postgress from my tableau desktop and access all the tables.

             

            Regards,

            Anand

            • 3. Re: Tabjolt error - test_runs" does not exist
              Hugh Nguyen

              Hi Anand,

               

              Thanks for sending the properties. Everything appears to be default value. The default DB is "PerfResults." Can you confirm that this is the db you checked for the test_runs table?

               

              I suggest, re-running the SQL queries included in the root folder called, "postgresDBSchemaPart1.sql" and "postgresDBSchemaPart2.sql." These two scripts should create the PerfResults db and all needed tables.


              Hope this helps.

              • 4. Re: Tabjolt error - test_runs" does not exist
                anand.sreeram.0

                Hi Hugh,

                 

                Yes I have successfully run the scripts. Below screen shot gives you the view of all the tables.

                 

                 

                 

                • 5. Re: Tabjolt error - test_runs" does not exist
                  Hugh Nguyen

                  Can you rerun tabjolt and attach logs?

                  • 6. Re: Tabjolt error - test_runs" does not exist
                    anand.sreeram.0

                    I just ran the script. Below is the log:

                     

                    Perf harness is started with parameters: --rootPath=C:\Users\asreeram\Desktop\Tabjolt\tabjolt-master --t=testplans\InteractVizLoadT

                    est.jmx --d=2 --c=1

                    unable to load configuration file based on binary location reflection; continuing...

                    Loaded properties file from C:\Users\asreeram\Desktop\Tabjolt\tabjolt-master/config/PerfRunHarness.properties

                    Looking for `config` starting in: C:\Users\asreeram\Desktop\Tabjolt\tabjolt-master\bin\perfRunHarness

                    Config folder path is: C:\Users\asreeram\Desktop\Tabjolt\tabjolt-master\config

                    Loading Log4j configuration from: C:\Users\asreeram\Desktop\Tabjolt\tabjolt-master\config\log4j.properties

                    INFO  [main] (ServerTestConfig.java:88)   - Loading ServerTestConfig from: ServerTestConfig.yaml

                    INFO  [main] (AbstractConfig.java:79)   - Reading java.test.config.override from System properties...

                    INFO  [main] (AbstractConfig.java:83)   - No override is set, using default

                    DEBUG [main] (AbstractConfig.java:108)   - Looking for config file: ServerTestConfig.yaml

                    INFO  [main] (AbstractConfig.java:121)   - Looking for specific folder named  in tree of [C:\Users\asreeram\Desktop\Tabjolt\

                    tabjolt-master\bin\perfRunHarness]

                    INFO  [main] (AbstractConfig.java:129)   - Reading configuration from [C:\Users\asreeram\Desktop\Tabjolt\tabjolt-master\config\Serve

                    rTestConfig.yaml]

                    INFO  [main] (AbstractConfig.java:133)   - Using testConfigOverride:

                    ERROR [main] (AbstractConfig.java:143)   - Failed to load config from yaml file.

                    while parsing a block collection

                    in 'string', line 14, column 11:

                                  - !!com.tableausoftware.test.ser ...

                                  ^

                    expected (ServerTestConfig.java:67)

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

                    WARN  [main] (AbstractConfig.java:176)   - Config object returned from loadConfiguration is null

                    INFO  [main] (ServerTestConfig.java:135)   - Looking for `config` starting in: C:\Users\asreeram\Desktop\Tabjolt\tabjolt-master\bin\

                    perfRunHarness

                    INFO  [main] (ServerTestConfig.java:141)   - Config folder path is: C:\Users\asreeram\Desktop\Tabjolt\tabjolt-master\config

                    INFO  [main] (ServerTestConfig.java:143)   - Loading Log4j configuration from: C:\Users\asreeram\Desktop\Tabjolt\tabjolt-master\conf

                    ig\log4j.properties

                    INFO  [main] (ServerTestConfig.java:88)   - Loading ServerTestConfig from: C:\Users\asreeram\Desktop\Tabjolt\tabjolt-master\config\S

                    erverTestConfig.yaml

                    INFO  [main] (AbstractConfig.java:79)   - Reading java.test.config.override from System properties...

                    INFO  [main] (AbstractConfig.java:83)   - No override is set, using default

                    INFO  [main] (AbstractConfig.java:129)   - Reading configuration from [C:\Users\asreeram\Desktop\Tabjolt\tabjolt-master\config\Serve

                    rTestConfig.yaml]

                    INFO  [main] (AbstractConfig.java:133)   - Using testConfigOverride:

                    ERROR [main] (AbstractConfig.java:143)   - Failed to load config from yaml file.

                    while parsing a block collection

                    in 'string', line 14, column 11:

                                  - !!com.tableausoftware.test.ser ...

                                  ^

                    expected , but found Key

                    in 'string', line 15, column 11:

                                  name: asreeram

                                  ^

                     

                            at org.yaml.snakeyaml.parser.ParserImpl$ParseBlockSequenceEntry.produce(ParserImpl.java:514)

                            at org.yaml.snakeyaml.parser.ParserImpl.peekEvent(ParserImpl.java:158)

                            at org.yaml.snakeyaml.parser.ParserImpl.checkEvent(ParserImpl.java:143)

                            at org.yaml.snakeyaml.composer.Composer.composeSequenceNode(Composer.java:198)

                            at org.yaml.snakeyaml.composer.Composer.composeNode(Composer.java:153)

                            at org.yaml.snakeyaml.composer.Composer.composeMappingNode(Composer.java:229)

                            at org.yaml.snakeyaml.composer.Composer.composeNode(Composer.java:155)

                            at org.yaml.snakeyaml.composer.Composer.composeDocument(Composer.java:122)

                            at org.yaml.snakeyaml.composer.Composer.getSingleNode(Composer.java:105)

                            at org.yaml.snakeyaml.constructor.BaseConstructor.getSingleData(BaseConstructor.java:120)

                            at org.yaml.snakeyaml.Yaml.loadFromReader(Yaml.java:450)

                            at org.yaml.snakeyaml.Yaml.load(Yaml.java:369)

                            at com.tableausoftware.test.server.configuration.AbstractConfig.loadConfiguration(AbstractConfig.java:140)

                            at com.tableausoftware.test.server.configuration.AbstractConfig.loadConfiguration(AbstractConfig.java:85)

                            at com.tableausoftware.test.server.configuration.ServerTestConfig.loadConfiguration(ServerTestConfig.java:89)

                            at com.tableausoftware.test.server.configuration.ServerTestConfig.getInstance(ServerTestConfig.java:164)

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

                    WARN  [main] (AbstractConfig.java:176)   - Config object returned from loadConfiguration is null

                    INFO  [main] (AbstractConfig.java:79)   - Reading java.test.config.override from System properties...

                    INFO  [main] (AbstractConfig.java:83)   - No override is set, using default

                    INFO  [main] (AbstractConfig.java:129)   - Reading configuration from [C:\Users\asreeram\Desktop\Tabjolt\tabjolt-master\config\PerfT

                    estConfig.yaml]

                    INFO  [main] (AbstractConfig.java:133)   - Using testConfigOverride:

                    INFO  [main] (AbstractConfig.java:141)   - Completed reading the  config

                    INFO  [main] (ServerTestConfig.java:135)   - Looking for `config` starting in: C:\Users\asreeram\Desktop\Tabjolt\tabjolt-master\bin\

                    perfRunHarness

                    INFO  [main] (ServerTestConfig.java:141)   - Config folder path is: C:\Users\asreeram\Desktop\Tabjolt\tabjolt-master\config

                    INFO  [main] (ServerTestConfig.java:143)   - Loading Log4j configuration from: C:\Users\asreeram\Desktop\Tabjolt\tabjolt-master\conf

                    ig\log4j.properties

                    INFO  [main] (ServerTestConfig.java:88)   - Loading ServerTestConfig from: C:\Users\asreeram\Desktop\Tabjolt\tabjolt-master\config\S

                    erverTestConfig.yaml

                    INFO  [main] (AbstractConfig.java:79)   - Reading java.test.config.override from System properties...

                    INFO  [main] (AbstractConfig.java:83)   - No override is set, using default

                    INFO  [main] (AbstractConfig.java:129)   - Reading configuration from [C:\Users\asreeram\Desktop\Tabjolt\tabjolt-master\config\Serve

                    rTestConfig.yaml]

                    INFO  [main] (AbstractConfig.java:133)   - Using testConfigOverride:

                    ERROR [main] (AbstractConfig.java:143)   - Failed to load config from yaml file.

                    while parsing a block collection

                    in 'string', line 14, column 11:

                                  - !!com.tableausoftware.test.ser ...

                                  ^

                    expected , but found Key

                    in 'string', line 15, column 11:

                                  name: asreeram

                                  ^

                     

                            at org.yaml.snakeyaml.parser.ParserImpl$ParseBlockSequenceEntry.produce(ParserImpl.java:514)

                            at org.yaml.snakeyaml.parser.ParserImpl.peekEvent(ParserImpl.java:158)

                            at org.yaml.snakeyaml.parser.ParserImpl.checkEvent(ParserImpl.java:143)

                            at org.yaml.snakeyaml.composer.Composer.composeSequenceNode(Composer.java:198)

                            at org.yaml.snakeyaml.composer.Composer.composeNode(Composer.java:153)

                            at org.yaml.snakeyaml.composer.Composer.composeMappingNode(Composer.java:229)

                            at org.yaml.snakeyaml.composer.Composer.composeNode(Composer.java:155)

                            at org.yaml.snakeyaml.composer.Composer.composeDocument(Composer.java:122)

                            at org.yaml.snakeyaml.composer.Composer.getSingleNode(Composer.java:105)

                            at org.yaml.snakeyaml.constructor.BaseConstructor.getSingleData(BaseConstructor.java:120)

                            at org.yaml.snakeyaml.Yaml.loadFromReader(Yaml.java:450)

                            at org.yaml.snakeyaml.Yaml.load(Yaml.java:369)

                            at com.tableausoftware.test.server.configuration.AbstractConfig.loadConfiguration(AbstractConfig.java:140)

                            at com.tableausoftware.test.server.configuration.AbstractConfig.loadConfiguration(AbstractConfig.java:85)

                            at com.tableausoftware.test.server.configuration.ServerTestConfig.loadConfiguration(ServerTestConfig.java:89)

                            at com.tableausoftware.test.server.configuration.ServerTestConfig.getInstance(ServerTestConfig.java:164)

                            at com.tableausoftware.test.tools.perfRunHarness.PerfRunHelper.getTestPassId(PerfRunHelper.java:611)

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

                    WARN  [main] (AbstractConfig.java:176)   - Config object returned from loadConfiguration is null

                    Exception in thread "main" java.lang.NullPointerException

                            at com.tableausoftware.test.tools.perfRunHarness.PerfRunHelper.getTestPassId(PerfRunHelper.java:613)

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

                    • 7. Re: Tabjolt error - test_runs" does not exist
                      Hugh Nguyen

                      This is a completely different error now.

                       

                      I'm not quite sure I know what the new error is about. Have you tried using a different user or try using the guest account instead of a specific test user? You can also try disabling SSL and see if that might work. Hopefully, these tests will give us an idea as to where the problem might be.

                      • 8. Re: Tabjolt error - test_runs" does not exist
                        anand.sreeram.0

                        We don’t have a test env. And I cannot disable the SSL on this server.

                         

                        I tried with a different user as well on my colleague’s machine, we both are experiencing the same issue.

                         

                        Regards,

                        Anand

                        • 9. Re: Tabjolt error - test_runs" does not exist
                          Hugh Nguyen

                          Also try installing tabjolt in the c:\ rather than your desktop. This might be a bit blind, but give that a shot.