An unexpected problem has occurred when generating defragmentation script.
Steps to reproduce the issue:
1.Install Spotlight on SQL Server Enterprise 10.0.6971
2.Launch Spotlight,create SQL Server connection profile
3.Open the Databases | Fragmented Indexes drilldown. Select the index to defragment and click Fragmented Indexes | Generate defragmentation script.
The error below is generated:
Message:
An unexpected problem has occurred
It is recommended that you send a support bundle to Quest Software. Click "Show details..." for more information about the problem.
Details:
Message:
Could not convert variant of type (OleStr) into type (Double)
Source:
00434954 (Spotlight.00033954) 10.0.0.6971
Call stack:
00434954 (Spotlight.00033954) 10.0.0.6971
00434D93 (Spotlight.00033D93) 10.0.0.6971
00437BE3 (Spotlight.00036BE3) 10.0.0.6971
00D04CD4 (Spotlight.00903CD4) 10.0.0.6971
007C789E (Spotlight.003C689E) 10.0.0.6971
00B6F944 (Spotlight.0076E944) 10.0.0.6971
00B73134 (Spotlight.00772134) 10.0.0.6971
WORKAROUND
None
STATUS
Issue fixed in version 10. The latest version of Spotlight on SQL Server Enterprise can be downloaded here.
Note: This bug only affects to build 10.0.0.6971. If you have this build (go to Help | About to check this), please download version 10.0 again and perform the upgrade.
After the upgrade you will see build 10.0.0.6972 in Help | About
