Details

    • Type: Bug
    • Status: Production Complete
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
    • Environment:
      Stage
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Import
    • Reported by:
      Client
    • Company:
      Reinforced Earth
    • Item State:
      Production Complete - Closed

      Description

      Hi,

      I did not see this group name in the drop down list below to select.

      Per the client:

      Do you know if there are any known issues or recent changes in Stage? We’re having that strange problem again where when I go to load eligibility to Reinforced Earth (in this case, Employee (500) records with the “Employee Import” template), it spins for a while until my session finally times out. About 20 employees appear to get loaded as far as the GUI Employee Search screen is concerned, but the SA Toolkit sees 499 when I go to delete them (there were 730 employees plus a header record in the file). Do you know if anyone else is having this problem? We’re hoping to load all the demographics and elections today so we can submit the UAT form.

      Thank you,
      Kira Hamilton
      Debbie Kulling

        Attachments

          Activity

          Kira.Hamilton Kira Hamilton (Inactive) created issue -
          amruta.lohiya Amruta Lohiya made changes -
          Field Original Value New Value
          Assignee Satya [ ID10004 ] Jaideep Vinchurkar [ jaideep.vinchurkar ]
          Hide
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

          We are still working on this. No Reached at any conclusion yet. We will update you by Tomorrow EOD.

          Show
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - We are still working on this. No Reached at any conclusion yet. We will update you by Tomorrow EOD.
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Code Review Date 21/Oct/2017
          Code Reviewed By Jaideep Vinchurkar [ 11908 ]
          Component/s BenAdmin [ 10000 ]
          Dev Due Date 23/Oct/2017
          Developer Prasanna Karlekar [ prasanna ] Jaideep Vinchurkar [ jaideep.vinchurkar ]
          Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
          Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Import(10111)
          QA Jayshree Nagpure [ jayshree.nagpure ]
          Remaining Estimate 8h [ 28800 ]
          Original Estimate 8h [ 28800 ]
          Hide
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - - edited

          Concern: Import not working on stage

          Cause: On Reinforced earth, user name generation uses last 4 characters of SSN. User name can be generated in combination of few first digits and few last digits of SSN. Last digits of SSN are getting append to first digits. The variable used to store these digits is not getting reset after each user generation, hence it is getting increased in length and throwing exception once variable being overflow. This code is working perfectly for 1 employee but fails for multiple employees.

          Correction: We have corrected the code to reset the variable which stores the SSN digits.

          Workaround:
          The code fix will go on LB and stage in next week. Till then, you can change the settings on security to generate username, from last 4 characters to first 4 characters. We can regenerate the usernames later using SA utility if needed.

          CC: Ankur Deshpande Suraj SokasaneSnehal KatkarKira Hamilton

          Show
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - - edited Concern: Import not working on stage Cause: On Reinforced earth, user name generation uses last 4 characters of SSN. User name can be generated in combination of few first digits and few last digits of SSN. Last digits of SSN are getting append to first digits. The variable used to store these digits is not getting reset after each user generation, hence it is getting increased in length and throwing exception once variable being overflow. This code is working perfectly for 1 employee but fails for multiple employees. Correction: We have corrected the code to reset the variable which stores the SSN digits. Workaround: The code fix will go on LB and stage in next week. Till then, you can change the settings on security to generate username, from last 4 characters to first 4 characters. We can regenerate the usernames later using SA utility if needed. CC: Ankur Deshpande Suraj Sokasane Snehal Katkar Kira Hamilton
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 21/Oct/17 11:25 AM
          • Time Spent:
            5h
             
            <No comment>
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Remaining Estimate 8h [ 28800 ] 3h [ 10800 ]
          Time Spent 5h [ 18000 ]
          Worklog Id 85668 [ 85668 ]
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          khandu.kshirsagar 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)
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Jayshree Nagpure [ jayshree.nagpure ]
          Hide
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

          Deployed on LB and Azure

          Show
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - Deployed on LB and Azure
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Production Due Date 08/Nov/2017
          Stage Due Date 26/Oct/17 [ 2017-10-26 ]
          Kira.Hamilton Kira Hamilton (Inactive) made changes -
          Hide
          Kira.Hamilton Kira Hamilton (Inactive) added a comment -

          Per the client:

          There’s something else happening as well. When I went to load the employees (as I did several times successfully a few weeks ago), it now gives me an “Import Failed” error message (see screen shot attached w/in email), but when I look in the GUI employee list or SA Toolbox Delete option, all of the employees I loaded are there, but none of them are getting core plan allocations and the SA Toolbox core plan allocation won’t give them the coverage either. If I go into any of their demographics & simply hit “Save” without making any change whatsoever, and create a QE for any person on any date, it correctly gives them all the core coverages they should be getting when I loaded them. It’s also doing this with group COB, so I think it’s something new and systemic.

          Has something changed recently in Stage? How can this be corrected?

          RE Group Reinforced Earth in Stage WT-11702.msg

          Thank you,
          Kira Hamilton
          Debbie Kulling

          Show
          Kira.Hamilton Kira Hamilton (Inactive) added a comment - Per the client: There’s something else happening as well. When I went to load the employees (as I did several times successfully a few weeks ago), it now gives me an “Import Failed” error message (see screen shot attached w/in email), but when I look in the GUI employee list or SA Toolbox Delete option, all of the employees I loaded are there, but none of them are getting core plan allocations and the SA Toolbox core plan allocation won’t give them the coverage either. If I go into any of their demographics & simply hit “Save” without making any change whatsoever, and create a QE for any person on any date, it correctly gives them all the core coverages they should be getting when I loaded them. It’s also doing this with group COB, so I think it’s something new and systemic. Has something changed recently in Stage? How can this be corrected? RE Group Reinforced Earth in Stage WT-11702.msg Thank you, Kira Hamilton Debbie Kulling
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 24/Oct/17 07:38 AM
          • Time Spent:
            0.5h
             

            Core plan allocation and import failure issue check up.

          Hide
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

          Hi Kira Hamilton,

          Import still is still failing on stage because of WT-10897. We are reverting it from stage. Because of this issue import is completed but while showing status it get failed. This left the core plan allocation routine untouched after import.
          I have tried to allocation LTD using SA toolbox on HSPL copy and I am able to allocate core plans. If you still found any issue related to core plan allocation please open separate ticket.

          Show
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - Hi Kira Hamilton , Import still is still failing on stage because of WT-10897 . We are reverting it from stage. Because of this issue import is completed but while showing status it get failed. This left the core plan allocation routine untouched after import. I have tried to allocation LTD using SA toolbox on HSPL copy and I am able to allocate core plans. If you still found any issue related to core plan allocation please open separate ticket.
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Remaining Estimate 3h [ 10800 ] 2.5h [ 9000 ]
          Time Spent 5h [ 18000 ] 5.5h [ 19800 ]
          Worklog Id 85992 [ 85992 ]
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
          Hide
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

          Hi Jaideep Vinchurkar,

          Verified on LB
          Company - QA caiso

          Verified scenario are attached in Xls doc EmployeeImport.xls
          Working fine as expected

          Marking item state as Ready for Stage

          Thanks,
          Jayshree

          cc : Rakesh Roy Prasad Pise

          Show
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi Jaideep Vinchurkar , Verified on LB Company - QA caiso Verified scenario are attached in Xls doc EmployeeImport.xls Working fine as expected Marking item state as Ready for Stage Thanks, Jayshree cc : Rakesh Roy Prasad Pise
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Attachment EmployeeImport.xls [ 65458 ]
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          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)
          jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 24/Oct/17 12:46 PM
          • Time Spent:
            3.5h
             

            Testing on LB

          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Remaining Estimate 2.5h [ 9000 ] 0h [ 0 ]
          Time Spent 5.5h [ 19800 ] 9h [ 32400 ]
          Worklog Id 86080 [ 86080 ]
          amruta.lohiya Amruta Lohiya made changes -
          Assignee Jayshree Nagpure [ jayshree.nagpure ] Amruta Lohiya [ amruta.baheti ]
          amruta.lohiya Amruta Lohiya made changes -
          Assignee Amruta Lohiya [ amruta.baheti ] Jaideep Vinchurkar [ jaideep.vinchurkar ]
          Hide
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

          Import is working fine on stage after reverting WT-10897. We also have executed core plan allocation on main Reinfornced Earth stage.

          Show
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - Import is working fine on stage after reverting WT-10897 . We also have executed core plan allocation on main Reinfornced Earth stage.
          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Company Reinforced Earth [ 18441 ]
          Root Cause Deployment [ 18428 ]
          suraj.sokasane Suraj Sokasane (Inactive) logged work - 25/Oct/17 03:36 PM
          • Time Spent:
            0.75h
             

            HSPL creation
            Stage verification of issue

          suraj.sokasane Suraj Sokasane (Inactive) made changes -
          Time Spent 9h [ 32400 ] 9.75h [ 35100 ]
          Worklog Id 86424 [ 86424 ]
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Labels Manual_import
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Jayshree Nagpure [ jayshree.nagpure ]
          jaideep.vinchurkar Jaideep Vinchurkar (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)
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          Hide
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

          Verified on Stage.
          Company - ASML For Hspl

          Verified attached scenario
          Working fine
          Moving this jira to Production

          Thanks,
          Jayshree

          cc : Rakesh Roy Prasad Pise

          Show
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified on Stage. Company - ASML For Hspl Verified attached scenario Working fine Moving this jira to Production Thanks, Jayshree cc : Rakesh Roy Prasad Pise
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          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)
          jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 02/Nov/17 12:40 PM
          • Time Spent:
            1.5h
             

            Stage testing

          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Time Spent 9.75h [ 35100 ] 11.25h [ 40500 ]
          Worklog Id 88836 [ 88836 ]
          satyap Satya made changes -
          Environment_New Stage [ 18443 ]
          jaideep.vinchurkar Jaideep Vinchurkar (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)
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
          Hide
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

          Verified on Production
          Company - Symphony For Hspl

          Verified attached scenario
          Working fine

          CC: Rakesh Roy Prasad Pise

          Show
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified on Production Company - Symphony For Hspl Verified attached scenario Working fine CC: Rakesh Roy Prasad Pise
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          Transition Time In Source Status Execution Times
          Jaideep Vinchurkar (Inactive) made transition -
          Open In Development
          1d 22h 27m 1
          Jayshree Nagpure (Inactive) made transition -
          In Development In LB Testing
          2d 1h 17m 1
          Jayshree Nagpure (Inactive) made transition -
          In LB Testing Stage Testing
          9d 23h 2m 1
          Jayshree Nagpure (Inactive) made transition -
          Stage Testing In Production Testing
          2d 1h 8m 1
          Jayshree Nagpure (Inactive) made transition -
          In Production Testing Production Complete
          1d 22h 30m 1

            People

            Assignee:
            jayshree.nagpure Jayshree Nagpure (Inactive)
            Reporter:
            Kira.Hamilton Kira Hamilton (Inactive)
            Account Executive:
            Debbie Kulling
            Developer:
            Jaideep Vinchurkar (Inactive)
            QA:
            Jayshree Nagpure (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Dev Due Date:
              Pre-Prod Due Date:
              Production Due Date:
              Code Review Date:

                Time Tracking

                Estimated:
                Original Estimate - 8h Original Estimate - 8h
                8h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 11.25h
                11.25h