Results 1 to 9 of 9

Thread: Replmerg problem

  1. #1
    Join Date
    Mar 2009
    Posts
    6

    Question 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

  2. #2
    Join Date
    Mar 2009
    Posts
    6
    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

  3. #3
    Join Date
    Mar 2009
    Posts
    6
    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

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    SQL Express 2005 can't publish any changes.

  5. #5
    Join Date
    Mar 2009
    Posts
    6
    Is this a statement about SQL Express 2005 in general or do you mean just my copy?

  6. #6
    Join Date
    Sep 2002
    Posts
    5,938
    In general, sql2k5 express can only be replication subscriber.

  7. #7
    Join Date
    Mar 2009
    Posts
    6
    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?

  8. #8
    Join Date
    Sep 2002
    Posts
    5,938
    You can set merge replication with sql2k5 express, but it'll not send any change back to publisher.

  9. #9
    Join Date
    Mar 2009
    Posts
    6
    Thanks rmiao.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •