Running Ranorex tests with Jenkins - data connector issue

Experiences, small talk, and other automation gossip.
Posts: 9
Joined: Fri Jul 31, 2015 8:24 am

Running Ranorex tests with Jenkins - data connector issue

Post by Sajczi » Thu Dec 10, 2015 4:26 pm

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”.

User avatar
Support Team
Site Admin
Site Admin
Posts: 12145
Joined: Fri Jul 07, 2006 4:30 pm
Location: Houston, Texas, USA

Re: Running Ranorex tests with Jenkins - data connector issue

Post by Support Team » Mon Dec 14, 2015 3:13 pm

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.

Markus (S)

Posts: 152
Joined: Fri Aug 15, 2014 12:24 pm

Re: Running Ranorex tests with Jenkins - data connector issue

Post by Martin » Mon Dec 21, 2015 9:54 am

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?