DB Cleanup workflow deletd all list tables(grp tables) | Community
Skip to main content
Level 4
September 15, 2023
Solved

DB Cleanup workflow deletd all list tables(grp tables)

  • September 15, 2023
  • 1 reply
  • 708 views

 

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.
 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Manoj_Kumar

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.

1 reply

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity AdvisorAccepted solution
Community Advisor
September 17, 2023

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.

Manoj     Find me on LinkedIn