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

Global Level Standard Reports - Throws Server error on selecting all companies

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • 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
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have

      Description

      Issues :

      Randomly, Getting server error on selecting all companies for Global Level Standard Report [ Any Report Type ]

      ErrorID : 0
      ErrorSource : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->ReportDetails.GetData->ReportDetails.GetReportListByCompanyIds
      ErrorMessage: SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
      StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.GetData(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity)
      at WORKTERRA.ControllerAppTier.GetData(Int32 intProjectsId, String strInput)
      TargetSite: System.String GetData(ValueObjects.BenAdminControllerWebTierEntity)

      CC - Sachin Hingole Prasanna Karlekar

        Attachments

          Issue Links

            Activity

            Hide
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            3C's:

            Concern: Global Level Standard Reports - Throws Server error on selecting all companies
            Cause: Server name not considered before database name while form query. But on stage environment we have different companies database on different servers but it was trying to search database on same server.
            Correction: We have added server name while generate query so this will not throw exceptions now.

            Tested Scenarios:
            1. Select and deselect company functionality for multiple report type.

            Affected Files: This resolved under the main enhancement WT-129.

            Affected Areas: Global level reports.

            Note: Same issue will occur in case of any company is an active but database not available on mentioned server. Already discussed scenario with Ashwin Wankhede and according to them this case will handle at there side.

            CC: Prasanna Karlekar Sachin Hingole

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - 3C's : Concern : Global Level Standard Reports - Throws Server error on selecting all companies Cause : Server name not considered before database name while form query. But on stage environment we have different companies database on different servers but it was trying to search database on same server. Correction : We have added server name while generate query so this will not throw exceptions now. Tested Scenarios : 1. Select and deselect company functionality for multiple report type. Affected Files : This resolved under the main enhancement WT-129 . Affected Areas : Global level reports. Note : Same issue will occur in case of any company is an active but database not available on mentioned server. Already discussed scenario with Ashwin Wankhede and according to them this case will handle at there side. CC: Prasanna Karlekar Sachin Hingole
            Hide
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - - edited

            This is already deployed on stage along with WT-129. So need to check this on both environments (Stage/Production)

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - - edited This is already deployed on stage along with WT-129 . So need to check this on both environments (Stage/Production)
            Hide
            mahendra.mungase Mahendra Mungase (Inactive) added a comment -

            We have regressed this issue on Stage and observed that issue does not exist.Hence marking ready for production

            Show
            mahendra.mungase Mahendra Mungase (Inactive) added a comment - We have regressed this issue on Stage and observed that issue does not exist.Hence marking ready for production
            Hide
            mahendra.mungase Mahendra Mungase (Inactive) added a comment -

            We have regressed this issue on Production and observed that issue does not exist.Hence marking production complete.

            Show
            mahendra.mungase Mahendra Mungase (Inactive) added a comment - We have regressed this issue on Production and observed that issue does not exist.Hence marking production complete.

              People

              Assignee:
              mahendra.mungase Mahendra Mungase (Inactive)
              Reporter:
              meghana.joshi Meghana Joshi (Inactive)
              Developer:
              Parmeshwar Jumbad (Inactive)
              QA:
              Mahendra Mungase (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Production Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 1h
                  1h
                  Remaining:
                  Time Spent - 0.25h Remaining Estimate - 0.5h
                  0.5h
                  Logged:
                  Time Spent - 0.25h Remaining Estimate - 0.5h Time Not Required
                  0.25h