WORKTERRAProject Type: software

WORKTERRA

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

Import -> Import fail for demographics data update

    Details

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

      Description

      Company - Austin for hspl, City of bellevue for hspl

      1)Login with Partner
      2)Select company
      3)Create demographic template
      4)Import the file -> Import done successfully for multiple employee
      5)Updated last name of 1 st employee from file -> Import done successfully
      6)Updated last name for all 3 employee from file -> Import failed

      Note : Same scenario worked properly on LB(QA caiso for hspl)
      With same security customization i.e Data update for all 3 Employee -> Import done successfully

      Please note : Once Import is failed, even new employee cannot be inserted.In each and every attempt import gets failed

        Attachments

        1. EmployeeImport.xls
          9 kB
        2. Error.jpg
          Error.jpg
          195 kB
        3. JeDunnStage.jpg
          JeDunnStage.jpg
          189 kB
        4. LBUpdate.jpg
          LBUpdate.jpg
          200 kB

          Issue Links

          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. WT-10805 User generation for failed Imports after Employee data is inserted - Implementation

          • Medium - Has the potential to affect progress.
          • Production Complete

            Activity

            Ascending order - Click to sort in descending order
            jayshree.nagpure Jayshree Nagpure (Inactive) created issue -
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - - edited

            City of bellevue for hspl

            ErrorID : 0
            ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportValidation.ImportData->ImportValidation.GetUniqueUserNameHashTable
            ErrorMessage: Item has already been added. Key in dictionary: 'new01011990xyz' Key being added: 'new01011990xyz'
            StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.SaveAndGetData(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)
            at WORKTERRA.ControllerAppTier.SaveAndGetData(Int32 intProjectsId, String strInput)
            TargetSite: System.String SaveAndGetData(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - - edited City of bellevue for hspl ErrorID : 0 ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportValidation.ImportData->ImportValidation.GetUniqueUserNameHashTable ErrorMessage: Item has already been added. Key in dictionary: 'new01011990xyz' Key being added: 'new01011990xyz' StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.SaveAndGetData(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity) at WORKTERRA.ControllerAppTier.SaveAndGetData(Int32 intProjectsId, String strInput) TargetSite: System.String SaveAndGetData(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Field Original Value New Value
            Attachment Error.jpg [ 64582 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment LBUpdate.jpg [ 64583 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Assignee Satya [ ID10004 ] Ankur Deshpande [ ankur.deshpande ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Link This issue relates to WT-10805 [ WT-10805 ]
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            CC : Rakesh Roy Prasad Pise

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - CC : Rakesh Roy Prasad Pise
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Description Company - Austin for hspl, City of bellevue for hspl

            1)Login with Partner
            2)Select company
            3)Create demographic template
            4)Import the file -> Import done successfully for multiple employee
            5)Updated last name of 1 st employee from file -> Import done successfully
            6)Updated last name for all employee from file -> Import failed

            Note : Same scenario worked properly on LB(QA caiso for hspl)
            With same security customization
            		Company - Austin for hspl, City of bellevue for hspl

            1)Login with Partner
            2)Select company
            3)Create demographic template
            4)Import the file -> Import done successfully for multiple employee
            5)Updated last name of 1 st employee from file -> Import done successfully
            6)Updated last name for all employee from file -> Import failed

            Note : Same scenario worked properly on LB(QA caiso for hspl)
            With same security customization

            Please note : Once Import is failed, even new employee cannot be inserted.In each and every attempt import gets failed
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment JeDunnStage.jpg [ 64587 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Description Company - Austin for hspl, City of bellevue for hspl

            1)Login with Partner
            2)Select company
            3)Create demographic template
            4)Import the file -> Import done successfully for multiple employee
            5)Updated last name of 1 st employee from file -> Import done successfully
            6)Updated last name for all employee from file -> Import failed

            Note : Same scenario worked properly on LB(QA caiso for hspl)
            With same security customization

            Please note : Once Import is failed, even new employee cannot be inserted.In each and every attempt import gets failed             		Company - Austin for hspl, City of bellevue for hspl

            1)Login with Partner
            2)Select company
            3)Create demographic template
            4)Import the file -> Import done successfully for multiple employee
            5)Updated last name of 1 st employee from file -> Import done successfully
            6)Updated last name for all 3 employee from file -> Import failed

            Note : Same scenario worked properly on LB(QA caiso for hspl)
            With same security customization i.e Data update for all 3 Employee -> Import done successfully

            Please note : Once Import is failed, even new employee cannot be inserted.In each and every attempt import gets failed
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Error Log for JE Dun for hspl :

            ErrorID : 0
            ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportValidation.ImportData->ImportValidation.GetUniqueUserNameHashTable
            ErrorMessage: Item has already been added. Key in dictionary: 'test89' Key being added: 'test89'
            StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.SaveAndGetData(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)
            at WORKTERRA.ControllerAppTier.SaveAndGetData(Int32 intProjectsId, String strInput)
            TargetSite: System.String SaveAndGetData(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Error Log for JE Dun for hspl : ErrorID : 0 ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportValidation.ImportData->ImportValidation.GetUniqueUserNameHashTable ErrorMessage: Item has already been added. Key in dictionary: 'test89' Key being added: 'test89' StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.SaveAndGetData(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity) at WORKTERRA.ControllerAppTier.SaveAndGetData(Int32 intProjectsId, String strInput) TargetSite: System.String SaveAndGetData(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 17/Oct/17 04:33 PM
            • Time Spent:
              0.5h
               

              Discussion with Ankur
              Issue reproduced on stage

            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 0.5h [ 1800 ]
            Worklog Id 85510 [ 85510 ]
            Permalink
            ankur.deshpande Ankur Deshpande (Inactive) logged work - 20/Oct/17 02:47 PM
            • Time Spent:
              1.5h
               
              <No comment>
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Company JE Dunn [ 10476 ]
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            Original Estimate 0h [ 0 ]
            Hide
            Permalink
            ankur.deshpande Ankur Deshpande (Inactive) added a comment -

            Concern : Import fail for demographics data update.

            Cause : If there are more than 1 employee in file which will generate the same user name and the employees are new, then same username was getting inserted in the system. Due to this error was occurring.

            Correction : Checked the username before getting inserted in the system and if the user is present them user id is appended to the username.

            Regards,
            Ankur

            Show
            ankur.deshpande Ankur Deshpande (Inactive) added a comment - Concern : Import fail for demographics data update. Cause : If there are more than 1 employee in file which will generate the same user name and the employees are new, then same username was getting inserted in the system. Due to this error was occurring. Correction : Checked the username before getting inserted in the system and if the user is present them user id is appended to the username. Regards, Ankur
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Assignee Ankur Deshpande [ ankur.deshpande ] Jayshree Nagpure [ jayshree.nagpure ]
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            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 - 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 [ 65459 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 24/Oct/17 12:46 PM
            • Time Spent:
              2.5h
               

              Testing on LB

            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 0.5h [ 1800 ] 3h [ 10800 ]
            Worklog Id 86078 [ 86078 ]
            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)
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Time Spent 3h [ 10800 ] 4.5h [ 16200 ]
            Worklog Id 87978 [ 87978 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Labels Manual_import
            khandu.kshirsagar Khandu Kshirsagar (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)
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Verified on Stage.
            Company - ASML For Hspl

            Working fine
            Moving this jira to Production

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified on Stage. Company - ASML For Hspl Working fine Moving this jira to Production
            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)
            satyap Satya made changes -
            Environment_New Stage [ 18443 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            ankur.deshpande Ankur Deshpande (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 ]
            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
            Jayshree Nagpure (Inactive) made transition -
            Open In Development
            		8d 3h 36m 1
            Jayshree Nagpure (Inactive) made transition -
            In Development In LB Testing
            		4s 1
            Rakesh Roy (Inactive) made transition -
            In LB Testing Stage Testing
            		11d 1h 19m 1
            Jayshree Nagpure (Inactive) made transition -
            Stage Testing In Production Testing
            		3d 21h 26m 1
            Jayshree Nagpure (Inactive) made transition -
            In Production Testing Production Complete
            		1m 23s 1

              People

              Assignee:
              jayshree.nagpure Jayshree Nagpure (Inactive)
              Reporter:
              jayshree.nagpure Jayshree Nagpure (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

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