Solved

Internal error occured on the report server

Posted on 2010-09-23
3
3,506 Views
Last Modified: 2012-05-10
Hi,

i am having some problems figuring out why i would be getting the following error on my SQL Reporting Server when trying to create a new subscription for any report:

"An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help For more information about this error navigate to the report server on the local server machine, or enable remote errors "

the environment is set up like this:

2 servers in total

Server A has only Microsoft SQL Server Reporting Services Version 9.00.4035.00 installed
Server B is a DB Engine server (SQL Server 2008 cluster) which hosts the reporting databases (among others).

everything works fine as far as im aware on the reporting server apart from the subscriptions.

in the SSRS log i can only see this error line:

w3wp!library!5!09/24/2010-10:51:04:: Call to GetPermissionsAction(/ConfigMgr/[ Tier 1 Reports ]/[ SCCM ] - List of all unknown servers).

w3wp!library!5!09/24/2010-10:51:04:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: The operation  is not supported on a report server that runs in native mode., ;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: The operation  is not supported on a report server that runs in native mode.

w3wp!extensionfactory!5!09/24/2010-10:51:04:: e ERROR: Exception caught instantiating Report Server DocumentLibrary report server extension: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Microsoft.ReportingServices.SharePoint.SharePointDeliveryExtension.DocumentLibraryProvider' threw an exception. ---> Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: The operation  is not supported on a report server that runs in native mode.
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)





In the Event Viewer there is the following error logged:

Source: Report Server
Category: Extension
Event ID: 108

Report Server (MSSQLSERVER) cannot load the Report Server DocumentLibrary extension.




Can anyone help out ?
 
0
Comment
Question by:kengo007
3 Comments
 
LVL 14

Accepted Solution

by:
wolfman007 earned 500 total points
ID: 33752251
Have a look at the following website it seems to have your error message

SSRS 2005 Web Farm Error : The delivery extension for this subscription could not be loaded
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/ead32a3e-ebde-4e3b-8a36-d2b2e023e187

You seem to be getting an error message about sharepoint delivery while running in native mode which does not make much sense.

The solution seems to be to comment out the offending extension in the rsreportserver.config file under your ReportServer installation folder

Always backup your rsreportserver.config file before making any changes to it.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 34662555
This question has been classified as abandoned and is being closed as part of the Cleanup Program.  See my comment at the end of the question for more details.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now