-
Type:
Enhancement
-
Status: Closed
-
Priority:
Medium
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
Module:BenAdmin - Report
-
Reported by:Harbinger
-
Item State:Production Complete - Closed
-
Sprint:WT Sprint 37 - Enhancement
-
Severity:Simple
Need to provide 2 reporting servers on production servers.
that can be configurable using simple steps .
1. Can be configure 2 DB reporting services which will only rendering the reports.
2.Simplicity for distributing companies load on either server.
-
- Time Spent:
- 4h
- <No comment>
-
- Time Spent:
- 2h
-
Parallel Reporting Services - Meeting and MOM
-
- Time Spent:
- 0.25h
-
Discussion on Parallel Reporting Services ETA
-
- Time Spent:
- 0.5h
-
Discussion on Parallel reporting services
Remaining Estimate | 40h [ 144000 ] | 38h [ 136800 ] |
Time Spent | 2h [ 7200 ] | |
Worklog Id | 41645 [ 41645 ] |
Remaining Estimate | 38h [ 136800 ] | 34h [ 122400 ] |
Time Spent | 2h [ 7200 ] | 6h [ 21600 ] |
Worklog Id | 41704 [ 41704 ] |
Remaining Estimate | 34h [ 122400 ] | 33h [ 118800 ] |
Time Spent | 6h [ 21600 ] | 7h [ 25200 ] |
Worklog Id | 42052 [ 42052 ] |
Remaining Estimate | 33h [ 118800 ] | 31h [ 111600 ] |
Time Spent | 7h [ 25200 ] | 9h [ 32400 ] |
Worklog Id | 42164 [ 42164 ] |
Remaining Estimate | 31h [ 111600 ] | 29h [ 104400 ] |
Time Spent | 9h [ 32400 ] | 11h [ 39600 ] |
Worklog Id | 42175 [ 42175 ] |
Remaining Estimate | 29h [ 104400 ] | 27h [ 97200 ] |
Time Spent | 11h [ 39600 ] | 13h [ 46800 ] |
Worklog Id | 42177 [ 42177 ] |
Remaining Estimate | 27h [ 97200 ] | 25h [ 90000 ] |
Time Spent | 13h [ 46800 ] | 15h [ 54000 ] |
Worklog Id | 42194 [ 42194 ] |
Remaining Estimate | 25h [ 90000 ] | 24.75h [ 89100 ] |
Time Spent | 15h [ 54000 ] | 15.25h [ 54900 ] |
Worklog Id | 42197 [ 42197 ] |
Worklog Id | 42194 [ 42194 ] |
Remaining Estimate | 24.75h [ 89100 ] | 24.25h [ 87300 ] |
Time Spent | 15.25h [ 54900 ] | 15.75h [ 56700 ] |
Worklog Id | 42230 [ 42230 ] |
Remaining Estimate | 24.25h [ 87300 ] | 23.75h [ 85500 ] |
Time Spent | 15.75h [ 56700 ] | 16.25h [ 58500 ] |
Worklog Id | 42744 [ 42744 ] |
Remaining Estimate | 23.75h [ 85500 ] | 18.75h [ 67500 ] |
Time Spent | 16.25h [ 58500 ] | 21.25h [ 76500 ] |
Worklog Id | 43059 [ 43059 ] |
Assignee | Nandkumar [ satyap ] | Aditya Vishwakarma [ aditya.vishwakarma ] |
Status | New Request [ 10029 ] | Pending for Approval [ 10002 ] |
Status | Pending for Approval [ 10002 ] | Approved for Development [ 10003 ] |
Status | Approved for Development [ 10003 ] | In Development [ 10007 ] |
Remaining Estimate | 18.75h [ 67500 ] | 18.25h [ 65700 ] |
Time Spent | 21.25h [ 76500 ] | 21.75h [ 78300 ] |
Worklog Id | 43407 [ 43407 ] |
-
- Time Spent:
- 5h
-
Coding
Unit testing started
Remaining Estimate | 18.25h [ 65700 ] | 13.25h [ 47700 ] |
Time Spent | 21.75h [ 78300 ] | 26.75h [ 96300 ] |
Worklog Id | 43566 [ 43566 ] |
Remaining Estimate | 13.25h [ 47700 ] | 8.75h [ 31500 ] |
Time Spent | 26.75h [ 96300 ] | 31.25h [ 112500 ] |
Worklog Id | 43569 [ 43569 ] |
-
- Time Spent:
- 4h
-
In progress (Change suggested in review)
-
- Time Spent:
- 0.5h
-
Discussion on on going changes for Parallel Reporting Servers
-
- Time Spent:
- 7h
-
Testing using Different Report Server
Remaining Estimate | 8.75h [ 31500 ] | 7.75h [ 27900 ] |
Time Spent | 31.25h [ 112500 ] | 32.25h [ 116100 ] |
Worklog Id | 44144 [ 44144 ] |
Remaining Estimate | 7.75h [ 27900 ] | 0.75h [ 2700 ] |
Time Spent | 32.25h [ 116100 ] | 39.25h [ 141300 ] |
Worklog Id | 44190 [ 44190 ] |
-
- Time Spent:
- 4h
-
Testing
Discussion for different test case.
Remaining Estimate | 0.75h [ 2700 ] | 0h [ 0 ] |
Time Spent | 39.25h [ 141300 ] | 43.25h [ 155700 ] |
Worklog Id | 44194 [ 44194 ] |
Description |
Need to provide 2 reporting servers on production servers. that can be configurable using simple steps . 1. Can be configure 2 DB reporting services which will only rendering the reports. 2.Simplicity for distributing companies load on either server. |
Need to provide 2 reporting servers on production servers. that can be configurable using simple steps . 1. Can be configure 2 DB reporting services which will only rendering the reports. 2.Simplicity for distributing companies load on either server. |
Item State | Parent values: Development(10200)Level 1 values: Ready for Review(10208) | |
Module | Parent values: BenAdmin(10100) | Parent values: BenAdmin(10100)Level 1 values: Report(10109) |
Code Reviewed By | Nandkumar Karlekar [ 11904 ] |
Time Spent | 43.25h [ 155700 ] | 44.25h [ 159300 ] |
Worklog Id | 44481 [ 44481 ] |
-
- Time Spent:
- 3h
-
Code review request
Uni testing
Time Spent | 44.25h [ 159300 ] | 47.25h [ 170100 ] |
Worklog Id | 44523 [ 44523 ] |
Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
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) |
Assignee | Aditya Vishwakarma [ aditya.vishwakarma ] | Sachin Hingole [ sachin.hingole ] |
Assignee | Sachin Hingole [ sachin.hingole ] | Satya [ ID10004 ] |
Summary | PE: Parallel reporting server configuration analysis | PE: Parallel reporting server configuration |
Assignee | Satya [ ID10004 ] | Ashwin Wankhede [ ashwin.wankhede ] |
Time Spent | 47.25h [ 170100 ] | 47.75h [ 171900 ] |
Worklog Id | 47788 [ 47788 ] |
Assignee | Ashwin Wankhede [ ashwin.wankhede ] | Aditya Vishwakarma [ aditya.vishwakarma ] |
-
- Time Spent:
- 0.5h
-
Discussion on changes for Parallel Report Servers on device side
Time Spent | 47.75h [ 171900 ] | 48.25h [ 173700 ] |
Worklog Id | 49202 [ 49202 ] |
Time Spent | 48.25h [ 173700 ] | 50.75h [ 182700 ] |
Worklog Id | 51369 [ 51369 ] |
Time Spent | 50.75h [ 182700 ] | 54.75h [ 197100 ] |
Worklog Id | 51373 [ 51373 ] |
Assignee | Aditya Vishwakarma [ aditya.vishwakarma ] | Prasanna Karlekar [ prasanna ] |
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) |
Assignee | Prasanna Karlekar [ prasanna ] | Sachin Hingole [ sachin.hingole ] |
Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
Assignee | Sachin Hingole [ sachin.hingole ] | Meghana Joshi [ meghana.kulkarni ] |
Developer | Prasanna Karlekar [ prasanna ] | |
Production Due Date | 06/Jul/2017 | |
QA | Meghana Joshi [ meghana.kulkarni ] | |
Stage Due Date | 5/Jul/17 [ 2017-07-05 ] |
-
- Time Spent:
- 4.5h
-
Analysis
Test Scenarios Writing
Started testing on LB
Time Spent | 54.75h [ 197100 ] | 59.25h [ 213300 ] |
Worklog Id | 59845 [ 59845 ] |
Attachment | Parallel reporting server configuration_Test Scenarios.xls [ 53869 ] |
Time Spent | 59.25h [ 213300 ] | 62.75h [ 225900 ] |
Worklog Id | 60522 [ 60522 ] |
Item State | Parent values: LB QA(10201)Level 1 values: In Testing(10210) | Parent values: LB QA(10201)Level 1 values: On Hold(10211) |
Item State | Parent values: LB QA(10201)Level 1 values: On Hold(10211) | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
Production Due Date | 06/Jul/2017 | 11/Jul/2017 |
Stage Due Date | 5/Jul/17 [ 2017-07-05 ] | 6/Jul/17 [ 2017-07-06 ] |
Attachment | Modified Files.txt [ 54255 ] |
Attachment | Modified Files.txt [ 54255 ] |
Attachment | Modified Files.txt [ 54256 ] |
Item State | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Attachment | Parallel Reporting Servers - Implementation.doc [ 54284 ] |
Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) |
Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
Status | Local Testing [ 10200 ] | Pending for Stage Approval [ 10300 ] |
Status | Pending for Stage Approval [ 10300 ] | Approved for Stage [ 10030 ] |
Status | Approved for Stage [ 10030 ] | Stage Testing [ 10201 ] |
Attachment | ErrorLog.txt [ 54319 ] |
Status | Stage Testing [ 10201 ] | Reopen in Stage [ 10023 ] |
Assignee | Meghana Joshi [ meghana.kulkarni ] | Prasanna Karlekar [ prasanna ] |
Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: Stage QA(10202)Level 1 values: Re-open(10216) |
-
- Time Spent:
- 3h
-
Code changes merged into Stage & UI- Refresh
Discussion related to impacted files and update JIRA
Create Script to update data on different environment
Time Spent | 62.75h [ 225900 ] | 65.75h [ 236700 ] |
Worklog Id | 61184 [ 61184 ] |
-
- Time Spent:
- 3.5h
-
Testing on Stage.
Discussion with Dev
Time Spent | 65.75h [ 236700 ] | 69.25h [ 249300 ] |
Worklog Id | 61202 [ 61202 ] |
-
- Time Spent:
- 2h
-
Clone company verification on LB
Reports not working on Stage environment after patch deployment - Analysis
Discussion with Deployment engineer and DBA
Issue due to - sql authentication not happening with IP
Issue resolved by DBA
Assignee | Prasanna Karlekar [ prasanna ] | Meghana Joshi [ meghana.kulkarni ] |
Item State | Parent values: Stage QA(10202)Level 1 values: Re-open(10216) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
Status | Reopen in Stage [ 10023 ] | In Development [ 10007 ] |
Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Status | Local Testing [ 10200 ] | Pending for Stage Approval [ 10300 ] |
Status | Pending for Stage Approval [ 10300 ] | Approved for Stage [ 10030 ] |
Status | Approved for Stage [ 10030 ] | Stage Testing [ 10201 ] |
Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
Assignee | Meghana Joshi [ meghana.kulkarni ] | Prasanna Karlekar [ prasanna ] |
-
- Time Spent:
- 2.5h
-
Reports not working on Azure - Discussion and resolution
workterrauser authenticatiion verification with IP address on Production and Azure
Discussion and email for multiple Report Servers in Stage environment
Reports not working on Production - User locked error
Assignee | Prasanna Karlekar [ prasanna ] | Vijay Siddha [ vijays ] |
Time Spent | 69.25h [ 249300 ] | 71.25h [ 256500 ] |
Worklog Id | 62619 [ 62619 ] |
Time Spent | 71.25h [ 256500 ] | 73.25h [ 263700 ] |
Worklog Id | 65437 [ 65437 ] |
Time Spent | 73.25h [ 263700 ] | 75.75h [ 272700 ] |
Worklog Id | 65453 [ 65453 ] |
Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: Stage QA(10202)Level 1 values: On Hold(10215) |
-
- Time Spent:
- 2h
-
Report server working verification for MORELLOSR
Verified:
Reports are working on Prestage demo site
Report Manager is accessible via url
SQL authentication using IP address
Changed ReportServerAddress for one of the Stage company to see if reports are working or not. - Got authentication issue.
Email communication
Assignee | Vijay Siddha [ vijays ] | Prasanna Karlekar [ prasanna ] |
Assignee | Prasanna Karlekar [ prasanna ] | Satya [ ID10004 ] |
Time Spent | 75.75h [ 272700 ] | 77.75h [ 279900 ] |
Worklog Id | 75123 [ 75123 ] |
Assignee | Satya [ ID10004 ] | Jyoti Agrawal [ jyoti.agrawal ] |
Production Due Date | 11/Jul/2017 | 11/Jul/2017 |
Sprint | WT Sprint 37 - Enhancement [ 86 ] | |
Stage Due Date | 6/Jul/17 [ 2017-07-06 ] | 6/Jul/17 [ 2017-07-06 ] |
Assignee | Jyoti Agrawal [ jyoti.agrawal ] | Sachin Hingole [ sachin.hingole ] |
Dev Due Date | 12/Sep/2017 |
Assignee | Sachin Hingole [ sachin.hingole ] | Meghana Joshi [ meghana.kulkarni ] |
Item State | Parent values: Stage QA(10202)Level 1 values: On Hold(10215) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
-
- Time Spent:
- 1.5h
-
Report Server Configuration - Pair Programming
Issues encountered while updating second report server
Discussion on multiple report servers in Production environment
Production Due Date | 11/Jul/2017 | |
Stage Due Date | 6/Jul/17 [ 2017-07-06 ] | 12/Sep/17 [ 2017-09-12 ] |
-
- Time Spent:
- 6.75h
-
Parallel report server configuration and internal discussions
Time Spent | 77.75h [ 279900 ] | 84.5h [ 304200 ] |
Worklog Id | 78403 [ 78403 ] |
Production Due Date | 19/Sep/2017 |
Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: Stage QA(10202)Level 1 values: On Hold(10215) |
Time Spent | 84.5h [ 304200 ] | 86.5h [ 311400 ] |
Worklog Id | 78451 [ 78451 ] |
Time Spent | 86.5h [ 311400 ] | 88h [ 316800 ] |
Worklog Id | 78512 [ 78512 ] |
-
- Time Spent:
- 1h
-
Internal discussion with Team
configure few companies with different reporting server
Time Spent | 88h [ 316800 ] | 89h [ 320400 ] |
Worklog Id | 78631 [ 78631 ] |
Item State | Parent values: Stage QA(10202)Level 1 values: On Hold(10215) | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) |
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) |
Status | Stage Testing [ 10201 ] | Pending for Production Approval [ 10301 ] |
Status | Pending for Production Approval [ 10301 ] | Approved for production [ 10034 ] |
Status | Approved for production [ 10034 ] | Production Testing [ 10202 ] |
Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production QA(10203)Level 1 values: In Testing(10218) |
Time Spent | 89h [ 320400 ] | 91h [ 327600 ] |
Worklog Id | 79679 [ 79679 ] |
-
- Time Spent:
- 2.5h
-
Internal discussion and changes related to report server address
Report server address values change for testing
Discussion with QA
Verified changes on production
Resolution | Fixed [ 1 ] | |
Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
Status | Production Complete [ 10028 ] | Closed [ 6 ] |
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 | 91h [ 327600 ] | 93.5h [ 336600 ] |
Worklog Id | 79748 [ 79748 ] |
-
- Time Spent:
- 1h
-
Reports working verification after Patch deployment
Discussion
Email Communication
Time Spent | 93.5h [ 336600 ] | 94.5h [ 340200 ] |
Worklog Id | 81312 [ 81312 ] |
Transition | Time In Source Status | Execution Times |
---|
|
17d 21h 54m | 1 |
|
3s | 1 |
|
2s | 1 |
|
2h 11m | 1 |
|
17h 33m | 1 |
|
6d 4h 1m | 2 |
|
55d 19h 37m | 2 |
|
5s | 2 |
|
6s | 2 |
|
74d 5h 16m | 1 |
|
3s | 1 |
|
16s | 1 |
|
1h 28m | 1 |
|
4s | 1 |
Hello Satya
I have ended up the coding part for this ticket on Friday.
Today I will be doing unit testing for it by using the local and LB report DB as discussed with Nandkumar Prabhakar Karlekar. The updating of Report server name in DB using Add company functionality will be consider as separate enhancement under ticket
WT-9412.This should be completed by 10- May 2017.I have also working on
WT-8924parallely as this ticket required client communication for testing at their end.Thanks