Concern : Duplicate fields visible on subtemplate if more than 1 fields are mapped. This caused server error while exporting the file.

Cause : When more than 1 fields are mapped, 2 different rows are stored in the database. While fetching on to subtemplate page instead of getting displayed as comma separated, 2 separate rows were occurring. This happened due to WT-9259 where Id's of the fields were fetched from Database which was the main reason for displaying 2 separate rows.

Correction : Fetched the Id's from database same as the text of the fields, which solved the issue and only 1 comma separated row is visible.

Regards,
Ankur

Hi Ankur Deshpande,

Verified on company
Company - QA ASML
Login - Partner

Verified below scenario through import :

• When 1 sub-template field is mapped to 2 mapping field : It creates single row.and shows in comma separated row - Pass
• Also verified all the unique scenario mentioned in WT-9259 - Pass
• When Emp Effective date is mapped with Employee effective date and other field, its creates 2 rows in sub template and position on file is duplicated - This scenario is not working fine

As last scenario is not working fine, hence re-opening this jira

Thanks,
Jayshree

cc : Rakesh Roy Prasad Pise

Hi Rajendra Pawar,

As per discussion can you please look into the issue.

Regards,
Ankur

It is giving server error while 2 fields are mapped.

Error occurred as below:-
-------------
*ErrorID : 0
ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->ImportExportSettings.Save->ImportExportSettings.AddUpdateMappingFields
ErrorMessage: Error converting data type varchar to bigint.*
------------

Aniruddha DevHrishikesh DeshpandeRakesh Roy

Ankur Deshpande, Please see error.

Verified this issue by Mapping Emp Effective date and Emp Cost,
It is working as expected.
Ready for stage.

CC-Aniruddha DevRakesh RoyGaurav SodaniRajendra PawarHrishikesh Deshpande

We are blocked to verify this JIRA due to it is related to wt-10294, hence changing status ON HOLD.
We will verify this JIRA after WT-10294 is deployed on STAGE

CC-Aniruddha DevHrishikesh DeshpandeGaurav SodaniRakesh Roy

Hi Swapnil Eksambekar,

I have verified this issue for import on stage

• When 1 sub-template field is mapped to 2 mapping field : It creates single row.and shows in comma separated row - Pass
• When Emp Effective date is mapped with Employee effective date and other field, its creates 1 rows and shows comma separated row - Pass

CC :Prasad Pise Rakesh Roy

What is final status of this? ready for stage?

Hi Swapnil Eksambekar,

Check this issue for export and update the jira accordingly

Thanks,
Jayshree

cc :Prasad Pise Rakesh Roy Jaideep Vinchurkar

Verified this issue by Mapping Emp Effective date and Emp Cost,
It is working as expected.
Ready for Production.

CC-Aniruddha DevHrishikesh DeshpandeRakesh RoyGaurav Sodani

Verified this Issue on Production it is working as expected.

CC-Aniruddha DevRakesh RoyHrishikesh Deshpande