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

XD7.0 Database update error while adding additional DC


shrikant padole

Question

I try to join additional Delivery Controller into site, while updating the database, i get the following error (see below)
Even though in citrix studio site under controllers an error shown that cannot communicate with database.

Error Id: XDDS:1FA8BEDF

Exception:
    Citrix.Orchestration.Base.LogicModels.Exceptions.ScriptException Failed to update database CitrixDEN3Site on server den3cxsqlvs01.
       at Citrix.Orchestration.Base.PowerShellSdk.DatabaseService.Scripts.UpdateDatabaseScript.DoImpersonatedWork()
       at Citrix.Orchestration.Base.PowerShellInteraction.ThreadedDatabaseScript`1.RunScript()
       at Citrix.Orchestration.Base.PowerShellInteraction.PowerShellScript`1.Run()
       at Citrix.Orchestration.Base.PowerShellSdk.DatabaseService.PSDatabaseService.AddControllerToDatabases(IEnumerable`1 databaseCredentials, String configServiceAddress, ScriptExecutionContext context, String controllerToAddAddress)
       at Citrix.Orchestration.Base.PowerShellSdk.SiteService.Scripts.JoinExistingSiteScript.RunScript()
       at Citrix.Orchestration.Base.PowerShellInteraction.PowerShellScript`1.Run()
       at Citrix.Console.DeliveryCenter.UI.Dialogs.JoinExistingSiteDialogViewModel.OkBackgroundOperation(IProgressReporter progressReporter)
       at Citrix.Console.Common.OperationTimer.TimeBlock(Action operation)
       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 : DatabaseError
    SqlServerOutput : den3cxsqlvs01: CitrixDEN3Site: Changed database context to 'CitrixDEN3Site'.
    den3cxsqlvs01: tempdb: Changed database context to 'tempdb'.
    den3cxsqlvs01: tempdb: Changed database context to 'tempdb'.
    den3cxsqlvs01: CitrixDEN3Site: Changed database context to 'CitrixDEN3Site'.
    den3cxsqlvs01: CitrixDEN3Site: Login [DATAVAIL\DEN3PCXDCTRL01$] for controller [DATAVAIL\DEN3PCXDCTRL01$] already exists
    den3cxsqlvs01: CitrixDEN3Site: Database user [DATAVAIL\DEN3PCXDCTRL01$] already exists for controller [DATAVAIL\DEN3PCXDCTRL01$]
    
    ErrorCategory : NotSpecified
    DesktopStudio_PowerShellHistory : UpdateDatabaseScript
    8/16/2019 5:18:58 AM
    
    
    
Inner Exception:
    Microsoft.SqlServer.Management.Smo.FailedOperationException ExecuteNonQuery failed for Database 'CitrixDEN3Site'. 
       at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
       at Citrix.Orchestration.Base.PowerShellSdk.DatabaseService.Scripts.UpdateDatabaseScript.DoImpersonatedWork()
    
    HelpLink.ProdName : Microsoft SQL Server
    HelpLink.BaseHelpUrl : http://go.microsoft.com/fwlink
    HelpLink.LinkId : 20476
    HelpLink.ProdVer : 11.0.5058.0 ((SQL11_PCU_Main).140514-1623 )
    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.Database.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
    
    
Inner Exception:
    System.Data.SqlClient.SqlException Failed to add Citrix AD Identity Service on controller [S-1-5-21-2381427994-4160072731-3448860392-31441]
       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 : 14.00.1000
    HelpLink.EvtSrc : MSSQLServer
    HelpLink.EvtID : 50000
    HelpLink.BaseHelpUrl : http://go.microsoft.com/fwlink
    HelpLink.LinkId : 20476

Link to comment

4 answers to this question

Recommended Posts

  • 0
53 minutes ago, shrikant padole said:

    DesktopStudio_ErrorId : DatabaseError
    SqlServerOutput : den3cxsqlvs01: CitrixDEN3Site: Changed database context to 'CitrixDEN3Site'.
    den3cxsqlvs01: tempdb: Changed database context to 'tempdb'.
    den3cxsqlvs01: tempdb: Changed database context to 'tempdb'.
    den3cxsqlvs01: CitrixDEN3Site: Changed database context to 'CitrixDEN3Site'.
    den3cxsqlvs01: CitrixDEN3Site: Login [DATAVAIL\DEN3PCXDCTRL01$] for controller [DATAVAIL\DEN3PCXDCTRL01$] already exists
    den3cxsqlvs01: CitrixDEN3Site: Database user [DATAVAIL\DEN3PCXDCTRL01$] already exists for controller [DATAVAIL\DEN3PCXDCTRL01$]
    
    ErrorCategory : NotSpecified
    DesktopStudio_PowerShellHistory : UpdateDatabaseScript
    8/16/2019 5:18:58 AM
    
    
    
Inner Exception:
    Microsoft.SqlServer.Management.Smo.FailedOperationException ExecuteNonQuery failed for Database 'CitrixDEN3Site'. 
       at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
       at Citrix.Orchestration.Base.PowerShellSdk.DatabaseService.Scripts.UpdateDatabaseScript.DoImpersonatedWork()

 

i believe this is failing because it is trying to create/add the DATAVAIL\DEN3PCXDCTRL01$ computer account during the upgrade but it already exists/is configured in SQL Server.

 

From SQL Server Management Studio, remove that computer account and try the upgrade again.

 

Let us know if that allows the upgrade to complete or if it errors out again.  Please share any errors encountered and we should be able to help you through this.

Link to comment
  • 0
1 hour ago, shrikant padole said:

Inner Exception:
    System.Data.SqlClient.SqlException Failed to add Citrix AD Identity Service on controller [S-1-5-21-2381427994-4160072731-3448860392-31441]
       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)

 

Does this SID match the SID of the Delivery Controller referenced earlier in the error message?

 

If not, this process might be helpful in this instance:  https://www.jgspiers.com/remove-orphaned-delivery-controller-xenapp-xendesktop-site/

 

I am not sure what actions you've taken (or what your environment was like leading up to this upgrade), but I've been in a few scenarios recently involving database issues very similar to your current situation.

 

Let us know either way and we will continue to troubleshoot.

Link to comment
  • 0

Thanks Jim

I have removed orphaned  DC from site, but while adding again into site same error shown.

However in all errors same SID of DC shown.

 

After removing orphaned DC I have restarted complete Citrix setup including SQL DB servers as well as removed user hostname account from SQL security so that stored SID were cleared.

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