Type:
Bug
Status:
Closed
Priority:
Medium
Resolution:
Bug Fixed
Affects Version/s:
None
Fix Version/s:
None
Module:
BenAdmin
- Customization
Item State:
Stage QA
- Production Deployment on Hold
Sprint:
WT Sprint 36 - Bugs
Steps:-
1] Log onto LB site
2] Search and select For QA ASML For Hspl company
3] Click on View History on company level
4] Enter valid date range , select document type as Benefits and select Plandesign Eligibility Rules from Document Sub Type and click on Search button
Actual Result:-
Server error is displayed on click of Search button
Error Log is as below:-
ErrorID : 0
ErrorSource : ControllerAppTier.GetCollection->WORKTERRAControllerAppTier.GetData->CollectionManager.GetCollection->CompanyCollection.GetGlobalHistoryInformationCollection->CompanyCollection.CreateDataForGlobalHistory->CompanyCollection.CheckPageModification
ErrorMessage: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
Please find the attached screen shot it seems to be an issue with the date format
Venkatesh Pujari (Inactive)
made changes -
28/Aug/17 09:01 AM
Field
Original Value
New Value
Link
This issue blocks WT-10195
[ WT-10195
]
Venkatesh Pujari (Inactive)
made changes -
28/Aug/17 12:21 PM
Description
Steps:-
1] Log onto LB site
2] Search and select For QA ASML For Hspl company
3] Click on View History on company level
4] Enter valid date range , select document type as Benefits and select Plandesign Eligibility Rules from Document Sub Type and click on Search button
Actual Result:-
Server error is displayed on click of Search button
Error Log is as below:-
ErrorID : 0
ErrorSource : ControllerAppTier.GetCollection->WORKTERRAControllerAppTier.GetData->CollectionManager.GetCollection->CompanyCollection.GetGlobalHistoryInformationCollection->CompanyCollection.CreateDataForGlobalHistory->CompanyCollection.CheckPageModification
ErrorMessage: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
Steps:-
1] Log onto LB site
2] Search and select For QA ASML For Hspl company
3] Click on View History on company level
4] Enter valid date range , select document type as Benefits and select Plandesign Eligibility Rules from Document Sub Type and click on Search button
Actual Result:-
Server error is displayed on click of Search button
Error Log is as below:-
ErrorID : 0
ErrorSource : ControllerAppTier.GetCollection->WORKTERRAControllerAppTier.GetData->CollectionManager.GetCollection->CompanyCollection.GetGlobalHistoryInformationCollection->CompanyCollection.CreateDataForGlobalHistory->CompanyCollection.CheckPageModification
ErrorMessage: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
Please find the attached screen shot it seems to be an issue with the date format
Vishal Bajad (Inactive)
made changes -
06/Sep/17 02:33 PM
Remaining Estimate
0h
[ 0
]
Time Spent
2h
[ 7200
]
Worklog Id
77170
[ 77170
]
Vishal Bajad (Inactive)
made changes -
07/Sep/17 04:27 AM
Item State
Parent values: Development(10200)Level 1 values: Ready for Review(10208)
Original Estimate
0h
[ 0
]
Vishal Bajad (Inactive)
made changes -
07/Sep/17 04:28 AM
Code Reviewed By
Jaideep Vinchurkar
[ 11908
]
Dev Due Date
08/Sep/2017
Developer
Vishal Bajad
[ vishal.bajad
]
Vishal Bajad (Inactive)
made changes -
07/Sep/17 04:28 AM
Assignee
Vishal Bajad
[ vishal.bajad
]
Jaideep Vinchurkar
[ jaideep.vinchurkar
]
Jaideep Vinchurkar (Inactive)
made changes -
07/Sep/17 10:29 AM
Code Review Date
07/Sep/2017
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)
Sprint
WT Sprint 36 - Bugs
[ 84
]
Vishal Bajad (Inactive)
made changes -
07/Sep/17 02:11 PM
Time Spent
2.5h
[ 9000
]
4.5h
[ 16200
]
Worklog Id
77482
[ 77482
]
Khandu Kshirsagar (Inactive)
made changes -
08/Sep/17 10:45 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)
Vishal Bajad (Inactive)
made changes -
08/Sep/17 11:05 AM
Assignee
Vishal Bajad
[ vishal.bajad
]
Venkatesh Pujari
[ venkatesh.pujari
]
Venkatesh Pujari (Inactive)
made changes -
11/Sep/17 05:17 AM
Item State
Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
Parent values: LB QA(10201)Level 1 values: In Testing(10210)
Venkatesh Pujari (Inactive)
made changes -
11/Sep/17 11:11 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 -
18/Sep/17 07:17 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)
Venkatesh Pujari (Inactive)
made changes -
18/Sep/17 12:02 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)
Venkatesh Pujari (Inactive)
made changes -
18/Sep/17 12:07 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 -
25/Sep/17 02:43 PM
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:49 PM
Satya
made changes -
04/Nov/17 06:20 AM
Environment_New
LB
[ 18444
]
Venkatesh Pujari (Inactive)
made changes -
14/Mar/18 09:04 AM
Resolution
Bug Fixed
[ 10402
]
Status
Production Testing
[ 10202
]
Production Complete
[ 10028
]
Venkatesh Pujari (Inactive)
made changes -
14/Mar/18 09:04 AM
Time Spent
4h 40m
[ 16800
]
4h 50m
[ 17400
]
Worklog Id
108219
[ 108219
]
{"report":{"apdex":0.5,"isInitial":true,"journeyId":"87287876-40f6-4f8a-9ec9-57e7b4a0a456","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":1126.7000000476837,"redirectCount":0,"resourceLoadedEnd":810.6000001430511,"resourceLoadedStart":360.60000014305115,"resourceTiming":[{"duration":197.59999990463257,"initiatorType":"link","name":"https://jira.workterra.net/s/3003653444a1e1a85555cab7dcfb3a21-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/css/_super/batch.css","startTime":360.60000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":360.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":558.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":198.20000004768372,"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":361,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":361,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":559.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":198.5,"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":361.2000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":361.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":559.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":198.89999985694885,"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":361.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":361.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":560.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":199.40000009536743,"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":361.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":361.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":560.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":367.7999999523163,"initiatorType":"script","name":"https://jira.workterra.net/s/f2623af22c15df767ec6ff268ae0b8bd-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":361.60000014305115,"connectEnd":361.60000014305115,"connectStart":361.60000014305115,"domainLookupEnd":361.60000014305115,"domainLookupStart":361.60000014305115,"fetchStart":361.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":562.9000000953674,"responseEnd":729.4000000953674,"responseStart":625.1000001430511,"secureConnectionStart":361.60000014305115},{"duration":448,"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":362.60000014305115,"connectEnd":362.60000014305115,"connectStart":362.60000014305115,"domainLookupEnd":362.60000014305115,"domainLookupStart":362.60000014305115,"fetchStart":362.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":564.4000000953674,"responseEnd":810.6000001430511,"responseStart":656.3000001907349,"secureConnectionStart":362.60000014305115},{"duration":262.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":362.80000019073486,"connectEnd":362.80000019073486,"connectStart":362.80000019073486,"domainLookupEnd":362.80000019073486,"domainLookupStart":362.80000019073486,"fetchStart":362.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":564.5,"responseEnd":624.9000000953674,"responseStart":624.3000001907349,"secureConnectionStart":362.80000019073486},{"duration":288.19999980926514,"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":362.80000019073486,"connectEnd":362.80000019073486,"connectStart":362.80000019073486,"domainLookupEnd":362.80000019073486,"domainLookupStart":362.80000019073486,"fetchStart":362.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":568.3000001907349,"responseEnd":651,"responseStart":650.5,"secureConnectionStart":362.80000019073486},{"duration":288.7000000476837,"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":363,"connectEnd":363,"connectStart":363,"domainLookupEnd":363,"domainLookupStart":363,"fetchStart":363,"redirectEnd":0,"redirectStart":0,"requestStart":569.2000000476837,"responseEnd":651.7000000476837,"responseStart":651.2000000476837,"secureConnectionStart":363},{"duration":290.7999999523163,"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":363.10000014305115,"connectEnd":363.10000014305115,"connectStart":363.10000014305115,"domainLookupEnd":363.10000014305115,"domainLookupStart":363.10000014305115,"fetchStart":363.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":570.3000001907349,"responseEnd":653.9000000953674,"responseStart":653.4000000953674,"secureConnectionStart":363.10000014305115},{"duration":291.2999999523163,"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":363.2000000476837,"connectEnd":363.2000000476837,"connectStart":363.2000000476837,"domainLookupEnd":363.2000000476837,"domainLookupStart":363.2000000476837,"fetchStart":363.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":571.7000000476837,"responseEnd":654.5,"responseStart":654,"secureConnectionStart":363.2000000476837},{"duration":207.19999980926514,"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":363.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":363.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":570.5,"responseStart":0,"secureConnectionStart":0},{"duration":295.09999990463257,"initiatorType":"script","name":"https://jira.workterra.net/rest/api/1.0/shortcuts/805012/81da1c7492d7ee698ae1cc31902498d9/shortcuts.js?context=issuenavigation&context=issueaction","startTime":363.40000009536743,"connectEnd":363.40000009536743,"connectStart":363.40000009536743,"domainLookupEnd":363.40000009536743,"domainLookupStart":363.40000009536743,"fetchStart":363.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":573,"responseEnd":658.5,"responseStart":657.9000000953674,"secureConnectionStart":363.40000009536743},{"duration":208.5,"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":363.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":363.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":572,"responseStart":0,"secureConnectionStart":0},{"duration":326.7000000476837,"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":363.60000014305115,"connectEnd":363.60000014305115,"connectStart":363.60000014305115,"domainLookupEnd":363.60000014305115,"domainLookupStart":363.60000014305115,"fetchStart":363.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":576.3000001907349,"responseEnd":690.3000001907349,"responseStart":689.6000001430511,"secureConnectionStart":363.60000014305115},{"duration":440,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":364.40000009536743,"connectEnd":364.40000009536743,"connectStart":364.40000009536743,"domainLookupEnd":364.40000009536743,"domainLookupStart":364.40000009536743,"fetchStart":364.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":740.2000000476837,"responseEnd":804.4000000953674,"responseStart":803.8000001907349,"secureConnectionStart":364.40000009536743},{"duration":408.59999990463257,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":396.40000009536743,"connectEnd":396.40000009536743,"connectStart":396.40000009536743,"domainLookupEnd":396.40000009536743,"domainLookupStart":396.40000009536743,"fetchStart":396.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":740.6000001430511,"responseEnd":805,"responseStart":804.5,"secureConnectionStart":396.40000009536743}],"threshold":1000,"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":118,"responseStart":324,"responseEnd":396,"domLoading":327,"domInteractive":1238,"domContentLoadedEventStart":1238,"domContentLoadedEventEnd":1306,"domComplete":1630,"loadEventStart":1630,"loadEventEnd":1632,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"b045a65eed3365","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":155,"dbReadsTimeInMs":46,"dbConnsTimeInMs":50,"applicationHash":"156decd7d2b4272533aa6cefc8294af635e1da97","experiments":[]}}