elthamcollege
asked on
Upgrading 7.1 to 7.5 XenDesktop fails when running the database upgrade script
Hi,
We are upgrading our XenDesktop environment from 7.1 to 7.6. Following the recommended steps when we ran the database upgrade script after launching Studio for the first time the DB upgrade appeared to complete OK but failed at the end with the following:
Error Id: XDDS:DA11D207
Exception:
Citrix.Console.Models.Exce ptions.Scr iptExcepti on Failed to upload database scripts
at Citrix.Console.PowerShellS dk.Upgrade Service.Up gradeTasks .DatabaseU pgradeTask .UpgradeDa tabases(IL ist`1 scripts, IProgressReporter applyDbScriptProgress, ITaskLogger taskLogger)
at Citrix.Console.PowerShellS dk.Upgrade Service.Up gradeTasks .DatabaseU pgradeTask .DoImperso natedWork( Action work)
at Citrix.Console.PowerShellS dk.Upgrade Service.Up gradeTasks .DatabaseU pgradeTask .RunUpgrad eTask(IPro gressRepor ter progressReporter, ITaskLogger taskLogger)
at Citrix.Console.PowerShellS dk.Upgrade Service.Up gradeTasks .UpgradeTa skBase.Run Upgrade(IP rogressRep orter progressReporter, ITaskLogger taskLogger)
at Citrix.Console.PowerShellS dk.Upgrade Service.Up gradeTasks .ServiceUp gradeTask. RunUpgrade Task(IProg ressReport er progressReporter, ITaskLogger taskLogger)
at Citrix.Console.PowerShellS dk.Upgrade Service.Up gradeTasks .UpgradeTa skBase.Run Upgrade(IP rogressRep orter progressReporter, ITaskLogger taskLogger)
at Citrix.Console.PowerShellS dk.Upgrade Service.Up gradeTasks .Upgrade.R unUpgradeT ask(IProgr essReporte r progressReporter, ITaskLogger taskLogger)
at Citrix.Console.PowerShellS dk.Upgrade Service.Up gradeTasks .UpgradeTa skBase.Run Upgrade(IP rogressRep orter progressReporter, ITaskLogger taskLogger)
at Citrix.Console.DeliveryCen ter.UI.Mmc .UpgradeRe sultPaneVi ewModel.Up gradeTask( IProgressR eporter progressReporter, UserCredentials databaseCredentials)
at Citrix.Console.CommonContr ols.Progre ssDisplay. GenericPro gressOpera tionWithFe edBack.Per formOperat ionInterna l()
at Citrix.Console.CommonContr ols.Progre ssDisplay. ProgressWi ndowOperat ion.Perfor mOperation ()
at Citrix.Console.CommonContr ols.Progre ssDisplay. ProgressWi ndowViewMo del.Perfor mAction(Ac tion operationComplete)
DesktopStudio_ErrorId : UnknownError
ErrorCategory : NotSpecified
Inner Exception:
Microsoft.SqlServer.Manage ment.Smo.F ailedOpera tionExcept ion ExecuteNonQuery failed for Database 'CitrixXenDesktopDB'.
at Microsoft.SqlServer.Manage ment.Smo.D atabase.Ex ecuteNonQu ery(String Collection sqlCommands, ExecutionTypes executionType)
at Citrix.Console.PowerShellS dk.Upgrade Service.Up gradeTasks .DatabaseU pgradeTask .ApplySqlU pdate(Stri ng script, DataStoreModel appliesTo)
at Citrix.Console.PowerShellS dk.Upgrade Service.Up gradeTasks .DatabaseU pgradeTask .UpgradeDa tabases(IL ist`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-1 322 )
HelpLink.EvtSrc : Microsoft.SqlServer.Manage ment.Smo.E xceptionTe mplates.Fa iledOperat ionExcepti onText
HelpLink.EvtData1 : ExecuteNonQuery
HelpLink.EvtData2 : Database
Inner Exception:
Microsoft.SqlServer.Manage ment.Commo n.Executio nFailureEx ception An exception occurred while executing a Transact-SQL statement or batch.
at Microsoft.SqlServer.Manage ment.Commo n.ServerCo nnection.E xecuteNonQ uery(Strin g sqlCommand, ExecutionTypes executionType)
at Microsoft.SqlServer.Manage ment.Commo n.ServerCo nnection.E xecuteNonQ uery(Strin gCollectio n sqlCommands, ExecutionTypes executionType)
at Microsoft.SqlServer.Manage ment.Smo.E xecutionMa nager.Exec uteNonQuer y(StringCo llection queries, ExecutionTypes executionType)
at Microsoft.SqlServer.Manage ment.Smo.D atabase.Ex ecuteNonQu ery(String Collection sqlCommands, ExecutionTypes executionType)
Inner Exception:
System.Data.SqlClient.SqlE xception There is already an object named 'EnvTestServiceSchema' in the database.
CREATE SCHEMA failed due to previous errors.
at Microsoft.SqlServer.Manage ment.Commo n.Connecti onManager. ExecuteTSq l(ExecuteT SqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Manage ment.Commo n.ServerCo nnection.E xecuteNonQ uery(Strin g sqlCommand, ExecutionTypes executionType)
HelpLink.ProdName : Microsoft SQL Server
HelpLink.ProdVer : 10.50.4000
HelpLink.EvtSrc : MSSQLServer
HelpLink.EvtID : 2714
HelpLink.BaseHelpUrl : http://go.microsoft.com/fwlink
HelpLink.LinkId : 20476
We've tried this thread but does not seem to work - http://discussions.citrix.com/topic/356640-site-upgrade-xendesktop-75-to-76-error-id-xddsc266bbdf/
I've googled for a few hours but don't seem to be getting anywhere.
Advice and suggestion welcomed.
Thanks
Damien
We are upgrading our XenDesktop environment from 7.1 to 7.6. Following the recommended steps when we ran the database upgrade script after launching Studio for the first time the DB upgrade appeared to complete OK but failed at the end with the following:
Error Id: XDDS:DA11D207
Exception:
Citrix.Console.Models.Exce
at Citrix.Console.PowerShellS
at Citrix.Console.PowerShellS
at Citrix.Console.PowerShellS
at Citrix.Console.PowerShellS
at Citrix.Console.PowerShellS
at Citrix.Console.PowerShellS
at Citrix.Console.PowerShellS
at Citrix.Console.PowerShellS
at Citrix.Console.DeliveryCen
at Citrix.Console.CommonContr
at Citrix.Console.CommonContr
at Citrix.Console.CommonContr
DesktopStudio_ErrorId : UnknownError
ErrorCategory : NotSpecified
Inner Exception:
Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Citrix.Console.PowerShellS
at Citrix.Console.PowerShellS
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-1
HelpLink.EvtSrc : Microsoft.SqlServer.Manage
HelpLink.EvtData1 : ExecuteNonQuery
HelpLink.EvtData2 : Database
Inner Exception:
Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
Inner Exception:
System.Data.SqlClient.SqlE
CREATE SCHEMA failed due to previous errors.
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
HelpLink.ProdName : Microsoft SQL Server
HelpLink.ProdVer : 10.50.4000
HelpLink.EvtSrc : MSSQLServer
HelpLink.EvtID : 2714
HelpLink.BaseHelpUrl : http://go.microsoft.com/fwlink
HelpLink.LinkId : 20476
We've tried this thread but does not seem to work - http://discussions.citrix.com/topic/356640-site-upgrade-xendesktop-75-to-76-error-id-xddsc266bbdf/
I've googled for a few hours but don't seem to be getting anywhere.
Advice and suggestion welcomed.
Thanks
Damien
This problem is easy to solve in SQL Server (connect to the database and delete the schema 'EnvTestServiceSchema') but I don't know what is the impact in the XenDesktop.
Does your database name have any spaces?
Do you have separate databases for Site, Config Logging and Monitoring or are they still in the default config of all 3 databases combined?
Do you have separate databases for Site, Config Logging and Monitoring or are they still in the default config of all 3 databases combined?
ASKER
Hi,
thanks for the replies.
No spaces in database and yes it is still the default config of all 3 databases combined.
Thanks
Damien
thanks for the replies.
No spaces in database and yes it is still the default config of all 3 databases combined.
Thanks
Damien
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your input.
The only issue I have seen with upgrading a default database where all 3 DBs are still in the 1 default DB is where a space is in the DB name. The monitoring DB will not work if it has a space in the name because the API that Director uses to read the monitoring DB crashes if there is a space in the DB name.
I have the same issue did you get a resolution on this?.