Forum Discussion

dvjensen17's avatar
dvjensen17
Occasional Contributor
10 years ago

jenkins integration data file spreadsheet is not found

When I try to run a Test Suite that depends on an Excel data file as a Jenkins job, somewhere it appears that the path to the data file, which created on a Windows system, was saved with an absolute path which does not work on a Linux Jenkins agent. An error is thrown saying that the data file is not found. Is there a way these paths can be saved as relative?

 

12:27:08,278 INFO  [SoapUIProTestCaseRunner] Running TestCase [Event Detail TestCase]
12:27:08,279 ERROR [SoapUI] An error occurred [C:/Users/david.jensen/SoapUI Projects/ESB Data.xls (No such file or directory)], see error log for details
java.io.FileNotFoundException: C:/Users/david.jensen/SoapUI Projects/ESB Data.xls (No such file or directory)
	at java.io.FileInputStream.open(Native Method)
	at java.io.FileInputStream.<init>(FileInputStream.java:146)
	at com.eviware.soapui.impl.wsdl.teststeps.datasource.ExcelFacade.readWorkbookFrom(ExcelFacade.java:32)
	at com.eviware.soapui.impl.wsdl.teststeps.datasource.ExcelDataSource.a(ExcelDataSource.java:133)
	at com.eviware.soapui.impl.wsdl.teststeps.datasource.ExcelDataSource.load(ExcelDataSource.java:121)
	at com.eviware.soapui.impl.wsdl.teststeps.WsdlDataSourceTestStep.prepare(WsdlDataSourceTestStep.java:411)
	at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:132)
	at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:1)
	at com.eviware.soapui.impl.wsdl.support.AbstractTestRunner.run(AbstractTestRunner.java:130)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:745)
12:27:08,282 ERROR [AbstractTestRunner] Exception during Test Execution
java.lang.Exception: Failed to prepare testStep [Retrieve Country Code]; java.io.FileNotFoundException: C:/Users/david.jensen/SoapUI Projects/ESB Data.xls (No such file or directory)
	at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:136)
	at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:1)
	at com.eviware.soapui.impl.wsdl.support.AbstractTestRunner.run(AbstractTestRunner.java:130)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:745)
12:27:08,283 INFO  [SoapUIProTestCaseRunner] Finished running TestCase [Event Detail TestCase], time taken: 0ms, status: FAILED
12:27:08,285 INFO  [SoapUIProTestCaseRunner] Running TestCase [Calibration Device TestCase]
12:27:08,296 INFO  [SoapUIProTestCaseRunner] running step [sapId]
java.io.FileNotFoundException: C:/Users/david.jensen/SoapUI Projects/ESB Data.xls (No such file or directory)
	at java.io.FileInputStream.open(Native Method)
	at java.io.FileInputStream.<init>(FileInputStream.java:146)
	at com.eviware.soapui.impl.wsdl.teststeps.datasource.ExcelFacade.readWorkbookFrom(ExcelFacade.java:32)
	at com.eviware.soapui.impl.wsdl.teststeps.datasource.ExcelDataSource.a(ExcelDataSource.java:133)
	at com.eviware.soapui.impl.wsdl.teststeps.datasource.ExcelDataSource.load(ExcelDataSource.java:121)
	at com.eviware.soapui.impl.wsdl.teststeps.WsdlDataSourceTestStep.next(WsdlDataSourceTestStep.java:447)
	at com.eviware.soapui.impl.wsdl.teststeps.WsdlDataSourceTestStep.run(WsdlDataSourceTestStep.java:134)
	at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.runTestStep(AbstractTestCaseRunner.java:223)
	at com.eviware.soapui.impl.wsdl.testcase.WsdlTestCaseRunner.runCurrentTestStep(WsdlTestCaseRunner.java:47)
	at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:145)
	at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:1)
	at com.eviware.soapui.impl.wsdl.support.AbstractTestRunner.run(AbstractTestRunner.java:130)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:745)
12:27:08,300 ERROR [SoapUIProTestCaseRunner] sapId failed, exporting to [/opt/jenkins/workspace/qa-esb-tests/target/soapui-reports//ageLOC_ME_TestSuite-Calibration_Device_TestCase-sapId-0-FAILED.txt]
12:27:08,302 INFO  [SoapUIProTestCaseRunner] Finished running TestCase [Calibration Device TestCase], time taken: 0ms, status: FAILED
  • nmrao's avatar
    nmrao
    Champion Level 3
    10 years ago
    Dont know much about maven. But, you should be able to override properties from pom.xml or command line. While reading the data source file use property expansion instead of hard coded absolute file path.