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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.