Workflows failing due to missing delivery template in Adobe Campaign Classic

This article explains how to address workflow failures in Adobe Campaign Classic resulting from the manual deletion of a delivery template in the nmsDelivery schema. Direct database manipulations can lead to system instability and errors. The resolution involves restoring the deleted record and adopting best practices for managing delivery templates to prevent future issues.

Description description

Environment

Adobe Campaign Classic

Issue/Symptoms

Multiple workflows failed after a delivery template was deleted from the nmsDelivery schema using an SQL command. Symptoms included:

  • Errors in various workflows.
  • Inability to load the deliveries’ view.

Resolution resolution

  • Avoid directly executing SQL commands on the database, as this can lead to instability and errors.
  • If you need to delete delivery records, contact Adobe Support to ensure the process is handled safely by their Infrastructure team.
  • Instead of directly deleting records, mark them for deletion by setting ideletestatus=1.
  • To restore functionality, insert a new record into the nmsDelivery table with ideliveryid=0

Query:

insert into nmsdelivery(ideliveryid) values(0);
Before:
select count(*) from nmsdelivery where ideliveryid=0;

After:
select count(*) from nmsdelivery where ideliveryid=0;

If further issues arise or additional deletions are required, please reach out to Adobe Support for guidance and assistance.

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