What are the challenges you face when working across database platforms? Take the survey
Options

Error during Build Database task on Azure Devops

druzadruza Posts: 1 New member
Hi, I'm using the Redgate SQL Change Automation: Build task on Azure Devops. During the execution of the build, I'm getting this error:

##[debug]Error: Unhandled exception
##[debug]One or more errors occurred.
##[debug]System.AggregateException
##[debug] at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)
##[debug] at RedGate.SQLCompare.CommandLine.SchemaCommandProcessor.Run()
##[debug] at RedGate.SQLCompare.CommandLine.Startup.Start(String[] args, Boolean proceedPastLicensingCondition)
##[debug] at DLMAutomation.CommandLine.Exe.DlmAutomationStartup.Main(String[] args)
##[debug]Contains exceptions:
##[debug] Input string was not in a correct format.
##[debug] System.FormatException
##[debug] at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
##[debug] at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
##[debug] at System.Data.SqlTypes.SqlInt32.Parse(String s)
##[debug] at RedGate.SQLDataCompare.Engine.TableReaderHelper.ProcessRowDataEx(IDCDataReader reader, Int32& sqlIndex, Int32 fieldIndex, TypeData td, ComparisonOptions comparisonOptions, SQLVersion version, Boolean binaryNewDataTypes, FieldPairs allPairs, Boolean runOnTwo)
##[debug] at RedGate.SQLDataCompare.Engine.FolderReader.FolderTableReader.get_CurrentRow()
##[debug] at RedGate.SQLDataCompare.Engine.ComparisonSession.ScriptTable(ITableReader reader, TableMapping mapping, Boolean runInTwo, ProgressPercentageTracker progress)
##[debug] at RedGate.SQLDataCompare.Engine.ComparisonSession.ScriptDatabase(ISQLProvider provider, TableMappings mappings)
##[debug] at RedGate.SQLDataCompare.Engine.ComparisonSession.CompareDatabases(IDatabase db1, IDatabase db2, TableMappings mappings, SessionSettings sessionSettings, Boolean doNotBeDefeated)
##[debug] at RedGate.SQLDataCompare.Common.Services.DataEngineComparisonService.<>c__DisplayClass9_0.<DoCompareDatabases>b__1()
##[debug] at System.Threading.Tasks.Task.Execute()

It seems like the highlighted method above is trying to parse  an empty string, but I have no idea about what is this string. I might be missing a configuration or an argument but it was working on past builds. Is there a way I can get a more detailed information about the cause of this? Or maybe a clue of what's happening?

Thanks in advance
Tagged:

Answers

  • Options
    Hi,

    This appears to be related to Static Data, you might be able to get more information by using SQL Data Compare to simulate deploying static data to an empty database.
    Sergio
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
Sign In or Register to comment.