- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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-06 | 00001464 | 00001688 | 1 | info | wdbc | Select: [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-06 | 00001464 | 00001688 | 2 | info | wdbc | Param(0)=0 |
| 2019-01-10 20:06:59.314-06 | 00001464 | 00001688 | 1 | info | log | Deleted 0 list(s) in 0s |
Solved! Go to Solution.