Mid-sourcing (delivery counters) workflow is failing

Description description

Environment

  • Campaign
  • Campaign Classic

Issue/Symptoms
The Mid-sourcing (delivery counters) workflow was running for the client, trying to synchronize the logs between MID and marketing, but it kept failing. You may have tried to stop and restart the workflow, but it didn’t help. 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 the option NmsMidSourcing_LastDelivery_externalAccount which 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.

recommendation-more-help
3d58f420-19b5-47a0-a122-5c9dab55ec7f