BUG: Distribution Task Fails with "Invalid Cursor State" Error If Batch = 1

ID: Q194773

The information in this article applies to:

Microsoft SQL Server version 6.5

BUG #: 14941 (SQLBUG_65)

SYMPTOMS

A scheduled distribution task fails with the following error:

[ODBC][SQL Server Driver] invalid cursor state

This problem occurs on all subscribers (whether SQL Server or ODBC subscribers) when the commitbatchsize option of the distribution task (that is, the -c parameter) is set to 1.

WORKAROUND

To work around this problem, use a value greater than 1 for the commitbatchsize (-c) parameter. For information on the parameters for the replication tasks, see the "Replication Task Scheduling" topic in the SQL Server Books Online.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.5. This problem has been corrected in the latest U.S. Service Pack for SQL Server version 6.5. For more information, contact your primary support support provider.

MORE INFORMATION

The commitbatchsize (-c) parameter for the distribution task is the number of jobs to be issued to the subscription server before performing a commit on the subscription server. The default value for this parameter is 100.

For more information about this optional command, see the "Replication Task Scheduling" topic in the SQL Server Books Online.

Additional query words: prodsql dist repl

Keywords : SSrvRep kbbug6.50 kbfix6.50.sp1
Version : WINNT:6.5
Platform : winnt
Issue type : kbbug