WORKTERRAProject Type: software

WORKTERRA

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

standard report->Employee census->Payroll last date paid for->Getting server error

    Details

    • Type: Bug
    • Status: In Development
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Stage
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Partner
    • Module:
      BenAdmin - Report
    • Reported by:
      Harbinger
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Development - On Hold
    • Browser:
      Google Chrome
    • Sprint:
      WT Sprint 35 - Bugs, WT Sprint 37 - Bugs

      Description

      1.Login to stage
      2.Select company:LONG For HSPL
      3.Navigate to Home >> Company Home >> standard report
      4.click on add new
      5.Select Type as 'Employee census'.
      6.Provide report name
      7.Enter all mandatory field
      8.Select all employee fields
      10.Click on preview.

      Actual result: Getting server error
      Expected result: Report should be generated properly.

      Please refer attached scrren shot and error log

      same issue exist on LB.

        Attachments

          Issue Links

          relates to

          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

          Bug - A problem which impairs or prevents the functions of the product. WT-11676 LB->Global->standard report->Eligibility->Getting server error

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

            Activity

            Ascending order - Click to sort in descending order
            sanjana.jadhav Sanjana Jadhav (Inactive) created issue -
            Hide
            Permalink
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment -

            CC: Rakesh Roy Hrishikesh Deshpande Sachin Hingole

            Show
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - CC: Rakesh Roy Hrishikesh Deshpande Sachin Hingole
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Field Original Value New Value
            Description 1.Login to stage
            2.Select company:LONG For HSPL
            3.Navigate to Home >> Company Home >> standard report
            4.click on add new
            5.Select Type as 'Employee census'.
            6.Provide report name
            7.Enter all mandatory field
            8.Select all employee fields
            10.Click on preview.

            Actual result: Getting server error
            Expected result: Report should be generated properly.

            This issue is due to "Payroll last date paid for" field

            Please refer attached scrren shot and error log             		1.Login to stage
            2.Select company:LONG For HSPL
            3.Navigate to Home >> Company Home >> standard report
            4.click on add new
            5.Select Type as 'Employee census'.
            6.Provide report name
            7.Enter all mandatory field
            8.Select all employee fields
            10.Click on preview.

            Actual result: Getting server error
            Expected result: Report should be generated properly.

            *This issue is due to "Payroll last date paid for" field*

            Please refer attached scrren shot and error log
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Description 1.Login to stage
            2.Select company:LONG For HSPL
            3.Navigate to Home >> Company Home >> standard report
            4.click on add new
            5.Select Type as 'Employee census'.
            6.Provide report name
            7.Enter all mandatory field
            8.Select all employee fields
            10.Click on preview.

            Actual result: Getting server error
            Expected result: Report should be generated properly.

            *This issue is due to "Payroll last date paid for" field*

            Please refer attached scrren shot and error log             		1.Login to stage
            2.Select company:LONG For HSPL
            3.Navigate to Home >> Company Home >> standard report
            4.click on add new
            5.Select Type as 'Employee census'.
            6.Provide report name
            7.Enter all mandatory field
            8.Select all employee fields
            10.Click on preview.

            Actual result: Getting server error
            Expected result: Report should be generated properly.

            Please refer attached scrren shot and error log

            same issue exist on LB.
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 08/Aug/17 12:41 PM
            • Time Spent:
              1.5h
               

              Analysis and Try to reproduce issue on development Environment

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 1.5h [ 5400 ]
            Worklog Id 70101 [ 70101 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Dev Due Date 18/Aug/2017
            Original Estimate 0h [ 0 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Code Reviewed By Prasanna Karlekar [ 11907 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: On Hold(10207)
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 35 - Bugs [ 81 ]
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 22/Aug/17 03:18 PM
            • Time Spent:
              8.5h
               

              Internal discussion
              Issue reproduce on Dev Environment and find out cause
              Code changes and Unit testing

            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 22/Aug/17 11:30 PM
            • Time Spent:
              1.5h
               

              Issue discussion
              Discussion on fix to be done - Decided to do a permenant fix over here

            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 23/Aug/17 03:19 PM
            • Time Spent:
              9h
               

              Check code and verify reports for Global level
              Code changes for Global level
              Internal discussion

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 1.5h [ 5400 ] 10h [ 36000 ]
            Worklog Id 73924 [ 73924 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 10h [ 36000 ] 19h [ 68400 ]
            Worklog Id 73926 [ 73926 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 23/Aug/17 10:00 PM
            • Time Spent:
              1h
               

              Discussion on issue fix to be implemented

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Dev Due Date 18/Aug/2017 18/Aug/2017
            Item State Parent values: Development(10200)Level 1 values: On Hold(10207) Parent values: Development(10200)Level 1 values: In Progress(10206)
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 24/Aug/17 10:00 PM
            • Time Spent:
              1h
               

              Discussion on issue fix to be implemented

            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 25/Aug/17 04:13 AM
            • Time Spent:
              9h
               

              Code changes and all types report verification
              internal discussion

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 19h [ 68400 ] 28h [ 100800 ]
            Worklog Id 74269 [ 74269 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Dev Due Date 18/Aug/2017 18/Jan/2017
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 28/Aug/17 06:30 PM
            • Time Spent:
              1h
               

              Discussion on issue for Columwise Report
              List of scenarios to be unit tested

            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 29/Aug/17 05:54 AM
            • Time Spent:
              6h
               

              Implementation and Unit Testing on Old UI

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 28h [ 100800 ] 34h [ 122400 ]
            Worklog Id 74614 [ 74614 ]
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Link This issue relates to WT-10462 [ WT-10462 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 29/Aug/17 09:20 PM
            • Time Spent:
              0.5h
               

              Issue discussion of columnwise Billing Report

            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 30/Aug/17 04:01 AM
            • Time Spent:
              8h
               

              Internal discussion
              Unit testing on old UI
              Code changes for billing details column wise reports
              Unit testing on new UI for all types of reports

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 34h [ 122400 ] 42h [ 151200 ]
            Worklog Id 74985 [ 74985 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 42h [ 151200 ] 43.5h [ 156600 ]
            Worklog Id 75546 [ 75546 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 43.5h [ 156600 ] 44.5h [ 160200 ]
            Worklog Id 75569 [ 75569 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 44.5h [ 160200 ] 45.5h [ 163800 ]
            Worklog Id 75586 [ 75586 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 45.5h [ 163800 ] 46.5h [ 167400 ]
            Worklog Id 75619 [ 75619 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 46.5h [ 167400 ] 47h [ 169200 ]
            Worklog Id 75650 [ 75650 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 35 - Bugs [ 81 ] WT Sprint 35 - Bugs, WT Sprint 37 - Bugs [ 81, 87 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Dev Due Date 18/Jan/2017 14/Sep/2017
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Parmeshwar Jumbad [ parmeshwar.jumbade ] Prasanna Karlekar [ prasanna ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Dev Due Date 14/Sep/2017 15/Sep/2017
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 15/Sep/17 12:30 AM
            • Time Spent:
              0.5h
               

              Code review

            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 15/Sep/17 06:30 PM
            • Time Spent:
              3h
               

              Code review
              Go through of changes done
              Discussion on better way this can be handled

            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 47h [ 169200 ] 47.5h [ 171000 ]
            Worklog Id 79223 [ 79223 ]
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 18/Sep/17 12:27 PM
            • Time Spent:
              7h
               

              Internal discussion
              Code changes and Unit testing
              Check existing code

            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 18/Sep/17 06:00 PM
            • Time Spent:
              3.5h
               

              Code analysis for hard coded fields used in Standard and some Static Report
              Discussion on approach to fix the issue

            prasanna Prasanna Karlekar (Inactive) made changes -
            Dev Due Date 15/Sep/2017 19/Sep/2017
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Attachment modified fi;es.txt [ 61954 ]
            Hide
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            3C's:

            Concern: Getting server error
            Cause: The issue was due to after removal of special characters multiple columns names were same. Example: On employee census report having two fields Payroll last date paid for & Payroll last date paid for: respectively. After remove special character (i.e. : in second column name ) it become same as previous one. It was throwing exception.
            Correction: Now while forming datasource and writing RDL we have removed special charcter and replaced with underscor. Due to this every fields will get unique name and will not have duplicate while writing datasource.

            Affected Files: Please check attached modified fi;es.txt file.

            Affected Areas: Reports (Need to verify every type of report)

            Tested Scenarios:
            1. Verified all standard reports with multiple combinations.
            2. Checked reports with the selection of special characters fields.
            3. Checked preview and save functionality.
            4. Verified Global level standard report (Not verified data and only normal report)
            5. Every reports with multiple fields selections.

            Known issues:
            1. Scroll not appear to fields if having large text width
            2. If two fields having same name but distinct special characters then it will not work because it will form same name after replace spacial characters.

            Note: Need to verify this issue on all environment.

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - 3C's : Concern : Getting server error Cause : The issue was due to after removal of special characters multiple columns names were same. Example: On employee census report having two fields Payroll last date paid for & Payroll last date paid for: respectively. After remove special character (i.e. : in second column name ) it become same as previous one. It was throwing exception. Correction : Now while forming datasource and writing RDL we have removed special charcter and replaced with underscor. Due to this every fields will get unique name and will not have duplicate while writing datasource. Affected Files : Please check attached modified fi;es.txt file. Affected Areas : Reports (Need to verify every type of report) Tested Scenarios : 1. Verified all standard reports with multiple combinations. 2. Checked reports with the selection of special characters fields. 3. Checked preview and save functionality. 4. Verified Global level standard report (Not verified data and only normal report) 5. Every reports with multiple fields selections. Known issues : 1. Scroll not appear to fields if having large text width 2. If two fields having same name but distinct special characters then it will not work because it will form same name after replace spacial characters. Note: Need to verify this issue on all environment.
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 47.5h [ 171000 ] 54.5h [ 196200 ]
            Worklog Id 79733 [ 79733 ]
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 19/Sep/17 12:45 PM
            • Time Spent:
              1h
               

              Unit testing
              JIRA update
              Review request

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 54.5h [ 196200 ] 55.5h [ 199800 ]
            Worklog Id 79766 [ 79766 ]
            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)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] 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 ] Sanjana Jadhav [ sanjana.jadhav ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Production Due Date 28/Sep/2017
            Stage Due Date 27/Sep/17 [ 2017-09-27 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 55.5h [ 199800 ] 58.5h [ 210600 ]
            Worklog Id 81194 [ 81194 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 58.5h [ 210600 ] 62h [ 223200 ]
            Worklog Id 81306 [ 81306 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Dev Due Date 19/Sep/2017 04/Oct/2017
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Stage Due Date 27/Sep/17 [ 2017-09-27 ] 5/Oct/17 [ 2017-10-05 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Production Due Date 28/Sep/2017
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Summary Azure->standard report->Employee census->Payroll last date paid for->Getting server error standard report->Employee census->Payroll last date paid for->Getting server error
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Link This issue relates to WT-11675 [ WT-11675 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Link This issue relates to WT-11676 [ WT-11676 ]
            Hide
            Permalink
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - - edited

            Hi [~parmeshwar.jumbade]

            Verified on LB
            Verified all types of standard report on company and global level

            Company level-
            1.Employee census -> Pass
            2.Dependent census -> Pass
            3.Eligibility -> Pass
            4.Enrollment -> Pass
            5.Billing details -> Pass
            6.Payroll deduction -> Pass
            7.System utilization- WT-11675
            8.Commission details -> Pass
            9.Fee details -> Pass
            10.Benefit wise billing details -> Pass

            global level-
            1.Employee census -> Pass
            2.Dependent census -> Pass
            3.Eligibility- WT-11676
            4.Enrollment -> Pass
            5.Billing details -> Pass
            6.Payroll deduction -> Pass
            7.System utilization -> Pass
            8.Commission details -> Pass
            9.Fee details -> Pass

            Verified reports with the selection of special characters fields.
            Verified save, Run and preview button fuctionality

            Please look into following issues found.Once resolved assign back to me.
            1. WT-11675 -> Getting error on systeem utilization report
            2.WT-11676 -> Getting server error on global eligiblility report

            CC: Rakesh Roy Prasad Pise Hrishikesh Deshpande Sachin Hingole

            Thanks,
            Sanjana Jadhav

            Show
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - - edited Hi [~parmeshwar.jumbade] Verified on LB Verified all types of standard report on company and global level Company level- 1.Employee census -> Pass 2.Dependent census -> Pass 3.Eligibility -> Pass 4.Enrollment -> Pass 5.Billing details -> Pass 6.Payroll deduction -> Pass 7.System utilization- WT-11675 8.Commission details -> Pass 9.Fee details -> Pass 10.Benefit wise billing details -> Pass global level- 1.Employee census -> Pass 2.Dependent census -> Pass 3.Eligibility- WT-11676 4.Enrollment -> Pass 5.Billing details -> Pass 6.Payroll deduction -> Pass 7.System utilization -> Pass 8.Commission details -> Pass 9.Fee details -> Pass Verified reports with the selection of special characters fields. Verified save, Run and preview button fuctionality Please look into following issues found.Once resolved assign back to me. 1. WT-11675 -> Getting error on systeem utilization report 2. WT-11676 -> Getting server error on global eligiblility report CC: Rakesh Roy Prasad Pise Hrishikesh Deshpande Sachin Hingole Thanks, Sanjana Jadhav
            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: Re-open(10212)
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Assignee Sanjana Jadhav [ sanjana.jadhav ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            Permalink
            sanjana.jadhav Sanjana Jadhav (Inactive) logged work - 18/Oct/17 09:18 AM - edited
            • Time Spent:
              2.5h
               

              Verified on LB
              Issue logged
              Jira update

            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Time Spent 62h [ 223200 ] 64.2h [ 231120 ]
            Worklog Id 85530 [ 85530 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Time Spent 64.2h [ 231120 ] 64.5h [ 232200 ]
            Worklog Id 85530 [ 85530 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Link This issue relates to WT-11675 [ WT-11675 ]
            Hide
            Permalink
            prasanna Prasanna Karlekar (Inactive) added a comment -

            We are keeping this JIRA On Hold.
            From OE perspective, It is fine if we do not send this fix further.

            Thank you!

            cc: Gaurav Sodani, Jyoti Agrawal, [~parmeshwar.jumbade]

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - We are keeping this JIRA On Hold. From OE perspective, It is fine if we do not send this fix further. Thank you! cc: Gaurav Sodani , Jyoti Agrawal , [~parmeshwar.jumbade]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: Development(10200)Level 1 values: On Hold(10207)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 64.5h [ 232200 ] 64.75h [ 233100 ]
            Worklog Id 91850 [ 91850 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 21/Nov/17 11:25 PM
            • Time Spent:
              0.25h
               

              Discussion
              JIRA update

            prasanna Prasanna Karlekar (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Company All Clients/Multiple Clients [ 18434 ]
            Environment Stage [ 18443 ]
            Transition Time In Source Status Execution Times
            Parmeshwar Jumbad (Inactive) made transition -
            Open In Development
            		21h 34m 1
            Sachin Hingole (Inactive) made transition -
            In Development In LB Testing
            		44d 17h 49m 1
            Sanjana Jadhav (Inactive) made transition -
            In LB Testing Reopen in Local
            		26d 3h 25m 1
            Prasanna Karlekar (Inactive) made transition -
            Reopen in Local In Development
            		43d 21h 26m 1

              People

              Assignee:
              parmeshwar.jumbad Parmeshwar Jumbad (Inactive)
              Reporter:
              sanjana.jadhav Sanjana Jadhav (Inactive)
              Developer:
              Parmeshwar Jumbad (Inactive)
              QA:
              Sanjana Jadhav (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Dev Due Date:
                Pre-Prod Due Date:

                  Time Tracking

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