User has upgraded to Spotlight 10.0.2 and upgrading Spotlight Statistics Repository generates the following error. This is high availability Active Groups instance.
"Repository error [Upgrade Error]: Unable to upgrade the Spotlight Statistics Repository : The operation cannot be performed on database 'SpotlightStatisticsRepository' because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group. (any error line number is relative to the contents of the file SetupSSRUpgrade.sql starting at line 3) [1468]"
WORKAROUND:
Recreate or move Spotlight Statistics Repository to new instance.
STATUS:
Enhancement request SOSSE-225 has been submitted to Development for consideration in a future release of Spotlight on SQL Server Enterprise.
