Synchronisation Wizard in version 6 keeps crashing.

• 
  This may be a problem we've spotted to do with the SQL Server you're using. Can you check the service pack of your sql server as I believe if it's prior to SP4 there can be problems.
  
  We will be bringing a point release out soon that will fix the issue.

  richardjm December 07, 2007 02:44

  - 0 +
• 
  Hi, the target machine is SP4 (8.00.2039, Desktop Engine, this is the local instance running on my machine (WinXP Pro SP2)) but the source is running SP3, 8.00.760, Enterprise Edition.
  
  Does your solution relates to the version of the source, the target or to either one of them?

  Sylvain Lafontaine December 07, 2007 03:13

  - 0 +
• 
  I believe it's just the target machine, so I'm slightly surprised you're seeing that crash.
  
  Do you have Red Gate SQL Backup installed on the machine, and if so, which version?
  
  Many thanks,
  Robert

  Robert C December 07, 2007 03:29

  - 0 +
• 
  Yes, I had SQL Backup Pro (july 2006) installed on this machine and removed a few weeks ago and SQL Backup 5 installed recently but never used.
  
  If I remember correctly, I've used SQL Backup Pro (the older version) to make some tests but not with this particular database; it was with another database running on the same instance.
  
  I'd also used SQL Log Rescue but again not on this database, it was on another one but still both on the same (target) SQL-Server 2000.
  
  I can try removing SQL Backup 5 (and/or SQL Log Rescue) if you think this might help correcting the problem.

  Sylvain Lafontaine December 07, 2007 12:55

  - 0 +
• 
  Hi,
  
  If you're not using SQL Backup, you might want to give it a go for the moment - hopefully the issue should be addressed properly in the patch release of Data Compare (expected early next year, I think), but this should get you running for the moment.
  
  SQL Log Rescue shouldn't have any effect, so there's no need to remove that.
  
  Thanks,
  Robert

  Robert C December 10, 2007 04:44

  - 0 +
• 
  Hi, just a word to say that I've just removed SQL-Backup (and rebooted) but still no luck, SQL-DataCompare 6 keeps crashing.

  Sylvain Lafontaine December 10, 2007 15:56

  - 0 +
• 
  Hi,
  
  Bother - I thought that would've cured it. Do you have access to any other database servers that you could run against as the target? (Obviously not actually performing the synchronization!)
  
  Do you get any details regarding the crash, or is it just an instant bail out with no further information?
  
  Sorry this hasn't worked for you so far - and thanks for your help in providing the information!
  
  Robert

  Robert C December 10, 2007 18:47

  - 0 +
• 
  Hi, the crash occurs after the display of the first dialog window of the wizard: it display it's dialog window then after 2 or 3 seconds, the crashing window appears. It looks like that SQL-Compare is trying to access a null record; if I enter the CLR Debugger, I have the following information:
  
  An unhandled exception of type 'System.Data.SqlType.SqlNullValueException' occurred in System.Windows.Forms.dll
  
  Additional information: Data is Null. This method or property cannot be called on Null values.
  
  
  To my knowledge, there is no further usefull information from the Debugger. If I take a look at the error report (the one to be sent to Microsoft); I have the following content:
  
  from the Error Report Contents; first window:
  
  Error Signature:
  EventType: clr20r3
  P1: redgate.sqldatacompare.ui.exe
  P2: 6.0.0.1124
  P3: 4703485d
  P4: system.windows.forms
  P5: 2.0.0.0
  P6: 461ef203
  P7: 150c
  P8: 12f
  P9: desIn42ebwmodxjic4snf0cyehcagzn
  
  
  If I click to view the contents of the error report:
  
  Exception Information
  Code: 0x0434f4d Flags: 0x000000007c812a5b
  Record: 0x0000000000000000 Address: 0x000000007c812a5b
  
  Module 1
  RedGate.SQLDataC
  Image Base: 0x11000000 Image Size: 0x00000000
  .....

  Sylvain Lafontaine December 12, 2007 13:21

  - 0 +
• 
  I must add to that that the wizard seems to be working correctly as I can click the buttons and follow the sequence of dialog windows and even perform the final synchronisation step correctly.

  Sylvain Lafontaine December 12, 2007 13:37

  - 0 +
• 
  Hi,
  
  Thanks for the information - that's exactly what I was looking for. The reason it'll appear to keep working in the background is that the crash is actually happening in a background initialisation thread, rather than the UI thread.
  
  Sorry once again for the inconvenience - we'll let you know as soon as we've got a patch available.
  
  Thanks,
  Robert

  Robert C December 13, 2007 05:28

  - 0 +
• 
  Hi,
  
  Just to let you know, 6.1 is now out. You can get this by going to Check for Updates on the Help menu.
  
  Robert

  Robert C January 24, 2008 06:26

  - 0 +

Add comment

Please sign in to leave a comment.