.NET Error when trying to run SQL Prompt Command Line
intGod
Posts: 7 New member
in SQL Prompt
When running the SQL Prompt command line, I get this error.
Unhandled Exception: System.IO.FileLoadException: Could not load file or assembly 'System.Memory, Version=4.0.1.1, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
Unhandled Exception: System.IO.FileLoadException: Could not load file or assembly 'System.Memory, Version=4.0.1.1, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
at System.CommandLine.Parsing.StringExtensions.Tokenize(IReadOnlyList`1 args, CommandLineConfiguration configuration, Boolean inferRootCommand)
at System.CommandLine.Parsing.Parser.Parse(IReadOnlyList`1 arguments, String rawInput)
at RedGate.SqlPrompt.Formatting.Bulk.CommandLine.Program.Main(String[] args)
The command I ran was:
C:\"Program Files (x86)\Red Gate\SQL Prompt 10\FormatCommandLine\SqlPrompt.Format.CommandLine.exe" --i-agree-to-the-eula --path c:\Users\XXXXXXXXX --style "C:\Users\XXXXXXXXX\AppData\Local\Red Gate\SQL Prompt 10\Styles\Kristof-f2b8d899-4be0-4ebe-9220-4b63ae5d3fd6.json" --create-backups
The command I ran was:
C:\"Program Files (x86)\Red Gate\SQL Prompt 10\FormatCommandLine\SqlPrompt.Format.CommandLine.exe" --i-agree-to-the-eula --path c:\Users\XXXXXXXXX --style "C:\Users\XXXXXXXXX\AppData\Local\Red Gate\SQL Prompt 10\Styles\Kristof-f2b8d899-4be0-4ebe-9220-4b63ae5d3fd6.json" --create-backups
Best Answer
-
Jon_Kirkwood Posts: 428 Gold 1Hi @intGod
Thank you for reaching out to us on the Redgate forums. We're here to help you with the error you encountered in the SQL Prompt command line.
Could you please let me know the version you are currently running?
There was a bug that we identified and fixed in version 10.14.10.
If you are using a version older than this, would you mind updating to the latest version, v10.14.12, at your earliest convenience? After updating, please check if the error persists.
You can download the versions from the following links:
Release notes for reference:
https://documentation.red-gate.com/sp/release-notes-and-other-versions/sql-prompt-10-14-release-notes10.14.10.7538 - Released on 14 March 2024
Fixes- Fixed "Could not load file or assembly System.Memory" exception, occuring when using SqlPrompt.Format.CommandLine.exe from FormatCommandLine.zip.
Jon Kirkwood | Technical Support Engineer | Redgate Software