Type:
Bug
Status:
Closed
Priority:
Critical
Resolution:
Done
Affects Version/s:
None
Fix Version/s:
None
Item State:
Production Complete
- Closed
Issue Importance:
Must Have
Sprint:
WT Sprint 34-Bugs
Hi Vinayak Kulkarni ,
After copying City Of Durham Company again from production to LB today,We observed that after creating event builder rule for MEDICARE we are getting below error while changing Employee Demographics data such as date of Birth , Status etc :-
Error LOG->
ErrorID : 0
ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->Employee.Save->Employee.UpdateEmployeeChangeStatus->EventBuilderRuleEngine.UpdateEventBuilderRuleEngineFromCriteria
ErrorMessage: Conversion failed when converting character string to smalldatetime data type.
NOTE : we are able to change employee data successfully after deleting MEDICARE event builder rule.
Can you please look into this , as we are blocked to test actual scenarios for which implementation is done.
CC-Aniruddha Dev Hrishikesh Deshpande
is caused by
WT-8875
City of Durham > HR Simplified COBRA > Custom Event > Dependents of Retirees Turning 65
Closed
Swapnil Eksambekar (Inactive)
made changes -
27/Apr/17 01:56 PM
Comment
[ We are unable to create medicare event scenarios . Due to this event builder for which WT-9346 is created. Can you please look into this , as we are blocked to test actual scenarios for which implementation is done ?
]
Vinayak Kulkarni (Inactive)
made changes -
27/Apr/17 02:27 PM
Assignee
Vinayak Kulkarni
[ vinayak.kulkarni
]
Swapnil Eksambekar
[ swapnil.eksambekar
]
Hrishikesh Deshpande (Inactive)
made changes -
28/Apr/17 09:32 AM
Module
Parent values: BenAdmin(10100)Level 1 values: Export(10110)
Parent values: BenAdmin(10100)Level 1 values: EDS(10108)
Satya
made changes -
29/Jun/17 07:17 AM
Status
Reopen in Production
[ 10027
]
In Development
[ 10007
]
Satya
made changes -
29/Jun/17 07:17 AM
Item State
Parent values: Development(10200)Level 1 values: Development Backlog(10205)
Sheetal Bodhale (Inactive)
made changes -
12/Jul/17 01:05 PM
Assignee
Sheetal Bodhale
[ sheetal.bodhale
]
Jyotibala Pardeshi
[ jyotibala
]
Sheetal Bodhale (Inactive)
made changes -
03/Aug/17 05:28 AM
Assignee
Jyotibala Pardeshi
[ jyotibala
]
Akshay Mukkawar
[ akshay.mukkawar
]
Akshay Mukkawar (Inactive)
made changes -
03/Aug/17 05:37 AM
Developer
Sheetal Bodhale
[ sheetal.bodhale
]
Akshay Mukkawar
[ akshay.mukkawar
]
Akshay Mukkawar (Inactive)
made changes -
09/Aug/17 12:37 PM
Item State
Parent values: Development(10200)Level 1 values: Development Backlog(10205)
Parent values: Development(10200)Level 1 values: In Progress(10206)
Akshay Mukkawar (Inactive)
made changes -
10/Aug/17 04:41 AM
Remaining Estimate
0h
[ 0
]
Time Spent
5h
[ 18000
]
Worklog Id
70660
[ 70660
]
Akshay Mukkawar (Inactive)
made changes -
10/Aug/17 06:29 AM
Item State
Parent values: Development(10200)Level 1 values: In Progress(10206)
Parent values: Development(10200)Level 1 values: Ready for Review(10208)
Original Estimate
0h
[ 0
]
Akshay Mukkawar (Inactive)
made changes -
10/Aug/17 12:03 PM
Item State
Parent values: Development(10200)Level 1 values: Ready for Review(10208)
Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
Khandu Kshirsagar (Inactive)
made changes -
11/Aug/17 05:54 AM
Item State
Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
Akshay Mukkawar (Inactive)
made changes -
11/Aug/17 06:37 AM
Assignee
Akshay Mukkawar
[ akshay.mukkawar
]
Swapnil Eksambekar
[ swapnil.eksambekar
]
Sheetal Bodhale (Inactive)
made changes -
11/Aug/17 07:28 AM
Time Spent
8h 20m
[ 30000
]
10h 20m
[ 37200
]
Worklog Id
71029
[ 71029
]
Swapnil Eksambekar (Inactive)
made changes -
27/Sep/17 02:24 PM
Item State
Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
Parent values: LB QA(10201)Level 1 values: In Testing(10210)
Swapnil Eksambekar (Inactive)
made changes -
03/Oct/17 09:16 AM
Item State
Parent values: LB QA(10201)Level 1 values: In Testing(10210)
Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
Khandu Kshirsagar (Inactive)
made changes -
10/Oct/17 06:23 AM
Item State
Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
Swapnil Eksambekar (Inactive)
made changes -
10/Oct/17 12:42 PM
Item State
Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
Rakesh Roy (Inactive)
made changes -
12/Oct/17 07:13 AM
Status
Local Testing
[ 10200
]
Stage Testing
[ 10201
]
Swapnil Eksambekar (Inactive)
made changes -
13/Oct/17 12:49 PM
Item State
Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
Rakesh Roy (Inactive)
made changes -
17/Oct/17 11:17 AM
Item State
Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
Satya
made changes -
01/Nov/17 11:45 PM
Satya
made changes -
04/Nov/17 06:19 AM
Environment_New
LB
[ 18444
]
Rakesh Roy (Inactive)
made changes -
02/Feb/18 08:58 AM
Status
Stage Testing
[ 10201
]
Production Testing
[ 10202
]
Rakesh Roy (Inactive)
made changes -
02/Feb/18 08:58 AM
Resolution
System Behaviour
[ 10100
]
Done
[ 10000
]
Status
Production Testing
[ 10202
]
Production Complete
[ 10028
]
Rakesh Roy (Inactive)
made changes -
02/Feb/18 08:59 AM
Resolution
Done
[ 10000
]
Fixed
[ 1
]
Status
Production Complete
[ 10028
]
Closed
[ 6
]
Rakesh Roy (Inactive)
made changes -
02/Feb/18 08:59 AM
Item State
Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
Parent values: Production Complete(10222)Level 1 values: Closed(10223)
Amit Kumawat (Inactive)
made changes -
20/Mar/18 12:55 PM
Time Spent
14h 50m
[ 53400
]
15h 50m
[ 57000
]
Worklog Id
109092
[ 109092
]
Transition
Time In Source Status
Execution Times
Open
In Development
16h 29m
1
In Development
Rejected
17s
1
Rejected
Closed
3s
1
Closed
Reopen in Production
3h 9m
1
Satya
made transition
-
29/Jun/17 07:17 AM
Reopen in Production
In Development
61d 21h 44m
1
In Development
In LB Testing
96d 2h 2m
1
In LB Testing
Stage Testing
8d 21h 53m
1
Stage Testing
In Production Testing
113d 2h 45m
1
In Production Testing
Production Complete
33s
1
Production Complete
Closed
4s
1
{"report":{"apdex":0.5,"isInitial":true,"journeyId":"5c3c19d3-8681-4300-b10b-220a4369e821","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":1031.0999999046326,"redirectCount":0,"resourceLoadedEnd":1045.3000001907349,"resourceLoadedStart":313.80000019073486,"resourceTiming":[{"duration":292,"initiatorType":"link","name":"https://jira.workterra.net/s/3003653444a1e1a85555cab7dcfb3a21-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/css/_super/batch.css","startTime":313.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":313.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":605.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":291.90000009536743,"initiatorType":"link","name":"https://jira.workterra.net/s/dd6a0911920485696ac20493290df627-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/3abe50d469404b639745df44b51476b6/_/download/contextbatch/css/jira.browse.project,jira.view.issue,project.issue.navigator,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&richediton=true","startTime":314.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":314.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":606,"responseStart":0,"secureConnectionStart":0},{"duration":291.80000019073486,"initiatorType":"link","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/8.5.0/_/download/batch/com.atlassian.auiplugin:split_aui.pattern.label/com.atlassian.auiplugin:split_aui.pattern.label.css","startTime":314.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":314.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":606,"responseStart":0,"secureConnectionStart":0},{"duration":291.8999996185303,"initiatorType":"link","name":"https://jira.workterra.net/s/bd548f27bbf8f278bd83b60dd3284ed8-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:global-static-adgs/jira.webresources:global-static-adgs.css","startTime":314.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":314.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":606.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":291.7999997138977,"initiatorType":"link","name":"https://jira.workterra.net/s/70725731a158a7140f19ddbd4201ba27-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:global-static/jira.webresources:global-static.css","startTime":314.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":314.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":606.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":300.5,"initiatorType":"script","name":"https://jira.workterra.net/s/f2623af22c15df767ec6ff268ae0b8bd-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":314.5,"connectEnd":314.5,"connectStart":314.5,"domainLookupEnd":314.5,"domainLookupStart":314.5,"fetchStart":314.5,"redirectEnd":0,"redirectStart":0,"requestStart":314.5,"responseEnd":615,"responseStart":615,"secureConnectionStart":314.5},{"duration":318.59999990463257,"initiatorType":"script","name":"https://jira.workterra.net/s/6ce676f2a5bcc9651cef6e7956f05def-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/3abe50d469404b639745df44b51476b6/_/download/contextbatch/js/jira.browse.project,jira.view.issue,project.issue.navigator,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":314.59999990463257,"connectEnd":314.59999990463257,"connectStart":314.59999990463257,"domainLookupEnd":314.59999990463257,"domainLookupStart":314.59999990463257,"fetchStart":314.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":314.59999990463257,"responseEnd":633.1999998092651,"responseStart":633.1999998092651,"secureConnectionStart":314.59999990463257},{"duration":321.09999990463257,"initiatorType":"script","name":"https://jira.workterra.net/s/ecf7ec549751ae117b778f0525d6d371-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/4.1.5/_/download/resources/com.atlassian.plugins.atlassian-chaperone:hotspot-tour/hotspot-tour.js?batch=false&locale=en-US","startTime":314.80000019073486,"connectEnd":314.80000019073486,"connectStart":314.80000019073486,"domainLookupEnd":314.80000019073486,"domainLookupStart":314.80000019073486,"fetchStart":314.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":314.80000019073486,"responseEnd":635.9000000953674,"responseStart":635.9000000953674,"secureConnectionStart":314.80000019073486},{"duration":321.5,"initiatorType":"script","name":"https://jira.workterra.net/s/6aa3fcf1fac5fd551eee0b69077524e6-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/aae1242f5fc81cc6a5bb8bc963ccda29/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en-US","startTime":314.80000019073486,"connectEnd":314.80000019073486,"connectStart":314.80000019073486,"domainLookupEnd":314.80000019073486,"domainLookupStart":314.80000019073486,"fetchStart":314.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":314.80000019073486,"responseEnd":636.3000001907349,"responseStart":636.3000001907349,"secureConnectionStart":314.80000019073486},{"duration":321.90000009536743,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":314.90000009536743,"connectEnd":314.90000009536743,"connectStart":314.90000009536743,"domainLookupEnd":314.90000009536743,"domainLookupStart":314.90000009536743,"fetchStart":314.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":314.90000009536743,"responseEnd":636.8000001907349,"responseStart":636.8000001907349,"secureConnectionStart":314.90000009536743},{"duration":322,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":315.19999980926514,"connectEnd":315.19999980926514,"connectStart":315.19999980926514,"domainLookupEnd":315.19999980926514,"domainLookupStart":315.19999980926514,"fetchStart":315.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":315.19999980926514,"responseEnd":637.1999998092651,"responseStart":637.1999998092651,"secureConnectionStart":315.19999980926514},{"duration":322.5,"initiatorType":"script","name":"https://jira.workterra.net/s/ecf7ec549751ae117b778f0525d6d371-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/8.5.0/_/download/batch/com.atlassian.auiplugin:split_aui.pattern.label/com.atlassian.auiplugin:split_aui.pattern.label.js?locale=en-US","startTime":315.19999980926514,"connectEnd":315.19999980926514,"connectStart":315.19999980926514,"domainLookupEnd":315.19999980926514,"domainLookupStart":315.19999980926514,"fetchStart":315.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":315.19999980926514,"responseEnd":637.6999998092651,"responseStart":637.6999998092651,"secureConnectionStart":315.19999980926514},{"duration":323,"initiatorType":"link","name":"https://jira.workterra.net/s/05c862146699bb029ceb0a489075e63b-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/bcd66e9a133a1b9f5fd14b56841e1c5b/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":315.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":315.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":638.3000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":322.69999980926514,"initiatorType":"script","name":"https://jira.workterra.net/rest/api/1.0/shortcuts/805012/81da1c7492d7ee698ae1cc31902498d9/shortcuts.js?context=issuenavigation&context=issueaction","startTime":315.5,"connectEnd":315.5,"connectStart":315.5,"domainLookupEnd":315.5,"domainLookupStart":315.5,"fetchStart":315.5,"redirectEnd":0,"redirectStart":0,"requestStart":315.5,"responseEnd":638.1999998092651,"responseStart":638.1999998092651,"secureConnectionStart":315.5},{"duration":323.30000019073486,"initiatorType":"link","name":"https://jira.workterra.net/s/9095228fa10daa2d3e3d7d5760c95e91-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/72477c22780abda5f51fe696920d843f/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.css?jira.create.linked.issue=true&richediton=true","startTime":315.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":315.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":638.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":323.30000019073486,"initiatorType":"script","name":"https://jira.workterra.net/s/c19a1b46e985d7fb85efaf27c8febfdd-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/72477c22780abda5f51fe696920d843f/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":315.69999980926514,"connectEnd":315.69999980926514,"connectStart":315.69999980926514,"domainLookupEnd":315.69999980926514,"domainLookupStart":315.69999980926514,"fetchStart":315.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":315.69999980926514,"responseEnd":639,"responseStart":639,"secureConnectionStart":315.69999980926514}],"threshold":1000,"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":51,"responseStart":306,"responseEnd":322,"domLoading":310,"domInteractive":1142,"domContentLoadedEventStart":1143,"domContentLoadedEventEnd":1238,"domComplete":2120,"loadEventStart":2120,"loadEventEnd":2122,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"5eacde7ccc8e08","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":251,"dbReadsTimeInMs":37,"dbConnsTimeInMs":42,"applicationHash":"156decd7d2b4272533aa6cefc8294af635e1da97","experiments":[]}}
Hi Swapnil,
As we checked, In the event builder, it was configured with Employee.Age which is why it was giving error as Employee.age is actually date of birth and while comparing date of birth with Number 66 it gave error.
And we should use only "Age" macro in event builder for this scenario. There should not be Employee.age for date of birth, please update summary of this jira and assign to respective team to change its label.
We have now modified event builder and it is working properly. Thanks.