FIX: 803 Error on Select Based Insert
  
PSS ID Number: Q104967
Article last modified on 10-31-1994
 
4.20
 
OS/2
 

----------------------------------------------------------------------
The information in this article applies to:
 
  - Microsoft SQL Server version 4.2 for 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.
