New Features 2017Project Type: software

New Features 2017

Uploaded image for project: 'New Features 2017'
  1. New Features 2017
  2. NF-5119

CLONE - Server error on Employee plan eligibility report

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: Medium
    • Resolution: Bug Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: UI Refresh
    • Labels:
    • Environment:
      Stage
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Admin
    • Module:
      BenAdmin - Report
    • Reported by:
      Support
    • Company:
      Softchoice
    • Item State:
      Stage QA - Production Deployment on Hold

      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

          clones

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

          • Medium - Has the potential to affect progress.
          • Closed
          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
            Link This issue clones WT-11184 [ WT-11184 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Link This issue is duplicated by WT-12227 [ WT-12227 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Component/s UI Refresh [ 10902 ]
            Component/s BenAdmin [ 10000 ]
            Environment_Old Stage [ 10004 ]
            Key WT-12275 NF-5119
            Project WORKTERRA [ 10000 ] New Features 2017 [ 11000 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Rakesh Roy [ rakeshr ] Nidhi Kaul [ nidhi.kaul ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: Development(10200)
            nidhi.kaul Nidhi Kaul (Inactive) made changes -
            Assignee Nidhi Kaul [ nidhi.kaul ] Harshada Borole [ harshada.borole ]
            Hide
            Permalink
            nidhi.kaul Nidhi Kaul (Inactive) added a comment -

            Harshada Borole,
            This JIRA has been created against WT-11184. Please check in the code in UI refresh branch.

            Vijayendra Shinde

            Show
            nidhi.kaul Nidhi Kaul (Inactive) added a comment - Harshada Borole , This JIRA has been created against WT-11184 . Please check in the code in UI refresh branch. Vijayendra Shinde
            harshada.borole Harshada Borole (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Item State Parent values: Development(10200) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            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 -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            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 -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: LB QA(10201)Level 1 values: Re-open(10212)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Attachment CHMC_CODEMAP.png [ 68767 ]
            Hide
            Permalink
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            As SoftChoice is not available on CODEMPA,
            Hence verified on CHMC Company from CODEMPA, Still getting server error, refer attached image.

            No error log generated on CODEMAP for this issue.

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - As SoftChoice is not available on CODEMPA, Hence verified on CHMC Company from CODEMPA, Still getting server error, refer attached image. No error log generated on CODEMAP for this issue.
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Harshada Borole [ harshada.borole ]
            Hide
            Permalink
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi Ashwin Wankhede,

            We need following path shared:
            \\10.0.0.27\WORKterra\Reports\

            Please do the needful and let us know.

            Thank you!

            cc: Harshada Borole, Jyoti Agrawal

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi Ashwin Wankhede , We need following path shared: \\10.0.0.27\WORKterra\Reports\ Please do the needful and let us know. Thank you! cc: Harshada Borole , Jyoti Agrawal
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Harshada Borole [ harshada.borole ] Ashwin Wankhede [ ashwin.wankhede ]
            Hide
            Permalink
            khandu.kshirsagar Khandu Kshirsagar (Inactive) added a comment -

            Hi Prasanna Karlekar,

            Please check now. Do let me know if any issue.

            Ashwin Wankhede,Rakesh Roy

            Show
            khandu.kshirsagar Khandu Kshirsagar (Inactive) added a comment - Hi Prasanna Karlekar , Please check now. Do let me know if any issue. Ashwin Wankhede , Rakesh Roy
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Assignee Ashwin Wankhede [ ashwin.wankhede ] Prasanna Karlekar [ prasanna ]
            Hide
            Permalink
            prasanna Prasanna Karlekar (Inactive) added a comment - - edited

            Harshada Borole -
            Please check now. Report should execute without any error. Do check Add/Change/Term report too.
            Update the JIRA accordingly.

            Thank you!

            cc: Jyoti Agrawal

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - - edited Harshada Borole - Please check now. Report should execute without any error. Do check Add/Change/Term report too. Update the JIRA accordingly. Thank you! cc: Jyoti Agrawal
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Harshada Borole [ harshada.borole ]
            Permalink
            harshada.borole Harshada Borole (Inactive) logged work - 29/Nov/17 05:49 PM
            • Time Spent:
              2h
               

              Issue analysis and discussion.

            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 29/Nov/17 11:00 PM - edited
            • Time Spent:
              0.5h
               

              Issue analysis and resolution
              Discussion

            harshada.borole Harshada Borole (Inactive) made changes -
            Remaining Estimate 21h [ 75600 ] 19h [ 68400 ]
            Time Spent 2h [ 7200 ]
            Worklog Id 93864 [ 93864 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            harshada.borole Harshada Borole (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: Development(10200)Level 1 values: In Progress(10206)
            Hide
            Permalink
            harshada.borole Harshada Borole (Inactive) added a comment -

            Hi Sachin Hingole,

            We have checked Employee Plan Eligibility Report and Add/Change/Term Report in Codemap environment. Both reports are working fine now.
            Please verify at your end.

            cc:Prasanna Karlekar,Jyoti Agrawal,Rakesh Roy

            Show
            harshada.borole Harshada Borole (Inactive) added a comment - Hi Sachin Hingole , We have checked Employee Plan Eligibility Report and Add/Change/Term Report in Codemap environment. Both reports are working fine now. Please verify at your end. cc: Prasanna Karlekar , Jyoti Agrawal , Rakesh Roy
            harshada.borole Harshada Borole (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            harshada.borole Harshada Borole (Inactive) made changes -
            Assignee Harshada Borole [ harshada.borole ] Sachin Hingole [ sachin.hingole ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 19h [ 68400 ] 18.5h [ 66600 ]
            Time Spent 2h [ 7200 ] 2.5h [ 9000 ]
            Worklog Id 93977 [ 93977 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Worklog Id 93977 [ 93977 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 18.5h [ 66600 ] 18h [ 64800 ]
            Time Spent 2.5h [ 9000 ] 3h [ 10800 ]
            Worklog Id 99111 [ 99111 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 18h [ 64800 ] 18.5h [ 66600 ]
            Time Spent 3h [ 10800 ] 2.5h [ 9000 ]
            Worklog Id 99111 [ 99111 ]
            Worklog Time Spent 0.5h [ 1800 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Labels Static_Reports Sprint_40
            Hide
            Permalink
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Verified on pre-prod on County of San Luis Obispo For HSPL, working fine.

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Verified on pre-prod on County of San Luis Obispo For HSPL, working fine.
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Resolution Bug Fixed [ 10402 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            Transition Time In Source Status Execution Times
            Harshada Borole (Inactive) made transition -
            Open In Development
            		5d 32m 1
            Sachin Hingole (Inactive) made transition -
            In LB Testing Reopen in Local
            		3h 31m 1
            Harshada Borole (Inactive) made transition -
            Reopen in Local In Development
            		21h 1
            Sachin Hingole (Inactive) made transition -
            In Development In LB Testing
            		2d 19h 45m 2
            Sachin Hingole (Inactive) made transition -
            In LB Testing Stage Testing
            		54d 5h 21m 1
            Sachin Hingole (Inactive) made transition -
            Stage Testing In Production Testing
            		57d 19h 17m 1
            Sachin Hingole (Inactive) made transition -
            In Production Testing Production Complete
            		3m 45s 1

              People

              Assignee:
              sachin.hingole Sachin Hingole (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 - 2.5h Remaining Estimate - 18.5h
                  18.5h
                  Logged:
                  Time Spent - 2.5h Remaining Estimate - 18.5h
                  2.5h