Adobe Campaign Classic v7 & Campaign v8

Shrutii · 9/26/23

Hi All,

I have observed

wkDlv_815003218:observed tables like starts with wkDlv_81500321 in adobe database is 1lac in counts,

can someone lwt me know when these tables are craeted , can we delete them?

LakshmiPravallika · 9/26/23

Could you Please uncheck the Interim results Option in the Production Workflows and also ask Adobe Team to do a DB Vaccum activity to drop all these Temp Tables to clear the DB Space.

It is a best practice to do the DB Vaccum activity once in a month to avoid the memory issues for DB Space,

Regards,

Pravallika.

View solution in original post

AkshayAnand · 9/26/23

Hi @Shrutii

Please find the thread for a similar kind of issue, you can follow the resolution provided by Denis_Bozonnet.

These all are temp tables created while workflow execution and you can clear them out.

Regards

Akshay

LakshmiPravallika · 9/26/23

Hi @Shrutii ,

Could you Please uncheck the Interim results Option in the Production Workflows and also ask Adobe Team to do a DB Vaccum activity to drop all these Temp Tables to clear the DB Space.

It is a best practice to do the DB Vaccum activity once in a month to avoid the memory issues for DB Space,

Regards,

Pravallika.

Shrutii · 9/26/23

hi @LakshmiPravallika

CAN U PELASE HELP ME TO KNOW WHICH TEAM PERFORMS db vaccum actiivty

is this adobe team---when we login to adobe adin console,,?

LakshmiPravallika · 9/26/23

Hi @Shrutii ,

If your Instance is On premise , your Team can perform the DB Vaccum activity or If your Instance is a hosted Environment, then all the Operations at Backend are managed by Adobe Team , then you have to raise an Adobe ticket.

Regards,

Pravallika.

@aggabhi