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

Cannot Launch Apps or Desktop; DC showing "An unexpected exception occurred while the Citrix Broker Service processed an HTTP request. "


Question

Even though all VDA's are showing as registered in studio and no site test or delivery group test is throwing error, when user try to launch the app or desktop "Cannot Launch app "app name" is displayed. And on the Delivery Controller getting below error:

 

An unexpected exception occurred while the Citrix Broker Service processed an HTTP request. 
 
Error details: 
Exception Type: 'Citrix.Fma.Sdk.Dal.DALDataStoreException' 
Exception Call Stack: '   at System.Data.SqlClient.SqlInternalConnectionTds.OnEnvChange(SqlEnvChange rec)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at Citrix.Fma.Sdk.Dal.SqlTxProvider.Open(DbConnection conn)
   at Citrix.Fma.Sdk.Dal.BaseTxProvider.CreateConnection(CdsTxOptions txOptions)
   at Citrix.Fma.Sdk.Dal.CdsTx.GetStoredProcedure(String spName)
   at Citrix.Cds.Broker.DAL.GeneratedBrokerDAL.EnumerateSelectedResources_TX(CdsTx _tx, SecurityIdentifier userSid, IEnumerable`1 groupSids, IEnumerable`1 denyOnlySids, IPAddress endpointIPAddress, String endpointName, Nullable`1 isViaAG, IEnumerable`1 smartAccessTags, Boolean enumeratePrivateDesktops, Boolean enumerateAOFUDesktops, Boolean enumerateSharedDesktops, Boolean enumerateApplications, String selectedBrowserName, Boolean& applicationsSuppressed)
   at Citrix.Cds.Broker.DAL.GeneratedBrokerDAL.<>c__DisplayClass72b.<EnumerateSelectedResources>b__728(CdsTx _tx)
   at Citrix.Fma.Sdk.Dal.BaseTxProvider.RunBatch(CdsTx tx, CdsTxAction txAction, String txName, Int32 retryNumber, Exception& originalException)
   at Citrix.Xms.XmlSupport.XmlPerf.TimeoutAction(Int32 timeoutMs, Action action)
   at Citrix.Cds.Xms.Wpnbr.WpnbrServer.HandleRequest(HttpListenerRequest request, WindowsIdentity identity, DateTime startTime)'

 

 

This is really urgent as I am sitting on hot seat at clients location for doing the POC.

 

Link to comment

9 answers to this question

Recommended Posts

  • 0

Saw this recently, it was due to a failover of the SQL instance from the primary SQL server to the Secondary (A SQL mirror is in place) without the Citrix services adjusting on their own (failure on Citrix part). A reboot of the Delivery Controller resolved the issue and they began talking to their data bases once again. Simple reboot for me, may not be as simple for you. Good luck.

Link to comment
  • 0

Even though all VDA's are showing as registered in studio and no site test or delivery group test is throwing error, when user try to launch the app or desktop "Cannot Launch app "app name" is displayed. And on the Delivery Controller getting below error:

 

An unexpected exception occurred while the Citrix Broker Service processed an HTTP request. 
 
...

 

Unfortunately there's not enough information there to say what's gone wrong. The stack trace suggests that the service is unable to open a connection to the database. Unless there's something obviously wrong with the database connectivity it would probably need CDF tracing from DDC to see what's happened. You might also look in the SQL server logs to see if it has recorded any errors.

 

Andrew.

Link to comment
  • 0

Correct, this is mostlike caused by the SQL database using mirroring whereas the DDC was never configured for using mirroring with failover partner.  For some reason either someone enabled mirroring on the Data Base  or the connection strings were modified on the DDC removing the failover partner from the strings.

 

solutions:

 

1) Ask your DBA to  disable/remove citrix daba bases from mirroring, reboot DDC 

 

or

 

2) Configure DDC for mirrorring on the connection strings 

https://docs.citrix.com/en-us/advanced-concepts/implementation-guides/database-connection-strings.html

Link to comment
  • 0
On 10/27/2014 at 12:47 AM, Mohammed Ansar Sukri1709154401 said:

Looks like when I create DB and dont mirror it then it works just fine. As soon as I do mirroring, again getting the same error. Have I missed something during mirroring??

 

you are missing the connection strings for mirroring with failover partner

 

https://docs.citrix.com/en-us/advanced-concepts/implementation-guides/database-connection-strings.html

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