How can we help you today? How can we help you today?
PDinCA
Brian Donahue wrote: Hi, I think that on the surface it's a client-side issue because SQLLite is the technology used to host the SQL Backup console's data cache. However, since you have deleted the data from there, I'd guess that the server-side data is corrupt. The evidence does not give us a clear conclusion, though. If you can, I think you should run the server side utility to verify all of the SQL CE databases that SQL Backup uses on the server-side. If you aren't allowed .NET on the SQL Server, then you can't do that. I ran the utility on the SS2008 instance under Windows Server 2008 - the one that bombed in the post above and the utility exceptioned: ************** Exception Text ************** System.BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B) at System.Data.SqlServerCe.NativeMethods.DllAddRef() at System.Data.SqlServerCe.SqlCeEngine..ctor() at RepairSQBDataStore.SDFDataStore..ctor(String filename) in D:\Documents\brian.donahue\My Documents\Visual Studio 2008\Projects\RepairSQBDataStore\RepairSQBDataStore\SDFDataStore.cs:line 15 at RepairSQBDataStore.Form1.butVerify_Click(Object sender, EventArgs e) in D:\Documents\brian.donahue\My Documents\Visual Studio 2008\Projects\RepairSQBDataStore\RepairSQBDataStore\Form1.cs:line 174 at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) ************** Loaded Assemblies ************** mscorlib Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3074 (QFE.050727-3000) CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll ---------------------------------------- RepairSQBDataStore Assembly Version: 1.0.0.0 Win32 Version: 1.0.0.0 CodeBase: file:///T:/PD-IT/Software/Red-Gate/RepairSQBDataStore/RepairSQBDataStore.exe ---------------------------------------- System.Windows.Forms Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll ---------------------------------------- System Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- System.Drawing Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll ---------------------------------------- System.Management Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll ---------------------------------------- System.ServiceProcess Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.dll ---------------------------------------- System.Data.SqlServerCe Assembly Version: 9.0.242.0 Win32 Version: 3.0.5300.0 CodeBase: file:///T:/PD-IT/Software/Red-Gate/RepairSQBDataStore/System.Data.SqlServerCe.DLL ---------------------------------------- I uninstalled the SQB Server Components and reinstalled and still it crashes. Ideas? / comments
Brian Donahue wrote: Hi, I think that on the surface it's a client-side issue because SQLLite is the technology used to host the SQL Backup console's data cache. However, since you have deleted t...
0 votes
James: SO Close! I excluded every subfolder under Local Settings\Application Data\Red Gate\ from Symantec's Endpoint Protection. I managed to expand the Production group and two of its servers, but when I expanded the Development Group - poof! No Exception, no message, just "gone"... Do I need to do any excludes on the servers too? Robin: filemon/procmon are unfamiliar to me, so I'd need some assistance to set them up... Details? When I first open SQL Backup, I get the "Upgrading Activity Cache" dialog every time - it never appears to complete, even having managed to keep the UI active for a few minutes. I usually choose the default "Upgrade Now" but even if I choose "Later" I get the error: "Some cache files could not be upgraded. It may initially take a few minutes to display activity history for some servers." I whacked the entire Server Data folder content and now, upon attempted expansion of the Development group: localDataCache.dat 4.dat 4.dat-journal 6.dat 6.dat-journal 7.dat 8.dat 8.dat-journal As the files are binary, I can't see the content of the %journal files... Do you want them? ALL: Took the sledgehammer approach and uninstalled 6.2, rebooted, reinstalled from fresh Toolbelt download and: 1. Added Production Group and each of three servers under it. 2. Added Dev Group and the first virtual OK. 3. Tried to add a SS2000 instance and the UI crashed with no exception. 4. When SQL Backup restarted, I received the "Upgrading Cache" dialog, chose "Now" and my list of groups and servers was EMPTY. 5. Re-added the Production Group and all 3 servers. OK. 6. Closed SQL Backup. 7. Restarted SQL Backup and my Group is intact. 8. Added the DEV Group and one server. OK. 9. Exit and restart - OK. 10. Tried to add a SS2008 instance - crash! 11. Went to the SS2000 and SS2008 "failed addition" servers and ran the SQB Install on both virtuals. 12. Tried to re-add the SS2008 instance - CRASH! Full Logging is still turned on. What can I send you that may help? / comments
James: SO Close! I excluded every subfolder under Local Settings\Application Data\Red Gate\ from Symantec's Endpoint Protection. I managed to expand the Production group and two of its servers, bu...
0 votes
Here's the content of the log file after turning on full logging: 09:22:10.777|Verbose|UI |1 |Loaded RedGate.Shared.Utils, Version=7.3.0.25, Culture=neutral, PublicKeyToken=7f465a1c156d4d57 C:\Program Files\Red Gate\SQL Backup 6\RedGate.Shared.Utils.dll 09:22:10.808|Info |UI |1 |SQL Backup Client 6.2.0.134 09:22:10.808|Info |UI |1 |======================================= 09:22:12.230|Verbose|UI |1 |Loaded System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll 09:22:12.277|Verbose|UI |1 |Loaded System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll 09:22:12.402|Verbose|UI |1 |Loaded System.Data.SQLite, Version=1.0.54.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139 C:\Program Files\Red Gate\SQL Backup 6\System.Data.SQLite.dll 09:22:12.589|Verbose|UI |1 |Loaded System.Transactions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\assembly\GAC_32\System.Transactions\2.0.0.0__b77a5c561934e089\System.Transactions.dll 09:22:12.964|Verbose|UI |1 |Loaded RedGate.SQLCompare.ASTParser, Version=8.0.0.309, Culture=neutral, PublicKeyToken=7f465a1c156d4d57 C:\Program Files\Red Gate\SQL Backup 6\RedGate.SQLCompare.ASTParser.dll 09:22:12.980|Verbose|UI |1 |Loaded RedGate.Shared.SQL, Version=7.3.0.25, Culture=neutral, PublicKeyToken=7f465a1c156d4d57 C:\Program Files\Red Gate\SQL Backup 6\RedGate.Shared.SQL.dll 09:22:13.073|Verbose|UI |1 |Loaded Antlr3.Runtime, Version=3.1.2.41038, Culture=neutral, PublicKeyToken=3a9cab8f8d22bfb7 C:\Program Files\Red Gate\SQL Backup 6\Antlr3.Runtime.dll 09:22:13.183|Verbose|UI |1 |Loaded System.Web.Services, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\assembly\GAC_MSIL\System.Web.Services\2.0.0.0__b03f5f7f11d50a3a\System.Web.Services.dll 09:22:13.448|Verbose|UI |1 |Loaded System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll 09:22:56.934|Verbose|UI |1 |Loaded DevExpress.XtraEditors.v7.2, Version=7.2.4.0, Culture=neutral, PublicKeyToken=9b171c9fd64da1d1 C:\Program Files\Red Gate\SQL Backup 6\DevExpress.XtraEditors.v7.2.dll 09:22:56.981|Verbose|UI |1 |Loaded DevExpress.Utils.v7.2, Version=7.2.4.0, Culture=neutral, PublicKeyToken=9b171c9fd64da1d1 C:\Program Files\Red Gate\SQL Backup 6\DevExpress.Utils.v7.2.dll 09:22:57.074|Verbose|UI |1 |Loaded DevExpress.Data.v7.2, Version=7.2.4.0, Culture=neutral, PublicKeyToken=9b171c9fd64da1d1 C:\Program Files\Red Gate\SQL Backup 6\DevExpress.Data.v7.2.dll 09:22:57.215|Verbose|UI |1 |Loaded DevExpress.XtraBars.v7.2, Version=7.2.4.0, Culture=neutral, PublicKeyToken=9b171c9fd64da1d1 C:\Program Files\Red Gate\SQL Backup 6\DevExpress.XtraBars.v7.2.dll 09:23:00.402|Verbose|UI |1 |Loaded Syncfusion.Grid.Windows, Version=6.102.0.34, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89 C:\Program Files\Red Gate\SQL Backup 6\Syncfusion.Grid.Windows.dll 09:23:00.465|Verbose|UI |1 |Loaded Syncfusion.Shared.Base, Version=6.102.0.34, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89 C:\Program Files\Red Gate\SQL Backup 6\Syncfusion.Shared.Base.dll 09:23:00.652|Verbose|UI |1 |Loaded Syncfusion.Core, Version=6.102.0.34, Culture=neutral, PublicKeyToken=632609b4d040f6b4 C:\Program Files\Red Gate\SQL Backup 6\Syncfusion.Core.dll 09:23:02.934|Verbose|UI |1 |Loaded RedGate.Shared.Controls, Version=7.4.0.7, Culture=neutral, PublicKeyToken=7f465a1c156d4d57 C:\Program Files\Red Gate\SQL Backup 6\RedGate.Shared.Controls.dll 09:23:03.262|Verbose|UI |1 |Connection state of now NotConnected 09:23:03.278|Verbose|UI |1 |Connection state of now NotConnected 09:23:03.278|Verbose|UI |1 |Connection state of now NotConnected 09:23:03.278|Verbose|UI |1 |Connection state of now NotConnected 09:23:03.340|Verbose|UI |1 |Connection state of now NotConnected 09:23:03.340|Verbose|UI |1 |Connection state of now NotConnected 09:23:03.340|Verbose|UI |1 |Connection state of now NotConnected 09:23:03.340|Verbose|UI |1 |Connection state of now NotConnected 09:23:03.340|Verbose|UI |1 |SEL: Selected 9268D399-5F97-438f-A815-DA326F2CF787 09:23:03.699|Verbose|UI |1 |Loaded DevExpress.XtraGrid.v7.2, Version=7.2.4.0, Culture=neutral, PublicKeyToken=9b171c9fd64da1d1 C:\Program Files\Red Gate\SQL Backup 6\DevExpress.XtraGrid.v7.2.dll 09:23:05.574|Verbose|UI |1 |Loaded DevExpress.XtraTreeList.v7.2, Version=7.2.4.0, Culture=neutral, PublicKeyToken=9b171c9fd64da1d1 C:\Program Files\Red Gate\SQL Backup 6\DevExpress.XtraTreeList.v7.2.dll 09:23:06.168|Verbose|UI |1 |SEL: Selected Saddleback 09:23:08.324|Verbose|UI |1 |Loaded RedGate.Update.Client, Version=2.2.0.3, Culture=neutral, PublicKeyToken=7f465a1c156d4d57 C:\Program Files\Red Gate\SQL Backup 6\RedGate.Update.Client.dll 09:24:03.357|Verbose|UI |5 |BackupApplication: Requesting DM update for visible, expanded/selected servers. 09:24:58.217|Verbose|UI |1 |SEL: Selected Production 09:24:58.530|Verbose|UI |1 |Connection state of eSQL now PreConnecting 09:24:58.530|Verbose|UI |6 |Connection state of eSQL now Connecting 09:24:58.561|Verbose|UI |1 |Connection state of mceRPRT now PreConnecting 09:24:58.561|Verbose|UI |1 |Connection state of PD-SQLDB now PreConnecting 09:24:58.577|Verbose|UI |15 |Connection state of mceRPRT now Connecting 09:24:58.577|Verbose|UI |16 |Connection state of PD-SQLDB now Connecting 09:25:02.202|Verbose|UI |1 |DataManager: Queueing data request 61660876 on mceRPRT 09:25:02.217|Verbose|UI |17 |DataManager: EXEC DataReq ActivityHistoryByDates 61660876 on mceRPRT 09:25:02.233|Verbose|UI |15 |Connection state of mceRPRT now Successful 09:25:02.264|Verbose|UI |17 |DataManager: XFORM AHByDates to UpdateReq for DataReq 61660876 on mceRPRT 09:25:02.295|Verbose|UI |17 |DataManager: Queueing UpdateReq 7185836 on mceRPRT from 9/13/2009 12:00:00 AM to 9/14/2009 9:25:02 AM 09:25:02.327|Verbose|UI |20 |DataManager: EXEC UpdateReq 7185836 on mceRPRT 09:25:02.327|Verbose|UI |20 |mceRPRT is updating is None 09:25:02.327|Verbose|UI |20 |mceRPRT continuing updating 09:25:02.342|Verbose|UI |20 |mceRPRT checking sync 09:25:02.420|Verbose|UI |6 |Connection state of eSQL now Successful 09:25:02.514|Verbose|UI |1 |DataManager: Queueing data request 28475059 on eSQL 09:25:02.514|Verbose|UI |17 |DataManager: EXEC DataReq ActivityHistoryByDates 28475059 on eSQL 09:25:02.514|Verbose|UI |17 |DataManager: XFORM AHByDates to UpdateReq for DataReq 28475059 on eSQL 09:25:02.514|Verbose|UI |17 |DataManager: Queueing UpdateReq 54804024 on eSQL from 9/13/2009 12:00:00 AM to 9/14/2009 9:25:02 AM 09:25:02.545|Verbose|UI |20 |mceRPRT is updating is None 09:25:02.561|Verbose|UI |20 |DataManager: XFORM UpdateReq 7185836 to DataReq 61660876 on mceRPRT 09:25:02.561|Verbose|UI |20 |DataManager: Queueing data request 61660876 on mceRPRT 09:25:02.561|Verbose|UI |17 |DataManager: EXEC DataReq ActivityHistoryByDates 61660876 on mceRPRT 09:25:02.577|Verbose|UI |17 |DM: mceRPRT SQL: SELECT * FROM activityhistory WHERE end > 633883968000000000 and start < 633885171021865533 and server_identity = 2 ORDER BY end DESC 09:25:02.577|Verbose|UI |17 |Process delegate is: ey::a 09:25:02.608|Verbose|UI |21 |DataManager: EXEC UpdateReq 54804024 on eSQL 09:25:02.608|Verbose|UI |21 |eSQL is updating is None 09:25:02.608|Verbose|UI |21 |eSQL continuing updating 09:25:02.608|Verbose|UI |21 |eSQL checking sync / comments
Here's the content of the log file after turning on full logging: 09:22:10.777|Verbose|UI |1 |Loaded RedGate.Shared.Utils, Version=7.3.0.25, Culture=neutral, PublicKeyToken=7f465a...
0 votes
Added a new node for the key, then added the value. Ran UI and predicatably it died. Location of the log file(s) you need? / comments
Added a new node for the key, then added the value. Ran UI and predicatably it died. Location of the log file(s) you need?
0 votes