Forum Discussion

limak91's avatar
limak91
New Contributor
9 years ago

Run SoapUI Pro Integration tests on Jenkins

Hello,
I'm currently working on integration tests and my goal is to run them after build via Jenkins.
But my tests fail for various reasons.

My first question. Why Jenkins leave empty space in endpoint when I use request ${POST Add Device#Response#$.id} to get data from other teststep. It's like it doesn't support such expression. Should it work or it can be used only inside SoapUI?

I'm using Ready! API 1.5.0. My pom is attached. Please verify if it's correct.

Second question .I'm using DataSource test step which uses .xls file to get username/password for authentication causes, so I could use ${DataSource#username} expression in authentication field in each test step. But when I run test, it looks like it doesn't even get this data from the file. DataSource test step is skipped and I get 401 Unauthorized. How to make it run properly via Jenkins?

Regards

  • limak91's avatar
    limak91
    9 years ago

    I've resolved first issue by adding 

    <dependency>
    <groupId>org.reflections</groupId>
    <artifactId>reflections-maven</artifactId>
    <version>0.9.9-RC2</version>
    </dependency>

    to my pom file.

    But problem still exists with DataSource test step. I've received this kind of log from Jenkins:

    12:08:46,936 INFO  [SoapUIProTestCaseRunner] running step [DataSource]
java.lang.NoClassDefFoundError: org/apache/poi/ss/usermodel/Workbook
	at com.eviware.soapui.impl.wsdl.teststeps.datasource.ExcelDataSource.load(SourceFile:114)
	at com.eviware.soapui.impl.wsdl.teststeps.WsdlDataSourceTestStep.next(SourceFile:439)
	at com.eviware.soapui.impl.wsdl.teststeps.WsdlDataSourceTestStep.run(SourceFile:126)
	at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.runTestStep(AbstractTestCaseRunner.java:213)
	at com.eviware.soapui.impl.wsdl.testcase.WsdlTestCaseRunner.runCurrentTestStep(WsdlTestCaseRunner.java:47)
	at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:139)
	at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:47)
	at com.eviware.soapui.impl.wsdl.support.AbstractTestRunner.run(AbstractTestRunner.java:129)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.ClassNotFoundException: org.apache.poi.ss.usermodel.Workbook
	at org.codehaus.plexus.classworlds.strategy.SelfFirstStrategy.loadClass(SelfFirstStrategy.java:50)
	at org.codehaus.plexus.classworlds.realm.ClassRealm.unsynchronizedLoadClass(ClassRealm.java:271)
	at org.codehaus.plexus.classworlds.realm.ClassRealm.loadClass(ClassRealm.java:247)
	at org.codehaus.plexus.classworlds.realm.ClassRealm.loadClass(ClassRealm.java:239)
	... 13 more

     I hope this might be easier to resolve :)

    Regards

    @Edit:

    Second issue also solved. I've just updated my pom with three more dependencies:

    <dependency>
    <groupId>org.reflections</groupId>
    <artifactId>reflections-maven</artifactId>
    <version>0.9.9-RC2</version>
    </dependency>
    <dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>3.13</version>
    </dependency>
    <dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>3.13</version>
    </dependency>
    <dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml-schemas</artifactId>
    <version>3.13</version>
    </dependency>

    Regards

  • TanyaYatskovska's avatar
    TanyaYatskovska
    SmartBear Alumni (Retired)
    9 years ago

    Hi Limak91,

     

    Both of your questions require some investigation. I would recommend that you submit them to our Support Team (one question per a case) – they will analyze them and get back to your with a possible solution. You can submit a support ticket here: https://support.smartbear.com/product-list/

    • limak91's avatar
      limak91
      New Contributor
      9 years ago

      I've resolved first issue by adding 

      <dependency>
      <groupId>org.reflections</groupId>
      <artifactId>reflections-maven</artifactId>
      <version>0.9.9-RC2</version>
      </dependency>

      to my pom file.

      But problem still exists with DataSource test step. I've received this kind of log from Jenkins:

      12:08:46,936 INFO  [SoapUIProTestCaseRunner] running step [DataSource]
java.lang.NoClassDefFoundError: org/apache/poi/ss/usermodel/Workbook
	at com.eviware.soapui.impl.wsdl.teststeps.datasource.ExcelDataSource.load(SourceFile:114)
	at com.eviware.soapui.impl.wsdl.teststeps.WsdlDataSourceTestStep.next(SourceFile:439)
	at com.eviware.soapui.impl.wsdl.teststeps.WsdlDataSourceTestStep.run(SourceFile:126)
	at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.runTestStep(AbstractTestCaseRunner.java:213)
	at com.eviware.soapui.impl.wsdl.testcase.WsdlTestCaseRunner.runCurrentTestStep(WsdlTestCaseRunner.java:47)
	at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:139)
	at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:47)
	at com.eviware.soapui.impl.wsdl.support.AbstractTestRunner.run(AbstractTestRunner.java:129)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.ClassNotFoundException: org.apache.poi.ss.usermodel.Workbook
	at org.codehaus.plexus.classworlds.strategy.SelfFirstStrategy.loadClass(SelfFirstStrategy.java:50)
	at org.codehaus.plexus.classworlds.realm.ClassRealm.unsynchronizedLoadClass(ClassRealm.java:271)
	at org.codehaus.plexus.classworlds.realm.ClassRealm.loadClass(ClassRealm.java:247)
	at org.codehaus.plexus.classworlds.realm.ClassRealm.loadClass(ClassRealm.java:239)
	... 13 more

       I hope this might be easier to resolve :)

      Regards

      @Edit:

      Second issue also solved. I've just updated my pom with three more dependencies:

      <dependency>
      <groupId>org.reflections</groupId>
      <artifactId>reflections-maven</artifactId>
      <version>0.9.9-RC2</version>
      </dependency>
      <dependency>
      <groupId>org.apache.poi</groupId>
      <artifactId>poi</artifactId>
      <version>3.13</version>
      </dependency>
      <dependency>
      <groupId>org.apache.poi</groupId>
      <artifactId>poi-ooxml</artifactId>
      <version>3.13</version>
      </dependency>
      <dependency>
      <groupId>org.apache.poi</groupId>
      <artifactId>poi-ooxml-schemas</artifactId>
      <version>3.13</version>
      </dependency>

      Regards