If we run the pipeline in jenkins its showing xls file is not available

Hi,

2023-02-07 17:29:35.596 DEBUG testcase.Marketo - 19: comment(“Audience”)
2023-02-07 17:29:35.613 INFO c.k.k.c.keyword.builtin.CommentKeyword - Audience
2023-02-07 17:29:35.614 DEBUG testcase.Marketo - 20: Output1 = database_query.query.execute(findTestData(“wholedashboards/Marketo”).getValue(“HANA SQL Query”, 1), “Marketo”)
2023-02-07 17:29:35.642 ERROR c.k.katalon.core.main.TestCaseExecutor - ? Test Cases/2023_D_WHOLEDASHBOARD/Marketo FAILED.
Reason:
java.lang.IllegalArgumentException: Cannot find test data with id ‘Data Files/wholedashboards/Marketo’ because (of) ‘java.io.FileNotFoundException: C:\Users\2193838\Downloads\MarketoTestCases.xls’
at com.kms.katalon.core.testdata.TestDataFactory.findTestData(TestDataFactory.java:131)
at com.kms.katalon.core.testdata.TestDataFactory$findTestData.callStatic(Unknown Source)
at Marketo.run(Marketo:72)
at com.kms.katalon.core.main.ScriptEngine.run(ScriptEngine.java:194)
at com.kms.katalon.core.main.ScriptEngine.runScriptAsRawText(ScriptEngine.java:119)
at com.kms.katalon.core.main.TestCaseExecutor.runScript(TestCaseExecutor.java:398)
at com.kms.katalon.core.main.TestCaseExecutor.doExecute(TestCaseExecutor.java:389)
at com.kms.katalon.core.main.TestCaseExecutor.processExecutionPhase(TestCaseExecutor.java:368)
at com.kms.katalon.core.main.TestCaseExecutor.accessMainPhase(TestCaseExecutor.java:360)
at com.kms.katalon.core.main.TestCaseExecutor.execute(TestCaseExecutor.java:255)
at com.kms.katalon.core.main.TestSuiteExecutor.accessTestCaseMainPhase(TestSuiteExecutor.java:203)
at com.kms.katalon.core.main.TestSuiteExecutor.accessTestSuiteMainPhase(TestSuiteExecutor.java:152)
at com.kms.katalon.core.main.TestSuiteExecutor.execute(TestSuiteExecutor.java:95)
at com.kms.katalon.core.main.TestCaseMain.startTestSuite(TestCaseMain.java:157)
at com.kms.katalon.core.main.TestCaseMain$startTestSuite$0.call(Unknown Source)
at TempTestSuite1675771099848.run(TempTestSuite1675771099848.groovy:39)

if we run the code in jenkins pipeline it is throwing this error.but the respective file is in git and also in katalon can anyone tell me what is the issue here.

1 Like

Hi,

The path of your xls must be in “Relative path” and not in “absolute”

java.lang.IllegalArgumentException: Cannot find test data with id ‘Data Files/wholedashboards/Marketo’ because (of) ‘java.io.FileNotFoundException: C:\Users\2193838\Downloads\MarketoTestCases.xls’
at com.kms.katalon.core.testdata.TestDataFactory.findTestData(TestDataFactory.java:131)

3 Likes

If you have the above pathway, then try (assuming the pathway exists) the below:

C:\\Users\\2193838\\Downloads\\MarketoTestCases.xls

Edit: I thought to bring to your attention the “old” Excel extension pre-2007 in case you are using a “newer” version of Excel, which would have “xlsx” extension. Just check which one it actually has.

1 Like