[v6] How can I purge temporary/work tables?

Avatar

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

29-09-2016

There are a few ways to purge work tables (which hold temporary data for workflows or deliveries, but are commonly but erroneously called "temporary tables").

  • Restart the workflow, whilst making sure the "Keep interim populations" checkbox in workflow properties is unchecked
  • Stop the workflow. Then from the workflow list, select the workflow, right click it and select "Actions" > "Purge History". Be careful, as this will also delete the workflow journal/log too.

Also see documentation about database cleanup.

 

Florent.