Additional migration steps for SupportCenter Plus
If your Analytics Plus is integrated with SupportCenter Plus then continue with the instructions below. The steps differ based on the database that your SupportCenter Plus runs on. Please choose the appropriate database.
PostgreSQL
1. Stop SupportCenter Plus service.
2. Navigate to <SupportCenter Plus_Home>\bin and run startDB.bat (sh startDB.sh for Linux) from command prompt or terminal in administrator mode.
3. Change the location to <SupportCenter Plus_Home>\pgsql\bin directory.
4. Run the following commands one by one
psql.exe -U postgres -p 65432
\c supportcenter;
update ServiceConfig set paramvalue='https://<hostname of new server>:<Analytics port>' where serviceparameter='reportsURL';
update ServiceConfig set paramvalue='https://<hostname of new server>:<Analytics Accounts port>' where serviceparameter='accountsURL';
\q
where <hostname of new server> is the hostname of the new Analytics Plus server and <Analytics port> is the port it runs on, in the new server and <Analytics Accounts port> is the Analytics Plus accounts port in the new server. The default values for these 2 ports are 8443 and 8200 respectively.
5. Open <SupportCenter Plus_Home>\zreports\uploadtool\conf\common_params.conf in WordPad as administrator.
6. Update the following entries with the new Analytics Plus server hostname.
- REPORT_SERVER_URL
- IAM_SERVER_URL
7. Start SupportCenter Plus service.
8. The updated values will be displayed on the Advanced Analytics configuration page.
9. Make sure you start your Analytics Plus service before re-syncing with SupportCenter Plus.
Microsoft SQL Server
1. Stop SupportCenter Plus service.
2. Execute the following queries directly on the SupportCenter Plus database using SQL management studio.
update ServiceConfig set paramvalue='https://<hostname of new server>:<Analytics port>' where serviceparameter='reportsURL';
update ServiceConfig set paramvalue='https://<hostname of new server>:<Analytics Accounts port>' where serviceparameter='accountsURL';
where <hostname of new server> is the hostname of the new Analytics Plus server and <Analytics port> is the port Analytics Plus runs on, in the new server and <Analytics Accounts port> is the Analytics Plus accounts port in the new server. The default values for these 2 ports are 8443 and 8200 respectively.
3. Open <SupportCenter Plus_Home>\zreports\uploadtool\conf\common_params.conf in WordPad as administrator.
4. Update the following entries with the new Analytics Plus server hostname.
- REPORT_SERVER_URL
- IAM_SERVER_URL
5. Start SupportCenter Plus service.
6. The updated values will be displayed on the Advanced Analytics configuration page.
7. Make sure you start your Analytics Plus service before re-syncing with SupportCenter Plus.