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

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

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

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

Hi Aditya Vishwakarma,

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

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

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

Hi Aditya Vishwakarma,

I have changed Reportserveraddress from WORKTERRASQL to WTREPORTINGSERV. .

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

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

CC - Sachin Hingole Rakesh Roy

Started testing on LB.

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

CC - Sachin Hingole

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

Prasanna Karlekar

Testing of Enhancement blocked due to WT-10049

Cc - Sachin Hingole

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

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

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

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

Yes Prasanna, That's fine.

I will take it forward.

Regards,
Satya Prakash

Good day All-

Is there an update on this ticket?

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

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

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

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

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

CC - Sachin Hingole