Need To Reinitialize Subscriptions
Jun 7, 2015
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)
View 0 Replies
ADVERTISEMENT
Feb 27, 2004
If I have one table in one publication in transactional replication
replication between primary and replicate is broken because subscription is marked as inactive.
If there are 3 rows on replicate and 5 rows on primary , out of which 2 are added after replication is broken
If I do
Reinitialize subscriptions
start the snapshot agent
start the distribution agent
Does this mean that it will only transfer the new 2 rows to replicate sites ? or will it drop everything from replicate site and apply all rows from primary site on to replicate.
Any help is appreciated
View 1 Replies
View Related
May 16, 2007
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
View 9 Replies
View Related
Jan 18, 2007
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).
View 1 Replies
View Related
May 8, 2007
How can you tell if a merge subscription is set to reinitialize?
View 2 Replies
View Related
Jan 23, 2008
Hi members!
I was wondering how to reintialize one of many subscriptions under a publication...
I know I can use sp_startpublication_snapshot to reinitialize all the subscriptions but how do you only reinitialize one subscription????
Thanks for your help!!! very appreciated!
thanks,
View 1 Replies
View Related
Jan 17, 2008
We have several sites using SQLCE to merge sync. with an SQL 2005 server, and recently a large change was made at the server end. The sites now only seems to upload their changes, but are unable to download any server changes, and the sync fails with the following message (after about half an hour):
A call to SQL Server Reconciler failed. Try to resynchronize.
HRESULT 0x80004005 (29006)
The merge process was unable to create a new generation at the 'Publisher'. Troubleshoot by restarting the synchronization with verbose history logging and specify an output file to which to write.
HRESULT 0x8004501E (0)
I would like to reinitialize the subscriptions using the option to upload any subscriber changes first, but I don't know exactly what this will do. Will it simply re-download the entire database, after uploading any recent changes? This is what I want it to do, but am unable to find any help telling me what exactly 'reinitialize subscription' does.
Many thanks in advance!
View 1 Replies
View Related
Mar 27, 2004
I have a few databases that I replicate between NY and Greece. We utilize merge replication on all SQL 2000 servers. My question, is there a quick way to reinitialize replication besides pushing the initial snapshot? I would like to avoid the initial snapshot in the event of a failure due to the amount of time it takes to transfer over our 3mb ATM circuit.
Any help is greatly appreciated.
Thanks,
Michael
View 2 Replies
View Related
Oct 24, 2007
Hi,
I'm setting up Transaction Replication b/w SQL Server 2K and SQL Server 2K5.
I have published Tables, Views and SPs as articles.
When I try to modify the published Stored procedure, the changes are not replicated.
When I Reinitialize the Subscription and start the Snapshot agent, it is copying the changes
made. But all articles are reinitialized again, So it takes huge time to do this.
Is there any way to just reinitialize only the changed article?
Or Is there any work around for this problem?
Than
View 1 Replies
View Related
Dec 20, 2006
I have kind of unique situation. I am running Merge replication. In one of my publications I am only publishing procedures/functions/views. By design, these do not change that often, but when a programmability object changes, it is scripted in a way so that:
1. The article is dropped from the publication
2. the object is then changed
3. The article is added back to the publication
My question is: Is there a table or view that the subscriber or publisher can see that could tell me if reinitialization needs to occur. I am looking at adding an automated script at the subscriber that makes the determiniation and automatically reinitializes the subscription. My alternative is to force the subscriber to reinitialize every time when synchronizing with this publication, even if nothing has changed because the process has to be automated.
Thanks,
Bill
View 8 Replies
View Related
Oct 24, 2006
Hi
I have a web sync merge publication with multiple anonymous subscribers. Unfortunately two of the subscribers have experienced errors as follows.
###############################################
The Merge Agent failed after detecting that retention-based metadata cleanup has deleted metadata at the Subscriber for changes not yet sent to the Publisher. You must reinitialize the subscription (without upload). (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199401)
###############################################
Now they successfully sync'd within the retention period so I am baffled as to why the cleanup has occured. Unfortunately I can't seem to find a way to reinitialize just a single subscriber. It seems that the only reinitialize option is across all subscribers, which I do not wish to do as they would loose any changes since last sync.
Can anyone shed any light on this.
Cheers
Rab
View 3 Replies
View Related
May 2, 2007
Hello,
After creating a publication for Merge Replication, if I need to add or drop a simple table, do I have to reinitialize the snapshot all over again?
Thanks
Ekrem Önsoy
View 1 Replies
View Related
Nov 18, 2006
I've been trying to reinitialize the membership database, but something stops me.
I have tried deleting aspnetdb.mdf from the App_Data folder. This works fine, and then a new one is created when I use the asp.net adminstration tool. I can use the server explorer to view the table content (all null).
Although I can open the asp.net configuration page, the problem occurs when I select security. Then I get the error
There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: Database 'C:WINDOWSMicrosoft.NETFrameworkv2.0.50727asp.netwebadminfilesApp_DataASPNETDB.MDF' already exists. Could not attach file 'C:Documents and SettingsJeff LeeseMy Documentsworldmy workcurrentcounsellorApp_DataASPNETDB.MDF' as database 'ASPNETDB_devjeffleese'.
All this seems to have happened after I modified my connection info in the web.config file:
<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=.SQLEXPRESS;
 AttachDbFilename=|DataDirectory|ASPNETDB.MDF;
 user instance=true;
 Integrated Security=True;
 Initial Catalog=ASPNETDB_devjeffleese;"
providerName="System.Data.SqlClient" />
</connectionStrings>
So, two questions:
1) What are the 
 sections about? They seem to have been inserted automatically at some point, and I wonder if its just formatting info or should I remove them?
2) How can I get security going again. How do I deal with the 'already exists' problem that prevents 'attaching' ?
Would greatly appreciate guidance in how to start over...
View 1 Replies
View Related
Feb 11, 2015
When trying to reinitialize a transactional replication subscription I am unable to select the "Generate the new snapshot now" checkbox. This seems to be happening only with SSMS 2014. When I connect to the same server from SSMS 2008 R2 I am able to select this checkbox.
View 0 Replies
View Related
May 15, 2006
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 Related
Mar 13, 2007
Hi 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
View 3 Replies
View Related
Feb 1, 2008
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.
View 2 Replies
View Related
Jan 28, 2008
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
View 1 Replies
View Related
Jul 23, 2005
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 Related
Aug 23, 2007
I 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
View 1 Replies
View Related
Sep 18, 2007
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?
View 1 Replies
View Related
May 7, 2008
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
View 4 Replies
View Related
Jan 24, 2008
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.
View 3 Replies
View Related
Feb 11, 2008
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.
View 2 Replies
View Related
Nov 23, 2007
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
May 14, 2008
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
View 3 Replies
View Related
Jan 4, 2008
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.
View 1 Replies
View Related
Feb 12, 2007
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
View 12 Replies
View Related
Apr 9, 2008
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
View 3 Replies
View Related
May 11, 2006
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.
View 3 Replies
View Related
Sep 6, 2006
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?
View 1 Replies
View Related
Apr 4, 2007
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
View 3 Replies
View Related
Feb 12, 2008
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.
View 1 Replies
View Related
