WORKTERRAProject Type: software

WORKTERRA

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

Report -> System Utilization - throws server error on report running

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      QA
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Report
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have

      Description

      Replication Steps :
      1) Create one System Utilization report
      2) Map Employee Effective Date and Emergency Contact Effective Date
      3) Run Report

      Throws error on report running:
      An error has occurred during report processing. (rsProcessingAborted)
      Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)
      For more information about this error navigate to the report server on the local server machine, or enable remote errors

      CC - Sachin Hingole Prasanna Karlekar

        Attachments

        1. wt-9020.png
          wt-9020.png
          119 kB
        2. wt-9020.png
          wt-9020.png
          89 kB
        3. wt-9020.png
          wt-9020.png
          123 kB

          Issue Links

          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. WT-7867 Employee effective date to expose on report

          • Critical - This problem will block progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - - edited

            This task is ready for testing

            Concern : System Utilization - throws server error on report running.
            Cause: Query was not generating properly those fields.
            Correction: Now all the fields are mapped correctly.

            Affected Areas: System utilization report
            Affected File Name: OES_SP_SystemUtilization.StoredProcedure.sql
            Tested Scenarios:
            Following scenarios i have tested at my end
            1. Checked reports with selection of individual fields from system utilization and employee fields
            2. Checked reports with selection of all fields except few fields like Employee Monthly Average Working Hours, Employee Stable Working Hours, Formatted Social Security No., Year Of Service
            3. Checked report for diffrent classes, status and dates
            4. Verified report with superadmin user login

            Known issue:
            There is problem to selection of some fields like Employee Monthly Average Working Hours, Employee Stable Working Hours, Formatted Social Security No., Year Of Service. For that we have added new JIRA with and ID- WT-9679

            CC: Prasanna Karlekar

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - - edited This task is ready for testing Concern : System Utilization - throws server error on report running. Cause : Query was not generating properly those fields. Correction : Now all the fields are mapped correctly. Affected Areas : System utilization report Affected File Name : OES_SP_SystemUtilization.StoredProcedure.sql Tested Scenarios : Following scenarios i have tested at my end 1. Checked reports with selection of individual fields from system utilization and employee fields 2. Checked reports with selection of all fields except few fields like Employee Monthly Average Working Hours, Employee Stable Working Hours, Formatted Social Security No., Year Of Service 3. Checked report for diffrent classes, status and dates 4. Verified report with superadmin user login Known issue: There is problem to selection of some fields like Employee Monthly Average Working Hours, Employee Stable Working Hours, Formatted Social Security No., Year Of Service. For that we have added new JIRA with and ID- WT-9679 CC: Prasanna Karlekar
            Hide
            Permalink
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment -

            Verified on LB
            Working properly.
            PFA,

            Thanks,
            Sanjana Jadhav

            CC: Rakesh Roy Hrishikesh Deshpande

            Show
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - Verified on LB Working properly. PFA, Thanks, Sanjana Jadhav CC: Rakesh Roy Hrishikesh Deshpande
            Hide
            Permalink
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - - edited

            Verified on stage.
            Report run properly. Not getting server error.
            Ready for production.
            PFA,

            Thanks,
            Sanjana Jadhav.

            CC: Rakesh Roy Hrishikesh Deshpande

            Show
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - - edited Verified on stage. Report run properly. Not getting server error. Ready for production. PFA, Thanks, Sanjana Jadhav. CC: Rakesh Roy Hrishikesh Deshpande
            Hide
            Permalink
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment -

            Verified on production.
            Report run sucessfully.
            PFA,

            Thanks,
            Sanjana Jadhav

            CC:Rakesh Roy Hrishikesh Deshpande Sachin Hingole

            Show
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - Verified on production. Report run sucessfully. PFA, Thanks, Sanjana Jadhav CC: Rakesh Roy Hrishikesh Deshpande Sachin Hingole

              People

              Assignee:
              sanjana.jadhav Sanjana Jadhav (Inactive)
              Reporter:
              meghana.joshi Meghana Joshi (Inactive)
              Developer:
              Parmeshwar Jumbad (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

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

                  Time Tracking

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