SQL reporting generates error rsDataExtensionNotFound

book

Article ID: 100018760

calendar_today

Updated On:

Description

Error Message

An error has occurred during report processing. (rsProcessingAborted)
An attempt has been made to use a data extension 'EVDataExtension' that is not registered for this report server. (rsDataExtensionNotFound)

Cause

This issue is caused because the SQL Server 2005 SSRS web.config file does not have the proper redirection setting for the Microsoft.ReportingServices.Interfaces dll.

This condition has been observed both after an upgrade of SSRS and after the application of the patch referenced here Microsoft Update Catalog.

Resolution

1. Open the ReportServer folder in the Microsoft SSRS installation folder.

2. Make a backup copy of the web.config file.

3. Open the web.config file for editing using a text editor.

4. Add the following subnode within the node:


 

 

 
publicKeyToken="89845dcd8080cc91"
 
culture="neutral" />
 

 
newVersion="9.0.242.0"/>
 

 


5. Save the changes to the web.config file.

Issue/Introduction

Attempting to generate Enterprise Vault (EV) reports on the SQL Server Reporting Server (SSRS) results in the following error.