Microsoft KB Archive/104967

FIX: 803 Error on Select Based Insert

PSS ID Number: Q104967 Article last modified on 10-31-1994

4.20

OS/2

BUG# OS/2: 1692 (4.2)

= SYMPTOMS =

Under certain rare circumstances, a select-based insert can receive an 803 error:

Unable to place buffer 0x%ld holding logical page %ld in sdes for object ‘%s’ - either there is no room in sdes or buffer already in requested slot.

Under rare circumstances, an insert of the form:

insert table803 select * from source_table

on a table with two or more non-clustered indexes can result in an 803 error. This error is very dependent on the data in the indexes at the time the operation is attempted.

= WORKAROUND =

This condition may sometimes be addressed by dropping any non-clustered indexes on the table, then retrying the operation. If it succeeds, the indexes can be recreated and normal operations continued.

= STATUS =

Microsoft has confirmed this to be a problem in SQL Server version 4.2 for OS/2. This problem was corrected in SQL Server version 4.2aK11. For more information, contact your primary support provider.

Additional reference words: 4.20 KBCategory: kbother kberrmsg KBSubcategory: SSrvServer

=
================================================================

Copyright Microsoft Corporation 1994.