Delivery Outbound Transition is 0 even though deliveries are sent and received.

Description description

Environment

  • Campaign Classic
  • Campaign Classic v7

Issues/Symptoms

When sending a delivery with an outbound transition in a workflow, the delivery is set to either “Prepare” or “Prepare and Start”. Once the workflow runs, the outbound transition of the delivery shows 0 on the UI. The delivery is still sent as expected everything else is working but the UI just doesn’t display the correct number of recipients in the outbound transition. This is occurring for all workflows regardless of how the workflow is created.

Resolution resolution

Please reach out to your Database Admin and have them insert a new record into the NmsBroadLogMsg table where the values are equal to 0.

Cause:

The NmsBroadLogMsg table is missing the record where iBroadLogMsgId = 0 which is needed for the SQL query to populate the temp table used by the outbound transition.

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