Uploaded image for project: 'New Features 2017'
  1. New Features 2017
  2. NF-5724

Newly Enrollment Dependent Report -> Pulling report throws error

    Details

    • Type: Bug
    • Status: Resolution Setting
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: UI Refresh
    • Labels:
      None
    • Environment:
      Pre Production
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Partner
    • Module:
      BenAdmin - Report
    • Reported by:
      Harbinger
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Stage QA - Production Deployment on Hold

      Description

      Environment - Preprod
      Company - Orchard school district, The packard companies
      Browser - Chrome / IE

      1) Login with partner
      2) Select company
      3) Reports -> Newly enrollment dependent report -> Preview reports -> throws error

      Note - After clearing cache also issue exists

        Attachments

          Issue Links

            Activity

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - cc : Rakesh Roy Prasad Pise Sachin Hingole
            Hide
            vijayendra Vijayendra Shinde (Inactive) added a comment -
            Show
            vijayendra Vijayendra Shinde (Inactive) added a comment - CC: Nidhi Kaul
            Hide
            sumeet.kolge Sumeet.Kolge (Inactive) added a comment -

            Environment : Pre-Prod
            Company: Colts for hspl

            Same server error observed by partner/admin login.

            ---------------------------------
            CC: Mandar Kulkarni, Satya, Rakesh Roy, Hrishikesh Deshpande, Sachin Hingole, Prasad Patil

            Show
            sumeet.kolge Sumeet.Kolge (Inactive) added a comment - Environment : Pre-Prod Company: Colts for hspl Same server error observed by partner/admin login. --------------------------------- CC: Mandar Kulkarni , Satya , Rakesh Roy , Hrishikesh Deshpande , Sachin Hingole , Prasad Patil
            Hide
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            Below are the 3C's:

            Concern: Newly Enrolled Dependent Report throws error on preview.
            Cause: This issue was caused because of fix done in NF-5613. We did not verify the impact on Newly enrolled dependent Report.
            While fixing issue for NF-5613 following was done:

            • While creating JOIN clause, we removed the hard coded string that was used earlier for field name and instead used the selected field value as it is. While doing so, some of the space characters also got removed.
            • As we removed the hardcoded value, while doing string comparison in further implementation, there was issue related to case sensitivity for same field name.
              Because of these reasons, error appeared while previewing the report.

            Correction:
            Now we have done following two changes:
            1. Added space in the string while creating JOIN clause.
            2. While comparing query text, have capitalized characters, so that it will avoid case sensitivity problem.

            Affected Areas: Reports (Newly dependent report, Standard report, dynamic report)
            Affected Files: StandardReports.cshtml
            Tested Scenarios:
            1. Checked newly dependent report with preview option.
            2. Verified Standard and Dynamic report with metadata fields like Relationship and Secondary relationship.

            Known issues:
            1. After click on any fields from select/display fields it scroll to the top of section. It should not.
            2. Employee type field (I.e. Metadata field) returning number instead of name of type.

            CC: Prasanna Karlekar Amruta Lohiya Gaurav Sodani

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - Below are the 3C's : Concern : Newly Enrolled Dependent Report throws error on preview. Cause : This issue was caused because of fix done in NF-5613 . We did not verify the impact on Newly enrolled dependent Report. While fixing issue for NF-5613 following was done: While creating JOIN clause, we removed the hard coded string that was used earlier for field name and instead used the selected field value as it is. While doing so, some of the space characters also got removed. As we removed the hardcoded value, while doing string comparison in further implementation, there was issue related to case sensitivity for same field name. Because of these reasons, error appeared while previewing the report. Correction : Now we have done following two changes: 1. Added space in the string while creating JOIN clause. 2. While comparing query text, have capitalized characters, so that it will avoid case sensitivity problem. Affected Areas : Reports (Newly dependent report, Standard report, dynamic report) Affected Files : StandardReports.cshtml Tested Scenarios : 1. Checked newly dependent report with preview option. 2. Verified Standard and Dynamic report with metadata fields like Relationship and Secondary relationship. Known issues : 1. After click on any fields from select/display fields it scroll to the top of section. It should not. 2. Employee type field (I.e. Metadata field) returning number instead of name of type. CC: Prasanna Karlekar Amruta Lohiya Gaurav Sodani
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Verified on codemap
            Company - QA kindercare

            Verified newly enrolled dependent report - Pulling reports shows proper data
            Also verified standard report and dynamic report.
            Marking item state as Ready for stage

            Thanks,
            Jayshree

            cc : Rakesh Roy Prasad Pise Sachin Hingole Hrishikesh Deshpande

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified on codemap Company - QA kindercare Verified newly enrolled dependent report - Pulling reports shows proper data Also verified standard report and dynamic report. Marking item state as Ready for stage Thanks, Jayshree cc : Rakesh Roy Prasad Pise Sachin Hingole Hrishikesh Deshpande

              People

              Assignee:
              jayshree.nagpure Jayshree Nagpure (Inactive)
              Reporter:
              jayshree.nagpure Jayshree Nagpure (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 10.25h
                  10.25h