Can not access the Enterprise Vault (EV) Data Analysis Reports and File System Archiving (FSA) Reporting has completed the initial scan

book

Article ID: 100001077

calendar_today

Updated On:

Description

Error Message

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'SiteID'. (rsErrorExecutingCommand)
For more information about this error navigate to the report server on the local server machine, or enable remote errors.

When a user attempts to view one of the EV Data Analysis Reports from the SQL Reporting Web Site, the above error is displayed.

Performing a Dtrace of the 'ReportingServicesService' on the SQL Reporting Server, the following line will highlight the issue:

 
{EVREPORTSQLEXCEPTION.EN_US} The following error has occurred while processing the report|SQLServer:SQLServerName,1443|Database:EnterpriseVaultFSAReporting|Authentication:Integrated Windows Authentication|Error:|System.Data.SqlClient.SqlError: Cannot open database "EnterpriseVaultFSAReporting" requested by the login. The login failed.|System.Data.SqlClient.SqlError: Login failed for user 'Domain\ReportingUsername'.|
 

Note: See Technical Article under Related Documents on performing Dtrace.

Cause

The above reference points to an issue with the given user 'Domain\ReportingUsername' not having the appropriate access to the 'EnterpriseVaultFSAReporting' database, which may occur if FSA Reporting was setup after Enterprise Vault Reporting was configured.

Resolution

Using the SQL Server Management Studio, perform the following:
 
  1. Expand 'Security' and 'Logins'
  2. Right-click the 'Domain\ReportingUsername' and choose 'Properties'
  3. Select 'User Mapping'
  4. Select the appropriate Database 'EnterpriseVaultFSAReporting'
  5. If the Database is not mapped to the user, select the check-box to Map the Database to the user
  6. Select the 'EVReportingRole'
  7. Select 'OK'

Retry the Data Analysis Reports from the SQL Reporting Web Site
 
 

 

Issue/Introduction

Can not access the Enterprise Vault (EV) Data Analysis Reports and File System Archiving (FSA) Reporting has completed the initial scan
Powered by Wolken Software