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 withideliveryid=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.