Details
-
Bug
-
Resolution: Obsolete
-
Medium
-
None
-
3.6.3
-
Jira 3.6.3 Professional Standalone
JDK 1.4.2_05
Windows Server 2003
JIRA Charting Plugin
-
3.06
-
Description
Example:
- In my issue navigator I have a closed issue (Closed export.jpg)
- I press All fields and get a fine export to Excel (Closed Excel.jpg)
- I reopen the issue (Reopened export.jpg)
- Again, I press All fields and now I get an error in Excel (Reopened Excel.jpg)
I have found this problem in several projects and it is always related to an issue with status Reopened. However, it is not caused by all issues in with this status.
An error occurred whilst rendering this message. Please contact the administrators, and inform them of this bug. Details: ------- com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, ISSUE, CUSTOMFIELD, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE FROM customfieldvalue WHERE ISSUE=? AND CUSTOMFIELD=? AND TEXTVALUE=? (The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByAnd(DefaultOfBizDelegator.java:38) at com.atlassian.jira.issue.customfields.persistence.OfBizCustomFieldValuePersister.removeValue(OfBizCustomFieldValuePersister.java:152) at com.atlassian.jira.issue.customfields.persistence.EagerLoadingOfBizCustomFieldPersister.removeValue(EagerLoadingOfBizCustomFieldPersister.java:60) at com.atlassian.jira.ext.charting.field.TimeInStatusCFType.clearDatabaseValue(TimeInStatusCFType.java:83) at com.atlassian.jira.ext.charting.field.TimeInStatusCFType.getValueFromIssue(TimeInStatusCFType.java:63) at com.atlassian.jira.issue.fields.CustomFieldImpl.getValue(CustomFieldImpl.java:212) at com.atlassian.jira.issue.DocumentIssueImpl.getCustomFieldValue(DocumentIssueImpl.java:216) at com.atlassian.jira.issue.fields.CustomFieldImpl.getRendererCustomFieldValue(CustomFieldImpl.java:594) at com.atlassian.jira.issue.fields.CustomFieldImpl.getColumnViewHtml(CustomFieldImpl.java:581) at com.atlassian.jira.issue.fields.layout.column.ColumnLayoutItemImpl.getHtml(ColumnLayoutItemImpl.java:104) at sun.reflect.GeneratedMethodAccessor569.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267) at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197) at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175) at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220) at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:55) at org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:166) at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114) at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230) at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:172) at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114) at