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

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

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.

On this page