Workflows will not load or extremely slow in Campaign Console

[James_Ont]

Hi there,

We have been experiencing an issue with our self hosted Marketing instance of adobe campaign classic.

We have several import workflows in our solution. These have been running every 15 minutes for the last 3 years or so without major issue with the execution.

However for the last year we have noticed that when we try to load the workflow in the workflow editor the time it takes to load has been increasing, it is now at the point where it will either take around 15 minutes to load the workflow or fails to load completely with a timeout error. While loading we can see the adobe campaigns process using excessive CPU amounting to 100% of one logical core.

We have tried purging history etc with no effect.  We have looked at our Postgres instance to see if we can see any long running queries but nothing seems to be amiss.

If we duplicate one of the affected workflows it loads instantly and without issue.

Execution of the workflows are unaffected by this issue.

Really struggling to find any support on this so could use some help knowing where to look next.

Thanks

[Craig_Thonis · Accepted solution]

Hi James,

It is probably easier to schedule a screen share with Campaign Support to review everything in a single session, as performance issues often require a holistic approach. That said, here are some things to check:

1) Ensure that your DB Cleanup workflow is running without error (this cleans up various temp tables, which can impact performance if they continue to grow)

2) Similarly, ensure that all paused workflows are stopped along with removing the "Keep interim results" from workflows, as these can maintain temp tables, which impact performance.

3) Analyze the bloat on your database, as Postgres may need a vacuum of large tables.

4) As performance has gotten worse over time, it is likely due to table growth which may indicate the need for indexes.

Finally, check out the best practices documentation below:
https://experienceleague.adobe.com/docs/campaign-classic/using/configuring-campaign-classic/data-mod...

Hope that helps.

Craig