The following errors are seen during Citrix Virtual Apps and Desktops (CVAD) upgrade while updating the CVAD Site database schema from version 7.15 LTSR  to 1912 LTSR.
.

Error Id: XDDS:FA5F002A Exception: DesktopStudio_ErrorId : DatabaseError SqlServerOutput : AG_RBAMVSXADDB: XADEMES01DB_Site: Changed database context to 'XADEMES01DB_Site'. AG_RBAMVSXADDB: XADEMES01DB_Site: Updating MachineCreation schema in [XADEMES01DB_Site] from version 7.15.0.0 to 7.24.0.0 Changed database context to 'XADEMES01DB_Site'. ErrorCategory : NotSpecified DesktopStudio_PowerShellHistory : UpdateDatabaseScript 10/14/2021 9:59:54 AM Error Source : Citrix Studio StackTrace: Citrix.Orchestration.Base.LogicModels.Exceptions.ScriptException Failed to upload database scripts at Citrix.Orchestration.Base.PowerShellSdk.UpgradeService.UpgradeTasks.DatabaseUpgradeTask.UpgradeDatabases(IList`1 scripts, IProgressReporter applyDbScriptProgress, ITaskLogger taskLogger) at Citrix.Orchestration.Base.PowerShellSdk.UpgradeService.UpgradeTasks.DatabaseUpgradeTask.RunUpgradeTask(IProgressReporter progressReporter, ITaskLogger taskLogger) at Citrix.Orchestration.Base.PowerShellSdk.UpgradeService.UpgradeTasks.UpgradeTaskBase.RunUpgrade(IProgressReporter progressReporter, ITaskLogger taskLogger) at Citrix.Orchestration.Base.PowerShellSdk.UpgradeService.UpgradeTasks.ServiceUpgradeTask.RunUpgradeTask(IProgressReporter progressReporter, ITaskLogger taskLogger) at Citrix.Orchestration.Base.PowerShellSdk.UpgradeService.UpgradeTasks.UpgradeTaskBase.RunUpgrade(IProgressReporter progressReporter, ITaskLogger taskLogger) at Citrix.Orchestration.Base.PowerShellSdk.UpgradeService.UpgradeTasks.Upgrade.RunUpgradeTask(IProgressReporter progressReporter, ITaskLogger taskLogger) at Citrix.Orchestration.Base.PowerShellSdk.UpgradeService.UpgradeTasks.UpgradeTaskBase.RunUpgrade(IProgressReporter progressReporter, ITaskLogger taskLogger) at Citrix.Console.DeliveryCenter.UI.Mmc.UpgradeResultPaneViewModel.UpgradeTask(IProgressReporter progressReporter, UserCredentials databaseCredentials) at Citrix.Console.Common.OperationTimer.TimeBlock(Action operation) at Citrix.Console.CommonControls.ProgressDisplay.GenericProgressOperationWithFeedBack.PerformOperationInternal() at Citrix.Console.CommonControls.ProgressDisplay.ProgressWindowOperation.PerformOperation() at Citrix.Console.CommonControls.ProgressDisplay.ProgressWindowViewModel.PerformAction(Action operationComplete) Inner Exception: HelpLink.ProdName : Microsoft SQL Server HelpLink.BaseHelpUrl : http://go.microsoft.com/fwlink HelpLink.LinkId : 20476 HelpLink.ProdVer : 11.0.5058.0 ((SQL11_PCU_Main).140514-1623 ) HelpLink.EvtSrc : Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText HelpLink.EvtData1 : ExecuteNonQuery HelpLink.EvtData2 : Database StackTrace: Microsoft.SqlServer.Management.Smo.FailedOperationException ExecuteNonQuery failed for Database 'XADEMES01DB_Site'. at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType) at Citrix.Orchestration.Base.PowerShellSdk.DatabaseService.Scripts.UpdateDatabaseScript.DoImpersonatedWork() Inner Exception: StackTrace: Microsoft.SqlServer.Management.Common.ExecutionFailureException An exception occurred while executing a Transact-SQL statement or batch. at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType) at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType) Inner Exception: HelpLink.ProdName : Microsoft SQL Server HelpLink.ProdVer : 12.00.6024 HelpLink.EvtSrc : MSSQLServer HelpLink.EvtID : 50000 HelpLink.BaseHelpUrl : http://go.microsoft.com/fwlink HelpLink.LinkId : 20476 StackTrace: System.Data.SqlClient.SqlException StartUpdate: Update requires all services to be stopped. The Citrix Machine Creation Service needs to be stopped. at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException) at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
Customer hasn't change database permissions.

• Restart affected Delivery Controller servers
• Stop all Citrix services using the following PowerShell command.

• Delete the directory  *C:\ProgramData\Citrix *
• Launch installation again from* \x64\XenDesktop Setup\XenDesktopServerSetup.exe*

Problem Cause

Corrupted CVAD installation due to running of ISO from a network share resulting in upgrade error

Error Id: XDDS:FA5F002A

StackTrace: System.Data.SqlClient.SqlException StartUpdate: Update requires all services to be stopped. The Citrix Machine Creation Service needs to be stopped.

at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)