Server Error Messages 1500-1599

Number

Severity

Text and Explanation

1501

20

 Sort failure

Explanation: Refer to the writeup for this error.

1502

20

 Sort Internal Error: Bad Sort Descriptor!!

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.

1503

20

 Sort Internal Error: The Root page of right/left sub-index tree is missing.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.

1504

20

 Internal Sort Error. Empty Index Page found.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.

1505

14

 Create unique index aborted on duplicate key.  Primary key is `%S_KEY'

Explanation: Refer to the writeup for this error.

1507

10

 Warning: deleted duplicate row.  Primary key is `%S_KEY'

Explanation: Report the error to your System Administrator. You may need to increase swap space.

1508

14

 Create index aborted on duplicate rows.  Primary key is `%S_KEY'

Explanation: Refer to the writeup for this error.

1509

20

Row compare failure of RIDs (%ld, %d) and (%ld, %d), keycnt = %ld, compflags = %ld, rowformat = %ld, minlen = %ld. 

Explanation: Refer to the writeup for this error.

1510

17

 Sort failed: Out of space in database `%.*s'

Explanation: Refer to the writeup for this error.

1511

20

 Sort cannot be reconciled with transaction log

Explanation: Adaptive Server encountered an internal error indicative of some problem in logging/recovery. Reconnect to Adaptive Server. Report the error to your System Administrator.

1513

20

 Reuse of extent failed in sort

Explanation: Adaptive Server encountered an internal error indicative of some problem in logging/recovery. Reconnect to Adaptive Server. Report the error to your System Administrator.

1514

21

Sort failed because it attempted to allocate page %ld and found that the page was busy. Buffer %S_BUF contains a cached and referenced page with objid %ld indid %ld and status 0x%x.

Explanation: Adaptive Server encountered an internal error affecting all processes using the current database. Report the error to your System Administrator.

1515

20

 Bad session descriptor for sort

Explanation: This error occurs during a sort operation when the server finds that a session descriptor (pointing to row ID’s) is invalid. Shut down and restart the server to correct the problem.

1519

20

Internal Sort Error. A transaction that is involved in Parallel Sort is being redone. 

Explanation: Adaptive Server encountered an internal error affecting the current process. Restart Adaptive Server.

1520

18

 Sort failed for table `%.*s' in database `%.*s' because internal count of used pages is incorrect. Run DBCC TABLEALLOC to correct the value.

Explanation: The create index command allocates a work area based on an estimate in the OAM page of the number of data pages in the table. If this value is too low, the work area is too small, the sort fails, and Error 1520 is raised. Use dbcc tablealloc to update the page count and correct this error.

1521

18

 Sort failed because a table in tempdb used for the processing of the query had a bad data page count.  Tempdb should not have been damaged.

Explanation: Adaptive Server encountered an internal error affecting the current process. Restart Adaptive Server.

1522

20

 Sort failure.  Prevented overwriting of allocation page in database `%S_DBID' by aborting sort.

Explanation: Adaptive Server encountered an internal error affecting the current process. Run `dbcc checkdb' and check available space.

1523

20

 Sort failure.  Prevented incorrect extent deallocation by aborting sort.

Explanation: Adaptive Server encountered an internal error affecting the current process. Run `dbcc checkdb' and check available space.

1525

21

 Sort Failure. Rollforward of sort encountered sort descriptor timestamps out of sequence. Old timestamp in log: %04x %08lx. New timestamp in log: %04x %08lx. Timestamp in sort descriptor: %04x %08lx.

Explanation: Adaptive Server encountered an internal error affecting all processes in the current database. Report the error to your System Administrator. Adaptive Server must be restarted and dbcc diagnostics run.

1526

17

Sort failure. The configure size for data cache (%.*s) is not sufficient to handle the sort buffers (%d) requested. Please reconfigure the data cache or sort buffers and try the command again. 

Explanation: Command failed due to resource limitation on the specified data cache. Contact your System Administrator to address the resource issue (see System Administration Guide for help with configuring memory).

1527

20

 Sort failure.  Unknown exception returned from bufclaimcache:  %d.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.

1528

21

 Character data comparison failure.  An unrecognized Sort-Map-Element type (%d) was found in the server-wide default sort table at SMEL entry [%d].

Explanation: Adaptive Server encountered an internal error affecting all processes in the current database. Report the error to your System Administrator. Adaptive Server must be restarted and dbcc diagnostics run.

1529

21

 Character data comparison failure.  A list of Sort-Map-Elements from the server-wide default sort table does not end properly.  This list begins at SMEL entry [%d].

Explanation: Adaptive Server encountered an internal error affecting all processes using the current database. Report the error to your System Administrator.

1530

16

 Create index with sorted_data was aborted because of row out of order.  Primary key of first out of order row is `%S_KEY'

Explanation: Refer to the writeup for this error.

1531

16

 The sorted_data option cannot be used for a nonclustered index if the keys are not unique within the table.  Create index was aborted because of duplicate keys.  Primary key is `%S_KEY'.

Explanation: Refer to the writeup for this error.

1532

20

 Invalid merge page. %s on page %ld.

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator so dbcc checks (tablealloc, indexalloc) can be run .

1533

20

 Internal Sort error. Extend read returns an invalid page. Requested pageno=%ld  Read pageno=%ld.

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator so dbcc checks (tablealloc, indexalloc) can be run .

1534

20

 Internal Sort error: Attempt to split presorted clustered data page failed. Attempted to split page, pageno = %ld.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.

1535

20

 Internal Sort error: Attempt to split presorted clustered data page failed. Split page, pageno = %ld.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.

1536

20

 Internal Sort error. Presorted clustered data page invalid. Page, pageno = %ld, parm1 = %d, parm2 = %d.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.

1537

17

Cannot create clustered index on partition table due to not enough sort buffers. Configure at least %ld sortbuffers to create the clustered index on partition table. 

Explanation: The parallel sort expect at least N number of sort buffers where N= number of consumers to run the parallel sort. Modify the command to fit available resources, retry when the resource is available, or contact your System Administrator to address the resource problem.

1538

17

Parallel degree %ld is less than required parallel degree %ld to create clustered index on partition table. Ch ange the parallel degree to required parallel degree and retry.

Explanation: Command failed due to resource limitation. Contact your System Administrator to address the resource problem.

1539

17

Only %d worker processes are available when %d worker processes are required. Process aborted. 

Explanation: Command failed due to resource limitation. Modify the command to fit available resources, retry when the resource is available, or contact your System Administrator to address the resource problem.

1540

10

Warning: Only %d worker processes are available when %d worker processes are required. 

Explanation: This is an informational message.

1541

10

Internal sort error: cannot allocate memory in data sampling. 

Explanation: This is an informational message. No action is required.

1542

10

Internal sort error: Too small a sample set! 

Explanation: This is an informational message. No action is required.

1543

20

Cannot create a pipe group for sorting in parallel.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator.

1544

20

Parallel Sort: Cannot initiate producers and consumers.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator.

1545

20

Parallel sort parent driver cannot send message to child thread.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator.

1546

20

Parallel sort parent driver cannot receive message from child threads.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator.

1547

20

Parallel sort parent driver error in waiting for child threads

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator.

1548

10

The Create Index is done using %s

Explanation: This is an informational message. No action is required.

1549

10

Partition Element: %ld

Explanation: This is an informational message. No action is required.

1550

10

Sort buffer size: %ld

Explanation: This is an informational message. No action is required.

1551

10

Parallel degree: %ld

Explanation: This is an informational message. No action is required.

1552

10

Number of producer threads: %ld

Explanation: This is an informational message. No action is required.

1553

10

Number of consumer threads: %ld

Explanation: This is an informational message. No action is required.

1554

10

Number of output devices: %ld

Explanation: This is an informational message. No action is required.

1555

10

Number of sampled records: %ld

Explanation: This is an informational message. No action is required.

1556

16

No such message!

Explanation: Check command syntax and semantics.

1557

10

Inconsistent distribution map (%d elements without element information)!

Explanation: This is an informational message. No action is required.

1558

10

Empty distribution map

Explanation: This is an informational message. No action is required.

1559

10

The distribution map contains %d element(s) for %d partitions.

Explanation: This is an informational message. No action is required.

1560

10

Warning: Number of filled elements differs from the data structure.

Explanation: This is an informational message. No action is required.

1561

20

Producer cannot insert rows into pipe buffers. 

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator.

1562

10

The sort for Worktable%d is done in %s

Explanation: This is an informational message. No action is required.

1563

10

The sort for %.*s is done in %s

Explanation: This is an informational message. No action is required.

1564

10

Psort option is not enabled in this database. Create Index will be done using Serial Sort

Explanation: This is an informational message. No action is required unless you wish to use parallel sort for the operation.

1565

20

The database option pllsort option is not enabled in this database. Create Clustered Index on partition table cannot be done using Serial Sort. Set the pllsort database option and rerun.

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.

1566

10

Warning: Attempt to create a clustered index on the partitioned table '%.*s' with distinct key values less than the number of partitions. Some partitions will be empty if the index is successfully created.

Explanation: This is an informational message. No action is required.

1567

20

Create Index Internal Error %ld detected

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.

1568

16

Unable to find sort order. Please check sort order ID or name.

Explanation: Adaptive Server could not perform the requested action. Contact your System Administrator.

1569

17

Unable to get a conversion handler for the built-in sort function.

Explanation: Command failed due to resource limitation. Contact your System Administrator to address the resource problem.

1570

10

The generated sortkey has been truncated.

Explanation: This is an informational message. No action is required.

1571

10

Unknown sort order ID %ld. Using binary sort order instead.

Explanation: This is an informational message. No action is required.

1572

16

Unknown sort order file name '%.*s' or Unicode cache is full.

Explanation: Command failed due to invalid or illegal request.

1573

16

Can't open the directory $SYBASE/collate/unicode.

Explanation: Command failed due to invalid or illegal request. Check syntax and permissions.

1574

20

Begin transaction failed when attempting to update syscharsets sort order information.

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.

1575

20

Unable to open syscharsets table to update sort order information.

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.

1576

20

Unable to lock syscharsets table to update sort order information.

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.

1577

20

Update of sort order informarion in syscharsets failed.

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.

1578

20

Unable to insert sort order information into syscharsets.

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.

1579

16

Error converting characters into Unicode to generate sort keys. There maybe illegal byte(s) in source string, or failure to allocate memory.

Explanation: Command failed due to invalid or illegal request.

1580

16

Unable to generate sortkey.

Explanation: Command failed due to invalid or illegal request.

1581

16

Create index was aborted because pages in the data only locked table are not linked.

Explanation: Notify your System Administrator so that dbcc diagnostics can be run.

1582

17

Failed to allocate memory for %ld auxiliary keep buffers. Try this operation when there is enough memory in the procedure cache, or increase the procedure cache memory and retry the sort operation.

Explanation: Command failed due to resource limitation. Modify the command to fit available resources, retry when the resource is available, or contact your System Administrator to address the resource problem.

1583

20

Found a rowlen of %ld, from the merge, while building index on %.*s. The maximum row length is %ld. Please contact Sybase Technical Support.

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.

1584

20

Unable to build the parent page at level %d while building index on %.*s. Please contact Sybase Technical Support.

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.

1585

20

Validation of datapage %ld in table %.*s failed. Please contact Sybase Technical Support.

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.

1586

20

Internal Sort Error. Attempt to hash a buffer from cache %.*s into cache %.*s. Please contact Sybase Technical  Support.

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.

1587

20

Empty buffer 0x%lx or mismatch in page or row number. SDES page=%ld, rownum=%ld, RID page=%ld, rownum=%ld. Ple ase contact Sybase Technical Support.

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.

1588

20

Attempt to create an index with sorted data option failed. Please contact Sybase Technical Support.

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.

1589

20

Found bad merge type %d while merging sub-indexes. Please contact Sybase Technical Support.

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.

1590

20

Internal error. Pipe create operation failed. Please report this to Sybase Technical Support staff. 

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.

1591

20

Internal error. Pipe destroy operation failed. Please report this to Sybase Technical Support staff. 

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.

1592

20

Internal error. Pipe open operation failed. Please report this to Sybase Technical Support staff. 

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.

1593

20

Internal error. Pipe close operation failed. Please report this to Sybase Technical Support staff. 

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.

1594

20

Internal error. Pipe read operation failed. Please report this to Sybase Technical Support staff. 

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.

1595

20

Internal error. Pipe write operation failed. Please report this to Sybase Technical Support staff. 

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.

1596

20

Internal Sort Error. Attempt to hash a buffer from cache %.*s into cache %.*s. Please contact Sybase Technical  Support.

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.

1597

17

Sort failure: Number of available sort buffers (%d) is less than the number required (%d) for executing this query. Contact your system administrator to reconfigure the number of sort buffers and try the query again. 

Explanation: Command failed due to resource limitation. Modify the command to fit available resources, retry when the resource is available, or contact your System Administrator to address the resource problem.

1598

21

Can not use Unilib Thai Dictionary Sort Order because dataserver may have memory corruption. 

Explanation: Adaptive Server encountered an internal error affecting all processes using the current database. Report the error to your System Administrator. Adaptive Server must be restarted and DBCC diagnostics run.

1599

21

Can not use Unilib Thai Dictionary Sort order because the conversion handle needed is NULL. Please check server’s error log file. 

Explanation: Adaptive Server encountered an internal error affecting all processes using the current database. Report the error to your System Administrator.