.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

Cant reinitialize an expired subscription

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :Sql Server
 

in my company's custom app the synchronization fails every now and then with "The subscription to publication '%' has expires or does not exist". I am under the assumption these subs are expiring and have tried to reinitialize at both the subscriber and the publisher to no success. I have looked in the replication monitor and have noticed that not all the subscriptions to the pub are listed here either.

The pub is running SQL server 2005  and the subscriber is on SQL Express 2005




View Complete Post


More Related Resource Links

RMO Error: The subscription to publication has expired or does not exist

  
Hello,   I have seen several posts on this issue but none that seem to be answered or resolved. I note two posts on my browser that MS has identified as being similar to my problem. Again, none have been answered. (???? Microsoft ????)   I am having the error: "The subscription to the publication has expired or does not exist" - when I try to do a PullMerge subscription from the client. The subscription was created using RMO objects in a program. I am using stright Synchronization - not web. The resulting subscription is viewable in the SQL Server Management Studio and all the properties appear correct. No matter what, the subscription created through a program always fails with the above error.   IIf I create a subscription to the same publication using the SQL Server Management Studio, however, the PullMerge works. Both subscriptions look the same but both behave very differently. Obviously this is a security difference between the subscription made by the Mangement Studio and one made through a running application.   Can anyone shed some light on what these differences are? I read somewhere that the subscriptions and publications made through the Management Studio had a different security certificate than those through a program. What they were are not clear.   Most impotantly, how do I fix this problem?????     Code: ==============================     serverConn.C

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is no

  

Hi,

 I keep getting the following error. I also added time out parameter in the connection stirng and it still did not help. Has any one faced similar issues.

Thanks in adavance.

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

 

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.]
   System.Data.SqlCl

Is Conditional Subscription possible in SSRS 2005?

  

Hi Guys,

Is there a way to set up a subscription that will send e-mails based on the contents of a report? For example, I want to schedule a daily subscription that will only send an e-mail if the report contains data, otherwise it will do nothing for that day. i.e If the report has more than one row, it should send the mail otherwise it should not send the mail.....

Is it possible in SSRS 2005 or is there any other way to do it???

 


How to increment default dates in the subscription

  

I have a report that I want run on a monthly subscription, but the report has a default date parameter. Is there a way to have the default date parameter increment each month. So if I choose to receive the subscription monthly I would want that default date to increment.


ReportViewer Error Asp.net Session expired

  
When i am connecting Report Manager report through our ASP.NET 2.0 application using Report Viewer control frequently we get message ASP.Net Session expired .              How can we avoid this error.While i directly opens Reports through the Report Manager reports are opening without any problem.   My .Net application Code. ReportViewer1.ServerReport.ReportServerUrl = new Uri("http://SERVER/reportserver");ReportViewer1.ServerReport.ReportPath = @"/myreport/reportname";

Subscription scheduling

  
Currently I have 35 remote locations, each with a SQL Server, that all replicate (transactional) back to a data center as well as replication from the data center to each location.   Each remote location has approx 13 publications each with one subscription that all go to the data center. The data center has 3 sets of filtered publications (1 for each location) with one subscriber & 26 publications that each have 35 subscribers (to the remote locations) The SQL Server @ the data center is used very little for anything other than replication.  The SQL Server in the data center is used for a pass through & the data is replicated to the main office for queries/processing/etc. A questions has bee brought up about scheduling. What is the best practice when it comes to scheduling data to be replicated from the data center to the remote locations?? What is the best practice when it comes to scheduling data to be replicated from the remote locations to the data center?? Is there any documented white papers out there that I can use as a guide?? Currently most replication happens at X after the hour, where X is the location number (#3-#44). Does anyone have any suggestions?? AHIA, Larry....

The subscription status of the object could not be changed

  
Good day to all.. I have a problem. There are two sql servers with transactional replication Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2) There was a table function without parameters, included in articles of publication. Then I had to change it with adding one parameter. I've changed it via alter function on the publisher. And then replication stopped with error message about invalid argument count in this function. I've decided to reinitialise subscribtion with new snapshot, but new snapshot can't be created ("The subscription status of the object could not be changed"). Then I've decided to drop this subscription and recreate it, but I can't drop it (same error - "The subscription status of the object could not be changed").. Dropping publication also was unsuccesfull. How I can repair replication now?

Merge Replication: Fails using Replication.SaveProperties when changing Subscription Info

  
I'm trying to use SQL Server/Compact Framework 3 Merge Replication functionality and am running into a problem when calling Replication.SaveProperties (using c#). I was hoping to get some clarification on whether its my interpretation on how things should work vs a coding problem. Basically, the Merge Replication seems to work as I can sync information between my handheld and server databases.  However, I've created a form on my handheld so that the user can change some synchronication settings (e.g. Publication or Publisher Name) and then save it.  What I've noticed is : 1) You can NOT call Replication.SaveProperties until after a synchronization is performed (otherwise you get an error message).  Assuming this is so that it can create the "__sysMergeSubscriptions" table. Does this sound right? 2) If I then try to change the saved Subscriber information via another call to Replication.SaveProperties (e.g. change the Publication info), I then get an error message that says: The subscription was not found. Publisher, PublisherDatabase, or Publication  could be incorrect. Is this normal behavior?  Does this mean that you can you NOT change subscriber information; only add or drop it? Thanks,  Ed

Sql Compact Subscription failure - Win 7 Ultimate 64 Bit Sql 2008 64 bit, Sql Ce 3.5 sp1

  
Greetings,  Testing sql compact subscription setup on a single machine.  Can NOT get the subscription to initialize.  This works without fail on server 2003, 32 bit, and IIS 6.  I think it is security but not sure.  Using web syncConfigured publication and web sync went fine.  Key secret here was using sqlce 3.5 sp1 tools. the http://localhost/sync/sqlcesa35.dll?diag works fineThe create snapshot works fineAdded the IUSR with db_owner rights to the primary database.Added the IUSR to the publication access list.The Agent is running, I checked that.Created a new sql ce db in the management studio and configured the subscription through the wizard, like I do all the time in sql 2005.It fails with the following error codes, which I suspect are security related.  Below is the setup for the subscription:Publisher: My-PCPublisherDatabase: MyDBPublication: MyDB_PUBSubscriber: 0024HostName: 0024InternetUrl: http://localhost/sync/sqlcesa35.dllWeb Server Authentication: AnonymousPublisherSecurityMode: Windows AuthenticationError Message below:2010/03/11 15:20:07 == SQLCESA Version ==> 3.5.5692.02010/03/11 15:20:07 Hr=00000000 SQLCE Server Agent Loaded - Version 3.5.5692.002010/03/11 15:20:17 Thread=4A0 RSCB=1 Command=SCHK Hr=80045637 ERR:Initialize failed for DistributorSessionID =  02010/03/11 15:20:17 Thread=4A0 RSCB=1 Command=SCHK Hr=8004

Reinitialize transaction replication clear the subcriber data and replicating again

  
Hi all, I add new table in to mu publisher database and reinitialize the subscriber.And i select the option to create new snapshot and marked as reinitialize.When it starts the reinitializing it clear all data from subscriber and coping again.Am i missing any thing here to add new table into existing replication ? Regards, Theesh

SSRS integrated mode email subscription to AD dist group

  
I have MOSS 2007 running SQL 2008 SSRS integrated mode and have created some reports and report subscriptions. Everything is working great. Now I want to use an Active Directory Distribution Group as a recipient for a report subscription - does not work, however the "last results" show no error. Try again using Dist Group in TO: field but adding regular email in CC: field...only email in CC field receive report, again all successful. Does SSRS integrated mode support AD distribution groups? if so is there any special setup required? Thanks LmmMmmm...yummy...

Another merge agent for the subscription or subscriptions is running, or the server is working on a

  
Hi All, Using Merge Replication over the web (https). Server is running SQL Server 2008, client using SQL Server Express 2008. I am getting these error messages while trying to synchronize, and it won't let me sync: {call sp_MSensure_single_instance (N'{459D0BBA-53EC-4F65-AF52-E7DA478841DA}', 4)} Another merge agent for the subscription or subscriptions is running, or the server is working on a previous request by the same agent. Can you please advice what can be done to fix. Do I need to kill a process in SQL Server?

Active or Expired

  
hAI, I  Need help from ur end. I have drop down .in that i want diplay Active , Expired by default "All".  If the Current Date >= Expiration Date then the status is expired. how can i craete drop down . i am create one DS For  DROP DOWN .

email subscription

  
Hello All Experts, I have created email subscription for one report, which is working properly. I have scheduled it on everyday,its automatically send emails to the concern email id on everyday basis. Now is there any way suppose when reports get executed and reports comes blank then its shouldnt send mail on that day. Is it possible or not? Because currently the report is coming blank then also its sending blank report to the concern email id. Please guide me. Regards, AKM  

Microsoft.Reporting.WebForms.AspNetSessionExpiredException: ASP.NET session has expired

  
**A)** I have an asp.net page with a reportViewer control hosting a report in remote processing Mode. Whenever i would tried to export the report to excel or pdf, i could get the error      Microsoft.Reporting.WebForms.AspNetSessionExpiredException: ASP.NET session has expired I then came across this http://msdn.microsoft.com/en-us/library/ms178586.aspx and decided to resolve the problem by going with **SQL Server Mode** sessionState( http://www.nimbleuser.com/blogs/Knowledge_Base/knowledge_base/Installing/Configuring_the_Session_State_Database_for_Multi-Core_Web_Servers.aspx ) and the export problem was resolved. **B)** Now, i also have a completely different Windows Forms application deployed by ClickOnce deployment(.NET 3.5 SP1).  **In this windows application, i have a form with a WebBrowser control whose URL is the asp.net page mentioned in A above.**  Unfortunately, when the reportViewer asp.net page is displayed in the WebBrowser control which is on the windows form and i click the Export button, i get the error as in A above(`Microsoft.Reporting.WebForms.AspNetSessionExpiredException: ASP.NET session has expired` ). When i added the below code to the web.config file of the asp.net application, the problem was resolved     <sessionState mode="SQLServer" sqlConnectionString="server=myServer;UID=User1;P

email subscription problem

  
Hello All Experts, I have created email subscription for one report, which is working properly. I have scheduled it on everyday,its automatically send emails to the concern email id on everyday basis. Now is there any way suppose when reports get executed and reports comes blank then its shouldnt send mail on that day. Is it possible or not? Because currently the report is coming blank then also its sending blank report to the concern email id. Please guide me. Regards,AKM  
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend