SQL Toolbelt, latest version, fails with error 0434352

gilbertr2412

Looks like it fails during decompression of installer,
It worked once, but now will not work at all.

Windows 10
SSMS 18 and 19
VS 2019 and 2022

Application: RedGate.Installer.UI.App.exe

Framework Version: v4.0.30319

Description: The process was terminated due to an unhandled exception.

Exception Info: RedGate.Installer.Compressors.SevenZip.DataErrorException

   at RedGate.Installer.Compressors.SevenZip.Compress.LZMA.Decoder.Code(System.IO.Stream, System.IO.Stream, Int64, Int64, RedGate.Installer.Compressors.SevenZip.ICodeProgress)

   at RedGate.Installer.Compressors.Compressors.Lzma7ZipCompressor.Decompress(System.IO.Stream, System.IO.Stream)

   at RedGate.CompressEngine.DecompressFile.DecompressStreamAndDeleteFile(RedGate.Installer.CompressionInterfaces.ICompressor, System.String, System.String)

   at RedGate.CompressEngine.DecompressFile+ThreadPooledDecompression.ThreadPoolCallback(System.Object)

Exception Info: System.Exception

   at RedGate.CompressEngine.DecompressFile.DecompressAllTheStreams(System.IO.BinaryReader, RedGate.Installer.CompressionInterfaces.ICompressor)

   at RedGate.CompressEngine.DecompressFile.DecompressToStream()

   at RedGate.CompressEngine.DecompressFile..ctor(System.String)

   at RedGate.Installer.Adapter.ContentDecompressor.ExtractionThreadMethod()

   at RedGate.Installer.ThreadHelper.ThreadCreator+<>c__DisplayClass0_0.<Create>b__0()

Exception Info: System.Exception

   at RedGate.Installer.ThreadHelper.ThreadCreator+<>c__DisplayClass0_1.<Create>b__1()

   at System.Windows.Threading.ExceptionWrapper.InternalRealCall(System.Delegate, System.Object, Int32)

   at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(System.Object, System.Delegate, System.Object, Int32, System.Delegate)

   at System.Windows.Threading.DispatcherOperation.InvokeImpl()

   at System.Windows.Threading.DispatcherOperation.InvokeInSecurityContext(System.Object)

   at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)

   at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)

   at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object)

   at MS.Internal.CulturePreservingExecutionContext.Run(MS.Internal.CulturePreservingExecutionContext, System.Threading.ContextCallback, System.Object)

   at System.Windows.Threading.DispatcherOperation.Invoke()

   at System.Windows.Threading.Dispatcher.ProcessQueue()

   at System.Windows.Threading.Dispatcher.WndProcHook(IntPtr, Int32, IntPtr, IntPtr, Boolean ByRef)

   at MS.Win32.HwndWrapper.WndProc(IntPtr, Int32, IntPtr, IntPtr, Boolean ByRef)

   at MS.Win32.HwndSubclass.DispatcherCallbackOperation(System.Object)

   at System.Windows.Threading.ExceptionWrapper.InternalRealCall(System.Delegate, System.Object, Int32)

   at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(System.Object, System.Delegate, System.Object, Int32, System.Delegate)

   at System.Windows.Threading.Dispatcher.LegacyInvokeImpl(System.Windows.Threading.DispatcherPriority, System.TimeSpan, System.Delegate, System.Object, Int32)

   at MS.Win32.HwndSubclass.SubclassWndProc(IntPtr, Int32, IntPtr, IntPtr)

   at MS.Win32.UnsafeNativeMethods.DispatchMessage(System.Windows.Interop.MSG ByRef)

   at System.Windows.Threading.Dispatcher.PushFrameImpl(System.Windows.Threading.DispatcherFrame)

   at System.Windows.Threading.Dispatcher.PushFrame(System.Windows.Threading.DispatcherFrame)

   at System.Windows.Application.RunDispatcher(System.Object)

   at System.Windows.Application.RunInternal(System.Windows.Window)

   at System.Windows.Application.Run(System.Windows.Window)

   at RedGate.Installer.UI.App.App.Main()

Victoria W

Hi

We are currently investigating this error. Please can you try using this SQL Toolbelt Essentials installer instead and see if it works for you?
 
https://download.red-gate.com/installers/SQLToolbeltEssentials/2023-06-21/SQLToolbeltEssentials.exe

JerOstmeyer

I've also had this same issue after my work desktop was replaced this week. Only it is failing every time within 30 seconds no matter what I do, even if I run run the executable and do nothing. I've confirmed that the account running the installer has admin permissions and the installer is being run as admin. I'm getting the exact same error code and error in the event log.

I checked and I have 7zip installed (just incase that matters) and I have .net 4.8 (since a prior recommendation was to have 4.6.1) and I tried changing the temp location, but the command didn't work for me. Also the machine in question is isolated from the web, so if there is any downloading necessary it won't be able to complete that, but I believe the installer isn't supposed to require a connection.

KevinGreiner

I'm having the same problem. Windows 10 fully updated, running installer as admin doesn't help.

gilbertr2412

That worked for me - the installer did not throw an error and SSMS 19 has tools installed!!

GreinerKevin

Same. This installer worked for me. Thanks Victoria.

gilbertr2412

There are instructions on how to extract from msi
Installing from the .msi file (silent install) – Support (red-gate.com)

By following this, I was able to get installs for SQL Prompt and SSMS tools to finally install.

JerOstmeyer

Victoria W said:

Hi

We are currently investigating this error. Please can you try using this SQL Toolbelt Essentials installer instead and see if it works for you?
 
https://download.red-gate.com/installers/SQLToolbeltEssentials/2023-06-21/SQLToolbeltEssentials.exe

I tried that installer instead and it worked as expected. Thanks!

Victoria W

Hi all

New installer now available!

https://download.red-gate.com/installers/SQLToolbeltEssentials/2023-06-29/SQLToolbeltEssentials.exe