The LiteSpeed_DeleteActivity (the purge function for respository database/tables) does not delete rows from LiteSpeedLocal or LiteSpeedCentral if 'Finishtime' is NULL
exec LiteSpeedLocal.dbo.LiteSpeed_DeleteActivity
@delLocal=1
, @delCentral=1
, @purgeDeleted = 1
, @deleteDate ='20130815 00:00:00'
WORKAROUND:
The rows in LiteSpeedLocal and/or LiteSpeedCentral LitespeedActivity tables with the NULL in FinishTime will need to be deleted manually. The LiteSpeed_DeleteActivity won't delete them.
The following script will assist in listing and deleting NULL rows:
USE LiteSpeedLocal
go
SELECTCOUNT(*)
FROM LitespeedLocal.dbo.LiteSpeedActivity
go
USE LiteSpeedCentral
go
SELECTCOUNT(*)
FROM LitespeedCentral.dbo.LiteSpeedActivity
exec LiteSpeedLocal.dbo.LiteSpeed_DeleteActivity
@delLocal=1
, @delCentral=1
, @purgeDeleted = 1
, @deleteDate ='20130815 00:00:00'
--OR--
exec LiteSpeedLocal.dbo.LiteSpeed_DeleteActivity
@delLocal=1
, @delCentral=1
, @purgeDeleted = 1
, @deleteDate =''
USE LiteSpeedLocal
go
SELECTCOUNT(*)
FROM LitespeedLocal.dbo.LiteSpeedActivity
where FinishTime =''
go
USE LiteSpeedCentral
go
SELECTCOUNT(*)
FROM LitespeedCentral.dbo.LiteSpeedActivity
where FinishTime =''
