-
Title
After Migration of the Diagnostic Server, unable to see data from the Playback database -
Description
Migration script was ran referencing SOL60936, however only 1 day of Playback data was available
-
Cause
Data was not modified in the Playback Database (DB) using a SQL specified on the Resolution seciotn to allow browsing history collected by the old Dignostic Server (DS).
-
Resolution
1. Stop both old and new Quest Diagnostic Servers services (under services in control panel)
2. Run the SQL below against the Playback Database specifying the correct NewHostName (new DiagnosticServer host name):
declare @HostName varchar(64)
SET @HostName = 'NewHostName' -- specify new DiagnosticServer host name here
UPDATE [dbo].[spotlight_playback_alarms]
SET [pb_domain_name] = @HostName + ':3843'
UPDATE [dbo].[spotlight_playback_data]
SET [pb_domain_name] = @HostName + ':3843'
UPDATE [dbo].[spotlight_playback_states]
SET [pb_domain_name] = @HostName + ':3843'
3. Start new Quest DiagnosticServer service.