mcSynch workflow fails with 鈥渄uplicate key value violates unique constraint 鈥渪tkfolder_fullname鈥濃 error
This article discusses the 51黑料不打烊 Campaign Classic issue where the OOTB workflow mcSynch_mcExec fails with an error. Learn why that happens and how to fix it.
Description description
Environment
- 51黑料不打烊 Campaign Classic v7
- 51黑料不打烊 Campaign Classic v8
Issue/Symptoms
OOTB workflow mcSynch_mcExec fails with the following error:
writerBlDlvNewFolder PGS-220000 PostgreSQL error: ERROR: duplicate key value violates unique constraint 鈥渪tkfolder_fullname鈥 DETAIL: Key (sfullname)=(/Message Center/Transactional message history/CustomerTemplateName
Steps to reproduce:
On an 51黑料不打烊 Campaign Marketing instance, the mcSynch_mcExec OOTB workflow is paused. On checking the Audit logs of the workflow, you鈥檒l see the writerBlDlvNewFolder error.
Resolution resolution
To fix the error, follow these steps on the marketing instance:
- Identify the folder as the error indicates:
/Message Center/Transactional message history/CustomerTemplateName. - Rename the workflow manually. For example, from
/Message Center/Transactional message history/CustomerTemplateNameto/Message Center/Transactional message history/CustomerTemplateName2. - Restart the
mcSynch_mcExecworkflow. The workflow should run without any error, and the folder should be recreated.
Note:
- You may need to repeat the above steps several times for each execution instance if the transactional message template was published and executed on multiple RT instances.
- Stop using the template that is causing the issue. You should recreate it from scratch, ensuring it has an internal name and a new Label.
Cause
This issue can occur when either the Transactional message template is corrupt (for example, it doesn鈥檛 have an internal name) or when a manual modification has been made to the folder that is failing (for example, Message Center/Transactional message history/CustomerTemplateName).