Specflow External Data Package in Azure devops
Hi there,
I have my .xsl file as a DataSource for the Feature files located in the same Feature Folder. It is running fine on my local machine but when integrated to Azure DevOps Pipeline, it is failing with the error -
-
Hi Priyadarshani P,
The issue looks like to be coming from issues loading this dependent assembly, ExcelDataReader, not loading the the data itself? Or at least this is how it looks to me.
Without having access to your repo, it can be very difficult to tell you where the issue is.
It might be beneficial to take a look at this post in order to give you somewhere to start as there is a tool mentioned you can use to find out where this dependency is coming from.
0 -
Hi Jordan Western,
Thanks for the reply. As I mentioned earlier it is running on my local machine but causing issues in the Pipeline and the same is the case with the CsvHelper assembly.
I have raised an issue on ExcelDataReader Repo also.
I will go through the post shared by you and put up the comment here. Thanks!
0 -
I explored the fuslogvw.exe but didn't help.
The problem I observed was with ExternalData Plugin as it used ExcelDataReader and CsvHelper internally to load the excel & csv files respectively and the respective .dlls are not found on the Agent machine. I tried referencing those packages in my steps files but still those .dll are not found so build is failing.
Please let me know how to resolve this dependency! Thanks!
Attached is the snapshot of Specflow ExternalData Plugin .csproj
0 -
Can you send a screenshot of the tasks in your pipeline?
Which task is failing?
Can you look though the logs to see if this file is present?
0 -
2021-09-09T08:53:15.0038498Z ##[error]Feature\CashBalance.feature(0,0): Error : Generation error: Message: Unable to load Excel file from 'D:\a\1\s\ConseroDemoProject\clients.xlsx': Could not load file or assembly 'ExcelDataReader, Version=3.6.0.0, Culture=neutral, PublicKeyToken=93517dbe6a4012fa'. The system cannot find the file specified.
Here are the screenshots of failing task - Build
Also I ensured the excel is present by using the copy file
0 -
Hi Jordan Western, any update on the issue? Please let me know.
Thanks!
0 -
Is ExcelDataReader assembly present?
Can you see this from the logs and or agent itself?
0 -
Yes it is there.
0 -
0
-
Hi Priyadarshani P,
Honestly I am out of ideas, everything that you have shown me seems to look ok and I cannot access your repo to investigate further.
I would suggest to continue to reach out via the ExcelDataReader repo to see if they have any ideas.
0 -
Jordan Western Same issue is logged here today. https://github.com/SpecFlowOSS/SpecFlow/issues/2496
I also tried running the tests dotnet test command, it is failing on the local machine.
0 -
Did you manage to fix this?
I have the same issue and no solution on sight.
Thanks in advance!0 -
alekstamatov I got the confirmation mail, it is fixed with version 3.9.52.
0
Please sign in to leave a comment.
Comments
13 comments