Error during Build Database task on Azure Devops

druza

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

Sergio R

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.