Jump to content


Photo

After upgrade to XenDesktop 7.9 controllers not visible in studio - cannot communicate with the database

Started by joyk04 , 01 December 2016 - 03:22 PM
8 replies to this topic

joyk04 Members

Surya Prakash JOYMUNGUL
  • 1 posts

Posted 01 December 2016 - 03:22 PM

We recently upgraded from XA/XD 7.6 to 7.9.

 

On the Delivery controllers, we are able to connect to studio and see the configurations and the apps. HOwever, we are not able to see the controllers. We have the following error message:

 

cannot communicate with the database

 

All the DC servers accounts are authorised at the MS Sql 2012 level.

 

Any help on the issue?

 

 

The error details are as follows:

 

Error Id: XDDS:826D8FE0
 
Exception:
    Citrix.Console.Models.Exceptions.ScriptException Cannot communicate with the database.
       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.BrokerService.Scripts.GetControllersScript.AddZonesToModels(IList`1 controllerModels)
       at Citrix.Console.PowerShellSdk.BrokerService.Scripts.GetControllersScript.RunScript()
       at Citrix.Console.PowerShellInteraction.PowerShellScript`1.Run()
       at Citrix.Console.PowerShellSdk.BrokerService.PSBrokerService.GetBrokers()
       at Citrix.Console.Brokers.UI.Mmc.BrokersTabViewModel.<>c__DisplayClass4.<OnRefresh>b__0()
       at Citrix.Console.CommonControls.ViewModelBase.<>c__DisplayClasse.<RunBackgroundTask>b__c(Object s, DoWorkEventArgs e)
    
    DesktopStudio_ErrorId : DatabaseError
    Exception : System.NullReferenceException: Object reference not set to an instance of an object.
       at Citrix.Fma.Sdk.Filtering.TypeCache.<>c__DisplayClass1`2.<CastAndInvoke>b__0(Object t, Object o)
       at Citrix.Fma.Sdk.Filtering.TypeCache.SetProperty(Object instance, String property, Object value)
       at Citrix.Fma.Sdk.Filtering.SdkObjectReader.ReadSdkObject(DbDataReader db)
       at Citrix.Fma.Sdk.Filtering.FilteringDal.GetCommonReader(Func`2 reader, Int32 maxResultCount, Object[]& sdkObjects, DbDataReader query)
       at Citrix.Fma.Sdk.Filtering.FilteringDal.GetCommonTx(CdsTx txProvider, String query1, String query2, IEnumerable`1 sqlParameters, Func`2 reader, Nullable`1 sqlQueryTimeout, Int32 maxResultCount, Boolean returnTotalAvailableResultCount, Int32& totalAvailableResultCount, Object[]& sdkObjects)
       at Citrix.Fma.Sdk.Filtering.FilteringDal.<>c__DisplayClass3.<GetCommon>b__0(CdsTx tx)
       at Citrix.Fma.Sdk.Dal.BaseTxProvider.RunBatch(CdsTx tx, CdsTxAction txAction, String txName, Int32 retryNumber, Exception& originalException)
       at Citrix.Fma.Sdk.Dal.BaseTxProvider.Execute(String txName, CdsTxOptions txOptions, CdsTxAction txAction)
       at Citrix.Fma.Sdk.Filtering.FilteringDal.GetCommon(ICdsTxProvider txProvider, String query1, String query2, IEnumerable`1 sqlParameters, Func`2 reader, Nullable`1 sqlQueryTimeout, Int32 maxResultCount, Boolean returnTotalAvailableResultCount, Int32& totalAvailableResultCount, Object[]& sdkObjects)
       at Citrix.Fma.Sdk.Filtering.FilteringLogic.GetCommon(IQuerySchemaProvider schemaProvider, ICdsTxProvider txProvider, String operationName, IDictionary`2 arguments, String groupByProperty, ScopeList scopeIds, Nullable`1 sqlCommandTimeout, Int32 skip, Int32 maximumResultCount, Boolean returnTotalAvailableResultCount, Int32& totalAvailableResultCount, Object[]& records)
       at Citrix.Fma.Sdk.ServiceCore.CommonCmdlets.CommonCmdletsDal.CommonGetLogicDefault(String operationName, IDictionary`2 arguments, String groupByProperty, Guid[] gettableScopeIds, Int32 skip, Int32 maximumResultCount, Boolean returnTotalAvailableResultCount, Int32& totalAvailableResultCount, Object[]& records)
       at Citrix.Fma.Sdk.ServiceCore.CommonCmdlets.CommonCmdletsDal.CommonGetLogicDispatcher(String operationName, IDictionary`2 arguments, String groupByProperty, Guid[] gettableScopeIds, Int32 skip, Int32 maximumResultCount, Boolean returnTotalAvailableResultCount, Int32& totalAvailableResultCount, Object[]& records)
       at Citrix.Fma.Sdk.ServiceCore.CommonCmdlets.CommonCmdletsDal.CommonGetLogic(String operationName, IDictionary`2 arguments, String groupByProperty, Guid[] gettableScopeIds, Int32 skip, Int32 maximumResultCount, Boolean returnTotalAvailableResultCount, Int32& totalAvailableResultCount, Object[]& records)
    Sdk Error Message : A database operation failed and could not be recovered : Reason Object reference not set to an instance of an object.
    Sdk Error ID : Citrix.XDPowerShell.Status.DatabaseError,Citrix.Configuration.Sdk.Management.Commands.GetConfigServiceCommand
    ErrorCategory : NotSpecified
    DesktopStudio_PowerShellHistory : GetControllersScript
    12/1/2016 2:53:11 PM
    
    Get-BrokerController  -AdminAddress "afdbhqxddc01.afdb.local:80" -MaxRecordCount 2147483647
    Get-ConfigService  -AdminAddress "afdbhqxddc02.afdb.local:80" -MaxRecordCount 2147483647
    Get-ConfigService : A database operation failed and could not be recovered : Reason Object reference not set to an instance of an object.
    + CategoryInfo : InvalidOperation: (:) [Get-ConfigService], InvalidOperationException
    + FullyQualifiedErrorId : Citrix.XDPowerShell.Status.DatabaseError,Citrix.Configuration.Sdk.Management.Commands.GetConfigServiceCommand
    
    
 

 



Reinhard Travnicek Members

Reinhard Travnicek
  • 43 posts

Posted 12 December 2016 - 12:13 PM

Me too,

Just upgrade from 7.6 to 7.12 and have the same error pattern.

I see everything in the console / studio except controller and zones.

Any idea!

 

regards

 

Reinhard



Clement Thuraisamy Members

Clement Thuraisamy
  • 11 posts

Posted 18 January 2017 - 02:03 AM

i have same experience after upgrade to 7.12. Any update ?



Russell Farr Members

Russell Farr
  • 2 posts

Posted 14 February 2017 - 02:26 PM

Having the same issue, any updates?



Kevin Swann Members

Kevin Swann
  • 2 posts

Posted 16 February 2017 - 08:59 PM

We are getting the same error when I go to Citrix Studio/Configuration/Controllers.  Test-ConfigDBConnection gives ServicesStatus = OK.  It really seems not to be a Database connection communication.  It seems that the Citrix powershell or configuration it requires is broken.



Jeffery Ranger Members

Jeffery Ranger
  • 3 posts

Posted 27 February 2017 - 03:43 PM

Seeing the same issue going from 7.8 to 7.12. Anyone get this resolved?



Martin Bergeron Members

Martin Bergeron
  • 12 posts

Posted 19 April 2017 - 04:25 AM

Hi,

 

Same error here after upgrade from 7.8 to 7.13. Any news? Cannot access Controllers and Zones.

 

Thanks!



William (Bill) Hughes Members

William (Bill) Hughes
  • 3 posts

Posted 28 April 2017 - 03:05 PM

Same here. No fixes found yet? 



Denelia Smith Citrix Employees

Denelia Smith
  • 2 posts

Posted 28 April 2017 - 03:44 PM

There could be stale entries existing in the database after the upgrade. A scout with CDF trace will need to be submitted to support to verify. 

 

Are you able to add new controller to site? If yes, once new controller is successfully added and functional in Site the other controller can be evicted https://support.citrix.com/article/CTX139505/ [ backup all databases and snapshot servers ]