Failed to get rows from data source - Run as Administrat

Ask general questions here.
Posts: 26
Joined: Mon Sep 24, 2012 9:45 pm
Location: Kansas City

Failed to get rows from data source - Run as Administrat

Post by kdreiling » Wed Mar 21, 2018 3:00 pm


I need help to determine what the advantage of running Ranorex as Administrator versus just running Ranorex is. Initially (that's 2012), when I started to build our test suite, there was no support available in the US. At that time, I did not know that I should build my test suite as administrator in Ranorex. I'd like to know what Run As Administrator does for building and running all of the recordings that I have built over the years.

So the reason for this post is, when I try to run my test suite as Administrator, I get the following error:

Failed to get rows from data source: The Excel file with name 'O:\Ranorex\Test_Data\Optamum\Authorization Modalities BCBSKC.xlsb' could not be found.

I saw where one option is to move the spreadsheets to my C:\ drive, but that is not an option because we share the spreadsheets in other test suites and recordings.

Any suggestions are welcomed!

User avatar
Ranorex Guru
Ranorex Guru
Posts: 6529
Joined: Mon Aug 13, 2012 9:54 am
Location: Zilina, Slovakia

Re: Failed to get rows from data source - Run as Administrat

Post by odklizec » Wed Mar 21, 2018 3:18 pm


By default, it's not required to run Ranorex as administrator. It should be perfectly fine to run Ranorex as standard user. However, running Ranorex as Administrator may help with some GUI identification problems. And I believe it's required to run Ranorex as administrator (on Win 10), if you want to use debug mode.

As for your problem with excel file, I'm afraid, Ranorex specifically does not support/recommend using shared/network drives. So your usage of shared files is wrong. You should use version control system to share data between users and have the files stored locally.
Pavel Kudrys
Ranorex explorer at Descartes Systems

Please add these details to your questions:
  • Ranorex Snapshot. Learn how to create one >here<
  • Ranorex xPath of problematic element(s)
  • Ranorex version
  • OS version
  • HW configuration

Certified Professional
Certified Professional
Posts: 39
Joined: Mon Dec 12, 2016 9:24 am

Re: Failed to get rows from data source - Run as Administrat

Post by dpFourOFour » Thu Mar 22, 2018 9:56 am


Pavel is right. You should definitely use a source control tool instead of a network drive if you need your other team members to access the data file as well.
In addition to that, there is a known limitation in Microsoft Windows that does prevent applications started as Admin to access mapped network drives.

Please always include the following information to your posts
  • Ranorex Version
  • OS Version