Similarly , If waiver reason is mapped in template and having BLANK or NULL values for waiver reason in File then Data imported successfully . Ideally it goes to bad file

will be taken while working on WT-9291

Concern - Waiver reason is mandatory for waiving the plan, but without waiver reason import was getting successful. Ideally it should go to bad file.

Cause - Waiver reason was not mandatory for waived data import.

Correction - Added mandatory check for waiver reason for waived data import.

Files having changes :
https://delta.harbinger.in/svn/WT/trunk/WORKTERRAweb/App/BusinessLogic/ImportExportDTS/ImportValidation.vb

Impacted Areas:
1) Manual Import - Waived data import

Unit test case scenario:
1) Waiver reason is mandatory for waived data import. If waiver reason is missing in file, it should go to bad file.

hi Snehal Katkar,

Verified on QA FDU company

Verified below scenario
1)Waive Import done for benefit type/Plan design without waiver reason - File wents to bad "Please provide waiver reason"
2)Waiver reason for benefit type/Plan design with waiver reason - System is accepting "blank", "~", and any other reasons - Not expected (System must accept waiver reason which are provided on DTS only as per UI)
3)DTS of Waiver reason is not getting ADD even though pop up is reflecting

As above mentioned 2 and 3 scenario's are not working hence re-opening this jira.

Thanks,
Jayshree

cc : Rakesh Roy Prasad Pise

Hi Jayshree Nagpure ,

Please find below item reported in LB testing.

• Waiver reason for benefit type/Plan design with waiver reason - System is accepting "blank", "~", and any other reasons - Not expected (System must accept waiver reason which are provided on DTS only as per UI) : We have provided code fix.
• DTS of Waiver reason is not getting ADD even though pop up is reflecting : In this scenario, there were no waiver reason available at company level hence it not allow to add in DTS.

Code fix will be deployed after review.

Thanks !

Company - QA Wheaton
Environment - LB

Verified below scenario
1)Waive Import done for benefit type/Plan design without waiver reason - File wents to bad "Please provide waiver reason"
2)Waiver reason for benefit type/Plan design with waiver reason - System is accepting "blank", "_{", and any other reasons - Pass(System must accepts waiver reason which are provided on DTS only as per UI for "}" and blank waiver reason file wents to bad
3)DTS of Waiver reason is getting ADD if waiver reason is present in company

Working fine
Marking item state as LB QA on hold, as other issues are still re-open

Thanks,
Jayshree

cc : Rakesh Roy Prasad Pise

Verified on stage
Company - City of bellevue for hspl

Verified below scenario
1)Waive Import done for benefit type/Plan design without waiver reason - File wents to bad "Please provide waiver reason"
2)Waiver reason for benefit type/Plan design with waiver reason - System is accepting "blank", "", and any other reasons - Pass(System must accepts waiver reason which are provided on DTS only as per UI for "" and blank waiver reason file wents to bad
3)DTS of Waiver reason is getting ADD if waiver reason is present in company

Marking item state as Ready for Production

Hi Snehal Katkar,

Verified on Production
Company - Je dunn for hspl, Caiso for hspl

When we map waiver reason, system throws server error
And On DTS by selecting map field -> We are getting server error

Please find error log :
ErrorID : 0
ErrorSource : ControllerAppTier.GetCollection->WORKTERRAControllerAppTier.GetData->CollectionManager.GetCollection->CollectionManager.GetImportExportMetaData
ErrorMessage: Invalid column name 'name'.
StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.GetCollection(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)
at WORKTERRA.ControllerAppTier.GetCollection(Int32 intProjectsId, String strInput)
TargetSite: System.String GetCollection(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)

Hence re-opening this jira

Thanks,
Jayshree

cc : Rakesh Roy Prasad Pise Jaideep Vinchurkar Vishal Bajad Suraj Sokasane Ankur Deshpande Snehal Katkar

Verified on Production
Working fine

Marking item state as Production complete