Avatar

Level 3

I am having an issue in my on-prem environment where if I create a list, it is getting deleted overnight. I am using the List Update activity and creating own table for the list so that I can store additional columns as snapshot. It is working fine, but on the next day when I try to use the list, I am getting and error and figured out that the associated grp table (example: grp165019102) is deleted.

I figured out that the list is getting deleted after 4 AM and obviously pointer shifted to Cleanup Workflow. After I stopped the cleanup workflow, in UAT, the lists are not getting deleted.

I initially thought it might be due to the list not having the expiration date. So I gave the expiration date as 6 months from creation date, but still it is getting deleted.

Any idea what to check?

Also in another lower environment even after stopping the cleanup workflow, I see that the cleanup is somehow running at 4AM. I checked the Cleanup workflow workflow log of the cleanup workflow and also the monitor > runwf@instanceName and don't see any workflow kicking off at 4AM. But my sql server profiler is capturing a log as "nlserver runwf cleanup" as application name. So the cleanup script is somehow kicking from somewhere. Any idea how to track it down?

Note, I ran nlserver cleanup script as below manually after creating the list, but it is not deleted that time and I am getting logs like 0 list deleted and so

nlserver cleanup -instance:sit -verbose -tracefile:clenup_01102018@sit -tracefilter:*

Log from cleanup

2019-01-10 20:06:59.314-060000146400001688  1infowdbcSelect: [98494224] SELECT  top 101 G0.iGroupId, G0.sLabel, G0.iType FROM NmsGroup G0 WHERE (G0.iDeleteStatus <> ? OR G0.tsExpiration <= GetDate()) ORDER BY G0.tsLastModified, G0.iGroupId
2019-01-10 20:06:59.314-060000146400001688  2infowdbc  Param(0)=0
2019-01-10 20:06:59.314-060000146400001688  1infologDeleted 0 list(s) in 0s