Microsoft KB Archive/817843

= BUG: Error Message: &quot;The colv1 parameter is shorter...&quot; Occurs When Replicated Column is Updated =

Article ID: 817843

Article Last Modified on 6/1/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



BUG #: 469281 (SQL Server 8.0)



SYMPTOMS
When you try to modify a column in a table with SQL Server Enterprise Manager or SQL Query Analyzer, you may receive an error message similar to the following:

SQL Server Enterprise Manager

[Microsoft][ODBC SQL Server Driver][SQL Server]INITCOLVS: The colv1 parameter is shorter than the minimum required size.

[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.'

SQL Query Analyzer

Server: Msg 21512, Level 16, State 5, Procedure upd_3EE07881CAB246AD8434F5EDB0FE54AF, Line 60

INITCOLVS: The colv1 parameter is shorter than the minimum required size.

Server: Msg 3621, Level 16, State 1, Procedure upd_3EE07881CAB246AD8434F5EDB0FE54AF, Line 60

The statement has been terminated.

The statement has been terminated.

This problem occurs for the merge replicated publisher when you change the tracking option from row-level to column-level, and then try to modify the column of the merge replicated table.



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.



WORKAROUND
To work around this problem, follow these steps:


 * 1) Generate the SQL script of the subscribers.
 * 2) Delete the subscriptions, and then delete the publication. For more information about how to delete a subscription, visit the Microsoft Web sites:

http://msdn2.microsoft.com/en-us/library/aa216640(SQL.80).aspx

http://msdn2.microsoft.com/en-us/library/aa216653(SQL.80).aspx

http://msdn2.microsoft.com/en-us/library/aa177920(SQL.80).aspx
 * 1) Re-create the publication with default tracking level as column-level tracking. For more information about column-level tracking, visit the following Microsoft Web site:

http://msdn2.microsoft.com/en-us/library/aa216620(SQL.80).aspx
 * 1) Re-create the subscriptions.



Steps to Reproduce the Behavior

 * 1) Set up merge replication.

Note Do not synchronize the Publisher and the Subscriber.
 * 1) At the Subscriber, insert data in the merge replicated table.
 * 2) At the Publisher, change the tracking option from row-level to column-level.
 * 3) Synchronize the Publisher and the Subscriber.
 * 4) At the Publisher, update the merge replicated table.

