Re-index fails due to ClassCastException for Timestamp types

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

A JIRA administrator is unable to run a re-index due to ClassCastException. The following appears in the atlassian-jira.log:

java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.ClassCastException: java.sql.Timestamp cannot be cast to java.lang.String
at com.atlassian.jira.index.FutureResult.await(FutureResult.java:35)
at com.atlassian.jira.index.CompositeResultBuilder$CompositeResult.await(CompositeResultBuilder.java:82)
at com.atlassian.jira.issue.index.DefaultIndexManager.reIndexAll(DefaultIndexManager.java:286)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.atlassian.util.profiling.object.ObjectProfiler.profiledInvoke(ObjectProfiler.java:81)
at com.atlassian.jira.config.component.SwitchingInvocationHandler.invoke(SwitchingInvocationHandler.java:28)
...
Caused by: java.lang.ClassCastException: java.sql.Timestamp cannot be cast to java.lang.String
at com.atlassian.jira.issue.index.indexers.impl.ExactTextCustomFieldIndexer.addDocumentFields(ExactTextCustomFieldIndexer.java:45)
at com.atlassian.jira.issue.index.indexers.impl.ExactTextCustomFieldIndexer.addDocumentFieldsSearchable(ExactTextCustomFieldIndexer.java:29)
at com.atlassian.jira.issue.index.indexers.impl.AbstractCustomFieldIndexer.addIndex(AbstractCustomFieldIndexer.java:46)
at com.atlassian.jira.issue.index.IssueDocument.getDocument(IssueDocument.java:40)

Cause

The Search Template specified for custom fields using Date Time type is invalid. This could be caused by either a manual database manipulation or an improper upgrade.

Resolution

  1. Go to Administration >> Custom Fields 
  2. Find the custom fields of Date Time type, edit them and select one of the available options at the Search Template drop-down.
  3. Repeat this process for each custom field using Date Time type.

 

Last modified on Mar 30, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.