DB Cleanup workflow deletd all list tables(grp tables) | Community
Skip to main content
Shrutii
Level 4
Sep 15, 2023 4:35 PM UTC
Solved

DB Cleanup workflow deletd all list tables(grp tables)

 

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.
_Manoj_Kumar_
_Manoj_Kumar_Accepted solution
New Participant
Sep 17, 2023 11:13 PM UTC

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
View reply

1 reply

_Manoj_Kumar_
_Manoj_Kumar_Accepted solution
New Participant
Sep 17, 2023 11:13 PM UTC

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.

Translate
     Manoj     Find me on LinkedIn
    Terms & ConditionsAccessibility statement

    Loading footer...