Exception Info: System.FormatException

• 
  Hi all,
  
  This issue was resolved through a support ticket.
  
  Be sure to have the following product versions (or later) installed to resolve this error:
  https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.23.11448.exe
  https://download.red-gate.com/checkforupdates/SQLCompare/SQLCompare_15.3.14.27393.exe

  chrisqtran December 06, 2024 21:26

  - 0 +
• 
  Except I am not moving to 15.x because I'm not going to the "Subscription" model.   What do we do if we are on 14.x?

  BrienKing January 08, 2025 21:09

  - 0 +
• 
  Hi @BrienKing
  
  In your case, I would make sure you're using SQL Prompt v10.14.23 or later and see if that resolves the issue.

  chrisqtran January 08, 2025 21:11

  - 0 +
• 
  Didn't help.   After being a customer for 19+ years, I'm done.   Time to go to a competitor.
  

  BrienKing January 08, 2025 21:26

  - 0 +
• 
  Hi @BrienKing
  
  What versions of SQL Prompt and SQL Compare do you have installed? Are you able to share a screenshot of the error you're getting as well?

  chrisqtran January 08, 2025 21:49

  - 0 +
• 
  The error has been submitted to Red Gate via the built in reporting tool many many times.

  BrienKing January 13, 2025 22:26

  - 0 +
• 
  I am having the same issue.  I'm running SQL Prompt 10.16.2.14461 and SQL Compare 14.10.8.22508.

  RBeaubien January 13, 2025 23:24

  - 0 +
• 
  Hi all,
  
  Are you able to share a screenshot of the error you get when you view the differences? I'd like to confirm if this is the same issue as the original post.

  chrisqtran January 13, 2025 23:33

  - 0 +
• 
  
  

  Application: RedGate.SQLCompare.UI.exe

  Framework Version: v4.0.30319

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

  Exception Info: System.FormatException

     at System.Version+VersionResult.SetFailure(ParseFailureKind, System.String)

     at System.Version.TryParseComponent(System.String, System.String, VersionResult ByRef, Int32 ByRef)

     at System.Version.TryParseVersion(System.String, VersionResult ByRef)

     at System.Version.Parse(System.String)

     at System.Version..ctor(System.String)

     at RedGate.SqlServer.Comparison.Schema.UI.Services.ExternalFormatting.ReleaseSqlPromptVersionChecker.IsCorrectVersion(System.String)

     at RedGate.SqlServer.Comparison.Schema.UI.Services.ExternalFormatting.ExternalFormatterLocator.LocatePromptPath(System.String)

     at RedGate.SqlServer.Comparison.Schema.UI.Services.ExternalFormatting.ExternalFormatter.Format(RedGate.SQLCompare.Engine.Regions)

     at RedGate.SqlServer.Comparison.Schema.UI.Services.SchemaEngineService.GetComparisonStrings(RedGate.SqlServer.Comparison.Schema.UI.Model.Grid.SchemaDifferenceRow, RedGate.SQLCompare.Engine.Options, System.Collections.Generic.List`1<RedGate.Compare.CommonUI.Shared.Model.MyRegion> ByRef, Boolean, Boolean)

     at RedGate.SqlServer.Comparison.Schema.UI.Services.SchemaEngineService.CreateTextualDifferences(RedGate.SqlServer.Comparison.Schema.UI.Model.ComparisonState, Boolean, RedGate.SqlServer.SharedGUI.Model.Schema.ISchemaDifferenceRow)

     at RedGate.SqlServer.SharedGUI.Controls.ObjectDifferences.Schema.SchemaDifferenceViewerFrame.CalculateDifferences(RedGate.SqlServer.SharedGUI.Model.Schema.ISchemaDifferenceRow)

     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.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()

     at System.Threading.ThreadPoolWorkQueue.Dispatch()

  
  

  RBeaubien January 14, 2025 00:28

  - 0 +
• 
  The 12/4 version update fixed it for me. 
  
  

  https://download.red-gate.com/installers/SQLToolbeltEssentials/2024-12-04/SQLToolbeltEssentials.exe

  
  

  Arthas January 14, 2025 16:15

  - 0 +

Add comment

Please sign in to leave a comment.