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

Standard Report for Multiple Locatons error

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Report
    • Reported by:
      Support
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 31-Bugs

      Description

      Per attachment below - when I try to do a standard report for multilple locations, I receive an ERROR message.

        Attachments

        1. EnrollmentReport.jpg
          EnrollmentReport.jpg
          84 kB
        2. image001.jpg
          image001.jpg
          1.0 kB
        3. image002.jpg
          image002.jpg
          1 kB
        4. image003.png
          image003.png
          1 kB
        5. image004.png
          image004.png
          5 kB
        6. image005.jpg
          image005.jpg
          64 kB
        7. image006.jpg
          image006.jpg
          2 kB
        8. image007.jpg
          image007.jpg
          3 kB
        9. image009.png
          image009.png
          0.6 kB
        10. LB_Global Report.jpg
          LB_Global Report.jpg
          79 kB
        11. Standard Report Multiple Locations error.png
          Standard Report Multiple Locations error.png
          134 kB

          Issue Links

            Activity

            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -

            ErrorID : 0
            ErrorSource : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->ReportDetails.GetData->ReportDetails.GetReportListByCompanyIds
            ErrorMessage: Invalid object name 'AdvancedDrainageSystemsInc_12242.dbo.ReportDetails'.
            StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.GetData(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity)

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - ErrorID : 0 ErrorSource : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->ReportDetails.GetData->ReportDetails.GetReportListByCompanyIds ErrorMessage: Invalid object name 'AdvancedDrainageSystemsInc_12242.dbo.ReportDetails'. StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.GetData(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity)
            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi Amanda B. Garvey,

            Apologies for delayed reply.
            This functionality was not in use and hence is not up to the mark.
            We will have to do regression testing and related issue fixes will be required to be done. This will be a bit time taking activity.
            As of now, we have not done any analysis related to issues for this feature hence do not have a fix ETA, but if you have any date that you expect this feature to be working please let us know. We will check if it is feasible for us too and update you accordingly.

            cc: Satya, Aditya Vishwakarma

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi Amanda B. Garvey , Apologies for delayed reply. This functionality was not in use and hence is not up to the mark. We will have to do regression testing and related issue fixes will be required to be done. This will be a bit time taking activity. As of now, we have not done any analysis related to issues for this feature hence do not have a fix ETA, but if you have any date that you expect this feature to be working please let us know. We will check if it is feasible for us too and update you accordingly. cc: Satya , Aditya Vishwakarma
            Hide
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment -

            This will get fixed upon fixing of WT-129

            Show
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment - This will get fixed upon fixing of WT-129
            Hide
            agarvey Amanda B. Garvey (Inactive) added a comment -

            I appreciate the update. Thank you.

            Amanda Garvey | Client Support
            Employee Benefit Specialists, Inc.
            PO Box 11657, Pleasanton, CA 94588
            PH: 925-469-2418 Ext 418| | FAX: 925-460-3920 | amanda.garvey@ebsbenefits.com<amanda.garvey@ebsbenefits.com>
            [Description: Description: Description: Description: Description: twitter]<http://twitter.com/#!/workterra> [Description: Description: Description: Description: Description: linkedin-tiny-square2] <http://www.linkedin.com/company/workterra> [Description: Description: Description: cid:image003.png@01CD3F49.3D5BC7C0] <http://www.facebook.com/workterra>

            Show
            agarvey Amanda B. Garvey (Inactive) added a comment - I appreciate the update. Thank you. Amanda Garvey | Client Support Employee Benefit Specialists, Inc. PO Box 11657, Pleasanton, CA 94588 PH: 925-469-2418 Ext 418| | FAX: 925-460-3920 | amanda.garvey@ebsbenefits.com< amanda.garvey@ebsbenefits.com > [Description: Description: Description: Description: Description: twitter] < http://twitter.com/#!/workterra > [Description: Description: Description: Description: Description: linkedin-tiny-square2] < http://www.linkedin.com/company/workterra > [Description: Description: Description: cid:image003.png@01CD3F49.3D5BC7C0] < http://www.facebook.com/workterra >
            Hide
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment -

            As discussed with Jaideep Vinchurkar assigning to Prasanna Karlekar

            Show
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment - As discussed with Jaideep Vinchurkar assigning to Prasanna Karlekar
            Hide
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            3C's:
            Concern: Standard Report for Multiple Locatons error
            Cause: It was throwing an exception due to table or fields not in respective company DB
            Correction: It seems that DB or table not available for company due to this exception occur while return list of reports for selected companies.

            Affetcted Areas: Global Reports

            Affected Files: WT-129 IN DEVELOPMENT modified files

            *Tested Scenarios: *
            1. Verified standard reports multiple companies selection so it is returning list of reports as expected.

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - 3C's: Concern : Standard Report for Multiple Locatons error Cause : It was throwing an exception due to table or fields not in respective company DB Correction : It seems that DB or table not available for company due to this exception occur while return list of reports for selected companies. Affetcted Areas : Global Reports Affected Files : WT-129 IN DEVELOPMENT modified files *Tested Scenarios: * 1. Verified standard reports multiple companies selection so it is returning list of reports as expected.
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Verified on LB.

            Issue : Not able to Save Global Report even though all fields are selected. Always displayed message like as 'Please Select One Report'

            Also, Report Displayed two time under selected criteria.

            CC - Sachin Hingole Prasanna Karlekar

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Verified on LB. Issue : Not able to Save Global Report even though all fields are selected. Always displayed message like as 'Please Select One Report' Also, Report Displayed two time under selected criteria. CC - Sachin Hingole Prasanna Karlekar
            Hide
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            Hi [~meghana joshi]

            Our changes not deployed properly in previous patch. Please verify it now

            CC- Prasanna Karlekar

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - Hi [~meghana joshi] Our changes not deployed properly in previous patch. Please verify it now CC- Prasanna Karlekar
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Verified on LB .
            Now, Reports are properly displayed on selection of companies.
            Will update testing status one's main enhancement testing WT-129 is completed on LB.

            CC - Sachin Hingole Prasanna Karlekar

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Verified on LB . Now, Reports are properly displayed on selection of companies. Will update testing status one's main enhancement testing WT-129 is completed on LB. CC - Sachin Hingole Prasanna Karlekar
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Ready for Stage

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Ready for Stage CC - Sachin Hingole
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Verified on Stage .
            Now, Reports are properly displayed on selection of companies.

            Will update testing status one's main enhancement testing WT-129 is completed on Stage.

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Verified on Stage . Now, Reports are properly displayed on selection of companies. Will update testing status one's main enhancement testing WT-129 is completed on Stage. CC - Sachin Hingole
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            As discussed with Prasanna Karlekar and [~parmeshwar.jumbade] , All Enhancement WT-129, WT-9377 and WT-9223 move at same time on Production. So, We will move all enhancement on 09/19/2017

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - As discussed with Prasanna Karlekar and [~parmeshwar.jumbade] , All Enhancement WT-129 , WT-9377 and WT-9223 move at same time on Production. So, We will move all enhancement on 09/19/2017 CC - Sachin Hingole
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Hi Amanda B. Garvey ,

            Verified above issues on Production.
            Working Fine

            Customization Screenshot :

            Kindly check at your side and close jira accordingly.

            CC - Sachin Hingole

            Thanks,
            [~meghana joshi]

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Hi Amanda B. Garvey , Verified above issues on Production. Working Fine Customization Screenshot : Kindly check at your side and close jira accordingly. CC - Sachin Hingole Thanks, [~meghana joshi]
            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -

            Amanda B. Garvey Please verify this issue and confirm.

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Amanda B. Garvey Please verify this issue and confirm.

              People

              Assignee:
              agarvey Amanda B. Garvey (Inactive)
              Reporter:
              agarvey Amanda B. Garvey (Inactive)
              Developer:
              Parmeshwar Jumbad (Inactive)
              QA:
              Meghana Joshi (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Pre-Prod Due Date:
                Production Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 5h Original Estimate - 5h
                  5h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 9.75h
                  9.75h