Microsoft KB Archive/166190

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

Article ID: 166190

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q166190



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  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  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 , 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: kbbug kbprb kbusage KB166190

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.