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

WT -> Server Errors on Plan Eligibility Screen

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      QA
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      Harbinger

      Description

      Tested on - ASML. JCCC, Austin, MHNGS
      Environment - WT Stage

      1. I tried switching few enrollment period ON for employees and seeing benefit plans for my further testing

      Actual Result : No Benefit Types are shown to enroll

      2. When I went on benefit plan's eligibility screens to check the eligibility

      Actual Result : Server Error (on adding new or updating existing eligibility for plans)

      Unable to test anything on LB

        Attachments

          Issue Links

            Activity

            alankar.chavan Alankar Chavan (Inactive) created issue -
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Field Original Value New Value
            Assignee Satya [ ID10004 ] Swaraj Patil [ vijayendra ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Link This issue blocks WT-460 [ WT-460 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Link This issue blocks WT-534 [ WT-534 ]
            Hide
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            Error Logs -

            ErrorID : 0
            ErrorSource : ControllerAppTier.GetCollection->BenAdminControllerAppTier.GetData->CollectionManager.GetCollection->
            CollectionManager.GetEligibileBenefitTypesForGivenEffectiveDate->Eligibility.GetEligibleBenefitTypes_EnrollNow
            ErrorMessage: Invalid column name 'GenericEligibilityRulesID'.

            ErrorID : 0
            ErrorSource : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->PlanDesignEligibilityRule.GetData->
            PlanDesignEligibilityRule.GetPlanDesignEligbilityRuleForGivenID
            ErrorMessage: Conversion from type 'DBNull' to type 'Integer' is not valid.

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - Error Logs - ErrorID : 0 ErrorSource : ControllerAppTier.GetCollection->BenAdminControllerAppTier.GetData->CollectionManager.GetCollection-> CollectionManager.GetEligibileBenefitTypesForGivenEffectiveDate->Eligibility.GetEligibleBenefitTypes_EnrollNow ErrorMessage: Invalid column name 'GenericEligibilityRulesID'. ErrorID : 0 ErrorSource : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->PlanDesignEligibilityRule.GetData-> PlanDesignEligibilityRule.GetPlanDesignEligbilityRuleForGivenID ErrorMessage: Conversion from type 'DBNull' to type 'Integer' is not valid.
            swaraj Swaraj Patil (Inactive) made changes -
            Assignee Swaraj Patil [ vijayendra ] Varsha Shejawal [ varsha.shejawal ]
            Hide
            swaraj Swaraj Patil (Inactive) added a comment -

            Hi Alankar,

            I have fixed this issue for time being on by updating GenericEligibilityRulesID on mentioned companies. Varsha will provide proper fix in next LB build. Can you please check if you are able test it now?

            Show
            swaraj Swaraj Patil (Inactive) added a comment - Hi Alankar, I have fixed this issue for time being on by updating GenericEligibilityRulesID on mentioned companies. Varsha will provide proper fix in next LB build. Can you please check if you are able test it now?
            Hide
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            yes Swaraj Patil - this is working well on the desired comapny

            Varsha Shejawal please assign this to me with according statuses - once the proper changes are deployed

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - yes Swaraj Patil - this is working well on the desired comapny Varsha Shejawal please assign this to me with according statuses - once the proper changes are deployed
            Hide
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            Error I am getting on 23rd March 2016

            ErrorID : 0
            ErrorSource : ControllerAppTier.Save->BenAdminControllerAppTier.Save->PlanDesignEligibilityRule.Save->PlanDesignEligibilityRule.AddPlanDesignEligbilityRule
            ErrorMessage: @GenericEligibilityRuleID is not a parameter for procedure OES_SP_Insert_PlanDesignEligibilityRule.

            This is still open

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - Error I am getting on 23rd March 2016 ErrorID : 0 ErrorSource : ControllerAppTier.Save->BenAdminControllerAppTier.Save->PlanDesignEligibilityRule.Save->PlanDesignEligibilityRule.AddPlanDesignEligbilityRule ErrorMessage: @GenericEligibilityRuleID is not a parameter for procedure OES_SP_Insert_PlanDesignEligibilityRule. This is still open
            varsha.shejawal Varsha Shejawal (Inactive) made changes -
            Assignee Varsha Shejawal [ varsha.shejawal ] Amit Gude [ amitg ]
            Hide
            varsha.shejawal Varsha Shejawal (Inactive) added a comment -

            If it is fixed on LB then please close this issue. As this was due to scripts were not executed on
            the company.

            Show
            varsha.shejawal Varsha Shejawal (Inactive) added a comment - If it is fixed on LB then please close this issue. As this was due to scripts were not executed on the company.
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Tested this issue on JCCC company on LB. Working fine as expected no server error being displayed after saving on plan eligibility tab. (This is on LB and company specific so tested on JCCC company only). As it is working as expected so closing the ticket.

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Tested this issue on JCCC company on LB. Working fine as expected no server error being displayed after saving on plan eligibility tab. (This is on LB and company specific so tested on JCCC company only). As it is working as expected so closing the ticket.
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            satyap Satya made changes -
            Environment_New LB [ 18444 ]
            Transition Time In Source Status Execution Times
            Venkatesh Pujari (Inactive) made transition -
            Open In Development
            6d 4h 39m 1
            Venkatesh Pujari (Inactive) made transition -
            In Development In LB Testing
            5s 1
            Venkatesh Pujari (Inactive) made transition -
            In LB Testing Stage Testing
            8m 27s 1
            Venkatesh Pujari (Inactive) made transition -
            Stage Testing In Production Testing
            1s 1
            Venkatesh Pujari (Inactive) made transition -
            In Production Testing Production Complete
            11s 1
            Venkatesh Pujari (Inactive) made transition -
            Production Complete Closed
            4s 1

              People

              Assignee:
              amitg Amit Gude (Inactive)
              Reporter:
              alankar.chavan Alankar Chavan (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: