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
            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
            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.
            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
            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]

              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