Competition: What’s your favorite Redgate tool? Enter now.

Sql Compare error on startup

SeanXSeanX Posts: 11 Bronze 2
edited October 9, 2008 3:04PM in SQL Compare Previous Versions
I get the following error when starting Sql Compare 5.3

RedGate.SQLCompare.UI.exe - Common Language Runtime Debugging Services
Application has generated an exception that could not be handled.

Process id=0x1498 (5272), Thread id=0xd64 (3428).

Click OK to terminate the application.
Click CANCEL to debug the application.
OK Cancel

I am using Vista. I have the dev express components for delphi installed, but I can only find one copy of the DevExpress.xxx 6.3 dlls on the computer.

I have tried uninstalling/reinstalling without any joy.


Sean

Comments

  • Hi Sean,

    Can I ask which version of .NET you have installed? We have been encountering problems with DevExpress when .NET 1.1 is not installed.

    See this post for more details: http://www.red-gate.com/messageboard/vi ... 5517#15517

    Regards,

    Jonathan
    Jonathan Watts

    -Project Manager
    -Red Gate Software Ltd
  • SeanXSeanX Posts: 11 Bronze 2
    1.1 and 2.0
  • Hi there,

    would it be possible for you to capture a stack trace of the crash by hitting debug? I strongly suspect a problem with some 3rd party components, but we can't tell for sure without more details.

    Many thanks,

    Tom Harris

    Red Gate Software
  • SeanXSeanX Posts: 11 Bronze 2
    When I start the debugger, it gives a second exception:

    An unhandled exception of type 'System.TypeInitializationException' occurred in RedGate.SQLCompare.UI.exe

    Additional information: The type initializer for "RedGate.SQL.Shared.SQLServerInstances" threw an exception.

    Stack trace is as follows:

    Address _111._1

    00000000 push edi
    00000001 push esi
    00000002 call dword ptr ds:[003B56F0h]
    00000008 mov ecx,eax
    0000000a mov edx,1
    0000000f mov eax,dword ptr [ecx]
    00000011 call dword ptr [eax+7Ch]
    00000014 call dword ptr ds:[003B56F0h]
    0000001a mov ecx,eax
    0000001c xor edx,edx
    0000001e mov eax,dword ptr [ecx]
    00000020 call dword ptr [eax+00000090h]
    00000026 mov ecx,3B5C3Ch
    0000002b call 719F22AB
    00000030 mov esi,eax
    00000032 mov ecx,esi
    00000034 call dword ptr ds:[003B61E0h]
    0000003a mov ecx,esi
    0000003c cmp dword ptr [ecx],ecx
    0000003e call dword ptr ds:[7B9DEDA4h]
    00000044 mov ecx,esi
    00000046 cmp dword ptr [ecx],ecx
    00000048 call dword ptr ds:[003B61F8h]
    0000004e call dword ptr ds:[003B64E8h]
    00000054 mov edi,eax
    00000056 call dword ptr ds:[003B7B74h]
    >>> 0000005c mov ecx,esi <<<
    0000005e cmp dword ptr [ecx],ecx
    00000060 call dword ptr ds:[7B9DEC64h]
    00000066 mov ecx,3B7C10h
    0000006b call F8BE1FC0
    00000070 mov ecx,eax
    00000072 call dword ptr ds:[7B9E5AF8h]
    00000078 mov ecx,edi
    0000007a call dword ptr ds:[7B9E5B64h]
    00000080 pop esi
    00000081 pop edi
    00000082 ret
  • SeanXSeanX Posts: 11 Bronze 2
    I have reinstalled .net 1.1 but that has not fixed the problem.

    Sean
  • SeanXSeanX Posts: 11 Bronze 2
    Any one there?
  • Hi,

    we are investigatin why the code that retrieves the list of available SQL Servers might be throwing an exception. This is not a bug that we have encountered before. Please bear with us as we try to get to the bottom of the problem.

    Many thanks,

    Tom Harris

    Red Gate Software
  • Hi,

    could you try out the SQL Compare 6 beta and see of the same problem occurs? SQL Compare 6 is a .NET 2.0 build and may well not exhibit the same phenomena.

    Details at http://www.red-gate.com/MessageBoard/viewforum.php?f=65

    Thanks,

    Tom
  • SeanXSeanX Posts: 11 Bronze 2
    Tom Harris wrote:
    Hi,

    could you try out the SQL Compare 6 beta and see of the same problem occurs? SQL Compare 6 is a .NET 2.0 build and may well not exhibit the same phenomena.
    Tom

    That works.

    Thanks

    Sean
  • Sean - I'm not sure whether using the v6 beta is a valid solution for you, but if not, please can you log a call with our support desk - [email protected], and someone will look in to what's possible with 5.3.

    Thanks, Nick
    Nick Warren
    Head of Customer Support
    Red Gate Software

    e: [email protected]
    t: +44 (0)870 160 0037
    w: www.red-gate.com
  • SeanXSeanX Posts: 11 Bronze 2
    Beta 6 is fine for now.

    Sean
  • shadowbobshadowbob Posts: 71 Bronze 2
    I am receiving the same problem, even after uninstalling/reinstalling. I am also using Vista. Vista contains .Net 2.0 and 3.0 built in to the operating system, and I have additionally installed 1.1. The interesting thing is, the software worked for months and months before mysteriously stopping. I can't correlate it with anything I have done to the system, either.

    I am going to try 6.0 beta, and as long as the beta doesn't corrupt my databases, that will suffice for me. However, it would be worth looking into the problem.
    Jeremy Fuller
    VP, Software Development
    Organizational Intelligence, Inc.
  • shadowbob,

    Can let us know if the beta solves this issue. We are fairly sure that it should, but would like to know just incase.

    Thanks,

    Jonathan
    Jonathan Watts

    -Project Manager
    -Red Gate Software Ltd
  • shadowbobshadowbob Posts: 71 Bronze 2
    Jonathan,

    6.0 beta definitely solved the issue. My only problem now is, the beta has expired! And since 5 doesn't work, I've hit a wall. I need a working version of this product!
    Jeremy Fuller
    VP, Software Development
    Organizational Intelligence, Inc.
  • Shadowbob,

    Sorry about this, we had hoped that there would be a bit over lap between the beta and final release. However, the final testing of SQL Compare 6 has ran on a bit longer. It is nearly complete and we should have the final version out shortly.

    Once again sorry about the delay,

    Regards,

    Jonathan
    Jonathan Watts

    -Project Manager
    -Red Gate Software Ltd
  • can you please log a call with our support desk as well - [email protected] - so that we can help you directly with this issue.
    Daniel Handley
    Red Gate Software Ltd
  • Remove MSXML and install MSXML once again
Sign In or Register to comment.