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

• 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 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.