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

            Activity

            Hide
            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)
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -
            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - CC : Rakesh Roy Prasad Pise
            Hide
            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)
            Hide
            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
            Hide
            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
            Hide
            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

              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