I'm getting lots of errors on Calculated fields

When I reindex my JIRA 6.0.8 instance, I get a lot of ERRORS like:

 getCustomFieldValue called from script: No field with ID or name Date of Detection

 

I've used the "getCustomFieldValue" functions, but it looks it is actually throwing an exception during the reindex...

Here is an example:

return getCustomFieldValue("Date of Detection")?.format("yyyy-MM");

 

What is wrong with this code?  I've have other more elaborated examples which fail the same.

 

 

7 answers

Have you tried simply using the customfield ID as opposed to the name? 

I generally do it this way:

customFieldManager.getCustomFieldObject("customfield_11212");

Also, what are you trying to do here? Sum dates? I'd be interested in seeing your entire scripted field code if possible.

Hi there, thanks for the advise.  I would assume that I would have to use  getValue(this) to get the issue value.

 

for the specific example I'm returning the "Date of Detection" with format yyyy-MM

 

There is another case where I read another date "Incident Open", and mix it with the specified Severity to determine an estimated resolution date.

 

This also fails, the same, the field cannot be found.... 

 

I'd check out what Nic said below, that's definitely something to take into account if the field can't be found by the scripted or calculated field.

0 vote

My guess is that your "Date of Detection" field has a context that is limited to certain project/issue types, but your calculated fields are less limited.

You will get this error every time your calculated field tries to access a field that does not exist at all for the issue being indexed.  

You can either trap it by wrapping an "if field exists" type statement, or limit your calculated field to the same issue types and projects the date of detection field exists on.

Hi Nic/Andrew, if the field context was the problem, it wouldn't work at all in the UI. The fields work perfectly and show the return data as expected in the UI for each issue they are configure for..

 

The problem is the searcher, it is not working at all.

 BTW, I did try to catch the exception

try {
   def  dateOpen =  getCustomFieldValue("Incident Open")
} catch (Exception ex) {
}

 Still the error shows in the logs, looks like it is somethign internal to the "CustomFieldValue" method.

I've only every seen that error when the source data field does not exist for the current issue.

Thinking about it. it may be that the Reindex is trying to run the Scripted Field for every single Issue, and of course not all of them have the "Incident Open" field available...... that may be the problem... still the only alternative is to select no searcher.

Ahh, sorry, yes, that's what I was getting at - it will try to run it for every issue that it's valid for. Removing the searcher is one way to fix it, but limiting the calculated field context to the same issues as the source-data fields are for should also fix it (and retain the ability to search and sort by the calculated fields)

Switching user as I got blocked.

Yes, but here is the deal....  the Fields are actually (all of them) limited to Issue Type Incident and Project X.

Also, the Project X has about 100 issues submitted (all Incidents)

Finally, the log generates 100,000 +  ERROR messages  when reindexing the instance of 180,000+ issues.... This makes think the problem is that for some reason the context is not being respected, so I the only altearantive is to select no searcher. Any Ideas?

Any clue!? 

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,345 views 14 20
Join discussion

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot