I've put in a place an automatic rule that where a date custom field takes (start date) the value of another date field (Sprint Start Date). I've been getting this error:
BDDN-265 (Error parsing date string: Fri Sep 18 18:00:00 CEST 2020 (customfield_11603), Error parsing date string: Mon Sep 07 08:00:00 CEST 2020 (customfield_11602), Error parsing date string: Fri Sep 18 18:00:00 CEST 2020 (customfield_11605), Error parsing date string: Mon Sep 07 08:00:00 CEST 2020 (customfield_11604))
Our Jira is configured in french and I suspect it has something to do with that. Any idea how I can fix this?
Here's the rule (in french) and its translation below:
The translation :
When : the value of the Sprint field changes
If : Sprint is in openSprints() (JQL request)
If : Epic Link is different than "Formations2020"
And : "Due Date" is NULL
And : date of issue creation is less than Sprint Start Date
Then : Modify the value of the following fields :
Baseline start date takes the value of Sprint Start Date
Start date takes the value of Sprint Start Date
Baseline end date takes the value of Sprint End Date
End Date takes the value of Sprint End Date
Else-if : date of issue creation is greater than Sprint Start Date
And : "Due Date" is NULL
Then: Modify the value of the following fields :
Baseline end date takes the value of Sprint End Date
End Date takes the value of Sprint End Date
Else-if : "Due Date" is not NULL
Then: Modify the value of the following fields :
Baseline end date takes the value of "Due Date"
End Date takes the value of "Due Date"
[End of Rule]
The result of the audit log:
I think I may have found a solution: ending every date with ".jiraDate" ( ex. {{sprint.startDate.jiraDate}} ). I gave it a try yesterday and it worked. I'll see if if doesn't bring any errors in the following days, but normally this should work.
Give it a try @Matt Hewitt and let me if it works for you too.
Perfect! That solved my problem! Thank you so much!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What if a issue is spilled over to next sprint? the {{issue.Sprint.endDate.jiraDate}} is taking the Sprint end date of previous Sprint End Date.
How to get value of Current/ Active Sprint End date value?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Iana - Welcome to the Atlassian Community!
Can you share the rule that you have so far?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The translation :
When : the value of the Sprint field changes
If : Sprint is in openSprints() (JQL request)
If : Epic Link is different than "Formations2020"
And : "Due Date" is NULL
And : date of issue creation is less than Sprint Start Date
Then : Modify the value of the following fields :
Baseline start date takes the value of Sprint Start Date
Start date takes the value of Sprint Start Date
Baseline end date takes the value of Sprint End Date
End Date takes the value of Sprint End Date
Else-if : date of issue creation is greater than Sprint Start Date
And : "Due Date" is NULL
Then: Modify the value of the following fields :
Baseline end date takes the value of Sprint End Date
End Date takes the value of Sprint End Date
Else-if : "Due Date" is not NULL
Then: Modify the value of the following fields :
Baseline end date takes the value of "Due Date"
End Date takes the value of "Due Date"
[End of Rule]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks! One more share - can you show the value of one of the Alors details?
I am suspicious about the CEST being in the middle of your date that is being parsed. I believe that is what is causing it to error out.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
try using this and see if it helps:
{{sprint.startDate.shortDate}} where you add .shortDate to each smart value.
I really think there is a bug.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Will do. BTW, I should have mentioned, this rule used to work perfectly. But I updated the Automation plug-in at the beginning of this week and it is since then that it started bugging.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What did you change about the rule from when it was working?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I changed the trigger. It used to be At the beginning of every sprint and then applied a branch rule to all issues in the sprint. But that didn't take into account issues that were created (or added to the sprint) after the beginning of the sprint. I also added the if sprint is not empty condition and the sprint is in opensprints() JQL query. I didn't change anything in the Alors details. They were set in the exact same way since I created the rule.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It might have introduced the error due to a but with the dates getting applied under teh branch.
Give the shortDate a try and if it fails, you should open a support ticket.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I've tested and it still doesn't work. It still doesn't recognize the date despite the change to short form. Below the error:
PTD-10 (Error parsing date string: 8/7/20 (customfield_11603), Error parsing date string: 7/31/20 (customfield_11602), Error parsing date string: 8/7/20 (customfield_11605), Error parsing date string: 7/31/20 (customfield_11604))
I'll open a support ticket. Thanks for your help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Iana: I've encountered same issue with Error parsing data string.
If you don't mind sharing, what is the support ticket status on resolution?
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Iana - You haven't received an initial response from support? When did you submit it?
Can you share the support id?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @John Funk ,
Besides the automatic response confirming the support ticket was registered, none.
Here's the support id: GHS-200779
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks - when did you initially submit it?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello there @Iana and @John Funk !
I reached out to our internal teams and they have been facing a severe overload of tickets for the past few days. I made sure that they are aware of your ticket @Iana and they will surely look into it.
Thanks for reporting this for us.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I think I may have found a solution: ending every date with ".jiraDate" ( ex. {{sprint.startDate.jiraDate}} ). I gave it a try yesterday and it worked. I'll see if if doesn't bring any errors in the following days, but normally this should work.
Give it a try @Matt Hewitt and let me if it works for you too.
Thanks for your help @John Funk and @Diego .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.