Return
-
Title
Playback features displays wrong date. -
Description
If you rewind (in Playback mode) in the database and go into blocked processes you get a random date and not the processes that were being blocked at this time. -
Cause
Playback contained an old alarm ( 4 months old alarm ) however playback data only goes back up to 14 days.
Therefore when user right click on old alarm and goes to diagnostic mode, playback mode has no data. -
Resolution
For work around:
Using below script to delete the old alarms : (please execute in SSMS on the configured playback database context)
declare @date as datetime
set @date = dateadd(d, -14, sysdatetime())DELETE
FROM spotlight_playback_alarms
WHERE pb_timestamp < @date
User can adjust how far back to remove, by changing the -14 to number of days user wish to keep. For example, if user wants to keep alarms of 30 days, then this value should be "-30".Product enhancement submitted - reference numeber JIRA1962
-
Defect ID
JIRA1962