21
Page allocated to sort found to be busy. Page number %ld. %S_BUF.
During index creation, Adaptive Server allocates and uncaches pages to sort the table’s rows. The sort routine double checks whether a page allocated for the sort is in the data cache. If it is in the cache, the page cannot be used, the sort operation fails and error 1514 is raised.
Failure to sort means that the index creation fails; consequently 4313 errors often accompany error 1514.
If error 1514 is raised in an isolated case during index creation on a specific table, run dbcc checktable on the table. If errors are reported, try to fix them using the sections in this manual that describe those errors, then use one of these options to recover from error 1514:
Retry index creation.
Shut down and restart Adaptive Server, and retry index creation.
Select the table data into a new table, drop the old table, and rename the new table to the old table name. Create the desired index on the table.
Bulk copy the affected table out, drop and re-create the table, and bulk copy back in. Create the desired index on the table.
If the problem persists, or is not isolated to one table, contact Sybase Technical Support for assistance.
All versions
