Page History

...

1. Download the required installer version from FTP, f.ex. ftp://ftp.ucs.ru/rk7/versions/7_05_03/RK7_Setup_7.5.3.268.1.exe, and run it as administrator
2. The language selection, greeting, and license agreement terms are not described due to impracticability
3. Select New instance installation (if you use the installer for deletion purposes, select  One of the previously installed instances removal), then click Next
   
4. In the next window, select the directory, where the new instance will be installed, enter the name of the instance, and click Next. Any location can be used
   
   

5. Then, select the required components and click Next

   Info
   It is obligatory to select UCS CommonServer, Report function server, and Reports plugin. If Common Server has already been installed on the PC, you can use it.

   Also, pay attention to the RK7 Manager station item. When it is selected, a new manager station instance will be created with a configured plugin.
   If you selected this item, go to step 6, if not — to step 7.
   

6. Specify the Network name and port of the reference server, then click Next.
   

7. Specify the IP address of the report function server (IRReportsFSPrj.exe) and the port, to which the service will be physically, then click Next
   

   Info
   Important: the report function server port should be unique; it is also recommended to specify a port, different from 8888.

   

8. In the displayed window, enter the external IP address of the report function server (IRReportsFSPrj.exe) and the external port for IRReportsFSPrj configuration (required for feedback specification), then click Next
   
   

9. Specify the IP address and port for the new CS(CommonServer), then click Next

   Info
   Note: this event happens if you select UCS CommonServer during the installation.

   
   

   Image Modified
   
10. When using certificates, select them (optionally) and click Next
    
    
11. Select the logging level and click Next
    

    The plugin log file is created automatically in \bin\win\Logs\plugins\SchRepPluginClient\log\schRepPlugin.txt. The file location should not be changed.

    The FS server log file is created automatically in the *Logs\ directory of the FS server. The file location should not be changed.
    

12. Select the components that will operate as services and click Next

    Info
    It is recommended to launch servers as applications when run for the first time.

13. Enter the MS SQL server connection data and click Next
    
14. Enter the name of the cumulative SQL database and click Next
    The DB name can be checked in the External DB settings reference.
    
15. Select the applications, for which shortcuts on the desktop should be created, and click Next
    
16. Click Install to start the installation process
    
17. Click Finish to exit the installation program
    

18. After the launch, CS will be displayed in the list of services with the Running status. 
    
    
    If CS was installed as an application, you will see a window containing a successful launch notification and port information
    
    
    

    Info
    Important: when changing the FS version, the aggregates version does not always change, so aggregates may not be recalculated when switching to the new Feature version. It is also recommended not to delete aggregate DBs. If you transfer the DB to another server, you should transfer aggregate DBs as well, or downgrade the version of aggregates in the database (for test DBs only).

19. If you install the Feature Server as an application, you will see the following window upon its launch:
    

...

FS server configuration file

[FS_CONNECTION] section

ConnectTimeout=50000
ReceiveTimeout=50000
SendTimeout=50000
CommandTimeOut=50000
SessionTimeOut=50000

url=http://127.0.0.1:7777/soap/IStructuresInfo 
start_port=7777 
DB_Connect_Count=10 

[CS_CONNECTION] section

// address and port of the PC running the CS_Service 
url=http://127.0.0.1:7007/soap/UCSCommonWS 

[FS_TYPE] section

i_Guid={F4DED846-8913-4F1D-B5B5-5699CAC45DA9} 
instance_name=fsRK7_2    
MasterServer=1
connection_string=Provider=SQLNCLI11.1;Persist Security Info=True;Initial Catalog=rk7_5_3_Z;Data Source=127.0.0.1,1433 
MainLang=FeatureServPrj.rus 

[FS_MAILING] section

Mailing=0 

[RPL_PARAM] section

url =http://121.10.10.111:8892/soap/IStructuresInfo 
start_port = 8892 

[FS_AGREGATE] section

Agregate=1 
Count_shifts=10 
Time_between_recalc=0
Time_between_checking=10   
WaitConnectionInterval=5  

Parameters description

[FS_CONNECTION] section
Timeouts in seconds. In case of large databases (10 GB and larger), it is recommended to set high values (from 30,000 to 50,000).

...

In the upper menu, you will see the IR reports section with links to reports, and in the Extensions section — additional settings for IA reports.

Image Added

Configuring Reports for Restaurant Chain

...

If you need to display the data (IA reports) from point B  at  at point A, you should reconfigure the plugin at point A for FS at point B (line H in Figure below). Alternatively, you can reconfigure FS at point A for the DB at point B (change the SQL DB communication parameter in the FS INI file).

Image Modified

Hiding a restaurant from the report filter.

1. Protect the restaurant with a preset object privilege.
   
2. Disable those privileges for the role, the restaurants of which should be made inaccessible.
   
3. As a result, the role users will not see those restaurants, for which they do not have privileges. The method works for all preset interactive and web reports. !
4. This method might not work for custom reports. In this case, you need to adjust the value selection request for the the Restaurant parameter — parameter — just copy the request for the same parameter from any predefined report. To do this, open the report parameters and edit the SQL request.
   Image Added
5. For the parameter, you can create a list of values, from which the user will select the required ones by setting the relevant filter flag:
   Image Added
   This list is created via an SQL request in the parameter settings

...

2. In the parameter settings of the created report data set, specify the same request for the the Restaurant parameter, as in the data sets of the predefined reports for the same parameter. The request for the Restaurant parameter in predefined reports is intentionally configured in a manner considering the availability of restaurants to the user according to privileges.
   Image Added
   

Troubleshooting

Connection issues

• Error: You are not authorized

19.12.2019 17:22:01.743>

...

 [LOG]User entered incorrrectly    
19.12.2019 17:22:02.

...

080> [LOG]You are not authorized

...

   
19.12.2019 17:22:12.893> [LOG]After registration: code 2, Server re-registration
19.12.2019 17:22:28.217> [LOG]After registration: code 2, Server re-registration

Reason: In the Feature Server connection settings, no database user is specified.
Solution: Open the IRReportsFSPrj.ini file, and in the connection_string field, specify the correct connection string with a username and a password. ExampleFor example:

connection_string=Provider=SQLOLEDB.1;Password=1;Persist Security Info=True;User ID=sa;Initial Catalog=7171848;Data Source=127.0.0.1

• Error: Invalid PLG_EMPLOYEEROLES object name

Reason: Feature Server has not created the table PLG_EMPLOYEEROLES
Solution: Use the script attached to the article. Do not forget to specify your database name in the script.

Issues concerning SQL collation

"Possible Error: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Lithuanian_CI_AS" in the equal to operation".

As a result, some IA reports may become non-functional. As a solution, check

Solution: Check the sorting settings of the SQL server and the DB itself (Fig. 34see the figure below). After that, re-create the STAT aggregate databases.In order to re-create the aggregate DBs, proceed as follows:1.

1. Stop the

...

1. FeatureServer
2. Execute the following script in the main database: UPDATE [dbo].[DBInformation] set [DBVer]=0 where [Alias] = 'Agregates'

...

1. Delete all aggregate

...

1. databases (STAT)

...

1. Launch the

...

1. FeatureServer.

Fig. 35. Database properties — sorting parametersImage Added

Issues when importing the report from an XML file

If problems of such kind arise, the error may read as follows: "Possible Error: Could not find stored procedure 'RPL8_GET_CURRENT_DATABASE_GUID"
The issue problem is related to caused by the absence of certain tables and procedures. You should perform

Solution: Perform the following scripts:

USE [RK7]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RPL8_TRANSACT](
 [ID_INC] [int] IDENTITY(1,1) NOT NULL,
 [GUID] [uniqueidentifier] NOT NULL,
 [SERVER_GUID] [uniqueidentifier] NOT NULL,
 [DTS] [datetime] NULL
) ON [PRIMARY]
GO
CREATE PROCEDURE [dbo].[RPL8_GET_CURRENT_DATABASE_GUID] 
(@SRVGUID uniqueidentifier OUTPUT ) 
 AS BEGIN 
 SET @SRVGUID = NEWID() 
 END 
GO

...

 Configuring interactive reports  Device communication

...