Jump to content
Welcome to our new Citrix community!
  • 0

Migrate XenDesktop Database to New SQL Server failed


ding tong

Question

hello,

I'm trying to migrate the xendesktop database to a new sql server according to the steps in https://support.citrix.com/article/CTX140319,  I have completed all operations in one of the DDCS and have not reported an error , But when I restart Citrix studio,  It shows the error. 

Error Id: XDDS:2BA6839E

error:
    Citrix.Console.Models.Exceptions.ScriptException  No services can be found to run 
       ??? Citrix.Console.PowerShellSdk.HealthMonitor.Scripts.GetHealthyServiceInstanceScript.RunScript()
       ??? Citrix.Console.PowerShellInteraction.PowerShellScript`1.Run()
       ??? Citrix.Console.PowerShellSdk.HealthMonitor.Scripts.ReloadServiceInstancesScript.CheckServiceInstanceStatuses(IEnumerable`1 refreshedServices)
       ??? Citrix.Console.PowerShellSdk.HealthMonitor.Scripts.ReloadServiceInstancesScript.CheckForWorkingServiceSet()
       ??? Citrix.Console.PowerShellSdk.HealthMonitor.Scripts.ReloadServiceInstancesScript.RunScript()
       ??? Citrix.Console.PowerShellInteraction.PowerShellScript`1.Run()
       ??? Citrix.Console.PowerShellSdk.SiteService.Scripts.LoaderScript.InitializeSite(IProgressReporter loadServicesProgress)
       ??? Citrix.Console.PowerShellSdk.SiteService.Scripts.LoaderScript.RunScript()
       ??? Citrix.Console.PowerShellInteraction.PowerShellScript`1.Run()
       ??? Citrix.Console.PowerShellSdk.SiteService.PSSiteService.LoadSiteState(IProgressReporter progressReporter)
       ??? Citrix.Console.DeliveryCenter.UI.ViewModel.DesktopStudioViewModel.LoadSiteState(IProgressReporter progressReporter)
       ??? Citrix.Console.DeliveryCenter.UI.ViewModel.DesktopStudioViewModel.ConnectToSite(String ccsLocation, Boolean safeForDispatcher, IProgressReporter progressReporter)
       ??? Citrix.Console.MmcSnapin.SnapInClass.OnLoadCustomSnapinData(AsyncStatus status, Byte[] persistenceData)
    
    DesktopStudio_ErrorId : UnknownError
    ErrorCategory : NotSpecified
    DesktopStudio_PowerShellHistory : LoaderScript
    2020/4/5 15:32:32
    
    Get-ConfigServiceStatus  -AdminAddress "localhost"
    Get-ConfigServiceStatus  -AdminAddress "localhost"
    Set-Variable  -Name "sidsToExclude" -Value @()
    Get-ConfigRegisteredServiceInstance  -AdminAddress "localhost" -Filter {(((ServiceType -eq 'Config') -and (Version -eq 2))) -and ((InterfaceType -eq 'SDK') -and (-not (ServiceAccountSid -in $sidsToExclude)))} -MaxRecordCount 2147483647
    Remove-Variable  -Name "sidsToExclude"
    Set-Variable  -Name "sidsToExclude" -Value @()
    Get-ConfigRegisteredServiceInstance -AdminAddress "localhost" -Filter {(((ServiceType -eq 'Config') -and (Version -eq 2)) -or ((ServiceType -eq 'Admin') -and (Version -eq 1)) -or ((ServiceType -eq 'Log') -and (Version -eq 1)) -or ((ServiceType -eq 'Acct') -and (Version -eq 2)) -or ((ServiceType -eq 'Hyp') -and (Version -eq 2)) -or ((ServiceType -eq 'Prov') -and (Version -eq 2)) -or ((ServiceType -eq 'Broker') -and (Version -eq 2)) -or ((ServiceType -eq 'Monitor') -and (Version -eq 1)) -or ((ServiceType -eq 'Sf') -and (Version -eq 1)) -or ((ServiceType -eq 'EnvTest') -and (Version -eq 1)) -or ((ServiceType -eq 'Analytics') -and (Version -eq 1))) -and ((InterfaceType -eq 'SDK') -and (-not (ServiceAccountSid -in $sidsToExclude)))} -MaxRecordCount 2147483647 | Test-ConfigServiceInstanceAvailability -AdminAddress "localhost" -MaxDelaySeconds 5
    Remove-Variable  -Name "sidsToExclude"
    Get-AcctServiceStatus  -AdminAddress "ddc02.test.cn:80"
    Get-AcctServiceStatus  -AdminAddress "ddc01.test.cn:80"
    Get-ConfigServiceStatus  -AdminAddress "ddc02.test.cn:80"
    Get-ConfigServiceStatus  -AdminAddress "ddc01.test.cn:80"
    Get-BrokerServiceStatus  -AdminAddress "ddc02.test.cn:80"
    Get-BrokerServiceStatus  -AdminAddress "ddc01.test.cn:80"
    Get-MonitorServiceStatus  -AdminAddress "ddc02.test.cn:80"
    Get-MonitorServiceStatus  -AdminAddress "ddc01.test.cn:80"
    
    

Link to comment

6 answers to this question

Recommended Posts

  • 0

Greeting,

not to open a new topic ....

We have a Citrix 7.15 farm and we did a database migration to the new SQL according to this article:

https://www.meijlink.nl/migrate-xendesktop-database/

Everything went well but there are still some connections that create a problem...

konekcije.thumb.jpg.48280901a7b0b43766264c5c66859780.jpg

 

Everything works but these connections I attached are still used from the old SQL

We tried to turn them off but then in the studio console we get the message: Mandatory update (and we stuck in the loop)

When we get those connections back, everything works.

 

Nowhere do I find the powershell commands (in the article) that solve this problem.

Does anyone have an idea?

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...