Enterprise Vault Reporting: Unable to generate any reports getting 'An error has occurred during report processing'

book

Article ID: 100033669

calendar_today

Updated On:

Description

Error Message

Reports stay in 'loading' for the defined timeout then fails with:

An error has occurred during report processing. (rsProcessingAborted)
  Query execution failed for dataset 'SiteListParameterDataSet'. (rsErrorExecutingCommand)

     For more information about this error navigate to the report server on the local server machine, or enable remote errors

User-added image

Cause

The aforementioned issue has been observed in environments where the ReportServer and ReportServerTemp databases reside on a SQL Server 2016 RTM CU2

The ReportingServicesService dtrace reveals that the SQL connection string contains double SQL Server name and EntepriseVaultDirectory:

Initial Catalog=EnterpriseVaultDirectory,EnterpriseVaultDirectory;Data Source=SQLCLUSTER,SQLCLUSTER; 

Resolution

This issue has been addressed in the following releases:

Enterprise Vault 12.1.3 Release
Enterprise Vault 12.2 Release

Issue/Introduction

Users are not able to generate Enterprise Vault reports. The reports begin to load, stay in a loading period for 1800 seconds (30 minutes) and then fail.

Additional Information

JIRA: SDIOCFT-87