Jaideep Vinchurkar Could you please check this on priority?

Vijay Siddha

Verified on LB on Environment.
Found one issue below is the steps.
1]Create format pay check template
2]again go to the Field mapping screen change the mapping of two filed.
3]Save template properly
4]go to sub template page it showing one filed Unmapped
5]Again go to the filed mapping screen it not showing unmapped filed on Template filed box.

refer below screen shots.

This was not reproduced on Wheaton copy on Local. I tried to take the Windstream to local but facing space issues on WTDEVDBSERVER.
I'll look into this tomorrow.

Repro frequency is low of this issue. Not yet able to repro on local dev environment or able to deduce any root cause

Please update scenario and 3C's

3 C's :
Concern: Format paycheck-Getting server error for Update template for format paycheck.
Cause: Records from table ImportExportMappingPaycheckData were getting deleted when mapping and unmapping of lineitem was being done.
Correction: Persisted the Id's of the record from table ImportExportMappingPaycheckData which were getting deleted and was utilized for processing.

Update Scenario :

1) When lineitems were mapped and saved and again unmapped and saved in the same order and then saved, complete mapping was getting removed.
2) Also when 1 mapping was changed with other some lineitems were not getting mapped.

verified on Lb environment.
Getting server error on filed mapping screen when changing mapping fields and click on save button.
see below error log:

ErrorID : 0
ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->ImportExportSettings.Save->ImportExportSettings.AddUpdateMappingFields
ErrorMessage: Incorrect syntax near ','.
------------
------------
update174
------------
------------
------------
------------
@UserDefinedFields
7814,7815
@UserDefinedFields28,37,38,,34
DELETE FROM ImportExportMappingPaycheckData WHERE id not IN(28,37,38,,3) AND importexportfieldsid in(select id from importexportfields WHERE ImportExportSubTemplateID=459)
UPDATE ImportExportMappingFieldsData SET IsMappedMultiple = 0 WHERE ImportExportFieldsID IN(SELECT ImportExportFieldsID FROM ImportExportMappingFieldsData WHERE IsMappedMultiple = 1 AND ImportExportFieldsID IN (13816,13817,13818,13819,13820,13822)

GROUP BY ImportExportFieldsID HAVING COUNT(ImportExportFieldsID) = 1)
UPDATE IMPORTEXPORTFIELDS SET ISNONMAPPED=1 WHERE ImportExportSubTemplateID= 459 AND ID not IN(13816,13817,13818,13819,13820,13822)
UPDATE IMPORTEXPORTFIELDS SET ISNONMAPPED=0 WHERE ImportExportSubTemplateID= 459 AND ID IN(13816,13817,13818,13819,13820,13822)
delete from ImportExportMapFields where importexportfields_id in( select id from importexportfields where id in( select distinct importexportfieldsid FROM ImportExportMappingFieldsData WHERE importexportfieldsid not IN(13816,13817,13818,13819,13820,13822)) and importexportsubtemplateid=459)
DELETE FROM ImportExportMappingFieldsData WHERE id not IN(7814,7815) AND importexportfieldsid in(select id from importexportfields WHERE ImportExportSubTemplateID=459)

verified on Lb environment.
mapping filed issue is solved
but when import file it is failed.
below is error log:

ErrorID : 0
ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData->ImportValidation.ImportData->ImportValidation.PopulateLineItemValueMappingHash
ErrorMessage: Conversion from type 'DBNull' to type 'String' is not valid.

The mapping was not customized properly, so not considering it as an issue.

Verified on LB working fine

Verified this on Stage.
Getting server error:

error log:

ErrorSource : ControllerAppTier.GetData->WORKTERRAControllerAppTier.GetData->ImportExportSettings.GetData->ImportExportSettings.GetMappingFieldData
ErrorMessage: ImportExportFieldTypeID
StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.GetData(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)
at WORKTERRA.ControllerAppTier.GetData(Int32 intProjectsId, String strInput)
TargetSite: System.String GetData(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)

Steps to re-pro:
1]Create template for paycheck type.
2]again got to the Field mapping screen throwing server error.
tried on more than 2 company.

Verified on LB Environment.
For paycheck import on Filed mapping screen not getting any error.
working fine.

Verified on Stage Environment.
For paycheck import on Filed mapping screen not getting any error.
working fine.

Hi Rashmita
Please confirm if this bug resolved?
Can LONG paycheck data be imported into WT stage?

do provide update
thanks,
Chitra
Monika Demla
Amannda Johnson

Chitra Rao This fix is deployed on stage and production. Please check and confirm.