none
"The server returned an invalid or unrecognized response" during Web synchronization. RRS feed

  • Общие обсуждения

  • Hi,
    Have a problem with merge replication via Web.

    I have a publisher and distributor configured for Web synchronization (MS SQL 2005 Standard).

    Also I have two subscribers, both MS SQL SERVER 2005 Express. One of them using Windows Vista  and another Windows XP. On Vista everything is going well, but in XP I've got "The server returned an invalid or unrecognized response" during synchronization. (settings are the same in Vista and XP).

    Does anyone have any idea how to solve or indetify the problem ?

    Thanks in advance!

    P.S. Here is log from replmerg.exe

    CReconcilerTask               , 2009/09/16 23:36:09.625, 2412,   406,  S1, INFO: =============== STARTING OF MERGE ===============
    CReconcilerTask               , 2009/09/16 23:36:09.625, 2412,   485,  S2, INFO: CommandLine:  replmerg.exe -Publisher TestPublisher -PublisherDB testPublisherDB -Publication testPublication -Subscriber LONER-XP\SQLEXPRESS -SubscriberDB subscriberDB -ValidateInterval 5 -SubscriptionType 1 -PublisherSecurityMode 0 -PublisherLogin sa -PublisherPassword **** -SubscriberSecurityMode
    CReconcilerTask               , 2009/09/16 23:36:09.625, 2412,   485,  S2, INFO:   0 -SubscriberLogin raz -SubscriberPassword **** -SubscriberType 0 -Distributor TestPublisher -DistributorSecurityMode 0 -DistributorLogin sa -DistributorPassword **** -FileTransferType 0 -ExchangeType 3 -Output c:\ErrorRepl.txt -LoginTimeout 30 -InternetURL https://somedomain.com/sync//replisapi.dll
    CReconcilerTask               , 2009/09/16 23:36:09.625, 2412,   494,  S2, INFO:   -InternetLogin Replicator -InternetPassword ****
    Replprov.dll                  , 2009/09/16 23:36:09.781, 2412, 19858,  S2, INFO: Reading profile from Subscriber: ProfileName:
    WinHttpClient                 , 2009/09/16 23:36:10.125, 2412,   985,  S1, ERROR: CWinHttpClient::AuthenticateConnection: WinHttpReceiveResponse failed, got error 12152.
    WinHttpClient                 , 2009/09/16 23:36:10.125, 2412,  2549,  S1, ERROR: CWinHttpClient: The server returned an invalid or unrecognized response
    , 12152
    WinHttpClient                 , 2009/09/16 23:36:10.125, 2412,  2501,  S1, ERROR: ErrNo = 0x80042f78, ErrSrc = <null>, ErrType = 10, ErrStr = The server returned an invalid or unrecognized response
    WinHttpClient                 , 2009/09/16 23:36:10.125, 2412,  2501,  S1, ERROR: ErrNo = 0x80070715, ErrSrc = <null>, ErrType = 10, ErrStr = The Merge Agent could not connect to the URL 'https://somedomain.com/sync//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.
    WinHttpClient                 , 2009/09/16 23:36:10.125, 2412,  2596,  S1, ERROR: CWinHttpClient::RetrieveStatusText: WinHttpQueryHeaders for WINHTTP_QUERY_STATUS_TEXT failed, got error 12019.
    WinHttpClient                 , 2009/09/16 23:36:10.125, 2412,  2549,  S1, ERROR: CWinHttpClient: The handle is in the wrong state for the requested operation
    , 12019
    WinHttpClient                 , 2009/09/16 23:36:10.125, 2412,  2501,  S1, ERROR: ErrNo = 0x80042ef3, ErrSrc = <null>, ErrType = 10, ErrStr = The handle is in the wrong state for the requested operation
    WinHttpClient                 , 2009/09/16 23:36:10.125, 2412,  1081,  S1, ERROR: CWinHttpClient::AuthenticateConnection: Could not close HTTP request handle.
    replrec!FillErrorInfo         , 2009/09/16 23:36:10.125, 2412, 19955,  S1, ERROR: ErrNo = 0x80070006, ErrSrc = <null>, ErrType = 9, ErrStr = The Merge Agent could not connect to the URL 'https://somedomain.com/sync//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.
    DatabaseReconciler            , 2009/09/16 23:36:10.140, 2412, 20067,  S2, :T:,110,0,6,,,,,,,
    DatabaseReconciler            , 2009/09/16 23:36:10.140, 2412, 20074,  S2, INFO: Session Highlights: FAIL, WEBSYNC_CLIENT,
    CReconcilerTask               , 2009/09/16 23:36:10.140, 2412,   641,  S1, INFO: =============== ENDING OF MERGE
    • Изменено Jcomp 17 сентября 2009 г. 11:02 Update
    • Изменен тип I.Vorontsov 19 октября 2009 г. 5:55
    • Перемещено I.Vorontsov 1 декабря 2009 г. 9:17 (От:Сообщество SQLClub.ru)
    • Перемещено Tagore Bandlamudi 2 октября 2010 г. 0:18 MSDN Forums consolidation (От:SQL Server для разработчиков)
    16 сентября 2009 г. 23:08

Все ответы

  • Hello,

    Here you could find the solution of your problem: http://social.msdn.microsoft.com/forums/en-US/sqlreplication/thread/625f8497-8116-497b-83fd-cc7ee4a952b2 .

    If this answer was helpfull, please, mark it.
    17 сентября 2009 г. 11:16
  • Hi Stanislav,

    I've read that post, I have SP 3 installed on both side (subscriber and publisher) and my connection is not slow (about 100 Mbps). Will try to increase login timeout, but I don't think that it can help (I'm getting response immediately).
    17 сентября 2009 г. 13:51
  • Hello Jcomp
    Looking your error list I see that line:
    "
    ...The Merge Agent could not connect to the URL 'https://somedomain.com/sync//replisapi.dll' during ...
    Please verify that the URL, Internet login credentials and proxy server settings are correct and that the Web server is reachable...
    "

    Maybe double slash '//' in agent URL option is your problem?  verify  that
    PS check out also  Internet login credentials and proxy server settings
    18 сентября 2009 г. 7:56
  • Check logs Firewall..
    Quotas, access rights?
    18 сентября 2009 г. 8:28
  • Hi ][irurg,

    Removing '//' not help. Internet login credentials are correct one, and I have no proxy.

    I was thinking about what to do next, and decided to check what's going on over https.

    Download Fiddler ( check this out http://www.fiddler2.com/fiddler2/ ), check decrypt https trafic (in settings) and ..... sync begin working !

    Unfortunately  Fiddler  is crashing in few minutes, but anyway use Fiddler is not a solution.

     
    18 сентября 2009 г. 11:54
  • Hi Ivan,

    Firewall is disabled on publisher and on subscriber.

    18 сентября 2009 г. 11:55
  • Jcomp, that`s all very intresting
    Let`s try to understand.

    Fiddler option means http://www.fiddler2.com/Fiddler/help/OptionsUI.asp:
    "Capture HTTPS CONNECTs controls whether Fiddler will attempt to create tunnels through which secure traffic will flow. Decrypt HTTPS traffic controls whether Fiddler will decrypt the requests and responses within those secure tunnels."

    It seems decrypted traffic flows between your servers, when you start Fiddler . Without decrtypt checkbox enabled it isnt work, is it? Fiddler uses self-certificates to decrypt traffic, may https-sertificate of original connection get wrong. It is just discuss idea, i dont know what to do with that yet))

     

    18 сентября 2009 г. 17:32
  • ][irurg, probably we should continue in Russian ?

    You are right, without decrypt chechbox checked it is not working. And you are wrong about "Fiddler uses self-certificates to decrypt traffic", it is not possible.

    In this case, Fiddler is a client for my  web server, it descrypt traffic using my certificate then encrypt it again using Fiddler self signed certificates.

    About " https-sertificate of original connection get wrong" - don't think so, it works fine in Vista.
    19 сентября 2009 г. 13:32