Microsoft KB Archive/160180

= FIX: Replicated UPDATE to Char Column May Cause Error 803 =

Article ID: 160180

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q160180



BUG #: 15829 (Windows NT: 6.5)



SYMPTOMS
LogReader fails with error 803. The errorlog and the task history shows the following message:

Error : 803, Severity: 20, State: 1

Unable to place buffer %*.d holding logical page %*.d in sdes for object

'syslogs' - either there is no room in sdes or buffer already in

requested slot.



CAUSE
The server may encounter this error when all of the following are true:


 * You attempt to perform a replicated UPDATE on a character column.
 * The character column is a part of an index in a table.
 * The index is published, using partitioning, at least seven times in the same publication or multiple publications.

This problem only occurs with transaction-based publications.



WORKAROUND
To work around this problem, drop the index on the character column that is being updated. If this is not possible, use Scheduled Table Refresh for tables that are required to be published using partitioning at least seven times.



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

Additional query words: SEM hung unresponsive

Keywords: kbbug kbfix kbusage KB160180

-

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

© Microsoft Corporation. All rights reserved.