...
To install software from the distribution package (find the archive in ftp://ftp.ucs.ru/rk7/versions/7_05_03/STANDALONES/ folder), copy the REPSERV.INI file from \bin\win\ini\ folder to \bin\win\ working folder where rkReportServer.exe is located.
...
| Note |
|---|
| Licensing is necessary if the reports server is supposed to be used for data collection and cube reports generation. The license is bound to the full object code (9 digits) and the key code. Prior to licensing, the reports server needs to be created in the manager station, in the Options - OLAP reports - Reporting servers. |
Reports server licensing procedure is identical to references server licensing procedure described in the article on the References server.
Briefly, the procedure is as follows:
...
- Disconnect an external DB if there is a connection (External Data Base Link — empty, Cubes Source Type — switch to recalculation via disk file: UDB database (exchange via file)
- Save the changes
- Select the protection key in the License Information — Protection Key Actual Number field
- Generate license request: right-click on the reports server icon — Actions — Generate License Request
- Generate license for this request on the licensing system site, and specify it in the License Information — License Key field
- Save the chamgeschanges
- Configure the connection to an external DB if cube-based reports are required.
...
| Info |
|---|
| The default server config file is repserv.ini. If the reports server needs to be launched with other another INI file, use the following command: rkReportServer.exe /ininame: newname.ini /desktop. |
...
Copy the repserv.ini file from the RK7/BIN/WIN/ini folder if you have not done this before, and place it beside the RKREPORTSSERVER.EXE file, i. e., into the RK7/BIN/WIN/ folder.
| Code Block | ||
|---|---|---|
| ||
[CONFIG] Client = "REPSRV3001" ;; the reportsreport server network name, same as the corresponding reportsreport server in the managementmanager station. See "Manager station settings" belowRefServerbelow RefServer = "RK7SRV_3001" ;; the references ;; the references server network name (or the upper reportsreport server) RefsBasePath = ".\BaseData\refsdata.udb" ;; a full path to the referencesreference base, do not confuse with rk7.udbCheckBasePathudb CheckBasePath = ".\BaseData\check_db.udb" ;; a full path to the receipt base, do not confuse with check.udbWorkModsFileudb WorkModsFile = ".\BaseData\wmodules.udb" ;; a a full path to the working modules baseReceivedPathbase ReceivedPath = ".\Received\" ;; a path to the data receiving folderErrorLog = "repsserv.stk" ;; a logpath fileto namethe (adddata thereceiving pathfolder ErrorLog if= necessary)"repsserv.stk" By default, the log file is saved in the same folder where RKREPORTSSERVER.exe is placedErrorLogSize = 1048576 ;; an error log size in bytesOldRefsSyncMode = 0 ;; 1 - enable old synchronization mode, necessary if PollEvents=1PollEvents = 0 ;; enable periodic references server polling mode (in the references server .ini file, fill EventCachePath= parameter), and set OldRefsSyncMode=1RecalcAllCubesAt = 2015 ;; Time is specified without semicolon in HHMM format. Recalculate all cubes that would be recalculated by "recalculate all cubes" item at the manager station at 20:15. For versions 7.4.20.60 or higher.CubesRecalc = 0 ;; disable cubes recalculation, 1- enable cubes recalculation, 2 - only manual cubes recalculation (For versions7.6.1.2 or higher!)NoReports = 0 ;; disabling menu with manager station reports (For versions 7.6.1.2 or higher!)ServPingTimeout = 5000 ;; 7.4.17.78 or higherUseSql = 1 ;; a log file name (add a path if necessary). By default, a log file is saved in the same folder where RKREPORTSSERVER.exe is placed ErrorLogSize = 1048576 ;; error log size in bytes OldRefsSyncMode = 0 ;; 1 - enable old synchronization mode, necessary if PollEvents=1 PollEvents = 0 ;; enable periodic references server polling mode (in the references server .ini file, fill in the EventCachePath= parameter), and set OldRefsSyncMode=1 RecalcAllCubesAt = 2015 ;; Time is specified without semicolon in "HHMM" format. Recalculate all cubes that would be recalculated by the "recalculate all cubes" item at the manager station at 20:15. For versions 7.4.20.60 or higher. CubesRecalc = 0 ;; disable cubes recalculation, 1- enable cubes recalculation, 2 - only manual cubes recalculation (For versions7.6.1.2 or higher!) NoReports = 0 ;; disabling menu with manager station reports (For versions 7.6.1.2 or higher!) ServPingTimeout = 5000 ;; 7.4.17.78 or higher UseSql = 1 ;; 0 - if there is no connection to SQL, 1 - if connection to SQL is usedLoadThreadsCountused LoadThreadsCount = 4 ;; load closed shifts data to the cumulative DB simultaneously, "4" - a number of files processed simultaneously (recommended in case of the big number of shift files beingarriving receivedin simultaneouslyparallel). Version shall be higher thanFor versions 7.5.2.328 or higher!! cubesBuildTool = "bldcubex.exe" ;; Enable bldcubex.exe utility for cubes generation at PC with with 22+ GB memory (For versions7.6.2 or2 or higher!) [NETKERN] Protocols = tcpsoc.dll ;; protocols list (comma separated), you must make sure these DLL files are placed in the folder with the RKREPORTSSERVER.exe file [TCPSOC] PORT=3639 ;; a port for the server [TCPDNS] RK7SRV_3001=subway.rkeeper.com:3648;; REP_CENTR4=subway.rkeeper.com:3644;; RK7SRV=subway.rkeeper.com:3639 [UPDATE] NoUpdate=0 ; scheduler. only for for 77.5.2.502+ [SYNCCONF]; Enable scheduled synchronizationRefsSyncModesynchronization RefsSyncMode=1; synchronization time in CRON format 50 10 * * * is equivalent to "always at 10:50", 45 13 * * * is equivalent to "always at 13:45". Format is as follows: * * * * * | | | | | | | | | +----- Days of week (range: 1 1-7) | | | +------- Months (range: 1 1-12) | | +--------- Days of month (range: 1 1-31) | +----------- Hours (range: 0 0-23) +------------- Minutes (range: 0 0-59) SyncSchedule=50 10 50 10 * * * ;; synchronize references at reportsreport server loadingSyncOnReloadloading SyncOnReload=0 |
Reports Server Update
Right-click the icon to open the reports server in a browser. Default HTTP port can be set in the manager station by specifying a new port in reports server properties (HTTP Server group -> HTTP Data Port group).
...
The reports server update is identical to the references server update.
| Note |
|---|
| The report server must be restarted after its update, |
...
- Create a separate instance of the manager station with a new INI file and specify the reports server network ID in the [REFEDIT] section therein.
- Server= REPSRV3001 ;; Your reports server name
- Client=MANST-%RANDOM% ;; the name of the manager station that will be connected to the reports server.
Therefore, there will be two icons for RK7MAN.exe on the desktop - one for connection to the reports server and references editing, another for connection to the reports server and reports viewing.
- Launch the manager station again, leaving the INI file unchanged. When the logging window appears, press Ctrl+Alt+S on the keyboard and enter the reports server ID in the poll in the bottom left corner.
...
Create 2 restaurants and a cash server for each of them.
External DB settings
Create 3 settings as described in described in the article on connection to MS SQL, and configure the connection to corresponding reports servers (shall be created additionally). !
This shall result in 3 configurations:
- for For Head office (‘reports_HO’ database);
- for For restaurant 1 (‘reports_rest1’ database);
...
- For restaurant 2 (‘reports_rest2’ database).
...
2.5. reports server properties
...
Reports Server Properties
| Info |
|---|
| Do not forget to acquire 3 licenses for 3 reports servers. |
...
INI files
For reports server 1:
| Code Block |
|---|
[CONFIG] |
...
Client = |
...
"repsrv_1" |
...
RefServer = |
...
"RK7SRV_3001" |
...
RefsBasePath = |
...
".\BaseData1\refsdata.udb" |
...
CheckBasePath = |
...
".\BaseData1\check_db.udb" |
...
ReceivedPath = ".\Received1\" |
...
ErrorLog = |
...
"repsserv1.stk" |
...
[NETKERN] |
...
Protocols = tcpsoc.dll |
For reports server 2:
| Code Block |
|---|
[CONFIG] |
...
Client = |
...
"repsrv_2" |
...
RefServer = |
...
"RK7SRV_3001" |
...
RefsBasePath = |
...
".\BaseData2\refsdata.udb" |
...
CheckBasePath = |
...
".\BaseData2\check_db.udb" |
...
ReceivedPath = ".\Received2\" |
...
ErrorLog = |
...
"repsserv2.stk" |
...
[NETKERN] |
...
Protocols = tcpsoc.dll |
Manager The manager station connected to the references server (refserver):
| Code Block |
|---|
[REFEDIT] |
...
Server=RK7SRV_3001 |
...
Client=rk7man_ref |
Manager The manager station connected to reports server 1:
| Code Block |
|---|
[REFEDIT] |
...
Server=repsrv_1 //network name of reports server 1 |
...
Client=rk7man_rep1 |
Manager station connected to reports server 2:
| Code Block |
|---|
[REFEDIT] |
...
Server=repsrv_ |
...
2 //network name of reports server 2 |
...
Client=rk7man_rep2 |
...
Employees and their rights
...
Add 2 employee groups:*
- for reports server 1
...
- for reports server 2
Configure their right in properties:*
- give all rights to view reports
...
- manager restrictions --> reports servers
...
- --> mark corresponding reports server
Set the following in employee properties:* general
- main --
...
- > current restaurant
...
- main --
...
- > account --
...
- > login and password
Using
...
Valid SSL
...
Certificates for
...
Reports Server in Domain
The default Default certificate (for rk7.local) is placed in the BaseData\httpKeys\ folder, the default.pem file.
To use your own certificate, rename it (own certificate) change its name to mylocal.pem, and place it into the same catalogdirectory, then restart the reports server.
Certificate properties:
- Subj name – restaurant DNS name
- Alternative An alternative name is not needed
- Certificate A certificate shall support server authentication.
- Key type – exchange or signature (default value is exchange). Exchange is a data encryption certificate.key
- Key A key size of 2048 is supported.
- sha256 algorithm and sha256RSA hash algorithm are supported.
- Key export is possible. Certificate The certificate itself shall be in PEM format. Server The server key shall be located there as well. See example in default .pem file.
- No restrictions on crypto provider usage.
| Note |
|---|
Please, note |
...
: an attempt to use a wildcard certificate for FQDN machine with custom port and *.DomainName.local:8080 template failed. *.DomainName.local template worked. |
Troubleshooting
- "The error occurring while viewing a report: Cannot load cube data (cube data is empty or corrupted): Cannot open file "D:\UCS\RK7_5_1_34\bin\win\Cubes\00000022.blb". File not found". (see figure below)
Solution:
...
- Find a cube corresponding to the report and recalculate it
...
- .
- In In Windows 7 and higher OS, when report generation is attempted at the manager station, "the following error may occur: CubeDLL: Error reading Grid -> LICENSE_STR: Failed to set data for" error occurs. " The CubeDLL: " error occurs in while viewing the course of viewing corresponding cube.
Solution: Assign administrator rights to the Windows 7 user or run the manager station as administrator.
...
- Disable account control
...
- .
- The error occurring during report generation: "Item 0 was not found in external base config collection"error occurs during report generation.
Reason:
...
- this happens if the role has no connection to SQL
...
- , and the user attempts to run an existing report or to create a new
...
- one, generated via FR4 directly from SQL.
...
- Connections limit exceeded.
Reason
...
- : the pre-installed reports server is licensed in RK7, and you are trying to create one more reports server.
...
- Solution: reset the license data of an extra reports server, and create
...
- the "Setup of connection to external DB"empty string.
- If the following user login failure error occurs while implementing an internal or external base on your computer:
check correctness of filling on your computer, go to Options > OLAP Reports > Reporting Servers and check if the following lines are filled correctly:
Reason: When "Connection to external DB" the External Data Base Link block is filled, "the Reference logs" Logs block is filled automatically.
Solution: SQL username and password shall be the same in "Connection to external DB" and "Reference logs" blocks
Installation of cash register station on Linux Setup of service print
the External Data Base Link and Reference Logs blocks.