Microsoft KB Archive/194773

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

Article ID: 194773

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q194773



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: kbbug kbfix KB194773

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.