-
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
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)
- relates to
-
WT-6798 Import - Recruit data - Implementation
- Production Complete