Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

7. Enter it into the License key field.

8. Save changes.

References server licensing with virtual key

...

  • in the refsrv.ini file of the references server
  • in the manager station. In this case the setting from the INI file prevails over the value in the manager station.!

To turn this parameter on in the INI file, add the [CONFIG] section and specify the UsePasswordPolicy=1 parameter as shown bellow:

Code Block
[CONFIG]
UsePasswordPolicy=1

Image Added

Setup of connection to external DB

To have possibility make it possible to view cube OLAP reports in the manager station, setup of set up a connection to external SQL DB is necessary, as described in in the Setup of connection to MS SQL article article.

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

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

Info
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.

...

References server settings description

Parameter

Default value

Description

[REFSERVER]


General section

Server

TEST_RK7SRV

References server network name

UDBFILE

..\..\base\rk7.udb

Path A path to the References server database file. rk7.udb is a default name, it can be changed to any other name

ERRORLOG

refsrv.stk

Error log file name

MainLang

.\RefSrv.Rus

A full path to the primary language data translation file

AltLang

()

A full path to the alternative language data translation file

WorkModules

..\..\base\workmods

Path A path to working cash register module bases

WORKUDB

""

A full path to billing the receipts data file.

BLDCUBELOG

0

If the value is not 0, BLDCUBE.TXT cube construction log is maintained

ShortTimeout

20000

Max time of network operation execution over one element, ms

LongTimeout

100000

Max time of network operation execution over a collection, ms

NoTempMemStream

0

If 1 is set — intermediate data storage in memory is not used when cubes are being constructed. 1 is slower but can be useful in case of for work with very big data. Obsolete parameter. It Now it is now recommended to use "Source type" the «Source type» cube property.

UpgradeAnyTime

0

If 1 is set, the base version is not checked, and an upgrade attempt is always made when upgrade.udb file is detected

UpgradeTranslateRussian

0

If 1 is set, values configured in the primary language are translated from Russian rather than and not from English when a new base is being created. Upon After the new base creationwas created, languages cannot be changed anymore.

UpgradeAltTranslateRussian

1

If 1 is set, preset values in alternative language are translated from Russian rather than and not from English when a new base is being created

CubesRecalc

0

Disable cubes re-calculation, 1- enable cubes re-calculation, 2 - manual only cubes re-calculation for versions for versions 7.6.1.2 or higher higher.

NoReports

0

Disable the reports menu at manager station – for for versions 7.6.1.2 or higher

UnknownIdFormat(“Id=%d”)


Output The output format for info on the unfound element that was not found (in reports /or cubes). Element The element ID will substitute %d.

UseSQL

1

Connection ot SQLserver. 0 -off, 1 -on.

MaxCubeCalcs

2

Max number of cubes calculated in parallelsimultaneously. Makes sense Recommended to increase it for SQL if the server is multi-processor.

DisableSMARTVerify

1

Do not send SMART requests to IDE devices or their emulators thereof when the license is being generated.  Only Only for versions 7.4.17.31 or higher.  This This parameter is used for POS cash server license generation in multi-processor systems with the References server installed.

EventCachePath

C:\path\

Specify the path if you want the References server to store the latest changes in RefEvents.dat file. This will allow to send sending the whole collection rather than and not a limited list of changes. The parameter will only work if if PollEvents is is turned on at POS the cash server or the Reporting server

[REFEDIT]


For direct reports, ConnectionString parameters can be moved to INI file

Server

"IMxREPS1x0"

Server The server name

Client

"IMxMNGRx%RANDOM%"


SQLServerLink

"Provider

MS SQL connection string

[NETKERN]


Network protocol section. Possible options nbhdup: ofnbhdup.dll,spxsoc.dll

Protocols

tcpsoc.DLL

Full A full path to tcpsoc.DLL file

[TCPSOC]


TCP/IP section

PORT

3639

A server port for incoming connections

[CubeDLL]


CubeDLL.dll settings section. This section is supported starting from version from version 7.0.21.2

CommandTimeout

30

Time in seconds to execute SQL query for a cube

[Config]


If the References server also functions as the Reporting server, add this section to rk7srv.ini

UseShift2SQL

1

See more details on this parameter in the article on shifts upload via Shifts2sql

LoadThreadsCount

"4"

Upload data on closed shifts to the cumulative DB in parallel, "4" database simultaneously, «4» is the number of files processed in parallel simultaneously (recommended no in case of a big number of shift files incoming simultaneously). Version shall not be below be below 7.5.2.328

ErrorLogSize

1048576

Error log file size, bytes

To translate reference data:

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

...

names.

Code Block
[REFSERVER]

...



MainLang=.\RefSrv.DEU ; primary language

...



AltLang=.\ RefSrv.PLK ; alternative language

To translate primary language:

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

To translate alternative language:

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

2. UPGRADE.DEU2. With Using Langer.exe program 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 progamprogram.

Attention! To restore default settings for different drivers, do the following:

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 foscal register drivers. Partial update  Setup of connection to MS SQL