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

            Ascending order - Click to sort in descending order
            meghana.joshi Meghana Joshi (Inactive) created issue -
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to WT-129 [ WT-129 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 0.75h [ 2700 ]
            Worklog Id 62072 [ 62072 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            Original Estimate 0h [ 0 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Developer Parmeshwar Jumbad [ parmeshwar.jumbade ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Code Review Date 11/Jul/2017
            Code Reviewed By Prasanna Karlekar [ 11907 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 0.75h [ 2700 ] 3.25h [ 11700 ]
            Worklog Id 62406 [ 62406 ]
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 32-Bugs [ 76 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Assignee Parmeshwar Jumbad [ parmeshwar.jumbade ] 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 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Production Due Date 10/Aug/2017
            Stage Due Date 7/Aug/17 [ 2017-08-07 ]
            meghana.joshi Meghana Joshi (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)
            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: On Hold(10211)
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Production Due Date 10/Aug/2017 15/Aug/2017
            Stage Due Date 7/Aug/17 [ 2017-08-07 ] 9/Aug/17 [ 2017-08-09 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Production Due Date 15/Aug/2017 16/Aug/2017
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Production Due Date 16/Aug/2017 18/Aug/2017
            Stage Due Date 9/Aug/17 [ 2017-08-09 ] 14/Aug/17 [ 2017-08-14 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Production Due Date 18/Aug/2017 24/Aug/2017
            Stage Due Date 14/Aug/17 [ 2017-08-14 ] 17/Aug/17 [ 2017-08-17 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            QA Meghana Joshi [ meghana.kulkarni ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: On Hold(10215)
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Time Spent 3.25h [ 11700 ] 3.75h [ 13500 ]
            Worklog Id 73021 [ 73021 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Code Review Date 11/Jul/2017 11/Jul/2017
            Production Due Date 24/Aug/2017 29/Aug/2017
            Stage Due Date 17/Aug/17 [ 2017-08-17 ] 17/Aug/17 [ 2017-08-17 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Production Due Date 29/Aug/2017
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 3.75h [ 13500 ] 4h [ 14400 ]
            Worklog Id 75518 [ 75518 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Production Due Date 19/Sep/2017
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: On Hold(10215) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Time Spent 4h [ 14400 ] 5h [ 18000 ]
            Worklog Id 80219 [ 80219 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            satyap Satya made changes -
            Environment_New LB [ 18444 ]

              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