Skip to main content

Specflow External Data Package in Azure devops

Comments

13 comments

  • Jordan Western

    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

    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

    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

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

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

    Thanks!

    0
  • Jordan Western

    Is ExcelDataReader assembly present?

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

    0
  • Priyadarshani P

    Yes it is there. 

    0
  • Priyadarshani P

    0
  • Jordan Western

    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

    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

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

    Thanks in advance!

    0
  • Priyadarshani P

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

    0

Please sign in to leave a comment.

Powered by Zendesk