Symptoms

The Reporting Service installation succeeded. However, after installing Reporting Service only dbo.EventLog and dbo.DocumentEditingStatistic tables are getting populated with data.

Cause

There are several possible root causes of the issue:

1. ABBYY FlexiCapture ReportingResults service is not running.
2. The Data Access (Reading Service) component is missing.
3. Connection strings in the appsettings.json files do not match.
4. The TrustServerCertificate parameter is missing in the connection string.
5. Validation and decryption keys do not match with values from the Application Server machine.
6. The statistics need to be collected for the tenant, however, the dbo.Tenant record for the corresponding tenant is not set to "1".

Resolution

To install the Reporting Service properly and collect the data, it is necessary to fulfill all the following steps:

1. Verify that ABBYY FlexiCapture ReportingResults Service is up and running:
   1.1. Press the Windows key + R on your keyboard to open the Run dialog box.
   1.2. Type services.msc in the Run dialog box and press Enter or click OK.
   1.3. The Services window will open, displaying a list of all the services on your computer.
   1.4. Check if the ABBYY FlexiCapture ReportingResults service is in Running status
2. Install both Writing and Reading services if the statistics need to be collected for all the tables.
   In the latest version of Reporting Service data aggregation is performed in the background using the Data Access service. Therefore, now, when only Writing Service is installed, the data will be generated in the dbo.EventLog and dbo.DocumentEditingStatistic tables only.
3. Verify that both configuration appsettings.json files in the Reporting and Data Access folders contain the same connection string. To make sure that the connection strings are the same, please copy the connection string from the C:\inetpub\wwwroot\FlexiCapture12Reporting\appsettings.json to C:\inetpub\wwwroot\FlexiCapture12ReportingDataAccess\appsettings.json
4. Specify the correct connection string by including the TrustServerCertificate=yes parameter.
   The expected format of the connection string is as follows:

   "ConnectionString": "Data Source=Servername,Port(if custom is used);Initial Catalog=DatabaseName;User ID=Username;Password=Password(in either hashed or in a raw form);TrustServerCertificate=yes"

5. Copy the validation and decryption keys to the Data Access configuration file from the Application Server machine config file (C:\inetpub\wwwroot\FlexiCapture12\Server\web.config).
   

   Please note, if the NLB is present, the Application Server decryption keys will be the same.

6. To capture data for other tenants, additional modification need to be performed on the FlexiCapture 12 Database side. Open the dbo.Tenant and edit the Flags column by setting its value to '1' if the statistics data need to be collected for tenant.