none
Error SQL0: Required contributor with id 'Microsoft.LightSwitch.LocalDbLocationModifier.v5.0' could not be loaded. RRS feed

Answers

  • just like old times eh?  There are some old posts on here about SSDT breaking LS, but.....?

    I'd try reinstalling Office Dev Tools(?) Good luck! 

    Josh, You did it (again) - Yeah just like old times! :)

    This fixes it:

    Download and install the latest SSDT for Visual Studio 2015

    Go to Add remove programs.

    Search for Microsoft Office Developer Tools.

    Click on it, then select Modify.

    Click Repair.


    http://AIHelpWebsite.com

    http://HoloLensHelpWebsite.com


    • Marked as answer by ADefwebserver Wednesday, October 18, 2017 8:46 PM
    • Edited by ADefwebserver Wednesday, October 18, 2017 11:05 PM
    Wednesday, October 18, 2017 8:02 PM
  • just like old times eh?  There are some old posts on here about SSDT breaking LS, but.....?

    I'd try reinstalling Office Dev Tools(?) Good luck! 

    • Marked as answer by ADefwebserver Wednesday, October 18, 2017 8:46 PM
    Wednesday, October 18, 2017 5:32 PM

All replies

  • Hi ADefwebserver,

    You could try to troubleshooting the lightswitch issue following this link:
    https://msdn.microsoft.com/en-us/library/ee256725.aspx

    Best Regards,

    Yuk Ding

    Monday, October 9, 2017 8:07 AM
  • Hi ADefwebserver,

    You could try to troubleshooting the lightswitch issue following this link:
    https://msdn.microsoft.com/en-us/library/ee256725.aspx

    Best Regards,

    Yuk Ding


    Thanks, I read it, but the issues covered don't apply in this situation.

    http://AIHelpWebsite.com

    http://HoloLensHelpWebsite.com

    Monday, October 9, 2017 12:23 PM
  • That link doesn't apply because you cannot upgrade LightSwitch.

    http://AIHelpWebsite.com

    http://HoloLensHelpWebsite.com

    Tuesday, October 17, 2017 6:12 AM
  • Hey Michael,

    Long time... hope you're well.

    FWIW, I install SSDT 2015 14.0.61707.300 the other day and did not have this problem.

    Take Care,

    Josh

    VS VER INFO:

    Microsoft Visual Studio Community 2015
    Version 14.0.25431.01 Update 3
    Microsoft .NET Framework
    Version 4.7.02046

    Installed Version: Community

    LightSwitch for Visual Studio 2015   00322-20000-00000-AA290
    Microsoft LightSwitch for Visual Studio 2015

    Microsoft Visual Studio Tools for Applications 2015   00322-20000-00000-AA290
    Microsoft Visual Studio Tools for Applications 2015

    Visual Basic 2015   00322-20000-00000-AA290
    Microsoft Visual Basic 2015

    Visual C# 2015   00322-20000-00000-AA290
    Microsoft Visual C# 2015

    Visual C++ 2015   00322-20000-00000-AA290
    Microsoft Visual C++ 2015

    Windows Phone SDK 8.0 - ENU   00322-20000-00000-AA290
    Windows Phone SDK 8.0 - ENU

    Application Insights Tools for Visual Studio Package   7.18.00214.2
    Application Insights Tools for Visual Studio

    ASP.NET and Web Tools 2015.1   14.1.21111.0
    ASP.NET and Web Tools 2015.1

    ASP.NET Web Frameworks and Tools 2012.2   4.1.41102.0
    For additional information, visit http://go.microsoft.com/fwlink/?LinkID=309563

    ASP.NET Web Frameworks and Tools 2013   5.2.40314.0
    For additional information, visit http://www.asp.net/

    Azure App Service Tools v2.9.6   14.0.21111.0
    Azure App Service Tools v2.9.6

    Azure Data Lake Node   1.0
    This package contains the Data Lake integration nodes for Server Explorer.

    Azure Data Lake Tools for Visual Studio   2.2.6000.1
    Microsoft Azure Data Lake Tools for Visual Studio

    Azure Data Lake Tools for Visual Studio   2.2.6000.1
    Microsoft Azure Data Lake Tools for Visual Studio

    Command Bus, Event Stream and Async Manager   Merq
    Provides ICommandBus, IEventStream and IAsyncManager MEF services for loosely coupled Visual Studio extension components communication and integration.

    Common Azure Tools   1.8
    Provides common services for use by Azure Mobile Services and Microsoft Azure Tools.

    GitHub.VisualStudio   2.1.1.4
    A Visual Studio Extension that brings the GitHub Flow into Visual Studio.

    JavaScript Language Service   2.0
    JavaScript Language Service

    JavaScript Project System   2.0
    JavaScript Project System

    Microsoft .NET Core Tools (Preview 2)   14.1.21111.0
    Microsoft .NET Core Tools (Preview 2)

    Microsoft Azure HDInsight Azure Node   2.2.6000.1
    HDInsight Node under Azure Node

    Microsoft Azure Hive Query Language Service   2.2.6000.1
    Language service for Hive query

    Microsoft Azure Mobile Services Tools   1.4
    Microsoft Azure Mobile Services Tools

    Microsoft Azure Stream Analytics Language Service   2.2.6000.1
    Language service for Azure Stream Analytics

    Microsoft Azure Tools   2.9
    Microsoft Azure Tools for Microsoft Visual Studio 2015 - v2.9.41104.6

    Node.js Tools   1.2.40726.00
    Adds support for developing and debugging Node.js apps in Visual Studio

    Node.js Tools - Profiling   1.2.40726.00
    Profiling support for Node.js projects.

    NuGet Package Manager   3.5.0
    NuGet Package Manager in Visual Studio. For more information about NuGet, visit http://docs.nuget.org/.

    Office Developer Tools for Visual Studio 2015 ENU   14.0.23928
    Microsoft Office Developer Tools for Visual Studio 2015 ENU

    PreEmptive Analytics Visualizer   1.2
    Microsoft Visual Studio extension to visualize aggregated summaries from the PreEmptive Analytics product.

    SQL Server Analysis Services   14.0.806.134
    Microsoft SQL Server Analysis Services Designer 
    Version 14.0.806.134

    SQL Server Data Tools   14.0.61707.300
    Microsoft SQL Server Data Tools

    SQL Server Integration Services   
    Microsoft SQL Server Integration Services Designer
    Version 14.0.800.90

    SQL Server Reporting Services   14.0.806.134
    Microsoft SQL Server Reporting Services Designers 
    Version 14.0.806.134

    ToolWindowHostedEditor   1.0
    Hosting json editor into a tool window

    TypeScript   1.8.36.0
    TypeScript tools for Visual Studio

    Visual Studio Tools for Apache Cordova   Update 10
    Visual Studio Tools for Apache Cordova

    Workflow Manager Tools 1.0   1.0
    This package contains the necessary Visual Studio integration components for Workflow Manager.

    Xamarin   4.2.1.62 (680125b)
    Visual Studio extension to enable development for Xamarin.iOS and Xamarin.Android.

    Xamarin.Android   7.0.2.37 (ce955cc)
    Visual Studio extension to enable development for Xamarin.Android.

    Xamarin.iOS   10.2.1.5 (44931ae)
    Visual Studio extension to enable development for Xamarin.iOS.

    Wednesday, October 18, 2017 1:57 PM
  • Josh,

    Thanks for looking into this. I uninstalled SSDT and re-installed the latest but I still get the error when trying to run in debug or publish:

    An error occurred during deployment plan generation. Deployment cannot continue.
    Error SQL0: Required contributor with id 'Microsoft.LightSwitch.DataRetentionDeploymentPlanModifier.v5.0' could not be loaded.
    Error SQL0: Required contributor with id 'Microsoft.LightSwitch.LocalDbLocationModifier.v5.0' could not be loaded. Application1 
    C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v14.0\LightSwitch\v5.0\Microsoft.LightSwitch.targets 160 

    My computer:

    Microsoft Visual Studio Community 2015
    Version 14.0.25431.01 Update 3
    Microsoft .NET Framework
    Version 4.7.02046

    Installed Version: Community

    LightSwitch for Visual Studio 2015   00322-20000-00000-AA844
    Microsoft LightSwitch for Visual Studio 2015

    Microsoft Visual Studio Tools for Applications 2015   00322-20000-00000-AA844
    Microsoft Visual Studio Tools for Applications 2015

    Visual Basic 2015   00322-20000-00000-AA844
    Microsoft Visual Basic 2015

    Visual C# 2015   00322-20000-00000-AA844
    Microsoft Visual C# 2015

    Visual C++ 2015   00322-20000-00000-AA844
    Microsoft Visual C++ 2015

    Application Insights Tools for Visual Studio Package   7.18.00214.2
    Application Insights Tools for Visual Studio

    ASP.NET and Web Tools 2015.1   14.1.21111.0
    ASP.NET and Web Tools 2015.1

    ASP.NET Web Frameworks and Tools 2012.2   4.1.41102.0
    For additional information, visit http://go.microsoft.com/fwlink/?LinkID=309563

    ASP.NET Web Frameworks and Tools 2013   5.2.40314.0
    For additional information, visit http://www.asp.net/

    Azure App Service Tools v2.9.6   14.0.21205.0
    Azure App Service Tools v2.9.6

    Azure Data Lake Node   1.0
    This package contains the Data Lake integration nodes for Server Explorer.

    Azure Data Lake Tools for Visual Studio   2.2.2100.0
    Microsoft Azure Data Lake Tools for Visual Studio

    Common Azure Tools   1.8
    Provides common services for use by Azure Mobile Services and Microsoft Azure Tools.

    JavaScript Language Service   2.0
    JavaScript Language Service

    JavaScript Project System   2.0
    JavaScript Project System

    Microsoft Azure Hive Query Language Service   2.2.2100.0
    Language service for Hive query

    Microsoft Azure Mobile Services Tools   1.4
    Microsoft Azure Mobile Services Tools

    Microsoft Azure Tools   2.9
    Microsoft Azure Tools for Microsoft Visual Studio 2015 - v2.9.41104.6

    NuGet Package Manager   3.5.0
    NuGet Package Manager in Visual Studio. For more information about NuGet, visit http://docs.nuget.org/.

    Office Developer Tools for Visual Studio 2015 ENU   14.0.23928
    Microsoft Office Developer Tools for Visual Studio 2015 ENU

    PreEmptive Analytics Visualizer   1.2
    Microsoft Visual Studio extension to visualize aggregated summaries from the PreEmptive Analytics product.

    SQL Server Analysis Services   14.0.1012.227
    Microsoft SQL Server Analysis Services Designer
    Version 14.0.1012.227

    SQL Server Data Tools   14.0.61709.290
    Microsoft SQL Server Data Tools

    SQL Server Integration Services  
    Microsoft SQL Server Integration Services Designer
    Version 14.0.800.90

    SQL Server Reporting Services   14.0.1012.227
    Microsoft SQL Server Reporting Services Designers
    Version 14.0.1012.227

    SQLite & SQL Server Compact Toolbox   4.7
    SQLite & SQL Server Compact Toolbox adds scripting, import, export, rename, query execution and much more to SQL Server Compact & SQLite Data Connections.

    ToolWindowHostedEditor   1.0
    Hosting json editor into a tool window

    TypeScript   2.1.4.0
    TypeScript tools for Visual Studio

    Web Essentials 2015.3   3.0.235
    Adds many useful features to Visual Studio for web developers. Requires Visual Studio 2015

    Workflow Manager Tools 1.0   1.0
    This package contains the necessary Visual Studio integration components for Workflow Manager.

    --------------------


    http://AIHelpWebsite.com

    http://HoloLensHelpWebsite.com


    Wednesday, October 18, 2017 4:04 PM
  • just like old times eh?  There are some old posts on here about SSDT breaking LS, but.....?

    I'd try reinstalling Office Dev Tools(?) Good luck! 

    • Marked as answer by ADefwebserver Wednesday, October 18, 2017 8:46 PM
    Wednesday, October 18, 2017 5:32 PM
  • just like old times eh?  There are some old posts on here about SSDT breaking LS, but.....?

    I'd try reinstalling Office Dev Tools(?) Good luck! 

    Josh, You did it (again) - Yeah just like old times! :)

    This fixes it:

    Download and install the latest SSDT for Visual Studio 2015

    Go to Add remove programs.

    Search for Microsoft Office Developer Tools.

    Click on it, then select Modify.

    Click Repair.


    http://AIHelpWebsite.com

    http://HoloLensHelpWebsite.com


    • Marked as answer by ADefwebserver Wednesday, October 18, 2017 8:46 PM
    • Edited by ADefwebserver Wednesday, October 18, 2017 11:05 PM
    Wednesday, October 18, 2017 8:02 PM
  • If you do not see a "repair" link:


    http://AIHelpWebsite.com

    http://HoloLensHelpWebsite.com

    Wednesday, October 18, 2017 11:02 PM
  • Glad it worked! 

    Let me know if you have any ideas about how to get my VS to debug JavaScript.  I had it working in Chrome but now cannot debug js in any browser.  Get the dreaded 'breakpoint wont be hit - no symbols loaded for this document'. 

    I'm pretty sure it busts if you hit F12 in Chrome while debugging in VS.  Then it's busted for good. But why?  In normal web projects you can change debug browsers, but LS is a special breed as we know too well.

    It's happened before and I had to spin up a new VM in Azure.  Now with a new machine, it's happed again. Ugh!

    Makes me thankful that I spend more time in VSCode nowadays.

    Thursday, October 19, 2017 1:16 AM
  • Let me know if you have any ideas about how to get my VS to debug JavaScript. 

    I still use IE and it debugs for me.

    These days I mostly I use VS2017 and Chrome when debugging my Angular 4 .Net Core 2.0 apps. I use the Chrome debugger and I can navigate to my .ts files and step through the code.


    http://AIHelpWebsite.com

    http://HoloLensHelpWebsite.com

    Thursday, October 19, 2017 2:08 AM
  • Thank you, thank you! Two days work lost trying to figure this out....

    Saved my rear!

    Stephen

    Wednesday, November 8, 2017 6:50 PM
  • I have discovered another solution, try to copy all the content from this location "C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\130\Extensions" to "C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\140\Extensions"

    Let me know.

    Thursday, December 28, 2017 2:00 AM
  • Had the error after trying to add new database fields. Repairing Office tools would work some of the time, sometimes reinstalling would work. Having to do this each time a new field was added was annoying.

    Solution - Uninstalling VS 2017 Community/VS Code/SSDT/Office Tools/Silverlight SDK 5, then repairing VS 2015 Community(add SSDT through the VS 2015 modify option), reinstalling Office Tools/Silverlight SDK 5

    Seems the later versions(not sure which), VS 2017 Community and VS Code, were the issue.

    Friday, October 5, 2018 2:59 AM
  • I have discovered another solution, try to copy all the content from this location "C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\130\Extensions" to "C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\140\Extensions"

    Let me know.

    This solution worked for me.  Thank you Abraham-Chahla!
    Wednesday, March 27, 2019 9:21 PM