Jira4 upgrade to Jira5 and greenhopper upgrade from 5.7.4 to 6.1.2, can't create Boards

[dibo zeng]

got a error message:

ORA-01400: 无法将 NULL 插入 ("JIRA"."AO_60DB71_RAPIDVIEW"."ID")

I find a lot of sites, including answers.atlassian.com, and didn't found a solution. Finally, I decided to try to resolve. Fortunately, I was successful.

I think someone may also encounter similar problems, answers.atlassian.com maybe is the best platform to share.

Maybe The cause: I have tried GH RapidView LAB before, it has established some tables and sequences in the database. When upgrade to 6.1.2, this tables and sequences didn't recreated.

Sequences :

AO_60DB71_RAPIDVIEW_ID_SEQ

AO_60DB71_SWIMLANE_ID_SEQ

AO_60DB71_STATSFIELD_ID_SEQ

AO_60DB71_COLUMNSTATUS_ID_SEQ

AO_60DB71_COLUMN_ID_SEQ

AO_60DB71_QUICKFILTER_ID_SEQ

Tables:

AO_60DB71_RANK_ISSUE_LINK;

AO_60DB71_SWIMLANE;

AO_60DB71_RAPIDVIEW;

AO_60DB71_COLUMNSTATUS;

AO_60DB71_COLUMN;

AO_60DB71_STATSFIELD;

AO_60DB71_QUICKFILTER;

Solution:

1. drop Sequences;

2. drop Tables.

when drop AO_60DB71_RAPIDVIEW, get a error message, ORA-02449.

Because some foreign constraints. Record a script :

/*--------------------------------------------

alter table AO_60DB71_CARDCOLOR add constraint "fk_ao_60db71_cardco777216688" foreign key (RAPID_VIEW_ID) references AO_60DB71_RAPIDVIEW (ID);

alter table AO_60DB71_DETAILVIEWFIELD add constraint "fk_ao_60db71_detail204345855" foreign key (RAPID_VIEW_ID) references AO_60DB71_RAPIDVIEW (ID);

alter table AO_60DB71_ESTIMATESTATISTIC add constraint "fk_ao_60db71_estima1932123493" foreign key (RAPID_VIEW_ID) references AO_60DB71_RAPIDVIEW (ID);

alter table AO_60DB71_SUBQUERY add constraint "fk_ao_60db71_subque1526381681" foreign key (RAPID_VIEW_ID) references AO_60DB71_RAPIDVIEW (ID);

alter table AO_60DB71_TRACKINGSTATISTIC add constraint "fk_ao_60db71_tracki1901499126" foreign key (RAPID_VIEW_ID) references AO_60DB71_RAPIDVIEW (ID);

alter table AO_60DB71_WORKINGDAYS add constraint "fk_ao_60db71_workin146243269" foreign key (RAPID_VIEW_ID) references AO_60DB71_RAPIDVIEW (ID);

------------------------------------------------*/

then drop table AO_60DB71_RAPIDVIEW again, use this SQL:

drop table AO_60DB71_RAPIDVIEW cascade constraints;

3. uninstall Greenhopper(in plugin manage page);

4. reinstall Greenhopper(in plugin manage page);

5. create a Board(Agile menu). finally, it works.... look into the database, you will find sequences and tables recreated;

6. run Record script in database.

[AhmadDanial · Accepted solution]

Hey there.

Thank you for sharing this. I believe that this will be very helpful for those users who bumped into the same issue. Very helpful!

Warm regards,

Danial