Return
-
Title
Error: "Could not convert variant of type (OleStr) into type (Unknown)" -
Description
Product:
Spotlight on SQL Server 7.0.1.4515
--------------------------------------------------------------------------------
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:
Details:
Handling notification: 67 (00000043)
Parameter info1: str:\xxxxx
Parameter info2: bool:0Message:
Notification 67 in drilldown TPpcmNavigation.Notify() has the following
error :Could not convert variant of type (OleStr) into type (Unknown)Source:
15E40C6A (Cop.0023FC6A) 7.5.0.354Call stack:
15E40C6A (Cop.0023FC6A) 7.5.0.354
15EBB221 (Cop.002BA221) 7.5.0.354
007C8E02 (Spotlight.003C7E02) 7.0.1.4515
007C9C53 (Spotlight.003C8C53) 7.0.1.4515
007D4DE6 (Spotlight.003D3DE6) 7.0.1.4515
004CA5FD (Spotlight.000C95FD) 7.0.1.4515
004CEB04 (Spotlight.000CDB04) 7.0.1.4515
004AAA75 (Spotlight.000A9A75) 7.0.1.4515
004CE21B (Spotlight.000CD21B) 7.0.1.4515
00437ACA (Spotlight.00036ACA) 7.0.1.4515
7D9472D8 (USER32.000162D8) 5.2.3790.4033
7D947568 (USER32.00016568) 5.2.3790.4033
7D94778D (USER32.0001678D) 5.2.3790.4033
7D9477D0 (USER32.000167D0) 5.2.3790.4033
004B31B6 (Spotlight.000B21B6) 7.0.1.4515
-
Cause
Spotlight on SQL Server Enterprise (SoSSE) installation is corrupt. Another Spotlight product installed on top of SoSSE or SoSSE installed on top of another Spotlight product.
We identify this restriction in the SoSSE Deployment Guide (page 27):* Do not install Spotlight on SQL Server into an existing Spotlight Console directory.
* If you install a different Spotlight after you have installed Spotlight on SQL Server, do not install the new Spotlight in the Spotlight on SQL Server directory. -
Resolution
The installation is corrupted, and there is no alternative other than to entirely uninstall the Spotlight clients, and re-install.
Steps;1. Use Control Panel > Add/Remove Programs to uninstall all Spotlight clients, which will probably be named similarly to:
- Spotlight on SQL Server
- Spotlight on Oracle, Oracle RACNote that there is no need to uninstall the Diagnostic Server, wherever it is running.2. Delete the folder: C:\Program Files\Quest Software\Spotlight Enterprise. Default installation folder.
3. Delete the folder: C:\Documents and Settings\All Users\Application Data\Quest Software\Spotlight
This folder contains configuration data (in a sub-directory "Default") for the Spotlight installation that has been corrupted.4. Now re-run the Spotlight on SQL Server Enterprise 7.0.1 installer. Select to only install the Spotlight client. You can choose your directory, either the default value, or "Spotlight Enterprise" as desired.5. Spotlight on SQL Server Enterprise should now be operational again. You may need to specify the location of the Diagnostic Server.6. If you want to install another Spotlight product for example Spotlight on Oracle, run the Spotlight on Oracle installer. Depending on the precise client environment, you will possibly get a dialog saying "Simple" or "Advanced" installation. If so, select "Advanced". You may also get a dialog saying "New installation" or "Existing installation". If so select "New installation". Probably, neither of these dialogues will be displayed, and you will simply get a default directory path to install into, probably ...\Quest Software\Spotlight. The key point is to choose a directory DIFFERENT to the Spotlight on SQL Server Enterprise install directory. Complete the installation.8. You should now have two Spotlights installed: SoSSE at ...\Quest Software\Spotlight Enterprise (for example), and SoO at ...\Quest Software\Spotlight for example. They should both work independently of each other. You may need to manually create Desktop shortcuts for the exe, which in both cases is ...\Console\Spotlight.exe in the installation directory.