WORKTERRAProject Type: software

WORKTERRA

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

Global Report - Standard Report - Server error on Report

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      QA
    • Bug Type:
      Functional
    • Bug Severity:
      Critical
    • Level:
      Partner
    • Module:
      BenAdmin - Report
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Browser:
      Google Chrome
    • Sprint:
      WT Sprint 32-Bugs

      Description

      Replication Steps :

      1) SA Login
      2) Navigate to Global level Standard Report
      3) Add new Report
      4) Create New Report
      5) Ran Report then it throws server error

      Issue : Same issue exist on EXCEL , PDF, HTML and Download files button.

      Error Log :
      ErrorID : 0
      ErrorSource : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->ReportDetails.GetData->ReportDetails.GetDataForCaseAndComponent
      ErrorMessage: Invalid column name 'TransactionTypeID'.
      Invalid column name 'GroupBenefitsYesNoID'.
      Invalid column name 'LoginStatusOfUsersID'.
      Invalid column name 'ShowTerminatedRecordsID'.
      Invalid column name 'GroupBenefits'.
      Invalid column name 'EmployeeName'.
      Invalid column name 'IsApplyDemoGraphicsHistory'.

      CC - Sachin Hingole Prasanna Karlekar

        Attachments

          Issue Links

          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. WT-129 Ability to run an enrollment report across all companies

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

            Activity

            Descending order - Click to sort in ascending order
            Hide
            Permalink
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Verified on Production.

            Working Fine

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Verified on Production. Working Fine
            Hide
            Permalink
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            As discussed with Prasanna Karlekar and [~parmeshwar.jumbade] , All Enhancement WT-129, WT-9377 and WT-9223 move at same time on Production. So, We will move all enhancement on 09/19/2017

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - As discussed with Prasanna Karlekar and [~parmeshwar.jumbade] , All Enhancement WT-129 , WT-9377 and WT-9223 move at same time on Production. So, We will move all enhancement on 09/19/2017 CC - Sachin Hingole
            Hide
            Permalink
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Verified on Stage.
            Working Fine.

            Will update testing status one's main enhancement WT-129 Stage Testing is completed on Stage

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Verified on Stage. Working Fine. Will update testing status one's main enhancement WT-129 Stage Testing is completed on Stage CC - Sachin Hingole
            Hide
            Permalink
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Ready for Stage

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Ready for Stage CC - Sachin Hingole
            Hide
            Permalink
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Verified on LB.
            Working Fine.

            Will update testing status one's main enhancement WT-129 is completed on LB

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Verified on LB. Working Fine. Will update testing status one's main enhancement WT-129 is completed on LB CC - Sachin Hingole
            Hide
            Permalink
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Testing is not started yet on LB due to other highest priority issue WT-3377 and WT-10102

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Testing is not started yet on LB due to other highest priority issue WT-3377 and WT-10102 CC - Sachin Hingole
            Hide
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            While working on this issue found that all bubble values were read hard-coded so made some changes to read it from based on configuration.

            Affected Areas: Global level standard reports

            Affected Files:
            \Database Objects\OnlineEnrollment\01_DDL\138_WT-10074_WTB_Report_ModTable_ReportDetails.sql
            \Database Objects\OnlineEnrollment\04_Stored Procedures\dbo.OES_SP_Report_GetGlobalLevelSavedReport.StoredProcedure.sql

            Tested scenarios:
            1. Verified existing reports Edit and Run functionality.
            2. Check bubbles are showing on screen based on the configurations.

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - While working on this issue found that all bubble values were read hard-coded so made some changes to read it from based on configuration. Affected Areas : Global level standard reports Affected Files : \Database Objects\OnlineEnrollment\01_DDL\138_ WT-10074 _WTB_Report_ModTable_ReportDetails.sql \Database Objects\OnlineEnrollment\04_Stored Procedures\dbo.OES_SP_Report_GetGlobalLevelSavedReport.StoredProcedure.sql Tested scenarios : 1. Verified existing reports Edit and Run functionality. 2. Check bubbles are showing on screen based on the configurations.
            Hide
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            On LB one column not available so it will not work.

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - On LB one column not available so it will not work.
            Hide
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - - edited

            3C's:
            Concern: Global Report - Standard Report - Server error on Report
            Cause: One file remains while merging code
            Correction: Missing code file merged.

            Description: This issue came due to while merging changes file were not properly merged.

            Affected Areas: Global Reports and Reports

            *Affected Files: *
            StandardReportsModel.cs

            *Tested Scenarios: *
            1. Verified preview report
            2. Checked PDF, HTML, EXCEL action for global level report
            3. Checked Run functionality.

            Note: i have checked download functionality, Exception not appear on screen but getting in console related to JS. But Download file button not available to company level reports so need to check what actually happens on it.

            CC: Prasanna Karlekar

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - - edited 3C's: Concern: Global Report - Standard Report - Server error on Report Cause: One file remains while merging code Correction: Missing code file merged. Description: This issue came due to while merging changes file were not properly merged. Affected Areas: Global Reports and Reports *Affected Files: * StandardReportsModel.cs *Tested Scenarios: * 1. Verified preview report 2. Checked PDF, HTML, EXCEL action for global level report 3. Checked Run functionality. Note: i have checked download functionality, Exception not appear on screen but getting in console related to JS. But Download file button not available to company level reports so need to check what actually happens on it. CC: Prasanna Karlekar
            Hide
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            While run report on LB generated query executing on OnlineEnrollment DB and those columns are not available on it. Need to check code on LB for this.

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - While run report on LB generated query executing on OnlineEnrollment DB and those columns are not available on it. Need to check code on LB for this.

              People

              Assignee:
              meghana.joshi Meghana Joshi (Inactive)
              Reporter:
              meghana.joshi Meghana Joshi (Inactive)
              Developer:
              Parmeshwar Jumbad (Inactive)
              QA:
              Meghana Joshi (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Pre-Prod Due Date:
                Production Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 5h
                  5h