SSRS 2005 Web Farm Error : The Delivery Extension For This Subscription Could Not Be Loaded.
Jun 22, 2007
We are using RS2005 for a year now and never had any problems especially with mail subscriptions.
Since we transferred from single RS machine to web farm everything works ok except mail subscriptions. Subscription sometimes (?!?!?!?!) refuse to export report to a document of any kind. I repeat that this is a random thing which is more often with PDF and less with Web Archive or Excel. We are using shared schedules and on demand execution of AddEvent stored procedure by night batches to send mail to users. Also, original error from RS log says something that this kind of operation is not supported for server working in native mode. We don't have SharePoint so we never used it in any other way then native mode and it worked.
Any idea will be appreciated!
Thanks in advance.
Update 26.06.2007
It seems that problem is not loading dll used to export report to a file but loading email subscription extension (dll that needs to be loaded for execution of email subscription.)
Original error from RS Log:
w3wp!library!1!06/22/2007-11:06:43:: 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!1!06/22/2007-11:06:43:: 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)
at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)
at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.CreateExtensionObject(Extension extConfig).
I am having a problem with the e-mail delivery extension in MS SQL Reporting Services 2005. I have some reports that use an Oracle data source. When running the reports through Report Manager the data source works fine and the reports display properly. But when running an automatic e-mail delivery of the reports through a subscription I get the following error message (in the ReportServerService log file):
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
Doesn't this seem strange when the reports run in Report Manager but not when I send the reports through e-mail? I have Oracle Instant client v. 10.2.0.3 installed on the machine. I am wondering if the e-mail delivery extension has an account that needs privilegies to the oracle client home directory or something like that. Any ideas?
I have a report server set with an smtp account with Alias set to False but will not allow me to send e-mail outside the network. E-mail report delivery works fine to any e-mail with @mycompany.com but to an e-mail like @hotmail.com it gets rejected saying e-mail not recognized. I tried all config possibilities know to this man but nothing works. If long into the smtp server itself I can send e-mails outside of company. I'm thinking it may require a password from SSRS config but there is no place to put one. Any one know how to config SSRS to deliver e-mails to any and all e-mails accounts?
I'm trying to start the generic query designer and i get this error. I have no idea what is wrong, but I know I'm using Visual Studio 2005 V 8.050727.42 .net Framework 2.050727 SSRS Designers v 9:00.3042.00
I have installed the printer delivery sample and made the changes to the config files as described in the documentation but can only see it available as an option in the data driven subscriptions section. Anyone know how I can get it to show up in the standard subscriptions option?
I have written a custom rendering extension for my reporting services. In one of my function inside custom rendering assembly, I want to access the underlying dataset and manipulate with it. I gain some knowledge on dataextension but not able to use it successfully. Can someone please help me get to underlying dataset?
I am having a strange intermittent problem sending reports via e-mail subscription. The report will be delivered only 20-25% of the time. I have checked the SQL logs, SQL Agent logs, System, App and Secuirty logs and see nothing obvious.
I put a network monitor on the reporting box and looked at all SMTP traffic. What happens is the reporting server connects to the SMTP box, sends the From Address and gets an OK, sends the To Address and gets an Ok. Next the reporting server sends a RSET command to the SMTP and it closes the connection.
No e-mail sent, but reporting services/SQL agent indicate success. Here is a log of the
I am using Custom Data Processing Extension to call a stored procedure. Iam getting following error when creating a dataset in report designer using the extension. I wrote the code in c#.
could not update a list of fields for the query. verify that you can connect to the data source and that your query syntax is correct.(Details-Object reference not set to an instance of an object.)
Here is my code
using System; using System.Collections.Generic; using System.Text; using System.IO; using System.Data;
We have a new SSRS 2005 instance running with a number of reports. We have setup a subscription on one of these to run at 8am every Monday. However this is not working. No email is being sent and it does not appear the subscription is being run, nothing is ever written in the Last Run column.
I have looked in the logs and the only thing I can see is the following warning
w3wp!extensionfactory!5!13/02/2006-14:42:03:: w WARN: The extension Report Server Email does not have a LocalizedNameAttribute. w3wp!extensionfactory!5!13/02/2006-14:42:03:: w WARN: The extension Report Server FileShare does not have a LocalizedNameAttribute.
We had this working succesfully with SSRS 2000. The new instance was a clean install.
I have SSRS 2005 installed. User wants to change email address on subscription to send to external customer or others in our organization.
If I modify right "Manage individual subscriptions" to enabled for his security profile, the email address box is greyed-out.
I tried changing value <SendEmailToUserAlias>xxxx</ SendEmailToUserAlias> to FALSE in rsreportserver.config, with SSRS restart, but address box is greyed-out.
If I modify right "Manage all subscriptions" enabled for his security profile, the address box is not greyed-out, but can now see-edit everyone's subscriptions for that report.
How can I turn on address box is not greyed-out, but not open view of ALL subscriptions to my users?
I have an issue with a data driven subscription under SSRS 2008R2 in which users are emailed a message based on a condition. For the last two months the majority of the users were mailed the message successfully but this month two users failed to get their message. I checked the selected email address in our mail system and they seemed to be correct. But running these two address (unlike the others which ran sucssfully) caused an error and they did not receive their message. Â The error in the SSRS log read: Â Line 96485: library!ReportServer_0-81!b9c!05/29/2015-13:25:49:: Call to DeleteItemAction(|eju4fz45zsbn3sykjtpuegec|@|/XX/XXYYZZ/ Report Name123|). Line 96486: library!ReportServer_0-81!b9c!05/29/2015-13:25:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '|eju4fz45zsbn3sykjtpuegec|@|/XX/YYZZAA/ReportName123 |' cannot be found.;
is subscription using E-mail delivery possible in SSRS developer edition? act in the option for "Delivered By" in "New Subscription", only "Windows file share" is coming....
Using SSRS 2008R2 is it possible to change the file extension of a CSV data driven subscription? Â I'm outputting a text file with a .csv extension, but users have access to these files and I don;t want them opened with Excel and then saved back in an incorrect format.Â
These are the options I have from the report "manage" option. Â
It seems to me that if a scheduled SSRS report subscription fails ( Status Message - An error has occurred during report processing) , that I actually need to delete the subscription and reconfigure it from scratch. The scheduled job doesn't try to run again automatically (say the next Monday on a weekly Monday schedule).
Is there a way to "reset" a failed subscription without have to recreate the entire subscription?
I have been stuck with this problem since few days, need help regarding the same. I am enclosing the problem description and possible solutions that I have found.
Can anyone please help me out here?
Thanks and regards, Virat
Problem Description:
I have a requirement for which I have created a data driven subscription in SQL Server 2005, the whole thing works like this:
I have a report on Report Server which executes a stored procedure to get its parameters; then it calls another stored procedure to get data for the report; then it creates the report and copies it to a file share. This is done using data driven subscription and the time set for repeating this process is 5 minutes.
You can assume that following are working fine:
1. I have deployed the report on the Report Manager (Uploaded the report, created a data source, linked the report to data source) - manually, the report works fine.
2. Created a data driven subscription.
3. The data driven subscription calls a stored procedure, say GetReportParameters which returns all the parameters required for the report to execute.
4. The Report Manager executes the report by calling a stored procedure, say GetReportData with the parameters provided by GetReportParameters stored procedure; after it has generated the report file (PDF) is copied to a file share.
For each row that GetReportParameters stored procedure returns a report (PDF file) will be created and copied to file share.
Now, my question is
1. How to I get a notification that this file was successfully created or an error occurred? 2. The only message that reporting service shows on 'Report Manager > My Subscriptions' is something like "Done: 5 processed of 10 total; 2 errors." How do I find out which record was processed successfully and which ones resulted in an error?
Based on above results (success or failure), I have to perform further operations.
Solutions or Work around that I have found:
1. Create a windows service which will monitor the file share folder and look for the file name (each record has a unique file name) for the reports that were picked up for PDF creation. If the file is not found, this service will report an error. Now, there's a glitch there; if a report takes very long time to execute it will also be reported as error (i.e. when this service checks for the PDF file, the report was currently being generated). So, I can't go with this solution.
2. I have also looked at following tables on ReportServer database:
a. Catalog - information regarding all the reports, folders, data source information, etc. b. Subscriptions - all the subscriptions information. c. ExecutionLog - information regarding execution of the subscriptions and the also manual execution of reports. d. Notifications - information regarding the errors that occurred during subscription execution.
For this solution, I was thinking of doing a windows service which will monitor these tables and do further operations as required.
This looks like most feasible solution so far.
3. Third option is to look at DeliveryExtensions but in that case I will have to manually call SSRS APIs and will have to manage report invocation and subscription information. What is your opinion on this?
My environment details:
Windows XP SP2
SQL Server 2005
Reporting Services 2005
Please let me know if I am missing something somewhere...
suggested that this problem could be circumvented by getting the replication object early and then continuously using the same object for subsequent replications.
I did this and it works a lot better now but ever so often I get another error which is
Native Error 28559 SQL Mobile encountered problems when opening the database
My only option at this point is to stop and start the application which cures the problem.
I try to add an data extension who take the information to connect to the database in a config file. But It's could not retreive the values corresponding to the key.
I'm using the class ConfigurationManager from the namespace System.Configuration.
ConfigurationManager.AppSettings["QueryModel"]
Without the config file, the extension is working well.... I got the impression that reporting service and Visual Studio BI don't find the config file.
If someone can help me or have some advices. I will be pleased
I installed SSRS 2014 Reporting Services on a 2008R2 Enterprise server. When I try to subscribe to a report (also SQL 2014), the default rendering is MHTML. I want to change this default to EXCEL.
I updated the rsreportserver.config file and restarted SQL Server Reporting Service. Now, the default rendering for a subscription is 'XML file with report data' which is the first <Render> data element. If I change
<DefaultRenderingExtension>EXCEL</DefaultRenderingExtension> back to <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
And restart SSRS Service, the default subscription rendering is MHTML.
 <DeliveryUI>  <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider">     <DefaultDeliveryExtension>True</DefaultDeliveryExtension>     <Configuration>
I have a (for me) strange problem with subscribing reports.
I've setup several reports that I want to create monthly and store to a file share. In BIDS Preview and deployed to the report server everything works fine.
Each of my reports has an own schedule (they'll be created step by step), export format is Excel, as credentials I use a local user, all parameters are set porperly. When the time to render the reports has gone, I just see the following behind each subscription:
Failure writing file LIS04 : An internal error occurred on the report server. See the error log for more details.
The Log file contains the following: (I highlighted what I think to be the key error)
ReportingServicesService!library!4!12/19/2006-10:20:35:: i INFO: Call to RenderFirst( '/CM Reports/LIS04' ) ReportingServicesService!library!e!12/19/2006-10:20:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams ReportingServicesService!library!4!12/19/2006-10:21:22:: i INFO: Initializing SqlStreamingBufferSize to default value of '64640' Bytes because it was not specified in Server system properties. ReportingServicesService!library!4!12/19/2006-10:21:22:: i INFO: Initializing SnapshotCompression to 'SQL' as specified in Server system properties. ReportingServicesService!runningjobs!f!12/19/2006-10:21:37:: i INFO: Adding: 1 running jobs to the database ReportingServicesService!library!14!12/19/2006-10:21:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams ReportingServicesService!runningjobs!1a!12/19/2006-10:22:37:: i INFO: Adding: 1 running jobs to the database ReportingServicesService!library!19!12/19/2006-10:22:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams ReportingServicesService!runningjobs!1b!12/19/2006-10:23:37:: i INFO: Adding: 1 running jobs to the database ReportingServicesService!library!1c!12/19/2006-10:23:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams ReportingServicesService!runningjobs!3!12/19/2006-10:24:37:: i INFO: Adding: 1 running jobs to the database ReportingServicesService!library!17!12/19/2006-10:24:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams ReportingServicesService!runningjobs!17!12/19/2006-10:25:37:: i INFO: Adding: 1 running jobs to the database ReportingServicesService!library!3!12/19/2006-10:25:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams ReportingServicesService!runningjobs!16!12/19/2006-10:26:37:: i INFO: Adding: 1 running jobs to the database ReportingServicesService!library!19!12/19/2006-10:26:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams ReportingServicesService!runningjobs!18!12/19/2006-10:27:37:: i INFO: Adding: 1 running jobs to the database ReportingServicesService!library!13!12/19/2006-10:27:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams ReportingServicesService!runningjobs!d!12/19/2006-10:28:37:: i INFO: Adding: 1 running jobs to the database ReportingServicesService!library!1c!12/19/2006-10:28:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams ReportingServicesService!runningjobs!1c!12/19/2006-10:29:37:: i INFO: Adding: 1 running jobs to the database ReportingServicesService!library!14!12/19/2006-10:29:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams ReportingServicesService!runningjobs!13!12/19/2006-10:30:37:: i INFO: Adding: 1 running jobs to the database ReportingServicesService!library!15!12/19/2006-10:30:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams ReportingServicesService!runningjobs!1c!12/19/2006-10:31:37:: i INFO: Adding: 1 running jobs to the database ReportingServicesService!library!8!12/19/2006-10:31:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams ReportingServicesService!dbpolling!c!12/19/2006-10:32:10:: EventPolling processing 1 more items. 1 Total items in internal queue. ReportingServicesService!dbpolling!f!12/19/2006-10:32:10:: EventPolling processing item ea730ae6-d1ad-4535-b651-5bdfe4c0339f ReportingServicesService!library!f!12/19/2006-10:32:10:: Schedule 9587e9db-b005-4f96-ad18-4afc29207481 executed at 12/19/2006 10:32:10 AM. ReportingServicesService!schedule!f!12/19/2006-10:32:10:: Creating Time based subscription notification for subscription: 2ae5c0ed-9eea-4ca4-8e41-be5cde9f7908 ReportingServicesService!library!f!12/19/2006-10:32:10:: Schedule 9587e9db-b005-4f96-ad18-4afc29207481 execution completed at 12/19/2006 10:32:10 AM. ReportingServicesService!dbpolling!f!12/19/2006-10:32:10:: EventPolling finished processing item ea730ae6-d1ad-4535-b651-5bdfe4c0339f ReportingServicesService!dbpolling!c!12/19/2006-10:32:20:: NotificationPolling processing 1 more items. 2 Total items in internal queue. ReportingServicesService!dbpolling!13!12/19/2006-10:32:20:: NotificationPolling processing item b216a965-eaa7-4003-b776-4663c19c8d54 ReportingServicesService!library!13!12/19/2006-10:32:21:: i INFO: Call to RenderFirst( '/CM Reports/LIS04' ) ReportingServicesService!library!13!12/19/2006-10:32:21:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.OverflowException: Arithmetic operation resulted in an overflow. at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String userName) at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String userName, IntPtr userToken) at Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation) at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType catItemType, Byte[] secDesc, ReportOperation rptOper) at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc) at Microsoft.ReportingServices.Library.RSService._GetReportParameters(ClientRequest session, String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials) at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters) at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) --- End of inner exception stack trace --- ReportingServicesService!runningjobs!17!12/19/2006-10:32:37:: i INFO: Adding: 1 running jobs to the database ReportingServicesService!library!15!12/19/2006-10:32:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
WHen creating publciations under 2005 i saw a very interesting option under stament delivery, for inserts , updates , deletes there is an option that simply says insert/update/delete statement.
I could find very little in BOL about this under "Article Properties", is this what it soudns like ? FOr example if you say :
update Table set Cloumn = 'whatever', this will not trigger the update sp for each row at the subscriber , will it actually deliver the update statements and literally do the update/insert/delete statement at the subscriber?
while working on deployment to production server of an SSIS project, I have noticed that development priject has "disappeared" from my development machine which, obviously, was not my intention, at all. I now get the error prompt saying this:
what am I suppose to do in order to RESTORE it on devel machine like it used to be?
There are lots of subscriptions (for different reports) that are being sent out for users on a daily and weekly basis.
For the last few weeks, some of these subscriptions fail. It€™s not the same report subscriptions that fail each week. (Some subscriptions of few (different) reports fail each weekJ).
When we reschedule them, it goes out without any issues. Please let me know if you have ever faced such issues with SSRS report subscriptions. Please let me know if you would require more information.
I have created a subscription to dump my output file into a network share, however; when it runs I'm getting the following error in my log file:
ReportingServicesService!library!13a4!12/15/2006-10:25:09:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files, AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service account doesn't have rights to check domain user SIDs.
Can someone point me in the right direction on how to correct this. I'm assuming I have a permissions issue some where.
After performing a side-by-side instalation of SQL2005, I am not able to open Enterprise manager (for managing SQL2000 instance). It aborts with some errors related to mmc.exe not being able to use a couple of dlls: semsfc.dll and lmmc.dll. I've tried to unresgister/register them but I get the following error message:
semsfc.dll is loaded, but the dllRegisterServer entry point was not found... This file can not be registered .
I found a similar complaint in the VB forum, which recomended to use Reagasm but I couldn't understand it really, and I'm not sure if it applies to this SQL server issue.
I would like to set up a subscription that has two date parameters, I would like the end_date to be today and the start_date to be (today - 1 Month). The interface does not seem to support expressions?
I saw some documentation that said to use defaults in the report but that does not help because I may want multiple subscriptions with different params like 1 person may want (today - 2 months) as the start date ...
Some months ago, we migrated our SQL Server Reporting services server from Server 'Alpha' to server 'Bravo'. I thought we performed all of the steps needed to accomplish this task based on various Microsoft Articles that we identified. The fact that everything has been running fine (we thought) for the last several months confirmed our belief that everything was done.
Our problem found the other day is with a report 'Subscription'. The other day, a user called me and said their subscription is coming to them fine with the report displayed, but the link to re-run the report at the bottom of the e-mailed document doesn't work. I looked at the e-mail they received and found that the link had 'http://alpha/reportserver/...' instead of 'http://bravo/reportsserver/...'. Since 'Bravo' is the name of the new server, I new something was a miss. I tried creating a new subscription to a report and the result was the same 'http://alpha/reportserver/...' I've looked high and low in the SQL Reporting services configuration and can not figure out where I missed a change from 'Alpha' to 'Bravo'.
Has anyone seen anthing like this? If you can help me out it would be greatly appreciated. Thanks! - Eric-
