JIRA 4.4 issue cloning - data base error (object already exists)

[Elvir Hadzic]

Hello everybody,

did anyone else encounter this problem in JIRA 4.4? When we want to clone an issue, we receive the following error:

Exception: net.java.ao.sql.ActiveObjectSqlException: java.sql.SQLException: There is already an object named 'AO_60DB71_RANK_ISSUE_LINK' in the database.

Any help regarding this matter would be greatly appreciated.

Edit: for some reason it want's to create the table again:

2011-08-22 09:43:56,992 http-192.168.15.16-443-6 ERROR [username] 583x30971x1 tgqvkm [jira ip] /sr/jira.issueviews:searchrequest-xml/10272/SearchRequest-10272.xml [net.java.ao.sql] Exception executing SQL update <CREATE TABLE AO_60DB71_RANK_ISSUE_LINK (
ISSUE_ID BIGINT NOT NULL,
NEXT_ID BIGINT,
PRIMARY KEY(ISSUE_ID)

[Jeremy Largman · Accepted solution]

Sorry for the late response. It looks like you might have hit one of these:

• https://jira.atlassian.com/browse/JRA-25309
• https://jira.atlassian.com/browse/GHS-3525

Looks like upgrading either JIRA (4.4.1) or GreenHopper (5.5.7) will fix it.

[Elvir Hadzic]

Thanks a lot!

This solved the problem completely.