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:
- 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 : kbusage SSrvGen SSrvStProc kbbug6.50
Version : 6.5
Platform : WINDOWS
Issue type : kbprb