Microsoft KB Archive/104967

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 18:13, 12 August 2020 by X010 (talk | contribs) (X010 moved page Microsoft KB Archive/Q104967 to Microsoft KB Archive/104967 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.