[WT-10912] BSG - Across Company Report Issue - Workterra Jira

Details

Type: Bug
Status: Closed
Priority: Medium
Resolution: Unresolved
Affects Version/s: None
Fix Version/s: None
Component/s: BenAdmin
Labels:
None

Environment:

Production
Bug Severity:
Medium
Module:
BenAdmin - Report
Reported by:
Client
Company:
All Clients/Multiple Clients
Item State:
Production Complete - Closed
Reported by Customer:
BSG
Sprint:
WT Sprint 36 - Bugs, WT Sprint 37 - Bugs

Description

BSG has an across company report named "Employee Status Report"

Please see the screen shot below. Ascension is an inactivated company and it is not in the list of selected companies but the data is still appearing on the report. Please advise

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

image-2017-08-31-12-08-16-603.png
34 kB
31/Aug/17 05:08 PM
BSG Report With ASML for HSPL as active.xls
405 kB
18/Sep/17 08:48 AM
For QA ASML FOR HSPL inactive Status Report.xls
304 kB
18/Sep/17 08:51 AM
Again Activated.png
94 kB
18/Sep/17 08:51 AM
Again ASML for QA hspl Activated.pdf
830 kB
18/Sep/17 08:51 AM
Employee Census Report.xls
1.35 MB
18/Sep/17 08:54 AM
With Active company Barrow for HSPL.xls
459 kB
22/Sep/17 06:32 AM
With Inactive Company BArrow For HSPL.xls
268 kB
22/Sep/17 06:32 AM
Again Activated Inactive company Barrow for HSPL.xls
459 kB
22/Sep/17 06:33 AM
Employee Census Report.xls
490 kB
22/Sep/17 06:55 AM
Prod.png
147 kB
26/Sep/17 02:56 PM

Issue Links

is caused by

WT-10799 Functional | Any company | Student verification report | Validation message is not displaying for classes & status column , & report is getting saved ,without selecting classes

Closed

relates to

NF-5154 BSG - Across Company Report Issue

Production Complete

Activity

Ascending order - Click to sort in descending order

Debbie Kulling created issue - 31/Aug/17 05:09 PM

Jaideep Vinchurkar (Inactive) made changes - 01/Sep/17 04:55 AM

Field	Original Value	New Value
Assignee	Vijay Siddha [ vijays ]	Prasanna Karlekar [ prasanna ]

Hide

Permalink

Prasanna Karlekar (Inactive) added a comment - 01/Sep/17 02:42 PM

Hi Debbie Kulling,

Will check this in coming week and will update you by 7-Sep-2017.

Thank you!

Show

Prasanna Karlekar (Inactive) added a comment - 01/Sep/17 02:42 PM Hi Debbie Kulling , Will check this in coming week and will update you by 7-Sep-2017. Thank you!

Permalink

Prasanna Karlekar (Inactive) logged work - 02/Sep/17 02:45 AM

Time Spent:

0.25h

JIRA update

Prasanna Karlekar (Inactive) made changes - 04/Sep/17 06:32 AM

Remaining Estimate		0h [ 0 ]
Time Spent		0.25h [ 900 ]
Worklog Id		76564 [ 76564 ]

Permalink

Prasanna Karlekar (Inactive) logged work - 07/Sep/17 02:30 AM

Time Spent:

0.5h

Initial Issue analysis

Prasanna Karlekar (Inactive) made changes - 07/Sep/17 08:19 AM

Time Spent	0.25h [ 900 ]	0.75h [ 2700 ]
Worklog Id		77308 [ 77308 ]

Prasanna Karlekar (Inactive) made changes - 07/Sep/17 10:14 AM

Status

Open [ 1 ]

In Development [ 10007 ]

Prasanna Karlekar (Inactive) made changes - 07/Sep/17 11:06 AM

Code Reviewed By		Parmeshwar Jumbad [ 17800 ]
Developer		Prasanna Karlekar [ prasanna ]
Original Estimate		0h [ 0 ]

Prasanna Karlekar (Inactive) made changes - 07/Sep/17 11:06 AM

Item State

Parent values: Development(10200)Level 1 values: Ready for Review(10208)

Hide

Permalink

Prasanna Karlekar (Inactive) added a comment - 07/Sep/17 12:57 PM

Hi Debbie Kulling,

We are done with the code fix for this issue. It will get deployed in QA environment tomorrow. After that it will get deployed on Stage and Production as per process.

Thank you!

Show

Prasanna Karlekar (Inactive) added a comment - 07/Sep/17 12:57 PM Hi Debbie Kulling , We are done with the code fix for this issue. It will get deployed in QA environment tomorrow. After that it will get deployed on Stage and Production as per process. Thank you!

Permalink

Prasanna Karlekar (Inactive) logged work - 07/Sep/17 09:00 PM

Time Spent:

1.5h

Issue analysis
Code changes for the fix
Unit testing
Review request

Hide

Permalink

Prasanna Karlekar (Inactive) added a comment - 08/Sep/17 07:59 AM

Following are the 3 Cs:

Concern:
Ascension is an inactivated company and it is not in the list of selected companies but the data is still appearing on the report.

Cause:
Ascension company was active and selected when "Employee Status Report" was created. Now this company is InActive. On UI, for selection, only active companies are appear. Hence, Ascension is not appearing. On report, data was getting displayed for all selected companies irrespective of company status (Active / Inactive) at the time of report execution.

Correction:
We have added check to populate data on report as per company status (Active / Inactive) at the time of report execution. We have done this change Global level Employee Status and Employee Census report.

Affected Files:
WT/trunk/WORKTERRAweb/Database Objects/OnlineEnrollment/04_Stored
Procedures/dbo.OES_SP_InsertUpdateGlobalCensusReport.StoredProcedure.sql
WT/trunk/WORKTERRAweb/RDL/GlobalCensusAcrossCmp.rdl
WT/trunk/WORKTERRAweb/RDL/GlobalEmployeeCensusAcrossCmp.rdl

Impacted Areas:
Global Level - Employee Status Report
Global Level - Employee Census Report

Known Issue:
If all the previously selected companies are made inactive, then proper message needs to be displayed at the time of execution. For this we will create new JIRA.

Thank you!

Show

Prasanna Karlekar (Inactive) added a comment - 08/Sep/17 07:59 AM Following are the 3 Cs: Concern: Ascension is an inactivated company and it is not in the list of selected companies but the data is still appearing on the report. Cause: Ascension company was active and selected when "Employee Status Report" was created. Now this company is InActive. On UI, for selection, only active companies are appear. Hence, Ascension is not appearing. On report, data was getting displayed for all selected companies irrespective of company status (Active / Inactive) at the time of report execution. Correction: We have added check to populate data on report as per company status (Active / Inactive) at the time of report execution. We have done this change Global level Employee Status and Employee Census report. Affected Files: WT/trunk/WORKTERRAweb/Database Objects/OnlineEnrollment/04_Stored Procedures/dbo.OES_SP_InsertUpdateGlobalCensusReport.StoredProcedure.sql WT/trunk/WORKTERRAweb/RDL/GlobalCensusAcrossCmp.rdl WT/trunk/WORKTERRAweb/RDL/GlobalEmployeeCensusAcrossCmp.rdl Impacted Areas: Global Level - Employee Status Report Global Level - Employee Census Report Known Issue: If all the previously selected companies are made inactive, then proper message needs to be displayed at the time of execution. For this we will create new JIRA. Thank you!

Prasanna Karlekar (Inactive) made changes - 08/Sep/17 08:17 AM

Time Spent	0.75h [ 2700 ]	2.25h [ 8100 ]
Worklog Id		77605 [ 77605 ]

Prasanna Karlekar (Inactive) made changes - 08/Sep/17 08:34 AM

Sprint

WT Sprint 36 - Bugs [ 84 ]

Permalink

Parmeshwar Jumbad (Inactive) logged work - 08/Sep/17 12:45 PM

Time Spent:

1.25h

Internal discussion and code review

Parmeshwar Jumbad (Inactive) made changes - 11/Sep/17 12:46 PM

Time Spent	2.25h [ 8100 ]	3.5h [ 12600 ]
Worklog Id		77994 [ 77994 ]

Permalink

Prasanna Karlekar (Inactive) logged work - 11/Sep/17 05:30 PM

Time Spent:

1.5h

Code centralization
Changes to fetch DB Name from UDF

Prasanna Karlekar (Inactive) made changes - 12/Sep/17 11:18 AM

Time Spent	3.5h [ 12600 ]	5h [ 18000 ]
Worklog Id		78185 [ 78185 ]

Permalink

Prasanna Karlekar (Inactive) logged work - 12/Sep/17 06:30 PM

Time Spent:

2.5h

RDL changes to show No Records Found, when all selected companies are inactive
Unit testing

Prasanna Karlekar (Inactive) made changes - 13/Sep/17 12:38 PM

Time Spent	5h [ 18000 ]	7.5h [ 27000 ]
Worklog Id		78515 [ 78515 ]

Prasanna Karlekar (Inactive) made changes - 13/Sep/17 12:39 PM

Sprint

WT Sprint 36 - Bugs [ 84 ]

WT Sprint 36 - Bugs, WT Sprint 37 - Bugs [ 84, 87 ]

Prasanna Karlekar (Inactive) made changes - 13/Sep/17 12:44 PM

Dev Due Date

15/Sep/2017

Rakesh Roy (Inactive) made changes - 14/Sep/17 08:32 AM

Production Due Date		21/Sep/2017
QA		Priya Handepatil [ priya.handepatil ]
Stage Due Date		20/Sep/17 [ 2017-09-20 ]

Hide

Permalink

Rakesh Roy (Inactive) added a comment - 14/Sep/17 08:34 AM

Priya Handepatil Please make sure this is tested on priority once its deployed for testing.
Stage and production due date is 20 Sep and 21 Sep respectively.

[~meghana joshi]Prasanna Karlekar

Show

Rakesh Roy (Inactive) added a comment - 14/Sep/17 08:34 AM Priya Handepatil Please make sure this is tested on priority once its deployed for testing. Stage and production due date is 20 Sep and 21 Sep respectively. [~meghana joshi] Prasanna Karlekar

Rakesh Roy (Inactive) made changes - 14/Sep/17 08:36 AM

Module

Parent values: BenAdmin(10100)

Parent values: BenAdmin(10100)Level 1 values: Report(10109)

Khandu Kshirsagar (Inactive) made changes - 14/Sep/17 12:14 PM

Item State

Parent values: Development(10200)Level 1 values: Ready for Review(10208)

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Permalink

Prasanna Karlekar (Inactive) logged work - 14/Sep/17 07:30 PM

Time Spent:

0.75h

Discussion on Rowcount change
Blank data getting populated
Changes and unit testing for Rowcount change
Code check in

Permalink

Parmeshwar Jumbad (Inactive) logged work - 15/Sep/17 05:08 AM

Time Spent:

2h

Code review and Scenarios testing
Internal discssion

Parmeshwar Jumbad (Inactive) made changes - 15/Sep/17 05:08 AM

Time Spent	7.5h [ 27000 ]	9.5h [ 34200 ]
Worklog Id		78839 [ 78839 ]

Prasanna Karlekar (Inactive) made changes - 15/Sep/17 11:08 AM

Assignee

Prasanna Karlekar [ prasanna ]

Sachin Hingole [ sachin.hingole ]

Sachin Hingole (Inactive) made changes - 15/Sep/17 11:30 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Hide

Permalink

Sachin Hingole (Inactive) added a comment - 15/Sep/17 11:31 AM

[~meghana joshi]

Show

Sachin Hingole (Inactive) added a comment - 15/Sep/17 11:31 AM [~meghana joshi]

Sachin Hingole (Inactive) made changes - 15/Sep/17 11:31 AM

Assignee

Sachin Hingole [ sachin.hingole ]

Priya Handepatil [ priya.handepatil ]

Priya Handepatil (Inactive) made changes - 15/Sep/17 12:32 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)

Permalink

Priya Handepatil (Inactive) logged work - 15/Sep/17 12:52 PM

Time Spent:

1.5h

Analysis
Testing for different scenarios
Internal Discussions
JIRA Updates

Hide

Permalink

Priya Handepatil (Inactive) added a comment - 15/Sep/17 12:52 PM

Hi Rakesh Roy

I have tested this issue for Active and Inactive companies

I will be discussing more impacted scenarios with [~meghana joshi]

Till the time testing is In Progress on LB

cc: Sachin Hingole Prasad Pise Hrishikesh Deshpande

Thank You !

Show

Priya Handepatil (Inactive) added a comment - 15/Sep/17 12:52 PM Hi Rakesh Roy I have tested this issue for Active and Inactive companies I will be discussing more impacted scenarios with [~meghana joshi] Till the time testing is In Progress on LB cc: Sachin Hingole Prasad Pise Hrishikesh Deshpande Thank You !

Priya Handepatil (Inactive) made changes - 15/Sep/17 12:53 PM

Time Spent	9.5h [ 34200 ]	11h [ 39600 ]
Worklog Id		79043 [ 79043 ]

Priya Handepatil (Inactive) made changes - 18/Sep/17 08:48 AM

Attachment

BSG Report With ASML for HSPL as active.xls [ 61705 ]

Priya Handepatil (Inactive) made changes - 18/Sep/17 08:51 AM

Attachment

For QA ASML FOR HSPL inactive Status Report.xls [ 61706 ]

Priya Handepatil (Inactive) made changes - 18/Sep/17 08:51 AM

Attachment		Again Activated.png [ 61707 ]
Attachment		Again ASML for QA hspl Activated.pdf [ 61708 ]

Priya Handepatil (Inactive) made changes - 18/Sep/17 08:54 AM

Attachment

Employee Census Report.xls [ 61709 ]

Hide

Permalink

Priya Handepatil (Inactive) added a comment - 18/Sep/17 09:01 AM

Hi Prasanna Karlekar

I have verified this issue on LB

Verified with Super Admin and Partner Login

Verified for Following Scenarios :

1) Pulled "Employee Status Report" For For QA ASML For HSPL is in ACTIVE status

BSG Report With ASML for HSPL as active.xls

2) Pulled "Employee Status Report " For For QA For ASML for HSPL is in INACTIVE Status

For QA ASML FOR HSPL inactive Status Report.xls

3) Again Pulled Report for Same company with Active State

Again ASML for QA hspl Activated.pdf

4) Also Verified " Employee Census Report "

Employee Census Report.xls

5) Also Verified for "All Employee Status " under Classes and Status
Found One issue while testing this issue which is As discussed already Taken Care of in ticket ~~WT-10799~~

Its working fine

Hence, Marking it as Ready for Stage

cc:Sachin Hingole Prasad Pise Rakesh Roy

Thank You !

Show

Priya Handepatil (Inactive) added a comment - 18/Sep/17 09:01 AM Hi Prasanna Karlekar I have verified this issue on LB Verified with Super Admin and Partner Login Verified for Following Scenarios : 1) Pulled "Employee Status Report" For For QA ASML For HSPL is in ACTIVE status BSG Report With ASML for HSPL as active.xls 2) Pulled "Employee Status Report " For For QA For ASML for HSPL is in INACTIVE Status For QA ASML FOR HSPL inactive Status Report.xls 3) Again Pulled Report for Same company with Active State Again ASML for QA hspl Activated.pdf 4) Also Verified " Employee Census Report " Employee Census Report.xls 5) Also Verified for "All Employee Status " under Classes and Status Found One issue while testing this issue which is As discussed already Taken Care of in ticket WT-10799 Its working fine Hence, Marking it as Ready for Stage cc: Sachin Hingole Prasad Pise Rakesh Roy Thank You !

Priya Handepatil (Inactive) made changes - 18/Sep/17 09:01 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)

Priya Handepatil (Inactive) made changes - 18/Sep/17 09:02 AM

Link

This issue is caused by ~~WT-10799~~ [ ~~WT-10799~~ ]

Permalink

Priya Handepatil (Inactive) logged work - 18/Sep/17 09:03 AM

Time Spent:

2h

Testing with Different Scenarios
Internal Discussions with Meghana , Prasanna and Hrishikesh
JIRA Updates

Priya Handepatil (Inactive) made changes - 18/Sep/17 09:04 AM

Time Spent	11h [ 39600 ]	13h [ 46800 ]
Worklog Id		79203 [ 79203 ]

Prasanna Karlekar (Inactive) made changes - 18/Sep/17 10:46 AM

Time Spent	13h [ 46800 ]	13.75h [ 49500 ]
Worklog Id		79222 [ 79222 ]

Khandu Kshirsagar (Inactive) made changes - 20/Sep/17 06:33 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)

Priya Handepatil (Inactive) made changes - 22/Sep/17 06:07 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)

Priya Handepatil (Inactive) made changes - 22/Sep/17 06:32 AM

Attachment

With Active company Barrow for HSPL.xls [ 62375 ]

Priya Handepatil (Inactive) made changes - 22/Sep/17 06:32 AM

Attachment

With Inactive Company BArrow For HSPL.xls [ 62376 ]

Priya Handepatil (Inactive) made changes - 22/Sep/17 06:33 AM

Attachment

Again Activated Inactive company Barrow for HSPL.xls [ 62377 ]

Priya Handepatil (Inactive) made changes - 22/Sep/17 06:55 AM

Attachment

Employee Census Report.xls [ 62380 ]

Hide

Permalink

Priya Handepatil (Inactive) added a comment - 22/Sep/17 07:01 AM

Hi Prasanna Karlekar

I have verified this issue on Stage

Verified with Partner Login

Verified for Following Scenarios :

1) Pulled "Employee Status Report" For Barrow For HSPL is in ACTIVE status
With Active company Barrow for HSPL.xls

2) Pulled "Employee Status Report " For Barrow for HSPL is in INACTIVE Status
With Inactive Company BArrow For HSPL.xls

3) Again Pulled Report for Same company with Active State
Again Activated Inactive company Barrow for HSPL.xls

4) Also Verified " Employee Census Report "
Employee Census Report.xls

5) Also Verified for "All Employee Status " under Classes and Status
Found One issue while testing this issue which is As discussed already Taken Care of in ticket ~~WT-10799~~ LOCAL TESTING

Its working fine

Hence, Marking it as Ready for Production

cc: Sachin Hingole Rakesh Roy Prasad Pise

Thank You !

Show

Priya Handepatil (Inactive) added a comment - 22/Sep/17 07:01 AM Hi Prasanna Karlekar I have verified this issue on Stage Verified with Partner Login Verified for Following Scenarios : 1) Pulled "Employee Status Report" For Barrow For HSPL is in ACTIVE status With Active company Barrow for HSPL.xls 2) Pulled "Employee Status Report " For Barrow for HSPL is in INACTIVE Status With Inactive Company BArrow For HSPL.xls 3) Again Pulled Report for Same company with Active State Again Activated Inactive company Barrow for HSPL.xls 4) Also Verified " Employee Census Report " Employee Census Report.xls 5) Also Verified for "All Employee Status " under Classes and Status Found One issue while testing this issue which is As discussed already Taken Care of in ticket WT-10799 LOCAL TESTING Its working fine Hence, Marking it as Ready for Production cc: Sachin Hingole Rakesh Roy Prasad Pise Thank You !

Priya Handepatil (Inactive) made changes - 22/Sep/17 07:01 AM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Permalink

Priya Handepatil (Inactive) logged work - 22/Sep/17 07:02 AM

Time Spent:

2h

Company Restore on Stage
Company Activation and Deactivation on Stage
Testing for Different Reports
Internal Discussion for Report Access with Developer
JIRA Updates

Priya Handepatil (Inactive) made changes - 22/Sep/17 07:02 AM

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)

Priya Handepatil (Inactive) made changes - 22/Sep/17 07:02 AM

Production Due Date

21/Sep/2017

26/Sep/2017

Priya Handepatil (Inactive) made changes - 22/Sep/17 07:08 AM

Time Spent	13.75h [ 49500 ]	15.75h [ 56700 ]
Worklog Id		80417 [ 80417 ]

Khandu Kshirsagar (Inactive) made changes - 26/Sep/17 06:46 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)

Rakesh Roy (Inactive) made changes - 26/Sep/17 01:20 PM

Status

Stage Testing [ 10201 ]

Production Testing [ 10202 ]

Rakesh Roy (Inactive) made changes - 26/Sep/17 02:56 PM

Attachment

Prod.png [ 62754 ]

Hide

Permalink

Rakesh Roy (Inactive) added a comment - 26/Sep/17 02:59 PM

Debbie Kulling This is deployed on production, please verify and confirm.

Show

Rakesh Roy (Inactive) added a comment - 26/Sep/17 02:59 PM Debbie Kulling This is deployed on production, please verify and confirm.

Rakesh Roy (Inactive) made changes - 26/Sep/17 02:59 PM

Assignee	Priya Handepatil [ priya.handepatil ]	Debbie Kulling [ dkulling ]
Resolution		Fixed [ 1 ]
Status	Production Testing [ 10202 ]	Production Complete [ 10028 ]

Rakesh Roy (Inactive) made changes - 26/Sep/17 02:59 PM

Item State

Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)

Parent values: Production Complete(10222)Level 1 values: Closed(10223)

Satya made changes - 04/Nov/17 06:35 AM

Environment_New

Production [ 18442 ]

Parmeshwar Jumbad (Inactive) made changes - 23/Nov/17 09:57 AM

Link

This issue relates to ~~NF-5154~~ [ ~~NF-5154~~ ]

Debbie Kulling made changes - 27/Feb/18 03:47 PM

Resolution	Done [ 10000 ]
Status	Production Complete [ 10028 ]	Closed [ 6 ]

Rakesh Roy (Inactive) made changes - 03/Mar/18 04:41 AM

Company		All Clients/Multiple Clients [ 18434 ]
Root Cause		Bug [ 18430 ]

Transition	Time In Source Status	Execution Times

Prasanna Karlekar (Inactive) made transition - 07/Sep/17 10:14 AM

Open

In Development

6d 17h 5m

Sachin Hingole (Inactive) made transition - 15/Sep/17 11:30 AM

In Development

In LB Testing

8d 1h 15m

Priya Handepatil (Inactive) made transition - 22/Sep/17 07:01 AM

In LB Testing

Stage Testing

6d 19h 31m

Rakesh Roy (Inactive) made transition - 26/Sep/17 01:20 PM

Stage Testing

In Production Testing

4d 6h 18m

Rakesh Roy (Inactive) made transition - 26/Sep/17 02:59 PM

In Production Testing

Production Complete

1h 39m

Debbie Kulling made transition - 27/Feb/18 03:47 PM

Production Complete

Closed

154d 1h 48m

People

Assignee:: Debbie Kulling

Reporter:: Debbie Kulling

Developer:: Prasanna Karlekar (Inactive)

QA:: Priya Handepatil (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 31/Aug/17 05:09 PM

Updated:: 03/Mar/18 04:41 AM

Dev Due Date:: 15/Sep/2017

Pre-Prod Due Date:: 20/Sep/2017

Production Due Date:: 26/Sep/2017

Time Tracking

Estimated:

Remaining:

Logged:

15.75h