SQL Changeset Fails
bhopenw
Posts: 39
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
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
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
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
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
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