Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Table created by List is deleted

Avatar

Avatar
Validate 1
Level 2
Aalokitoaami
Level 2

Likes

14 likes

Total Posts

29 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
Aalokitoaami
Level 2

Likes

14 likes

Total Posts

29 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
Aalokitoaami
Level 2

10-01-2019

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 2
Aalokitoaami
Level 2

Likes

14 likes

Total Posts

29 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
Aalokitoaami
Level 2

Likes

14 likes

Total Posts

29 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
Aalokitoaami
Level 2

14-07-2019

I found the reason and sorry for late posting.

The issue was, someone created FDA connection from a different environment to this environment. When the nightly cleanup workflow runs, it deletes the table for the list. Here is more details.

We had UAT environment connecting to SIT via FDA (probably someone did some test, god knows when, especially when the environments are 7+ yesrs old). So when UAT cleanup is running, it is connecting to SIT via FDA. That connection is deleting the list related table. Similarly all other lower environments are interconnected via some other environment's FDA and it was happening to all lower environments.

Answers (3)

Answers (3)

Avatar

Avatar
Validate 1
MVP
Jean-Serge_Biro
MVP

Likes

353 likes

Total Posts

464 posts

Correct Reply

153 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
MVP
Jean-Serge_Biro
MVP

Likes

353 likes

Total Posts

464 posts

Correct Reply

153 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Jean-Serge_Biro
MVP

14-01-2019

Hi Aalokitoaami,

Please may you display and check the @expirationDate value (SQL field tsExpiration) of your List (recipient group or other type of list)?
The easiest is to add expirationDate field as a column when you display the lists in the User Interface.

Usually by default expirationDate is set to be empty, and you can set it to a specific date through the UI.
By using the List update activity in the workflow, you don't have to define it  usually, but perhaps something has been done for this somewhere.

Regards

J-Serge

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

960 likes

Total Posts

1,090 posts

Correct Reply

508 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

960 likes

Total Posts

1,090 posts

Correct Reply

508 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

11-01-2019

Hi,

As you've discovered, cleanup is an nlserver command- part of the binary, i.e. not directly read. The command is run by technical workflow 'cleanup', with scheduler at 4AM by default, prob just a safe time after 2AM reboot. The workflow logs its actions, so you can see how many it deleted when.

What you're doing is pretty good for debugging, tracing the sql calls it makes. From here just run the same sql and see what it picks up, and why.

Thanks,

-Jon

Avatar

Avatar
Validate 1
Level 3
asariaaara
Level 3

Likes

18 likes

Total Posts

48 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 3
asariaaara
Level 3

Likes

18 likes

Total Posts

48 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
asariaaara
Level 3

10-01-2019

HI Alok,

This is off-point question.
how can i check temp table associated with lists.

Thanks