DB Cleanup workflow deletd all list tables(grp tables)

[Shrutii]

DB Cleanup workflow deleted all list tables(grp tables) before today

Please help me what db cleanup workflow deleted wrt to Nmsgroup tables as part of which query--which filtering conditions

 error logs of DB cleanup workflow

ODB-240000 ODBC error: [Microsoft][ODBC Driver 17 for SQL Server]Communication link failure SQLState: 08S01
 Purge of 11893 no longer useful work tables associated with 'NmsGroup' completed in 1h 19m 14s.
 

[_Manoj_Kumar_ · Accepted solution]

Hello @Shrutii 

The DB Clean-up workflow deletes the data from the list where you have the expiry date.

If there is no expiry date, then a recent instance upgrade could be one of the reasons for this. This is a known issue: the lists are purged when Adobe upgrades the instance due to some bug.

Unfortunately, you can't do anything now.

One of the options is to restore the DB backup but doing this, you will lose any changes that is made to platform after the upgrade.