-
Type:
Bug
-
Status: Closed
-
Priority:
High
-
Resolution: Cannot Reproduce
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Environment:QA
-
Bug Severity:Medium
-
Module:BenAdmin - Import
-
Reported by:Harbinger
-
Sprint:WT Sprint 31-Bugs
Column wise import is getting failed when line item name is the combination of special characters refer below error log:
: ErrorID : 0
ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportValidationColumnWise.ImportData->ImportValidationColumnWise.ProcessImportDataFile->ImportValidationColumnWise.ValidateAndInsertData->ImportValidationColumnWise.ExecuteAllQueries
ErrorMessage: Incorrect syntax near ','.
Incorrect syntax near ','.
Incorrect syntax near ','.
Incorrect syntax near ','.
Incorrect syntax near ','.
- relates to
-
-
- Closed
-
LineItemName, containing special characters got imported successfully. Hence rejected.
Though above issue may occur if we use incorrect file format during import. The data should be in below format -
EmployeeSSN, EffectiveDate, LineItemName, ItemValue1, ItemValue2, ItemValue3, ItemValue4
Fields in bold have fixed positions. One can add other required fields after these above specified fields.
Snehal Katkar (Inactive)
added a comment - - edited LineItemName, containing special characters got imported successfully. Hence rejected.
Though above issue may occur if we use incorrect file format during import. The data should be in below format -
EmployeeSSN , EffectiveDate , LineItemName , ItemValue1, ItemValue2, ItemValue3, ItemValue4
Fields in bold have fixed positions. One can add other required fields after these above specified fields. Verified for column wise import Working fine as expected.
on hold as low priority
column wise import is still on stage only. no major impact is there for holding this