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

Studio stuck at "Mandatory Upgrade" following a SQL DB Migration to a new SQL server.

Patrick Sheahan1709160923


Current Software Version:  XA/XD 7.15 CU7

Servers:  2 DDC/Director Servers

Problem:  Following an update to 7.1 5 CU7 from 7.15 CU2 (which was successful)  a migration to a new SQL server was completed.  Following the switch to the new SQL server, the Studio Console is showing that a mandatory upgrade is required.


I have confirmed with our SQL team that the database copy that was taken from the old SQL server was in fact taken after the update to 7.15 CU7. 


That said, I can't think of any other reason I would be getting forced into a second Site Upgrade.  Any help in this matter would be appriciated.


Link to comment

1 answer to this question

Recommended Posts

  • 0



First take a look if they set every security rights correctly, then check if all the tests of the new location are successful:




## Load the Citrix snap-ins
asnp citrix.*

$ServerName = "<dbserver>"
$SiteDBName = "<SiteDbName>"
$LogDBName = "<LoggingDbName>"
$MonitorDBName = "<MonitorDbName>"
$csSite = "Server=$ServerName;Initial Catalog=$SiteDBName;Integrated Security=True"
$csLogging = "Server=$ServerName;Initial Catalog=$LogDBName;Integrated Security=True"
$csMonitoring = "Server=$ServerName;Initial Catalog=$MonitorDBName;Integrated Security=True"

Test-AcctDBConnection -DBConnection $csSite
Test-AdminDBConnection -DBConnection $csSite
Test-AnalyticsDBConnection -DBConnection $csSite   # for 7.6 and newer
Test-AppLibDBConnection -DBConnection $csSite      # for 7.8 and newer
Test-BrokerDBConnection -DBConnection $csSite
Test-ConfigDBConnection -DBConnection $csSite
Test-EnvTestDBConnection -DBConnection $csSite
Test-HypDBConnection -DBConnection $csSite
Test-LogDBConnection -DBConnection $csSite
Test-LogDBConnection -DataStore Logging -DBConnection $csLogging
Test-MonitorDBConnection -DBConnection $csSite
Test-MonitorDBConnection -Datastore Monitor -DBConnection $csMonitoring
Test-OrchDBConnection -DBConnection $csSite       # for 7.11 and newer
Test-ProvDBConnection -DBConnection $csSite
Test-SfDBConnection -DBConnection $csSite
Test-TrustDBConnection -DBConnection $csSite      # for 7.11 and newer




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