org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getHtml' in class com

[Naman Soni]

Please contact the administrators, and inform them of this bug. Details: ------- org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getHtml' in class com.atlassian.jira.issue.fields.layout.column.ColumnLayoutItemImpl threw exception java.lang.NullPointerException at templates/jira/issue/table/macros.vm[line 117, column 34] at org.apache.velocity.runtime.parser.node.ASTMethod.handleInvocationException(ASTMethod.java:342) at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:284) at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:262) at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:507) at org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:71) at org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:142) at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72) at org.apache.velocity.runtime.directive.Foreach.performIteration(Foreach.java:393) at org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:316) at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:175) at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72) at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:212) at

[Ben Robbins]

Long time since this was asked but we had a similar issue in our instance. The cause was that someone had deleted an issue which had a sub-task. The sub-task still existed and therefore caused any searches (or dashboards using search) which included this sub-task to throw the above error.

Anyone else coming across this error should attempt to isolate the problem using JQL to find which issue(s) are causing it. Following that, appropriate action can be taken (integrity checks etc) which should fix it.

[Naman Soni]

This problem came when we have deleted the records of jiraissue table. here jira incident id is created but it's not mapped with jira parent id. Mainly link is broken for this.

Resolution:

we have find the records in issuelink table where source column is blank for particular destination coulmn in issuelink table. 

we have inserted back all the records whose source is empty in issulink table from jiraissue backup table with the help of destination column in issuelink table. Then this problem is solved.

[Naman Soni]

how can I resolve this error? This is coming when I search for issues under issue tab in JIRA. I have tried following steps suggested in jira community

1. Restart Jira.

2. Integrity check that was giving 500 error.

can anyone tell how to solve this