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

            Descending order - Click to sort in ascending order
            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.
            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
            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
            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
            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
            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.
            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.
            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

              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