Running Ranorex tests with Jenkins - data connector issue

[Sajczi]

Hello,
I have specified Jenkins job that tries to run Ranorex tests by running some .bat file on my PC. When I start this .bat file locally, it does all the required actions. But when it is runned with Jenkins, there is a log:

2015-12-10 15:57:23,51
[2015/12/10 15:57:25.535][Debug ][Logger]: Console logger starting.
[2015/12/10 15:57:26.016][Info ][Test]: Test Suite 'bulk_printing_invoice' started.
[2015/12/10 15:57:26.534][Info ][Test]: Test Case 'TestCase' started.
[2015/12/10 15:57:26.537][Failure][Test]: Test Case 'TestCase' completed with status 'Failed'.
[2015/12/10 15:57:26.539][Failure][Test]: Test Suite 'bulk_printing_invoice' completed with status 'Failed'.
[2015/12/10 15:57:26.797][Debug ][Logger]: Console logger stopping.
2015-12-10 15:57:26,87

As far as I know, such situation occurs when Ranorex test suite cannot find data connector (my excel file). But as I said before it appers on my PC and is usable when I run those tests by double clicking bat file.
Can anyone tell me what to do?


EDIT: It surely is Excel issue:
Failed to get rows from data source: Failed to load Excel data. Program Microsoft Excel can't access file „C:\Ranorex\RanorexStudio Projects\UAT\MONITORING\1_1_2_bulk_printing_invoice\bulk_printing_invoice\bin\Debug\test_data_monitoring.xlsx”.

[Support Team]

Hi Sajczi,

It seems that the path to the Excel file is not correct on your system under test.
Please check if you have used an absolute or relative path in the Data Connector. I’d also suggest using the option “Copy File to Project”. This setting will ensure that the data file is copied to the projects folder.
Hope that helps.

Regards,
Markus (S)

[Martin]

Just to be sure, is the Jenkins instance also setup on your PC locally or does it have it's seperate machine and has universal access from inside of the network?