User profile for Roil – Support

Activity overview Badges (0) Posts (1) Comments (2)

Comments

I tried the following: Enabled Verbose Logging within SSMS Ran SQL Prompt formatter from command line with SSMS open. Went to SSMS and clicked View Log (shown below) Went to the %LOCALAPPDATA%\Red Gate\Logs\SQL Prompt 10 directory to see if that caught it There was only one log file there, but it has not been modified since April. (shown below) Log from SSMS: 2022-08-03 08:34:48.573 -04:00 [Information] Logging level set to 'Information' 2022-08-03 08:34:50.924 -04:00 [Information] Launching package entry point Ssms18 (version 15.0.18424.0) for SQL Prompt 10.12.3.28623. 2022-08-03 08:34:51.228 -04:00 [Information] Initialising DTE and AddIn connections. DTE.FullName: C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe DTE.Version: 2019.0150 DTE.CommandLine: Current culture: en-US Current UI culture: en-US 2022-08-03 08:34:53.137 -04:00 [Information] Current license: Enabled = True, Activated = True, Features = [None] 2022-08-03 08:34:55.638 -04:00 [Information] SqlPromptApplication initialised (startup took 0:0:0.0) Log from %LOCALAPPDATA%\Red Gate\Logs\SQL Prompt 10: 2022-04-06 07:24:00.780 -04:00 [Information] Logging level set to 'Information' 2022-04-06 07:24:01.145 -04:00 [Error] Report error dialog UI shown System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.Bcl.AsyncInterfaces, Version=5.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The system cannot find the file specified. File name: 'Microsoft.Bcl.AsyncInterfaces, Version=5.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' at RedGate.SqlPrompt.Platform.Client.HttpClientConfiguration.Configure(IKernel kernel) at RedGate.SqlPrompt.Platform.Client.PlatformModule.Load() at Ninject.Modules.NinjectModule.OnLoad(IKernel kernel) at Ninject.KernelBase.Load(IEnumerable`1 m) at RedGate.SqlPrompt.EntryPointCommon.NinjectSetup.Create() at RedGate.SqlPrompt.EntryPointCommon.Startup.<>c__DisplayClass0_0.<Initialize>b__0() at RedGate.SqlPrompt.UsageReporting.ErrorReporting.ErrorReporterWithUI.Do(Action action) WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. / comments

I tried the following: Enabled Verbose Logging within SSMS Ran SQL Prompt formatter from command line with SSMS open. Went to SSMS and clicked View Log (shown below) Went to the %LOCALAPPDATA%\Red ...

0 votes

FYI. I installed the newest version of SQL Prompt this morning, and the error message has changed to the following: Error encountered during format: Could not load file or assembly 'System.ValueTuple, Version=4.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The system cannot find the file specified. / comments

FYI. I installed the newest version of SQL Prompt this morning, and the error message has changed to the following:Error encountered during format: Could not load file or assembly 'System.ValueTupl...

0 votes

Total activity: 4
Last activity: February 06, 2025 11:57
Member since: February 06, 2025 11:57

Following: 0 users
Followed by: 0 users
Votes: 0
Subscriptions: 1