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

PE: Parallel reporting server configuration

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Module:
      BenAdmin - Report
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 37 - Enhancement
    • Severity:
      Simple

      Description

      Need to provide 2 reporting servers on production servers.
      that can be configurable using simple steps .
      1. Can be configure 2 DB reporting services which will only rendering the reports.
      2.Simplicity for distributing companies load on either server.

        Attachments

          Issue Links

            Activity

            Hide
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment -

            Hello Satya

            I have ended up the coding part for this ticket on Friday.
            Today I will be doing unit testing for it by using the local and LB report DB as discussed with Nandkumar Prabhakar Karlekar. The updating of Report server name in DB using Add company functionality will be consider as separate enhancement under ticket WT-9412.This should be completed by 10- May 2017.

            I have also working on WT-8924 parallely as this ticket required client communication for testing at their end.

            Thanks

            Show
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment - Hello Satya I have ended up the coding part for this ticket on Friday. Today I will be doing unit testing for it by using the local and LB report DB as discussed with Nandkumar Prabhakar Karlekar . The updating of Report server name in DB using Add company functionality will be consider as separate enhancement under ticket WT-9412 .This should be completed by 10- May 2017. I have also working on WT-8924 parallely as this ticket required client communication for testing at their end. Thanks
            Hide
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment -

            Hello Satya

            Additional Item for TO DO when deploying to Environment:

            1) Need to update the ReportServerAddress column value on company table of OnlineEnrollment.

            Please let me know who is going to do the mentioned task

            Ashwin WankhedeNandkumar Prabhakar Karlekar

            Show
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment - Hello Satya Additional Item for TO DO when deploying to Environment: 1) Need to update the ReportServerAddress column value on company table of OnlineEnrollment. Please let me know who is going to do the mentioned task Ashwin Wankhede Nandkumar Prabhakar Karlekar
            Hide
            satyap Satya added a comment -

            Hi Ashwin,

            Please discuss with Aditya Vishwakarma to do report configuration on two servers at LB

            Regards,
            Satya Prakash

            Cc: shyam sharma Indraprakash Tiwari Nandkumar Prabhakar Karlekar

            Show
            satyap Satya added a comment - Hi Ashwin, Please discuss with Aditya Vishwakarma to do report configuration on two servers at LB Regards, Satya Prakash Cc: shyam sharma Indraprakash Tiwari Nandkumar Prabhakar Karlekar
            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi Aditya Vishwakarma,

            Forgot to mention this during our initial discussions.
            We will have to inform/check this change with Device team too. As reports are also executed from devices.
            Please discuss the changes done for Parallel Reporting Servers with Varsha and Sayali.

            cc: Satya, Nandkumar Prabhakar Karlekar, Varsha Shejawal, Sayali Doshi

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi Aditya Vishwakarma , Forgot to mention this during our initial discussions. We will have to inform/check this change with Device team too. As reports are also executed from devices. Please discuss the changes done for Parallel Reporting Servers with Varsha and Sayali. cc: Satya , Nandkumar Prabhakar Karlekar , Varsha Shejawal , Sayali Doshi
            Hide
            ashwin.wankhede Ashwin Wankhede (Inactive) added a comment -

            Hi Aditya Vishwakarma,

            Please let what settings you need to change, We can do it at Monday 22nd May 2017 morning.

            Show
            ashwin.wankhede Ashwin Wankhede (Inactive) added a comment - Hi Aditya Vishwakarma , Please let what settings you need to change, We can do it at Monday 22nd May 2017 morning.
            Hide
            ashwin.wankhede Ashwin Wankhede (Inactive) added a comment - - edited

            Hi Aditya Vishwakarma,

            I found 46 companies active on LB.
            Out of which i have mad 24's companies ReportServerAddress as 'WTDEVDBSERVER'
            and 22 companies ReportServerAddress as 'WORKTERRASQL'.

            Aditya Vishwakarma,

            Below are some queries,

            1. What if ReportServerAddress is NULL and company is active. [HSPL or dummy copies] ?
            2. What if if company is added through Add company / Clone Company feature?
            3. How entry is made when creating HSPL copies on stage and production?
            4. Do we need to recycle IIS when ReportServerAddress changed?

            Samir, Satya, shyam sharma, Vijay Siddha, Indraprakash Tiwari, Nandkumar Prabhakar Karlekar,Prasanna Karlekar

            Show
            ashwin.wankhede Ashwin Wankhede (Inactive) added a comment - - edited Hi Aditya Vishwakarma , I found 46 companies active on LB. Out of which i have mad 24's companies ReportServerAddress as 'WTDEVDBSERVER' and 22 companies ReportServerAddress as 'WORKTERRASQL'. Aditya Vishwakarma , Below are some queries, What if ReportServerAddress is NULL and company is active. [HSPL or dummy copies] ? What if if company is added through Add company / Clone Company feature? How entry is made when creating HSPL copies on stage and production? Do we need to recycle IIS when ReportServerAddress changed? Samir , Satya , shyam sharma , Vijay Siddha , Indraprakash Tiwari , Nandkumar Prabhakar Karlekar , Prasanna Karlekar
            Hide
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment - - edited

            Hello Ashwin Wankhede

            Please update 10.0.0.236 instead of WORKTERRASQL on LB DB as 10.0.0.236 is report server for LB.

            Below are the inline answers of your queries
            1) What if ReportServerAddress is NULL and company is active. [ HSPL or dummy copies] ?
            => The Report functionalitywill not able to process report. Impact is limited to Report processing only. We need to update the ReportServeraddress manually for that company.

            2) What if if company is added through Add company / Clone Company feature?
            => We have planned this as separate ticket for overcome this scenario.WT-9377

            3) How entry is made when creating HSPL copies on stage and production?
            => We need to modify the procedure and HSPL copy will hold the same address of Main company.

            4) Do we need to recycle IIS when ReportServerAddress changed?
            => No, Its not needed.

            Thanks

            cc: Samir Satya Vijay Siddha Prasanna Karlekar Indraprakash Tiwari Nandkumar Prabhakar Karlekar

            Show
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment - - edited Hello Ashwin Wankhede Please update 10.0.0.236 instead of WORKTERRASQL on LB DB as 10.0.0.236 is report server for LB. Below are the inline answers of your queries 1) What if ReportServerAddress is NULL and company is active. [ HSPL or dummy copies] ? => The Report functionalitywill not able to process report. Impact is limited to Report processing only. We need to update the ReportServeraddress manually for that company. 2) What if if company is added through Add company / Clone Company feature? => We have planned this as separate ticket for overcome this scenario. WT-9377 3) How entry is made when creating HSPL copies on stage and production? => We need to modify the procedure and HSPL copy will hold the same address of Main company. 4) Do we need to recycle IIS when ReportServerAddress changed? => No, Its not needed. Thanks cc: Samir Satya Vijay Siddha Prasanna Karlekar Indraprakash Tiwari Nandkumar Prabhakar Karlekar
            Hide
            ashwin.wankhede Ashwin Wankhede (Inactive) added a comment -

            Hi Aditya Vishwakarma,

            I have changed Reportserveraddress from WORKTERRASQL to WTREPORTINGSERV. .

            Show
            ashwin.wankhede Ashwin Wankhede (Inactive) added a comment - Hi Aditya Vishwakarma , I have changed Reportserveraddress from WORKTERRASQL to WTREPORTINGSERV. .
            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
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi Sachin Hingole],

            LB testing for this JIRA needs to be taken on priority.
            Code check in for WT-9441 cannot be done on stage as it refers some code part related to this enhancement.
            Apologies for assigning this at run time. Thought that this is LB verified as this enhancement got deployed on LB before 15th May 2017 but the JIRA was with Dev team and not assigned to any QA team member.

            Thank you!

            cc: Satya, Rakesh Roy

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi Sachin Hingole ], LB testing for this JIRA needs to be taken on priority. Code check in for WT-9441 cannot be done on stage as it refers some code part related to this enhancement. Apologies for assigning this at run time. Thought that this is LB verified as this enhancement got deployed on LB before 15th May 2017 but the JIRA was with Dev team and not assigned to any QA team member. Thank you! cc: Satya , Rakesh Roy
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Testing is not yet started due to other highest priority task NF - 2424

            CC - Sachin Hingole Rakesh Roy

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Testing is not yet started due to other highest priority task NF - 2424 CC - Sachin Hingole Rakesh Roy
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Started testing on LB.

            PFA Test scenarios doc Parallel reporting server configuration_Test Scenarios.xls for same.

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Started testing on LB. PFA Test scenarios doc Parallel reporting server configuration_Test Scenarios.xls for same. CC - Sachin Hingole
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Verified attached scenarios on LB.

            As discussed with Prasanna Karlekar , will verify schedule Report functionality on Stage.

            Rest are working fine.

            Will update testing status ones WT-9377 testing is completed on LB.

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Verified attached scenarios on LB. As discussed with Prasanna Karlekar , will verify schedule Report functionality on Stage. Rest are working fine. Will update testing status ones WT-9377 testing is completed on LB. CC - Sachin Hingole
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment - - edited

            Prasanna Karlekar

            Testing of Enhancement blocked due to WT-10049

            Cc - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - - edited Prasanna Karlekar Testing of Enhancement blocked due to WT-10049 Cc - Sachin Hingole
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            We need Parallel Reporting Servers configuration on Stage for testing WT- 9223 on Stage.

            So assign back to me ones configurtion are done from Dev side.

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - We need Parallel Reporting Servers configuration on Stage for testing WT- 9223 on Stage. So assign back to me ones configurtion are done from Dev side. CC - Sachin Hingole
            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi Vijay Siddha,

            Kindly update QA when required configuration is done in Stage environment.
            Also, please note that we will require multiple reports servers setup in Azure and Production environment too.

            cc: Satya, [~meghana joshi], Sachin Hingole

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi Vijay Siddha , Kindly update QA when required configuration is done in Stage environment. Also, please note that we will require multiple reports servers setup in Azure and Production environment too. cc: Satya , [~meghana joshi] , Sachin Hingole
            Hide
            mandark Mandar Kulkarni (Inactive) added a comment -

            Hi Prasanna Karlekar,
            This ticket was assigned to Vijay Siddha since long, could you please quickly review once and take it towards closure as appropriate? Thanks.

            -------------------------------------------------------------------
            CC: Vijay Siddha, Satya, Jaideep Vinchurkar

            Show
            mandark Mandar Kulkarni (Inactive) added a comment - Hi Prasanna Karlekar , This ticket was assigned to Vijay Siddha since long, could you please quickly review once and take it towards closure as appropriate? Thanks. ------------------------------------------------------------------- CC: Vijay Siddha , Satya , Jaideep Vinchurkar
            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi Satya,

            We had assigned this ticket to Vijay S. as we required parallel reporting servers in Stage / Azure / Production environment.

            Following is the update regarding same:
            Stage:
            Currently only one report server MORELLOSR. We were suggested to use MORELLO as another Report Server. We tried using it and reports are working on it. But it needs to be updated with RDL and Report Localization changes. We will try to work on this in coming week, 28-Aug-2017.

            Azure:
            Currently has only one Report Server. Another needs to be configured.

            Production:
            Recently, another report server was configured. Details in WT-10741. So this is done for Production environment.

            Assigning the JIRA to you as for Azure we will need another server.

            Thank you!

            cc: Vijay Siddha, Mandar Kulkarni, Gaurav Sodani, Vijayendra Shinde, Nandkumar Prabhakar Karlekar

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi Satya , We had assigned this ticket to Vijay S. as we required parallel reporting servers in Stage / Azure / Production environment. Following is the update regarding same: Stage: Currently only one report server MORELLOSR. We were suggested to use MORELLO as another Report Server. We tried using it and reports are working on it. But it needs to be updated with RDL and Report Localization changes. We will try to work on this in coming week, 28-Aug-2017. Azure: Currently has only one Report Server. Another needs to be configured. Production: Recently, another report server was configured. Details in WT-10741 . So this is done for Production environment. Assigning the JIRA to you as for Azure we will need another server. Thank you! cc: Vijay Siddha , Mandar Kulkarni , Gaurav Sodani , Vijayendra Shinde , Nandkumar Prabhakar Karlekar
            Hide
            satyap Satya added a comment -

            Yes Prasanna, That's fine.

            I will take it forward.

            Regards,
            Satya Prakash

            Show
            satyap Satya added a comment - Yes Prasanna, That's fine. I will take it forward. Regards, Satya Prakash
            Hide
            Raywill Raymond Williams (Inactive) added a comment -

            Good day All-

            Is there an update on this ticket?

            Show
            Raywill Raymond Williams (Inactive) added a comment - Good day All- Is there an update on this ticket?
            Hide
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            Sachin Hingole/[~meghana joshi],

            Today, we have uploaded latest RDL and localization files on new report server (i.e. MORELLO). Now you will be able to test all linked JIRA's related to this on stage environment. Please let us know which companies you are going to test on new report server so we can update report server address accordingly for the same companies.

            cc: Satya Prasanna Karlekar Gaurav Sodani Rakesh Roy

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - Sachin Hingole / [~meghana joshi] , Today, we have uploaded latest RDL and localization files on new report server (i.e. MORELLO). Now you will be able to test all linked JIRA's related to this on stage environment. Please let us know which companies you are going to test on new report server so we can update report server address accordingly for the same companies. cc: Satya Prasanna Karlekar Gaurav Sodani Rakesh Roy
            Hide
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            Hi Raymond Williams,

            We have created second report server for stage environment. This will move ahead once stage QA testing gets completed.

            cc: Prasanna Karlekar

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - Hi Raymond Williams , We have created second report server for stage environment. This will move ahead once stage QA testing gets completed. cc: Prasanna Karlekar
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Verified all the attached scenarios on Stage for different server companies and it is working Fine.

            As discussed with Prasanna Karlekar and [~parmeshwar.jumbade] , All Enhancement WT-129, WT-9377 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 - Verified all the attached scenarios on Stage for different server companies and it is working Fine. As discussed with Prasanna Karlekar and [~parmeshwar.jumbade] , All Enhancement WT-129 , WT-9377 move at same time on Production. So, We will move all enhancement on 09/19/2017 CC - Sachin Hingole
            Hide
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            Hi [~meghana joshi],

            Just now i have configured one company (i.e. GSRMA For HSPL given by you) to different new report server and rest of companies are on old report server. Please verify changes which are linked to this JIRA.

            CC: Prasanna Karlekar Sachin HingoleGaurav Sodani Satya Rakesh Roy

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - Hi [~meghana joshi] , Just now i have configured one company (i.e. GSRMA For HSPL given by you) to different new report server and rest of companies are on old report server. Please verify changes which are linked to this JIRA. CC: Prasanna Karlekar Sachin Hingole Gaurav Sodani Satya Rakesh Roy
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Verified Reports on two companies which are configured on different Server.
            Reports ( Scheduler and Manual Functionality ) are working properly.

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Verified Reports on two companies which are configured on different Server. Reports ( Scheduler and Manual Functionality ) are working properly. CC - Sachin Hingole

              People

              Assignee:
              meghana.joshi Meghana Joshi (Inactive)
              Reporter:
              nandkumar Nandkumar Prabhakar Karlekar (Inactive)
              Developer:
              Prasanna Karlekar (Inactive)
              QA:
              Meghana Joshi (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

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

                  Time Tracking

                  Estimated:
                  Original Estimate - 40h Original Estimate - 40h
                  40h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 94.5h
                  94.5h