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:
- When the table specified does not have primary key declared.
- If the article information for this table is missing. If sysarticles
is directly manipulated, this error may occur.
- 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:
- 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.
- Sp_helparticle <publication_name> will give details on the articles in
the specified publication. Check to see if the article information
retrieved is correct.
- 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: kbbug kbprb kbusage KB166190