Replmerg problem

Printable View

03-27-2009, 07:28 AM
Leeb65

Replmerg problem

Hi I'm trying to merge some data with SQL Server 2005 Enterprise from SQL Express 2005 via web synchronization, but it's not connecting. Below is the return from the command window:

2009-03-27 11:51:12.968 Microsoft SQL Server Merge Agent 9.00.4035.00
2009-03-27 11:51:12.968 Copyright (c) 2005 Microsoft Corporation
2009-03-27 11:51:12.968
2009-03-27 11:51:12.968 The timestamps prepended to the output lines are expressed in terms of UTC time.
2009-03-27 11:51:12.968 User-specified agent parameter values:
-Publisher TIDYHOST-WDNB0A
-PublisherDB P8447_Meetings
-Publication P8447_Meetings_Distribution
-Distributor TIDYHOST-WDNB0A
-SubscriptionType 1
-Subscriber LEE-PC\SQLTEST
-SubscriberSecurityMode 1
-SubscriberDB P8447_Meetings
-InternetURL https://8447notes.impl.pro/WebSynch/replisapi.dll
-InternetLogin TIDYHOST-WDNB0A\p8447repl
-InternetPassword **********
-QueryTimeout 900
-InternetTimeout 1200
2009-03-27 11:51:13.000 Connecting to Subscriber 'LEE-PC\SQLTEST'
2009-03-27 11:51:13.125 The upload message to be sent to Publisher 'TIDYHOST-WDNB0A' is being generated
2009-03-27 11:51:13.125 The merge process is using Exchange ID '56A426DA-EED4-433B-84D0-7BB0D8469D8D' for this web synchronization session.
2009-03-27 11:51:13.578 A security error occurred

2009-03-27 11:51:13.578 Category:NULL
Source: Merge Process
Number: -2147209329
Message: A security error occurred

2009-03-27 11:51:13.578 Category:NULL
Source: Merge Process(Web Sync Client)
Number: -2147010889
Message: The Merge Agent could not connect to the URL 'https://8447notes.impl.pro/WebSynch/replisapi.dll' during Web synchronization. Please verify that the URL, Internet login credentials and proxy server settings are correct and that the Web server is reachable.

Can anyone tell me what I am doing wrong please?

thanks,

Lee
03-27-2009, 10:32 AM
Leeb65

This has changed now, the above problem was the Certificate on the server.

Now however the problem is different, see below:

2009-03-27 15:02:29.718 Microsoft SQL Server Merge Agent 9.00.4035.00
2009-03-27 15:02:29.718 Copyright (c) 2005 Microsoft Corporation
2009-03-27 15:02:29.718
2009-03-27 15:02:29.718 The timestamps prepended to the output lines are express
ed in terms of UTC time.
2009-03-27 15:02:29.718 User-specified agent parameter values:
-Publisher TIDYHOST-WDNB0A
-PublisherDB P8447_Meetings
-Publication P8447_Meetings_Distribution
-Distributor TIDYHOST-WDNB0A
-SubscriptionType 1
-Subscriber LEE-PC\SQLTEST
-SubscriberSecurityMode 1
-SubscriberDB P8447_Meetings
-InternetURL https://8447notes.impl.pro/WebSynch/replisa
pi.dll
-InternetLogin TIDYHOST-WDNB0A\p8447repl
-InternetPassword **********
-QueryTimeout 900
-InternetTimeout 1200
2009-03-27 15:02:29.750 Connecting to Subscriber 'LEE-PC\SQLTEST'
2009-03-27 15:02:30.328 The upload message to be sent to Publisher 'TIDYHOST-WDNB0A' is being generated
2009-03-27 15:02:30.328 The merge process is using Exchange ID '7B51950E-BF32-47D0-96D4-4D794C1A00E1' for this web synchronization session.
2009-03-27 15:02:31.531 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.
2009-03-27 15:02:31.531 Category:NULL
Source: Merge Replication Provider
Number: -2147199481
Message: 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.
2009-03-27 15:02:31.531 Category:SQLSERVER
Source: LEE-PC\SQLTEST
Number: 20017
Message: The subscription on the Subscriber does not exist.

Can anyone give me some guidance on this please.

Lee
03-27-2009, 12:23 PM
Leeb65

Ok,

I remade the subscription and now I get this error:

2009-03-27 16:47:33.609 Microsoft SQL Server Merge Agent 9.00.4035.00
2009-03-27 16:47:33.609 Copyright (c) 2005 Microsoft Corporation
2009-03-27 16:47:33.609
2009-03-27 16:47:33.609 The timestamps prepended to the output lines are expressed in terms of UTC time.
2009-03-27 16:47:33.609 User-specified agent parameter values:
-Publisher TIDYHOST-WDNB0A
-PublisherDB P8447_Meetings
-Publication P8447_Meetings_distribution
-Distributor TIDYHOST-WDNB0A
-SubscriptionType 1
-Subscriber LEE-PC\SQLTEST
-SubscriberSecurityMode 1
-SubscriberDB P8447_Meetings
-InternetURL https://notesdb.theithelper.com/WebSynch/replisapi.dll
-InternetLogin 78.129.163.191\p8447repl
-InternetPassword **********
-ouptut c:\bdc.log
2009-03-27 16:47:33.625 Percent Complete: 0
2009-03-27 16:47:33.640 Connecting to Subscriber 'LEE-PC\SQLTEST'
2009-03-27 16:47:33.640 Connecting to OLE DB Subscriber at datasource: 'LEE-PC\SQLTEST', location: '', catalog: 'P8447_Meetings', providerstring: '' using provider 'SQLNCLI'
2009-03-27 16:47:33.734 OLE DB Subscriber: LEE-PC\SQLTEST
DBMS: Microsoft SQL Server
Version: 09.00.4035
catalog name: P8447_Meetings
user name: dbo
API conformance: 0
SQL conformance: 0
transaction capable: 1
read only: F
identifier quote char: "
non_nullable_columns: 0
owner usage: 15
max table name len: 128
max column name len: 128
need long data len:
max columns in table: 1000
max columns in index: 16
max char literal len: 131072
max statement len: 131072
max row size: 131072
2009-03-27 16:47:33.734 OLE DB Subscriber 'LEE-PC\SQLTEST': {call sp_MSgetversion }
2009-03-27 16:47:33.750 OLE DB Subscriber 'LEE-PC\SQLTEST': set nocount on declare @dbname sysname select @dbname = db_name() declare @collation nvarchar(255) select @collation = convert(nvarchar(255), databasepropertyex(@dbname, N'COLLATION')) select collationproperty(@collation, N'CODEPAGE') as 'CodePage', collationproperty(@collation, N'LCID') as 'LCID', collationproperty(@collation, N'COMPARISONSTYLE') as 'ComparisonStyle',cast(case when convert (int,databasepropertyex (@dbname,'comparisonstyle')) & 0x1 = 0x1 then 0 else 1 end as bit) as DB_CaseSensitive,cast(case when convert (int,serverproperty ('comparisonstyle')) & 0x1 = 0x1 then 0 else 1 end as bit) as Server_CaseSensitive set nocount off
2009-03-27 16:47:33.750 OLE DB Subscriber 'LEE-PC\SQLTEST': {?=call sp_helpsubscription_properties (N'TIDYHOST-WDNB0A', N'P8447_Meetings', N'P8447_Meetings_distribution')}
2009-03-27 16:47:33.750 Distributor security mode: 0, login name: , password: ********.
2009-03-27 16:47:33.750 OLE DB Subscriber 'LEE-PC\SQLTEST': {?=call sp_helpsubscription_properties (N'TIDYHOST-WDNB0A', N'P8447_Meetings', N'P8447_Meetings_distribution')}
2009-03-27 16:47:33.750 Publisher security mode: 0, login name: , password: ********.
2009-03-27 16:47:33.750 OLE DB Subscriber 'LEE-PC\SQLTEST': {call sys.sp_MShelp_profilecache(N'DEFAULT')}
2009-03-27 16:47:33.750 OLE DB Subscriber 'LEE-PC\SQLTEST': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
2009-03-27 16:47:33.765 Percent Complete: 0
2009-03-27 16:47:33.765 The upload message to be sent to Publisher 'TIDYHOST-WDNB0A' is being generated
2009-03-27 16:47:33.765 OLE DB Subscriber 'LEE-PC\SQLTEST': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
2009-03-27 16:47:33.765 Percent Complete: 0
2009-03-27 16:47:33.765 The merge process is using Exchange ID '6E81FCE5-71A8-4528-B743-D0792653B5C2' for this web synchronization session.
2009-03-27 16:47:33.765 Connecting to OLE DB at datasource: 'LEE-PC\SQLTEST', location: '', catalog: 'P8447_Meetings', providerstring: '' using provider 'SQLNCLI'
2009-03-27 16:47:33.765 OLE DB : LEE-PC\SQLTEST
DBMS: Microsoft SQL Server
Version: 09.00.4035
catalog name: P8447_Meetings
user name: dbo
API conformance: 0
SQL conformance: 0
transaction capable: 1
read only: F
identifier quote char: "
non_nullable_columns: 0
owner usage: 15
max table name len: 128
max column name len: 128
need long data len:
max columns in table: 1000
max columns in index: 16
max char literal len: 131072
max statement len: 131072
max row size: 131072
2009-03-27 16:47:33.765 OLE DB 'LEE-PC\SQLTEST': set nocount on declare @dbname sysname select @dbname = db_name() declare @collation nvarchar(255) select @collation = convert(nvarchar(255), databasepropertyex(@dbname, N'COLLATION')) select collationproperty(@collation, N'CODEPAGE') as 'CodePage', collationproperty(@collation, N'LCID') as 'LCID', collationproperty(@collation, N'COMPARISONSTYLE') as 'ComparisonStyle',cast(case when convert (int,databasepropertyex (@dbname,'comparisonstyle')) & 0x1 = 0x1 then 0 else 1 end as bit) as DB_CaseSensitive,cast(case when convert (int,serverproperty ('comparisonstyle')) & 0x1 = 0x1 then 0 else 1 end as bit) as Server_CaseSensitive set nocount off
2009-03-27 16:47:33.781 Can not find publication 'P8447_Meetings_distribution' on the subscriber. If this is a push subscription then attempt to synchronize using web-sync will fail.
2009-03-27 16:47:33.781 OLE DB Subscriber 'LEE-PC\SQLTEST': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
2009-03-27 16:47:33.781 Percent Complete: 0
2009-03-27 16:47:33.781 Can not find publication 'P8447_Meetings_distribution' on the subscriber. If this is a push subscription then attempt to synchronize using web-sync will fail.
2009-03-27 16:47:33.781 Percent Complete: 0
2009-03-27 16:47:33.781 Category:NULL
Source: Merge Replication Provider(Web Sync Client)
Number: -2147199421
Message: Can not find publication 'P8447_Meetings_distribution' on the subscriber. If this is a push subscription then attempt to synchronize using web-sync will fail.
2009-03-27 16:47:33.781 Percent Complete: 0
2009-03-27 16:47:33.781 Category:SQLSERVER
Source: LEE-PC\SQLTEST
Number: 0
Message: Row handle is invalid.
2009-03-27 16:47:33.781 Percent Complete: 0
2009-03-27 16:47:33.796 Category:NULL
Source: Merge Replication Provider(Web Sync Client)
Number: -2147199421
Message: Can not find publication 'P8447_Meetings_distribution' on the subscriber. If this is a push subscription then attempt to synchronize using web-sync will fail.
2009-03-27 16:47:33.796 Percent Complete: 0
2009-03-27 16:47:33.796 Category:SQLSERVER
Source: LEE-PC\SQLTEST
Number: 0
Message: Row handle is invalid.
2009-03-27 16:47:33.796 Disconnecting from OLE DB Subscriber 'LEE-PC\SQLTEST'
2009-03-27 16:47:33.796 Disconnecting from OLE DB Subscriber 'LEE-PC\SQLTEST'
2009-03-27 16:47:33.796 Disconnecting from OLE DB 'LEE-PC\SQLTEST'
2009-03-27 16:47:33.796 Disconnecting from OLE DB 'LEE-PC\SQLTEST'

How can I fix this problem?

Lee
03-28-2009, 12:10 PM
rmiao

SQL Express 2005 can't publish any changes.
03-28-2009, 01:35 PM
Leeb65

Is this a statement about SQL Express 2005 in general or do you mean just my copy?
03-29-2009, 12:30 PM
rmiao

In general, sql2k5 express can only be replication subscriber.
03-29-2009, 01:11 PM
Leeb65

It is setup as a subscriber using a pull subscription, but does this mean it cannot send any updates to the distributer?

I followed the tutorial on this site from Marcin Policht and from what I understood, a merge subscription is possible.

I have a DB that is updated locally on several laptops when the internet is not available and when a connection is available the web version of the app is used. What kind of replication should I use to ensure that both DBs are in sync?
03-29-2009, 06:31 PM
rmiao

You can set merge replication with sql2k5 express, but it'll not send any change back to publisher.
03-30-2009, 01:43 AM
Leeb65

Thanks rmiao.