please let me know
when these tables are created wkDlv_447220343 We can see there are are so many tables exist in pour db which starts with namespace......"wkDlv And the count of these tables in our db is close to 3000 and it is now affecting db performance can u please tell us when those tables are created, can we delete them from db manaully
Solved! Go to Solution.
Views
Replies
Total Likes
HI @Shruti1
These tables are created as part of workflow and delivery execution, they hold the target audience for that particular delivery.
We are back to the fact that you keep the interim results in your workflow and these tables won't be purged by the standard cleanup process.
Please do apply best practices to NOT use the "keep interim results" and "SQL Logs" options selected if you want to have a stable database.
Right now your solution will become more and more unstable because these options being selected across all your workflows, your database is never purged, keeping these options selected won't help the system getting better.
Thanks
Denis
HI @Shruti1
These tables are created as part of workflow and delivery execution, they hold the target audience for that particular delivery.
We are back to the fact that you keep the interim results in your workflow and these tables won't be purged by the standard cleanup process.
Please do apply best practices to NOT use the "keep interim results" and "SQL Logs" options selected if you want to have a stable database.
Right now your solution will become more and more unstable because these options being selected across all your workflows, your database is never purged, keeping these options selected won't help the system getting better.
Thanks
Denis
please recomemnd:
We have close to 2000 OLD wkfs LAST PROCESSED ON 2019 where "kEep interim result ..." is checked
now coz of this lot of temp tables were created and right now also they exist in db
now wwe want those tables to deleted from db====
we are thinking to follow this approach as recommeded by one of our colleegue":
Could you please suggest if this approach is safe in this case:
1. Uncheck interim result workflows, purge history and manually execute the cleanup workflow. We saw in the backend database that it deletes the data without manual intervention.
Views
Replies
Total Likes
Views
Replies
Total Likes
Hi @Shruti1
As mentioned earlier, you need to un-select the "Keep interim results "option and since you've got a large number of workflows and you could be it but phase a few workflows at a time to avoid to overwhelm the cleanup process.
Once it's done as also mentioned you can require a DB VACCUUM to be done. If the instance is hosted by Adobe, this will go via a customer care ticket.
Hope this helps,
Denis
Hello,
Just trying to understand...
@Shruti1 asked about the delivery's working tables (wkDlv_*) but @Denis_Bozonnet replied about workflow's working tables (wkf_*).
My question is: Is the "Keep interim result" workflow's setting affect some how the delivery's working tables?
We have the same issue but 40,000+ wkDlv_* tables in our Adobe database )).
Thanks!
Views
Replies
Total Likes
did u get an fix of this
if yes, pelase let mw know
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies