MSBuild missing Newtonsoft.Json.dll

• 
  Running into the same error while attempting to deploy pending scripts.
  
  Using SQL Change Automation version: 4.3.20205.21469
  Error:  : Could not load file or assembly 'Newtonsoft.Json, Version=12.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed' or one of its dependencies. The system cannot find the file specified.: Could not load file or assembly 'Newtonsoft.Json, Version=12.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed' or one of its dependencies. The system cannot find the file specified.
  

  Sean_Lively July 27, 2020 15:33

  - 0 +
• 
  Update (July 30th) - This issue has been fixed in  version 4.3.20211 of SQL Change Automation for Visual Studio
  

  Sergio R July 27, 2020 15:37

  - 0 +
• 
  @Sergio R We are not yet seeing that version available. 
  This has pretty much stalled my teams work today. 
  
  Any idea on when it will actually be available to install or is there somewhere we can pull an old version to get things working again?

  JoeHarkins July 27, 2020 19:01

  - 0 +
• 
  Visual Studio extensions are set to self-update by default, if that didn't happen in your case, you should be able to get it from the Visual Studio Marketplace: https://marketplace.visualstudio.com/items?itemName=vs-publisher-306627.RedgateSqlChangeAutomation

  Sergio R July 27, 2020 19:05

  - 0 +
• 
  Downloaded SQL Toolbelt installer today, and it did not update to 4.3.20209
  Downloaded the extension from VS Marketplace per the link, and it did update to 20209:
  Using SQL Change Automation version: 4.3.20209.21516
  Still getting the Newtonsoft.Json error:
  

  C:\Projects\database\SQLCore\PrimeReporting\PrimeReporting.sqlproj: Error:  : Could not load file or assembly 'Newtonsoft.Json, Version=12.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed' or one of its dependencies. The system cannot find the file specified.: Could not load file or assembly 'Newtonsoft.Json, Version=12.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed' or one of its dependencies. The system cannot find the file specified.

  
  

  Sean_Lively July 27, 2020 22:03

  - 0 +
• 
  Applying the vsix install from the marketplace did not resolve the issue.
  I can see the file in the MSBuild folder referenced above now, but every build still fails. 
  Unlike the originator of this thread, adding the file manually before attempting the vsix install also did not correct the problem.
  
  My other team members attempted the vsix install without having attempted any manual corrections and also report local builds remain broken after the upgrade.

  JoeHarkins July 27, 2020 22:20

  - 0 +
• 
  Got a response from RedGate support-
  Newtonsoft.json.dll is missing from the Extensions directory: C:\Program Files (x86)\Microsoft Visual Studio\(Visual Studio Version)\(Visual Studio Edition)\Common7\IDE\Extensions\001rr241.rgs\
  Manually copying the .dll there resolved the problem for me.

  Sean_Lively July 28, 2020 13:37

  - 0 +
• 
  I just got the same reply from support and it worked perfectly for me too.

  JoeHarkins July 28, 2020 14:20

  - 0 +
• 
  I am sorry that this issue is still occurring, like @garrettloy, @Sean_Lively and @JoeHarkins   mentioned this can be worked around by copying Newtonsoft.json.dll version 12 to the appropriate locations (this is probably already present on your system, so it's just a case of searching and copying):
  
  C:\Program Files (x86)\Microsoft Visual Studio\(Visual Studio Version)\(Visual Studio Edition)\MSBuild\SqlChangeAutomation\
  for example: C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\MSBuild\SqlChangeAutomation\
  
  C:\Program Files (x86)\Microsoft Visual Studio\(Visual Studio Version)\(Visual Studio Edition)\Common7\IDE\Extensions\001rr241.rgs\
  for example C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\Common7\IDE\Extensions\001rr241.rgs\
  
  

  Sergio R July 28, 2020 14:25

  - 0 +
• 
  Just ran through resolving an issue with one of my team members - it seems that for Visual Studio 2017 Professional's 4.3.20209.21516 extension, the dll is still missing from the 001rr241.rgs folder.  
  
  I also had problems updating my extension after adding the Newtonsoft.Json.dll files manually to the extension folders. I ended up having to remove the mentioned folders entirely in order to successfully uninstall/reinstall. I believe this is due to the uninstall process only removing what it expects to be there, and then leaving Newtonsoft.Json.Dll because the previous installer didn't put it there, then the new installer doesn't expect it to be there and errors out.
  
  We're unblocked right now but I anticipate my folks having to go in and delete the folders and/or remember to remove newtonsoft.json.dll from those folders when we get another update.

  garrettloy July 28, 2020 17:20

  - 0 +
• 
  I am sorry for this issue, we are investigating this and hopefully, this will be fixed in the next version.

  Sergio R July 28, 2020 17:30

  - 0 +
• 
  @Sean_Lively
  @JoeHarkins
  
  Can you let us know what versions of Visual Studio you were using?

  Sergio R July 28, 2020 18:18

  - 0 +
• 
  We verified the issue was with all the folks using VS 2017.

  JoeHarkins July 28, 2020 18:27

  - 0 +
• 
  VS2017

  Sean_Lively July 28, 2020 22:20

  - 0 +
• 
  I ran into this same (or a really similar) issue as well just now.
  No windows or VS updates had been installed for a while, but SCA had just gotten automatically updated.
  I found that the folder SqlChangeAutomation had a copy of Newtonsoft.Json.dll, but the folder 001rr241.rgs didn't. I copied the dll from the first to the second folder. After that I could build again without errors.
  
  OS: Windows 10 Enterprise
  IDE: Visual Studio Enterprise 2017, 15.9.22
  SCA: 4.3.20209.21516 (version that triggered the error. Don't know what the previous version was)

  StevenSegers July 29, 2020 14:58

  - 0 +
• 
  My team just ran into the same issue now. 
  I did the exact same thing that
  StevenSegers did and it fixed the issue.

  rchie July 29, 2020 15:33

  - 0 +
• 
  We've now released version 4.3.20211 of SQL Change Automation for Visual Studio which should resolve this

  Sergio R July 29, 2020 16:13

  - 0 +

Add comment

Please sign in to leave a comment.