We've got a lot of user subscriptions that need to be re-run (data was bad on the initial run). Is there anyway to do this programatically or behind the scenes? We're looking for a way to avoid going into each subscrption and re-running.
Thanks.
Greetings,
We periodically get the following message in our three server peer-to-peer transactional replication environment:
"One or more subscriptions have been marked inactive. Drop and re-create all subscriptions for this node that are failing with this error."
What causes a subscription to be marked inactive? What properties or settings can be adjusted to minimize or eliminate this occurrence?
Everthing seems to be running OK and then we get the message. It afflicts the higest change volume publication on our slowest overseas server.
Thanks,
BCB
I doubt this is possible, but can someone think of a way to change the email address used for sending report subscriptions based on the report or subscription?
It's a need that I've heard from a number of different clients. Scenario: a company has one reporting services server with reports running from numerous departments. Report subscriptions are sent to internal and external email addresses and there's a business need to use different "from" addresses based on the report (or audience).
We are running Reporting Services on an Application server, side by side with a web application. The server exists outside our corporate domain due to the fact that our external vendors need access to the application (not the reports). Our web app uses a third party mail system to funnel the application email thru our corporate exchange server. Since Reporting Services is not connected to our domain, it can not authenticate to send reports via e-mail subscriptions. I am looking for alternatives to make this work from outside the domain.
View 7 Replies View RelatedHi all,
I have created data drvien subscriptions in Report Manager (rs 2005). When the reports are run in Report Manager they give a status ie 5 processed of 5 Total-2 errors. Is it possible to find out what these errors are as no indication is given?
Thanks in advance
I am getting continuous errors in publisher/distributor server
Background: Transactional replication (Push) with one publication (above 30 articles (tables)) and 1 subscriber. Publisher/Distributor is 2008r2 SP2 & Subscriber is 2008r2 sp1
Current Problem:
Repl-Distribution
Message
Replication-Replication Distribution Subsystem: agent PubServername-Production-ProductionReplication-Subscriberservername scheduled for retry (One of the replication job). Query timeout expired.
When I open the replication monitor..In the first tab it is showing performance excellent but when I double click on the publiscation, it is showing errors under distributor to subscriber tab and there are some undistributed commands 5873507, estimated time to apply these commands, based on last performance is 1:06:05:05
Question 1: Do I need to reinitialize the subscriptions? How to find out the problem what went wrong with replication
Question 2: If I want to do any schema changes @publisher do I need to stop the log reader agent and start after the deployment? In my case both publisher/distributor are on the same server (Transactional Replication)
I subscribed to many topics in this site and I though I didn't receive any email when a topic I wrote was updated.
Shimi
HiWe are having major problems getting reporting services subscriptionsto work. We have the following setup:Windows 2K Server with Service Pack 4 InstalledSQL Server 2000 with Service Pack 3 InstalledSQL Server Reporting Services with Service Pack 1 Installed.Everytime the system tries to deliver a report via file share or email,we get the following error in Windows Events:The procedure entry point I_RPCExceptionFilter could not be located inthe dynamic link library RPCRT4.dll.We have tried re-installing Service Pack 4 and also re-installingreporting services on a new server to try and resolve the problem butencounter exactly the same issue.Any help on this would be hugely appreciated as we are coming to theend of our ideas!!Thanks very muchDave
View 1 Replies View RelatedI just installed SQLExpress, with reporting services on my own laptop
However, when I go to http://localhost/Reports/, I can see my reports uploaded, but the subscription links are not available. In Properties, I cannot see "Execution" either.
Can someone help me to get the Subscriptions feature enable again?
Thanks,
John W
Attempting to run any kind of subscription, we are receiving no error message, but not reports either
I think this maybe relatd to a system account used in setup being removed? does this sounds reasonable even though old subscriptions are stil working?
i have looked in the rsreportconfig file but the account is encrypted, how can i change this?
Hi,
I have generated a report and uploaded that report to reporting services. It works fine. I have created a subscription for the same report and scheduled the job to run the report. The report is not running.
I have tried the same report in different server and it works there.
I have sql server 2000 and sql server 2005 installed in the same server. I am using sql server 2000 reporting services but 2005 database. Will that creates a problem?
Can anyone please help me in this.
Thanks,
Priya
Per BOL, I can assign the following task to a role, and if I give role to SSRS user, they can see ALL SUBSCRIPTIONS. If so, WHERE do they see the ALL SUBSCRIPTIONS? Will they show when selecting MY SUBSCRIPTIONS, or some other way?
{{Manage all subscriptions: View, modify, and delete any subscription regardless of who owns the subscription. }}
I am full rights admin on the box, and yet to find way to see ALL SUBSCRIPTIONS as well.
Hi,
I have a problem on Report Manager none of my subscriptions are triggered. They were working fine until Friday but none of them are fired today. I tested
writing to file share also but the subscription I created to write to file share was not fired. I checked with log files but could not find any errors regarding the subscriptions. Can you please help me on this?
Thanks in Advance.
At the moment, the only way (that I know of) to test a subscription seems to be to schedule it a few minutes ahead in time and wait for it to happen. Dies nayone know if there are plans for and "Execute" or "tTst" button? It would be nice to have one.
View 1 Replies View Related
Help! After searching through the forums and the web in general, I cannot find a reference to this problem. On a new SBS 2003 R2 server, with a clean install of SQL Server and reporting services, I have reporting working fine except that the reports have no Subscriptions tab visible. Also when I go to "Site Settings" and "Manage Shared Schedules", I get an error:
"The feature: "Scheduled report execution" is not supported in this edition of Reporting Services. (rsOperationNotSupported)
Interrogating the SQL Server, I find that the edition is reporting as Workgroup, which should have scheduled report execution.
Please help as this is a big problem for this server deployment.
Thanks
Shane Michelon
I am calling the CreateReportHistorySnapshot command to create my snapshot report of a linked report.
What is not happening is the subscriptions that I have made for the linked report is not firing off.
Hi There
I need to get rid of all subscriptions (including cleaning up all associated sql jobs) for RS 2000 and 2005.
We have hundreds of reports , going through them 1 by 1 is not an option.
When i look at the system tables, i join Subscription to Catalog, but i find reports with subscriptions in the system tables but when i go to Report Manger there is no subscription for the report.
In a nutshell , how can i see all valid subscription for all reports in RS, how can i delete all of them and make sur eall sql jobs associated etc are deleted.???
Thanx
Where in the backend database can I find who a subscription was sent to? I know in the report server database the subscripitons table has a description and last status field, but these fields are cutting names off when the list is large. Is there any other place where this information is stored?
Nancy
We're new to SQL Reporting Services and have a new SQL 2005 server.
I'm having a problem activating scubscriptions.
- "New Subscription" is greyed out in Server Management Studio.
- Subscribing via the browser, even as the Content Manager, allows you to fill in the form for the subscription but then reports the following error;
"The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting)"
Any suggestions?
Found the problem.
When configuring the Data Source the "Impersonate the authenticated user after a connection has been made to the data source" button should be off.
I'm working with SQL Server 2005 Developer Edition and am trying to set up a new subscription to a database I created using Management Studio. In the step where you are prompted to choose the Subscriber Type I only have two options: SQL Server 2000 and SQL Server CE.
Why don't I have the options to choose SQL Server 2005 and SQL Mobile 2005?
Hello,
I have a dril lthrough report which takes a long time (5-7 minutes) to fetch the results. The reason is that the data it returns is huge as it fetches sales data till the lowest level.
when the users later on trz to export it to excel it takes again a lot of time and eventuallz the szstem freezes. I think the volume of export might be in the range of 14/15 MB.
Is there a way to reduce first the execution speed of the report and then secondly reduce the time to export the report?
Or a way where the report is executed once a day and everyone shares the already published report?
regards
Josh
Hi,
I'm trying to setup a subscription on a SSRS report and get the following error message:
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.
I've followed the advice given in this post but still get the same result.
The SQLAgent service is running under a domain account and the Reporting Services service running under a local account. Both these accounts are assigned to the RSExec Role in the master, msdb, ReportServer and ReportServerTempDB databases. This role has execute permissions set as per the above link.
I'm now at a loss as to what else the problem could be?
All ideas welcomed!
Steve.
We've invested ourselves heavily in subscription-based reporting where the SSRS service is responsible for rendering and delivering reports (to email, file shares, printers, document repositories, etc). We figured that this would be a model that would allow for easier scaling. Users submit their reports and allow SSRS to deliver them in due time. The biggest part of our reporting is now done via subscriptions.
However, adding long-running reports and short-running (but very critical) reports together to the same SSRS database has proven problematic. The long-running reports eventually make make the short reports starve for CPU time.
Does anyone know if there is a way to implement a CPU resource allocation strategy so that short running (but critical) reports will always have the ability to run? For example, it would be nice if certain user accounts or even report paths (RDL's) could have dedicated CPU resources (eg SSRS threads on which to run).
In other words, without creating additional ReportServer databases, I'd like a "pool" of threads for "severity 1" report subscriptions, a separate "pool" of threads for "severity 2" and so on. Then we'd be able to make sure that our critical subscriptions would get a chance to run. Sounds pretty straight-forward, right? Can't figure out how to go about this...
Hi all,
I have a problem with "Updatable Subscriptions" under concurrent transactions on both pub and sub effecting same data. At high level of concurrency it Subscriber starts giving error msg "Rows do not match between Publisher and Subscriber. Run the Distribution Agent to refresh rows at the Subscriber.".Please tell me any way arround for this.
I'm using SQL Server 2000 Reporting Services.
I'm trying to create a subscription to automatically generate a report daily and put a resulting pdf into a folder on the drive. Users will then receive an email notification with a link to the report so they can just click on it and see the report.
When creating the subscription, I am prompted for a set of "credentials used to access the file share" (user name and password). But I don't want my users to have to supply any credentials, I just want them to click on the link and get the report. Is there a way to disable the requirement for the credentials?
Thank you.
I have a report that I run where the selected MONTH and YEAR defaults to the prior month and year. When I run the report it shows the parameter values show as June 2007. Which is correct since this is July.
If I schedule the report to run on the 1st of every month will it default to the prior month/year automatically (I have the "use default" box checked).
I added Validate Subscriptions to my publication using the procedure outlined in BOL. Procedure is listed below. I want to stop the validation for this publication. I do not want to validate any longer. How can I stop this process?
To validate transactional data using SQL Server Enterprise Manager
At the Distributor, expand Replication Monitor, expand Publishers, and then expand a specific Publisher.
Right-click a transactional publication, and then click Validate subscriptions.
Choose whether you want to validate all subscriptions or just specific subscriptions, and if you want to validate specific subscriptions, select those in the text box.
To choose the type of validation, click Validation Options.
Choose whether you want to compute a fast rowcount based on cached table information, compute an actual row count by querying the tables directly, or compute a fast row count and if differences are found, compute an actual row count.
You can also choose to enable Compare checksums to validate data, a binary checksum (if the Subscriber is running SQL Server 2000), and you can choose to stop the Distribution Agent after the validation has completed.
Hi,
I have created a subscription for a report and this subscription is scheduled to run at specific time everyday. My subscription failed because of some stored proc issue. Is there a way to re-run the subscription. I did not know how to do this so I created a temporary subscription just to run it again. Please help!
Hello,
View 1 Replies View RelatedHi
I migrated my system from SQL2000 to SQL2005, now my MDX reports don't want to work with the data-driven subscriptions. The SQL reports run fine.
Any help, comments, or even suggestions will be very welcome.
Kind Regards
Carel Greaves
I have set up a pull subscription and nothing seems to come through although everything seems set up correctly. Push subscriptions are working just fine. Any thoughts why push subscriptions work and pull subscriptions do not?
View 4 Replies View RelatedHi everybody, I'm quite new to SQL 2005 and I€™m trying to understand some key concepts regarding replicas. I need to develop an application with characteristics similar to the Sales Order Sample for Merge Replication, on the client side it should run with the express version of sql server and also the synchronization should only work via web. I try to run the sample but I got an exception in the CreateSubscription method on invoking publisherConn.Connect();
TITLE: Microsoft.SqlServer.ConnectionInfo
------------------------------
Failed to connect to server XXX.
------------------------------
ADDITIONAL INFORMATION:
Login failed for user ''. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
I can€™t understand how this connection could work if it isn€™t aware of the fact that it should use https to connect with the server.
Can someone point me in the right direction?
Thanks
Angelo
ReportingServicesService!library!b!08/13/2007-09:00:37:: i INFO: Call to RenderFirst( '/IWM/AWD Combined Report' )
ReportingServicesService!library!b!08/13/2007-09:00:38:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information., AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service account doesn't have rights to check domain user SIDs.;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.
ReportingServicesService!library!b!08/13/2007-09:00:38:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!emailextension!b!08/13/2007-09:00:38:: Error sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The report server has encountered a configuration error. See the report server log files for more information. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.
at Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
I get the above error which I noticed is a solution in the forums for SQL Server 2000 but I am running SQL 2005 SP2. I can send an email subscription with a Link only but I can not send an email subscription along with a report. Sounds like the same problem??
My system is running in a DMZ and I am attempting to email outside that DMZ, I'm running on a MS Server 2003 Service pack 1
Can this be the same problem??