-
Type:
Bug
-
Status: Closed
-
Priority:
Medium
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Environment:QA
-
Bug Severity:Medium
-
Module:BenAdmin - Report
-
Reported by:Harbinger
-
Item State:Production Complete - Closed
-
Issue Importance:Must Have
Replication Steps :
1) Create one System Utilization report
2) Map Employee Effective Date and Emergency Contact Effective Date
3) Run Report
Throws error on report running:
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
- relates to
-
WT-7867 Employee effective date to expose on report
-
- Closed
-
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Vijay Siddha [ vijays ] | surender kumar [ surender.kumar ] |
| Assignee | surender kumar [ surender.kumar ] | Parmeshwar Jumbad [ parmeshwar.jumbade ] |
| Status | Open [ 1 ] | In Development [ 10007 ] |
| Dev Due Date | 31/May/2017 |
Parmeshwar Jumbad (Inactive)
logged work - 29/May/17 11:59 AM -
- Time Spent:
- 3.5h
-
1. Understand problem and reproduce issue
2. Find out cause of issue
-
- Time Spent:
- 1h
-
Issue discussion
Server error on saving standard reports
Discussion on fix to be done
Parmeshwar Jumbad (Inactive)
made changes -
| Remaining Estimate | 0h [ 0 ] | |
| Time Spent | 3.5h [ 12600 ] | |
| Worklog Id | 50398 [ 50398 ] |
| Time Spent | 3.5h [ 12600 ] | 4.5h [ 16200 ] |
| Worklog Id | 50462 [ 50462 ] |
Parmeshwar Jumbad (Inactive)
logged work - 30/May/17 12:45 PM -
- Time Spent:
- 8h
-
Fix issue
Discussion on fix to be done
Issue discussion
Server error on saving standard reports
Unit testing for all fields
Parmeshwar Jumbad (Inactive)
made changes -
| Time Spent | 4.5h [ 16200 ] | 12.5h [ 45000 ] |
| Worklog Id | 50543 [ 50543 ] |
-
- Time Spent:
- 0.75h
-
Discussion on changes done
Discussion on issues related to field selections for System Utilization report
| Time Spent | 12.5h [ 45000 ] | 13.25h [ 47700 ] |
| Worklog Id | 51123 [ 51123 ] |
| Time Spent | 13.25h [ 47700 ] | 13.75h [ 49500 ] |
| Worklog Id | 51135 [ 51135 ] |
Parmeshwar Jumbad (Inactive)
logged work - 31/May/17 12:11 PM -
- Time Spent:
- 5.75h
-
Discussion on changes done
Discussion on issues related to field selections for System Utilization report
Changes and Unit testing of fields selection with different combinations
Code review
R&D of how to call Remote UDF from select statement
Parmeshwar Jumbad (Inactive)
made changes -
| Time Spent | 13.75h [ 49500 ] | 19.5h [ 70200 ] |
| Worklog Id | 51147 [ 51147 ] |
-
- Time Spent:
- 0.5h
-
Discussion on fix done
Code review
Parmeshwar Jumbad (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | |
| Original Estimate | 0h [ 0 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) |
Parmeshwar Jumbad (Inactive)
made changes -
| Code Review Date | 01/Jun/2017 | |
| Code Reviewed By | Prasanna Karlekar [ 11907 ] |
Khandu Kshirsagar (Inactive)
made changes -
| 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) |
Parmeshwar Jumbad (Inactive)
made changes -
| Assignee | Parmeshwar Jumbad [ parmeshwar.jumbade ] | Sachin Hingole [ sachin.hingole ] |
Parmeshwar Jumbad (Inactive)
logged work - 01/Jun/17 12:34 PM -
- Time Spent:
- 0.75h
-
Check-In in trunk and LB branch
Task marked to local Testing
Parmeshwar Jumbad (Inactive)
made changes -
| Time Spent | 19.5h [ 70200 ] | 20.25h [ 72900 ] |
| Worklog Id | 51689 [ 51689 ] |
-
- Time Spent:
- 1h
-
- Functionality review
- Discussion and analysis on fields which use UDF for which server error appears on report
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Assignee | Sachin Hingole [ sachin.hingole ] | Sanjana Jadhav [ sanjana.jadhav ] |
| Stage Due Date | 14/Jun/17 [ 2017-06-14 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
| Attachment | wt-9020.png [ 51936 ] |
| 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) |
| Time Spent | 20.25h [ 72900 ] | 21.05h [ 75780 ] |
| Worklog Id | 54794 [ 54794 ] |
| Worklog Id | 54794 [ 54794 ] |
| Time Spent | 21.05h [ 75780 ] | 22.05h [ 79380 ] |
| Worklog Id | 55304 [ 55304 ] |
| Developer | Parmeshwar Jumbad [ parmeshwar.jumbade ] |
Khandu Kshirsagar (Inactive)
made changes -
| 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) |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
| Attachment | wt-9020.png [ 52600 ] |
Verified on stage.
Report run properly. Not getting server error.
Ready for production.
PFA,
Thanks,
Sanjana Jadhav.
| 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) |
| Time Spent | 22.05h [ 79380 ] | 22.55h [ 81180 ] |
| Worklog Id | 56471 [ 56471 ] |
| Worklog Id | 56471 [ 56471 ] |
-
- Time Spent:
- 0.5h
-
Verified on stage
Khandu Kshirsagar (Inactive)
made changes -
| 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) |
| Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production QA(10203)Level 1 values: In Testing(10218) |
| Attachment | wt-9020.png [ 53113 ] |
Verified on production.
Report run sucessfully.
PFA,
Thanks,
Sanjana Jadhav
| Item State | Parent values: Production QA(10203)Level 1 values: In Testing(10218) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Time Spent | 22.55h [ 81180 ] | 23.25h [ 83700 ] |
| Worklog Id | 57421 [ 57421 ] |
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
| Resolution | Fixed [ 1 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Bug Severity | Medium [ 16702 ] |
| Environment_New | LB [ 18444 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
60d 22h 28m | 1 |
|
7d 1h 6m | 1 |
|
14d 3h 53m | 1 |
|
2d 19h 7m | 1 |
|
7s | 1 |
|
5m 13s | 1 |
This task is ready for testing
Concern : System Utilization - throws server error on report running.
Cause: Query was not generating properly those fields.
Correction: Now all the fields are mapped correctly.
Affected Areas: System utilization report
Affected File Name: OES_SP_SystemUtilization.StoredProcedure.sql
Tested Scenarios:
Following scenarios i have tested at my end
1. Checked reports with selection of individual fields from system utilization and employee fields
2. Checked reports with selection of all fields except few fields like Employee Monthly Average Working Hours, Employee Stable Working Hours, Formatted Social Security No., Year Of Service
3. Checked report for diffrent classes, status and dates
4. Verified report with superadmin user login
Known issue:
There is problem to selection of some fields like Employee Monthly Average Working Hours, Employee Stable Working Hours, Formatted Social Security No., Year Of Service. For that we have added new JIRA with and ID- WT-9679
CC: Prasanna Karlekar