SQL Change Automation Build Failed on Azure Devops

I use Azure Devops to build My Test DB, but it always faild, logs is below, Can anyone hellp Me, Thanks!

2019-10-14T05:56:22.4604407Z ##[error]RedGate.Versioning.Automation.Shared.Errors.TerminatingException: 25 batches failed. The first error is 'Assembly 'system.enterpriseservices, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a.' was not found in the SQL catalog.
2019-10-14T05:56:22.4605443Z Warning: The Microsoft .NET Framework assembly 'system.web, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, processorarchitecture=amd64.' you are registering is not fully tested in the SQL Server hosted environment and is not supported. In the future, if you upgrade or service this assembly or the .NET Framework, your CLR integration routine may stop working. Please refer SQL Server Books Online for more details.' ---> System.AggregateException: 25 batches failed. The first error is 'Assembly 'system.enterpriseservices, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a.' was not found in the SQL catalog.
2019-10-14T05:56:22.4605955Z Warning: The Microsoft .NET Framework assembly 'system.web, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, processorarchitecture=amd64.' you are registering is not fully tested in the SQL Server hosted environment and is not supported. In the future, if you upgrade or service this assembly or the .NET Framework, your CLR integration routine may stop working. Please refer SQL Server Books Online for more details.' ---> System.Data.SqlClient.SqlException: Assembly 'system.enterpriseservices, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a.' was not found in the SQL catalog.
2019-10-14T05:56:22.4606149Z Warning: The Microsoft .NET Framework assembly 'system.web, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, processorarchitecture=amd64.' you are registering is not fully tested in the SQL Server hosted environment and is not supported. In the future, if you upgrade or service this assembly or the .NET Framework, your CLR integration routine may stop working. Please refer SQL Server Books Online for more details.
2019-10-14T05:56:22.4606329Z    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
2019-10-14T05:56:22.4606484Z    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
2019-10-14T05:56:22.4606633Z    at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
2019-10-14T05:56:22.4606788Z    at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
2019-10-14T05:56:22.4606939Z    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
2019-10-14T05:56:22.4607231Z    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
2019-10-14T05:56:22.4607367Z    at RedGate.Versioning.Automation.Shared.SQL.ErrorEnhancedDbCommand.ExecuteNonQuery()
2019-10-14T05:56:22.4607892Z    at RedGate.Versioning.Automation.Compare.SqlProcessing.SqlExecutor.ExecuteBatches(IDbConnection connection, IEnumerable`1 batches, Int32 commandTimeout, ISqlExecutorLogger batchLogger)
2019-10-14T05:56:22.4608028Z    --- End of inner exception stack trace ---
2019-10-14T05:56:22.4608140Z    at RedGate.Versioning.Automation.Compare.SqlProcessing.SqlExecutor.ExecuteBatches(IDbConnection connection, IEnumerable`1 batches, Int32 commandTimeout, ISqlExecutorLogger batchLogger)
2019-10-14T05:56:22.4608271Z    at RedGate.Versioning.Automation.Compare.SqlProcessing.SqlExecutor.ExecuteBatches(IHaveConnectionString connectionString, IReadOnlyCollection`1 sqlBatches, Int32 commandTimeout, Action`1 logAction)
2019-10-14T05:56:22.4608391Z    --- End of inner exception stack trace ---
2019-10-14T05:56:22.4608505Z    at RedGate.Versioning.Automation.Compare.SqlProcessing.SqlExecutor.ExecuteBatches(IHaveConnectionString connectionString, IReadOnlyCollection`1 sqlBatches, Int32 commandTimeout, Action`1 logAction)
2019-10-14T05:56:22.4608640Z    at RedGate.Versioning.Automation.Compare.Compare.SchemaUpdater.UpdateFromScriptsFolderWithAction(String scriptsFolderPath, IDatabase database, CreateDatabaseParameters createDatabaseParameters)
2019-10-14T05:56:22.4608754Z    at RedGate.Versioning.Automation.Compare.SchemaValidation.DiskBackedProjectValidator.ValidateProject(IProjectPath projectPath, IDatabase database, CreateDatabaseParameters createDatabaseParameters)
2019-10-14T05:56:22.4608936Z    at RedGate.Versioning.Automation.Compare.SchemaValidation.ProjectValidator.ValidateProject(String projectPath, CreateDatabaseParameters createDatabaseParameters)
2019-10-14T05:56:22.4609160Z    at RedGate.Versioning.Automation.PowerShell.Commands.InvokeDatabaseBuildCommandImpl.Process()
2019-10-14T05:56:22.4609286Z    at RedGate.Versioning.Automation.PowerShell.DlmAutomationCommandImpl`1.ProcessRecord()
2019-10-14T05:56:22.4609395Z    at RedGate.PowerShell.CommandBase`2.DelegateTo(Action doImplementation)
2019-10-14T05:56:22.6576963Z ##[error]Unable to process command '##vso[artifact.upload artifactname=Database Build Artifact;containerfolder=Database Build Artifact;]D:\a\1\s\LS_MES.1.0.nupkg' successfully. Please reference documentation (http://go.microsoft.com/fwlink/?LinkId=817296)
2019-10-14T05:56:22.6579370Z ##[error]Path not exist: D:\a\1\s\LS_MES.1.0.nupkg
2019-10-14T05:56:22.8170727Z ##[error]PowerShell script completed with 1 errors.
2019-10-14T05:56:22.8188634Z ##[section]Finishing: Build SQL Change Automation Project LS_MES
Tagged:

Answers

  • Jessica RJessica R Posts: 1,181 Rose Gold 4
    Hi there,

    Sorry to hear you're running into an issue!

    Can I please check what edition and version of SQL Server you are using as the temporary database?

    If you try to run a CREATE ASSEMBLY statement directly on that SQL Server, does it throw the same error?

    Jessica Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


Sign In or Register to comment.