Bug that disables "Edit Project" and "Refresh" buttons

JHunt

Since upgrading to SQL Data Compare v8, we have experienced the following problem. After opening a SQL Data Compare project and running the Synchronization Wizard, clicking on the "Edit Project" toolbar button does not work. Ditto for the "Refresh" button. We have to re-save and re-open the project in order to be able to edit it.

JHunt

I should add that it's not just the toolbar buttons. When the Edit Project button fails to work, attempting to edit the already opened project via the menu "File \ Edit Project" option doesn't work either.

Brian Donahue

Hi James,

Thanks for your post. There has been one other incidence of this GUI problem in SQL Data Compare and I am working to get a hang dump from this customer because I suspect a resource deadlock or runaway somewhere in the process. At this point, I'd still call it a rare/edge case so it's probably specific to your environment. If you can provide the OS version and bitness, that could possibly be of some help.

JHunt

Hi Brian,

Our workstations are XP Pro SP3 32bit, and this behavior has been observed to consistently happen on more than one of our workstations.

Thanks very much,

Brian Donahue

Hi James,

Preliminary examination of the problem that occurred for someone else looks like SQL Data Compare is ignoring an out of memory exception when refreshing the database schema. Note: this may not be an actual out of memory condition -- it may be lack of disk space or a .NET glitch as well. I'll keep you updated.

JHunt

Hi Brian,

Thanks for the update. If there's any further information that you need from us to help resolve the problem, just let me know.

buckindb

I am experiencing this same problem using RedGate SQL Data Compare. I am running version 8.0.1.9 under Windows 7 RTM.

Thanks,

David

Brian Donahue

At this point, I think the issue is caused by a "System.OutOfMemoryException" when refreshing the database schema that's been caught and silently handled. Since the error aborts the thread, the button is never notified that the refresh is complete and therefore never returns to the "upright position".

Brian Donahue

We have got one reproduction of this now, I'm happy to say. This does not happen all the time, but in some databases, a situation comes up where an error occurs when reading a saved schema representation from disk. A bit of the schema can't be deserialized from XML, and an out of memory exception results, terminating the worker thread silently.

We are looking into fixing the problem now.

PDinCA

Another "sufferer"...

Just created an empty DB, used SQL Compare to add 5 tables, used SQL Data Compare to copy data and cannot:

1. Edit Project - at all, and it is saved. 2. See any "Identical" rows, by any and all means attempted. 3. Refresh. 4. View Project Options - menu or Ctrl+J.

Both Products are the latest builds:

Compare: 8.1.0.360 Data Compare: 8.0.2.5

The Easter Egg works fine

Brian Donahue

Thanks for your patience -- I believe we now have a fix for the issue that causes the Edit buttons to freeze the program:

http://www.red-gate.com/MessageBoard/vi ... php?t=9880

This happens when comparing some databases whose schemata contain UDTs that return tables.

PDinCA

Hi Brian,

Is the link in the preceding post meant to do anything other than open a new browser window at the same topic?

Brian Donahue

Sorry, it should be http://www.red-gate.com/MessageBoard/vi ... php?t=9880

I've amended the original post.

JHunt

I downloaded the new SQL Data Compare build that you linked to and installed it on my workstation. I've been using it for a few days and it does indeed appear to have fixed the bug that I originally reported.

Thanks very much.