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

Job Data Import Is getting Failed

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Stage
    • Bug Severity:
      Medium
    • Module:
      Recruit
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Dev Estimates:
      1

      Description

      Job Data Import Is getting failed on Stage
      when i import attached file.
      For Job Data Import
      JobTitle JobCode is unique and Required filed.

      Refer attached file
      when duplicate entry is coming against any one of the above unique criteria file should be went to bad instead of failed with proper validation message

      Refer below Error Log:
      ErrorID : 0
      ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportRecruitData.ImportData->ImportRecruitData.ProcessImportDataFile->ImportRecruitData.ValidateAndInsertData->ImportRecruitData.ProcessJob->ImportRecruitData.ExecuteSqlQueries
      ErrorMessage: The variable name '@ID' has already been declared. Variable names must be unique within a query batch or stored procedure.
      The variable name '@ID' has already been declared. Variable names must be unique within a query batch or stored procedure.
      The variable name '@ID' has already been declared. Variable names must be unique within a query batch or stored procedure.
      The variable name '@ID' has already been declared. Variable names must be unique within a query batch or stored procedure.
      The variable name '@ID' has already been declared. Variable names must be unique within a query batch or stored procedure.
      StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.SaveAndGetData(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)
      at WORKTERRA.ControllerAppTier.SaveAndGetData(Int32 intProjectsId, String strInput)
      TargetSite: System.String SaveAndGetData(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              rashmita.dudhe Rashmita Dudhe (Inactive)
              Reporter:
              rashmita.dudhe Rashmita Dudhe (Inactive)
              Developer:
              Vishal Bajad (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

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