Failed to enable FSA Reporting for File Server target

book

Article ID: 100027268

calendar_today

Updated On:

Description

Error Message

Failed to enable FSA Reporting for file server 'fileserver.domain.local'.

Reason: Failed to save the data collection scheduling information.

No database changes will be saved.

 

Cause

An error is also shown on a DTrace output of the w3wp process:

87 15:57:53.511  [7464] (w3wp) <7720> EV-H {REPORTINGSERVER.EN_US} Exception: Retrieving the COM class factory for component with CLSID {4EC6FF78-C97A-11D1-90E0-0000F879BE6A} failed due to the following error: 8007007f. Info:Could not get reporting database for file server Diag:HRESULT: 8007007f Type:System.Runtime.InteropServices.COMException ST:   at KVS.EnterpriseVault.FSAReportingServerWebService.ReportingServer.GetFSAReportingDBAndUserForFileServer(String fileServerDNSName, String& dbServer, String& dbName, Int32& dbId, String& userName, String& domainName, String& pwd)
88 15:57:53.526  [7464] (w3wp) <7720> EV-H {REPORTINGSERVER.EN_US} Could not retrieve database information for file server fileserver.domain.local
 
 
When trying to reconfigure the Reporting Service using the Configuration Wizard the following alert is shown:

Reporting Configuration Utility is unable to copy file "C:\Program Files (x86)\Enterprise Vault\evreports\EVRT.dll" To "C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\Bin\EVRT.dll"

Please copy file manually after configuration ends.

 

The CLSID seen in the Dtrace output relates to the DLL file mentioned in alert when reconfiguring the Reporting Services. It means that the file cannot be found. Despite the fact that the file may exist in the target location.

 

Resolution

Firstly search the Registry on the EV server for the CLSID in question, if found it will point to the file location which means it's been loaded, if not, manually register the DLL with Regsvr32.exe.

Then, check the version of the DLL, if it can be found in the destination directory, and compare with the version in the EV installation directory .\EVReports folder. If the versions do not match, copy the DLL manually to the required location and restart the SQL Reporting services.

Reporting can then be enabled on the File Servers.

Note: If the FSA Reporting component has been installed on the EV server, instead of the SQL Server, the EVRT.dll would need to be copied to the corresponding folder path on the EV server,  i.e.  "C:\Program Files\Microsoft SQL Server\MSRS10_50.\Reporting Services\ReportServer\Bin\EVRT.dll". The EV server may need to be rebooted.
 

Warning: Incorrect use of the Windows registry editor may prevent the operating system from functioning properly. Great care should be taken when making changes to a Windows registry. Registry modifications should only be carried-out by persons experienced in the use of the registry editor application. It is recommended that a complete backup of the registry and workstation be made prior to making any registry changes.

 

 

 

Issue/Introduction

When attempting to enable Reporting on a File Server via the Vault Admin Console an error is returned
Powered by Wolken Software