tracking workflow takes hours (sometimes more than 1d to be completed)

[roro_coeur]

Hello,

the native tracking workflow in charge of downloading and consolidating the trackings logs retrieved from the mid that host tracking process is launching: 

tracking -instance:<%= instanceName %> -download -update

That's all we know. Any idea in details what this job actually do?

We are always at least 24 hours late.

No error in the audit. We have checked the database and purged old data on large tables that are related to delivery/tracking logs and deliveryStats.

Checking the database we don't see any lock or long processing queries.

Also checked the soap requests and did not see any latency.

Anybody have ideas on where to look for?

Any idea of the details of this process? (tables? queries?)

Thank you very much,

[david--garcia]

How often is your tracking workflow executing? every 1h?

[roro_coeur]

Hello David, it is scheduled every 1h but the scheduler does not have any effect since it takes at least several hours, sometimes 1 day to be completed so it never stop running. No error, but just slow apparently.

[david--garcia]

Whats your acc server version and deployment model? hybrid?

[roro_coeur]

We are hybrid, we are hosting the marketing instance and the mid is on adobe side (aws). We're on build V7 9032.

[david--garcia]

There is another client with the same version and deployment model facing the same issue, I will try to find out if this is a known issue.

[Sukrity_Wadhwa]

Hi @roro_coeur & @david--garcia,

Were any of you able to resolve this issue at your end? Do let us know. 

Thanks!

[Sukrity_Wadhwa · Accepted solution]

Hi @roro_coeur,

This question was recently addressed in one of our Adobe Campaign Community Q&A Coffee Break that happened on 10th February, 2022 at 8am PT with Michael Henry a.k.a @mihenry, Senior Business Consultant for Adobe Campaign. 

You can check the response here: https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic/new-in-2022-adobe-campaign-c...

Feel free to reach out to Michael on the same thread in case you have any follow up questions.

Thanks!