PRB: Err: Unable To Get Replication Information...Table %1!d!%

ID: Q166190


The information in this article applies to:
  • Microsoft SQL Server version 6.5


SYMPTOMS

You may receive the following error from Logreader, sp_replcmds, or sp_repltrans:

Unable to get replication information for table %1!d!%

This error also gives the object_id of the table in question.

This error indicates that some piece of schema information does not fit in place.


CAUSE

This error can occur under any of the following three conditions:

  1. When the table specified does not have primary key declared.


  2. If the article information for this table is missing. If sysarticles is directly manipulated, this error may occur.


  3. When the table schema is not available for the specified table article. This means that the table information could not be obtained from syscolumns.



WORKAROUND

For each of the causes above, use the corresponding workaround below:

  1. Use sp_help <table_name> to ensure that there is a declared primary key. This error can also occur if logreader is running when the index for the primary key is being rebuilt or dropped.


  2. Sp_helparticle <publication_name> will give details on the articles in the specified publication. Check to see if the article information retrieved is correct.


  3. Because the table information could not be obtained from syscolumns, use sp_helparticlecolumns <publication_name>,<article_name> to determine if there is a problem with the column information for the article that has the problem.


Additional query words: Log Reader repl info missing

Keywords : kbusage SSrvGen SSrvStProc kbbug6.50
Version : 6.5
Platform : WINDOWS
Issue type : kbprb


Last Reviewed: April 9, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.