How To Get Mobile Subscription To Sync With Dynamic Snapshot

Feb 8, 2007

Hello Everyone,

I have a publication on a Sql 2000 (SP4) server. This publication has dynamic filtering enabled. What I want to do is create an interface which will generate a new dynamic snapshot based on filtering input from users. So far I can create the dynamic snapshot easy enough and I can see the filtered results on a Sql 2000 subscriber. However, there seems to be no way to configure a mobile database to point to the dynamic snapshot. This is easy to configure in a Sql 2000 subscription - the options are right there are on the properties page. Yet, it seems like the mobile database only points to the required unfiltered snapshot through the IIS proxy.

Is there any way to force the mobile database to use the dynamic snapshot instead?

Thanks,

Mike



View 6 Replies


ADVERTISEMENT

Merge Replication W/ Dynamic Row Filter - Not 'dynamic' After First Initial Sync?

May 2, 2007

If anyone could confirm...

SQL Server 2000 SP4 to multiple SQL Server 2005 Mobile Edition on PDAs. My DB on SQL2k is published with a single dynamic row filter using host_name() on my 'parent' table and also join filters from parent to child tables. The row filter uses joins to other tables elsewhere that are not published to evaluate what data is allowed through the filter.

E.g. Published parent table that contains suppliers names, etc. while child table is suppliers' products. The filter queries host_name(s) linked to suppliers in unpublished table elsewhere.

First initial sync with snapshot is correct and as I expected - PDA receives only the data from parent (and thus child tables) that matches the row filter for the host_name provided.

However - in my scenario host_name <--> suppliers may later be updated E.g. more suppliers assigned to a PDA for use or vice versa. But when I merge the mobile DB, the new data is not downloaded? Tried re-running snapshot, etc., no change.

Question: I thought the filters would remain dynamic and be applied on each sync?

I run a 'harmless' update on parent table using TSQL e.g. "update table set 'X' = 'X'" and re-sync. Now the new parent records are downloaded - but the child records are not!

Question: I wonder why if parent records are supplied, why not child records?

If I delete existing DB and sync new, I get the updated snapshot and all is well - until more data added back at server...

Any help would be greatly appreciated. Is it possible (or not) to have dynamic filters run during second or subsequent merge?

View 4 Replies View Related

Sql Express Web Sync, Can't Find Snapshot?

Nov 12, 2007

I'm using RMO to set up MergePullSubscription to a SQL Express database, the server is running SS2k5.

The subscription gets created just fine, and web sync seems to be working, going to replisapi.dll?diag in my new virtual directory returns no errors.

When creating the publication on the server (using management studio for this) the snapshot is created, and stored in the snapshot share. Creating the publication seems to go without any issues. When I open the "Configure Web Synchronization" wizard, and point it to my new snapshot share, it ALWAYS says that the snapshot folder appears to be empty, which it isn't.

I get an error when I attempt to sync the databases that I believe is caused by Web Sync not being able to find the snapshot. Here's the output from triggering the sync via RMO.

2007-11-12 14:45:49.225 The upload message to be sent to Publisher 'SandBoxWebApp' is being generated
2007-11-12 14:45:49.265 The merge process is using Exchange ID 'DF8FE565-F6BC-40B3-8AEA-7B6FA5EC225D' for this web synchronization session.
2007-11-12 14:45:49.928 No data needed to be merged.
2007-11-12 14:45:49.940 Request message generated, now making it ready for upload.
2007-11-12 14:45:49.952 Upload request size is 1290 bytes.
2007-11-12 14:45:49.988 Uploaded a total of 1 chunks.
2007-11-12 14:45:50.000 The request message was sent to 'https://SandBoxWebApp/WebSync/replisapi.dll'
2007-11-12 14:45:50.064 Downloaded a total of 3 chunks.
2007-11-12 14:45:50.076 The response message was received from 'https://SandBoxWebApp/WebSync/replisapi.dll' and is being processed.
2007-11-12 14:45:50.109 The process could not connect to Distributor 'SandBoxWebApp'.
A first chance exception of type 'System.Runtime.InteropServices.SEHException' occurred in Microsoft.SqlServer.Replication.dll
A first chance exception of type 'Microsoft.SqlServer.Replication.ComErrorException' occurred in Microsoft.SqlServer.Replication.dll
A first chance exception of type 'Microsoft.SqlServer.Replication.ComErrorException' occurred in Microsoft.SqlServer.Replication.dll

That's it, always end up with "Cannot connect to distributor".

I'm using a free cert for testing, hence the non-FQDN name SandBox, but I have added the root CA to my machine, and don't get any cert errors when visiting the ?diag page in my browser.

Any ideas? I've been beating my head against the same wall for 2 days now!

Thanks in advance,
Scott P

View 1 Replies View Related

Web Sync: Strange Behaviour With The Snapshot Size

Aug 29, 2006

Hi

There's *strange* behaviour with snapshot size during subscription initialization.

So...

The initial snapshot has size about 9Mb at the publisher.

After subscription creation, I notice that the subscriber downloads about 21 MB.

It seems to me, that the snapshot is unpacked on the IIS, next, part of the files are packed again and just after it the changed snaphot is sent to the subscriber.

Why?

How it can be solved?

It brings some extent nuisance...

Thanks

Paul

View 11 Replies View Related

Sync Between Mobile And Desktop

Oct 6, 2007

Can I synch between a Mobile device using SqlServer Compact and desktop PC running Sql Server Express using Microsoft Synchronization Services?

View 1 Replies View Related

How Many Mobile DB's Can Sync With One Server?

Oct 3, 2006

Hi,

I'm in the planning stages of a new application and upper mgmt needs this question answered. I am planning to use SQL Mobile 2005 on the hand held devices and SQL Server 2005 as the server. What kind of hardware/configuration do I need that would allow 500 mobile devices to sync at roughly the same time? Any reccomendations on design issues is also welcome.

The business community is all on the same schedule and past experience shows that that do things in large groups. I need to plan for the worst case. Any input would be appreciated.

Thanks,

View 1 Replies View Related

Sync Two Mobile Databases

May 25, 2007

Hi,



If I have 2 mobile databases, 1 on my desktop and the other on a PDA, how do i synchronize both these database? Are there any vb samples where i can refer to?



thanx

View 4 Replies View Related

SQL Mobile Sync Problems

Jun 30, 2006

I have just upgraded from a working app for Pocket PC 2003 developed on MS SQL 2000 and VS 2003 to Mobile 5, MS SQL 2005 and VS 2005 and have been nable to get anything working.

I decided to go back to basics and just try to sync a SQL2005 and SQL mobile database by following the MS doc "Creating a mobile application with SQL Server mobile" and "Step by Step: Developing a SQL Mobile App with Visual Studio 2005 and SQL Server 2005". Unfortunately I have n't been able to get either of these 2 examlpes working either. The Database, publications, subscriptions etc are all created OK yet when I come to sync I get the following error:

"A request to send data to the computer running iis has failed"

I'd greatly appreciate it if someone could offer me any clues as how to approach this.

View 6 Replies View Related

Sync'ing A Merge Subscription Before Removal.

Feb 15, 2006

Hi,

is there a way to ensure a merge subscription is synchronised before it is removed from the publisher using SMO? - (it is a push subscription)

I thought I had it as there is a MergeSynchronizationAgent object on the SubscriptionDatabase object, but calling Synchronize() on this throws an exception saying it can't contact the publisher.

Any help would be really appreciated, thanks.

Graham

View 4 Replies View Related

Subscription/Data Sync Error

Sep 28, 2006

Dear All

Iam receiving an error message when trying to complete the subscription. Please find the below given error report that I get from SQL server.
Synchronizing Data (100%) (Error)
Messages
· A call to SQL Server Reconciler failed. Try to resynchronize.
HRESULT 0x80004005 (29006)

The schema script '\MAINsnapshotuncMAIN_SQLMOBILE_TEST20060926133385MembershipData_2.sch' could not be propagated to the subscriber.
HRESULT 0x800704CF (0)

The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write.
HRESULT 0x80045017 (0)


The operation could not be completed.

View 6 Replies View Related

Subscriber Alternate Snapshot Location And Web Sync - 2005 Express

Dec 7, 2005

Hi,

View 6 Replies View Related

Snapshot Share Access Problems After Publication And Web Sync Wizard

Feb 6, 2006

Hi

I've big problems with my SQL Server 2005 Std. merge replication/snapshot share

I want to create a mobile application based on a ms sql 2005 mobile database running on a pocketpc 2003se.

for this task i installed iis, sql server 2005 std. and the sql server mobile tools.

i created a dedicated user for making snapshots in the new created and functionable publication, but when i start the web sync wizard, i alwas get the failurmessages

snapshot share "......" cannot be accessed, please specify a new share

the access permissions based on the share an based on the ntfs area are set right.

the user, i chose for the anonymus access (the same, as for creating snapshots), has enough rights on the folder. also when creating a new share, with different share name, and using another user for anonymus access (standard iusr_machine_name) i get the same message



do you have any suggestions for my problem??



please i need help as soon as possible

best regards

View 6 Replies View Related

Replication Failing While Applying Snapshot As The Stored Procs Are Out Of Sync

Aug 28, 2007

Replication is failing while applying the snapshot as the stored procs are out of sync ( the objects referenced in the stored procedures are no more exists in the database) . Is there any easy way to identify the out of sync procedures so that I can exclude these stored procedures from the articles list. I am having around 1000 procs and is not possible to test them by executing.

Thanks in advance.

View 1 Replies View Related

Synchronize Desktop SDF &&amp; Mobile SDF - MS Sync Services

Apr 29, 2008

I have been able to use MS Sync Services to sync an MDF file & an SDF file (Works great! Very easy!).

What I would like to know is if I could sync an SDF file with another SDF file (making an SDF file a desktop DB and the other a Mobile DB)?

Thanks,

V

VS 2008
SQL 2005 Express

View 3 Replies View Related

Using Push In RDA For Sync The Data From Sql Mobile To Sql Server 2005

Oct 6, 2006

Hi Everyone,

I have tried the Sync the data from sql server mobile (.SDF) to Sql server 2005 (.mdf).In push command, i am getting the error "Sql Server Everywhere encountered problems when opening the database".
string rdaOleDbConnectString = @"Provider=SQLOLEDB.1;User ID=sa;Initial Catalog=master;Data Source=PRASSANAPRASANNA;Password=master";
qlCeRemoteDataAccess rda = null;
try
{
rda = new SqlCeRemoteDataAccess();
rda.LocalConnectionString = "Data Source=D:/DATABASE/test.sdf";
rda.InternetUrl = http://localhost/Dataset/sqlcesa30.dll;
rda.Push("company", rdaOleDbConnectString, RdaBatchOption.BatchingOn);
MessageBox.Show("Completed");

}

catch (SqlCeException)

{



}



finally

{



rda.Dispose();



}

please guide me any one ours guys to solve this problem .

Thanks

Prasanna.





View 5 Replies View Related

How To Pass A Parameter Or Value To A Publication From A Mobile Device During Sync.

Aug 5, 2007

Hiya,

I have a project that requires that I filter certain data going to the mobile device via the publication based on user selected value on the mobile device. (Filter by location based on the selection of the location on the mobile prior to syncronization).

Now, our current authentication model is Windows Authentication, and changing that to Username based authentication is not feasable, and using the users account to pass that value to the database is the only way I can think of to do this... (Then filter based on username)

But then I thought that there has to be another way - such as passing a variable or parameter to the sync request during or before syncronization... Is this possible? If I could query the data being sent back up to the server, for instance, I could do so to retrieve the value I need.... Any ideas?

Any help appreciated!!

Dave Borneman
anyWare Mobile Solutions

View 1 Replies View Related

Problem With Sync O2 Mini With Windows Mobile Device Center

Sep 9, 2007



I use my Pocket PC XDA O2 mini for 2 years already and I don't have any problems when I sync it with my previous laptop which has Window XP operation system.

A few months ago, I bought a new laptop with Window Vista operation system, I could not sync my O2 mini with my PC. Then, I download Windows Mobile Device Center but my computer still could not recognize my O2 mini. My O2 mini has window mobile 2003 Second Edition Version 4.21.1088 operation system. Please let me know if you have any advices.

Thanks.

View 1 Replies View Related

Subscription Without Snapshot Doesn't Work

Feb 26, 2007



Hi all,



I'm very very frustrated with this problem, I used to give maintenance to my database replication, disabling distribution and establishing the publications and subscriptions again from zero. This way metadata were clean up, and I was sure of that. When I migrated to MS SQL2005 I can't do this anymore, because drop rowguidcol at subscribers and publisher. The DB average size is 15 GB. And now this weekend I found the problem where the subscription try to apply the whole snapshot (15 GB! ).

I don't know what to do

PD Sorry for my english.

View 2 Replies View Related

Does Link In Subscription Point To Live Or Snapshot?

Mar 19, 2007

This should be an easy one...

You get an email that contains a link to a report. The email was sent automatically as part of a subscription.

Does that link point to a snapshot that was taken when the report was run, or does clicking the link cause the report to re-run altogether?

Thanks,
Dan

View 3 Replies View Related

Initializing A Merge Subscription Without A Snapshot Bugs

Feb 21, 2007

Hello guys,

We have customers that are using web synchronization. Could you, please tell us when service pack for the bugs, discussed in thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=689428&SiteID=1 will be reliazed?

What replication participants should apply the service pack in a configuration where Subscriber (MS SQL 2005 Express)  gets synchronized with Publisher/Diustributor (MS SQL 2005 Standard)?

 Thanks.

 Alexander.

View 3 Replies View Related

Snapshot Executes But Subscription Does Not Email To User

Sep 6, 2006

I have a problem with a report set up to execute a snapshot and subscription on day 1 of each month. On July 1, it ran and was emailed to the user; on 8/1 it created the snapshot but did not send to the user because of a user error in the subscription, so it was sent manually. the parameters issues were corrected and on 9/1 the snapshot executed but the subscription did not send. In the subscription window, the last good email of a snapshot was sent 7/1. So again 9/1 was sent manually. After fixing the parameters shouldn't this have emailed the snapshot correctly on 9/1?

Do I need to delete this subscription and create a new one to get it to send on 10/1 now?

any suggestions?

the set up is now verified to be identical to other reports which created a snapshot and emailed successfully, the only difference is the original problem with only the 7/1 subscription the only one you see when you look at the "subscription tab" for this report in Reporting services:

Description:Send e-mail to name.one@plife.com, name.two@plife.com

Trigger:SnapshotUpdated

Lastrun: 7/1/2006 7:00 AM

Mail Sent to:Mail sent to name.one@plife.com, name.two@plife.com

Snapshots successful






5/1/2006 7:00:02 AM



6/1/2006 7:00:03 AM



6/1/2006 8:26:31 AM



7/1/2006 7:00:07 AM



8/1/2006 7:00:24 AM



9/1/2006 7:00:19 AM




Logfile for "Ops Specialists/1035 Exchange Issue - Details (200407-R01)" report
Portion of log file:
ReportingServicesService!dbpolling!f!9/1/2006-07:00:04:: EventPolling processing item e869f577-b189-4e6a-a9be-37b61d737340
ReportingServicesService!dbpolling!13!9/1/2006-07:00:04:: EventPolling processing item 2b275311-0ee4-4cef-972d-86de48f4f360
ReportingServicesService!dbpolling!c!9/1/2006-07:00:04:: EventPolling processing item 3df3960a-ee28-4d5e-a46e-326ab5a0060d
ReportingServicesService!library!c!9/1/2006-07:00:04:: Schedule e11a00d3-56b6-46b3-b2d3-9e3156805be8 executed at 9/1/2006 7:00:04 AM.
ReportingServicesService!library!13!9/1/2006-07:00:04:: Schedule 177e9473-2c81-4152-a89f-137d25a556e1 executed at 9/1/2006 7:00:04 AM.
ReportingServicesService!library!4!9/1/2006-07:00:04:: Schedule 89071f26-435c-4cc7-bd9a-23907ef32b5c executed at 9/1/2006 7:00:04 AM.
ReportingServicesService!library!f!9/1/2006-07:00:04:: Schedule 3720d20c-460e-4549-9b57-c3cc97919f5f executed at 9/1/2006 7:00:04 AM.
ReportingServicesService!schedule!13!9/1/2006-07:00:04:: Updating report execution snapshot for report /Client Services/Ops Specialists/1035 Exchange Issue - Details (200407-R01)
ReportingServicesService!schedule!c!9/1/2006-07:00:04:: Updating report execution snapshot for report /Client Services/Ops Specialists/1035 Exchange Bridged - Details (200407-R01)
ReportingServicesService!schedule!f!9/1/2006-07:00:04:: Updating report execution snapshot for report /Client Services/Ops Specialists/Policy Counts (200401-R01)
ReportingServicesService!schedule!4!9/1/2006-07:00:04:: Updating report execution snapshot for report /Client Services/Inforce Admin/CAAB226 (200501-R03)
ReportingServicesService!dbpolling!d!9/1/2006-07:00:08:: EventPolling processing 4 more items. 8 Total items in internal queue.



View 8 Replies View Related

Adding Push Subscription For Snapshot Replication

Jan 7, 2008

Hi all,

I've been looking for the right stored procedure to create a push subscription for publication but i haven't had much luck so far. So I was wondering if you guys know which SP is appropriate, that'd be super great!! thanks guys!

note. the sp should run on the subscriber database.

thanks again

View 2 Replies View Related

Setting Up Sql Mobile Subscription

Apr 19, 2006

I am working on settin up a subscription to a publication that i made of the AW database. when running the subscription wizard i get an error on the sycronization of data part. the error states "A request to send data to the computer running IIS has failed HRESULT 0x80072EE7(28037)" i have the URL on the Web Server Authentication page of the wizard set to http://localhost. can anyone help me out on this one?

thanks

View 7 Replies View Related

Report Email Subscription Based On Snapshot Update

Dec 21, 2007

Hi Everyone,

I want to receive some reports by email every time the datawarehouse refreshes its content. The data warehouse is being refreshed on a daily basis but the exact time varies between 9:30 am and 11:30 am.

I have created the 4 reports in reporting services and set the execution property of each report to



Render this report from a report execution snapshot




and then created 4 subscriptions for email delivery based on processing option
When the report content is refreshed

In an Integration Services package I have 4 Script steps (VB.net) that perform an UpdateReportExececutionSnapshot for each of the reports.

The problem is that these steps fail in a random order every time the package runs. Sometimes they all run fine , but then one or two fail with timeout error. So the emails are not being sent.

I am currently using SQL Server 2005 SP2.

If anyone has an idea on this issue, please let me know.

Best Regards

View 4 Replies View Related

SQL Server Mobile Subscription Problem

Jun 30, 2006

Hi,

i have created publication on server.and when i try to create sql server mobile subscription on my machine, i get following error:

TITLE: Microsoft SQL Server Management Studio
------------------------------

A request to send data to the computer running IIS has failed. For more information, see HRESULT.
HRESULT 0x80072EE2 (28037)

------------------------------
BUTTONS:

OK
------------------------------

my machine and server are on different.

i am able to get "SQL Server Mobile Server Agent 3.0" message when i run  http://<server_name>/<virtual_dir>sqlcesa30.dll through Internet explorer
what should i do now.please help me

 

View 1 Replies View Related

Can't Drop SQL Mobile Subscription At Publisher

Oct 3, 2006

I have a program running on Pocket PCs that synchronizes with a desktop SQL database using SQL Mobile. My problem is that I can't delete old subscriptions from the publication; now the publication has 25 subscriptions and won't accept any more (limit of SQL Workgroup edition). I can delete non-SQL Mobile subcriptions just fine.

Running sp_replmonitorhelpsubscription provides this information:

subscriber: LVCONTACTSMERGE - 5FA305234F0C
subscriber_db: Program FilesPocketLVContactsLVContacts.sdf
publisher_db: LVContacts
publication: LVContactsMerge

So I set up this bit of code:

USE LVContacts
EXEC sp_dropmergesubscription
@publication = 'LVContactsMerge',
@subscriber = 'LVCONTACTSMERGE - 5FA305234F0C',
@subscriber_db = 'Program FilesPocketLVContactsLVContacts.sdf',
@subscription_type='all';
GO

No errors are reported, but the subscription doesn't get deleted.

I've tried shutting down SQL Server Agent (mentioned in another thread); makes no difference.

Any ideas?

--Evan

View 5 Replies View Related

Problem Downloading The Snapshot Agent In A Merge Pull Subscription.

Jun 21, 2007

Hello.

I've been having an error when downloading the snapshot agent from our Publisher.

The articles selected are all the tables and all the stored procedures.

The Subscription is created programmatically and so is the synchronization. When trying to synchronize for the first time and when the subscriber tries to download the snapshot I have the following error:




Error messages:
The schema script 'Distrito_2.sch' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
Get help: http://help/MSSQL_REPL-2147201001
The process could not read file 'GESZifuncAFRODITE$SILVITEST_GESZIF_GESZIF20070621182845Distrito_2.sch' due to OS error 3. (Source: MSSQL_REPL, Error number: MSSQL_REPL20143)
Get help: http://help/MSSQL_REPL20143
The system cannot find the path specified.
(Source: MSSQL_REPL, Error number: MSSQL_REPL3)
Get help: http://help/MSSQL_REPL3



The snapshot folder is at c:GESZifSnapshotFolder and the unc is \AfroditeSnapshot.

I'm getting a little desperate with this because we really need to propagate the schema changes around the subscribers.

Thanks in advance,

AVD

View 4 Replies View Related

Transactional Replication - Pull Subscription Snapshot Being Applied Continuously

Jan 25, 2007

Hi

We have setup transactional replication between 2 databases on SQL Server 2000 SP3a  (~70GB), using a concurrent snapshot (to prevent locking out of the live database) to initilaise the data and a pull subscription from the second database.

From analysing the msdistribution_history table in the distribution database on the subscriber it appears that the snapshot is being applied in a continuous loop to the subscriber database. Viewing the comments column in the msdistribution_history table we can see the following sequence of events occuring

Initialising
Applied script 'snapshot.pre'
Then it applies all the schema files .sch
Then it applies all the index files .idx
The it bulk copies the data in (bcp)
Then it creates the Primary Keys
Then it applies all the trigger files .trg
Then it applies all the referential integrity files .dri

These all complete successfully but then the process kicks off again immediately after reapplying the snapshot.  We are unaware of any settings that may be causing this.

Any help on what maybe causing this would be much appreciated.

 

 

View 5 Replies View Related

Unable To Create SQL Server Mobile Subscription

May 1, 2006

I have been following Creating a Mobile Application with SQL Server Mobile:

http://msdn2.microsoft.com/en-us/library/ms171908.aspx

I have successfully created the snapshot.

When performing the following:

Configure the publication for Web synchronization






In SQL Server Management Studio, in Object Explorer, expand the (local) computer node.


Right-click the Replication folder, and then choose Configure Web Synchronization

There is no option when Right-clicking the Replication folder under my local server, however there IS an option for Configuring Web Synchronization on the Replication folder under SQL Server Mobile. (Unfortunately the Configure the publication for Web Synchronization is listed BEFORE the SQLServer Mobile Task, so it is pretty confusing) So, assuming this is what the author meant, I successfully configured the Web Server and the SQLMobile shows under my default web site.



When I attempt to create a Subscription under SQLServer Mobile, I get the following error:



- Synchronizing Data (Error)



Messages

Unexpected HTTP status returned. [ 415,status = ]
HRESULT 0x80004005 (28632)


The operation could not be completed.


Am I missing something? Should the web configuration be done on my local SQL Server, not the SQLServer Mobile replication directory? If so, how come I do not have that option as suggested in the directions?

I have checked and rechecked permissions. As I mentioned, the snapshot is successfully created (verified by Right-clicking the publication and viewing the snapshot agent status)



View 9 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

Web Sync And Partitioned Snapshot - Failed From Time To Time. Why?

Oct 17, 2006

Hi!

Well..

There's operable web sync with parameterized filter.

But sometimes the strange errors appear.

Below the list of the errors I got from ComErrorCollection property of MergeSynchronizationAgent instance:
ERROR: -2147199433
SOURCE: Merge Replication Provider(Web Sync Server)
TEXT: The Merge Agent was unable to start the SQL Server Agent job to generate the partitioned snapshot for this subscription. Verify that the SQL Server Agent service is running at the Distributor.

ERROR: 22022
SOURCE: HOST3MAIN
TEXT: SQLServerAgent Error: Request to run job dyn_HOST3MAIN-Customers-Main-2__20061014_14 (from User distributor_admin) refused because the job is already running from a request by User distributor_admin

ERROR: 20633
SOURCE: HOST3MAIN
TEXT: Failed to start the dynamic snapshot job. Verify that the SQLServerAgent service is running on the distributor.

ERROR: 20628
SOURCE: HOST3MAIN
TEXT: Failed to generate dynamic snapshot.



I'm sure that SQL Server Agent is running...

What is the reason and how it can be solved?

Thanks

Paul

View 6 Replies View Related

Dynamic Snapshot Agent Error

Feb 17, 2006

I am setting up a large number of Push subscribers to a single publication. because of the large number of subscribers, I am not doing the merge with agent jobs, but with SQL RMO. All works well, but from time to time I am getting a funny error when I add a event handler to the snapshotagent, to return the messages, if some feedback to the screen on how the process is getting along.

The error also happen when the process is al most done. Basically when I am not compiling in this line, then NO error.

//Add the Event Handler to receive the Status changes

DynamicSnapshotAgent.Status += AgentEvent;

But once I started getting the error, then it would not go away, sometimes if the publication & subscribers is recreated it goes away but not always, first do not use the event anymore, and at some stage I can put is back after a few succesful dynamic snapshot, then I can enable the event and it will work again........

Any help welkom

Regards

Gertus





Error:

The replication agent had encountered an exception.
Source: Unknown
Exception Type: System.InvalidOperationException
Exception Message: Operation is not valid due to the current state of the object.
Message Code: Not Applicable

View 7 Replies View Related

How To Sync Mobile Database And Ms-access Database?

May 10, 2007

Hi,
i am working with windows mobile Cf 2.0 and desktop. i got problem when i were trying to synd mobile database and ms-access database.
my requirement is online i want to transfar data records from mobile to desktop vice versa.
but how? i dont knwo any body would like to guide me.
i am ready to accepting yours valuable views.
waiting
bye
Rajat.

View 9 Replies View Related







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