Module:
BenAdmin
- Report
Item State:
Production Complete
- Closed
Issue Importance:
Must Have
On field selection 'No. of working hours per day which 'is not in use so this is creating incorrect database query, which is resulting to error in generating report. The issue was reported in WT-8744
clones
WT-8744
Michael Best- Error in pulling Report
Resolved
made changes -
14/Mar/17 11:09 AM
Issue Type
Support Activity
[ 10301
]
Bug
[ 1
]
Support Task Type
Customization
[ 11204
]
Workflow
WT_Support
[ 34527
]
WT_Defects
[ 34528
]
made changes -
14/Mar/17 11:09 AM
Assignee
Michelle Parker
[ michelle.parker
]
Prasanna Karlekar
[ prasanna
]
made changes -
05/Apr/17 11:51 AM
Assignee
Prasanna Karlekar
[ prasanna
]
Aditya Vishwakarma
[ aditya.vishwakarma
]
made changes -
05/Apr/17 12:21 PM
Description
Unable to pull report for client, received error message see attached
On field selection *'No. of working hours per day* which 'is not in use so this is creating incorrect database query, which is resulting to error in generating report.
made changes -
05/Apr/17 12:22 PM
Description
On field selection *'No. of working hours per day* which 'is not in use so this is creating incorrect database query, which is resulting to error in generating report.
On field selection *'No. of working hours per day* which 'is not in use so this is creating incorrect database query, which is resulting to error in generating report. The issue was reported in WT-8744
made changes -
12/Apr/17 07:30 AM
Item State
Parent values: Production Complete(10222)
Parent values: Development(10200)
made changes -
14/Apr/17 12:42 PM
Remaining Estimate
0h
[ 0
]
Time Spent
4h
[ 14400
]
Worklog Id
38356
[ 38356
]
made changes -
21/Apr/17 12:47 PM
Item State
Parent values: Development(10200)
Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
made changes -
21/Apr/17 12:48 PM
Assignee
Aditya Vishwakarma
[ aditya.vishwakarma
]
Rakesh Roy
[ rakeshr
]
made changes -
24/Apr/17 04:50 AM
Assignee
Rakesh Roy
[ rakeshr
]
Meghana Kulkarni
[ meghana.kulkarni
]
made changes -
24/Apr/17 05:51 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)
made changes -
24/Apr/17 06:24 AM
Production Due Date
27/Apr/2017
Stage Due Date
26/Apr/17
[ 2017-04-26
]
made changes -
24/Apr/17 08:12 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)
made changes -
24/Apr/17 08:12 AM
Time Spent
4.5h
[ 16200
]
7.5h
[ 27000
]
Worklog Id
40291
[ 40291
]
made changes -
26/Apr/17 08:58 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)
made changes -
26/Apr/17 09:15 AM
Item State
Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
made changes -
26/Apr/17 09:57 AM
Time Spent
8.75h
[ 31500
]
10.75h
[ 38700
]
Worklog Id
40917
[ 40917
]
made changes -
26/Apr/17 12:00 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)
made changes -
27/Apr/17 08:00 AM
Item State
Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
made changes -
27/Apr/17 08:18 AM
Item State
Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
Parent values: Production QA(10203)Level 1 values: In Testing(10218)
made changes -
27/Apr/17 10:38 AM
Time Spent
10.75h
[ 38700
]
12.25h
[ 44100
]
Worklog Id
41270
[ 41270
]
made changes -
27/Apr/17 12:50 PM
Item State
Parent values: Production QA(10203)Level 1 values: In Testing(10218)
Parent values: Production Complete(10222)Level 1 values: Closed(10223)
made changes -
27/Apr/17 12:51 PM
Assignee
Meghana Kulkarni
[ meghana.kulkarni
]
Michelle Parker
[ michelle.parker
]
Resolution
Fixed
[ 1
]
Status
Production Testing
[ 10202
]
Production Complete
[ 10028
]
made changes -
29/Aug/17 09:50 AM
Bug Severity
Low
[ 16703
]
Dev Due Date
20/Apr/2017
20/Apr/2017
Production Due Date
27/Apr/2017
27/Apr/2017
Stage Due Date
26/Apr/17
[ 2017-04-26
]
26/Apr/17
[ 2017-04-26
]
made changes -
04/Nov/17 06:36 AM
Environment_New
Production
[ 18442
]
Transition
Time In Source Status
Execution Times
Open
In Development
38d 2h 4m
1
In Development
In LB Testing
2d 16h 38m
1
In LB Testing
Stage Testing
2d 3h 24m
1
Stage Testing
In Production Testing
23h 2m
1
In Production Testing
Production Complete
4h 33m
1
{"report":{"apdex":1,"isInitial":true,"journeyId":"edea1b34-12d1-4ce0-962d-1fc716b75d52","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":771.7999999998137,"redirectCount":0,"resourceLoadedEnd":895.2999999998137,"resourceLoadedStart":223.19999999925494,"resourceTiming":[{"duration":128.30000000074506,"initiatorType":"link","name":"https://jira.workterra.net/s/3003653444a1e1a85555cab7dcfb3a21-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/css/_super/batch.css","startTime":223.19999999925494,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":223.19999999925494,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":351.5,"responseStart":0,"secureConnectionStart":0},{"duration":128,"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":223.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":223.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":351.5,"responseStart":0,"secureConnectionStart":0},{"duration":128,"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":223.59999999962747,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":223.59999999962747,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":351.59999999962747,"responseStart":0,"secureConnectionStart":0},{"duration":128.20000000018626,"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":223.59999999962747,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":223.59999999962747,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":351.79999999981374,"responseStart":0,"secureConnectionStart":0},{"duration":128.1000000005588,"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":223.69999999925494,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":223.69999999925494,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":351.79999999981374,"responseStart":0,"secureConnectionStart":0},{"duration":136.20000000018626,"initiatorType":"script","name":"https://jira.workterra.net/s/f2623af22c15df767ec6ff268ae0b8bd-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":223.8999999994412,"connectEnd":223.8999999994412,"connectStart":223.8999999994412,"domainLookupEnd":223.8999999994412,"domainLookupStart":223.8999999994412,"fetchStart":223.8999999994412,"redirectEnd":0,"redirectStart":0,"requestStart":223.8999999994412,"responseEnd":360.09999999962747,"responseStart":360.09999999962747,"secureConnectionStart":223.8999999994412},{"duration":155.8999999994412,"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":224,"connectEnd":224,"connectStart":224,"domainLookupEnd":224,"domainLookupStart":224,"fetchStart":224,"redirectEnd":0,"redirectStart":0,"requestStart":224,"responseEnd":379.8999999994412,"responseStart":379.8999999994412,"secureConnectionStart":224},{"duration":153.59999999962747,"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":224,"connectEnd":224,"connectStart":224,"domainLookupEnd":224,"domainLookupStart":224,"fetchStart":224,"redirectEnd":0,"redirectStart":0,"requestStart":224,"responseEnd":377.59999999962747,"responseStart":377.59999999962747,"secureConnectionStart":224},{"duration":156.1000000005588,"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":224.19999999925494,"connectEnd":224.19999999925494,"connectStart":224.19999999925494,"domainLookupEnd":224.19999999925494,"domainLookupStart":224.19999999925494,"fetchStart":224.19999999925494,"redirectEnd":0,"redirectStart":0,"requestStart":224.19999999925494,"responseEnd":380.29999999981374,"responseStart":380.29999999981374,"secureConnectionStart":224.19999999925494},{"duration":156.3999999994412,"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":224.29999999981374,"connectEnd":224.29999999981374,"connectStart":224.29999999981374,"domainLookupEnd":224.29999999981374,"domainLookupStart":224.29999999981374,"fetchStart":224.29999999981374,"redirectEnd":0,"redirectStart":0,"requestStart":224.29999999981374,"responseEnd":380.69999999925494,"responseStart":380.69999999925494,"secureConnectionStart":224.29999999981374},{"duration":156.6000000005588,"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":224.3999999994412,"connectEnd":224.3999999994412,"connectStart":224.3999999994412,"domainLookupEnd":224.3999999994412,"domainLookupStart":224.3999999994412,"fetchStart":224.3999999994412,"redirectEnd":0,"redirectStart":0,"requestStart":224.3999999994412,"responseEnd":381,"responseStart":381,"secureConnectionStart":224.3999999994412},{"duration":156.79999999981374,"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":224.5,"connectEnd":224.5,"connectStart":224.5,"domainLookupEnd":224.5,"domainLookupStart":224.5,"fetchStart":224.5,"redirectEnd":0,"redirectStart":0,"requestStart":224.5,"responseEnd":381.29999999981374,"responseStart":381.29999999981374,"secureConnectionStart":224.5},{"duration":157,"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":224.69999999925494,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":224.69999999925494,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":381.69999999925494,"responseStart":0,"secureConnectionStart":0},{"duration":157.29999999981374,"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":224.79999999981374,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":224.79999999981374,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":382.09999999962747,"responseStart":0,"secureConnectionStart":0},{"duration":156.8999999994412,"initiatorType":"script","name":"https://jira.workterra.net/rest/api/1.0/shortcuts/805012/ea6f30d2bfdc99578bb23f4a5bac3ecd/shortcuts.js?context=issuenavigation&context=issueaction","startTime":224.79999999981374,"connectEnd":224.79999999981374,"connectStart":224.79999999981374,"domainLookupEnd":224.79999999981374,"domainLookupStart":224.79999999981374,"fetchStart":224.79999999981374,"redirectEnd":0,"redirectStart":0,"requestStart":224.79999999981374,"responseEnd":381.69999999925494,"responseStart":381.69999999925494,"secureConnectionStart":224.79999999981374},{"duration":157.40000000037253,"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":224.8999999994412,"connectEnd":224.8999999994412,"connectStart":224.8999999994412,"domainLookupEnd":224.8999999994412,"domainLookupStart":224.8999999994412,"fetchStart":224.8999999994412,"redirectEnd":0,"redirectStart":0,"requestStart":224.8999999994412,"responseEnd":382.29999999981374,"responseStart":382.29999999981374,"secureConnectionStart":224.8999999994412},{"duration":505,"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":225.8999999994412,"connectEnd":225.8999999994412,"connectStart":225.8999999994412,"domainLookupEnd":225.8999999994412,"domainLookupStart":225.8999999994412,"fetchStart":225.8999999994412,"redirectEnd":0,"redirectStart":0,"requestStart":225.8999999994412,"responseEnd":730.8999999994412,"responseStart":730.8999999994412,"secureConnectionStart":225.8999999994412}],"threshold":1000,"fetchStart":1,"domainLookupStart":1,"domainLookupEnd":1,"connectStart":1,"connectEnd":1,"requestStart":13,"responseStart":208,"responseEnd":209,"domLoading":220,"domInteractive":958,"domContentLoadedEventStart":958,"domContentLoadedEventEnd":1027,"domComplete":1277,"loadEventStart":1277,"loadEventEnd":1279,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"a1c2cd4e74b844","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":171,"dbReadsTimeInMs":30,"dbConnsTimeInMs":37,"applicationHash":"156decd7d2b4272533aa6cefc8294af635e1da97","experiments":[]}}
Bug
Critical
WT-8744 Michael Best- Error in pulling Report
surender kumar (Inactive)
logged work - 14/Apr/17 12:42 PM 
Sheetal Bodhale (Inactive)
made changes -
Khandu Kshirsagar (Inactive)
made changes -
3C:
Concern:Error in pulling Report issue on field selection on field selection No. of working hours per day
Cause: No. of working hours per day field was pointing to the WorkedHoursPerweek which was same as No. of working hours per week hence make incorrect query.
Correction: correction made such that No. of working hours per day field will not appear on Standard Report and Dynamic Report in Employee Related Fields.
Impacted Areas:
Employee Related Fields in following Reports
Standard Report
Dynamic Report
Files effected:
LB/Database Objects/MasterCompanyDB/07_Data/397_
WT-4047_WTB_Repot_ModData_Fields.sqlTested below scenarios:
Employee Related Fields in following Reports
Standard Report
Dynamic Report