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

DB Oddity


Jim McKelvie1709159887

Question

I have a strange issue with Citrix virtual apps. 

The Citrix site is configured to use a single Database on a standalone SQL server containing Site, Monitoring and Logging as below, also confirmed using the PS commands.

 

As part of another project the SQL engineer has been asked to migrate some other DB's from the same SQL server to a new one.

He took a DB called 'Xen' offline, and this is where we discovered it breaks the Citrix Site. Say for example if a Delivery group was edited it throws and error. (error below)

 

Any ideas? thankyou.

image.thumb.png.934c9ecd6a30fe3ad54dc96c29fa336b.png

 

The error.....

 

Error Id: XDDS:17027C06

Exception:
    Citrix.Console.Models.Exceptions.DatabaseConnectionException Database could not be contacted.
       at Citrix.Console.PowerShellInteraction.CmdletExecutionMethods.CreateException[T](ICommonLog logger, ExecutionResults`1 results, ICmdletExecutionHost host)
       at Citrix.Console.PowerShellInteraction.CmdletExecutionMethods.Execute[T](ISdkCmdlet`1 sdkCmd, ICmdletExecutionHost host, Boolean allowFailover)
       at Citrix.Console.PowerShellSdk.DesktopGroupService.Scripts.EditDesktopGroupScript.UpdateAccessPolicies()
       at Citrix.Console.PowerShellSdk.DesktopGroupService.Scripts.EditDesktopGroupScript.RunScript()
       at Citrix.Console.PowerShellInteraction.PowerShellScript`1.Run()
       at Citrix.Console.DesktopGroups.UI.Dialogs.DesktopPropertiesViewModel.Commit(IProgressReporter progressReporter)
       at Citrix.Console.CommonControls.Wizard.PageContainerViewModel.<CreateCommitProgressViewModelInternal>b__21_1(IProgressReporter progressReporter)
       at Citrix.Console.CommonControls.Wizard.CommitProgressViewModel.PerformOperationInternal()
    
    DesktopStudio_ErrorId : DataStoreException
    SqlErrorText : UpsertAccessPolicyRule: Database 'XEN' cannot be opened because it is offline.
    SqlErrorNumber : 942
    ConnectionString : Data Source=mssqlcluster.ad.lancscc.net;Initial Catalog=CTRX_MAN_CitrixSite1;Integrated Security=True;Application Name=Citrix:Broker#1
    DataSource : mssqlcluster.ad.lancscc.net
    Sdk Error Message : Problem occurred contacting the database
    Sdk Error ID : Citrix.XDPowerShell.Broker.DataStoreException,Citrix.Broker.Admin.SDK.SetBrokerAccessPolicyRuleCommand
    ErrorCategory : ResourceUnavailable
    DesktopStudio_PowerShellHistory : Edit Delivery Group 'CORP RACD TEST 2016'
    27/11/2019 15:40:28
    
    Get-LogSite  -AdminAddress "ctrx-prd-ddc01.manage.connect2ict.net:80"
    Start-LogHighLevelOperation  -AdminAddress "ctrx-prd-ddc01.manage.connect2ict.net:80" -Source "Studio" -StartTime "27/11/2019 15:40:21" -Text "Edit Delivery Group `'CORP RACD TEST 2016`'"
    Set-Variable  -Name "brokerUsers" -Value @("S-1-5-21-3073725641-1204123029-569601206-110610","S-1-5-21-3073725641-1204123029-569601206-1116","S-1-5-21-3073725641-1204123029-569601206-154881","S-1-5-21-3073725641-1204123029-569601206-34641")
    Get-BrokerUser  -AdminAddress "ctrx-prd-ddc01.manage.connect2ict.net:80" -Filter {(SID -in $brokerUsers)} -MaxRecordCount 2147483647
    Remove-Variable  -Name "brokerUsers"
    Set-BrokerAccessPolicyRule  -AdminAddress "ctrx-prd-ddc01.manage.connect2ict.net:80" -IncludedSmartAccessFilterEnabled $True -IncludedUsers @("AD\bashworth001","AD\ICTBA","AD\ictil","AD\ilangley001") -LoggingId "4da64534-a322-4d5d-b346-923f297ff864" -Name "RACD TEST 2016_Direct"
    Set-BrokerAccessPolicyRule : Problem occurred contacting the database
        + CategoryInfo : InvalidOperation: (:) [Set-BrokerAccessPolicyRule], SdkOperationException
        + FullyQualifiedErrorId : Citrix.XDPowerShell.Broker.DataStoreException,Citrix.Broker.Admin.SDK.SetBrokerAccessPolicyRuleCommand
    Stop-LogHighLevelOperation  -AdminAddress "ctrx-prd-ddc01.manage.connect2ict.net:80" -EndTime "27/11/2019 15:40:28" -HighLevelOperationId "4da64534-a322-4d5d-b346-923f297ff864" -IsSuccessful $False
    
    
Inner Exception:
    Citrix.Broker.Admin.SDK.SdkOperationException Problem occurred contacting the database
       at System.Management.Automation.MshCommandRuntime.ThrowTerminatingError(ErrorRecord errorRecord)
    
    
Inner Exception:
    System.InvalidOperationException Problem occurred contacting the database
    
    

 

 

 

I've asked the DB admin to compare the 2 databases, the Xen one contains a few tables.

 

Created 25/11/2016 13:10:51

 

DB.png.d2940cb1f08ae39582b0af4e69294cd4.png

 

 

 

Ctrx__Man_CitrixSite1 was created 25/11/2016 14:29:51 but has a very different structure (main Site, logging and monitoring DB for the Citrix site)

 

The XA6.5 migration scripts were used to migrate the config to 7.x back in 2016 which I thought only utilised a structured file (xml)


 

Link to comment

0 answers to this question

Recommended Posts

There have been no answers to this question yet

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...