Question
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***
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,
Hi Lochana,
I have created an SR: SR-C7343
Thanks and best regards,
Marcus
it seems the ticket has been closed already by <mod removed personal information>.
Are you able to re-open it?
Accepted Solution
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.
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