DevExpress.XtraGrid.GridControl Threw an Exception

Forum for users of SQL Compare schema synchronization utility

Moderators: JonathanWatts, Chris Auckland, David Atkinson

DevExpress.XtraGrid.GridControl Threw an Exception

Postby David Hayden » Mon Jan 08, 2007 6:27 pm

I just downloaded the latest release and now cannot run SqlCompare and SqlDataCompare without getting this error.


An unhandled exception ('System.TypeInitializationException') occurred in RedGate.SqlDataCompare.UI.exe [272].

From SqlDataCompare: Additional information: The type initializer for '_122' threw an exception.

From SqlCompare: Additional information: The type initializer for 'DevExpress.XtraGrid.GridControl' threw an exception.


Note I am a DeveloperExpress Subscriber and already have the latest version of Developer Express already installed on my development machine.

Aside from a few bugs that I hoped were fixed in the new release, they worked fine before downloading the latest release.

Now I am wondering if my DevExpress stuff is still correctly installed.

How do I fix this?

Regards,

Dave
David Hayden
 
Posts: 3
Joined: Mon May 15, 2006 9:01 pm

Postby Brian Donahue » Tue Jan 09, 2007 6:27 pm

Hello David,

The last time I saw this error occur, I believe that the problem was that the 'Times New Roman' font was not installed on the system.

http://www.red-gate.com/messageboard/vi ... php?t=3131

Can you please have a look at your installed fonts? Thanks!
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby ChristianASPNET » Wed Jan 24, 2007 6:07 pm

I've got the same issue. I upgraded yesterday to 5.3.2 and now I'm getting a type initializer error on the DevExpress XtraGrid. Times New Roman is installed. I'm running on Vista Ultimate.
David Neal
MCSD, MCSE, MCDBA
http://www.ChristianASP.NET/
ChristianASPNET
 
Posts: 6
Joined: Fri Sep 10, 2004 6:23 pm
Location: Nashville, TN

Same here.

Postby btompkins » Fri Feb 02, 2007 3:02 pm

I'm having this same problem. Any answers?
btompkins
 
Posts: 3
Joined: Thu Jan 04, 2007 7:38 pm

Postby ChristianASPNET » Fri Feb 02, 2007 3:13 pm

I contacted support, and after a few troubleshooting steps, here's the reply I received:

I have been unable to find any solution as to why you are getting this error. I have contacted development about the problem, and they will let me know as soon as they have some information.

I will close this call for now, but I will let you know as soon as I hear anything.
David Neal
MCSD, MCSE, MCDBA
http://www.ChristianASP.NET/
ChristianASPNET
 
Posts: 6
Joined: Fri Sep 10, 2004 6:23 pm
Location: Nashville, TN

Postby Dave Mellors » Fri Feb 02, 2007 6:32 pm

Thank you for posting that reply in this forum. It gives us awareness of it, provides a chance for us to respond and let's us take steps to prevent it from happening again

I wanted to let you know that the exception with DevExpress.XtraGrid.GridControl is being actively investigated by both the technical support team and our developers.

We hope to be able to provide a solution to this problem soon. The details of the solution will be posted in this forum as soon as we can and we will also contact customers directly who logged a call with us regarding this error.

Your co-operation and patience in this matter is very much appreciated and I am very sorry that the response you received from support was worded in that way.
Dave Mellors
Technical Support Engineer
Red Gate Software Ltd.
Tel US and CAN: 1-866-RED GATE
Tel World: +44 (0)870 160 0037 ext 43
Dave Mellors
 
Posts: 31
Joined: Thu Feb 01, 2007 6:03 pm

Postby ChristianASPNET » Fri Feb 02, 2007 6:34 pm

By the way, I rebuilt my Windows XP machine and installed the latest 5.3 bundle, and also received a similar message on application startup. I uninstalled and found an old copy of the 5.2 bundle on our company network and that works.
David Neal
MCSD, MCSE, MCDBA
http://www.ChristianASP.NET/
ChristianASPNET
 
Posts: 6
Joined: Fri Sep 10, 2004 6:23 pm
Location: Nashville, TN

Postby Dave Mellors » Fri Feb 02, 2007 6:37 pm

Thanks David, that extra information is very useful.

I will make sure everyone involved in providing the resolution is aware of it.
Dave Mellors
Technical Support Engineer
Red Gate Software Ltd.
Tel US and CAN: 1-866-RED GATE
Tel World: +44 (0)870 160 0037 ext 43
Dave Mellors
 
Posts: 31
Joined: Thu Feb 01, 2007 6:03 pm

Postby ChristianASPNET » Fri Feb 02, 2007 6:42 pm

Hey guys... on a hunch I decided to reinstall 5.3 on my XP machine. This time it works. The difference is one of two things:

1) I didn't have .NET Framework 1.1 installed before, but this time I do

2) I didn't have any saved projects to display before, but this time I do

Hope this helps!
David Neal
MCSD, MCSE, MCDBA
http://www.ChristianASP.NET/
ChristianASPNET
 
Posts: 6
Joined: Fri Sep 10, 2004 6:23 pm
Location: Nashville, TN

Postby Dave Mellors » Fri Feb 02, 2007 6:55 pm

Good news about your XP machine!

Not sure I understand why those two things should make a difference but I'm glad it worked for you. It will be interesting to see what the rest of the team make of it.

Would you be able to install 5.2 on your Vista PC and see if that works?
Dave Mellors
Technical Support Engineer
Red Gate Software Ltd.
Tel US and CAN: 1-866-RED GATE
Tel World: +44 (0)870 160 0037 ext 43
Dave Mellors
 
Posts: 31
Joined: Thu Feb 01, 2007 6:03 pm

Postby ChristianASPNET » Fri Feb 02, 2007 7:33 pm

SQL Bundle 5.2 has the same issue on Vista.

The (lack of the) .NET Framework 1.1 is the issue. I bravely installed the .NET Framework 1.1 on my Vista machine and now SQL Compare and Data Compare are working!
David Neal
MCSD, MCSE, MCDBA
http://www.ChristianASP.NET/
ChristianASPNET
 
Posts: 6
Joined: Fri Sep 10, 2004 6:23 pm
Location: Nashville, TN

Postby Dave Mellors » Fri Feb 02, 2007 9:13 pm

David,
I'm glad you have managed to sort the problem out and are now working!

Interestingly, my own Vista installation doesn't have .Net Framework 1.1 installed and I don't get the error and the vast majority of our customers do not seem to experience this problem either and I know some of them are Vista users.

We will be investigating this issue further to fully understand why this should make a difference and issue an official solution. I am certain the information you have given here, has speeded the process up no end.

Thank you so much for all of your help, it really is appreciated!
Dave Mellors
Technical Support Engineer
Red Gate Software Ltd.
Tel US and CAN: 1-866-RED GATE
Tel World: +44 (0)870 160 0037 ext 43
Dave Mellors
 
Posts: 31
Joined: Thu Feb 01, 2007 6:03 pm

Postby Brian Donahue » Sat Feb 03, 2007 12:35 pm

I disassembled the UI assembly, and found that _122 seems to have a lot of methods relating to 'licensing' I wonder if the error relates to a failure to get a licence for the third-party components?

SQL Data Compare is built against .NET Framework 1.1, so maybe what had happened is that when XtraGrid component got called, it found a version built for .NET 2.0 (perhaps in your GAC?) and loaded this version instead of the one that shipped with Data Compare and this had caused a licensing issue.

This is my assumption. What we really need is for one of our developers to have a proper look at it.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

DevExpress errors

Postby joltcoder » Mon Feb 12, 2007 8:20 pm

I noticed that my Red-Gate tools were loading the DevExpress binaries from the GAC and not from the application directory. Both assembly copies were version 6.3.1.0; I'm not sure if and why there is a difference internally between the DevExpress assemblies loaded in the GAC and those installed with Red-Gate products but once I removed the 6.3.1.0 assemblies from the GAC all of the applications in the Red-Gate suite that were having problems work perfectly.
Please note that this is by design as the .NET Framework will search the GAC for an assembly (By strong name and version) and if it located it will be used... if it isn't located in the GAC; the framework will begin probing (as defined at http://msdn2.microsoft.com/en-us/library/yx7xezcf.aspx) and will locate the correct assembly in the app or probing path.
I've never seen this cause a problem in the past as one would assume that two binaries with the same strong name and version should be identical... but I didn't dig any deeper.

hth,
bR
joltcoder
 
Posts: 3
Joined: Mon Feb 12, 2007 7:34 pm
Location: Redmond, WA

Postby James Moore » Mon Feb 12, 2007 11:58 pm

Thanks for the heads up Brian,

We will get someone to look into this and try and understand what's going on.

- James
James Moore
Head of DBA Tools
Red Gate Software Ltd
James Moore
 
Posts: 242
Joined: Mon Nov 21, 2005 9:35 am

Next

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests