About this book

This guide contains troubleshooting procedures for problems that you may encounter when using Sybase® Adaptive Server® Enterprise. The problems addressed here are those which the Sybase Technical Support staff hear about most often.

NoteAdaptive Server Enterprise is referred to as Adaptive Server in the remainder of this book.


This guide is intended for:

This guide assumes that you are thoroughly familiar with the Sybase products. If you are unfamiliar with any of the procedures described in this guide, call Sybase Technical Support for assistance.

How to use this book

This book provides detailed procedures for recovery from the most common Adaptive Server errors. Most resolutions are for numbered errors listed in the Adaptive Server server.loc file; however, some resolutions are for errors that do not have numbers.

Related documents

The Adaptive Server Enterprise documentation set consists of the following:

Other sources of information

Use the Sybase Getting Started CD, the SyBooks CD, and the Sybase Product Manuals Web site to learn more about your product:

Sybase certifications on the Web

Technical documentation at the Sybase Web site is updated frequently.

StepsFinding the latest information on product certifications

  1. Point your Web browser to Technical Documents.

  2. Click Certification Report.

  3. In the Certification Report filter select a product, platform, and timeframe, and click Go.

  4. Click a Certification Report title to display the report.

StepsFinding the latest information on component certifications

  1. Point your Web browser to Availability and Certification Reports.

  2. Either select the product family and product under Search by Base Product; or select the platform and product under Search by Platform.

  3. Select Search to display the availability and certification report for the selection.

StepsCreating a personalized view of the Sybase Web site (including support pages)

Set up a MySybase profile. MySybase is a free service that allows you to create a personalized view of Sybase Web pages.

  1. Point your Web browser to Technical Documents.

  2. Click MySybase and create a MySybase profile.

Sybase EBFs and software maintenance

StepsFinding the latest information on EBFs and software maintenance

  1. Point your Web browser to the Sybase Support Page.

  2. Select EBFs/Maintenance. If prompted, enter your MySybase user name and password.

  3. Select a product.

  4. Specify a time frame and click Go. A list of EBF/Maintenance releases is displayed.

    Padlock icons indicate that you do not have download authorization for certain EBF/Maintenance releases because you are not registered as a Technical Support Contact. If you have not registered, but have valid information provided by your Sybase representative or through your support contract, click Edit Roles to add the “Technical Support Contact” role to your MySybase profile.

  5. Click the Info icon to display the EBF/Maintenance report, or click the product description to download the software.


The conventions for syntax statements in this manual are as follows:




Command names, command option names, stored procedure names, utility names, utility flags, and other keywords are in bold.


Variables, or words that stand for values that you fill in, are in italics and are normally surrounded with angle brackets <>. Do not include the brackets when typing in the value.


Curly braces indicate that you choose at least one of the enclosed options. Do not include braces in your option.


Brackets mean choosing one or more of the enclosed options is optional. Do not include brackets in your option.


Parentheses are to be typed as part of the command.


The vertical bar means you may select only one of the options shown.


The comma means you may choose as many of the options shown as you like, separating your choices with commas to be typed as part of the command.


Words in angle brackets should be replaced with the corresponding name (such as a table or device). Do not include brackets in your entry.

SQL syntax statements (displaying the syntax and options for a command) are printed as follows:

sp_dropdevice <device_name>

Examples showing the use of Transact-SQL commands are printed as follows:

1> select * from publishers
2> go

Examples of computer output are printed as follows:

pub_id  pub_name               city         state 
------  -------------------   -----------   -----
0736    New Age Books          Boston        MA
0877    Binnet & Hardley       Washington    DC
1389    Algodata Infosystems   Berkeley      CA

(3 rows affected)

Accessibility features

This document is available in an HTML version that is specialized for accessibility. You can navigate the HTML with an adaptive technology such as a screen reader, or view it with a screen enlarger.

Adaptive Server HTML documentation has been tested for compliance with U.S. government Section 508 Accessibility requirements. Documents that comply with Section 508 generally also meet non-U.S. accessibility guidelines, such as the World Wide Web Consortium (W3C) guidelines for Web sites.

NoteYou might need to configure your accessibility tool for optimal use. Some screen readers pronounce text based on its case; for example, they pronounce ALL UPPERCASE TEXT as initials, and MixedCase Text as words. You might find it helpful to configure your tool to announce syntax conventions. Consult the documentation for your tool.

For information about how Sybase supports accessibility, see Sybase Accessibility. The Sybase Accessibility site includes links to information on Section 508 and W3C standards.

If you need help

Each Sybase installation that has purchased a support contract has one or more designated people who are authorized to contact Sybase Technical Support. If you cannot resolve a problem using the manuals or online help, please have the designated person contact Sybase Technical Support or the Sybase subsidiary in your area.