Hi All ,

Please find details as below ,

Concern : Wacker Import Failed

Cause : This issues is because code failure to check duplicate sequence if single file fields mapped on multiple DB fields with required flag set to "yes". This causes an issues to add duplicate value in hash table hence raising an error.

Correction : We have provided code fix and its under review.

Work Around : Mean while we have unchecked "is required" fields for "Original hire date" from template " Employee Ongoing New Hires".

Impacted Area : None

Test Scenario:

• Map single template fields on multiple DB fields
• Marked "IS Required" to checked.
• Import succeeded if we marked Required fields for Multiple DB fields.

Affected Files :

• \App\BusinessLogic\ImportExportDTS\ImportValidation.vb

Jaideep Vinchurkar Pleas have a review.

Thanks !

Good to LB Checkin

Hi Vishal Bajad,

Verified on LB
Company - City of durham for hspl.

Verified following scenario's
1)Map single template fields on multiple DB fields
2)Marked "IS Required" to checked.
3)Import succeeded if we marked Required fields for Multiple DB fields.

This scenario worked fine when for sub template (Date of employment) is mapped to Date of employment and employee effective date with "Is required flag set to yes"
Also reproduced issue on stage .

But in additional We have verified for first name
Sub template name -> FN
FN is mapped to Employee first name and Employee full name.
with is uniquee required flag to yes
Import is failed - following is error log
ErrorID : 0
ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportValidation.ImportData->ImportValidation.ProcessImportDataFile->ImportValidation.ProcessLineForBadRecord->ImportValidation.ValidateData
ErrorMessage: Object reference not set to an instance of an object.

Same issue exists on stage also.
Hence re-opening this jira.

Thanks,
Jayshree

cc : Rakesh Roy Prasad Pise

Hi All ,

Please find details as below ,

Concern : Wacker Import Failed , when First Name is mapped to Employee first name and Employee full name

Cause : code failure to check Object Null if we mapped multiple fields

Correction : Provided code fix and its under review.

Impacted Area : Not able to import fields which is not exist in DB.

Test Scenario:

• First Name is mapped to Employee first name and Employee full name : No Error but only first name updated. Employee full name
• First Name is mapped to Employee first name and Employee middle name : First Name and Middle is updated successfully.

Affected Files :

• App\BusinessLogic\ImportExportDTS\ImportValidation.vb

Jaideep Vinchurkar Please have a review.

Thanks !

Good to LB checkin

Hi Vishal Bajad,

Verified on LB
Company - QA FDU, QA city of durham for hspl, QA caiso for hspl

Verified following scenario's
1)Map single template fields on multiple DB fields
2)Marked "IS Required" to checked.
3)Import succeeded if we marked Required fields for Multiple DB fields.

• This scenario worked fine when for sub template (Date of employment) is mapped to Date of
  employment and employee effective date with "Is required flag set to yes"
• When we map Employee First name to First name and middle name
  and at the same time Employee Date of employment is mapped to employee effective date and DOE- This scenario worked fine(Import done successful)
• When Sub template name -> FN
  FN is mapped to Employee first name and Employee full name - Import done successully
• When Employee FN mapped to Emp FN and Full name and at the same time Employee Date of employment is mapped to employee effective date and DOE - Import failed

Error Log : ErrorID : 0
ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportValidation.ImportData->ImportValidation.ProcessImportDataFile->ImportValidation.ProcessLineForBadRecord->ImportValidation.ValidateData
ErrorMessage: Object reference not set to an instance of an object.

Note : Verified by restoring company, Creating new template on mentioned company.

Hence re-opening this jira.

Thanks,
Jayshree

cc : Rakesh Roy Prasad Pise

Hi All ,

Please find details as below ,

Concern : Wacker Import Failed

Cause : This issues is because code failure to check values for multiple mapped fields. Multiple mapped hash is getting filled with Zero index instead of that its should be filled as per mapped fields sequence. hence finding value with zero index raising an error.

Correction : We have provided code fix and its under review.

Test Scenario:

• Map single or multiple template fields on multiple DB fields
• Marked "IS Required" to checked.
• Import succeeded if we marked Required fields for Multiple DB fields.

Affected Files :

• \App\BusinessLogic\ImportExportDTS\ImportValidation.vb

Jaideep Vinchurkar Pleas have a review.

Thanks !

Hi Vishal Bajad,

we do not required code change here. Here employee full name field was mapped as second field, which is a export field and should not be shown in import mapping screen.
we have WT-11192 for such fields. Please revert your changes. If scenrio mentioned by Jayshree Nagpure is working with valid import field. no code fix is required for this issue.

Hi Jayshree Nagpure ,

I have verified with valid fields its working fine.Please verify.

Thanks !

Hi Vishal Bajad,

Verified below scenario :
1)Marked Date of Employee as required - Pass
2)Mapped DOE with DOE and Effective date - Pass
3)Marked all mandatory field as Is Required for Demographics import - Import done successfully
4)Also verified Spouse and Child data with "IS required" as YES - Pass
Working fine

Hence marking item state as Ready fo stage

Thanks,
Jayshree

verified on stage
Company - ASML for hspl

Verified below scenario :
1)Marked Date of Employee as required - Pass
2)Mapped DOE with DOE and Effective date - Pass
3)Marked all mandatory field as Is Required for Demographics import - Import done successfully
4)Also verified Spouse and Child data with "IS required" as YES - Pass
5))Marked Date of Employee as required - pass date of Employment as blank - Pass

Working fine
Hence marking item state as Ready fo Production

Thanks,
Jayshree

cc : Rakesh Roy Prasad Pise

verified on Production
Company - ASML for hspl

Verified below scenario :
1)Marked Date of Employee as required - Pass
2)Mapped DOE with DOE and Effective date - Pass
3)Marked all mandatory field as Is Required for Demographics import - Import done successfully
4)Also verified Spouse and Child data with "IS required" as YES - Pass
5))Marked Date of Employee as required - pass date of Employment as blank - Pass

Working fine
Hence marking item state as Production complete

Thanks,
Jayshree

cc : Rakesh Roy Prasad Pise