4 answers

Hi Sergey!

I would recommend to you to check this KB https://confluence.atlassian.com/display/JIRAKB/Foreign+key+constraint+fails+on+fk_ao_60db71_boardadmins_rapid_view_id+referencing+ao_60db71_rapidview+when+restoring+XML+backup

The error in the KB described a situation where a data restore does not succeed, but the resolution in the KB apply to you case. You also may need to adapt the solution for you specific case. Don't forget to do a backup of your data before do any changes.

 

Also, from the log files, I notice you are using HSQL as database. Please notice HSQL is suitable only for evaluation purposes and should no be used as production database in JIRA. You can find further information on How to: Migrate from HSQL Database to External Database

Cheers!
Teilor

 

0 votes

Hi Sergey, Could you please clarify what's your doubt regarding Agile?

When the plug-in does not work jira Referer URL: Unknown java.lang.RuntimeException: org.apache.jasper.JasperException: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:HSQL Database Engine - version:1.8.0 - minor version:8 - major version:1 Driver: - name:HSQL Database Engine Driver - version:1.8.0 java.sql.SQLException: Constraint not found FK_AO_60DB71_BOARDADMINS_RAPID_VIEW_ID in table: AO_60DB71_BOARDADMINS in statement [ALTER TABLE PUBLIC.AO_60DB71_BOARDADMINS DROP CONSTRAINT fk_ao_60db71_boardadmins_rapid_view_id] java.lang.RuntimeException: org.apache.jasper.JasperException: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:HSQL Database Engine - version:1.8.0 - minor version:8 - major version:1 Driver: - name:HSQL Database Engine Driver - version:1.8.0 java.sql.SQLException: Constraint not found FK_AO_60DB71_BOARDADMINS_RAPID_VIEW_ID in table: AO_60DB71_BOARDADMINS in statement [ALTER TABLE PUBLIC.AO_60DB71_BOARDADMINS DROP CONSTRAINT fk_ao_60db71_boardadmins_rapid_view_id] at com.opensymphony.sitemesh.webapp.decorator.BaseWebAppDecorator.render(BaseWebAppDecorator.java:37) at com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:92) at com.atlassian.jira.web.filters.SitemeshPageFilter.doFilter(SitemeshPageFilter.java:124) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:87)

Hello,

Thank you very much for article. It became clear in what a problem.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,655 views 18 21
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you