WORKTERRAProject Type: software

WORKTERRA

Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-9127

Hope Community Resources - Server error on enroll now page

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Stage
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - EDS
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed

      Description

      Server error on enroll now page--
      Checked test employee

        Attachments

          Issue Links

          is cloned by

          Support Activity - Support Activity WT-10843 OE regression for WT-9127

          • Medium - Has the potential to affect progress.
          • Resolved

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            rakeshr Rakesh Roy (Inactive) added a comment -

            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)

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - 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)
            Hide
            Permalink
            vinanti.yadav Vinanti Yadav (Inactive) added a comment -

            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

            Show
            vinanti.yadav Vinanti Yadav (Inactive) added a comment - 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
            Hide
            Permalink
            aarati.sabnis Aarati Sabnis (Inactive) added a comment -

            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

            Show
            aarati.sabnis Aarati Sabnis (Inactive) added a comment - 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
            Hide
            Permalink
            aarati.sabnis Aarati Sabnis (Inactive) added a comment -

            Impacted areas : Basic settings of Checkbox

            Show
            aarati.sabnis Aarati Sabnis (Inactive) added a comment - Impacted areas : Basic settings of Checkbox
            Hide
            Permalink
            aarati.sabnis Aarati Sabnis (Inactive) added a comment -

            Affected Files : WT-9127-AffectedFiles.txt

            Show
            aarati.sabnis Aarati Sabnis (Inactive) added a comment - Affected Files : WT-9127-AffectedFiles.txt
            Hide
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

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

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified on Lb Environment. Additional form or additional filed check box Single quote (') not allowed. it is showing validation message. working properly as expected
            Hide
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

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

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified on Stage Environment. Additional form or additional filed check box Single quote (') not allowed. it is showing validation message. working properly as expected
            Hide
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment -

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

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - Verified on Production Environment. Additional form or additional filed check box Single quote (') not allowed. it is showing validation message. working properly as expected

              People

              Assignee:
              rashmita.dudhe Rashmita Dudhe (Inactive)
              Reporter:
              rakeshr Rakesh Roy (Inactive)
              Developer:
              Aarati Sabnis (Inactive)
              QA:
              Prasad Pise (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 24h
                  24h
                  Remaining:
                  Time Spent - 21.25h Remaining Estimate - 2.75h
                  2.75h
                  Logged:
                  Time Spent - 21.25h Remaining Estimate - 2.75h
                  21.25h