Workterra BenAdminProject Type: business

Workterra BenAdmin

Uploaded image for project: 'Workterra BenAdmin'
  1. Workterra BenAdmin
  2. WB-281

Server error on Employee plan eligibility report

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Bug Fixed
    • Labels:
    • Environment:
      Stage
    • Categories:
      Report
    • Company:
      Softchoice
    • Reported by:
      Support
    • Level:
      Admin

      Description

      ErrorID : 0
      ErrorSource : ControllerAppTier.SaveAndGetData->BenAdminControllerAppTier.SaveAndGetData->StaticReports.SaveAndGetData->AdminUser.GetData->EligibilityReason.FetchEmployeePlanEligibility->EligibilityReason.FetchEligibleEmployeeForReport
      ErrorMessage: Invalid object name 'AdminUserClass1'.
      StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.SaveAndGetData(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity)

        Attachments

          Issue Links

          is cloned by

          Bug - A problem which impairs or prevents the functions of the product. NF-5119 CLONE - Server error on Employee plan eligibility report

          • Medium - Has the potential to affect progress.
          • Production Complete
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. WT-12227 Report -> Employee Plan Eligibility report -> System throws server error

          • High - Serious problem that could block progress.
          • Closed

            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
            Issue Category Harbinger [ 10700 ] EBS [ 10350 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Rakesh Roy [ rakeshr ] Prasanna Karlekar [ prasanna ]
            satyap Satya made changes -
            Environment Stage [ 10004 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Jyoti Agrawal [ jyoti.agrawal ]
            Hide
            Permalink
            prasanna Prasanna Karlekar (Inactive) added a comment -

            We will be taking this in Sprint-41 starting from 6-Nov-2017.

            Thank you!

            cc: Gaurav Sodani

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - We will be taking this in Sprint-41 starting from 6-Nov-2017. Thank you! cc: Gaurav Sodani
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 40 - Bugs [ 94 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Assignee Jyoti Agrawal [ jyoti.agrawal ] Harshada Borole [ harshada.borole ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Dev Due Date 02/Nov/2017
            Dev Estimates 21
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Remaining Estimate 21h [ 75600 ]
            Original Estimate 21h [ 75600 ]
            Hide
            Permalink
            prasanna Prasanna Karlekar (Inactive) added a comment -

            We will be working on this issue in Sprint-40, starting from 23-Oct-2017.

            Thank you!

            cc: Gaurav Sodani

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - We will be working on this issue in Sprint-40, starting from 23-Oct-2017. Thank you! cc: Gaurav Sodani
            prasanna Prasanna Karlekar (Inactive) made changes -
            Code Reviewed By Jyoti Agarwal [ 16704 ]
            Company Softchoice [ 10528 ]
            Developer Harshada Borole [ harshada.borole ]
            Permalink
            harshada.borole Harshada Borole (Inactive) logged work - 01/Nov/17 07:24 AM
            • Time Spent:
              4h
               

              Analysis,code change,discussion,sent code for review.

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Labels Static_Reports
            harshada.borole Harshada Borole (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Environment_New Stage [ 18443 ]
            Item State Parent values: Development(10200)
            Permalink
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 01/Nov/17 01:35 PM
            • Time Spent:
              2h
               

              Analysis, Discussion

            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Remaining Estimate 21h [ 75600 ] 19h [ 68400 ]
            Time Spent 2h [ 7200 ]
            Worklog Id 88629 [ 88629 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 01/Nov/17 10:00 PM
            • Time Spent:
              0.75h
               

              Pair Programming -
              Issue analysis
              Discussion on fix to be done

            harshada.borole Harshada Borole (Inactive) made changes -
            Assignee Harshada Borole [ harshada.borole ] Jyoti Agrawal [ jyoti.agrawal ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Item State Parent values: Development(10200) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 19h [ 68400 ] 18.25h [ 65700 ]
            Time Spent 2h [ 7200 ] 2.75h [ 9900 ]
            Worklog Id 88696 [ 88696 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Remaining Estimate 18.25h [ 65700 ] 14.25h [ 51300 ]
            Time Spent 2.75h [ 9900 ] 6.75h [ 24300 ]
            Worklog Id 88730 [ 88730 ]
            Permalink
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 02/Nov/17 09:02 AM
            • Time Spent:
              1.5h
               

              Code impact analysis,Code & functionality review

            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Assignee Jyoti Agrawal [ jyoti.agrawal ] Harshada Borole [ harshada.borole ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Remaining Estimate 14.25h [ 51300 ] 12.75h [ 45900 ]
            Time Spent 6.75h [ 24300 ] 8.25h [ 29700 ]
            Worklog Id 88952 [ 88952 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            Hide
            Permalink
            harshada.borole Harshada Borole (Inactive) added a comment -

            Below are the 3C's:

            Concern:- Server error on Employee plan eligibility report
            Cause:- Incorrect database connection string was formed.
            Connection string was pointing to OnlineEnrollment database instead of Company database.
            Database query for Company Admin included 'AdminUserClass' tables. These tables are present in Company DB. The query was getting executed in OnlineEnrollment and could not find 'AdminUserClass' tables.
            Correction:- Corrected the connection string, pointing to Company Database

            Files affected:-
            EligibilityReason.vb

            Affected Area:-
            Employee Plan Eligibility Report.

            Tested Scenario's:- Tested for Admin login and Company Admin.

            Show
            harshada.borole Harshada Borole (Inactive) added a comment - Below are the 3C's: Concern:- Server error on Employee plan eligibility report Cause:- Incorrect database connection string was formed. Connection string was pointing to OnlineEnrollment database instead of Company database. Database query for Company Admin included 'AdminUserClass' tables. These tables are present in Company DB. The query was getting executed in OnlineEnrollment and could not find 'AdminUserClass' tables. Correction:- Corrected the connection string, pointing to Company Database Files affected:- EligibilityReason.vb Affected Area:- Employee Plan Eligibility Report. Tested Scenario's:- Tested for Admin login and Company Admin.
            harshada.borole Harshada Borole (Inactive) made changes -
            Assignee Harshada Borole [ harshada.borole ] Sachin Hingole [ sachin.hingole ]
            sachin.hingole Sachin Hingole (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)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Meghana Joshi [ meghana.kulkarni ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Stage Due Date 20/Nov/17 [ 2017-11-20 ]
            Hide
            Permalink
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Verified above issue on LB through Admin and Partner Login with combination of Some Classes , Some Benefit Type and Plan and All Classes , All Benefit Types.

            Working Fine

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Verified above issue on LB through Admin and Partner Login with combination of Some Classes , Some Benefit Type and Plan and All Classes , All Benefit Types. Working Fine CC - Sachin Hingole
            meghana.joshi Meghana Joshi (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
            meghana.joshi Meghana Joshi (Inactive) logged work - 14/Nov/17 12:28 PM
            • Time Spent:
              2h
               

              Testing on LB

            meghana.joshi Meghana Joshi (Inactive) made changes -
            Remaining Estimate 12.75h [ 45900 ] 10.75h [ 38700 ]
            Time Spent 8.25h [ 29700 ] 10.25h [ 36900 ]
            Worklog Id 90752 [ 90752 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
            harshada.borole Harshada Borole (Inactive) made changes -
            Link This issue relates to WT-12227 [ WT-12227 ]
            Hide
            Permalink
            nidhi.kaul Nidhi Kaul (Inactive) added a comment -

            Harshada Borole
            IS this fixed in new UI as well?

            Show
            nidhi.kaul Nidhi Kaul (Inactive) added a comment - Harshada Borole IS this fixed in new UI as well?
            Hide
            Permalink
            harshada.borole Harshada Borole (Inactive) added a comment -

            Hi Nidhi Kaul,

            We haven't deployed the changes in new UI as it is on LB Hold.
            We will deploy it once it is ready for stage.

            cc: Jyoti Agrawal,Prasanna Karlekar

            Show
            harshada.borole Harshada Borole (Inactive) added a comment - Hi Nidhi Kaul , We haven't deployed the changes in new UI as it is on LB Hold. We will deploy it once it is ready for stage. cc: Jyoti Agrawal , Prasanna Karlekar
            nidhi.kaul Nidhi Kaul (Inactive) made changes -
            Assignee Meghana Joshi [ meghana.kulkarni ] Rakesh Roy [ rakeshr ]
            Hide
            Permalink
            nidhi.kaul Nidhi Kaul (Inactive) added a comment -

            Rakesh Roy
            I guess this issue was raised by UAT group while testing UI refresh. Shouldn't it be created in NF?

            Nidhi.

            Show
            nidhi.kaul Nidhi Kaul (Inactive) added a comment - Rakesh Roy I guess this issue was raised by UAT group while testing UI refresh. Shouldn't it be created in NF? Nidhi.
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Link This issue relates to WT-12227 [ WT-12227 ]
            jyoti.agrawal Jyoti Agrawal (Inactive) made changes -
            Link This issue is duplicated by WT-12227 [ WT-12227 ]
            Hide
            Permalink
            rakeshr Rakesh Roy (Inactive) added a comment - - edited

            Nidhi Kaul This issue was on stage as well, that's why created WT ticket.

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - - edited Nidhi Kaul This issue was on stage as well, that's why created WT ticket.
            rakeshr Rakesh Roy (Inactive) made changes -
            Link This issue is cloned by WT-12275 [ WT-12275 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Rakesh Roy [ rakeshr ] Priya Dhamande [ priya.dhamande ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Priya Dhamande [ priya.dhamande ] Rashmita Dudhe [ rashmita.dudhe ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Rashmita Dudhe [ rashmita.dudhe ] Sanjana Jadhav [ sanjana.jadhav ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Sanjana Jadhav [ sanjana.jadhav ] Rashmita Dudhe [ rashmita.dudhe ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Categories Parent values: Report(18507)
            Component/s BenAdmin [ 10000 ]
            Environment_Old Stage [ 10004 ]
            Key WT-11184 WB-281
            Project WORKTERRA [ 10000 ] Workterra BenAdmin [ 11501 ]
            Workflow WT_Defects [ 52829 ] WB: Bugs Project Management Workflow [ 65075 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Workflow WB: Bugs Project Management Workflow [ 65075 ] 0803 Copy of WB: Bugs Project Management Workflow [ 65870 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pre-prod Testing [ 11500 ]
            Workflow 0803 Copy of WB: Bugs Project Management Workflow [ 65870 ] 2203 WB: Bugs Project Management Workflow [ 67003 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Workflow 2203 WB: Bugs Project Management Workflow [ 67003 ] 0604 Issues Management Workflow [ 68302 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Status IN Pre-prod Testing [ 11500 ] Ready for Production [ 10024 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Status Ready for Production [ 10024 ] Production Deployed [ 10025 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Status Production Deployed [ 10025 ] In Production Testing [ 10202 ]
            Hide
            Permalink
            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) made changes -
            Resolution Bug Fixed [ 10402 ]
            Status In Production Testing [ 10202 ] In Production Review [ 11501 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Status In Production Review [ 11501 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Harshada Borole (Inactive) made transition -
            Open In Development
            		42d 6h 46m 1
            Sachin Hingole (Inactive) made transition -
            In Development In LB Testing
            		11d 18h 36m 1
            Sachin Hingole (Inactive) made transition -
            In LB Testing Stage Testing
            		37d 8h 35m 1
            Prashant Samal (Inactive) made transition -
            Stage Testing IN Pre-prod Testing
            		91d 15h 40m 1
            Hrishikesh Deshpande (Inactive) made transition -
            IN Pre-prod Testing Ready for Production
            		54d 21h 13m 1
            Hrishikesh Deshpande (Inactive) made transition -
            Ready for Production Production Deployed
            		46s 1
            Hrishikesh Deshpande (Inactive) made transition -
            Production Deployed In Production Testing
            		3s 1
            Hrishikesh Deshpande (Inactive) made transition -
            In Production Testing In Production Review
            		34s 1
            Hrishikesh Deshpande (Inactive) made transition -
            In Production Review Closed
            		4s 1

              People

              Assignee:
              rashmita.dudhe Rashmita Dudhe (Inactive)
              Reporter:
              rakeshr Rakesh Roy (Inactive)
              Developer:
              Harshada Borole (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Pre-Prod Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 21h
                  21h
                  Remaining:
                  Time Spent - 10.25h Remaining Estimate - 10.75h
                  10.75h
                  Logged:
                  Time Spent - 10.25h Remaining Estimate - 10.75h
                  10.25h