Exception Info: System.FormatException

ArthasArthas Posts: 2 New member
in SQL Compare
I'm getting the error below post compare and when I click on the accordion to view the objects that have differences in schema

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()
Tagged:
· Share on Twitter

Answers

  • chrisqtranchrisqtran Posts: 135 Silver 3
    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
    · Share on Twitter
  • BrienKingBrienKing Posts: 33 Bronze 3
    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?   
    --
    Brien King
    brien@classicsoft.com
    · Share on Twitter
  • chrisqtranchrisqtran Posts: 135 Silver 3
    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.
    · Share on Twitter
  • BrienKingBrienKing Posts: 33 Bronze 3
    Didn't help.   After being a customer for 19+ years, I'm done.   Time to go to a competitor.
    --
    Brien King
    brien@classicsoft.com
    · Share on Twitter
  • chrisqtranchrisqtran Posts: 135 Silver 3
    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?
    · Share on Twitter
  • BrienKingBrienKing Posts: 33 Bronze 3
    The error has been submitted to Red Gate via the built in reporting tool many many times.
    --
    Brien King
    brien@classicsoft.com
    · Share on Twitter
  • RBeaubienRBeaubien Posts: 23 Bronze 2
    I am having the same issue.  I'm running SQL Prompt 10.16.2.14461 and SQL Compare 14.10.8.22508.
    - Robert Beaubien
    - Kool Software
    · Share on Twitter
  • chrisqtranchrisqtran Posts: 135 Silver 3
    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.
    · Share on Twitter
  • RBeaubienRBeaubien Posts: 23 Bronze 2
    edited January 14, 2025 12:30AM

    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()

    - Robert Beaubien
    - Kool Software
    · Share on Twitter
  • ArthasArthas Posts: 2 New member
    The 12/4 version update fixed it for me. 

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


    · Share on Twitter
Sign In or Register to comment.