How to address Duplicate object Event 'Issue Archived' has duplicates error

How to address Duplicate object Event 'Issue Archived' has duplicates error

Problem:

Duplicate object Event 'Issue Archived' has duplicates. This may cause errors during deployment.


Solution:

  1. Always run a full integrity check first before the deployment on the source and target Jira instance and resolve any errors (you don't need to resolve all warnings). More information on Integrity check is available on the below page - https://appfire.atlassian.net/wiki/spaces/CMJ/pages/82776965/Integrity+Check

  2. If the errors found in the integrity check aren’t fixed, proceeded with the deployment and encountered this error, then follow the steps below to resolve the error:

    1. All events on the system with their event ID can be found in the "JIRAEVENTTYPE" DB table. These event types are connected with the notification schemes in the tables NOTIFICATION and NOTIFICATIONSCHEME.

    2. Search for the duplicates in the "NOTIFICATION" table for multiple events assigned to the same scheme and that have the same "NOTIF_TYPE" and "NOTIF_PARAMETER".

    3. After identifying the problematic ones, edit the notification schemes where the duplicate object is detected which should resolve the issue.

If any DB modifications are to be made, always be sure to back up first and verify twice what needs to be changed.