Error 1501

Severity

Message text

Sort failure

Explanation

This error occurs during index creation when Adaptive Server fails to complete a sort operation. There are a number of different states for this error, each indicating a different reason for the failure:

State	Meaning
2	When creating a high level index structure, Adaptive Server is unable to build a parent node in the ancestor list.
3	When creating a high level index structure, Adaptive Server is unable to build a parent node from the root of the tree.
4	When creating a high level index structure, Adaptive Server is unable to build a parent node from the new root of the ancestor tree.
6	The sever is adding the results of an internal sort of a special leaflet node to an external merge in progress, and a single internal merge step has a merge order greater than 8.
7	The server is adding the results of an internal leaf merge node and the previous merge step caused the merge order to be greater than 8.
8	Adaptive Server is starting a non-sort of already sorted data to create a clustered index, and it cannot find a page to an index that was supposed to have been built for the sorted data.
9	The server is unable to allocate and initialize space for managing the sort’s buffers.
10	The server is building indexes and the length of a row in an overflow page is either zero or greater than the size of a page.

When this error occurs, no index is created.

The configuration parameter number of sort buffers controls how Adaptive Server uses memory during sorting. number of sort buffers controls the sort buffer size; its default value is 500. Changing the value of number of sort buffers can cause error 1501.

Error 1501 can also be caused by an Adaptive Server problem.

Action

To resolve the error:

Determine the current value of number of sort buffers:
```
1> sp_configure "number of sort buffers"
2> go
```
Change the value, perhaps back to the default value of 500 (recommended except when creating indexes in parallel):
```
1> sp_configure "number of sort buffers", <new_value>
2> go
```

Additional information

Refer to “create index” in Reference Manual: Commands for information about creating indexes.

Refer to “Setting Configuration Parameters” in the System Administration Guide: Volume 1 for information about configuration parameters.

Versions in which this error is raised

All versions