Question
Deutsche Bank AG
DE
Last activity: 5 Feb 2018 3:18 EST
MARKETING DIRECTOR 6.6 - DELETE DECOMPOSING CAMPAIGNS
Hello together,
we have a couple of old campaigns that are no longer scheduled but shown up in the Campaign Builder with status Decomposing.
We are not able to delete them from the tool because all options for that are disabled.
How can we get rid of those?
From which tables of the repository has the campaign ID to be deleted to have it erased from the application?
Thanks and Cheers,
Marcus
***Updated by moderator: Lochan to add Categories and tag SR to post***
Accepted Solution
Optum
IN
The resolution for the SR is as follows:
By default Chordiant Marketing Director (CMD) application does not allow to delete the campaigns if the current status of the campaigns are in 'Decomposing' state. It needs to be manually changed to 'Approved' state by running the following SQL in database:
SQL>update camp_status_hist set status_setting_id=15 where status_setting_id=14 and camp_id=<campaign id>;
SQL>commit;
After this, the campaign will change to Approved state. Next, change the state of this campaign to 'Defined' by opening this campaign from Campaign Builder module and choosing the 'Define Campaign' option. On performing these operations, the delete button gets enabled at the campaign level.
Tech Mahindra
IN
Hi Marcus
I would suggest you raising the SR for this, as there is no straight forward way to delete the Campaigns, you might have to delete from the Database. GCS can provide the SQLs based on the campaign management data
Regards
Shri
Pegasystems Inc.
IN
Hi Marcus,
Please let us know the SR# once created. We will tag the SR to this post and continue to track it until resolution.
Regards,
Updated: 18 Jan 2018 11:26 EST
Deutsche Bank AG
DE
it seems the ticket has been closed already by <mod removed personal information>.
Are you able to re-open it?
Accepted Solution
Optum
IN
The resolution for the SR is as follows:
By default Chordiant Marketing Director (CMD) application does not allow to delete the campaigns if the current status of the campaigns are in 'Decomposing' state. It needs to be manually changed to 'Approved' state by running the following SQL in database:
SQL>update camp_status_hist set status_setting_id=15 where status_setting_id=14 and camp_id=<campaign id>;
SQL>commit;
After this, the campaign will change to Approved state. Next, change the state of this campaign to 'Defined' by opening this campaign from Campaign Builder module and choosing the 'Define Campaign' option. On performing these operations, the delete button gets enabled at the campaign level.