WORKTERRAProject Type: software

WORKTERRA

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

Waived Import - Import Failed

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      QA
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Import
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have
    • Sprint:
      WT Sprint 33-Bugs

      Description

      +underlined text+Precondition :
      1) Employee enrolled in Basic AD & D Plan
      2) Create waived import template [ Benefit Type Waive ]

      Replication Steps :
      1) Navigate to manual import export page
      2) Select file and import data

      Issue : Import Failed

      ErrorID : 0
      ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportValidation.ImportData->ImportValidation.GetPlanDesignHash
      ErrorMessage: Item has already been added. Key in dictionary: 'Mass Transit' Key being added: 'Mass Transit'

      CC - Sachin Hingole

        Attachments

        1. ImportFailed.jpg
          ImportFailed.jpg
          54 kB
        2. Plandesignallprovider.jpg
          Plandesignallprovider.jpg
          204 kB
        3. PlanDesignWaive.jpg
          PlanDesignWaive.jpg
          252 kB
        4. WaivedEffecDate.jpg
          WaivedEffecDate.jpg
          257 kB

          Issue Links

          blocks

          Enhancement - An improvement or enhancement to an existing feature or task. WT-8262 Importing Waived Benefit Type data

          • Low - Minor problem or easily worked around.
          • Production Complete

            Activity

            Ascending order - Click to sort in descending order
            meghana.joshi Meghana Joshi (Inactive) created issue -
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Field Original Value New Value
            Assignee Vijay Siddha [ vijays ] Suraj Sokasane [ suraj.sokasane ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Link This issue is blocked by WT-8262 [ WT-8262 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Link This issue is blocked by WT-8262 [ WT-8262 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Link This issue blocks WT-8262 [ WT-8262 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 33-Bugs [ 77 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] snehal katkar [ snehal.katkar ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Dev Due Date 26/Jul/2017
            Developer snehal katkar [ snehal.katkar ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Description Precondition :
            1) Employee enrolled in Basic AD & D Plan
            2) Create waived import template [ Benefit Type Waive ]

            Replication Steps :
            1) Navigate to manual import export page
            2) Select file and import data

            Issue : Import Failed

             !ImportFailed.jpg|thumbnail!

            ErrorID : 0
            ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportValidation.ImportData->ImportValidation.GetPlanDesignHash
            ErrorMessage: Item has already been added. Key in dictionary: 'Mass Transit' Key being added: 'Mass Transit'

            CC - [~sachin.hingole]             		+underlined text+Precondition :
            1) Employee enrolled in Basic AD & D Plan
            2) Create waived import template [ Benefit Type Waive ]

            Replication Steps :
            1) Navigate to manual import export page
            2) Select file and import data

            Issue : Import Failed

             !ImportFailed.jpg|thumbnail!

            ErrorID : 0
            ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportValidation.ImportData->ImportValidation.GetPlanDesignHash
            ErrorMessage: Item has already been added. Key in dictionary: 'Mass Transit' Key being added: 'Mass Transit'

            CC - [~sachin.hingole]
            Permalink
            snehal.katkar Snehal Katkar (Inactive) logged work - 20/Jul/17 06:26 PM - edited
            • Time Spent:
              4h
               

              Aalysis, discussion with Jaideep

            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 21/Jul/17 01:18 PM
            • Time Spent:
              0.5h
               
              <No comment>
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Remaining Estimate 40h [ 144000 ]
            Original Estimate 40h [ 144000 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Remaining Estimate 40h [ 144000 ] 39.5h [ 142200 ]
            Time Spent 0.5h [ 1800 ]
            Worklog Id 65354 [ 65354 ]
            Permalink
            snehal.katkar Snehal Katkar (Inactive) logged work - 21/Jul/17 06:29 PM
            • Time Spent:
              4h
               

              Analysis

            snehal.katkar Snehal Katkar (Inactive) made changes -
            Remaining Estimate 39.5h [ 142200 ] 34.5h [ 124200 ]
            Time Spent 0.5h [ 1800 ] 5.5h [ 19800 ]
            Worklog Id 65484 [ 65484 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Remaining Estimate 34.5h [ 124200 ] 30.5h [ 109800 ]
            Time Spent 5.5h [ 19800 ] 9.5h [ 34200 ]
            Worklog Id 65493 [ 65493 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Remaining Estimate 30.5h [ 109800 ] 31.5h [ 113400 ]
            Time Spent 9.5h [ 34200 ] 8.5h [ 30600 ]
            Worklog Id 65484 [ 65484 ]
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 24/Jul/17 03:05 PM
            • Time Spent:
              1h
               
              <No comment>
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Remaining Estimate 31.5h [ 113400 ] 30.5h [ 109800 ]
            Time Spent 8.5h [ 30600 ] 9.5h [ 34200 ]
            Worklog Id 65838 [ 65838 ]
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 25/Jul/17 01:59 PM
            • Time Spent:
              1.5h
               
              <No comment>
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Remaining Estimate 30.5h [ 109800 ] 29h [ 104400 ]
            Time Spent 9.5h [ 34200 ] 11h [ 39600 ]
            Worklog Id 66282 [ 66282 ]
            Permalink
            snehal.katkar Snehal Katkar (Inactive) logged work - 27/Jul/17 01:28 AM
            • Time Spent:
              3h
               

              Analysis, coding

            snehal.katkar Snehal Katkar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Code Review Date 27/Jul/2017
            Code Reviewed By Jaideep Vinchurkar [ 11908 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            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)
            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)
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Remaining Estimate 29h [ 104400 ] 28h [ 100800 ]
            Time Spent 11h [ 39600 ] 12h [ 43200 ]
            Worklog Id 67360 [ 67360 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Assignee snehal katkar [ snehal.katkar ] Prasad Pise [ prasadp ]
            Hide
            Permalink
            snehal.katkar Snehal Katkar (Inactive) added a comment -

            Concern: Waived Import - Import Failed

            Cause: If user selects all the plans present for template and multiple of them have same 'OldPlanDescriptionIdentifier' then it throws an exception because a hash can not contain duplicate keys.

            Correction: Added a check for duplicate plan design identifiers before processing file.

            Show
            snehal.katkar Snehal Katkar (Inactive) added a comment - Concern: Waived Import - Import Failed Cause: If user selects all the plans present for template and multiple of them have same 'OldPlanDescriptionIdentifier' then it throws an exception because a hash can not contain duplicate keys. Correction: Added a check for duplicate plan design identifiers before processing file.
            Hide
            Permalink
            snehal.katkar Snehal Katkar (Inactive) added a comment -

            Files having changes:
            1)D:\WT\trunk\WORKTERRAweb\App\BusinessLogic\ImportExportDTS\ExecuteImportDTS.vb

            Impacted areas:
            1) Manual Import for waived data

            Unit test scenarios:
            1) Select all the plans for template
            2) Check import for waived data

            Show
            snehal.katkar Snehal Katkar (Inactive) added a comment - Files having changes: 1)D:\WT\trunk\WORKTERRAweb\App\BusinessLogic\ImportExportDTS\ExecuteImportDTS.vb Impacted areas: 1) Manual Import for waived data Unit test scenarios: 1) Select all the plans for template 2) Check import for waived data
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Remaining Estimate 28h [ 100800 ] 25h [ 90000 ]
            Time Spent 12h [ 43200 ] 15h [ 54000 ]
            Worklog Id 67379 [ 67379 ]
            prasadp Prasad Pise (Inactive) made changes -
            Assignee Prasad Pise [ prasadp ] Jayshree Nagpure [ jayshree.nagpure ]
            Permalink
            snehal.katkar Snehal Katkar (Inactive) logged work - 28/Jul/17 01:16 AM
            • Time Spent:
              1h
               

              Unit testing, jira update

            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
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Hi Snehal Katkar,

            Verified on LB
            Company - CAISO

            Verified below scenario :

            1)Selected all plan for template - system wont allow to import for benefit type and plan design
            2)Imported the data for waived import - Import done successfully
            3)Import done marking SSN/Emp ID, benefit type/Plan design as unique- Import done successfully
            4)Cross verified on view history - waived effective date is shown.
            5)Plan is not waived as its implementation is not yet done,and also not verified effective and termination date scenario as its not implemented

            Thanks,
            Jayshree

            cc : Rakesh Roy Prasad Pise Suraj Sokasane

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi Snehal Katkar , Verified on LB Company - CAISO Verified below scenario : 1)Selected all plan for template - system wont allow to import for benefit type and plan design 2)Imported the data for waived import - Import done successfully 3)Import done marking SSN/Emp ID, benefit type/Plan design as unique- Import done successfully 4)Cross verified on view history - waived effective date is shown. 5)Plan is not waived as its implementation is not yet done,and also not verified effective and termination date scenario as its not implemented Thanks, Jayshree cc : Rakesh Roy Prasad Pise Suraj Sokasane
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment Plandesignallprovider.jpg [ 57144 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment PlanDesignWaive.jpg [ 57145 ]
            Attachment WaivedEffecDate.jpg [ 57146 ]
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 28/Jul/17 01:05 PM
            • Time Spent:
              4h
               

              Testing on LB
              Discussion
              Issue locking

            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Remaining Estimate 25h [ 90000 ] 21h [ 75600 ]
            Time Spent 15h [ 54000 ] 19h [ 68400 ]
            Worklog Id 67737 [ 67737 ]
            Hide
            Permalink
            snehal.katkar Snehal Katkar (Inactive) added a comment - - edited

            Waived Import enhancement is only on LB. So, marking it as on hold.

            Show
            snehal.katkar Snehal Katkar (Inactive) added a comment - - edited Waived Import enhancement is only on LB. So, marking it as on hold.
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Bug Severity Medium [ 16702 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            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)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Code Review Date 27/Jul/2017 27/Jul/2017
            Dev Due Date 26/Jul/2017 26/Jul/2017
            Production Due Date 14/Sep/2017
            Stage Due Date 11/Sep/17 [ 2017-09-11 ]
            snehal.katkar Snehal Katkar (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
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Verified on Stage
            Company - City of bellevue for hspl

            Imported the data for waived import - Import done successfully
            Verified and its working fine.
            Marking item state as Ready for production

            cc : Rakesh Roy Prasad Pise

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified on Stage Company - City of bellevue for hspl Imported the data for waived import - Import done successfully Verified and its working fine. Marking item state as Ready for production cc : Rakesh Roy Prasad Pise
            snehal.katkar Snehal Katkar (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)
            khandu.kshirsagar 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)
            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)
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Verified on Production
            Working fine

            Marking item state as Production complete

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified on Production Working fine Marking item state as Production complete
            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 -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            satyap Satya made changes -
            Environment_New LB [ 18444 ]
            Transition Time In Source Status Execution Times
            Snehal Katkar (Inactive) made transition -
            Open In Development
            		85d 17h 52m 1
            Gaurav Sodani (Inactive) made transition -
            In Development In LB Testing
            		12d 6h 38m 1
            Jayshree Nagpure (Inactive) made transition -
            In LB Testing Stage Testing
            		42d 22h 19m 1
            Jayshree Nagpure (Inactive) made transition -
            Stage Testing In Production Testing
            		1d 54m 1
            Jayshree Nagpure (Inactive) made transition -
            In Production Testing Production Complete
            		7s 1

              People

              Assignee:
              jayshree.nagpure Jayshree Nagpure (Inactive)
              Reporter:
              meghana.joshi Meghana Joshi (Inactive)
              Developer:
              Snehal Katkar (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 - 40h
                  40h
                  Remaining:
                  Time Spent - 19h Remaining Estimate - 21h
                  21h
                  Logged:
                  Time Spent - 19h Remaining Estimate - 21h
                  19h