Avatar of jnordeng
jnordeng
 asked on

Errors trying to upgrade XenApp 7.15.3000 to XenApp 7.15.5000

Hello.  Trying to upgrade from XenApp 7.15.3000 to XenApp 7.15.5000.  I had selected in the upgrade to have the Database Scripts generated and executed by the DBA.  I also read according to the flow chart that the DisableServices powershell script has to be run on Studio.  The issue is it is failing.  

Does anyone have insight as to what this is trying to use?  We tried without this and the DBA was getting errors indicating missing tables.


When running the disableServices powershell, getting errors.  So, what permission would it be looking for her for the logging?  Also, it generated this to use the Delivery Controller, but is giving the following error:


PS C:\Users\user> Add-PsSnapin Citrix.Broker.Admin.V2 -ErrorAction SilentlyContinue
PS C:\Users\user> Add-PsSnapin Citrix.Monitor.Admin.V1 -ErrorAction SilentlyContinue
PS C:\Users\user> Add-PsSnapin Citrix.ConfigurationLogging.Admin.V1 -ErrorAction SilentlyContinue
PS C:\Users\user>
PS C:\Users\user> Set-BrokerDBConnection  -AdminAddress "ctxdctst1a.domain.local:80" -DBConnection $null -Force
Set-BrokerDBConnection : Configuration logging required but unavailable; operation not allowed at this time
At line:1 char:1
+ Set-BrokerDBConnection  -AdminAddress "ctxdctst1a.domain.local:80" -DBCon ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : PermissionDenied: (:) [Set-BrokerDBConnection], SdkOperationException
    + FullyQualifiedErrorId : Citrix.XDPowerShell.Broker.DeniedByConfigurationLogging,Citrix.Broker.Admin.SDK.SetBroke
   rDBConnectionCommand


PS C:\Users\user> Set-MonitorDBConnection  -AdminAddress "ctxdctst1a.domain.local:80" -DataStore "Site" -DBConnection $nu
ll -Force

 ServiceStatus ExtraInfo
 ------------- ---------
DBUnconfigured


PS C:\Users\user> Set-LogDBConnection  -AdminAddress "ctxdctst1a.domain.local:80" -DataStore "Site" -DBConnection $null -
Force

 ServiceStatus ExtraInfo
 ------------- ---------
DBUnconfigured


PS C:\Users\user> Set-BrokerDBConnection  -AdminAddress "ctxdctst1a.domain.local:80" -DBConnection $null -Force
Set-BrokerDBConnection : Configuration logging required but unavailable; operation not allowed at this time
At line:1 char:1
+ Set-BrokerDBConnection  -AdminAddress "ctxdctst1a.domain.local:80" -DBCon ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : PermissionDenied: (:) [Set-BrokerDBConnection], SdkOperationException
    + FullyQualifiedErrorId : Citrix.XDPowerShell.Broker.DeniedByConfigurationLogging,Citrix.Broker.Admin.SDK.SetBroke
   rDBConnectionCommand

PS C:\Users\user> Set-MonitorDBConnection  -AdminAddress "ctxdctst1a.domain.local:80" -DataStore "Site" -DBConnection $nu
ll -Force

 ServiceStatus ExtraInfo
 ------------- ---------
DBUnconfigured


PS C:\Users\user> Set-LogDBConnection  -AdminAddress "ctxdctst1a.domain.local:80" -DataStore "Site" -DBConnection $null -
Force

 ServiceStatus ExtraInfo
 ------------- ---------
DBUnconfigured


PS C:\Users\user>

if I substitute the strings with the actual database server and databases it fails with a different error.  And does this for every line.

Set-MonitorDBConnection : An invalid URL was given for the service.  The value given was 'server.domain.local:1494'.
    The reason given was: The underlying connection was closed: The connection was closed unexpectedly.
        The underlying connection was closed: The connection was closed unexpectedly..
At line:1 char:1
+ Set-MonitorDBConnection  -AdminAddress "server.domain.local:1494" -Dat ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [Set-MonitorDBConnection], InvalidOperationException
    + FullyQualifiedErrorId : Citrix.XDPowerShell.Status.CommunicationError,Citrix.Monitor.Sdk.DataStore.Commands.SetM
   onitorDBConnectionCommand
Citrix* XenApp

Avatar of undefined
Last Comment
jnordeng

8/22/2022 - Mon
Sam Jacobs

Are the scripts being run by a Citrix Administrator?
jnordeng

ASKER
The DBA's, we have a separation here, so I had to select the section to have it manually generate the scripts.  The second time I did this the DBA said they worked and didn't error out.  However; when I go  back into Studio it's wanting me to run the steps again.

Thinking for future, will see if they'll grant my userID temporary access to the DB.
jnordeng

ASKER
Well, after selecting automatic a second time now it completed.  this is a little screwy, but at least I'm back into Studio.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Sam Jacobs

OK … Glad you got it working.
ASKER CERTIFIED SOLUTION
jnordeng

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.