Jump to content
  • 0

found some problem about creating Citrix Site and Citrix Databases as failed.

Artimus Aunos

Asked by Artimus Aunos,

Question

Artimus Aunos Collaborator

Artimus Aunos

Posted
Posted

Hello

I found some problem about creating Citrix Site and Citrix Databases as failed.  For logs at below.

Have anyone found this problem issue?  How can I solve this?   

for my environment:

controller 2203 CU3 with SQL express

I have tested to use both same sql express on Controller or existing SQL that's same problem

I seem that's problem about contacting the database. I don't know how to check and verify?

I have used installation account and assigned it to sql admin and local administrator of Servers (Controllers and SQL Server), same but found problem.

 

--------------------------

Error Id: XDDS:783F237D

Exception:
    DesktopStudio_ErrorId : DataStoreException
    SqlErrorText : 
    SqlErrorNumber : 0
    ConnectionString : 
    DataSource : 
    Error Source : CitrixBrokerService
    Sdk Error Message : Problem occurred contacting the database
    Sdk Error ID : Citrix.XDPowerShell.Broker.DataStoreException,Citrix.Broker.Admin.SDK.ResetBrokerEnabledFeatureListCommand
    ErrorCategory : ResourceUnavailable
    DesktopStudio_PowerShellHistory : Full Desktop Deployment
    25/8/2566 18:14:21
    
    Get-AcctDBSchema  -AdminAddress "APC01.COTH" -BearerToken ******** -DatabaseName "ctx-site" -LocalDatabase -ScriptType "FullDatabase" -ServiceGroupName "AAAGI"
    Get-HypDBSchema  -AdminAddress "APC01.COTH" -BearerToken ******** -DatabaseName "ctx-site" -LocalDatabase -ScriptType "FullDatabase" -ServiceGroupName "AAAGI"
    Get-AppLibDBSchema  -AdminAddress "APC01.COTH" -BearerToken ******** -DatabaseName "ctx-site" -LocalDatabase -ScriptType "FullDatabase" -ServiceGroupName "AAAGI"
    Get-ProvDBSchema  -AdminAddress "APC01.COTH" -BearerToken ******** -DatabaseName "ctx-site" -LocalDatabase -ScriptType "FullDatabase" -ServiceGroupName "AAAGI"
    Get-BrokerDBSchema  -AdminAddress "APC01.COTH" -BearerToken ******** -DatabaseName "ctx-site" -LocalDatabase -ScriptType "FullDatabase" -ServiceGroupName "AAAGI"
    Get-MonitorDBSchema  -AdminAddress "APC01.COTH" -BearerToken ******** -DatabaseName "ctx-site" -DataStore "Site" -LocalDatabase -ScriptType "FullDatabase" -ServiceGroupName "AAAGI"
    Get-SfDBSchema  -AdminAddress "APC01.COTH" -BearerToken ******** -DatabaseName "ctx-site" -LocalDatabase -ScriptType "FullDatabase" -ServiceGroupName "AAAGI"
    Get-TrustDBSchema  -AdminAddress "APC01.COTH" -BearerToken ******** -DatabaseName "ctx-site" -LocalDatabase -ScriptType "FullDatabase" -ServiceGroupName "AAAGI"
    Get-EnvTestDBSchema  -AdminAddress "APC01.COTH" -BearerToken ******** -DatabaseName "ctx-site" -LocalDatabase -ScriptType "FullDatabase" -ServiceGroupName "AAAGI"
    Get-AnalyticsDBSchema  -AdminAddress "APC01.COTH" -BearerToken ******** -DatabaseName "ctx-site" -LocalDatabase -ScriptType "FullDatabase" -ServiceGroupName "AAAGI"
    Get-OrchDBSchema  -AdminAddress "APC01.COTH" -BearerToken ******** -DatabaseName "ctx-site" -LocalDatabase -ScriptType "FullDatabase" -ServiceGroupName "AAAGI"
    Get-ConfigDBSchema  -AdminAddress "APC01.COTH" -BearerToken ******** -DatabaseName "ctx-site" -LocalDatabase -ScriptType "FullDatabase" -ServiceGroupName "AAAGI"
    Get-LogDBSchema  -AdminAddress "APC01.COTH" -BearerToken ******** -DatabaseName "ctx-site" -DataStore "Site" -LocalDatabase -ScriptType "FullDatabase" -ServiceGroupName "AAAGI"
    Get-AdminDBSchema  -AdminAddress "APC01.COTH" -BearerToken ******** -DatabaseName "ctx-site" -LocalDatabase -ScriptType "FullDatabase" -ServiceGroupName "AAAGI"
    Get-LogDBSchema  -AdminAddress "APC01.COTH" -BearerToken ******** -DatabaseName "ctx-log" -DataStore "Logging" -LocalDatabase -ScriptType "FullDatabase" -ServiceGroupName "AAAGI"
    Get-MonitorDBSchema  -AdminAddress "APC01.COTH" -BearerToken ******** -DatabaseName "ctx-monitor" -DataStore "Monitor" -LocalDatabase -ScriptType "FullDatabase" -ServiceGroupName "AAAGI"
    Get-AcctDBConnection  -AdminAddress "localhost" -BearerToken ********
    Get-AcctServiceStatus  -AdminAddress "localhost" -BearerToken ********
    Set-AcctDBConnection  -AdminAddress "localhost" -BearerToken ******** -DBConnection ********
    Get-HypDBConnection  -AdminAddress "localhost" -BearerToken ********
    Get-HypServiceStatus  -AdminAddress "localhost" -BearerToken ********
    Set-HypDBConnection  -AdminAddress "localhost" -BearerToken ******** -DBConnection ********
    Get-AppLibDBConnection  -AdminAddress "localhost" -BearerToken ********
    Get-AppLibServiceStatus  -AdminAddress "localhost" -BearerToken ********
    Set-AppLibDBConnection  -AdminAddress "localhost" -BearerToken ******** -DBConnection ********
    Get-ProvDBConnection  -AdminAddress "localhost" -BearerToken ********
    Get-ProvServiceStatus  -AdminAddress "localhost" -BearerToken ********
    Set-ProvDBConnection  -AdminAddress "localhost" -BearerToken ******** -DBConnection ********
    Get-BrokerDBConnection  -AdminAddress "localhost" -BearerToken ********
    Get-BrokerServiceStatus  -AdminAddress "localhost" -BearerToken ********
    Set-BrokerDBConnection  -AdminAddress "localhost" -BearerToken ******** -DBConnection ********
    Get-MonitorDBConnection  -AdminAddress "localhost" -BearerToken ******** -DataStore "Site"
    Get-MonitorServiceStatus  -AdminAddress "localhost" -BearerToken ********
    Set-MonitorDBConnection  -AdminAddress "localhost" -BearerToken ******** -DataStore "Site" -DBConnection ********
    Get-SfDBConnection  -AdminAddress "localhost" -BearerToken ********
    Get-SfServiceStatus  -AdminAddress "localhost" -BearerToken ********
    Set-SfDBConnection  -AdminAddress "localhost" -BearerToken ******** -DBConnection ********
    Get-TrustDBConnection  -AdminAddress "localhost" -BearerToken ********
    Get-TrustServiceStatus  -AdminAddress "localhost" -BearerToken ********
    Set-TrustDBConnection  -AdminAddress "localhost" -BearerToken ******** -DBConnection ********
    Get-EnvTestDBConnection  -AdminAddress "localhost" -BearerToken ********
    Get-EnvTestServiceStatus  -AdminAddress "localhost" -BearerToken ********
    Set-EnvTestDBConnection  -AdminAddress "localhost" -BearerToken ******** -DBConnection ********
    Get-AnalyticsDBConnection  -AdminAddress "localhost" -BearerToken ********
    Get-AnalyticsServiceStatus  -AdminAddress "localhost" -BearerToken ********
    Set-AnalyticsDBConnection  -AdminAddress "localhost" -BearerToken ******** -DBConnection ********
    Get-OrchDBConnection  -AdminAddress "localhost" -BearerToken ********
    Get-OrchServiceStatus  -AdminAddress "localhost" -BearerToken ********
    Set-OrchDBConnection  -AdminAddress "localhost" -BearerToken ******** -DBConnection "Server=NTPVMATCTX04\SQLExpress;Initial Catalog=ctx-site;Integrated Security=True"
    Get-ConfigDBConnection  -AdminAddress "localhost" -BearerToken ********
    Get-ConfigServiceStatus  -AdminAddress "localhost" -BearerToken ********
    Set-ConfigDBConnection  -AdminAddress "localhost" -BearerToken ******** -DBConnection ********
    Get-LogDBConnection  -AdminAddress "localhost" -BearerToken ******** -DataStore "Site"
    Get-LogServiceStatus  -AdminAddress "localhost" -BearerToken ********
    Set-LogDBConnection  -AdminAddress "localhost" -BearerToken ******** -DataStore "Site" -DBConnection ********
    Get-AdminDBConnection  -AdminAddress "localhost" -BearerToken ********
    Get-AdminServiceStatus  -AdminAddress "localhost" -BearerToken ********
    Set-AdminDBConnection  -AdminAddress "localhost" -BearerToken ******** -DBConnection ********
    Get-ConfigRegisteredServiceInstance -AdminAddress "localhost" -BearerToken ******** -MaxRecordCount 2147483647 | Unregister-ConfigRegisteredServiceInstance -AdminAddress "localhost" -BearerToken ********
    Import-AdminRoleConfiguration  -AdminAddress "localhost" -BearerToken ******** -Path "C:\Program Files\Citrix\XenDesktopPoshSdk\Module\Citrix.XenDesktop.Admin.V1\Citrix.XenDesktop.Admin\StudioRoleConfig\RoleConfigSigned.xml"
    Import-AdminRoleConfiguration  -AdminAddress "localhost" -BearerToken ******** -Path "C:\Program Files\Citrix\XenDesktopPoshSdk\Module\Citrix.XenDesktop.Admin.V1\Citrix.XenDesktop.Admin\StudioRoleConfig\DirectorRoleConfigSigned.xml"
    Get-ConfigServiceInstance -AdminAddress "localhost" -BearerToken ******** | Register-ConfigServiceInstance -AdminAddress "localhost" -BearerToken ********
    Get-AdminServiceInstance -AdminAddress "localhost" -BearerToken ******** | Register-ConfigServiceInstance -AdminAddress "localhost" -BearerToken ********
    Get-LogServiceInstance -AdminAddress "localhost" -BearerToken ******** | Register-ConfigServiceInstance -AdminAddress "localhost" -BearerToken ********
    Get-ConfigRegisteredServiceInstance -AdminAddress "localhost" -BearerToken ******** -MaxRecordCount 2147483647 -ServiceType "Config" | Reset-ConfigServiceGroupMembership -AdminAddress "localhost" -BearerToken ********
    Get-ConfigRegisteredServiceInstance -AdminAddress "localhost" -BearerToken ******** -MaxRecordCount 2147483647 -ServiceType "Config" | Reset-AdminServiceGroupMembership -AdminAddress "localhost" -BearerToken ********
    Get-ConfigRegisteredServiceInstance -AdminAddress "localhost" -BearerToken ******** -MaxRecordCount 2147483647 -ServiceType "Config" | Reset-LogServiceGroupMembership -AdminAddress "localhost" -BearerToken ********
    Import-ConfigFeatureTable  -AdminAddress "localhost" -BearerToken ******** -Path "C:\Program Files\Citrix\XenDesktopPoshSdk\Module\Citrix.XenDesktop.Admin.V1\Citrix.XenDesktop.Admin\FeatureTable.xml"
    Set-ConfigSite  -AdminAddress "localhost" -BearerToken ******** -SiteName "AAAGI"
    Get-ConfigServiceStatus  -AdminAddress "localhost" -BearerToken ********
    Get-ConfigServiceStatus  -AdminAddress "APC01.COTH" -BearerToken ********
    Get-LicLocation  -AddressType "WSL" -LicenseServerAddress "ntpvmatctx06" -LicenseServerPort 27000
    Set-ConfigSite  -AdminAddress "localhost" -BearerToken ******** -LicenseServerName "ntpvmatctx06" -LicenseServerPort 27000 -LicenseServerUri "https://ntpvmatctx06:8083/" -LicensingModel "Concurrent" -ProductCode "MPS" -ProductEdition "ENT" -ProductVersion "7.33"
    Get-AcctServiceInstance -AdminAddress "localhost" -BearerToken ******** | Register-ConfigServiceInstance -AdminAddress "localhost" -BearerToken ********
    Get-HypServiceInstance -AdminAddress "localhost" -BearerToken ******** | Register-ConfigServiceInstance -AdminAddress "localhost" -BearerToken ********
    Get-AppLibServiceInstance -AdminAddress "localhost" -BearerToken ******** | Register-ConfigServiceInstance -AdminAddress "localhost" -BearerToken ********
    Get-ProvServiceInstance -AdminAddress "localhost" -BearerToken ******** | Register-ConfigServiceInstance -AdminAddress "localhost" -BearerToken ********
    Get-BrokerServiceInstance -AdminAddress "localhost" -BearerToken ******** | Register-ConfigServiceInstance -AdminAddress "localhost" -BearerToken ********
    Get-MonitorServiceInstance -AdminAddress "localhost" -BearerToken ******** | Register-ConfigServiceInstance -AdminAddress "localhost" -BearerToken ********
    Get-SfServiceInstance -AdminAddress "localhost" -BearerToken ******** | Register-ConfigServiceInstance -AdminAddress "localhost" -BearerToken ********
    Get-TrustServiceInstance -AdminAddress "localhost" -BearerToken ******** | Register-ConfigServiceInstance -AdminAddress "localhost" -BearerToken ********
    Get-EnvTestServiceInstance -AdminAddress "localhost" -BearerToken ******** | Register-ConfigServiceInstance -AdminAddress "localhost" -BearerToken ********
    Get-AnalyticsServiceInstance -AdminAddress "localhost" -BearerToken ******** | Register-ConfigServiceInstance -AdminAddress "localhost" -BearerToken ********
    Get-OrchServiceInstance -AdminAddress "localhost" -BearerToken ******** | Register-ConfigServiceInstance -AdminAddress "localhost" -BearerToken ********
    Get-ConfigRegisteredServiceInstance -AdminAddress "localhost" -BearerToken ******** -MaxRecordCount 2147483647 -ServiceType "Config" | Reset-AcctServiceGroupMembership -AdminAddress "localhost" -BearerToken ********
    Get-ConfigRegisteredServiceInstance -AdminAddress "localhost" -BearerToken ******** -MaxRecordCount 2147483647 -ServiceType "Config" | Reset-HypServiceGroupMembership -AdminAddress "localhost" -BearerToken ********
    Get-ConfigRegisteredServiceInstance -AdminAddress "localhost" -BearerToken ******** -MaxRecordCount 2147483647 -ServiceType "Config" | Reset-AppLibServiceGroupMembership -AdminAddress "localhost" -BearerToken ********
    Get-ConfigRegisteredServiceInstance -AdminAddress "localhost" -BearerToken ******** -MaxRecordCount 2147483647 -ServiceType "Config" | Reset-ProvServiceGroupMembership -AdminAddress "localhost" -BearerToken ********
    Get-ConfigRegisteredServiceInstance -AdminAddress "localhost" -BearerToken ******** -MaxRecordCount 2147483647 -ServiceType "Config" | Reset-BrokerServiceGroupMembership -AdminAddress "localhost" -BearerToken ********
    Get-ConfigRegisteredServiceInstance -AdminAddress "localhost" -BearerToken ******** -MaxRecordCount 2147483647 -ServiceType "Config" | Reset-MonitorServiceGroupMembership -AdminAddress "localhost" -BearerToken ********
    Get-ConfigRegisteredServiceInstance -AdminAddress "localhost" -BearerToken ******** -MaxRecordCount 2147483647 -ServiceType "Config" | Reset-SfServiceGroupMembership -AdminAddress "localhost" -BearerToken ********
    Get-ConfigRegisteredServiceInstance -AdminAddress "localhost" -BearerToken ******** -MaxRecordCount 2147483647 -ServiceType "Config" | Reset-TrustServiceGroupMembership -AdminAddress "localhost" -BearerToken ********
    Get-ConfigRegisteredServiceInstance -AdminAddress "localhost" -BearerToken ******** -MaxRecordCount 2147483647 -ServiceType "Config" | Reset-EnvTestServiceGroupMembership -AdminAddress "localhost" -BearerToken ********
    Get-ConfigRegisteredServiceInstance -AdminAddress "localhost" -BearerToken ******** -MaxRecordCount 2147483647 -ServiceType "Config" | Reset-AnalyticsServiceGroupMembership -AdminAddress "localhost" -BearerToken ********
    Get-ConfigRegisteredServiceInstance -AdminAddress "localhost" -BearerToken ******** -MaxRecordCount 2147483647 -ServiceType "Config" | Reset-OrchServiceGroupMembership -AdminAddress "localhost" -BearerToken ********
    Get-LogDBConnection  -AdminAddress "localhost" -BearerToken ******** -DataStore "Logging"
    Get-LogServiceStatus  -AdminAddress "localhost" -BearerToken ********
    Set-LogDBConnection  -AdminAddress "localhost" -BearerToken ******** -DataStore "Logging" -DBConnection ********
    Get-MonitorDBConnection  -AdminAddress "localhost" -BearerToken ******** -DataStore "Monitor"
    Get-MonitorServiceStatus  -AdminAddress "localhost" -BearerToken ********
    Reset-BrokerEnabledFeatureList : Problem occurred contacting the database
        + CategoryInfo : InvalidOperation: (:) [Reset-BrokerEnabledFeatureList], SdkOperationException
        + FullyQualifiedErrorId : Citrix.XDPowerShell.Broker.DataStoreException,Citrix.Broker.Admin.SDK.ResetBrokerEnabledFeatureListCommand
    
    
    StackTrace: Citrix.Orchestration.Base.LogicModels.Exceptions.DatabaseConnectionException Database could not be contacted.
       at Citrix.Orchestration.Base.PowerShellInteraction.CmdletExecutionMethods.CreateException[T](ICommonLog logger, ExecutionResults`1 results, ICmdletExecutionHost host)
       at Citrix.Orchestration.Base.PowerShellInteraction.CmdletExecutionMethods.Execute[T](ISdkCmdlet`1 sdkCmd, ICmdletExecutionHost host, Boolean allowFailover)
       at Citrix.Orchestration.Base.PowerShellSdk.SiteService.Scripts.SiteServiceHelpers.<>c__DisplayClass3_0.<InitializePrimaryZone>b__0(ICmdletExecutionHost cmdletExecutionHost)
       at Citrix.Orchestration.Base.PowerShellSdk.SiteService.Scripts.InitializePrimaryZoneScript.RunScript()
       at Citrix.Orchestration.Base.PowerShellInteraction.PowerShellScript`1.Run()
       at Citrix.Orchestration.Base.PowerShellSdk.SiteService.Scripts.CreateEmptySiteScript.RunScript()
       at Citrix.Orchestration.Base.PowerShellInteraction.PowerShellScript`1.Run()
       at Citrix.Orchestration.Base.PowerShellSdk.SiteService.Scripts.FullDeploymentScript.RunScript()
       at Citrix.Orchestration.Base.PowerShellInteraction.PowerShellScript`1.Run()
       at Citrix.Console.DeliveryCenter.UI.Dialogs.FullDesktopDeploymentWizardViewModel.CompleteDeployment(IProgressReporter progressReporter)
       at Citrix.Console.DeliveryCenter.UI.Dialogs.DeploymentWizardViewModel.Commit(IProgressReporter progressReporter)
    
Inner Exception:
    
    StackTrace: Citrix.Broker.Admin.SDK.SdkOperationException Problem occurred contacting the database
       at System.Management.Automation.MshCommandRuntime.ThrowTerminatingError(ErrorRecord errorRecord)
    
Inner Exception:
    
    StackTrace: System.InvalidOperationException Problem occurred contacting the database

Link to comment

5 answers to this question

Recommended Posts

  • 0
Artimus Aunos Collaborator

Artimus Aunos

Posted
  • Author
Posted

I am now able to successfully sync the database during the creation of the citrix. but do not understand the in-depth reasons of what is the cause But what has been adjusted is to change the language to English (United State) at the Region System and Non-Unicode points, so it can be installed.
Previously, it was installed using the local language instead.

  • Like 1
Link to comment
  • 0
Artimus Aunos Collaborator

Artimus Aunos

Posted
  • Author
Posted
13 hours ago, Jeff Riechers1709152667 said:

Is this a new setup, or adding a delivery controller to an existing database site.

 

 

I'm setting up Citrix Vritual App and Dekstop 2203 CU3. I have tested both all in one and existing SQL but they found same problem. 

I have account as it's local administrator of Servers and sysadmin of SQL. 

Link to comment
  • 0
Jeff Riechers Mentor

Jeff Riechers

Posted
Posted

How far in the database creation process does it get?  Does it actually create the DB and not populate the tables?

 

The SQL account is going to need permissions to add active directory objects to the SQL server, as it puts the machine accounts for the delivery controllers as DBO on the databases it creates.

 

If it won't even create the databases, you can use a SQL query to create the databases.  

 

This is an example for setting them up for AAG

 

CREATE DATABASE CVADSite
CREATE DATABASE CVADMonitoring
CREATE DATABASE CVADLogging
ALTER DATABASE CVADSite COLLATE Latin1_General_100_CI_AS_KS
ALTER DATABASE CVADMonitoring COLLATE Latin1_General_100_CI_AS_KS
ALTER DATABASE CVADLogging COLLATE Latin1_General_100_CI_AS_KS
ALTER DATABASE CVADSite SET RECOVERY FULL
ALTER DATABASE CVADMonitoring SET RECOVERY FULL
ALTER DATABASE CVADLogging SET RECOVERY FULL
ALTER DATABASE CVADSite SET read_committed_snapshot on with rollback immediate
ALTER DATABASE CVADMonitoring SET read_committed_snapshot on with rollback immediate
ALTER DATABASE CVADLogging SET read_committed_snapshot on with rollback immediate
BACKUP DATABASE CVADSite TO DISK = 'CVADSite.bak'
BACKUP DATABASE CVADMonitoring TO DISK ='CVADMonitoring.bak'
BACKUP DATABASE CVADLogging TO DISK ='CVADLogging.bak'
GO
 

And this would be the process for setting them up for a single database server

 

CREATE DATABASE CVADSite
CREATE DATABASE CVADMonitoring
CREATE DATABASE CVADLogging
ALTER DATABASE CVADSite COLLATE Latin1_General_100_CI_AS_KS
ALTER DATABASE CVADMonitoring COLLATE Latin1_General_100_CI_AS_KS
ALTER DATABASE CVADLogging COLLATE Latin1_General_100_CI_AS_KS
GO
 

Link to comment
  • 0
Jason Ochs1709152296 Apprentice

Jason Ochs1709152296

Posted
Posted

Pretty common error. 

Check SQL permission.

--Your account for installing/running commands should be a sysadmin. 

--All your delivery controllers should be added as dbo to your Citrix databases.

--All your delivery controllers should have "connect" permissions to default system databases (master/model/msdb/tempdb.) 

 

Seeing as its local, I wouldn't expect to see a FW issue. 

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
Go to question listing

© Cloud Software Group, Inc. All rights reserved.

×
×
  • Create New...