Sql Compare error on startup

SeanX · May 9, 2007 11:47PM

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

JonathanWatts · May 10, 2007 5:34AM

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

SeanX · May 10, 2007 4:48PM

1.1 and 2.0

Tom Harris · May 11, 2007 8:01AM

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

SeanX · May 13, 2007 5:34PM

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

SeanX · May 15, 2007 9:21PM

I have reinstalled .net 1.1 but that has not fixed the problem.

Sean

SeanX · May 23, 2007 11:10PM

Any one there?

Tom Harris · May 24, 2007 5:38AM

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

Tom Harris · May 24, 2007 7:13AM

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

SeanX · May 24, 2007 5:35PM

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

Nick Warren · May 31, 2007 2:59AM

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 - support@red-gate.com, and someone will look in to what's possible with 5.3.

Thanks, Nick

SeanX · May 31, 2007 4:33PM

Beta 6 is fine for now.

Sean

shadowbob · June 13, 2007 1:35PM

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.

JonathanWatts · June 13, 2007 1:38PM

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

shadowbob · June 21, 2007 4:58PM

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!

JonathanWatts · June 22, 2007 6:50AM

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

Daniel Handley · June 22, 2007 7:03AM

can you please log a call with our support desk as well - support@red-gate.com - so that we can help you directly with this issue.

hemantmcse · October 9, 2008 3:04PM

Remove MSXML and install MSXML once again

Sql Compare error on startup

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk