Expand my Community achievements bar.

SOLVED

Regarding wkDlv_..............Tables

Avatar

Level 5

 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

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

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

View solution in original post

6 Replies

Avatar

Correct answer by
Employee Advisor

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

Avatar

Level 5

@Denis_Bozonnet 

 

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.

Avatar

Employee Advisor

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

Avatar

Level 2

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!

Avatar

Level 4

did u get an fix of this 

 

if yes, pelase let mw know