SQL Changeset Fails

bhopenwbhopenw Posts: 39
edited October 7, 2008 12:29PM in SQL Compare Previous Versions
I have a user that gets the below error when he tries to open up SQL changeset.

System:
Win Server 2003 sp2
SQL Compare 7.1 installed w/ SQL Changeset 1
MSSCCI TFS 1.2 installed
VS 2005 Dev edition sp1
SQL Compare 6
VS 2003 .Net

Let me know where I need to look,

We've tried uninstalling TFS MSSCCI, and SQL Compare 7.1 and reinstalling.


Error:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at RedGate.SqlChangeset.ScProvider..ctor(String registry)
at RedGate.SqlChangeset.ScProvider.GetProviders()
at E.c()
at E..ctor(L host)
at e.g()
at e.p(Object , EventArgs )
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
RedGate.SqlChangeset
Assembly Version: 1.1.0.11
Win32 Version: 1.1.0.11
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%207/SQL%20Changeset/RedGate.SqlChangeset.exe
RedGate.SqlChangeset.Common
Assembly Version: 1.1.0.11
Win32 Version: 1.1.0.11
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%207/SQL%20Changeset/RedGate.SqlChangeset.Common.DLL
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
System.Runtime.Remoting
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
RedGate.SqlChangeset.SharedUi
Assembly Version: 1.1.0.11
Win32 Version: 1.1.0.11
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%207/SQL%20Changeset/RedGate.SqlChangeset.SharedUi.DLL
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
RedGate.SqlChangeset.Shared
Assembly Version: 1.1.0.11
Win32 Version: 1.1.0.11
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%207/SQL%20Changeset/RedGate.SqlChangeset.Shared.DLL
z4okv6af
Assembly Version: 1.1.0.11
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

Thanks,

BJHop

Comments

  • Eddie DEddie D Posts: 1,780 Rose Gold 5
    Thank you for your forum post.

    Can you please check the following registry key:

    HKEY_LOCAL_MACHINE\SOFTWARE\SourceCodeControlProvider\InstalledSCCProviders

    Each provider should be represented by a SCCServerName value and a SCCServerPath value. One is the provider name and the second is the path to the dll.

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • Eddie,

    Thank you for your response

    I guess I forgot to mention that we looked into the registry at all the keys for both Red Gate, MSSCCI and TFS All seemed to correct including the below path you gave me in you

    Keys we looked at were

    HKEY_LOCAL_MACHINE\software\SourceCodeControlProvider {RoboSource Control 3, Microsoft Team Foundation Server MSSCCI Provider}

    HKEY_LOCAL_MACHINE\software\Red Gate\Downloads
    HKEY_LOCAL_MACHINE\software\Red Gate\Licensing
    HKEY_LOCAL_MACHINE\software\Red Gate\SQL Backup
    HKEY_LOCAL_MACHINE\software\Red Gate\SQL Changeset
    HKEY_LOCAL_MACHINE\software\Red Gate\Update

    HKEY_LOCAL_MACHINE\software\Microsoft\Team Foundation Server MSSCCI Provider
    HKEY_LOCAL_MACHINE\software\Microsoft\Team Foundation Server MSSCCI Provider\settings\EA500
    HKEY_LOCAL_MACHINE\software\Microsoft\Team Foundation Server MSSCCI Provider\settings\Microsoft Visual Basic
    HKEY_LOCAL_MACHINE\software\Microsoft\Team Foundation Server MSSCCI Provider\settings\Microsoft Visual C++
    HKEY_LOCAL_MACHINE\software\Microsoft\Team Foundation Server MSSCCI Provider\settings\Microsoft Visual FoxPro
    HKEY_LOCAL_MACHINE\software\Microsoft\Team Foundation Server MSSCCI Provider\settings\PowerBuilder
    HKEY_LOCAL_MACHINE\software\Microsoft\Team Foundation Server MSSCCI Provider\settings\Quest Team Coding
    HKEY_LOCAL_MACHINE\software\Microsoft\Team Foundation Server MSSCCI Provider\settings\VsScc
    HKEY_LOCAL_MACHINE\software\Microsoft\Team Foundation Server MSSCCI Provider\settings\VssProvider
  • Hi BJHop,

    Can you check a couple of additional things please?

    1. Is the registry key for RoboSource Control in HKEY_LOCAL_MACHINE\software\SourceCodeControlProvider pointing to a valid key?

    2. Does your user have permissions set to access the registry?


    Regards,

    Alice Easey
    Red Gate Software
  • 1. Is the registry key for RoboSource Control in HKEY_LOCAL_MACHINE\software\SourceCodeControlProvider pointing to a valid key? Yes

    2. Does your user have permissions set to access the registry? User is local Admin of Box

    I appreciate all the help and do want to resolve this issue but this is only PC that we are having issues with from about 10 that we have installed it on. We do plan on installing on many more machines (40+) but that work is a couple weeks off. With that said I am willing to right this off as local to this particular server and that it is not a Red Gate issue but some configuration issue.

    Thanks for you help I will continue to work to see if I can fix if I do i will post the fix.

    bjhop
Sign In or Register to comment.