WORKTERRAProject Type: software

WORKTERRA

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

UI refresh_ACA_W2 report_Getting error on click of Preview.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Cannot Reproduce
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Environment:
      Others
    • Bug Severity:
      Medium
    • Level:
      Partner
    • Module:
      ACA - 2017
    • Reported by:
      Harbinger
    • Item State:
      Stage QA - Re-open
    • Issue Importance:
      Q2
    • Browser:
      Google Chrome
    • Sprint:
      WT Sprint 33-Bugs

      Description

      1.Login to Azurre
      2.Edit company say "JE Dunn for Hspl"
      3.Navigate to Home >> Company Home >> IRS Reports
      4.Add new IRS report.
      5.Select Type as 'W2 Report'.
      6.Provide report name
      7.Select Cost Calculation Basis as 'Pro-rated' or 'Bill for Entire Month'
      8.Consider Plan with 'Lower Premium' or 'Higher Premium' or 'Prorated'
      9.Enter other required details.
      10.Click on Preview.

      Actual: Received an error as '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
      Expected: Report should get open.

        Attachments

        1. W2 Report.png
          W2 Report.png
          85 kB
        2. WT-10459_1.png
          WT-10459_1.png
          74 kB

          Issue Links

          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. NF-2140 ACA W2 Report

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

          Bug - A problem which impairs or prevents the functions of the product. WT-10459 UI refresh_ACA_W2 report_Month covered_Getting error on click of Preview.

          • Medium - Has the potential to affect progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-10462 ACA_W2 report_all employee fields and benefit related fields_Getting server error on click of Preview.

          • Medium - Has the potential to affect progress.
          • Resolution Setting

            Activity

            Ascending order - Click to sort in descending order
            smita.pawar Smita Pawar (Inactive) created issue -
            smita.pawar Smita Pawar (Inactive) made changes -
            Field Original Value New Value
            Assignee Nandkumar [ satyap ] Kumar Chhajed [ kumar.chhajed ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Attachment W2 Report.png [ 52615 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Link This issue relates to NF-2140 [ NF-2140 ]
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206)
            Permalink
            kumar.chhajed Kumar Chhajed (Inactive) logged work - 21/Jun/17 02:05 PM
            • Time Spent:
              1.5h
               

              Analysis
              Finding root cause
              Internal discussion with Nandu

            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Remaining Estimate 8h [ 28800 ]
            Original Estimate 8h [ 28800 ]
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Remaining Estimate 8h [ 28800 ] 6.5h [ 23400 ]
            Time Spent 1.5h [ 5400 ]
            Worklog Id 57266 [ 57266 ]
            Permalink
            kumar.chhajed Kumar Chhajed (Inactive) logged work - 23/Jun/17 12:27 PM
            • Time Spent:
              2h
               

              Finding root cause
              Internal discussion with Surender

            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Remaining Estimate 6.5h [ 23400 ] 4.5h [ 16200 ]
            Time Spent 1.5h [ 5400 ] 3.5h [ 12600 ]
            Worklog Id 57934 [ 57934 ]
            Permalink
            surender.kumar surender kumar (Inactive) logged work - 23/Jun/17 12:57 PM
            • Time Spent:
              1h
               

              Analysis
              Discussion

            surender.kumar surender kumar (Inactive) made changes -
            Remaining Estimate 4.5h [ 16200 ] 3.5h [ 12600 ]
            Time Spent 3.5h [ 12600 ] 4.5h [ 16200 ]
            Worklog Id 57980 [ 57980 ]
            Permalink
            kumar.chhajed Kumar Chhajed (Inactive) logged work - 27/Jun/17 01:51 PM
            • Time Spent:
              4.5h
               

              Analysis
              Debugging code
              internal discussion with team member

            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Remaining Estimate 3.5h [ 12600 ] 0h [ 0 ]
            Time Spent 4.5h [ 16200 ] 9h [ 32400 ]
            Worklog Id 58341 [ 58341 ]
            Permalink
            kumar.chhajed Kumar Chhajed (Inactive) logged work - 03/Jul/17 02:15 PM
            • Time Spent:
              0.5h
               

              Discussion with nandu

            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Time Spent 9h [ 32400 ] 9.5h [ 34200 ]
            Worklog Id 60588 [ 60588 ]
            Hide
            Permalink
            kumar.chhajed Kumar Chhajed (Inactive) added a comment -

            Hi Prasanna Karlekar,

            As per discussion with you, this issue is also applicable for Enrollment report which need to fixed. Hence assigning you the same.

            Show
            kumar.chhajed Kumar Chhajed (Inactive) added a comment - Hi Prasanna Karlekar , As per discussion with you, this issue is also applicable for Enrollment report which need to fixed. Hence assigning you the same.
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Assignee Kumar Chhajed [ kumar.chhajed ] Prasanna Karlekar [ prasanna ]
            Permalink
            kumar.chhajed Kumar Chhajed (Inactive) logged work - 05/Jul/17 12:15 PM
            • Time Spent:
              0.5h
               

              Unit testing
              Internal discussion

            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Time Spent 9.5h [ 34200 ] 10h [ 36000 ]
            Worklog Id 60859 [ 60859 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 33-Bugs [ 77 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
            Code Reviewed By Prasanna Karlekar [ 11907 ]
            Dev Due Date 27/Jul/2017
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 26/Jul/17 12:54 PM
            • Time Spent:
              1h
               

              Check comment in JIRA
              Check report on Azure Environment
              Tried to reproduce issue

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 10h [ 36000 ] 11h [ 39600 ]
            Worklog Id 66588 [ 66588 ]
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 27/Jul/17 10:02 AM - edited
            • Time Spent:
              6.25h
               

              Reproduce issue on Local Environment
              Analysis of an Issue
              Changes to resolve issue
              Unit testing

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 11h [ 39600 ] 17.25h [ 62100 ]
            Worklog Id 66989 [ 66989 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 17.25h [ 62100 ] 18.25h [ 65700 ]
            Worklog Id 66989 [ 66989 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Remaining Estimate 0h [ 0 ] 1h [ 3600 ]
            Time Spent 18.25h [ 65700 ] 17.25h [ 62100 ]
            Worklog Id 66989 [ 66989 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 27/Jul/17 06:30 PM
            • Time Spent:
              0.5h
               

              Discussion on issue repro

            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 1h [ 3600 ] 0.5h [ 1800 ]
            Time Spent 17.25h [ 62100 ] 17.75h [ 63900 ]
            Worklog Id 68182 [ 68182 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Code Review Date 31/Jul/2017
            prasanna Prasanna Karlekar (Inactive) made changes -
            Remaining Estimate 0.5h [ 1800 ] 0.25h [ 900 ]
            Time Spent 17.75h [ 63900 ] 18h [ 64800 ]
            Worklog Id 68496 [ 68496 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 31/Jul/17 11:30 PM
            • Time Spent:
              0.25h
               

              Code and Functionality review
              Changes suggested

            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 -
            Assignee Parmeshwar Jumbad [ parmeshwar.jumbade ] Sachin Hingole [ sachin.hingole ]
            Hide
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            3C's:

            Concern: Error on preview button
            Cause: There was an User Environment field on Enrollment report due to this exception getting thrown.
            Correction: Handled case to render user environment field on other reports except System utilization reports.

            Affected Areas: Reports

            Affected Files:
            App/BusinessLogic/Reports/ReportDetails.vb
            07_Data/491_WT-4059_WTB_Report_ModData_ReportFieldsMapping.sql

            Tested Scenarios:
            1. Checked that User environment field appear or not on other reports.
            2. Verified system utilization reports fields that Field is appear or not.
            3. Verified report generate or not with above mentioned steps.

            Kumar Chhajed, We just removed user environment field from report and it's working now but not verified report data.

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - 3C's: Concern: Error on preview button Cause : There was an User Environment field on Enrollment report due to this exception getting thrown. Correction : Handled case to render user environment field on other reports except System utilization reports. Affected Areas : Reports Affected Files : App/BusinessLogic/Reports/ReportDetails.vb 07_Data/491_ WT-4059 _WTB_Report_ModData_ReportFieldsMapping.sql Tested Scenarios : 1. Checked that User environment field appear or not on other reports. 2. Verified system utilization reports fields that Field is appear or not. 3. Verified report generate or not with above mentioned steps. Kumar Chhajed , We just removed user environment field from report and it's working now but not verified report data.
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Sanjana Jadhav [ sanjana.jadhav ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            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)
            Hide
            Permalink
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - - edited

            Verified on LB and Azure.
            Verified W2 Report and Enrollment report

            Tested scanerio:
            1.Follow all the steps mentioned above and verified that report is generated or not
            2.Verified save and preview button
            Working properly.
            Ready for stage

            Thanks,
            Sanjana Jadhav.

            CC: Rakesh Roy Hrishikesh Deshpande Smita Pawar

            Show
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - - edited Verified on LB and Azure. Verified W2 Report and Enrollment report Tested scanerio: 1.Follow all the steps mentioned above and verified that report is generated or not 2.Verified save and preview button Working properly. Ready for stage Thanks, Sanjana Jadhav. CC: Rakesh Roy Hrishikesh Deshpande Smita Pawar
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Remaining Estimate 0.25h [ 900 ] 0h [ 0 ]
            Time Spent 18h [ 64800 ] 18.75h [ 67500 ]
            Worklog Id 68765 [ 68765 ]
            Permalink
            sanjana.jadhav Sanjana Jadhav (Inactive) logged work - 03/Aug/17 05:47 AM
            • Time Spent:
              0.75h
               

              Verified on LB and azure

            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Developer Kumar Chhajed [ kumar.chhajed ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
            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)
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: On Hold(10215)
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: On Hold(10215) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 07/Aug/17 12:57 PM
            • Time Spent:
              0.5h
               

              Internal discussion with QA

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 18.75h [ 67500 ] 19.25h [ 69300 ]
            Worklog Id 69760 [ 69760 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Link This issue relates to WT-10462 [ WT-10462 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Link This issue relates to WT-10459 [ WT-10459 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Re-open(10216)
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Resolution Unresolved [ 10200 ]
            Status Stage Testing [ 10201 ] Reopen in Stage [ 10023 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Assignee Sanjana Jadhav [ sanjana.jadhav ] Kumar Chhajed [ kumar.chhajed ]
            Hide
            Permalink
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment -

            Hi Kumar Chhajed

            Due to open issues assigning this jira back to you.Once it is resolved assign back to me.

            Thanks,
            Sanjana Jadhav.

            CC: Rakesh Roy Hrishikesh Deshpande Smita Pawar

            Show
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - Hi Kumar Chhajed Due to open issues assigning this jira back to you.Once it is resolved assign back to me. Thanks, Sanjana Jadhav. CC: Rakesh Roy Hrishikesh Deshpande Smita Pawar
            Permalink
            sanjana.jadhav Sanjana Jadhav (Inactive) logged work - 07/Aug/17 01:31 PM
            • Time Spent:
              3.7h
               

              testing
              internal discussion with parmeshwar

            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Time Spent 19.25h [ 69300 ] 22.95h [ 82620 ]
            Worklog Id 69787 [ 69787 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Bug Severity Medium [ 16702 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Attachment WT-10459_1.png [ 63541 ]
            Hide
            Permalink
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment -

            Verified on LB and azure.
            Verified preview, save and cancel button functionality.Working properly.
            Hence closing this issue.
            PFA,

            CC: Rakesh Roy Prasad Pise Smita Pawar

            Thanks,
            Sanjana Jadhav.

            Show
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - Verified on LB and azure. Verified preview, save and cancel button functionality.Working properly. Hence closing this issue. PFA, CC: Rakesh Roy Prasad Pise Smita Pawar Thanks, Sanjana Jadhav.
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Time Spent 22.95h [ 82620 ] 23.45h [ 84420 ]
            Worklog Id 83343 [ 83343 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Status Reopen in Stage [ 10023 ] In Development [ 10007 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Resolution Unresolved [ 10200 ] Cannot Reproduce [ 5 ]
            Status In Development [ 10007 ] Rejected [ 10004 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Assignee Kumar Chhajed [ kumar.chhajed ] Sanjana Jadhav [ sanjana.jadhav ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Status Rejected [ 10004 ] Closed [ 6 ]
            Permalink
            sanjana.jadhav Sanjana Jadhav (Inactive) logged work - 06/Oct/17 06:28 AM
            • Time Spent:
              0.5h
               

              Verified on azure and LB

            satyap Satya made changes -
            Environment_New Others [ 18445 ]
            Transition Time In Source Status Execution Times
            Kumar Chhajed (Inactive) made transition -
            Open In Development
            		22h 42m 1
            Sachin Hingole (Inactive) made transition -
            In Development In LB Testing
            		41d 4h 40m 1
            Sanjana Jadhav (Inactive) made transition -
            In LB Testing Stage Testing
            		5d 22h 37m 1
            Sanjana Jadhav (Inactive) made transition -
            Stage Testing Reopened in Stage
            		4h 44m 1
            Sanjana Jadhav (Inactive) made transition -
            Reopened in Stage In Development
            		58d 17h 1
            Sanjana Jadhav (Inactive) made transition -
            In Development Rejected
            		46s 1
            Sanjana Jadhav (Inactive) made transition -
            Rejected Closed
            		1m 48s 1

              People

              Assignee:
              sanjana.jadhav Sanjana Jadhav (Inactive)
              Reporter:
              smita.pawar Smita Pawar (Inactive)
              Developer:
              Parmeshwar Jumbad (Inactive)
              QA:
              Smita Pawar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 8h Original Estimate - 8h
                  8h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 23.45h
                  23.45h