How can we help you today? How can we help you today?

Always asking to Create New Project

I frequently get random errors which I cannot clear (Object reference not set to an instance of an object - full message below). After closing VS and restarting, SQL Change Automation asks me to Create A New Project. I already have a project with a bunch of migration scripts. My ReadyRoll project is selected in the dropdown, but it still does not recognize it (https://www.screencast.com/t/33EmjOW5tRn). This has been happening with both ReadyRoll and SQL Change Automation. I have tried completely reinstalling VS Enterprise as well. I am pulling me hair out. I often have to delete my project and start over again (had to do this twice last week) because of instability in ReadyRoll. Please help.

Full Error Message:
Message = Object reference not set to an instance of an object.
Data = System.Collections.ListDictionaryInternal
InnerException = 
TargetSite = Void CompareSandboxToProject()
StackTrace =    at RedGate.Versioning.Client.VsShell.VisualStudio.PendingChangeModel.CompareSandboxToProject()
   at RedGate.Versioning.Client.VsShell.VisualStudio.PendingChangeModel.<CompareSandboxToProjectAsync>d__77.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at RedGate.Versioning.Client.VsShell.VisualStudio.Commands.RefreshCommand.<ExecuteAsync>d__14.MoveNext()
HelpLink = 
Source = RedGate.Versioning.Client.VsShell.VisualStudio
HResult = -2147467261
shaffersh1
0

Comments

3 comments

Sort by
  • MikielAgutu
    Hello

    Sorry you're encountering problems with SQL Change Automation.

    First, try updating to the latest version of the SQL Change Automation Visual Studio Extension.

    If that doesn't work, please contact support@red-gate.com. If you can prepare a zipped folder containing the project that's crashing also. This will help us debug the problem and find a solution for you.

    In the meantime, it's possible to recover your progress even if the project cannot be loaded. First, you can create a new project and connect to your development database that has the changes. Second, you can copy the migration scripts from your existing project into a new one.

    Thanks
    MikielAgutu
    0
  • shaffersh1
    Thanks for getting back to me. I have upgraded to the latest version, but the problem is still there.

    Where can I upload the project for you? It is quite large.

    I have recreated the project and readded the scripts many time. The problem is that it just does it again a few days later.
    shaffersh1
    0
  • MikielAgutu
    Hello

    Sorry you're still experiencing this issue. If you contact Redgate support at support@red-gate.com we can assist you further. Our support system provides a mechanism for uploading large files.

    Thanks
    MikielAgutu
    0

Add comment

Please sign in to leave a comment.