Results 1 to 1 of 1
  1. #1
    Join Date
    Jul 2003
    Posts
    53

    Unanswered: The process could not query row metadata at the 'Subscriber'.

    I replicate my MS-SQL Server 2000 data base between 2 Server by use 64K lease line. Both of servers use SQL Server2000 on Windows 2000 Server with all latest Service Pack. The number of tables that I want to replicate are 8 tables. Half of them is small tables and Half is large table. I found that small tables are work fine. But in large tables got the error in many time. The error that offen show is "The process could not query row metadata at the 'Subscriber'" with a different detail like QueryTimeout or TDS buffer length too large or General network error Check your network documentation. What is a problem? and How can I correct it?


    The error that show below is the latest error that I get.

    Table1
    Last Command: {call sp_MSgetmetadatabatch(?,?,?)}
    Error Message: The process could not query row metadata at the 'Subscriber'.
    Error Detial:
    The process could not query row metadata at the 'Subscriber'.
    (Source: Merge Replication Provider (Agent); Error number: -2147200996)
    ---------------------------------------------------------------------------------------------------------------
    Unknown token received from SQL Server
    (Source: ServerName (Data source); Error number: 0)
    ---------------------------------------------------------------------------------------------------------------
    The merge process timed out while executing a query. Reconfigure the QueryTimeout parameter and retry the operation.
    (Source: ServerName (Data source); Error number: 0)
    ---------------------------------------------------------------------------------------------------------------
    The process was successfully stopped.
    (Source: Merge Replication Provider (Agent); Error number: -2147199469)
    ---------------------------------------------------------------------------------------------------------------


    Table2
    Last Command: {call sp_MSgetmetadatabatch(?,?,?)}
    Error Message: The process could not query row metadata at the 'Subscriber'.
    Error Detial:
    The process could not query row metadata at the 'Subscriber'.
    (Source: Merge Replication Provider (Agent); Error number: -2147200996)
    ---------------------------------------------------------------------------------------------------------------
    Unknown token received from SQL Server
    (Source: ServerName (Data source); Error number: 0)
    ---------------------------------------------------------------------------------------------------------------
    TDS buffer length too large
    (Source: ServerName (Data source); Error number: 0)
    ---------------------------------------------------------------------------------------------------------------
    The merge process timed out while executing a query. Reconfigure the QueryTimeout parameter and retry the operation.
    (Source: ServerName (Data source); Error number: 0)
    ---------------------------------------------------------------------------------------------------------------
    The process was successfully stopped.
    (Source: Merge Replication Provider (Agent); Error number: -2147199469)
    ---------------------------------------------------------------------------------------------------------------



    Table3
    Last Command: {call sp_MSgetmetadatabatch(?,?,?)}
    Error Message: The process could not query row metadata at the 'Subscriber'.
    Error Detial:
    The process could not query row metadata at the 'Subscriber'.
    (Source: Merge Replication Provider (Agent); Error number: -2147200996)
    ---------------------------------------------------------------------------------------------------------------
    The merge process timed out while executing a query. Reconfigure the QueryTimeout parameter and retry the operation.
    (Source: ServerName (Data source); Error number: 0)
    ---------------------------------------------------------------------------------------------------------------
    The process was successfully stopped.
    (Source: Merge Replication Provider (Agent); Error number: -2147199469)
    ---------------------------------------------------------------------------------------------------------------



    Table4
    Last Command: {call sp_MSgetmetadatabatch(?,?,?)}
    Error Message: The process could not query row metadata at the 'Subscriber'.
    Error Detial:
    The process could not query row metadata at the 'Subscriber'.
    (Source: Merge Replication Provider (Agent); Error number: -2147200996)
    ---------------------------------------------------------------------------------------------------------------
    Protocol error in TDS stream
    (Source: ServerName (Data source); Error number: 9)
    ---------------------------------------------------------------------------------------------------------------
    TDS buffer length too large
    (Source: ServerName (Data source); Error number: 4352)
    ---------------------------------------------------------------------------------------------------------------
    The merge process timed out while executing a query. Reconfigure the QueryTimeout parameter and retry the operation.
    (Source: ServerName (Data source); Error number: 0)
    ---------------------------------------------------------------------------------------------------------------
    The process was successfully stopped.
    (Source: Merge Replication Provider (Agent); Error number: -2147199469)
    Last edited by solar115; 10-03-03 at 03:46.
    ^solaris^

Posting Permissions

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