Merge Replication SQL Mobile Subscriber To Cluster (What Is Best)
Hi All
I have been using some of the basic feature of merge replication from an sql mobile subcriber for some months now with good success. We need to however create a cluster server scenario for other requirements of the project. We have tester our system with both NLB and MSCS cluster setups.
What is the best option for compact merge replication and how can this best be achieved to attain load balancing and failover using a cluster server?
Nick
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
SQL Server Mobile 2005 Merge Replication Problem On Windows Mobile 5.0
Dear ppl, I am writing an application for a device (MDA Pro T-Mobile) having Windows Mobile 5.0 using -MS .NET Compact Framework 2.0 SP-1 -SQL Mobile 2005. -VS 2005 .NET The application uses Merge Replication. The error occurs in the Synchronise() Method of the SqlCeReplication object. "SQL Server Mobile encountered problems when opening the database." repl.AddSubscription(AddOption.CreateDatabase); repl.Synchronize(); I don't understand why I am having this error. It does create the database on AddSubscription() method but it is failing opening the database on Synchronise(). I have also tried uninstalling and then reinstalling all the SQL Mobile components in the following order. -sqlce30.wce5.armv4i.cab -sqlce30.repl.wce5.armv4i.cab -sqlce30.dev.ENU.wce5.armv4i.cab However, when i run this application on a device(Dell X50 AXIM) with Pocket PC 2003, it runs fine creating the database and sysnchronising it. The target platform for the project is Windows Mobile 5.0 Pocket PC SDK. Does any one have any clue what could be the problem ? Regards Nabeel
View Replies !
View Related
Merge Replication Subscriber
SQL Server 7.0 SP3 I am using the "Pull Subscription Wizard" to set up merge replication. I go through all the steps of the wizard and then I hit "Finish" at the end. When it gets to the third step (Creating the Subscription), I get the old: __________________________________________________ _________ mmc.exe has generated errors and will by closed by Windows. You will need to restart the program. An error log is being created. __________________________________________________ _________ This happens whether I try to do this from my PC or from the actual server I am creating the subscription on. Has anyone else had this issue? Is there a hotfix I need? Any help is appreciated. Thanks, Craig
View Replies !
View Related
Push Subscriber In Merge Replication
I am using merge replication with a push subscription type. I am wondering if the updates of the tables on the subscriber side are push to the publisher from the subscriber or pulled from the subscriber by the publisher when the syncronisation takes place. this makes a big diferrence for me and i can't find the answer to this question anywhere... if anyone could answer it would be really appreciated Thanks
View Replies !
View Related
Merge Replication Subscriber Status
Hi. I have setup an SQL Server 2005 Merge Replication. Now I need to display the status of the replication programatically from the subscriber side, I have checked the documentation which mentions MergeSubscription & MergeSubscriberMonitor but I couldn't know how to use them!! Any Help ? Thanks
View Replies !
View Related
Merge Replication - Subscriber Error
Hi, I have setup merge replication between SQL Server 2005 and SQL Server Express. The setup uses web synchronization. (And the setup uses dynamic filter HOST_NAME) On some of the client machines, replication fails with the following error (when initializing the subscription): from subscriber merge agent verbose log: A dynamic snapshot will be applied from 'D:DOCUME~1JBAUMG~1.CORLOCALS~1TempDB101-EQA-SCL_BQDB_BQ_PUB_BQDB' Validating dynamic snapshot 2007-04-1819:39:45.434 OLE DB Subscriber 'FRG-BAUMGARTENJSQLEXPRESS': sys.sp_MSregisterdynsnapseqno @snapshot_session_token=N'\XXX.XX.XX.XXSnapshotuncDB101-EQA-SCL_BQDB_BQ_PUB20070417180079dynsnap', @dynsnapseqno='5599F67E-A1A9-4573-A14F-9851F6FE4B51' (Note: XXX.XX.XX.XX is a proper IP of DB, I have just masked it in the post) 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. I enabled verbose logging for the snapshot agent for the subscriber, but there was no error there. It is obvious from the log info above that the error occurs only after downloading the snapshot to the client and during applying it to the subscriber by the merge agent. After I got this error, I tried running the subscriber program again and it successfully replicated on the third attempt. But this behavior is not consistent and it fails for most of the time on some of the machines Any info on this error?
View Replies !
View Related
Deletes On Subscriber In Merge Replication
Using Merge replication between SQL Server 2000 and SQL Server CE, is there any way that row deletes could occur on the subscriber without a reinitialize or explicit delete of row on publisher. More specifically, if there is a row filter that returns a days worth of data with each days pull, for example, and the filter looked like select <columns> from Table where UpdateDate < GETDATE() and UpdateDate >= DATEADD(d,1,GETDATE()) would there be some implicit delete at subscriber each day because data sent changed? My research indicates this does not happen, but I have a colleague who thinks differently.
View Replies !
View Related
Merge Replication Issue With Records Not Being Copied To Subscriber
I have an issue with merge replication between sql2005 sp2 and spl2000 sp4 the merge replication runs fine to 6 other sql servers but the sql2000 sp4 server has a lot of locking going on, but the merge replication doesnt fail it just loses several hundred records without notifying me I have to manually copy the missing records every week or so I have dropped the replication and rebuilt it twice but it still happens
View Replies !
View Related
Merge Replication: Missing Rows At Subscriber With No Conflicts
Hi all, We are using a mix of SQL 2005 and 2000 servers and our "main" database server is running SQL 2005 x64 (SP2 ver. 3042). Our system has run perfectly for months, then subsequent to an SP2 update we are seeing several instances where the data record counts are different for several tables among all the servers. We are using Merge Replication, with no filters and published every 2 minutes. Any ideas? TIA, Michael
View Replies !
View Related
Purging Records From Subscriber/publisher Database In Merge Replication
Are there any standard approaches used to purge records from databasein merge replication senario ?We are using merge replication between two sql server 2000 databases.These databasess have differnt purging frequencies ( purging frequencyof subscriber database is 6 month where as that of publisher is year).Is there anyway to purge data from subscriber and publisher withoutgetting these deletion reflected in replication ( basically deletingrecord bypassing the replication).
View Replies !
View Related
Merge Replication Error: The Schema Script '....sch' Could Not Be Propagated To The Subscriber
I tried setting up a Merge Replication between a MSDE (PullSubscription) and Sql Server 2000 (Publisher) and got the followingerror:The process could not enumerate changes at the 'Subscriber'.Then I created another subscription, but this time, a PUSH, and thistime I got the error "The process could not connect to Subsciber".I tried creating a second PULL Subscription, but the error I got was:The schema script '....sch' could not be propagated to the subscriberAnyone have any ideas how to fix this?Thank you.
View Replies !
View Related
Merge Replication Subscriber Error: Invalid Cursor State
These errors occur at the subscriber. First, "The merge process could not query the last sent and received generations" is generated, then immediately afterwards, "invalid cursor state" is generated. We are trying to pull a new subscription snapshot from the republisher. The subscriber has been added and removed from the replusher's pull subscriptions a number of times for testing. Now, we cannot get the subscriber to re-sync with the republisher. Any ideas?
View Replies !
View Related
Error While Propagating Initial Snapshot To Subscriber (Merge Replication)
Hi all. I get the following error when trying to run a pull subscription from the subscriber: The schema script '' could not be propagated to the subscriber. (Source: Merge Replication Provider (Agent); Error number: -2147201001) --------------------------------------------------------------------------------------------------------------- The process could not connect to FTP site 'ftp://ESOFTSERVER.NO-IP.INFO' using port 21. (Source: ESOFT (Agent); Error number: 0) --------------------------------------------------------------------------------------------------------------- The connection with the server was reset (Source: (OS); Error number: 12031) --------------------------------------------------------------------------------------------------------------- I've tried everything I could to solve this problem, but I can't get it working. Thanks for any advise. Fabio Reynoso
View Replies !
View Related
URGENT Merge Replication: Missing Rows At Publisher And Subscriber: No Conflicts
We have SQL Server 2000 with merge replication at a Publisher and subscriber. We have some records getting deleted at Publisher and Subscriber and no conflicts are logged. We have tried the compensate_for_errors setting and this has had no effect. This is causing serious data corruption and has now become an URGENT issue. Out tech team are almost out of ideas. Has anyone experienced this or have any ideas as to what to check next?
View Replies !
View Related
Using Row Filtering In SQL Mobile Merge Replication
Hi,, I understand that it is possible to set filters dynamically using functions 1) SUSER_SNAME() 2) and HOST_NAME(). SUSER_SNAME() returns the login credentials used in the subscritption. HOST_NAME() returns the host machine and can be overloaded with buisiness information. My application should work as below; 1) User enters the login credentials. 2) Some information as the User name passed to server and if the user name is valid , the rows related to this particular user get downloaded to device. A new user is added directly in the Users table in master database. My questions are : 1) If I have 3000 users , should I create 3000 subscriptions with 3000 HOSTName or Login credential information to differentiate btween users? 2) If yes , other than using the wizard is there any scripts available to create large number of subscription? 3) If add subscription programatically , should I re-initialise subscription for each new user which is assigned with a diferrent host name value? my current code looks like this SqlCeReplication repl = new SqlCeReplication(); repl.InternetUrl = @"http://100.000.000.000/test/sqlcesa30.dll"; repl.Publisher = @"something"; repl.PublisherDatabase = @"something"; repl.PublisherSecurityMode = SecurityType.DBAuthentication; repl.PublisherLogin = @"sa"; repl.PublisherPassword = @"something"; repl.Publication = @"somethingPublisher"; repl.Subscriber = @"something"; repl.HostName = @"newuser"; // The user name entered in the login form assigned to Hostname property. repl.SubscriberConnectionString = @"Data Source=""Program Files esthost.sdf"";Max Database Size=128;Default Lock Escalation =100;"; try { repl.ReinitializeSubscription(true); repl.Synchronize(); repl.Dispose(); } Please advise -Aneesh
View Replies !
View Related
Merge Replication With SQL Mobile 2005
We are using SQL 2005 (SP1) and mobile agents with SQL Mobile. We are seeing an excessive number of updates after a device's database is reinitialized. My understanding was that if I generate a new snapshot or reinitialize all subscriptions (from the server), the devices would only get what the database looks like right now (inserts only) after syncing and/or reinitializing, but they are actually getting the right number of inserts and a huge number of updates in Replication Monitor. Any ideas? Thanks! Mike
View Replies !
View Related
Merge Replication Using Wins Mobile 5.0
Hi all, I have developed a mobile program with sql server 2000 merge replication. It works fine in Win mobile 2003 OS, but, not working at all after I upgrade the mobile OS to Win mobile version 5.0 Does anyone have any idea at all what's going on? Thanks a lot. AngelaC
View Replies !
View Related
Merge Replication Using SSL On A Windows Mobile 5.0 Device
Dear ppl, I have a windows mobile 5.0 application that syncronises with SQL Sever 2005 (Merge Replication). The replication works fine without SSL. But when using SSL it doesn't work .On the device i get an error 28037, A request to send data to the computer running IIS has failed. I have created a a Wild Card Certificate (*.domain-name.net) using Microsoft Certificate Services (Stand Alone) and setup the replication website with replication virtual directory under it , in IIS, to use this certificate. The host header for the replication site is set to "sql.domain-name.net". I have binded the host headers to the port as well. I can access the https://sql.domain-name.net/replication/sqlcesa30.dll from remote computer and device and it says Microsoft SQL Server Compact Edition Server Agent, that means it is setup correctly. I have installed the certificate authority and its wild card certificate on the device Root Certificates. Now when I call repl.syncrhonise() from device .. it throws exception with error 28037, A request to send data to the computer running IIS has failed. which i think means, it can't find the service url. I am not sure what is the problem..something to do with Trust - SSL certificates... Is there any thing i am missing ? Awaiting,
View Replies !
View Related
Merge Replication Problem On Windows Mobile 5
Hi, I developed a mobile application (CF 2.0) that uses merge replication to synchronize data between SQL Server Mobile and SQL Server 2000 SP4. The application uses asynchronous synchronization (BeginSynchronize method) to initiate the replication and update the user about the progress. The application worked perfectly on PPC2003 and Windows CE .Net 4.2 platformes. The problem started when I moved it to WM5 platform. We're using Symbol MC70 devices. When I start the replication for the first time it synchronizes without a problem. If I perform additional synchronizations(updates) it synchronizes without a problem. If I exit the application and start it again the sync process hangs when I try to synchronize it(to deliver updates). Any ideas? Thank you
View Replies !
View Related
Locking Up After SQL Server Mobile Merge Replication
Hi , I would like to get your advice in an issue that I am facing regarding merge replication. The flow is like: 1) User enter his login name and password. 2) Host_name is set as the login name that the user enters. 3) Based on the HOST_NAME property after filtering user gets the records relevent only to him (Differnet subscriber may use same mobile device). 4) He make some changes in the local sdf according to the business logic. 5) The application Syncs with server on the next login session. My issue is when I am trying to run the application in emulator exactly at the sdf updating part the application terminates. Error mess: Connection to Remote Device has been lost..... If I execute the same sql insert query it works om the local sdf and master database. Emulator used where Pocket PC 2003 SE and Windows Mobile 6 classic emulator. I have installed 1) Visual Studio 2005 SP 1 2) net compact framework SP2. When I comment all the code related to Sync ,application works witout any issue. And the same application works in my "I mate kjam". The code that I use is given below: ========================================================================== public void Sync(string hostname, int newsub) // Parameters for HOSTNAME and flag to denote new user or existing //user. { SqlCeReplication repl = new SqlCeReplication(); repl.InternetUrl = @"http://231.000.000.211/Merge/sqlcesa30.dll"; repl.Publisher = @"SERVER"; repl.PublisherDatabase = @"Merge"; repl.PublisherSecurityMode = SecurityType.DBAuthentication; repl.PublisherLogin = @"sa"; repl.PublisherPassword = @"password"; repl.Publication = @"Merge"; repl.Subscriber = @"MergeSub"; repl.HostName = hostname; repl.SubscriberConnectionString = @"Data Source=""Program FilesMerge.sdf"";Max Database Size=128;Default Lock Escalation =100;"; try { if (newsub == 0) { if (File.Exists(@"Program FilesMerge.sdf")) { File.Delete(@"Program FilesMerge.sdf"); } repl.AddSubscription(AddOption.CreateDatabase); repl.Synchronize(); repl.Dispose(); MessageBox.Show("newuser sync Done"); } else { if (!File.Exists(@"Program FilesMerge.sdf")) { repl.AddSubscription(AddOption.CreateDatabase); repl.Synchronize(); repl.Dispose(); MessageBox.Show("FirstSync Done"); } else { repl.Synchronize(); repl.Dispose(); MessageBox.Show("SameuserSync Done"); } } ================================================================================= Please advise......
View Replies !
View Related
Merge Replication Between SQL Server 2005 And SQL Mobile
Hi, I'm currently investigating the feasibility of having SQL Mobile on a number of devices running Windows CE. These devices will have to synchronize with the server (either using merge replication or RDA) over GPRS. The problem I have is that some of these devices will never be online. Is there are a way of synching these offline devices? The model I had in mind was using a USB key (or some other storage device) to download the latest updates from an online device and transferring this data to the offline device, and vice versa e.g. from offline to online and then merging. Is this feasible? Thanks Csharper
View Replies !
View Related
SQL 2005 Mobile Merge Replication Size Limits?
I am in the process of testing a SQL 2005 Std x64 server with merge replication using Windows Mobile 5.0 clients and SQL 2005 Mobile. The test DB is a copy of the currently active DB, but has been expanded to include some new tables to support planned application functionality extensions. Once the publication exceeds 97 Articles, the error is thrown that "The buffer pool is too small or there are too many open cursors". If I drop one article everything is fine. I ran a test with dummy DB that had 100 blank tables, and this initialized just fine on the client. The additional articles I am publishing (the 98th table) is also empty, but it throws the error anyway. Is there a limit on the total size/number of changes that can be sent? Since I have run tests sending over 64,000 changes to a client during initialization this does not seem to be the case (I am only attempting a little more than 9,700 changes on this initialization). Some other ideas that have been tested without success are to stop the user triggers from propagating, and toggling the AWE setting for SQL. The Replication Monitor does say the client completes replication, and it seems to choke at the very end of completing replication when it attempts to write to the tracking tables. The last successful action is sys.sp_MSadd_merge_history90, and it appears to be acting on the last table added to the publication. There does not appear to be a limit on the number or articles, since I can publish more articles in a dummy DB than I am able here, so it seems to be something to do with size. Any information would be helpful, this is a very frustrating issue. Thanks!
View Replies !
View Related
High CPU Utilization On Merge Replication With SQL 2005 Mobile
I have a question for anyone who mas some tips/pointers for optimizing SQL merge replication publications. The front end web server is running IIS 6.0 on Windows 2003 x86 Server Standard (Server A). The back end database server is running SQL 2000 Standard on Windows 2003 x86 Standard (Server B). The merge replication clients connect via HTTPS over the Internet from a custom C#.NET 2005 application using SQL 2005 Mobile running on Windows Mobile 5.0 (Client). The publication itself has several filters on it. The entry point uses the user's Windows username to start the filter. Based on the user, it then filters the records in multiple tables. There are 68 articles and 44 filter statements. The filters extend multiple layers deep, in other words they are not all filtering off the HOST_NAME() variable, some tables filter from records in tables that filter from the HOST_NAME() variable. The publication is set to minimize data sent to the clients, and considers a subscription out of date if it has not synced in the last 4 days. All the rowguids are indexed as well. There are approximately 35 clients actively using the application at any given time. On average, a client will initiate a merge replication 3-4 times per hour from 8am-5pm. Generally, a sync will take between 10 seconds and 2 minutes to complete, with most of them being around 30 seconds on average. When a client starts a sync, there is a spike to about 50% on the server's CPU graph. If multiple clients attempt to sync at the same time the CPU utilization can be pushed to 100% for extended periods (more than 30 seconds). I recently completed a project to increase the bandwidth available to the clients, and plan to reduce the number of filters significantly (although this will obviously increase the amount of data going to the clients and the storage needs on the individual devices). I also plan on changing the setting to not minimize the amount of data sent to the clients. Having said all that, does anyone have any information about how to further optimize merge publications to mobile clients? The next publication will be on SQL 2005 x64 Standard if I can solve the issues in the text environment. I would like to enhance the publication as much as possible to make the end user experience better than it currently is. Thanks!
View Replies !
View Related
SQL Mobile Fails To Send Data To IIS - Merge Replication
This is just too simple. I must be doing something wrong. I have tried everything, redoing the SQLMobile merge publication, setting permissions, and need help ASAP. The basic test with the http://localhost/sqlmobile/sqlcesa30.dll returns the message: SQL Server Mobile Server Agent 3.0 I have tried the merge replication with both my local SQL Server 2005 installation and a remote development box. Both instances return the same error. I am able create and replicate a database using the sample application: http://msdn2.microsoft.com/en-us/library/ms171908.aspx However, another simple applications fails to synchronize when simply using the following code block: Dim repl As New SqlCeReplication() repl.InternetUrl = "http://xens/sqlmobile/sqlcesa30.dll" repl.Publisher = "xena" repl.PublisherDatabase = "SQLMobile" repl.PublisherSecurityMode = SecurityType.NTAuthentication repl.Publication = "SQLMobile" repl.Subscriber = "sqlmobile" repl.SubscriberConnectionString = _ "Data Source='" + filename + "';Password='';" _ & "Max Database Size='128';Default Lock Escalation ='100';" repl.AddSubscription(AddOption.CreateDatabase) repl.Synchronize() Here is the error message: Error Code: 80072EE7 Message: A request to send data to the computer running IIS has failed. For more information, see HRESULT. Minor Err. 28037 Source Microsoft SQL Server 2005 Mobile Edition -------------------------------------------------------------------------------------- Here is the full code sample: Imports System.Data.SqlServerCe Imports System.Text Public Class Form1 Private engine As SqlCeEngine Private repl As New SqlCeReplication() Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load engine = New SqlCeEngine() engine.LocalConnectionString = "Data Source=""sqlmobile.sdf"";Max Database Size=128;Default Lock Escalation =100;" engine.CreateDatabase() <- First method creates database engine.Dispose() engine = Nothing repl.InternetUrl = "http://xena/sqlmobile/sqlcesa30.dll" repl.Publisher = "xenaSQL2005" repl.PublisherDatabase = "SQLMobile" repl.PublisherSecurityMode = SecurityType.NTAuthentication repl.Publication = "SQLMobile" repl.Subscriber = "SQLMobile" repl.SubscriberConnectionString = "Data Source=""sqlmobile.sdf"";Max Database Size=128;Default Lock Escalation =100;" Try 'repl.AddSubscription(AddOption.CreateDatabase) <- this method fails also repl.AddSubscription(AddOption.ExistingDatabase) repl.Synchronize() <-- Code fails here with the error message shown. Catch err As SqlCeException ShowErrors(err) 'MessageBox.Show(err.ToString) End Try End Sub Public Sub ShowErrors(ByVal e As SqlCeException) Dim errorCollection As SqlCeErrorCollection = e.Errors Dim bld As New StringBuilder Dim inner As Exception = e.InnerException Dim err As SqlCeError If Not inner Is Nothing Then MessageBox.Show(("Inner exception: " & inner.ToString())) End If ' Enumerate each error to a message box. For Each err In errorCollection bld.Append((ControlChars.Cr & " Error Code: " & err.HResult.ToString("X"))) bld.Append((ControlChars.Cr & " Message : " & err.Message)) bld.Append((ControlChars.Cr & " Minor Err.: " & err.NativeError)) bld.Append((ControlChars.Cr & " Source : " & err.Source)) ' Retrieve the error parameter numbers for each error. Dim numPar As Integer For Each numPar In err.NumericErrorParameters If 0 <> numPar Then bld.Append((ControlChars.Cr & " Num. Par. : " & numPar)) End If Next numPar ' Retrieve the error parameters for each error. Dim errPar As String For Each errPar In err.ErrorParameters If [String].Empty <> errPar Then bld.Append((ControlChars.Cr & " Err. Par. : " & errPar)) End If Next errPar MessageBox.Show(bld.ToString()) bld.Remove(0, bld.Length) Next err End Sub End Class Thanks in advance....
View Replies !
View Related
Merge Replication 32-bit IIS - 64-bit SQL Server 2005 -Windows Mobile 5 Device
We have setup a 32-bit IIS server on a 32-bit machine. Installed necessary SQL Server components (32-bit replication components). We have installed SQL Server 2005 64-bit SP1 with latest hotfixes on a 64-bit machine. On the Mobile device we installed SQL Server 2005 Mobile. When we start mergereplication the problem we have is error 28009 (An instance of the SQL Server Reconciler cannot be created) on the mobile device. I read allot about it, but still have a questetion. Should this work? I found the doc: SQL Server 2005 Upgrade Technical Resource Guide: Note: If your upgrade involves SQL Server CE subscribers, you must perform additional actions on the IIS server. You will need to install SQL Server 2005 client connectivity components along with SQL Server Mobile Edition components on the IIS server. You will also have to replace sqlcesa30.dlll, sqlcerp30.dll, and all the replication components on the IIS server. From this I conclude it should work or is the doc in error? If it does not, what can we do? 32-bit SQL Server 2005 on the 64-bit machine should work. (Can a 64-bit SQL Server 2005 run alongside 32-bit SQL Server 2005?). Beste regards, Hans Mank
View Replies !
View Related
SQL Server Mobile 2005 Merge Replication Failing Over SSL, But Can Browse Through Pocket IE.
Hi All, this system is scheduled to go live in near to a day... but i have hit an issue when switching on SSL. Any help would be greatly appreciated. Device Env: Windows Mobile 5.0 + Messaging and Security Feature Pack SQL Server Mobile 2005. Merge replication works fine without SSL. After running the Configure Web Sync wizzard to setup SSL merge replication no longer works. Note i checked using pocket IE by browsing to https://mycompany.com/pub/sqlcesa30.dll?diag and all worked fine. There was no prompt saying the cert was bad etc. The certificate is a: Equifax secure global ebusiness CA-1 cert. Signature algorithm md5RSA public key RSA(1024 bits) thumbprint algorithm sha1 Stacktrace given is: - ex {"A request to send data to the computer running IIS has failed. For more information, see HRESULT."} System.Data.SqlServerCe.SqlCeException - Errors {System.Data.SqlServerCe.SqlCeErrorCollection} System.Data.SqlServerCe.SqlCeErrorCollection Count 1 Integer Item In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user. System.Data.SqlServerCe.SqlCeError HResult -2147012858 Integer InnerException Nothing System.Exception Message "A request to send data to the computer running IIS has failed. For more information, see HRESULT." String NativeError 28037 Integer Source "Microsoft SQL Server 2005 Mobile Edition" String StackTrace "at System.Data.SqlServerCe.NativeMethods.CheckHRESULT() at System.Data.SqlServerCe.SqlCeReplication.Synchronize() at MyApp.Helper.Replication.SynchronizeInit() at MyApp.CallSynchronize() at System.Windows.Forms.Control.OnGotFocus() at System.Windows.Forms.Control.WnProc() at System.Windows.Forms.ContainerControl.WnProc() at System.Windows.Forms.Form.WnProc() at System.Windows.Forms.Control._InternalWnProc() at Microsoft.AGL.Forms.EVL.EnterMainLoop() at System.Windows.Forms.Application.Run() at MyApp.Program.Main()
View Replies !
View Related
How Do I Measure Bandwith Usage For Merge Replication SQL 2005 To Sql Server Mobile 2005?
Hi, Is there any way to measure bandwith usage during merge replication between sql server 2005 and sql server mobile 2005 running on a cradled wm5 mobile device. Attaching the windows performance monitor to the network connection established over usb would work although I was wondering if there was something specific for this case integrated into Sql server 2005 / sql server mobile 2005 / Sql server management studio / third party tools that i could use ? thnx, pdns.
View Replies !
View Related
Help Needed In Merge Replication, SQL Server 2005 Mobile Edition And VC# 2005
I have written following code in my application I just want to display all the data of a Single table into a Data Grid, I know that we can drag and drop the table on to a form and datagrid is generated, but here I want to retrive those values through my code, how should i do that I am getting following errors while running the program Error 1) Error No. 28037, MS SQL Server 2005 Evrywhere Edition Error: A request to send data to the computer running IIS has failed. For more information see HRESULT Error 2) Error No. 0, SQL Server 2005 Evrywhere Edition ADO.Net Data Provider Error: The specified table does not exist [ JobLists ]. Can anybody please tell me, where I went wrong ??? In this code anywhere else???? Note: While adding a Data Source of SQL Server 2005 Mobile Edition, I have added that .sdf file into my project, thats why I have written the Data Source as : .DbFile.sdf @"Data Source = .DbDotNetCF.sdf"; The code is as follows: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlServerCe; namespace DeviceApplication1 { public partial class Form1 : Form { string filename = @".DbDotNetCF.sdf"; private DataSet dsJobLists; public Form1() { InitializeComponent(); } private void DeleteDB() { if (System.IO.File.Exists(filename)) { System.IO.File.Delete(filename); } } private void Sync() { SqlCeReplication repl = new SqlCeReplication(); repl.InternetUrl = @"http://localhost/WebsiteDotNetCF/sqlcesa30.dll"; repl.Publisher = @"RAHU"; repl.PublisherDatabase = @"DotNetCF"; repl.PublisherSecurityMode = SecurityType.NTAuthentication; repl.Publication = @"PubDotNetCF"; repl.Subscriber = @"SubDotNetCF"; repl.SubscriberConnectionString = @"Data Source='" + filename + "';Max Database Size=128;Default Lock Escalation =100;"; try { if (!System.IO.File.Exists(filename)) { repl.AddSubscription(AddOption.CreateDatabase); } repl.Synchronize(); } catch (SqlCeException ex) { DisplaySQLCEErrors(ex); } finally { repl.Dispose(); } // Display Same Data In Another DataGrid : dataGrid1 SqlCeConnection cn = new SqlCeConnection(@"Data Source='" + filename + "'"); SqlCeDataAdapter daJobLists = new SqlCeDataAdapter("SELECT JobListsID, JobID, PersonID FROM JobLists", cn); if (dsJobLists == null) { dsJobLists = new DataSet(); } try { dsJobLists.Clear(); daJobLists.Fill(dsJobLists, "JobLists"); dataGrid1.DataSource = dsJobLists.Tables["JobLists"]; } catch (SqlCeException ex) { DisplaySQLCEErrors(ex); } } private void DisplaySQLCEErrors(SqlCeException ex) { for (int i = 0; i < ex.Errors.Count; i++) { MessageBox.Show("Index #" + i.ToString() + "" + ex.Errors.Source + "" + "Error: " + ex.Errors.Message, "Error No. " + ex.Errors.NativeError.ToString()); } } private void Form1_Load(object sender, EventArgs e) { Sync(); DeleteDB(); if (DbDotNetCFDataSetUtil.DesignerUtil.IsRunTime()) { // TODO: Delete this line of code to remove the default AutoFill for 'dbDotNetCFDataSet.JobLists'. this.jobListsTableAdapter.Fill(this.dbDotNetCFDataSet.JobLists); } } } } I have created a merge replication correctlly( I suppose, there were no errros) Please help Your help will be appriciated
View Replies !
View Related
Change A Merge Subscriber To Become A Merge Publisher
Hi, I'm using merge replication to maintain a backup copy of my main (publisher)MSDE database. A push subscription periodically (1 per minute) updates the backup DB. It's intended that if the main db goes down then the backup (subscription) db can be configured as a publisher. This must all be performed via scripting. The initial configuration of the main publisher and subscription is controlled via scripting, which works fine. The problems occur when I try to configure the subsciber to become a publisher. A script is executed on the subscriber but fails at the point when it's configuring the publisher detail. The error is something like "unable to configure a publication for a database setup as an anonymous subscription". I'm guessing that there are subscritpion artifacts added to the database which need to be removed before it can be configured as a new publisher. Please help, Jez W
View Replies !
View Related
SQL Mobile 2005 Merge Replication With SQL 2005 X64
I am having trouble with getting Merge Replication up with a new SQL 2005 x64 Server. I already have it running smoothly with SQL 2005 Mobile and SQL 2000, but I want to migrate the backend to SQL 2005. There is a front end server running IIS 6.0 on Windows 2003 x86 Standard (Server A) with SSL required and Basic Authentication set as the only authentication method (default Domain and Realm are also set). The backend server is running SQL 2005 x64 Standard on Windows 2003 x64 Standard (Server B). The mobile devices are running Windows Mobile 5.0 with SQL 2005 Mobile (Client). From both a standard Windows XP workstation (IE) and the Client (PIE) I can browse to the HTTPS site on port 444 for the sqlcesa30.dll on Server A and get a response in normal and ?diag modes. The ?diag gives success in all but the 8.0 Database Reconciler (I didn't install the SQL 2000 replication components on Server A, my understanding is they should not be needed). Sql Server Module Versions are as follows: sqloledb.dll - 2000.86.1830.0, 9.0 replrec.dll - 2005.90.1399.0, 9.0 replprov.dll - 2005.90.1399.0, 9.0 msgprox.dll - 2005.90.1399.0. The publication on Server B is enabled for Web Synchronization and the Snapshop Agent has run. There are no reported errors on that side. Since I ran into issues getting synchronization to run I have opened up permissions fairly wide in this test environment. The PAL and the Database both have the user I am attempting to sync with listed (I am using the Administrator account in the test domain). I have opened full rights on the Snapshot share on Server B to Everyone (both NTFS ACL on the directory and the Share permissions). The virtual directory on Server A containing the sqlcesa30.dll has also been opened very wide, and the Application Pool does have access to it. The Client is running a custom C#.NET 2005 application. With the exception of changes to set the application to sync with the Server A/B duo instead of the production servers, this application is identical to the code currently being used in production with SQL 2000 Standard. The persistent error that I am getting from the Client being thrown by SQL 2005 Mobile when I attempt to sync is "An instance of the SQL Server Reconciler error object cannot be created. Try reinstalling the replication components." SQL 2005 Mobile components on Server A are set to Logging Level 3 but not returning any errors that I can see to troubleshoot with. All replication components appear to be installed and operational, although I have re-installed them. Besides the obvious question of how to solve the error listed above, is there an issue with am x85 front end IIS 6.0 server talking to an x64 back end SQL 2005 server for merge replication over HTTPS with Windows Mobile 5.0 clients running SQL 2005 Mobile? Based on everything I have read off the MSDN Forums, MSDN articles, BOL, log files, and web searches it seems like I should have an operational synching topology, however clearly I have missed something because I have yet to get a successful subscription through to the publication. Any insight/enlightenment would be greatly appreciated, this seems to be a very narrow and specific area of replication and mobility and information is relatively sparse from my experience so far. Thanks!
View Replies !
View Related
SQL Mobile 2005 Replication - SQL Mobile DLL Could Not Be Loaded - Error 28559
I am migrating a pocket PC application from VS 2003 to VS 2005 and a few weeks ago I hit the following problem when replicating A SQL Mobile DLL could not be loaded. Reinstall SQL Mobile. [ DLL Name=sqlceca30.dll] Scanning forums for help I saw that other people had had this problem and one http://www.eggheadcafe.com/aspnet_answers/NETFrameworkCompactFramework/Feb2006/post25814466.asp suggested that this problem could be circumvented by getting the replication object early and then continuously using the same object for subsequent replications. I did this and it works a lot better now but ever so often I get another error which is Native Error 28559 SQL Mobile encountered problems when opening the database My only option at this point is to stop and start the application which cures the problem.
View Replies !
View Related
Merge Process Could Not Enumerate Changes At The Subscriber
Hi, I've seen quite a few posts about this error message but so far no answers. I'm merge replicating between SQL Server 2005 SP2 and SQL Server 2005 Mobile. Everything seems to run really well until at some point I get the above error message while running the replication from the device. It seems to happen just after I've made a schema change on the server e.g. the latest one was adding some new columns (which allow nulls) to replicated tables. I've switched on verbose logging and I get the following: 2007/04/27 13:57:06 Hr=00000000 Compression Level set to 1 2007/04/27 13:57:06 Hr=00000000 Count of active RSCBs = 0 2007/04/27 13:57:06 Thread=B04 RSCB=15 Command=OPWC Hr=00000000 Total Compressed bytes in = 846 2007/04/27 13:57:06 Thread=B04 RSCB=15 Command=OPWC Hr=00000000 Total Uncompressed bytes in = 1442 2007/04/27 13:57:06 Thread=B04 RSCB=15 Command=OPWC Hr=00000000 Responding to OpenWrite, total bytes = 846 2007/04/27 13:57:06 Thread=B04 RSCB=15 Command=OPWC Hr=00000000 C:Program FilesMicrosoft SQL Server 2005 Mobile Editionserverctmobilesql30.7AABD0FB7460_010309C7-9030-4CF9-7D60-A64608CD62F7 0 2007/04/27 13:57:06 Thread=E54 RSCB=15 Command=SYNC Hr=00000000 Synchronize prepped 0 <PARAMS RSCB="15" HostName="" Publisher="WINSERVER" PublisherNetwork="" PublisherAddress="" PublisherSecurityMode="1" PublisherLogin="" PublisherDatabase="CompacTimesheet_Staging" Publication="CompacTimesheet_Staging" ProfileName="DEFAULT" SubscriberServer="CTimeMobile - 7aabd0fb7460" SubscriberDatabasePath="Program FilesCompac TimesheetDataCompacTimesheetMobile.sdf" Distributor="WINSERVER" DistributorNetwork="" DistributorAddress="" DistributorSecurityMode="1" DistributorLogin="" ExchangeType="3" ValidationType="0" QueryTimeout="300" LoginTimeout="15" SnapshotTransferType="0" DistributorSessionId="452"/> 2007/04/27 13:57:06 Thread=E54 RSCB=15 Command=SYNC Hr=80045019 The merge process could not enumerate changes at the 'Subscriber'. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write. -2147200999 2007/04/27 13:57:06 Thread=E54 RSCB=15 Command=SYNC Hr=80045645 The process was successfully stopped. -2147199419 2007/04/27 13:57:06 Thread=E54 RSCB=15 Command=SCHK Hr=80004005 SyncCheck responding 0 2007/04/27 13:57:06 Thread=E54 RSCB=15 Command=SCHK Hr=00000000 Removing this RSCB 0 The error message doesn't seem very helpful. Is there another way to find out what is causing the problem? I've tried reinitializing all subscriptions and generating a new snapshot but it makes no difference. The only way I've found to fix this is to delete the database on the subscriber and synchronise again (losing all subscriber data since the last sync). Regards, Greg
View Replies !
View Related
The Merge Process Could Not Enumerate Changes At The 'Subscriber'.
I have two SQL 2005 Standard servers using merge replication, and out of the blue started getting failure notices regarding "The merge process could not enumerate changes at the 'Subscriber'." I turned on verbose logging and noticed the following section: 2006-04-19 12:53:33.227 Category:NULL Source: Merge Replication Provider Number: -2147200999 Message: The merge process could not enumerate changes at the 'Subscriber'. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write. 2006-04-19 12:53:33.227 The Merge Agent was unable to update information about the last synchronization at the Subscriber. Ensure that the subscription exists at the Subscriber, and restart the Merge Agent. 2006-04-19 12:53:33.227 The merge process was unable to update last synchronization information at the Publisher. Using Profiler on both sides, I don't see anything out the ordinary during the replication process until there are two calls in a row to the stored procedure sp_MSadd_merge_history90, where the second one is storing the error message listed above. Any ideas? Thanks, Scott Davis
View Replies !
View Related
Merge: Records Associated By A JOIN Filter Not Being Sent To A Subscriber
Hi, I have a merge (SQL 2005 Standard -> Express) topolgoy which is having problems The main problem is that the join filters don't seem to work for one area and I am hoping someone can help me with some troubleshooting advice There are 140+ tables in the topology but the ones causing particular pain are a parent child relationship where the child is actually a bridge/linking table to another table. Therefore although it is a parent child in the replication filters it is the reverse. i.e. the child has the paramterised filter on it and the parent is one level down joined by it's id. There are other tables joined to this parent table but it stays at three levels deep. The @join_unique_key therefore is set to 0 as is the partition options for the parent /child relationship. However, when we synchronise we have a problem. The rows get inserted in to the database in RI order but only the child records are replicated down to the subscriber. The child table with the parameterised filter has 13 articles joined to it in total and one of the other branches of join filters go down as deep as four levels. Most though do not. Does anyone have any suggestions as to why this might be happening? Any help would be greatly appreciated. Cheers, James P.S. I should add this problem only occurs when the edits are made at the publisher. If new records are added at the subscriber everything is fine.
View Replies !
View Related
Finding Valid Identity Range On Merge Subscriber
I am using merge replication with automatic identity range management I want to be able to give a disconnected subscriber a warning message if a certain percentage of the allocated subscriber identity range has been used - so that they can make sure they reconnect soon to obtain a new identity range I can get the current identity value OK, but I can't find a good way of finding the current permitted primary and secondary ranges The information is available in the check constraint, but I don't really want to have to parse this! CONSTRAINT [repl_identity_range_0DF907AC_40CF_4849_9BD0_2173C90A3805] CHECK NOT FOR REPLICATION (([ContactID]>(10000040000.) AND [ContactID]<=(10000050000.) OR [ContactID]>(10000050000.) AND [ContactID]<=(10000060000.))) I can't find any system view which will provide this information Is there a recommended way of doing this? Thanks aero1
View Replies !
View Related
Merge Replication Error - The Merge Process Could Not Retrieve Column Information
I had merge up and running fine. All of the sudden, the agent took a dive. This is what I get from the agent log. Any help would be greatly appreciated. Thanks in advance. [10/12/2006 9:00:18 AM]VBSERVE19.LTS_Efile: {call sp_MSgetversion } Percent Complete: 3 Retrieving publication information Percent Complete: 4 Retrieving subscription information Percent Complete: 4 The merge process is cleaning up meta data in database 'LTS_Efile'. Percent Complete: 4 The merge process cleaned up 0 row(s) in MSmerge_genhistory, 0 row(s) in MSmerge_contents, and 0 row(s) in MSmerge_tombstone. Percent Complete: 4 The merge process is cleaning up meta data in database 'LTS_Efile'. Percent Complete: 4 The merge process cleaned up 0 row(s) in MSmerge_genhistory, 0 row(s) in MSmerge_contents, and 0 row(s) in MSmerge_tombstone. Percent Complete: 4 Uploading data changes to the Publisher Connecting to Subscriber 'FO-DB-003.LTS_Efile' Server: FO-DB-003 DBMS: Microsoft SQL Server Version: 08.00.2039 user name: dbo API conformance: 2 SQL conformance: 1 transaction capable: 2 read only: N identifier quote char: " non_nullable_columns: 1 owner usage: 31 max table name len: 128 max column name len: 128 need long data len: Y max columns in table: 1024 max columns in index: 16 max char literal len: 524288 max statement len: 524288 max row size: 524288 [10/12/2006 9:00:23 AM]FO-DB-003.LTS_Efile: {call sp_MSgetversion } Connecting to Publisher 'VBSERVE19.LTS_Efile' Server: VBSERVE19 DBMS: Microsoft SQL Server Version: 08.00.2039 user name: dbo API conformance: 2 SQL conformance: 1 transaction capable: 2 read only: N identifier quote char: " non_nullable_columns: 1 owner usage: 31 max table name len: 128 max column name len: 128 need long data len: Y max columns in table: 1024 max columns in index: 16 max char literal len: 524288 max statement len: 524288 max row size: 524288 [10/12/2006 9:00:24 AM]VBSERVE19.LTS_Efile: {call sp_MSgetversion } Connecting to Subscriber 'FO-DB-003.LTS_Efile' Server: FO-DB-003 DBMS: Microsoft SQL Server Version: 08.00.2039 user name: dbo API conformance: 2 SQL conformance: 1 transaction capable: 2 read only: N identifier quote char: " non_nullable_columns: 1 owner usage: 31 max table name len: 128 max column name len: 128 need long data len: Y max columns in table: 1024 max columns in index: 16 max char literal len: 524288 max statement len: 524288 max row size: 524288 [10/12/2006 9:00:24 AM]FO-DB-003.LTS_Efile: {call sp_MSgetversion } Connecting to Publisher 'VBSERVE19.LTS_Efile' Server: VBSERVE19 DBMS: Microsoft SQL Server Version: 08.00.2039 user name: dbo API conformance: 2 SQL conformance: 1 transaction capable: 2 read only: N identifier quote char: " non_nullable_columns: 1 owner usage: 31 max table name len: 128 max column name len: 128 need long data len: Y max columns in table: 1024 max columns in index: 16 max char literal len: 524288 max statement len: 524288 max row size: 524288 [10/12/2006 9:00:24 AM]VBSERVE19.LTS_Efile: {call sp_MSgetversion } Connecting to Subscriber 'FO-DB-003.LTS_Efile' Server: FO-DB-003 DBMS: Microsoft SQL Server Version: 08.00.2039 user name: dbo API conformance: 2 SQL conformance: 1 transaction capable: 2 read only: N identifier quote char: " non_nullable_columns: 1 owner usage: 31 max table name len: 128 max column name len: 128 need long data len: Y max columns in table: 1024 max columns in index: 16 max char literal len: 524288 max statement len: 524288 max row size: 524288 [10/12/2006 9:00:24 AM]FO-DB-003.LTS_Efile: {call sp_MSgetversion } Connecting to Publisher 'VBSERVE19.LTS_Efile' Server: VBSERVE19 DBMS: Microsoft SQL Server Version: 08.00.2039 user name: dbo API conformance: 2 SQL conformance: 1 transaction capable: 2 read only: N identifier quote char: " non_nullable_columns: 1 owner usage: 31 max table name len: 128 max column name len: 128 need long data len: Y max columns in table: 1024 max columns in index: 16 max char literal len: 524288 max statement len: 524288 max row size: 524288 [10/12/2006 9:00:25 AM]VBSERVE19.LTS_Efile: {call sp_MSgetversion } Connecting to Subscriber 'FO-DB-003.LTS_Efile' Server: FO-DB-003 DBMS: Microsoft SQL Server Version: 08.00.2039 user name: dbo API conformance: 2 SQL conformance: 1 transaction capable: 2 read only: N identifier quote char: " non_nullable_columns: 1 owner usage: 31 max table name len: 128 max column name len: 128 need long data len: Y max columns in table: 1024 max columns in index: 16 max char literal len: 524288 max statement len: 524288 max row size: 524288 [10/12/2006 9:00:25 AM]FO-DB-003.LTS_Efile: {call sp_MSgetversion } Connecting to Publisher 'VBSERVE19.LTS_Efile' Server: VBSERVE19 DBMS: Microsoft SQL Server Version: 08.00.2039 user name: dbo API conformance: 2 SQL conformance: 1 transaction capable: 2 read only: N identifier quote char: " non_nullable_columns: 1 owner usage: 31 max table name len: 128 max column name len: 128 need long data len: Y max columns in table: 1024 max columns in index: 16 max char literal len: 524288 max statement len: 524288 max row size: 524288 [10/12/2006 9:00:30 AM]VBSERVE19.LTS_Efile: {call sp_MSgetversion } The process could not enumerate changes at the 'Subscriber'. The process could not enumerate deletions at the 'Subscriber'. The process could not enumerate changes at the 'Subscriber'. The merge process could not retrieve column information for table 'dbo.cmsReturn'. The process could not deliver delete(s) at the 'Publisher'. The process could not deliver delete(s) at the 'Publisher'. The process could not deliver delete(s) at the 'Publisher'. Percent Complete: 0 The process could not enumerate changes at the 'Subscriber'. Percent Complete: 0 Category:NULL Source: Merge Replication Provider Number: -2147200999 Message: The process could not enumerate changes at the 'Subscriber'. Percent Complete: 0 Category:COMMAND Source: Failed Command Number: 0 Message: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)} Percent Complete: 0 Category:SQLSERVER Source: FO-DB-003 Number: 208 Message: Invalid object name 't'. Percent Complete: 0 Category:NULL Source: Merge Replication Provider Number: -2147200988 Message: The process was successfully stopped. Disconnecting from Subscriber 'FO-DB-003' Disconnecting from Publisher 'VBSERVE19' Disconnecting from Subscriber 'FO-DB-003' Disconnecting from Subscriber 'FO-DB-003' Disconnecting from Subscriber 'FO-DB-003' Disconnecting from Subscriber 'FO-DB-003' Disconnecting from Publisher 'VBSERVE19' Disconnecting from Publisher 'VBSERVE19' Disconnecting from Publisher 'VBSERVE19' Disconnecting from Publisher 'VBSERVE19' Disconnecting from Publisher 'VBSERVE19' Disconnecting from Distributor 'VBSERVE19'
View Replies !
View Related
Mobile Merge Simple Question
So when a mobile device pulls down information, say a typical order entry scenario, then continues to edit/add orders and merges those changes back to the server, when/how are those records ever purged from the device once they are no longer needed?
View Replies !
View Related
Large MSMerge_History, MSMerge_genhistory,MSRepl_errors Tables In SQL Server 2005 Express Edition (Merge Push Subscriber)
SQL Server 2005 Standard Edition act as publisher and distributor. All subscribers are SQL Server 2005 Express Edition. According to 2005 book online, "MSMerge_History table exists in distribution database". Howevey I found this table in Subscriber database which is in SQL Server 2005 Express Edition. The problem is this table (MSMerge_History) and other two tables (MSMerge_genhistory, MSRepl_errors) are quite large. We want to keep SQL Server 2005 Express database as small as possible so we can put more data into it. Is there anyway (Manually or automatically) to clean those tables in SQL Server 2005 Express? Please help.
View Replies !
View Related
Replication Insert From Subscriber
:confused: I want to call a stored procedure to do the insert into my published arcticle/table. Is this possible? I know you can call a stored procedure to insert into the subscriber arctiles. The problem is the published database has a generated primary key (max +1 )that is calculated via a stored procedure during all inserts. I would bring the stored procedure over to the subscriber but that would not help since the values in the target table will not be 'current' because the subscriber database is only updated nightly. Thoughts?
View Replies !
View Related
Replication: Cannot Enumerate Changes At Subscriber
Hi all! I hope anyone here can help me with this tough problem: I have a replication enviroment with several subscribers. Publisher:MSSQL 2000, SP3 Subscribers: MSSQL200, SP3 and MSDE2000, SP3 Since a few weeks, one of the subscribers fails when synchronizing with the message "This process could not enumerate changes at the subscriber" The erroroutput with verboselevel 3 doesn't help me much, I append it to the end of this posting. (unfortunately german) I heard that this error can be caused by a "blank" in an image column or different Service Pack Versions - definitely not possible in this case! The only strange detail is that the SQL Server Versionnumber of this MSDE shown via EM is not the same as the number shown in controlpanel->software. By the way, is it ok that here are two lines for the MSDE? SP3 is definitely installed on all machines! Any help would be greatly appreciated - i'm already losing hope... Best Regards, Gert Microsoft SQL Server-Merge-Agent 7.00.623 Copyright (c) 1998 Microsoft Corporation Percent Complete: 0 Verbindung mit Abonnent 'MyServerAT074' Connecting to Abonnent 'MyServerAT074.MyDB' MyServerAT074.MyDB: {call sp_MSgetversion } Percent Complete: 0 Verbindung mit Verteiler 'MyServer1s' Connecting to Verteiler 'MyServer1s.' MyServer1s.: {call sp_MSgetversion } MyServer1s.: {call sp_helpdistpublisher (N'MyServer1s') } MyServer1s.distribution: select datasource, srvid from master..sysservers where srvname = N'MyServer1s' MyServer1s.distribution: select datasource, srvid from master..sysservers where srvname = N'MyServerAT074' MyServer1s.distribution: {call sp_MShelp_merge_agentid (0, N'MyDB', N'MyDB', 9, N'MyDB')} Percent Complete: 0 Initialisiert MyServer1s.distribution: {call sp_MShelp_profile (19, 4, N'')} Percent Complete: 1 Verbindung mit Verleger 'MyServer1s' Connecting to Verleger 'MyServer1s.MyDB' Connecting to Verleger 'MyServer1s.MyDB' MyServer1s.MyDB: {call sp_MSgetversion } Percent Complete: 3 Ruft Publikationsinformationen ab Percent Complete: 4 Ruft Abonnementinformationen ab Connecting to Abonnent 'MyServerAT074.MyDB' Disconnecting from Abonnent 'MyServerAT074' Percent Complete: 4 Uploadet Datenänderungen zum Verleger Percent Complete: 5 Ruft die Liste der Löschungen von MyServer1s.MyDB ab Percent Complete: 5 Verarbeitet Artikel 'First' ...... SNIP .... Percent Complete: 5 Verarbeitet Artikel 'LastTable' Percent Complete: 0 Der Prozess konnte die Änderungen auf dem Abonnenten nicht aufzählen. Percent Complete: 0 Category:SQLSERVER Source: MyServerAT074 Number: 0 Message: Attributverletzung eingeschränkter Datentypen Attributverletzung eingeschränkter Datentypen Disconnecting from Abonnent 'MyServerAT074' Disconnecting from Verleger 'MyServer1s' Disconnecting from Verleger 'MyServer1s' Disconnecting from Verteiler 'MyServer1s'
View Replies !
View Related
Replication SQL 7/ Adding A New Subscriber
Hello, I'm working with a fine running Replication System. Today i want to add a new subscriber to a publication. (Enterprise Manager) The following Error occurs: When Iuse SQL Query Analyzer manualy , to run the sp_addsubscriber, the following Error occurs: 7411 Server 'repl_distributor' is not configured for RPC. Server: Nachr.-Nr. 7411, Schweregrad 16, Status 1, Prozedur sp_addsubscriber, Zeile 140 Server 'repl_distributor' is not configured for RPC. What can I do ? R.Lenz
View Replies !
View Related
Replication; What Is: SqlCeReplication.Subscriber?
I am tring to use SQL Server Mobile 2005 to subscribe to a SQL Server 2005 publication from a pocketPC. In my code I have a SqlCeReplication object. One of the properties that must be set is: Subscriber, but I have no idea what that should be set to. When I was setting up the publication I don't remember specifying anything like that, and the class description of this property doesn't help: "Specifies the name of the Subscriber". Any help will be appreciated.
View Replies !
View Related
|
TRACKER
