This message was deleted.
# _general
s
This message was deleted.
n
Application: Citrix.Trust.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: System.Reflection.ReflectionTypeLoadException at System.Reflection.RuntimeModule.GetTypes(System.Reflection.RuntimeModule) at System.Reflection.Assembly.GetTypes() at Citrix.Fma.Sdk.CommonEnvTests.BaseEnvTestsProvider.LoadTests(System.Reflection.Assembly, System.Type[]) at Citrix.Fma.Sdk.ServiceCore.EnvTestsProvider..ctor(System.String, System.Resources.ResourceManager, System.Type[]) at Citrix.Trust.Logic.TrustLogic.InitializeEnvTests() at Citrix.Trust.Logic.TrustLogic.Initialize() at Citrix.Fma.Sdk.ServiceCore.ServiceRunner`1[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]].InitializeService() at Citrix.Fma.Sdk.ServiceCore.ServiceRunner`1[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]].RunStartupSequence() at Citrix.Fma.Sdk.ServiceCore.ServiceRunner`1[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]].DoWork() at Citrix.Fma.Sdk.ServiceCore.ServiceRunner`1[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]].DoWorkShell() at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object) at System.Threading.ThreadHelper.ThreadStart()
c
whats the status of the fma trust service ? get-trustservicestatus also check the db connection string get-trustdbconnection it sounds like the registration of the service via the configuration service has failed get-configregisteredserviceinstance will show you the services registered with the configuration service
n
The Trust Service is stopped, crashes when i start it
PS C:\Users\T1-neil.mcloughlin> get-trustservicestatus get-trustservicestatus : Failed to connect to back-end server 'localhost' on port 80 using binding WSHttp. The server may be off-line or may not be running the appropriate service At line:1 char:1 + get-trustservicestatus + ~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [Get-TrustServiceStatus], CommunicationException + FullyQualifiedErrorId : Citrix.XDPowerShell.Status.CommunicationError,Citrix.Trust.Sdk.Management.Commands.GetTr ustServiceStatusCommand
Get-ConfigRegisteredServiceInstance : An invalid URL was given for the service. The value given was ''. The reason given was: Failed to connect to back-end server 'localhost' on port 80 using binding WSHttp. The server may be off-line or may not be running the appropriate service The HTTP service located at http://localhost/Citrix/ConfigurationService is unavailable. This could be because the service is too busy or because no endpoint was found listening at the specified address. Please ensure that the address is correct and try accessing the service again later. The remote server returned an error: (503) Server Unavailable.. At line:1 char:1 + Get-ConfigRegisteredServiceInstance + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [Get-ConfigRegisteredServiceInstance], InvalidOperationException + FullyQualifiedErrorId : Citrix.XDPowerShell.Status.CommunicationError,Citrix.Configuration.Sdk.Registration.Comm ands.GetConfigRegisteredServiceInstanceCommand
That fails as the Citrix Configuration Service won't start either 😞
Service start-up failed with : System.InvalidOperationException: Service 'Citrix.Configuration.WcfService' has zero application (non-infrastructure) endpoints. This might be because no configuration file was found for your application, or because no service element matching the service name could be found in the configuration file, or because no endpoints were defined in the service element. at System.ServiceModel.Description.DispatcherBuilder.EnsureThereAreApplicationEndpoints(ServiceDescription description) at System.ServiceModel.Description.DispatcherBuilder.InitializeServiceHost(ServiceDescription description, ServiceHostBase serviceHost) at System.ServiceModel.ServiceHostBase.InitializeRuntime() at System.ServiceModel.ServiceHostBase.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at Citrix.Fma.Sdk.ServiceCore.ServiceRunner`1.OpenServiceHost()
Database Connection strings are all still present in the registry
c
hows the DB run time permissions both controllers got sql logins and mapped to the databases and DB roles. i presume the account you did the upgrade with was a sysadmin ?
n
it wasn't a sysadmin, I was going to generate the sql scripts to give to the database guy
Database connections look fine
c
so when has these errors come up ? after the DDC was upgraded and rebooted and after you open the updated studio ? or after you opened the updated studio and rather than doing automatic site upgrade u gave the dba the sql scripts on the databases and he then ran them with sql cmd mode?
n
After the ddc was upgraded and rebooted, and when I attempted to Open Studio it won't open, then i checked and saw that the Configuration Service and Trust Service won't start
c
ok cool so no update to the db schema at this stage
you had a look a the DDC install log file any erors in that ?
how did all the pre upgrade checks come back before the upgrade ? when you upgrade it has a pre check test where it checks the connection to db / fma services ect
n
Everything was clean
c
tbh with you it might be just easier to shut down the upgraded DDC and revert the snapshot you shouldnt have to restore the sql dbs as the schema hasnt been updated at this stage
n
I just tested and it actually looks like the DDC is operating, just cannot launch studio to upgrade the schema
c
i presume you have restarted the services/rebooted the server?
n
yeah a few timess
c
get-service citrix* | restart-services
n
This is the problem
PS C:\windows\system32> get-configregisteredserviceinstance | measure get-configregisteredserviceinstance : An invalid URL was given for the service. The value given was ''. The reason given was: Failed to connect to back-end server 'localhost' on port 80 using binding WSHttp. The server may be off-line or may not be running the appropriate service The HTTP service located at http://localhost/Citrix/ConfigurationService is unavailable. This could be because the service is too busy or because no endpoint was found listening at the specified address. Please ensure that the address is correct and try accessing the service again later. The remote server returned an error: (503) Server Unavailable.. At line:1 char:1 + get-configregisteredserviceinstance | measure + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [Get-ConfigRegisteredServiceInstance], InvalidOperationException + FullyQualifiedErrorId : Citrix.XDPowerShell.Status.CommunicationError,Citrix.Configuration.Sdk.Registration.Commands.GetConfigRegisteredServiceInstanceCommand
everything looks good until step 6
c
yeh its basically check servicestatus for all the fma services and the db connection strings and the registered service instances
yeh sounds like the trust service hasnt registered with the configuration service
n
yup
PS C:\windows\system32> Get-ConfigRegisteredServiceInstance Get-ConfigRegisteredServiceInstance : An invalid URL was given for the service. The value given was ''. The reason given was: Failed to connect to back-end server 'localhost' on port 80 using binding WSHttp. The server may be off-line or may not be running the appropriate service The HTTP service located at http://localhost/Citrix/ConfigurationService is unavailable. This could be because the service is too busy or because no endpoint was found listening at the specified address. Please ensure that the address is correct and try accessing the service again later. The remote server returned an error: (503) Server Unavailable.. At line:1 char:1 + Get-ConfigRegisteredServiceInstance + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [Get-ConfigRegisteredServiceInstance], InvalidOperationException + FullyQualifiedErrorId : Citrix.XDPowerShell.Status.CommunicationError,Citrix.Configuration.Sdk.Registration.Commands.GetConfigRegisteredServiceInstanceCommand PS C:\windows\system32> Get-ConfigServiceinstance Get-ConfigServiceinstance : An invalid URL was given for the service. The value given was ''. The reason given was: Failed to connect to back-end server 'localhost' on port 80 using binding WSHttp. The server may be off-line or may not be running the appropriate service The HTTP service located at http://localhost/Citrix/ConfigurationContract/v2 is unavailable. This could be because the service is too busy or because no endpoint was found listening at the specified address. Please ensure that the address is correct and try accessing the service again later. The remote server returned an error: (503) Server Unavailable.. At line:1 char:1 + Get-ConfigServiceinstance + ~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [Get-ConfigServiceInstance], InvalidOperationException + FullyQualifiedErrorId : Citrix.XDPowerShell.Status.CommunicationError,Citrix.Configuration.Sdk.Registration.Commands.GetConfigServiceInstanceCommand
Get-TrustServiceInstance : The operation could not be completed as the database has not been configured for the Citrix Trust Service service. At line:1 char:1 + Get-TrustServiceInstance + ~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [Get-TrustServiceInstance], InvalidOperationException + FullyQualifiedErrorId : Citrix.XDPowerShell.Status.DatabaseNotConfigured,Citrix.Trust.Sdk.Registration.Commands.GetTrustServiceInstanceCommand PS C:\windows\system32>
interesting..
c
yeh what does get-trustdbconnection show
PS C:\Program Files\Citrix\Desktop Studio> Get-TrustDBConnection Data Source=aoagctx;Initial Catalog=Citrixc4rm0Site;Integrated Security=True;MultiSubnetFailover=True
n
PS C:\windows\system32> get-trustdbconnection get-trustdbconnection : Failed to connect to back-end server 'localhost' on port 80 using binding WSHttp. The server may be off-line or may not be running the appropriate service At line:1 char:1 + get-trustdbconnection + ~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [Get-TrustDBConnection], CommunicationException + FullyQualifiedErrorId : Citrix.XDPowerShell.Status.CommunicationError,Citrix.Trust.Sdk.DataStore.Commands.GetTrustDBConnectionCommand
Solution 1. Nullify the Connection String of Citrix Trust Service on each Controller using below commands in powershell in admin mode : • asnp citrix* • Set-TrustDBConnection -DBConnection $null 1. Reboot the controller and ran the Automatic site upgrade again
wonder if i should try that?
c
get your db connection string and try use the test-trustdbconnection
let me send u something i know dba's say sql perms are correct but i never beleive them
n
Test-TrustDBConnection : Failed to connect to back-end server 'localhost' on port 80 using binding WSHttp. The server may be off-line or may not be running the appropriate service At line:1 char:1 + Test-TrustDBConnection + ~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [Test-TrustDBConnection], CommunicationException + FullyQualifiedErrorId : Citrix.XDPowerShell.Status.CommunicationError,Citrix.Trust.Sdk.DataStore.Commands.TestTrustDBConnectionCommand
c
so on the sql login for the affected ddc eg ddc01$ go into properties and on the user mapping make sure the login is mapped the citrix dbs with the site db selected check those db roles there is a trustschema_role
n
I used the correct connection string
c
bottom screenshot in that doc i just uploaded
n
I don't see any of that, presume I don't have permissions
I have logged a call with Citrix, hopefully we can figure it out!
c
yeh best bet u could try null out the db connection string for that service and re add it but i think its more of a issues where it hasnt registered with the configuration service
i find citrix support useless in cases like this lol they will tell u to restore db/ snapshot on ddc
n
yeah don't really want to restore as i know its just an issue with this DDC, not the database
Get-TrustDBConnection works fine on the other DDC
Tempted to try this
1. Nullify the Connection String of Citrix Trust Service on each Controller using below commands in powershell in admin mode : • asnp citrix* • Set-TrustDBConnection -DBConnection $null 1. Reboot the controller and ran the Automatic site upgrade again
what do you reckon?
you just need to run it on the broken DDC I think?
c
yeh i have nullled out the db strings multiple times and re added never had to do other parts tho rebooting the controller /run auto site upgrade after doing so
set-trustdbconnection -dbconnection -null then just put the dbstring back
n
ok i am going to set them to null, and reboot the server, see what happens 🙂
c
create a variable for your db connection string then use set-trustdbconnection -dbconnection $variable
tbh tho test-trustdbconnection with your dbstring should work
n
it doesnt
c
so i dont think a null / resetting it will work as the test-trustdbconnection -dbconnection "yourstring" dont work
n
ok trying now..
event hat wont work
PS C:\windows\system32> Set-TrustDBConnection -DBConnection $null Set-TrustDBConnection : Failed to connect to back-end server 'localhost' on port 80 using binding WSHttp. The server may be off-line or may not be running the appropriate service At line:1 char:1 + Set-TrustDBConnection -DBConnection $null + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [Set-TrustDBConnection], CommunicationException + FullyQualifiedErrorId : Citrix.XDPowerShell.Status.CommunicationError,Citrix.Trust.Sdk.DataStore.Commands.SetTrustDBConnectionCommand
maybe it relies on the configuration service which won't start..
c
i would get the dba to check that doc i sent each ddc will have its own sql login if the account/sql login isnt mapped to the citrix dbs site,monitoring,logging and hasnt been given the correct db roles will cause issues like this there is a db roled called trustshema_ROLE as well
n
ok thanks, i will send it over to him
c
good luck
n
Thanks! At least its not a P1 and nobody is screaming down my ear 🙂
Thanks for your help John
c
np m8
n
And 5 hours later we are upgraded! Citrix couldn't find anything so we restored the server from snapshot, re-ran the upgrade process and it completed successfully. Things we did different - nothing!!
😉 1
c
good to hear 🙂