-
Title
Error upgrading Spotlight Statistics Repository on high availability instance. -
Description
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]"
-
Cause
Spotlight currently does not support Diagnostic Server, Playback or Spotlight Statistics Repository on high availability or cluster instances. -
Resolution
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. -
Defect ID
SOSSE-225