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

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
Was this article helpful?
thumb_up
Yes
thumb_down
No