ORA-00955: name is already used by an existing object

Symptoms:

Such error is observed in the Jira logs when the backing DB is Oracle.


Cause:

This is a known Jira issue - check this Atlassian KB article https://confluence.atlassian.com/jirakb/ora-00955-name-is-already-used-by-an-existing-object-144212317.html

Resolution:

Following the steps in Resolution for Cause #2 from the KB article should resolve this. If not - reinstall Configuration Manager for JIra following these steps:

1. Uninstall CMJ
2. Stop JIRA
3. Drop all CMJ AO_3A112F tables
4. Drop all CMJ AO_3A112F sequences
5. Start JIRA
6. Install CMJ