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

            Activity

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 29/May/17 11:59 AM
            • Time Spent:
              3.5h
               

              1. Understand problem and reproduce issue
              2. Find out cause of issue

            prasanna Prasanna Karlekar (Inactive) logged work - 29/May/17 07:00 PM
            • Time Spent:
              1h
               

              Issue discussion
              Server error on saving standard reports
              Discussion on fix to be done

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 30/May/17 12:45 PM
            • Time Spent:
              8h
               

              Fix issue
              Discussion on fix to be done
              Issue discussion
              Server error on saving standard reports
              Unit testing for all fields

            prasanna Prasanna Karlekar (Inactive) logged work - 30/May/17 10:00 PM
            • Time Spent:
              0.75h
               

              Discussion on changes done
              Discussion on issues related to field selections for System Utilization report

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 31/May/17 12:11 PM
            • Time Spent:
              5.75h
               

              Discussion on changes done
              Discussion on issues related to field selections for System Utilization report
              Changes and Unit testing of fields selection with different combinations
              Code review
              R&D of how to call Remote UDF from select statement

            prasanna Prasanna Karlekar (Inactive) logged work - 31/May/17 09:00 PM
            • Time Spent:
              0.5h
               

              Discussion on fix done
              Code review

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 01/Jun/17 12:34 PM
            • Time Spent:
              0.75h
               

              Check-In in trunk and LB branch
              Task marked to local Testing

            prasanna Prasanna Karlekar (Inactive) logged work - 01/Jun/17 09:00 PM
            • Time Spent:
              1h
               
              • Functionality review
              • Discussion and analysis on fields which use UDF for which server error appears on report
            sanjana.jadhav Sanjana Jadhav (Inactive) logged work - 15/Jun/17 06:10 AM - edited
            • Time Spent:
              0.8h
               

              Verified on LB

            sanjana.jadhav Sanjana Jadhav (Inactive) logged work - 21/Jun/17 05:30 AM - edited
            • Time Spent:
              0.5h
               

              Verified on stage

            sanjana.jadhav Sanjana Jadhav (Inactive) logged work - 22/Jun/17 09:52 AM
            • Time Spent:
              0.7h
               

              Verified on production

              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