ADVERTISEMENT

Creating Pull Subscription Using T-SQL

Aug 24, 2006

Hello,

i am trying to create a pull subscription to my publication using T-SQL. The pull subcription is created successfully but the problem is that data is not merged correctly. I mean when i run the agent ( despite of having data in subscription / publication ) the data is not merged and i get "No Data Needed To Be Merged" message.

i run following sp in this sequence:

At Subscrber:

1 - sp_addmergepullsubscription
2 - sp_addmergepullsubscription_agent

At Publisher:

1 - sp_addmergesubscription



Again at subscriber :

Transaction for adding merge agent job.

Regards,

View 16 Replies View Related

Error When Creating Subscription

Nov 7, 2007

I have a client who is getting an error when they try to create a report subscription. The error is as follows:

An unexpected error occurred: A subscription delivery error has occurred. ---> A subscription delivery error has occurred. ---> One of the extension parameters is not valid for the following reason: The account you are using does not have administrator priviledges. A subscription cannot be created for [email address].

The thing I find strange is that the client was able to create a shared schedule with no problems, so I don't see how they don't have administrator privileges. The shared schedules and subscriptions are created programmatically through a web application if that is of any importance.

Any ideas on how to fix this error?

View 1 Replies View Related

Creating A Subscription Via An Application

Mar 9, 2007

Hello,

I am wondering if there is some sample code out there that shows how to create a subscription for a report on reporting services via a win app or if anyone has a better suggestion. We are wanting to have a report that resides on reporting services server be sent to a client via email subscription, but do not want the client to goto the actual website that host reporting services. Thanks in advance.

John

View 3 Replies View Related

Problem Creating A Subscription

Feb 6, 2006

I am trying to publish / subscribe a database onto SQL Server Mobile and when I run the following code that was, for the most part, generated by the SQL Server Management Studio Subscription Wizard,

repl.InternetUrl=@"file://chiefjoseph/walklisttransfersite/sqlcesa30.dll";
repl.InternetLogin = @"rr";
repl.InternetPassword = @"88";
repl.Publisher = @"CHIEFJOSEPHSQLSERVER2005";
repl.PublisherDatabase = @"WalkList";
repl.PublisherSecurityMode = SecurityType.DBAuthentication;
repl.PublisherLogin = @"sx";
repl.PublisherPassword = @"xxx";
repl.Publication = @"WalkList";
repl.Subscriber = @"WalkListSubscription";
repl.SubscriberConnectionString = @"Data Source=""My DocumentsSQLServerNewWalkList.sdf"";Password=""pwd"";Max Database Size=32;Default Lock Escalation =100;";
try
{
// repl.AddSubscription(AddOption.ExistingDatabase);
repl.AddSubscription(AddOption.ExistingDatabase);
repl.Synchronize();
}
catch (SqlCeException ex)
{
MessageBox.Show(ex.ToString());
}

I get the following error on the Pocket PC emulator

€œA native exception has occurred in WalkLister.exe. Select Quit and then restart this program, or select Details for more information.€?

When I try to use the subscription wizard to create the subscription, I get the following error:

Synchronizing Data (Error)
Messages
· Connection broken.
HRESULT 0x80004005 (0)

· The operation could not be completed.

Any insight to what the problem might be?

-Rob

View 1 Replies View Related

Error Creating A New Pull Subscription

Dec 7, 2005

Hi

View 10 Replies View Related

Transact SQL For Creating Merge Subscription

Sep 13, 2006

I am trying to create a merge publication in sql server 2005 and a merge subscription in sql server 2005 mobile through transact sql using sql server query analyzer.

I am succeeded in creating the publication but not subscription.

I am using sp_addmergepublication and sp_addmergesubscription.

sp_addmergepublication is working fine.

But the problem is in creating sp_addmergesubscription.

Can anyone please guide me how to create subscription to sql server 2005 mobile database using transact sql.

View 1 Replies View Related

Error Creating Subscription To Reports

Nov 20, 2006

Hi all,

 

I am having a HUGE issue with SSRS, I am running SQL 2005 on Win 2003 server, the SQL uses SQL and windows permissions.

I have a datasource which stores it credentials securely on the server but for some reason when i try to subscribe to the report it errors saying

"Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked server the link is no longer valid."

Beats me but the credentials are stored, I am  connecting using a user account which can run the report fine (This is proven).

I have SP1 installed, and have literally tried every last option in the book.

 

N.B i have read all the existing post about this and i seem to have a different issue, I am not using any paraeters in the report i am trying to test and i dont use anything like USR!USERID

Please help!

 

Andy

View 11 Replies View Related

Problem Creating SQL Server Mobile Subscription

Jan 2, 2006

 

Hi there

When I try and create a subscription in SQL Server Mobile to a published SQL Server 2005 database, I get the following problem error during the data synchronization process:
Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29061)
 
Any help would be gratefully appreciated.
 
Regards
 
JB

View 9 Replies View Related

Problem Creating Data-Driven Subscription

Jul 2, 2007

Using SS2005, I am trying to create a Data-Driven Subscription to query off a value. I have the value in my stored procedure like:



Procedure dbo.sp_ReportMaster @myid int=null



When I run the report in the Reporting Services, it prompts for myid, which is fine. I then deployed the report to the Reports Manager and tried to create a Data-Driven Subscription. Where it says specify a command, I put in exec sp_ReportMaster. I put in the pertinent information, then it says, "The 'ReportMaster' has no parameters," even though I have the parameter in my stored procedure and I put myid as a parameter in my report in Reporting Services.



I don't know why it shows parameters in Reporting Services when I run the report from there, but when I try to create the subscription, it shows that I don't have any parameters.



Thanks, Iris

View 2 Replies View Related

Reporting Services :: SSRS Subscription Creating Duplicate Job

Jan 4, 2012

We have this sporadic problem where when we go in to save an edit on a SSRS report subscription, it gives us a duplicate job number error.  When I look at the Jobs in the Agent, there are duplicates, so I need to manually delete both duplicate jobs, then the subscription save will work.  If we delete just 1 of the jobs, the issue seems to clear for a while, but then reoccurs.  This has happened to us on multiple reports, but not consistently.  The subscriptions look fine.

View 7 Replies View Related

SSRS - Resetting A Subscription After A Subscription Run Failure

Feb 11, 2008



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?

Thank you
Devon Kyle

View 5 Replies View Related

Existing Subscription Already Contains Table Included In The New Subscription

Sep 26, 2007







28638


SSCE_M_DUPLICATETABLE


Existing subscription already contains table included in the new subscription.


What are the possible causes of this merge replication error?
Could it be caused by a SQL Server Compact Edition User trying to sync their .sdf file after their subscription has already expired on the SQL Server?

Would you expect to see a different message if a SQL Server Compact Edition user tried to sync a subscriber database (.sdf file) with merge replication if it's been longer than the subscription retention period since their last sync?

View 6 Replies View Related

Creating Trigger On Creating Table

Jan 28, 2008



Hi,

If I want to automatically insert a record which has default value in a table,
how can I create the trigger?

View 5 Replies View Related

Subscription

Jul 2, 2007



Hi,


We are migrating our reporting services database from one server to another.


What needs to be done to subscriptions to ensure they work properly. Will they automatically update as part of the migration, or is there a manual process.


We are using Reporting Services 2000 and will be using Reporting services 2000 as well on the new server.



Thanks

View 1 Replies View Related

DD Subscription

Nov 7, 2007

Hi all,
I'm creating data driven subscription for parameterized reports. I'm supposed to deliver one report to six different customers. But each customer can see only his own data in the report. This is not a problem. But the problem is I need another report in which all the data can be seen. When I create DD subsription, I chosed Auto increment option for the write mode under "





Specify delivery extension settings for Report Server FileShare" .
But then it creates seperate report for each parameter value. But it does not create the report which contains all the data for all parameter values. How can I make it without creating another report.
Also when I use overwrite option instead of Auto Increment, It creates only one reports. Does any one know why it happens?

Thanks

View 1 Replies View Related

Subscription

Dec 7, 2006

Hello,

is it possible to make a new subscription remote over a website and NOT in the Reportmanager?

Has anybody done something like this and are there any examples?



Thx

Jo-Jo

View 10 Replies View Related

Replication - Subscription

May 23, 2001

Hi,
I am doing a repl.in SQL7/NT.
At time of 'Push Subscription wizard' - I used the option "Yes,Initialize the schema and data......" whereas I already had data and schema at the subscriber.
Now my question is what will happen now and how long will this process take(for approx5GB of DAta).
OR should I stop the process - it's already an hour when I started the process.
Any suggestion appreciated.

View 1 Replies View Related

Subscription Pulls

Aug 24, 2001

I have created a subscription pull from one SQL server to another so that the database from one SQL server is replicated to another. But when the subscription runs, no data appears in the subscriber SQL server. When I check the subscription, I see that the database is connecting to the publisher but that is it. I have the login correct but what am I missing? Do the tables in the subscriber database have to be already created and matching the ones in the publisher database before the subscription runs or are they automaticaly created after the subscription runs?

Thank you in advance

View 1 Replies View Related

Generation Of Subscription

Feb 7, 2005

Hello all,

I have a data driven subscription with the information about the file name/file extension/ path etc coming in from a database. The problem is that the subscription status after running tells me that things are done and there is no error but the file is not being generated in the specified directory and for that reason the file is not generated at all anywhere on the hard disk. can anybody please help.

The information in the database for the report is as follows

FileName : Test1
FileExtn : True
Path = \ram\C$Reports
Render_Format = PDF
Username = Administrator
Password = password
Writemode = Overwrite

All the fields are varchar(50) in size.

View 1 Replies View Related

Subscription Reports

Mar 20, 2006

Hi, wonder if someone can help.

I've created a subscription and scheduled it to run but I get the following message:

Failure sending mail: The transport failed to connect to the server.

Anyone any ideas why? or what I can do to fix it?

Thanks

View 3 Replies View Related

Is DB Publication/subscription?

Jul 26, 2004

Because of problems trying to alter databases used
for replication my software would need to find out
if a database is a publisher or was repliated (using
T-SQL). Is this possible?

View 1 Replies View Related

Pull Subscription

Sep 27, 2006

My name is Tech guy,

I want to use window script program to execute a pull subscription installed on SQL 2005 express edition. Because it free for downloand.
is there a script that can call an existing pull subscription execution.

View 6 Replies View Related

Drop Subscription

Dec 28, 2006

is there anyone know how to drop subscription from the publisher database without a connection to the subscriber(because the subscriber server is formated)

View 3 Replies View Related

Pull Subscription

Sep 14, 2006

Are there any procedural differences between Express and MSDE considering pull subscription?

Thanks

abdul

View 2 Replies View Related

Email Subscription

Jul 2, 2007

Hi

I have uploaded a report onto my 2005 Reporting Manager and want to create a daily email of the report... How do I set up the email facility? Can someone give me a link?
I not sure what to do because the company uses Exchange Server and not SMTP....

Thanks

View 5 Replies View Related

Report Subscription

Apr 24, 2008



Hi,

I need to subscribe one report in Reporting Services. I was compiled all fields and I said to report server that
I want excel file at one shared directory of the server.
When the report server tried to process the report I have the following messagge:

Failure writing file S16 : An unexpected error occurred in Report Processing.

What's the report want?


thanks.

View 5 Replies View Related

Subscription: RsInvalidDataSourceCredentialSetting

Aug 24, 2007

I am unable to create a subscription.

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)


Delievered by: Report Server E-Mail
SMTP: is enabled on IIS
Reporting Services Configuration Manager:

Email Setting: setup correctly

What else is it that I would need to check to get the subscriptions going?



View 17 Replies View Related

Subscription Missing

Apr 6, 2006

We are seeing a problem with the users of our application. If the user closes our application from running programs (as best as we can tell as we cannot repro in dev) and SQL Mobile is in the middle of an async sync, sometimes when the application restarts it fails to load the properties for replication from the database. We are using code that is nearly identical to the samples provided by MS for performing replication async. Basically, the database still exists on the device and the application can use it just fine, but when a sync starts, the database is already there, so it tries to load the properties at which point we get a message stating that there is no subscription in the database.

Any ideas?

The second question would be if it doesn't exist and the database already contains data, can I create the subscription and have it not loose the users changes? Will it sync correctly after that?

Thanks for the help!!

Mike

View 5 Replies View Related

How Can You Tell That A Subscription Is Set To Reinitialize?

May 8, 2007

How can you tell if a merge subscription is set to reinitialize?

View 2 Replies View Related

IIS Error On New Subscription

Mar 9, 2006

hi. i was following the newbie's guide: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp?frame=true

on the creating a new subscription i was doing okay until i get to the last part wherein i click finish and this error pops up when it starts synchronizing data..

An error has occured on the computer running IIS. Try restarting the IIS server.

i already tried restarting the server.. is there anything else i can do to make it work?

View 6 Replies View Related

Subscription Not Displayed

Feb 23, 2007



Hi,

I have setup Merge replication with 2 publishers and one subscriber. On the subscription machine I can see publisher 1 listed under local subscriptions but not publisher 2. I have created the second subscription on publisher 2 and also tried to create the subscription again on the subscription machine but i get an error saying the 'Subscription already exists'.

Neither do I see the second subscription nor does it work as if it is subscribed to Publisher 2. What could be going wrong.

I would appreciate any help.

Thanks

tribal

View 5 Replies View Related

Subscription Setup

Sep 12, 2007

I know how to schedule a report to generate and email somebody weekly on a particular day of the week but how do you tell it to run for previous date range? For example to run on Thursday Sept.13, I would want it include data from Start date of Sept 3 and end date Sept 9.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved