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

PrimeHealthCare for HSPL - Report - Server error on Employee level report

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Support Task Type:
      Data Correction
    • Reported by:
      Harbinger
    • Company:
      PrimeHealthcare
    • Module:
      BenAdmin - Report
    • Severity:
      Simple

      Description

      Company - PrimeHealthCare for HSPL
      Environment - Production
      Report name - Eligibility Report and Enrollment Report

      Getting server error on Employee Login and on Partner Login-> EE level.

      CC : Ankur Deshpande Prasanna Karlekar

        Attachments

          Issue Links

            Activity

            Hide
            ankur.deshpande Ankur Deshpande (Inactive) added a comment -

            Hi Prasanna Karlekar,

            The following is the errror log.

            Report error log -

            ErrorID : 0

            ErrorSource : ControllerAppTier.Save->BenAdminControllerAppTier.Save->AdminUser.Save->EligibilityReason.FetchCheckEligibilityForPlanDesign->EligibilityReason.GetPlanDesignStatusHash

            ErrorMessage: Item has already been added. Key in dictionary: '9' Key being added: '9'

            StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.Save(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity)

            at WORKTERRA.ControllerAppTier.Save(Int32 intProjectsId, String strInput)

            TargetSite: System.String Save(ValueObjects.BenAdminControllerWebTierEntity)

            Regards,
            Ankur

            Show
            ankur.deshpande Ankur Deshpande (Inactive) added a comment - Hi Prasanna Karlekar , The following is the errror log. Report error log - ErrorID : 0 ErrorSource : ControllerAppTier.Save->BenAdminControllerAppTier.Save->AdminUser.Save->EligibilityReason.FetchCheckEligibilityForPlanDesign->EligibilityReason.GetPlanDesignStatusHash ErrorMessage: Item has already been added. Key in dictionary: '9' Key being added: '9' StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.Save(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity) at WORKTERRA.ControllerAppTier.Save(Int32 intProjectsId, String strInput) TargetSite: System.String Save(ValueObjects.BenAdminControllerWebTierEntity) Regards, Ankur
            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Following are the 3Cs:
            Concern:
            Error on Eligibility Report at employee level.

            Cause:
            Employee Status ID 9 is stored 2 times against Generic Eligibility Rule ID 188 which is causing an error.
            Against a rule repetition of same employee status, class or additional criteria is not expected.

            Correction:
            We need to remove duplicate data for employee status, class, and additional criteria against a rule.

            Gaurav Sodani -
            Correction needs to be done by Generic Eligibility team. Kindly assign it to appropriate team.

            Hrishikesh Deshpande -
            Please attach error log for Enrollment report. Tried checking enrollment issue on Production PrimeHealthcare for HSPL today but report ran successfully.

            Thank you!

            cc: Satya, Ankur Deshpande

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Following are the 3Cs: Concern: Error on Eligibility Report at employee level. Cause: Employee Status ID 9 is stored 2 times against Generic Eligibility Rule ID 188 which is causing an error. Against a rule repetition of same employee status, class or additional criteria is not expected. Correction: We need to remove duplicate data for employee status, class, and additional criteria against a rule. Gaurav Sodani - Correction needs to be done by Generic Eligibility team. Kindly assign it to appropriate team. Hrishikesh Deshpande - Please attach error log for Enrollment report. Tried checking enrollment issue on Production PrimeHealthcare for HSPL today but report ran successfully. Thank you! cc: Satya , Ankur Deshpande
            Hide
            jyoti.mayne Jyoti Mayne added a comment -
            Show
            jyoti.mayne Jyoti Mayne added a comment - Cc: Amruta Lohiya
            Hide
            shailendra.honrao Shailendra Honrao (Inactive) added a comment -

            Hi Hrishikesh Deshpande,

            We have scanned all data and we found that there are duplicate entries for Employee Status ID 9 &10
            against Generic Eligibility Rules Rule_188,Rule_189,Rule_190,Rule_191,Rule_192,Rule_193.

            We have done data correction for above impacted generic eligibility rules.

            Please verify.

            Thanks,
            Shailendra Honrao

            Cc:Jyoti Mayne,Amruta Lohiya,Ankur Deshpande

            Show
            shailendra.honrao Shailendra Honrao (Inactive) added a comment - Hi Hrishikesh Deshpande , We have scanned all data and we found that there are duplicate entries for Employee Status ID 9 &10 against Generic Eligibility Rules Rule_188,Rule_189,Rule_190,Rule_191,Rule_192,Rule_193 . We have done data correction for above impacted generic eligibility rules. Please verify. Thanks, Shailendra Honrao Cc: Jyoti Mayne , Amruta Lohiya , Ankur Deshpande
            Hide
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            Hi Shailendra Honrao,

            Getting server error on PrimeHealthCare for HSPL company on Eligibility report.

            error log - ErrorID : 0
            ErrorSource : ControllerAppTier.Save->BenAdminControllerAppTier.Save->AdminUser.Save->EligibilityReason.FetchCheckEligibilityForPlanDesign->EligibilityReason.GetDemographicClass1PlandesignHash
            ErrorMessage: Item has already been added. Key in dictionary: '46' Key being added: '46'
            StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.Save(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity)
            at WORKTERRA.ControllerAppTier.Save(Int32 intProjectsId, String strInput)
            TargetSite: System.String Save(ValueObjects.BenAdminControllerWebTierEntity)

            Thanks,
            Hrishikesh.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - Hi Shailendra Honrao , Getting server error on PrimeHealthCare for HSPL company on Eligibility report. error log - ErrorID : 0 ErrorSource : ControllerAppTier.Save->BenAdminControllerAppTier.Save->AdminUser.Save->EligibilityReason.FetchCheckEligibilityForPlanDesign->EligibilityReason.GetDemographicClass1PlandesignHash ErrorMessage: Item has already been added. Key in dictionary: '46' Key being added: '46' StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.Save(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity) at WORKTERRA.ControllerAppTier.Save(Int32 intProjectsId, String strInput) TargetSite: System.String Save(ValueObjects.BenAdminControllerWebTierEntity) Thanks, Hrishikesh.
            Hide
            shailendra.honrao Shailendra Honrao (Inactive) added a comment -

            Hi Hrishikesh Deshpande,

            We scanned the data, class1 and class2 ID were duplicated.
            We have correct the data.
            Also we have observe Eligibility Report and Enrollment Report of EE India Wilson & there is no server error occurred.

            Please verify.

            Thanks,
            Shailendra Honrao

            Cc:Jyoti Mayne,Amruta Lohiya,Ankur Deshpande

            Show
            shailendra.honrao Shailendra Honrao (Inactive) added a comment - Hi Hrishikesh Deshpande , We scanned the data, class1 and class2 ID were duplicated. We have correct the data. Also we have observe Eligibility Report and Enrollment Report of EE India Wilson & there is no server error occurred. Please verify. Thanks, Shailendra Honrao Cc: Jyoti Mayne , Amruta Lohiya , Ankur Deshpande
            Hide
            vinanti.yadav Vinanti Yadav (Inactive) added a comment -

            Hi Ankur Deshpande,

            While doing data correction for Generic Eligibility Rules we found below rules which are not move properly from stage to Production.

            ID Rule Name
            219 Rule_219
            220 Rule_220
            223 Rule_223
            224 Rule_224
            225 Rule_225
            226 Rule_226
            227 Rule_227
            228 Rule_228
            336 Rule_336
            416 Rule_416
            420 Rule_420
            421 Rule_421

            If any Module uses this rule we can face server error issues.
            e.g for Rule_223

            Stage Rule :

            Production Rule:

            All mentioned Rule has same problem

            Stage Production
            Employee.Active/COBRA- equal to yes Indicate whether child is a student eqaual to yes

            Please Correct above rule. Let me know if you need any help from our side.

            Thanks,
            Vinanti

            CC : Jyoti Mayne, Amruta Lohiya, Jaideep Vinchurkar, Satya

            Show
            vinanti.yadav Vinanti Yadav (Inactive) added a comment - Hi Ankur Deshpande , While doing data correction for Generic Eligibility Rules we found below rules which are not move properly from stage to Production. ID Rule Name 219 Rule_219 220 Rule_220 223 Rule_223 224 Rule_224 225 Rule_225 226 Rule_226 227 Rule_227 228 Rule_228 336 Rule_336 416 Rule_416 420 Rule_420 421 Rule_421 If any Module uses this rule we can face server error issues. e.g for Rule_223 Stage Rule : Production Rule: All mentioned Rule has same problem Stage Production Employee.Active/COBRA- equal to yes Indicate whether child is a student eqaual to yes Please Correct above rule. Let me know if you need any help from our side. Thanks, Vinanti CC : Jyoti Mayne , Amruta Lohiya , Jaideep Vinchurkar , Satya
            Hide
            ankur.deshpande Ankur Deshpande (Inactive) added a comment -

            Hi Vinanti Yadav,

            I have corrected all the above rules.

            Regards,
            Ankur

            Show
            ankur.deshpande Ankur Deshpande (Inactive) added a comment - Hi Vinanti Yadav , I have corrected all the above rules. Regards, Ankur
            Hide
            jyoti.mayne Jyoti Mayne added a comment -

            Hi Ankur Deshpande,

            One more rule is there Rule_222. Please correct.

            Show
            jyoti.mayne Jyoti Mayne added a comment - Hi Ankur Deshpande , One more rule is there Rule_222. Please correct.
            Hide
            ankur.deshpande Ankur Deshpande (Inactive) added a comment -

            Hi Jyoti Mayne,

            Rule_222 has been changed.

            Regards,
            Ankur

            Show
            ankur.deshpande Ankur Deshpande (Inactive) added a comment - Hi Jyoti Mayne , Rule_222 has been changed. Regards, Ankur
            Hide
            jyoti.mayne Jyoti Mayne added a comment -

            Hi Ankur Deshpande,

            I have verified all the generic rules are getting executed properly. No error is coming from backend while executing query.

            Cc: Amruta Lohiya, Prasanna Karlekar

            Show
            jyoti.mayne Jyoti Mayne added a comment - Hi Ankur Deshpande , I have verified all the generic rules are getting executed properly. No error is coming from backend while executing query. Cc: Amruta Lohiya , Prasanna Karlekar
            Hide
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            This is Fixed on Production.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - This is Fixed on Production.
            Hide
            ankur.deshpande Ankur Deshpande (Inactive) added a comment -

            reopen for work log

            Show
            ankur.deshpande Ankur Deshpande (Inactive) added a comment - reopen for work log

              People

              Assignee:
              hrishikesh.deshpande Hrishikesh Deshpande (Inactive)
              Reporter:
              hrishikesh.deshpande Hrishikesh Deshpande (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 29.75h
                  29.75h