Solved

Internal error occured on the report server

Posted on 2010-09-23
3
3,649 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
In this article I will describe the Backup & Restore 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.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

742 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