Mid-sourcing (delivery counters) workflow is failing

This article addresses the issue in Adobe Campaign Classic where your mid-sourcing (delivery counters) workflow keeps failing. It is likely occurring due to the  LastDelivery option not being updated properly. To resolve this, you have to manually update it with the current timestamp.

Description description

Environment

Issue/Symptoms

The Mid-sourcing (delivery counters) workflow was running, trying to synchronize the logs between MID and marketing, but it kept failing. Trying to stop and restart the workflow didn’t help either. This workflow has never worked properly. The status has always been either Aborted  or Failed  from the beginning.

Resolution resolution

The root cause of this behavior was that the option NmsMidSourcing_LastDelivery_externalAccount was not updated correctly. The LastDelivery option for mid workflow wasn’t updated, and every time the workflow started, it tried to fetch data from 2020, and a timeout error happened. You must update the option manually, and the workflow will start to execute normally.

This option should be updated with a current timestamp after the defaultMidSourcingDlv workflow is executed. When the next execution starts, the workflow checks this option in order to know when to start synchronizing the mid logs again.