Defect HC-14079

Deleting a marketing campaign in Management Center leads to stage propagation failure.

Software

Customer case Applies to Corrected in
CS0260099 V9.0.1.7 8.0.4.29

Observed behavior

When a campaign that has activities assigned is deleted on the staging environment, and the changes are stage propagated to production, the stage propagation job fails with a foreign key constraint violation.

Expected behavior

The staging propagation job should complete with no errors.

Resolution

The activities should be kept in the system, but their association to the deleted campaign should be removed by setting DMACTIVITY.DMCAMPAIGN_ID = null. This has been corrected.