Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

how to identify and find temp tables created by using option "Keep interm results between populaation" checked in wkfs

Avatar

Level 4

@DavidKangni @Craig_Thonis,

 

for all our wkfs  our campaign team is checking the box "keep interim results as checked lot of temp tables gets created and it's occupying a lot of space. Do you guys know how to drop these tables or is there any configuration to auto flush this. Note : We cannot uncheck the check box ( interim results ) as it's essential for us to view the targets."

and thi box is checked in all of our wkf since last 2years

 

 

nEDD HELP HERE

we need to identify temp tables --how we can identify them 

do they start with something like

 

wkf733107840_4206_1
grp337632156

 

Please let us know

do we need to purge them all

how can we purge them in db?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hello @Shruti1 

 

It is not a best practice to keep this checkbox checked. And if you trying to delete the temporary tables then it defeats the purpose of checking it in the first place.

 

My recommendation would be to uncheck this checkbox in all workflows.

View solution in original post

5 Replies

Avatar

Correct answer by
Community Advisor

Hello @Shruti1 

 

It is not a best practice to keep this checkbox checked. And if you trying to delete the temporary tables then it defeats the purpose of checking it in the first place.

 

My recommendation would be to uncheck this checkbox in all workflows.

Avatar

Level 4

Thanks @Manoj_Kumar_ 

for the info

I just need one small info here

our team is creating wkfs

for eg: scheduled to run @9am daily

and keeping this option"keep interim...." checked from last 2 years

now coz of that so many temP tables are created in DB everyday

NOW MY ASK IS

1)if I disable/uncheck the option ""keep interim...  results....."  in wkfs

will it delete all of my temp tables created since 2 years

2)After unchecking the option ""keep interim...  results....."  in wkfs

do we need to restart the wkf then only tables will be deleted by DB Clean up WKF or if we can simply disable this option  then THESE TEMP tables will be deleted by DB Clean up WKF

 

 

Avatar

Level 4

Hello @Shruti1,

 

Yes, temporary table name start with ''wkf''. In fact the temporary table name is constructed as so : 

wkf<workflow ID>_<task Identifier>_<incremental Identifier>.

So you can know what tables are generated by which workflow. 

 

Br,

Amine

Avatar

Level 4

 

I just need one small info here

our team is creating wkfs

for eg: scheduled to run @9am daily

and keeping this option"keep interim...." checked from last 2 years

now coz of that so many temP tables are created in DB everyday

NOW MY ASK IS

1)if I disable/uncheck the option ""keep interim...  results....."  in wkfs

will it delete all of my temp tables created since 2 years

2)After unchecking the option ""keep interim...  results....."  in wkfs

do we need to restart the wkf then only tables will be deleted by DB Clean up WKF or if we can simply disable this option  then THESE TEMP tables will be deleted by DB Clean up WKF

 

Avatar

Community Advisor

1)if I disable/uncheck the option ""keep interim...  results....."  in wkfs

will it delete all of my temp tables created since 2 years --> Yes it will delete temp tables link to these workflows

2)After unchecking the option ""keep interim...  results....."  in wkfs

do we need to restart the wkf then only tables will be deleted by DB Clean up WKF or if we can simply disable this option  then THESE TEMP tables will be deleted by DB Clean up WKF --> no need to restart the workflows