Error Message

N/A.

 

This issue has been traced to Microsoft SQL Server Reporting Services 2017 not correctly parsing the Report properties, as acknowledged by the Microsoft SQL Product Group. Microsoft's Release notes for SQL Server Reporting Services (SSRS) 2017 and later article lists the issue as:

"Logic changed on stored procedure GetAllProperties in SSRS 2017 and PBIRS, which causes the Web service endpoint ReportingService2010.GetProperties method unable to get any data for linked report"

 

Microsoft has released the fix in SQL Server Reporting Services 2017 version 14.0.600.1274, made available on 2019-07-01. The most current SQL Server Reporting Services 2017 version can be downloaded here: https://www.microsoft.com/en-us/download/details.aspx?id=55252 . Once SQL Server Reporting Services 2017 has been upgraded to version 14.0.600.1274 or higher, the Accelerator Reports should work as expected. It is not required to re-upload the Report templates via the EVBAAdmin administration website.

 

 

When generating the built-in Reports in Enterprise Vault (EV) Compliance Accelerator (CA) and Discovery Accelerator (DA), the Report progress does not move past the Processing status. Refreshing the Accelerator Client cache has no effect. Switching to a different tab then back to the Reports tab causes the Report to not be seen in the list. A workaround to view the Report is to browse to the SQL Server Reporting Services Reports website, navigate through the Accelerator Customer and view the user's Report. As Reports access is browser-based, either open the browser as the Vault Service Account (VSA), which will allow access to all Reports run by all users, or add the user with rights to SQL Server Reporting, which will allow access to only the user's Reports. Alternately, a SQL Reporting Services administrator could access the ReportServer website, as listed below in the section 'To generate the report', and export the Report to provide to the user. To open a browser as the VSA: - Hold down the Shift key and right-click on the browser icon to show the option to Run as a different user.
- Select the Run as a different user option.
- Enter the VSA credentials and click OK. To add the user with rights to SQL Server Reporting: - Browse to the SQL Server Reporting Services Web Portal URL (administration site), typically http://<sql server name>/reports, with an account having permissions to edit the Reporting Services permissions, such as the VSA.
- Click on Manage Folder.
- Click on Add group or user.
- Add the user requiring access or a group containing the users requiring access under Group or user.
- Select the Browser Role.
- Click OK. To view the Report: - Browse to: http://<sql server name>/reportserver (replace <sql server name> with the name of the SQL Server Reporting Services 2017 server).
- Click on the appropriate Reports folder (Compliance Accelerator Reports or Discovery Accelerator Reports).
- Click on the Accelerator Customer.
- Click on the user.
- Click on the Report.

JIRA: CFT-1993 ETrack: 3980725 ETrack: 3961654