ErrorID : 0
ErrorSource : ControllerAppTier.GetCollection->BenAdminControllerAppTier.GetData->CollectionManager.GetCollection->CollectionManager.GetEligibileBenefitTypesForGivenEffectiveDate->Eligibility.GetEligibleBenefitTypes_EnrollNow->Eligibility.FetchCheckEligibilityForPlanDesign_EnrollNow_Ex
ErrorMessage: Incorrect syntax near 's'.
StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.GetCollection(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity)

Hi Prasad Pise,

Server error is coming due to syntax error in Generic Eligibility Criteria Query.
We have scanned all rules and found following Rules whose criteria query is not proper:

1. Medical HRA Rule
2. Medical HSA Rule

As of now, we have corrected criteria query from back end so server error will not come on Enroll Now screen.

While finding root cause for this issue we found that additional field - check box is used in rule .
Checkbox option values contain single quote i.e. * ' *.
Due to this server error is coming on Enroll now screen.

This is issue in EDS. Sheetal Bodhale Please check this.

Note : If above 2 mentioned Eligibility rules saved from screen, then server error issue will again come.

CC : Satya, Rakesh Roy, Jyoti Mayne

Hello Prasad Pise,

As per above comment by Vinanti Yadav, the server error was because of * ' * (single quote).
Now single quote in Checkbox name is not allowed. So it will not produce server error.

Thanks,
Aarati R. Sabnis
CC Satya,Sheetal Bodhale

Impacted areas : Basic settings of Checkbox

Affected Files : WT-9127-AffectedFiles.txt

Verified on Lb Environment.
Additional form or additional filed check box Single quote (') not allowed.
it is showing validation message.
working properly as expected

Verified on Stage Environment.
Additional form or additional filed check box Single quote (') not allowed.
it is showing validation message.
working properly as expected

Verified on Production Environment.
Additional form or additional filed check box Single quote (') not allowed.
it is showing validation message.
working properly as expected