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.