BUG: Distribution Task Fails with "Invalid Cursor State" Error If Batch = 1 (194773)
The information in this article applies to:
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.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbBug kbfix KB194773 |
|---|
|