Hello,
There is an error which shows up for a set of Test Suites while executing through command line. However the same error seems not to be there for the rest of the test suites.
Error Message: Failed to get rows from data source: Failed to load excel data. Unspecified error
In the machine where I give the execution doesn't have Excel Application installed, rather i use the Microsoft Access Database Engine 2010 Redistributable (Downloaded from https://www.microsoft.com/en-in/downloa ... x?id=13255).
I have tried execution in different machines and I see the same error.
Attached is the screen captured for the same.
Failed to get rows from data source: Failed to load excel data. Unspecified error
Failed to get rows from data source: Failed to load excel data. Unspecified error
You do not have the required permissions to view the files attached to this post.
Regards,
Punith
Punith
Re: Failed to get rows from data source: Failed to load excel data. Unspecified error
Hi,
Excel data connector requires Microsoft Access Database Engine >=2013. So please, try to update the MS Access DB engine on your machines (with anything newer than 2013) and try it again. Hope this helps?
Excel data connector requires Microsoft Access Database Engine >=2013. So please, try to update the MS Access DB engine on your machines (with anything newer than 2013) and try it again. Hope this helps?
Pavel Kudrys
Ranorex explorer at Descartes Systems
Please add these details to your questions:
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
Re: Failed to get rows from data source: Failed to load excel data. Unspecified error
Hello Pavel,
I have installed the latest 2016 version (https://www.microsoft.com/en-us/downloa ... x?id=54920). Yet i see the same error showing up.
The problem is I have other test suites which run on the same machine without any exception. And this particular test suite continues to fail with the same error in all the other VM's.
I have installed the latest 2016 version (https://www.microsoft.com/en-us/downloa ... x?id=54920). Yet i see the same error showing up.
The problem is I have other test suites which run on the same machine without any exception. And this particular test suite continues to fail with the same error in all the other VM's.
Regards,
Punith
Punith
Re: Failed to get rows from data source: Failed to load excel data. Unspecified error
Hi,
So there must be a difference in the excel files in the failing test suite? Have you tried to resave them with another Excel version? Eventually, check what's different about them.
So there must be a difference in the excel files in the failing test suite? Have you tried to resave them with another Excel version? Eventually, check what's different about them.
Pavel Kudrys
Ranorex explorer at Descartes Systems
Please add these details to your questions:
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
Re: Failed to get rows from data source: Failed to load excel data. Unspecified error
Hello,
We have tried to change the Excel to a Binary version and Bind all the values,
Now we are seeing a new set of error with the following message,
Failed to get rows from data source: Failed to load Excel data. Invalid bracketing of name 'ExcelConnector$'
Not able to identify the problem here, let alone the solution
We have tried to change the Excel to a Binary version and Bind all the values,
Now we are seeing a new set of error with the following message,
Failed to get rows from data source: Failed to load Excel data. Invalid bracketing of name 'ExcelConnector$'
Not able to identify the problem here, let alone the solution
You do not have the required permissions to view the files attached to this post.
Regards,
Punith
Punith
Re: Failed to get rows from data source: Failed to load excel data. Unspecified error
Hi,
What happens, if you load the file directly in Ranorex Data connector window? Does it open OK? I assume the error happens both on dev. machine and any machine you eventually run the test on? Could you please share the screenshot of the data connector window (where is visible path to excel file). Also, could you please share the file?
What happens, if you load the file directly in Ranorex Data connector window? Does it open OK? I assume the error happens both on dev. machine and any machine you eventually run the test on? Could you please share the screenshot of the data connector window (where is visible path to excel file). Also, could you please share the file?
Pavel Kudrys
Ranorex explorer at Descartes Systems
Please add these details to your questions:
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
Re: Failed to get rows from data source: Failed to load excel data. Unspecified error
was this issue resolved ?
I am having the same issue on one of the Virtual machine. The issue happens only on this VM. I tried uninstalling ranorex and tried again but its not working. This is jenkins node, so MSBuild builds the solution and then the generated exe is been used for the test suites to run.
If I open the same rxsln on Ranorex ide, close it and save. Then try the exe is works fine. So not sure what is happening
Any suggestions ?
I am having the same issue on one of the Virtual machine. The issue happens only on this VM. I tried uninstalling ranorex and tried again but its not working. This is jenkins node, so MSBuild builds the solution and then the generated exe is been used for the test suites to run.
If I open the same rxsln on Ranorex ide, close it and save. Then try the exe is works fine. So not sure what is happening
Any suggestions ?