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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Uninitialized subscription error

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :


I ve created new subscription, it created successfully with no errors. When i clicked start in the 'View sync status' nothing gets started. And the status inthe replication monitor says Uninitialized subscription.

I ve tried creating and deleting publisher and subscription many times but didnt help same error every time.

I am using Sql server 2005, Running on Win Xp SP3

View Complete Post

More Related Resource Links

For a Data-driven Subscription, If it Processes 20 but 2 error , how do i just run the ones that err

 I'm trying to figure out if there is a way to just run the errored out ones.  Sometimes I have up to 100 being processed and need to only rerun the ones that error out. Is there a way to do this? and how?

Dynamics Ax report mail subscription error

I created a Dynamics Ax report. In this report some axapta static functions are called. When I run the report in browser it shows data normal. I created for this report email subscription(Setted the execution account).In the email is attached the report in pdf format, but for textboxes where it has to show data with results from axapta functions it shows "#Error". Running the report from link attached in mail shows data normal(Without"#Error"). What can be the solution for this problem?   The error from Event viewer: "The complete data cache has been flushed to request from session 13".      

Replication : Error: subscription already exists

I am receiving an error when i try to recreate a subscription. Error: subscription already exists. I ran expired subscription clean up job but still received this error. what am i missing?

Tx Replication Error when renaming Subscription Database

Tx Replication Errors when renaming Subscription Database. Please help. It seemed to work earlier, but now is giving errors when i rename subscription database.

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

SSRS Subscription Error (rsInvalidDataSourceCredentialSetting)



I just started using SSRS using SQL Server 2005. I've created several reports and have deployed these reports so they are available to use in Report Manager. I started playing around with subscriptions hoping to automate and schedule printouts for my end-users. I am trying to subscribe to this one report and have filled in the necessary fields in the subscription page but after getting everything filled in, when I hit OK, I get the ff msg - "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)". I've looked this up online and found a Microsoft Technet page on changing the setting of the data source I'm using and is as follows -

1.Go to the Data Sources properties page of the report that you want to automate.
2.For the Connect Using option, select Credentials stored securely in the report server.
3.In User Name and Password, type credentials that can be used to access the database. If you are using SQL Server as the data source, the user name must be valid for both logging on to the server and for accessing the database that contains the data for the report.
4.If the user name and password are credential

Error for delivering a report via email by using the data-driven subscription



I have created a SSRS 2005 report to export in the Excel format as a batch execution. I have made a data-driven subscription, I have specified the from mail address (with my address) and the smtp server in the RS configuration tool, I have set the SQL Server Agent account with my domain user, but I have an error about the from address is refused from the server and the client was not authenticated. I have tried to specify the IP for the smtp server.

Any suggests to me in order to solve this issue, please? Many thanks

Error while creating subscription from the backup file






='marcus8-test', --> Name of the publication



merge replication Uninitialized subscription warning


I've followed the instructions to setup merge replication. Finally, when I viewed the "Launch Replication Monitor", it is showing the warning as "Uninitialized subscription" Doesn anyone know the cause of this warning? Also, the table is not getting update,,,,,


error occurred while I tried to setup transaction replication with updateable subscription

   when I tried to setup transactional replication with updatable subscriptions between two nodes, an error occurred.

The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "REPL1 " was unable to begin a distributed transaction. Changed database context to 'database1'.

OLE DB provider "SQLNCLI" for linked server "REPL1" returned message "No transaction is active.". (.Net SqlClient Data Provider)
 May I know whether in order to setup transactional replication, do I need to run replication agents under domain users or local users?

thank you

Restored Subscription Database Resyn Error



We had a merge replication setup and it was working fine. After few days, there was some tables errors at the subscriber database, but still users were able to insert rows. These rows were not replicated to the publisher. We restored a new copy of the subscriber to resync with the publisher, but when resync the Publisher tables rows were only copied to the subscriber. We need to sync the subscriber with the publisher.


Can anyone help me on this ?




SSRS 2008 Data Driven Subscription Timeout Error



I have a report that pulls data from an SSAS 2008 cube.  The report does take a few minutes to run, as it is grabbing a lot of data.  The report is published to our sharepoint website, with stored credentials.  When I run this report manually on the sharepoint site, it works fine.  However, when I try to create a data driven subscription, it gives me the following error: Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.  I've looked through the SSRS log file, and it basically just repeats this error.  I've also run SQL Server profiler, and I can see that all of the queries that populate the parameters run successfully, but then there are no more queries sent.  So, it seems that the connection is fine, but the data driven subscription has another timeout value that is causing the problem.  All of the datasets have a timeout = 0, so that is not the issue. 

I've also run a different data driven subscription using a smaller report (based on the same cube though), and it works fine.  Any thoughts on what I need to do to fix this?


Merge Replication - Subscription Error


Hi All,


I get this error when I try to run the sync on a subscription. I found that this actually has something to do with permissions.

“ String or binary data would be truncated. [SQLSTATE 22001] (Error 8152). The step failed

If the account I am using is a server sysadmin does it still have to be part of the db_owner in publication and distribution dbs as shown below? It has write access to the file share as well so I am not sure I understand what the problem is? It is also a sysadmin on the client where the subscription is going?




Reporting Services Integrated mode 2008 R2 Subscription Email Error


I have setup report subscriptions delivered via email,  on Sharepoint and they tend to fail sending email randomly. It works most of the time, once or twice a week few subscriptions fail. Here is the detailed error message:

library!WindowsService_28!a74!05/18/2011-06:45:12:: w WARN: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. Logon failed for the unattended execution account. ---> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Log on failed. Ensure the user name and password are correct. ---> System.ComponentModel.Win32Exception: The security database on the server does not have a computer account for this workstation trust relationship

library!WindowsService_28!550!05/18/2011-06:45:12:: i INFO: Schedule 7d92afd5-f5ac-4d65-adc8-d87a3aa4bef4 executed at 05/18/2011 06:45:12.

schedule!WindowsService_28!550!05/18/2011-06:45:12:: Creating Time based subscription notification for subscription: 7f035fad-44a1-4cd6-9d41-5465540c879d

How to see the error message from the report subscription


hi there, I've created a data driven subscription for a production report and scheduled it to run every morning. I just checked the subscription and on the status , it is showing 1 processed of 1 total; 1 errors. Does anyone here know where to look for the detailed error message?



--Currently using Reporting Service 2000; Visual Studio .NET 2003; Visual Source Safe SSIS 2008 SSAS 2008, SVN --

IsapiModule Error 500 Issue


I am about exhausted trying to figure out this error:

HTTP Error 500.0 - Internal Server Error

Description: The page cannot be displayed because an internal server error has occurred.

Error Code: 0x8007007b

Notification: ExecuteRequestHandler

Module: IsapiModule

Requested URL: http://localhost:80/ReportServer

Physical Path: c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer

When I enable Failed Request Tracing Rules and view the log output I am supposing that the actual problem is in the 2nd call where there are 2 backslashes before the actual filename in the specified path:


CALL_ISAPI_EXTENSION DllName="C:\Windows\Microsoft.NET\Framework\v2.0.50727\\aspnet_isapi.dll"


Handling 404 page not found with Error page



      How do i handle 404 page not found?

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