Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-10233

TIBCO - Transit Plan Coverage duplicating when plan is terminated.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      Client
    • Company:
      TIBCO
    • Item State:
      Production Complete - Closed
    • Reported by Customer:
      BCC
    • Sprint:
      WT Sprint 33-Bugs

      Description

      Please see the attached screenshots. When transit plans are terminating it appears that the coverage is duplicating.

        Attachments

          Issue Links

            Activity

            dkulling Debbie Kulling created issue -
            jyoti.mayne Jyoti Mayne made changes -
            Field Original Value New Value
            Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Enrollment(10107)
            jyoti.mayne Jyoti Mayne made changes -
            Assignee Vijay Siddha [ vijays ] Shailendra Honrao [ shailendra.honrao ]
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 33-Bugs [ 77 ]
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Attachment List of Employees.xls [ 56199 ]
            Hide
            shailendra.honrao Shailendra Honrao (Inactive) added a comment -

            Hi Debbie Kulling,

            We have checked issue of reported EE and found that in coverage table there were multiple entries present with same Enrollment ID with OE mode with EE login. Hence on Confirmation Statement page coverage entries are getting shown multiple times.

            We have corrected data of reported EE.

            Also we have scanned all employees, and found attached 12 are affected List of Employees.xls , who has multiple entries in coverage table with same Enrollment ID.

            Please let us know shall we proceed with correction for these 12 EEs?

            Also we have tried to reproduce this issue but we are unable to reproduce it. We will try more scenarios and update you.

            Cc: Jyoti Mayne

            Show
            shailendra.honrao Shailendra Honrao (Inactive) added a comment - Hi Debbie Kulling , We have checked issue of reported EE and found that in coverage table there were multiple entries present with same Enrollment ID with OE mode with EE login. Hence on Confirmation Statement page coverage entries are getting shown multiple times. We have corrected data of reported EE. Also we have scanned all employees, and found attached 12 are affected List of Employees.xls , who has multiple entries in coverage table with same Enrollment ID. Please let us know shall we proceed with correction for these 12 EEs? Also we have tried to reproduce this issue but we are unable to reproduce it. We will try more scenarios and update you. Cc: Jyoti Mayne
            shailendra.honrao Shailendra Honrao (Inactive) logged work - 20/Jul/17 01:03 PM
            • Time Spent:
              4h
               

              data analysis,reproducing an issue,scanning of data

            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 4h [ 14400 ]
            Worklog Id 65090 [ 65090 ]
            jyoti.mayne Jyoti Mayne logged work - 20/Jul/17 03:31 PM
            • Time Spent:
              1.5h
               

              analysis, issue reproduce and discussion about scanning

            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Attachment screenshot.png [ 56316 ]
            Hide
            shailendra.honrao Shailendra Honrao (Inactive) added a comment -

            Hi Debbie Kulling,

            We have corrected data of 12 records of attached Employee's.

            Hi Prasad Pise,

            We analyzed data,we come to knew that on for all employees on 07/18/2017 incorrect Enrollment ID was inserted.
            Please find with attached screenshot.

            So we have checked Enrollment history for date 07/18/2017 but we found nothing.

            We have tried to reproduce an issue, for Active as well as Terminated EE's so that
            we raised a QE of date 01/01/17,changed the coverage and Enrolled again and we analyzed that Enrollment ID inserted properly.

            We are unable to reproduce this issue.

            Cc: Jyoti Mayne,Satya

            Show
            shailendra.honrao Shailendra Honrao (Inactive) added a comment - Hi Debbie Kulling , We have corrected data of 12 records of attached Employee's. Hi Prasad Pise , We analyzed data,we come to knew that on for all employees on 07/18/2017 incorrect Enrollment ID was inserted. Please find with attached screenshot. So we have checked Enrollment history for date 07/18/2017 but we found nothing. We have tried to reproduce an issue, for Active as well as Terminated EE's so that we raised a QE of date 01/01/17,changed the coverage and Enrolled again and we analyzed that Enrollment ID inserted properly. We are unable to reproduce this issue. Cc: Jyoti Mayne , Satya
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Assignee Shailendra Honrao [ shailendra.honrao ] Prasad Pise [ prasadp ]
            shailendra.honrao Shailendra Honrao (Inactive) logged work - 21/Jul/17 10:52 AM
            • Time Spent:
              4h
               

              data correction, data analysis,discussion with jyoti

            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Time Spent 4h [ 14400 ] 8h [ 28800 ]
            Worklog Id 65267 [ 65267 ]
            jyoti.mayne Jyoti Mayne logged work - 21/Jul/17 03:20 PM
            • Time Spent:
              1.5h
               

              analysis, reproducing issue and data correction

            Hide
            prasadp Prasad Pise (Inactive) added a comment -

            Hi Rashmita Dudhe

            Could you please try to reproduce the issue and share your findings with dev team?

            Thanks
            -Prasad

            CC : Hrishikesh DeshpandeSachin HingoleRakesh Roy

            Show
            prasadp Prasad Pise (Inactive) added a comment - Hi Rashmita Dudhe Could you please try to reproduce the issue and share your findings with dev team? Thanks -Prasad CC : Hrishikesh Deshpande Sachin Hingole Rakesh Roy
            prasadp Prasad Pise (Inactive) made changes -
            Assignee Prasad Pise [ prasadp ] Rashmita Dudhe [ rashmita.dudhe ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 8h [ 28800 ] 9.5h [ 34200 ]
            Worklog Id 65844 [ 65844 ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 9.5h [ 34200 ] 11h [ 39600 ]
            Worklog Id 65853 [ 65853 ]
            jyoti.mayne Jyoti Mayne made changes -
            Dev Due Date 28/Jul/2017
            Original Estimate 0h [ 0 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 25/Jul/17 08:40 AM
            • Time Spent:
              1h
               
              <No comment>
            Hide
            dkulling Debbie Kulling added a comment -

            Correct all 12 employees.

            I cannot go back to the client and tell them the issue cannot be reproduced. I need a root cause. What other impact did assigning the wrong enrollment ID have?

            Show
            dkulling Debbie Kulling added a comment - Correct all 12 employees. I cannot go back to the client and tell them the issue cannot be reproduced. I need a root cause. What other impact did assigning the wrong enrollment ID have?
            rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 26/Jul/17 08:40 AM - edited
            • Time Spent:
              5h
               
              <No comment>
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Hi Debbie Kulling,

            We are verifying this issue will update you tomorrow.

            Thanks,
            Rashmita

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Hi Debbie Kulling , We are verifying this issue will update you tomorrow. Thanks, Rashmita
            Hide
            jyoti.mayne Jyoti Mayne added a comment -

            Hi Debbie Kulling,

            We scanned all employees and corrected these 12 EEs data on '7/21/17'.
            Today also, we scanned data and found none of them are impacted.

            Cc: Shailendra Honrao

            Show
            jyoti.mayne Jyoti Mayne added a comment - Hi Debbie Kulling , We scanned all employees and corrected these 12 EEs data on '7/21/17'. Today also, we scanned data and found none of them are impacted. Cc: Shailendra Honrao
            Hide
            dkulling Debbie Kulling added a comment -

            Has a root cause been identified?

            Show
            dkulling Debbie Kulling added a comment - Has a root cause been identified?
            Hide
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

            Hi Jyoti Mayne

            CC:Hrishikesh Deshpande,Prasad Pise,Satya,Rakesh Roy

            Try to reproduced this issue But it is not getting reproduced consider below scenarios As per reported employee view history

            1] add new employee Enrolled in to the Transit Plan with effective date 02/01/2016 with coverage amount 550
            2]change Coverage amount 560 with effective date 02/01/2016
            3]again change coverage amount 600 with effective date 07/01/2017
            4] change employee status as terminated with 07/15/2017
            5]cross verified enrollment on Enroll now screen. confirmation statement, view enrollment summary

            6]Change Employee status through Import by using template Employee Import w Term Dates
            7]again cross verified on enrollment on Enroll now screen. confirmation statement, view enrollment summary
            8]tried on different browser like IE Mozilla and chrome with all above scenarios
            9]It showing proper termination date with proper coverage amount.

            Thanks,
            Rashmita

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Hi Jyoti Mayne CC: Hrishikesh Deshpande , Prasad Pise , Satya , Rakesh Roy Try to reproduced this issue But it is not getting reproduced consider below scenarios As per reported employee view history 1] add new employee Enrolled in to the Transit Plan with effective date 02/01/2016 with coverage amount 550 2]change Coverage amount 560 with effective date 02/01/2016 3]again change coverage amount 600 with effective date 07/01/2017 4] change employee status as terminated with 07/15/2017 5]cross verified enrollment on Enroll now screen. confirmation statement, view enrollment summary 6]Change Employee status through Import by using template Employee Import w Term Dates 7]again cross verified on enrollment on Enroll now screen. confirmation statement, view enrollment summary 8]tried on different browser like IE Mozilla and chrome with all above scenarios 9]It showing proper termination date with proper coverage amount. Thanks, Rashmita
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 11h [ 39600 ] 15h [ 54000 ]
            Worklog Id 66881 [ 66881 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 15h [ 54000 ] 16h [ 57600 ]
            Worklog Id 66882 [ 66882 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Time Spent 16h [ 57600 ] 17h [ 61200 ]
            Worklog Id 66881 [ 66881 ]
            satyap Satya made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            satyap Satya made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            satyap Satya made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            satyap Satya made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            satyap Satya made changes -
            Link This issue relates to WT-10291 [ WT-10291 ]
            Hide
            satyap Satya added a comment -

            This issue occurred due to reason mentioned in WT-10291.

            Show
            satyap Satya added a comment - This issue occurred due to reason mentioned in WT-10291 .
            Hide
            satyap Satya added a comment -

            Hi Debbie,

            Development has identified its root cause today and it had been affected due to WT-8417. Please find detailed reason & 3Cs in WT-10233.

            Regards,
            Satya Prakash

            Cc: Jyoti Mayne Rashmita Dudhe Hrishikesh Deshpande Rakesh Roy Vijay Siddha

            Show
            satyap Satya added a comment - Hi Debbie, Development has identified its root cause today and it had been affected due to WT-8417 . Please find detailed reason & 3Cs in WT-10233 . Regards, Satya Prakash Cc: Jyoti Mayne Rashmita Dudhe Hrishikesh Deshpande Rakesh Roy Vijay Siddha
            satyap Satya made changes -
            Assignee Rashmita Dudhe [ rashmita.dudhe ] Debbie Kulling [ dkulling ]
            Hide
            dkulling Debbie Kulling added a comment -

            Hi Satya,

            I just want to make sure I understand. This issue was created by a change made with WT-8417. The fixed has been completed and you are going to be monitoring all companies for the next week to ensure that it does not happen again. Do you have a list of all the companies that were impacted?

            Show
            dkulling Debbie Kulling added a comment - Hi Satya, I just want to make sure I understand. This issue was created by a change made with WT-8417 . The fixed has been completed and you are going to be monitoring all companies for the next week to ensure that it does not happen again. Do you have a list of all the companies that were impacted?
            Hide
            amruta.lohiya Amruta Lohiya added a comment -

            Hi Debbie,

            Yes you are correct. We have corrected this today across companies today. Some of the other client who reported similar issue were - Groendyke, LHP & Metso.

            We are monitoring this for next complete week and will share final result with you.

            Regards,
            Satya Prakash

            Cc: Vijay Siddha Jyoti Mayne Samir

            Show
            amruta.lohiya Amruta Lohiya added a comment - Hi Debbie, Yes you are correct. We have corrected this today across companies today. Some of the other client who reported similar issue were - Groendyke, LHP & Metso. We are monitoring this for next complete week and will share final result with you. Regards, Satya Prakash Cc: Vijay Siddha Jyoti Mayne Samir
            jyoti.mayne Jyoti Mayne made changes -
            Dev Due Date 28/Jul/2017 27/Jul/2017
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Company TIBCO [ 13656 ]
            Hide
            Kira.Hamilton Kira Hamilton (Inactive) added a comment -

            Hello,

            After having monitored this for a few weeks, can you tell us what the final results were?

            Thank you
            Kira

            Show
            Kira.Hamilton Kira Hamilton (Inactive) added a comment - Hello, After having monitored this for a few weeks, can you tell us what the final results were? Thank you Kira
            rakeshr Rakesh Roy (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            satyap Satya made changes -
            Environment_New Production [ 18442 ]
            dkulling Debbie Kulling made changes -
            Resolution Done [ 10000 ]
            Status Production Complete [ 10028 ] Closed [ 6 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Root Cause Bug [ 18430 ]
            Transition Time In Source Status Execution Times
            Shailendra Honrao (Inactive) made transition -
            Open In Development
            18h 58m 1
            Satya made transition -
            In Development In LB Testing
            7d 7h 58m 1
            Satya made transition -
            In LB Testing Stage Testing
            4s 1
            Satya made transition -
            Stage Testing In Production Testing
            3s 1
            Rakesh Roy (Inactive) made transition -
            In Production Testing Production Complete
            45d 23h 45m 1
            Debbie Kulling made transition -
            Production Complete Closed
            168d 8h 57m 1

              People

              Assignee:
              dkulling Debbie Kulling
              Reporter:
              dkulling Debbie Kulling
              Account Executive:
              Debbie Kulling
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Dev Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 17h
                  17h