JIRA Throw Error When Trying To Export Search Result Into Excel(All fields)

Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.

Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.

*Except Fisheye and Crucible

Summary

Symptoms

When user try to export search result into Excel while selecting All Fields, JIRA throw the following trace:

1 An error occurred whilst rendering this message. Please contact the administrators, and inform them of this bug. Details: ------- org.apache.velocity.exception.MethodInvocationException: Invocation of method 'hasValue' in class com.atlassian.jira.issue.fields.CustomFieldImpl threw exception class java.lang.RuntimeException : java.lang.reflect.InvocationTargetException

Diagnosis

  1. JIRA version 4.4.x

  2. GreenHopper Plugin is installed

  3. If entered the Plugin Safe Mode, the error no longer persist

  4. If GreenHopper plugin is enabled, and user try to add the Global Rank to the default Column in the Issue Navigator, JIRA will throw another trace:

    1 An error occurred whilst rendering this message. Please contact the administrators, and inform them of this bug. Details: ------- org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getSortComparatorSource' in class com.atlassian.jira.issue.fields.CustomFieldImpl threw exception class java.lang.NoClassDefFoundError : com/atlassian/greenhopper/customfield/rank/RankLuceneFieldSorter

    In the JIRA logs, the following trace can be found:

    1 2 3 4 5 6 2011-09-04 17:43:43,040 http-8082-4 ERROR admin 1063x232x1 1fbk5gm 127.0.0.1 /secure/ViewUserIssueColumns!default.jspa [com.atlassian.velocity.DefaultVelocityManager] MethodInvocationException occurred getting message body from Velocity: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException java.lang.RuntimeException: java.lang.reflect.InvocationTargetException at com.atlassian.activeobjects.tx.TransactionalProxy$1.doInTransaction(TransactionalProxy.java:47 ... Caused by: java.lang.RuntimeException: Entry to update not found: issueId=13081, nextValue=15001 at com.atlassian.greenhopper.service.rank.RankDaoImpl.setNextForIssue(RankDaoImpl.java:94)

Cause

A bug reported at https://jira.atlassian.com/browse/JRA-25808 . The rank index in the Database is broken. In this example, issue with ID 13081 is referenced as "next" by 13082, but 13081 is not in the index (it should be last, having "null" as next). This causes the next "rank last" operation (the default initial action for previously unranked issues) to fail.

Solution

Resolution

  1. Update the database manually. The steps are as follow:

    1. shutdown JIRA

    2. backup JIRA's database

    3. check if there a table that is started with AO and end with RANK_ISSUE_LINK. Please replace the XXXX with hash name exist in the JIRA database

    4. then run the following SQL query to check if there any entry that has issue with NEXT_ID 13081:

      1 SELECT * FROM AO_XXXX_RANK_ISSUE_LINK where NEXT_ID=13081;

      Replace the "13081" with the "issueID" value reported in the logs.

    5. Then, check if there any any ISSUE_ID with 13081

      1 SELECT * FROM AO_XXXX_RANK_ISSUE_LINK where ISSUE_ID=13081;
    6. Then, insert an entry to the table manually:

      1 insert into AO_XXXX_RANK_ISSUE_LINK (ISSUE_ID) values (13081);
    7. restart JIRA

Updated on April 2, 2025

Still need help?

The Atlassian Community is here for you.