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

            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.
            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
            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.
            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.

              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: