Setup of Reference Server

Introduction

The main server of r_keeper 7 system, or a root server, is the References server. It is launched first at system setup.

The References server executable file is REFSRV.EXE, the default config file name is RK7SRV.INI.

When RK7 is being installed from the distribution kit (the archive is at ftp in ftp.ucs.ru/versions folder), the RK7SRV.INI file needs to be copied from the \bin\win\ini\ folder into the \bin\win\ wording folder containing REFSRV.EXE.

If the software is being installed via the installer, the server with config file is located in [installation path\instance name\Rk7Reference] folder.

Licensing

If you need to view the reports, the References server should be licensed. License is associated with a full object code, a key code, and hardware components of the machine where the server is installed.

To license the References server:

1. Specify the corporation code in the parameters.
   1. Specify the Corporation code from the license system to the Enterprise code parameter. To do that, go to Options > Parameters > Installation and enter the number in the Integer field.
      
      
   2. The Object code from the license system should be specified in the restaurant properties.
      To do that, go to Service > Stations and Devices and select the required restaurant.
      
   3. Enter your object code in the Code field.
   4. Confirm and save the changes.
2. Enter Settings > OLAP reports > Reporting servers.
3. Select the References server, expand the «License information» properties group.
4. Select the protection key. The key can be either virtual or physical. The Guardant driver is necessary for licensing with the physical keys.
   Starting from versions 7.06.05.399, a virtual protection key is used by default.!

1. Generate license request (right-click on the server - Actions - Generate license request);
2. Generate the requested license on ucs.rusite; The objects shall have master license with RKeeper 7 Reporting server SW type.
3. Enter it into License key field;
4. Save changes.

References server licensing with virtual key

Fill the Servers restaurant field (mandatory). This must be a restaurant other than Head office.

Find more details on this type of licensing in Licensing system description article.

If your r_keeper version is below 7.06.05.399, specify the following parameter in rk7srv.ini prior to virtual key generation:

[REFSERVER]

UseNetChecking=1

And restart References server.

Launch

Before the server is launched, perform the following:

1. Modify RK7SRV.ini file: in [Refserver] section, specify server name (Server) and add UseSql parameter if not any:

Server = RK7SRV_3001 ; References server network ID

UseSql = 0 ; since there is no connection to external DB yet

See more detail on other rk7srv.ini file parameters below.

1. Run the server.

This application can be launched either as a separate service, or as an application.

Important: the first launch shall always be performed as an application (with /desktop parameter). Also, make sure to perform the launch as administrator.

Note: default application config file is rk7srv.ini. If References server needs to be launched with other ini file, use command: "refsrv.exe /ininame: newname.ini /desktop".

After server is launched as an application, icon will appear in Wndows task bar.

Depending on the task performed, the server icon can have three colors:

• green - normal server operation;
• yellow - data processing (loading, editing, cubes re-calculation, etc.), server is loaded;
• red - server is stopped.

Double click on the icon will open the Server information window.

To install server as a service, just double click Refsrv.exe file, and follow dialog instructions, or launch the server with /install parameter. After the service is installed, it needs to be launched.

Note that r_keeper_7 services should be launched from account with administrator rights.

Setup of connection to external DB

To have possibility to view cube reports in manager station, setup of connection to external SQL DB is necessary, as described in Setup of connection to MS SQL article

To configure interactive reports, see Setup of interactive reports plugin article.

Reports are generated from data collected from POS server only after common shift is closed at cash register station.

Note

The refsrv service often starts before MS SQL server, therefore, refsrv stops operation at startup phase with access to SQL DB error. This is solved by configuring the service dependencies. See more detail here: http://support.microsoft.com/kb/193888/ru.

References server settings description

To translate reference data:

1. In [REFSERVER] section, enter primary and alternative language file name.

[REFSERVER]

MainLang=.\RefSrv.DEU ; primary language

AltLang=.\ RefSrv.PLK ; alternative language

To translate primary language:

UpgradeTranslateRussian=0 ; 0 - translation from English, 1-translation from Russian

To translate alternative language:

UpgradeAltTranslateRussian=0 ; 0 - translation from English, 1-translation from Russian

UPGRADE.DEU2. With Langer.exe program (can be downloaded from our FTP), translate the files from /base folder

UPGRADEDEV.DEU
These files are created automatically after you perform paragraph 1 and update the progam.

Attention! To restore default settings for different drivers:

Go to base\drvlocalize and run Defparam.exe by selecting defparams.rus from the list (for versions below 7.5.2.269, see readme.txt in the same folder).

Default driver settings will be specified. This is particularly important for universal FR drivers.

 Partial update  Setup of connection to MS SQL