asked on

upgrade from xendesktop 7.5 to 7.6 db script error

here is my error log. My environment tests fine. everything goes well and them I get the following error. Not much of answer at citrix site. I see a couple of people had this error but not resolve. so I am trying to see if anyone canhelp now. Thanks in advance

Error Id: XDDS:DA11D207

Exception:
Citrix.Console.Models.Exceptions.ScriptException Failed to upload database scripts
at Citrix.Console.PowerShellSdk.UpgradeService.UpgradeTasks.DatabaseUpgradeTask.UpgradeDatabases(IList`1 scripts, IProgressReporter applyDbScriptProgress, ITaskLogger taskLogger)
at Citrix.Console.PowerShellSdk.UpgradeService.UpgradeTasks.DatabaseUpgradeTask.DoImpersonatedWork(Action work)
at Citrix.Console.PowerShellSdk.UpgradeService.UpgradeTasks.DatabaseUpgradeTask.RunUpgradeTask(IProgressReporter progressReporter, ITaskLogger taskLogger)
at Citrix.Console.PowerShellSdk.UpgradeService.UpgradeTasks.UpgradeTaskBase.RunUpgrade(IProgressReporter progressReporter, ITaskLogger taskLogger)
at Citrix.Console.PowerShellSdk.UpgradeService.UpgradeTasks.ServiceUpgradeTask.RunUpgradeTask(IProgressReporter progressReporter, ITaskLogger taskLogger)
at Citrix.Console.PowerShellSdk.UpgradeService.UpgradeTasks.UpgradeTaskBase.RunUpgrade(IProgressReporter progressReporter, ITaskLogger taskLogger)
at Citrix.Console.PowerShellSdk.UpgradeService.UpgradeTasks.Upgrade.RunUpgradeTask(IProgressReporter progressReporter, ITaskLogger taskLogger)
at Citrix.Console.PowerShellSdk.UpgradeService.UpgradeTasks.UpgradeTaskBase.RunUpgrade(IProgressReporter progressReporter, ITaskLogger taskLogger)
at Citrix.Console.DeliveryCenter.UI.Mmc.UpgradeResultPaneViewModel.UpgradeTask(IProgressReporter progressReporter, UserCredentials databaseCredentials)
at Citrix.Console.CommonControls.ProgressDisplay.GenericProgressOperationWithFeedBack.PerformOperationInternal()
at Citrix.Console.CommonControls.ProgressDisplay.ProgressWindowOperation.PerformOperation()
at Citrix.Console.CommonControls.ProgressDisplay.ProgressWindowViewModel.PerformAction(Action operationComplete)

DesktopStudio_ErrorId : UnknownError
ErrorCategory : NotSpecified

Inner Exception:
Microsoft.SqlServer.Management.Smo.FailedOperationException ExecuteNonQuery failed for Database 'Citrix-Citrix7'.
at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
at Citrix.Console.PowerShellSdk.UpgradeService.UpgradeTasks.DatabaseUpgradeTask.ApplySqlUpdate(String script, DataStoreModel appliesTo)
at Citrix.Console.PowerShellSdk.UpgradeService.UpgradeTasks.DatabaseUpgradeTask.UpgradeDatabases(IList`1 scripts, IProgressReporter applyDbScriptProgress, ITaskLogger taskLogger)

HelpLink.ProdName : Microsoft SQL Server
HelpLink.BaseHelpUrl : http://go.microsoft.com/fwlink
HelpLink.LinkId : 20476
HelpLink.ProdVer : 11.0.3000.0 ((SQL11_PCU_Main).121019-1322 )
HelpLink.EvtSrc : Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText
HelpLink.EvtData1 : ExecuteNonQuery
HelpLink.EvtData2 : Database

Inner Exception:
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.ExecutionManager.ExecuteNonQuery(StringCollection queries, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)

Inner Exception:
System.Data.SqlClient.SqlException StartUpdate: Update requires all services to be stopped. The Citrix Monitor 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)

HelpLink.ProdName : Microsoft SQL Server
HelpLink.ProdVer : 10.50.1600
HelpLink.EvtSrc : MSSQLServer
HelpLink.EvtID : 50000
HelpLink.BaseHelpUrl : http://go.microsoft.com/fwlink
HelpLink.LinkId : 20476

ASKER CERTIFIED SOLUTION

Carl Webster

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Ron Simpson

ASKER

I am using the same account to manage xen and sql. ( admin account),Don't know why its failing if its the same account. The system works fine otherwise. Wondering if just reinstalling with 7.6 is a better option then upgrading but would like to figure out why this is happening

Carl Webster

Does the account have full sql admin rights and not just dbo rights?

Ron Simpson

ASKER

it has sysadmin rights same as sa. But there are the 2 controllers machine accounts as user of the db. im thinking it is the machine account trying to upload scripts or would it be the admin account I am using in studio

Ron Simpson

ASKER

Got it solved. Yes Sql rights was it. Thanks very much Carl

Ron Simpson

ASKER

Had to give my admin the sql service accounts Sql server and sql agent

Ron Simpson

ASKER

Pointed me in the right direction