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

            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) created issue -
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Field Original Value New Value
            Link This issue is cloned by WT-11615 [ WT-11615 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Link This issue is caused by OE-301 [ OE-301 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Assignee Ankur Deshpande [ ankur.deshpande ] Prasanna Karlekar [ prasanna ]
            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
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            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
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Gaurav Sodani [ gaurav.sodani ]
            Hide
            jyoti.mayne Jyoti Mayne added a comment -
            Show
            jyoti.mayne Jyoti Mayne added a comment - Cc: Amruta Lohiya
            jyoti.mayne Jyoti Mayne made changes -
            Assignee Gaurav Sodani [ gaurav.sodani ] Shailendra Honrao [ shailendra.honrao ]
            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
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Issue Type Bug [ 1 ] Support Activity [ 10301 ]
            Status In Development [ 10007 ] Resolved [ 5 ]
            Support Task Type Data Correction [ 11203 ]
            Workflow WT_Defects [ 55057 ] WT_Support [ 55078 ]
            shailendra.honrao Shailendra Honrao (Inactive) logged work - 16/Oct/17 09:14 AM
            • Time Spent:
              4h
               

              analysis,discussion with ankur and jyoti, data scanning, data correction

            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Assignee Shailendra Honrao [ shailendra.honrao ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            jyoti.mayne Jyoti Mayne logged work - 16/Oct/17 09:15 AM
            • Time Spent:
              2.5h
               

              analysis, discussion, data correction and verification

            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 4h [ 14400 ]
            Worklog Id 85226 [ 85226 ]
            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.
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) logged work - 16/Oct/17 12:07 PM
            • Time Spent:
              0.5h
               
              <No comment>
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Status Resolved [ 5 ] Reopened [ 4 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Shailendra Honrao [ shailendra.honrao ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Time Spent 4h [ 14400 ] 4.5h [ 16200 ]
            Worklog Id 85273 [ 85273 ]
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Status Reopened [ 4 ] In Progress [ 3 ]
            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
            shailendra.honrao Shailendra Honrao (Inactive) logged work - 16/Oct/17 01:37 PM
            • Time Spent:
              4h
               

              analysis,data scanning,data correction

            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Time Spent 4.5h [ 16200 ] 8.5h [ 30600 ]
            Worklog Id 85326 [ 85326 ]
            shailendra.honrao Shailendra Honrao (Inactive) made changes -
            Assignee Shailendra Honrao [ shailendra.honrao ] Vinanti Yadav [ vinanti.yadav ]
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Attachment StageRule_223.PNG [ 64719 ]
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Attachment ProdctionRule_223.PNG [ 64720 ]
            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
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Assignee Vinanti Yadav [ vinanti.yadav ] Ankur Deshpande [ ankur.deshpande ]
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Attachment ProdctionRule_223.PNG [ 64720 ]
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Attachment ProdctionRule_223.PNG [ 64721 ]
            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
            jyoti.mayne Jyoti Mayne logged work - 17/Oct/17 09:56 AM
            • Time Spent:
              4h
               

              discussion with Ankur about eligibility wrong issue
              rules updation on main company
              analysis and testing

            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
            vinanti.yadav Vinanti Yadav (Inactive) logged work - 17/Oct/17 12:16 PM
            • Time Spent:
              8h
               

              analysis.
              JIRA updates.

            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Time Spent 8.5h [ 30600 ] 16.5h [ 59400 ]
            Worklog Id 85417 [ 85417 ]
            ankur.deshpande Ankur Deshpande (Inactive) logged work - 17/Oct/17 02:41 PM
            • Time Spent:
              6h
               
              <No comment>
            jyoti.mayne Jyoti Mayne made changes -
            Assignee Ankur Deshpande [ ankur.deshpande ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            Resolution Done [ 10000 ]
            Status In Progress [ 3 ] Resolved [ 5 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Time Spent 16.5h [ 59400 ] 17h [ 61200 ]
            Worklog Id 85731 [ 85731 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Status Resolved [ 5 ] Closed [ 6 ]
            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.
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) logged work - 23/Oct/17 06:34 PM
            • Time Spent:
              0.5h
               
              <No comment>
            jyoti.mayne Jyoti Mayne made changes -
            Resolution Done [ 10000 ]
            Status Closed [ 6 ] Reopened [ 4 ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 17h [ 61200 ] 19.5h [ 70200 ]
            Worklog Id 86635 [ 86635 ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 19.5h [ 70200 ] 23.5h [ 84600 ]
            Worklog Id 86649 [ 86649 ]
            jyoti.mayne Jyoti Mayne made changes -
            Resolution Done [ 10000 ]
            Status Reopened [ 4 ] Closed [ 6 ]
            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
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Closed [ 6 ] Reopened [ 4 ]
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Time Spent 23.5h [ 84600 ] 29.5h [ 106200 ]
            Worklog Id 87975 [ 87975 ]
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Reopened [ 4 ] Closed [ 6 ]
            jyoti.mayne Jyoti Mayne logged work - 31/Oct/17 04:36 PM
            • Time Spent:
              0.25h
               

              discussion with Snehal

            jyoti.mayne Jyoti Mayne made changes -
            Resolution Fixed [ 1 ]
            Status Closed [ 6 ] Reopened [ 4 ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 29.5h [ 106200 ] 29.75h [ 107100 ]
            Worklog Id 88423 [ 88423 ]
            jyoti.mayne Jyoti Mayne made changes -
            Resolution Done [ 10000 ]
            Status Reopened [ 4 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Prasanna Karlekar (Inactive) made transition -
            Open In Development
            18h 46m 1
            Shailendra Honrao (Inactive) made transition -
            In Development Resolved
            1d 6h 11m 1
            Hrishikesh Deshpande (Inactive) made transition -
            Resolved Reopen
            2h 53m 1
            Shailendra Honrao (Inactive) made transition -
            Reopen In Progress
            28m 18s 1
            Jyoti Mayne made transition -
            In Progress Resolved
            1d 17h 2m 1
            Hrishikesh Deshpande (Inactive) made transition -
            Resolved Closed
            5d 57m 1
            Jyoti Mayne made transition -
            Closed Reopen
            8d 9h 14m 3
            Jyoti Mayne made transition -
            Reopen Closed
            47m 52s 3

              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