Specflow External Data Package in Azure devops

Priyadarshani P

• September 01, 2021 12:03
• Edited

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 -

Error : Generation error: Message: Unable to load Excel file from 'D:\a\1\s\ConseroDemoProject\Feature\clients.xlsx': Could not load file or assembly 'ExcelDataReader, Version=3.6.0.0, Culture=neutral, PublicKeyToken= -------'. The system cannot find the file specified.

 

The file is present in the repository and I tried with CSV but the same error persists. 

 

Has anyone experienced any issue like this?

Any lead is appreciated. 

0

• 

  Jordan Western

  • September 07, 2021 09:47

  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
• 

  Priyadarshani P

  • September 07, 2021 09:58
  • Edited

  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
• 

  Priyadarshani P

  • September 09, 2021 09:30

  Hi Jordan Western 

  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
• 

  Jordan Western

  • September 09, 2021 09:49

  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
• 

  Priyadarshani P

  • September 09, 2021 09:53
  • Edited

  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
• 

  Priyadarshani P

  • September 14, 2021 08:52

  Hi Jordan Western, any update on the issue? Please let me know. 

  Thanks!

  0
• 

  Jordan Western

  • September 14, 2021 08:58
  • Edited

  Is ExcelDataReader assembly present?

  Can you see this from the logs and or agent itself?

  0
• 

  Priyadarshani P

  • September 14, 2021 08:59

  Yes it is there. 

  0
• 

  Priyadarshani P

  • September 14, 2021 12:07

  

  0
• 

  Jordan Western

  • September 15, 2021 07:39

  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
• 

  Priyadarshani P

  • September 20, 2021 17:16

  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
• 

  alekstamatov

  • January 21, 2022 11:30

  Did you manage to fix this?
  I have the same issue and no solution on sight.
  
  Thanks in advance!

  0
• 

  Priyadarshani P

  • February 15, 2022 05:12

  alekstamatov I got the confirmation mail, it is fixed with version 3.9.52.

  0

Please sign in to leave a comment.