Moving Scheduler /Webstatistica to new server

Products	Versions
Spotfire Statistica	12.7 and higher

Description

Right now Statistica enterprise, Webstatistica / Scheduler, Data Entry portal and SDMS all reside on the same servers, we want to move the Scheduler / Webstatistica to a separate standalone server. What are the steps to do this?

Resolution

Please note, there are steps (1 and 4) that can be relatively time consuming, depending on number of scheduled tasks. The scheduled tasks are scheduled as Windows Scheduled Tasks on the server and will need to be transferred.

Step 1
Log into WebStatistica as a user with SWS_ADMIN permissions, and review all currently scheduled tasks. Collect the following information for each task:

a. User configured to run the scheduled task.

b. Statistica Enterprise configuration scheduled to run (pretty sure they are not running any custom SVB).

c. Scheduled task scheduling info (when and repetition information).

Step 2

On the current Statistica server (that is running most everything):

a. Identify the functional user account running the WebStatistica service (if configured to use one for access to external resources).

i. Best way to determine this is to look at the Log On information for the WebStatistica service.

b. Identify the list of Windows users and groups who are members of the local SWS_... Windows user groups (ie. SWS_USER).

c. Identify the list of Windows user and groups and their access to the WSReports network file share on the server (this is the place where WebStatistica Reports are published if any used).

i. Typical location is “D:\WebStatisticaPub\wwwroot\WebSEWSS\WSReports”.

d. Identify the WebStatistica configuration options.

i. Open the WebStatistica admin console (typically “D:\Program Files\StatSoft\WebSTATISTICA\Console.msc”).

ii. Items in particular:

1. Connection->TCPIPPort (default is 8081, but often used by other apps so is usually reconfigured to 8082);

2. All “Email” options (smtpsender, smtphost);

3. Pooling options (Max/Min LL/SL – to determine the number of jobs queues available);

4. System->defaultdomainname (default is . which resolves the local server’s name as domain. Likely needs to be configured);

e. Schedule downtime of the WebStatistica/Scheduler service with users;

f. Stop the WebStatistica service;

g. Set the WebStatistica service as disabled (to prevent restart on reboot);

h. Browse into the Statistica license server application file location (typically “D:\Program Files (x86)\StatSoft\FlexLM”) and copy the “ClientSTAT.tmp” file to a known location (accessible to the new server).

Step 3
On the new WebStatistica/Scheduler server:

a. Copy Statistica server installation media onto a local hard drive.

b. Create a text file with the keys necessary to run the Statistica server installation.

c. Run the Statistica server installation process using the custom installation option.

i. In the list of components to install, only select the Statistica and WebStatistica components with sub components (not licensing, MAS, workstation installer, Live Score, …).

1. And recommend configuring path information so that they are not installed to the default operating system (C:) drive.

ii. You will be prompted for the client license file (ClientSTAT.tmp) (if you are not, then the licensing component was incorrectly selected … start again).

1. Provide the full path (directory only) to the ClientSTAT.tmp file (3.d. above).

d. Once the installation completed, setup the WebStatistica service and Statistica Job Server to run using the functional user account (same one as identified in step 3.a. above).

i. Make sure that the functional user account has full admin access to the new server.

ii. Stop the WebStatistica service.

iii. Edit the WebStatistica service Log On information to use this functional user account.

iv. Edit the Identity options for the “StatSoft WebSTATISTICA Job Server” DCOM application to use the functional user account.

1. Launch “DCOMCNFG”, expand “Component Services->Computers->My Computer->DCOM Config”, right click on the application, select Properties, click Identity tab, set option to This User, enter functional user account information, and click Apply.

v. Start the WebStatistica service.

1. Recommend opening the Windows Task Manager and confirming that the WebSTAT.exe and the multiple STATCF.exe processes are running using the functional user account.

e. Configure all of the local Windows SWS_... groups (ie. SWS_USER) to be the same as previous server (see step 2.b.).

f. Configure the WSReports network file share to have the same access permissions as previous server (see step 2.c.).

g. Configure the WebStatisica options to be the same as previous server (see step 2.d.).

i. Please note, Email->phphost will need to be set for new server name (if emailing options configured).

Step 4
Log into WebStatistica (using new server name) and reschedule jobs as identified in step 1.

Step 5
Notify users that WebStatistica/Scheduler service is back up.

Issue/Introduction

Moving Scheduler /Webstatistica to new server

Additional Information

Legacy Article ID: 212328

Welcome to "KB Articles"