SQL Changeset Fails

bhopenw

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

Eddie D

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

bhopenw

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

Alice E

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

bhopenw

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