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
            rakeshr Rakesh Roy (Inactive) created issue -
            rakeshr Rakesh Roy (Inactive) made changes -
            Field Original Value New Value
            Summary Server error on enroll now page Hope Community Resources - Server error on enroll now page
            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)
            jyoti.mayne Jyoti Mayne made changes -
            Assignee Jyoti Mayne [ jyoti.mayne ] Vinanti Yadav [ vinanti.yadav ]
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Code Reviewed By Jyoti Mayne [ 11910 ]
            Dev Estimates 16
            Developer Vinanti Yadav [ vinanti.yadav ]
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Code Reviewed By Jyoti Mayne [ 11910 ]
            Dev Estimates 16 24
            Developer Vinanti Yadav [ vinanti.yadav ]
            Remaining Estimate 24h [ 86400 ]
            Original Estimate 24h [ 86400 ]
            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
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Module Parent values: BenAdmin(10100)Level 1 values: Enrollment(10107) Parent values: BenAdmin(10100)Level 1 values: EDS(10108)
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Assignee Vinanti Yadav [ vinanti.yadav ] Sheetal Bodhale [ sheetal.bodhale ]
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Remaining Estimate 24h [ 86400 ] 19h [ 68400 ]
            Time Spent 5h [ 18000 ]
            Worklog Id 37175 [ 37175 ]
            Permalink
            jyoti.mayne Jyoti Mayne logged work - 10/Apr/17 03:02 PM
            • Time Spent:
              0.75h
               

              discussion and comment review

            Permalink
            vinanti.yadav Vinanti Yadav (Inactive) logged work - 10/Apr/17 04:58 PM
            • Time Spent:
              5h
               

              Analysis.
              Data correction.
              Jira Updates.
              Discussion.

            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Assignee Sheetal Bodhale [ sheetal.bodhale ] Aarati Sabnis [ aarati.sabnis ]
            jyoti.mayne Jyoti Mayne made changes -
            Remaining Estimate 19h [ 68400 ] 18.25h [ 65700 ]
            Time Spent 5h [ 18000 ] 5.75h [ 20700 ]
            Worklog Id 37817 [ 37817 ]
            aarati.sabnis Aarati Sabnis (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)
            aarati.sabnis Aarati Sabnis (Inactive) made changes -
            Item State Parent values: Development(10200) Parent values: Development(10200)Level 1 values: In Progress(10206)
            Permalink
            aarati.sabnis Aarati Sabnis (Inactive) logged work - 14/Apr/17 12:58 PM
            • Time Spent:
              1.75h
               

              Unit testing
              Internal discussion with Vinanti
              Internal discussion with Jaideep about query resolution
              Code debugging
              Database records checking for special characters in checkbox names

            aarati.sabnis Aarati Sabnis (Inactive) made changes -
            Remaining Estimate 18.25h [ 65700 ] 16.5h [ 59400 ]
            Time Spent 5.75h [ 20700 ] 7.5h [ 27000 ]
            Worklog Id 38386 [ 38386 ]
            Permalink
            aarati.sabnis Aarati Sabnis (Inactive) logged work - 18/Apr/17 04:19 AM
            • Time Spent:
              1.75h
               

              Unit testing
              Stage Testing
              Internal discussion with Vinanti
              Code debugging
              Code changes
              Unit testing

            aarati.sabnis Aarati Sabnis (Inactive) made changes -
            Remaining Estimate 16.5h [ 59400 ] 14.75h [ 53100 ]
            Time Spent 7.5h [ 27000 ] 9.25h [ 33300 ]
            Worklog Id 38836 [ 38836 ]
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Remaining Estimate 14.75h [ 53100 ] 14.25h [ 51300 ]
            Time Spent 9.25h [ 33300 ] 9.75h [ 35100 ]
            Worklog Id 39048 [ 39048 ]
            Permalink
            aarati.sabnis Aarati Sabnis (Inactive) logged work - 18/Apr/17 05:33 PM
            • Time Spent:
              0.5h
               

              Internal discussion with Vinanti
              Script changes
              Unit testing

            aarati.sabnis Aarati Sabnis (Inactive) made changes -
            Remaining Estimate 14.25h [ 51300 ] 13.75h [ 49500 ]
            Time Spent 9.75h [ 35100 ] 10.25h [ 36900 ]
            Worklog Id 39121 [ 39121 ]
            Permalink
            sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 19/Apr/17 01:24 AM
            • Time Spent:
              0.5h
               

              code review is in progress

            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Remaining Estimate 13.75h [ 49500 ] 12.75h [ 45900 ]
            Time Spent 10.25h [ 36900 ] 11.25h [ 40500 ]
            Worklog Id 39682 [ 39682 ]
            Permalink
            sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 21/Apr/17 01:12 AM
            • Time Spent:
              1h
               

              corrected script
              executed on local,stage and production

            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
            aarati.sabnis Aarati Sabnis (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            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
            aarati.sabnis Aarati Sabnis (Inactive) made changes -
            Attachment WT-9127-AffectedFiles.txt [ 46110 ]
            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
            aarati.sabnis Aarati Sabnis (Inactive) made changes -
            Code Review Date 24/Apr/2017
            Code Reviewed By Sheetal Bodhale [ 11905 ]
            Developer Aarati Sabnis [ aarati.sabnis ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            aarati.sabnis Aarati Sabnis (Inactive) made changes -
            Assignee Aarati Sabnis [ aarati.sabnis ] Rakesh Roy [ rakeshr ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Rakesh Roy [ rakeshr ] Rashmita Dudhe [ rashmita.dudhe ]
            Permalink
            aarati.sabnis Aarati Sabnis (Inactive) logged work - 25/Apr/17 04:12 AM
            • Time Spent:
              0.5h
               

              Internal discussion with Akshay
              LB check-in

            aarati.sabnis Aarati Sabnis (Inactive) made changes -
            Remaining Estimate 12.75h [ 45900 ] 12.25h [ 44100 ]
            Time Spent 11.25h [ 40500 ] 11.75h [ 42300 ]
            Worklog Id 40498 [ 40498 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            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
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Remaining Estimate 12.25h [ 44100 ] 11.25h [ 40500 ]
            Time Spent 11.75h [ 42300 ] 12.75h [ 45900 ]
            Worklog Id 40558 [ 40558 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Worklog Id 40558 [ 40558 ]
            Permalink
            aarati.sabnis Aarati Sabnis (Inactive) logged work - 25/Apr/17 03:47 PM
            • Time Spent:
              0.25h
               

              UI-refresh check-in

            aarati.sabnis Aarati Sabnis (Inactive) made changes -
            Remaining Estimate 11.25h [ 40500 ] 11h [ 39600 ]
            Time Spent 12.75h [ 45900 ] 13h [ 46800 ]
            Worklog Id 40741 [ 40741 ]
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 26/Apr/17 06:49 AM - edited
            • Time Spent:
              1h
               
              <No comment>
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 26/Apr/17 09:53 AM
            • Time Spent:
              2h
               
              <No comment>
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Remaining Estimate 11h [ 39600 ] 9h [ 32400 ]
            Time Spent 13h [ 46800 ] 15h [ 54000 ]
            Worklog Id 42104 [ 42104 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Remaining Estimate 9h [ 32400 ] 7h [ 25200 ]
            Time Spent 15h [ 54000 ] 17h [ 61200 ]
            Worklog Id 42634 [ 42634 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 03/May/17 06:03 AM
            • Time Spent:
              2h
               
              <No comment>
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 03/May/17 11:40 AM
            • Time Spent:
              2h
               
              <No comment>
            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
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Remaining Estimate 7h [ 25200 ] 5h [ 18000 ]
            Time Spent 17h [ 61200 ] 19h [ 68400 ]
            Worklog Id 42864 [ 42864 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) logged work - 04/May/17 12:47 PM
            • Time Spent:
              2h
               
              <No comment>
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            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
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Remaining Estimate 5h [ 18000 ] 3h [ 10800 ]
            Time Spent 19h [ 68400 ] 21h [ 75600 ]
            Worklog Id 43177 [ 43177 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            rashmita.dudhe Rashmita Dudhe (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            Permalink
            aarati.sabnis Aarati Sabnis (Inactive) logged work - 04/May/17 05:05 PM
            • Time Spent:
              0.25h
               

              Production check-in

            aarati.sabnis Aarati Sabnis (Inactive) made changes -
            Remaining Estimate 3h [ 10800 ] 2.75h [ 9900 ]
            Time Spent 21h [ 75600 ] 21.25h [ 76500 ]
            Worklog Id 43237 [ 43237 ]
            rajendraj Rajendra Joshi (Inactive) made changes -
            Link This issue is cloned by WT-10843 [ WT-10843 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Bug Severity Medium [ 16702 ]
            satyap Satya made changes -
            Environment_New Stage [ 18443 ]
            Transition Time In Source Status Execution Times
            Vinanti Yadav (Inactive) made transition -
            Open In Development
            		2d 12h 33m 1
            Rakesh Roy (Inactive) made transition -
            In Development In LB Testing
            		14d 10h 18m 1
            Rashmita Dudhe (Inactive) made transition -
            In LB Testing Stage Testing
            		9d 12h 52m 1
            Rashmita Dudhe (Inactive) made transition -
            Stage Testing In Production Testing
            		8h 24m 1
            Rashmita Dudhe (Inactive) made transition -
            In Production Testing Production Complete
            		25s 1
            Rashmita Dudhe (Inactive) made transition -
            Production Complete Closed
            		7s 1

              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