Sybase® Adaptive ServerTM Enterprise Troubleshooting and Error Messages Guide Volume 3 Sybase Adaptive Server Enterprise 11.9.x-12.
DOCUMENT ID: 39994-01-1250-01 LAST REVISED: May 2002 Copyright © 1989-2002 by Sybase, Inc. All rights reserved. This publication pertains to Sybase software and to any subsequent release until otherwise indicated in new editions or technical notes. Information in this document is subject to change without notice. The software described herein is furnished under a license agreement, and it may be used or copied only in accordance with the terms of that agreement. To order additional documents, U.S.
Contents About This Book .......................................................................................................................... vii CHAPTER 4 Backup Server Error Messages ................................................. 683 Commonly Encountered Errors .................................................... 683 “No language handler installed” Message .............................
Contents CHAPTER 5 Component Integration Services Error Messages ................... 745 Component Integration Services Error Messages ...................... 745 CHAPTER 6 Adaptive Server Error Messages ............................................... Working with Error Messages ...................................................... Server Error Messages 1 - 199 .................................................... Server Error Messages 200 - 299 ................................................
Contents Server Error Messages 4200 - 4299 ............................................ 935 Server Error Messages 4300 - 4399 ............................................ 938 Server Error Messages 4400 - 4499 ............................................ 941 Server Error Messages 4500 - 4599 ............................................ 943 Server Error Messages 4600 - 4699 ............................................ 944 Server Error Messages 4700 - 4799 ............................................
Contents Server Error Messages 9700 - 9799 .......................................... Server Error Messages 9800 - 9899 .......................................... Server Error Messages 9900 - 9999 .......................................... Server Error Messages 10100 - 10199 ...................................... Server Error Messages 10200 - 10299 ...................................... Server Error Messages 10300 - 10399 ...................................... Server Error Messages 10400 - 10499 ..........
About This Book The Sybase Adaptive Server Enterprise Troubleshooting and Error Messages Guide is a three-volume set. The first volume contains guidelines for system database recovery and other troubleshooting procedures. The second volume contains detailed error message descriptions. This third volume includes the text of all Component Integration Services, Backup Server, and Adaptive Server error messages, along with a glossary and index.
viii
CH A PTE R 4 Backup Server Error Messages This chapter discusses Backup Server errors and Open Server errors related to Backup Server, including: • “Commonly Encountered Errors” • “Error Conditions Without Messages” • “Errors in Backup Server Error Log” • “Open Server Error Messages Related to Backup Server” • “A Listing of All Backup Server Error Messages” Commonly Encountered Errors Following are descriptions of some problems that commonly occur when you use Backup Server.
Commonly Encountered Errors LOGCONN Errors in Adaptive Server After Using Backup Server The Adaptive Server site handler reports this error when the server has unexpectedly lost contact with another site. If the other site is a Backup Server, then a dump or load session has prematurely completed.
CHAPTER 4 Backup Server Error Messages Backup Server: 4.80.2.1: Server, device /dev/44a0e: You must use the no-rewind-on-close tape device. This is not a raw device problem in general, but a DEC HSC (mscp) device issue. Digital UNIX has a known problem on its HSC device driver that causes Backup Server to fail to identify the HSC device type. Digitals's CLD #00266 states that such devices return 0 when queried with “MTIOCGET ioctl.” Warning! Sybase currently supports only SCSI devices on Digital UNIX.
Commonly Encountered Errors isql/user_name="sa". Similarly, the strings 'us_english' and 'iso_1' seen above in single quotes are converted to uppercase. This causes backupserver.exe to interpret these strings in an unexpected manner. Note The runserver file is created in this manner by the sybinit.exe program.
CHAPTER 4 • Backup Server Error Messages Change the HP-UX kernel parameter UNLOCKABLE_MEM. By default, this is 0 which signifies the aforementioned 75% - 25% ratio. Consult HP technical support before changing this parameter. Maximum Number of DBPROCESSes Already Allocated Two scenarios could result in this error.
Errors in Backup Server Error Log Errors in Backup Server Error Log The following error messages may appear in the Backup Server error log. Net-Library routine net_dict_open failed in srv__open_dictionary Net-library routine net_dict_open() failed in srv__open_dictionary() Network error: status = 11 - Could not find addressing dictionary. No server log file open; Using stderr for log. The interfaces file does not exist or cannot be opened.
CHAPTER 4 Backup Server Error Messages No driver of the requested protocol class is available No driver of the requested protocol class is available. This message indicates that the entry in the interfaces file for the requested Backup Server is wrong. Refer to the System Administration Guide Supplement for your platform to find out the correct interfaces file entries. Net-lib protocol driver call to connect two endpoints failed Net-lib protocol driver call to connect two endpoints failed.
A Listing of All Backup Server Error Messages Error 16240.20.0 Many error conditions are associated with this Open Server error, differentiated by the accompanying messages. The following errors begin with the phrase “Open Server Fatal Error 16240.20.0”: Net-Library routine net_address_get() failed in srv__start_net Network error: status = 12 - Specified server name attribute could not be found Backup Server: 1.29.2.1: Unable to start the Backup Server.
CHAPTER 4 Backup Server Error Messages 1 Critical errors 2 3 Open Server event errors Backup Server RPC API errors 4 5 I/O service layer errors (that is, operating system I/O calls) Network data transfer errors 6 7 Archive volume manipulation errors Parser errors (errors in the dump or load command options) 8 Tape auto configuration errors minor numbers order the errors within a major category. There is no special meaning to these numbers; they serve only to distinguish between errors.
Backup Server Error Messages 1.1.2 - 1.63.2 Backup Server Error Messages 1.1.2 - 1.63.2 Number Severity Text and Explanation 1.1.2 2 Memory allocation failed in %1! for a %2! allocation. This DUMP or LOAD session must exit. Explanation: Indicates shortage of virtual memory on the machine running Backup Server. User should terminate unnecessary processes. 1.2.0 0 WAIT Explanation: This informational text may be a component of another message. No action is necessary. 1.3.
CHAPTER 4 Number Severity 1.9.0 0 Backup Server Error Messages Text and Explanation Backup Server This informational text may be a component of another message. No action is necessary. Explanation: 1.10.0 0 DUMP This informational text may be a component of another message. No action is necessary. Explanation: 1.11.0 0 LOAD This informational text may be a component of another message. No action is necessary. Explanation: 1.12.
Backup Server Error Messages 1.1.2 - 1.63.2 694 Number Severity Text and Explanation 1.16.2 2 Error (major = %1!, minor = %2!) raised with unknown severity %3!.n Explanation: Indicates a programming bug in an instance of error reporting. 1.17.2 2 1.18.1 1 Major = %1!, Minor = %2!, Severity = %3!, state = %4!: error text is missing. Explanation: Indicates that localization files are outof-date with the code. Check installation with Sybase Technical Support.
CHAPTER 4 Backup Server Error Messages Number Severity Text and Explanation 1.22.2 2 1.23.2 2 1.24.2 2 1.25.1 1 Unable to configure the maximum number of SRV_PROCS to %1!. Explanation: An attempt to configure the Open Server run-time values to allow the specified number of Server threads failed. Backup Server uses one thread per dump or load connection plus an additional thread for each stripe. Use the -P option to increase the number of threads.
Backup Server Error Messages 1.1.2 - 1.63.2 696 Number Severity Text and Explanation 1.28.2 2 Open Server routine %1! failed. See Backup Server error log for additional information. \n Explanation: Internal error, contact Sybase Technical Support. This is a catch-all message for any Open Server function that raises an error for which Backup Server has determined the affected routine but not the exact error. 1.29.2 2 Unable to start the Backup Server.
CHAPTER 4 Number Severity 1.34.1 1 Backup Server Error Messages Text and Explanation Unable to set one or more trace flags; continuing. Attempt to set the Open Server runtime trace flags failed. Check to see that the trace flags are valid and in the proper format. Explanation: 1.35.0 0 Explanation: This informational text may be a component of another message. No action is necessary. 1.36.1 1 1.37.4 4 Unable to configure Async IO.
Backup Server Error Messages 1.1.2 - 1.63.2 698 Number Severity Text and Explanation 1.41.4 4 1.42.4 4 1.43.4 4 A server named %1! is already running. Could not obtain stop-lock. Explanation: Digital OpenVMS only: another Backup Server with the same logical name is already running. This Backup Server cannot start. STOP semaphore failed, code %1! message %2!. Explanation: Digital OpenVMS only: failed to queue the lock required to shut down Backup Server via stopserver. Backup Server cannot start.
CHAPTER 4 Backup Server Error Messages Number Severity Text and Explanation 1.46.1 1 CSLIB routine %1! failed. See Backup Server error log for additional information. Explanation: This is the catch-all message for CSLibrary (Client/Server Library) functions that return an error. Currently, the only reference to this error occurs when Backup Server is attempting to configure the localization properties of the process. Refer to the Backup Server error log for more information.
Backup Server Error Messages 1.1.2 - 1.63.2 700 Number Severity Text and Explanation 1.50.2 2 Attempt to set Control Status returned operating system error = %1!(%2!). Explanation: An unexpected condition, possibly fatal to the session, has occurred. Error may have occurred with any or all of usage, environment, or internal logic. The session must exit. This is an NT specific message. 1.51.2 2 Service Control Handler received an invalid control code = %1!.
CHAPTER 4 Number Severity 1.56.2 2 Backup Server Error Messages Text and Explanation The SYBASE environment variable must be set. An unexpected condition, possibly fatal to the session, has occurred. Error may have occurred with any or all of usage, environment, or internal logic. The session must exit. Follow any instructions given. Explanation: 1.57.2 2 Backup Server encountered an error while attempting to create a message queue. The Open Server routine srv_createmsgq failed.
Backup Server Error Messages 2.1.2 - 3.55.2 Number Severity Text and Explanation 1.62.2 2 1.63.2 2 Unable to load the Sytos DLL that SYTAPE is set to. Explanation: An unexpected condition, possibly fatal to the session, has occurred. Error may have occurred with any or all of usage, environment, or internal logic. The session must exit. Unable to configure %1! connections and %2! service threads which requires %3! messages. The maximum number of messages is %4!.
CHAPTER 4 Number Severity 2.5.2 2 Backup Server Error Messages Text and Explanation Couldn't define %1! event; Backup Server must exit. An unexpected condition, possibly fatal to the session, has occurred. Error may have occurred with any or all of usage, environment, or internal logic. The session must exit. Login information unavailable. Explanation: The Backup Server could not access the session login information to perform authentication due to unauthorized session initiator or programming bug.
Backup Server Error Messages 2.1.2 - 3.55.2 704 Number Severity Text and Explanation 2.12.2 2 The diagnostic option specifier must be an integer. Option is `%1!' Explanation: An unexpected condition, possibly fatal to the session, has occurred. Error may have occurred with any or all of usage, environment, or internal logic. The session must exit. 2.13.2 2 2.14.2 2 Unable to get connection endpoint. srv_thread_props() returned an error.
CHAPTER 4 Backup Server Error Messages Number Severity Text and Explanation 2.19.2 2 Invalid verbosity level: A verbosity level specifier must be an integer from 0 to 3. Explanation: An unexpected condition, possibly fatal to the session, has occurred. Error may have occurred with any or all of usage, environment, or internal logic. The session must exit. 3.1.2 2 Unrecognized RPC received--ignored. The session initiator sent an unrecognized RPC.
Backup Server Error Messages 2.1.2 - 3.55.2 706 Number Severity Text and Explanation 3.8.2 2 %1!: May not begin phase %2! before completing an earlier phase, number %3!, for which there is uncompleted work. Explanation: Internal error, contact Sybase Technical Support. Violation of the dump synchronization protocol of the RPC API. 3.9.2 2 %1!: May not initiate Backup Server scanning for a phase for which run-lists have been queued. Explanation: Internal error, contact Sybase Technical Support.
CHAPTER 4 Backup Server Error Messages Number Severity Text and Explanation 3.17.2 2 Pathname parameter must specify an absolute pathname. Rejected value: %1! Explanation: Adaptive Server sent its present working directory to the Backup Server and that directory was not recognized as an absolute path specifier. 3.18.2 2 Adaptive Server Enterprise did not specify absolute pathname root before sending the relative device pathname %1!.
Backup Server Error Messages 2.1.2 - 3.55.2 708 Number Severity Text and Explanation 3.24.2 2 %1!: RPC rejected, phase %2! already concluded. Explanation: Internal error, contact Sybase Technical Support. Violation of the dump synchronization protocol of the RPC API. 3.25.2 2 3.26.2 2 %1!: May not submit run lists for phases in which Backup Server conducts the scan. Explanation: Internal error, contact Sybase Technical Support. Violation of the dump synchronization protocol of the RPC API.
CHAPTER 4 Backup Server Error Messages Number Severity Text and Explanation 3.32.2 2 Incorrect type for parameter #%1! for RPC %2!; expected %3! got %4!. Explanation: Internal error, contact Sybase Technical Support. Error in the session initiator (Adaptive Server or Backup Server), a violation of the RPC API. 3.33.2 2 3.34.2 2 SANITY: premature last run list. Explanation: Internal error, contact Sybase Technical Support. SANITY: more stripes than extents.
Backup Server Error Messages 2.1.2 - 3.55.2 710 Number Severity Text and Explanation 3.40.2 2 Illegal length for parameter #%1! for RPC %2!; expected %3! got %4!. Explanation: Internal error, contact Sybase Technical Support. Error in the session initiator (Adaptive Server or Backup Server), a violation of the RPC API. 3.41.2 2 3.42.1 1 Illegal max-length for parameter #%1! for RPC %2!; expected %3! got %4!. Explanation: Internal error, contact Sybase Technical Support.
CHAPTER 4 Backup Server Error Messages Number Severity Text and Explanation 3.48.1 1 The Backup Server will go down immediately. Terminating sessions. Explanation: This is the final message sent to the session that issued the shutdown command. 3.49.2 2 RPC %1! does not allow option %2!. Explanation: An RPC inconsistency was detected. This could be caused by incompatible releases of Backup Server and Adaptive Server. 3.50.
Backup Server Error Messages 4.1.2 - 4.75.3 Backup Server Error Messages 4.1.2 - 4.75.3 712 Number Severity Text and Explanation 4.1.2 2 4.2.3 3 Device `%1!': volume `%2!' appears to contain data written in a format that the Backup Server does not recognize. Please use a different volume, or initialize this volume through the operating system. Explanation: Digital OpenVMS only: the tape may be of foreign origin. Digital OpenVMS volume init may know how to confirm that data can be overwritten.
CHAPTER 4 Number Severity 4.7.2 2 Backup Server Error Messages Text and Explanation Device %1! already in use. A session attempted to use an archive device owned by another session. Select a different archive device. Explanation: 4.8.2 2 Mirror device types don't match: %1!. Explanation: This error is part of a not yet implemented feature, included here only for completeness. 4.9.2 2 Label validation error: read returned %1! reading label.
Backup Server Error Messages 4.1.2 - 4.75.3 714 Number Severity Text and Explanation 4.16.2 2 4.17.2 2 Label validation error: read of tape mark failed. Explanation: Errors similar to 4.9.2–4.12.2. The stripes on the specified devices have completed, but more dump stripes exist. Explanation: This message arises when loading from fewer stripes than the number used at dump time. At load time, there must be at least one instance of every device type used at dump time. 4.18.
CHAPTER 4 Backup Server Error Messages Number Severity Text and Explanation 4.25.2 2 Device `%1!': %2! is an inappropriate density value for this device. Explanation: Digital OpenVMS only: the density value specified in the dump or load command is not valid. Expected values are: none specified, 800, 1600, 6250, 6666, 10000, and 38000. 4.26.2 2 4.27.2 2 Volume validation error: failed to obtain device information, device: %1! error: %2!.
Backup Server Error Messages 4.1.2 - 4.75.3 716 Number Severity Text and Explanation 4.33.2 2 Header labels of rejected volume: Explanation: Display of the data Backup Server found where it expected ANSI volume labels. Verify that the proper volume is loaded. 4.34.1 1 4.35.1 1 Device `%1!':\nVolume name:'%2!'\n Explanation: Information, no user action necessary.
CHAPTER 4 Number Severity 4.43.2 2 Backup Server Error Messages Text and Explanation Couldn't create multibuffering subprocess. Backup Server was unable to complete start-up of the multibuffering subprocess. File descriptors may be exhausted (Error 4.42). Retry session when Backup Server activity is lower. Possible virtual memory shortage (Error 4.43). Explanation: 4.45.2 2 The maximum number of %1! stripe devices has been exceeded.
Backup Server Error Messages 4.1.2 - 4.75.3 718 Number Severity Text and Explanation 4.53.2 2 4.54.2 2 4.55.2 2 4.56.2 2 4.57.2 2 4.58.1 1 4.59.3 3 The load command specifies too many devices of type `%1!': expected %2!, got %3!. Explanation: Similar to 4.52.2; however, this is the reverse case. Backup Server cannot load from more stripes than were used for the original dump. The load command specifies too few devices of type `%1!': expected %2!, got %3!.
CHAPTER 4 Number Severity 4.60.2 2 Backup Server Error Messages Text and Explanation Archive device %1! does not support a valid tapemark. An unexpected condition, possibly fatal to the session, has occurred. Error may have occurred with any or all of usage, environment, or internal logic. Archive device %1! does not support %2! operation. Explanation: An unexpected condition, possibly fatal to the session, has occurred. Error may have occurred with any or all of usage, environment, or internal logic.
Backup Server Error Messages 4.1.2 - 4.75.3 720 Number Severity Text and Explanation 4.67.2 2 Device %1!: This tape device requires the CAPACITY option. Explanation: Backup Server does not know how to detect end-of-tape on this device. Therefore capacity must be specified on dump, or you must specify the device as a logical device name from sysdevices. 4.68.2 2 Write data to a network device (slave site: %1!, device: %2!) failed. Explanation: This messages are self-explanatory.
CHAPTER 4 Backup Server Error Messages Number Severity Text and Explanation 4.74.2 2 Unable to %1! database information file %2! : %3!. Explanation: UNIX Backup Servers use a temporary file (created in /tmp) to pass database device names to the sybmultbuf program. An I/O error with this file has occurred. User should verify that /tmp is worldwritable, has sufficient space, and contains no unused files of the form BS_servername.number. 4.75.3 3 Device %1!: %2! is not a legal virtual disk number.
Backup Server Error Messages 4.76.3 - 4.147.2 722 Number Severity Text and Explanation 4.79.2 2 Server %1!, device %2!: illegal I/O size %3!--max %4!. Explanation: Indicates a programming bug in a local or remote Backup Server. The I/O service layer has received a read or write request size that exceeds the available buffer size. 4.80.2 2 Server %1!, device %2!: You must use the no-rewindon-close tape device.
CHAPTER 4 Backup Server Error Messages Number Severity Text and Explanation 4.86.2 2 Unable to initialize Async IO on the database device %1!. Backup Server must use Async IO on a block special devices because Adaptive Server Enterprise is doing the same. Explanation: This is an HP-specific error. If Adaptive Server Enterprise is using asynchronous I/O for a block special device, then backup Server must do the same in order to guarantee disk coherency.
Backup Server Error Messages 4.76.3 - 4.147.2 724 Number Severity Text and Explanation 4.92.2 2 Unregistering of application failed. OS error returned %1!. Explanation: An unexpected condition, possibly fatal to the session, has occurred. Error may have occurred with any or all of usage, environment, or internal logic. 4.93.2 2 4.94.2 2 Read from %1! failed: OS error returned %2!, errno %3!. Explanation: An unexpected condition, possibly fatal to the session, has occurred.
CHAPTER 4 Backup Server Error Messages Number Severity Text and Explanation 4.99.2 2 Open unable to mount media for device %1! : OS error returned %2!. Explanation: An unexpected condition, possibly fatal to the session, has occurred. Error may have occurred with any or all of usage, environment, or internal logic. 4.100.2 2 4.101.2 2 Unable to dismount media for device %1! : OS error returned %2!. Explanation: An unexpected condition, possibly fatal to the session, has occurred.
Backup Server Error Messages 4.76.3 - 4.147.2 726 Number Severity Text and Explanation 4.106.2 2 4.107.2 2 Unable to forward a file mark: OS error returned %1! . Explanation: An unexpected condition, possibly fatal to the session, has occurred. Error may have occurred with any or all of usage, environment, or internal logic. Error in forwarding %1! file marks. Explanation: An unexpected condition, possibly fatal to the session, has occurred.
CHAPTER 4 Number Severity 4.113.2 2 Backup Server Error Messages Text and Explanation Unable to go to end of media. An unexpected condition, possibly fatal to the session, has occurred. Error may have occurred with any or all of usage, environment, or internal logic. Unable to retension device. Explanation: An unexpected condition, possibly fatal to the session, has occurred. Error may have occurred with any or all of usage, environment, or internal logic. Explanation: 4.114.2 2 4.115.2 2 4.116.
Backup Server Error Messages 4.76.3 - 4.147.2 728 Number Severity Text and Explanation 4.120.3 3 4.121.3 3 Unable to locate state information for this stripe. Explanation: An unexpected condition, possibly fatal to the session, has occurred. Error may have occurred with any or all of usage, environment, or internal logic. Local semaphore handle is NULL for asynchronous disk i/o. Explanation: An unexpected condition, possibly fatal to the session, has occurred.
CHAPTER 4 Backup Server Error Messages Number Severity Text and Explanation 4.127.2 2 Internal Error on device %1!: Attempting to determine if device is non-rewinding. Failed to get the OS version when converting data returned from uname(2). Explanation: An unexpected condition, possibly fatal to the session, has occurred. Error may have occurred with any or all of usage, environment, or internal logic. 4.128.2 2 4.129.2 2 Failed to start multibuffering subprocesses for archive device `%1!'.
Backup Server Error Messages 4.76.3 - 4.147.2 730 Number Severity Text and Explanation 4.133.2 2 Invalid path or no execute permission for multibuffering subprocess binary: %1! Explanation: The sybmultbuf binary could not be found. Check the pathname in the -M option or $SYBASE/bin for the existence of sybmultbuf binary (in NT sybmbuf.exe). Also, check if the binary has execute permissions. 4.134.2 2 4.135.2 2 Invalid Device: you cannot dump to or load from the null device, '%1!'.
CHAPTER 4 Backup Server Error Messages Number Severity Text and Explanation 4.140.2 2 4.141.2 2 [%1!] The '%2!' call failed with error number %3! (%4!). Refer to your operating system documentation for further details. Look for '%5!' in the backup server errorlog for additional information from SYBMULTBUF. Explanation: The message has 93 secondary state values used to determine where a failure occurred in sybmultbuf. [%1!] The '%2!' call failed for device '%3!' with error number %4! (%5!).
Backup Server Error Messages 5.1.2 - 6.89.2 Number Severity Text and Explanation 4.147.2 2 Operating system error. Code %1! message %2!. Explanation: The message has 93 secondary state values used to determine where a failure occurred in sybmultbuf. Backup Server Error Messages 5.1.2 - 6.89.2 Number Severity Text and Explanation 5.1.2 2 5.2.2 2 The mirror devices (site: %1!) and the primary device(site: %2!) must reside at the same site.
CHAPTER 4 Backup Server Error Messages Number Severity Text and Explanation 5.8.2 2 5.9.2 2 RPC as_cmd execution failed - slave server: %1!, device: %2!, command type: %3!. Explanation: These messages point to difficulties in issuing an RPC to a remote Backup Server. Probable cause is an Open Server programming error. RPC as_pagerun execution failed - slave server: %1!, device: %2!. Explanation: These messages point to difficulties in issuing an RPC to a remote Backup Server.
Backup Server Error Messages 5.1.2 - 6.89.2 734 Number Severity Text and Explanation 5.17.2 2 Cannot get the character set currently in use. Explanation: The remote Backup Server could not set the character set to its default setting for the initial connection from a client of the local Backup Server. 5.18.2 2 Cannot set character set `%1!' in the login record. Explanation: The remote Backup Server could not set the character set to the set specified by the remote connection. 5.19.
CHAPTER 4 Number Severity 6.31.2 2 Backup Server Error Messages Text and Explanation Volume rejected. Backup Server refuses to use the mounted volume. Adjacent messages provide more detail. The volume either has non-ANSI structure or there is a Backup Server programming error. %1!: volume not valid or not requested (server: %2!, session id: %3!.) Explanation: The data on the device is not in proper dump format. If you are loading, use another volume. If you are dumping, user may overwrite.
Backup Server Error Messages 5.1.2 - 6.89.2 Number Severity Text and Explanation 6.40.0 0 disk Explanation: Internal informational message, usually a component of another message. No user action necessary. 6.41.1 1 Header labels of mounted volume: Explanation: Preamble message to display labels of mounted volume. 6.42.0 0 disk file Explanation: Internal informational message, usually a component of another message. No user action necessary. 6.43.
CHAPTER 4 Backup Server Error Messages Number Severity Text and Explanation 6.50.1 1 %1!: Dumpfile `%2!' section %3! found instead of `%4!' section %5!. Explanation: The volume just read is out of order. Mount the correct volume. 6.51.1 1 %1!: Mount the next volume to search. Explanation: Reports that the requested dumpfile (specified by the file option) was not found on the volume. 6.52.1 1 6.53.1 1 6.54.1 1 6.55.1 1 6.56.
Backup Server Error Messages 5.1.2 - 6.89.2 738 Number Severity Text and Explanation 6.65.2 2 Volume validation error: illegal volume change, device %1!: volume for stripe %2! mounted while stripe %3! loading still in progress. Explanation: Reminds user that all volumes of a dump-time stripe must complete loading on the device before the first volume of another dump-time stripe may begin loading. 6.66.2 2 6.78.
CHAPTER 4 Backup Server Error Messages Number Severity Text and Explanation 6.83.2 2 Volume validation error: Volume name mismatch, volume name %1!, expected volume name %2!. Explanation: Volumes within a stripe must have the same name in the ANSI VOL1 label. It is possible for a user to execute the dump command properly and still receive this error at load time, if the first volume was overwritten using the dumpvolume option and the second volume, with a different name, was appended to. 6.84.
Backup Server Error Messages 7.1.2 - 8.17.2 Backup Server Error Messages 7.1.2 - 8.17.2 740 Number Severity Text and Explanation 7.1.2 2 7.2.2 2 Memory error: failed to allocate an `%1!' structure. Explanation: Not enough memory available to Backup Server. See “Note” at the top of this section. Option `%1!': %2! is an invalid value; value must be an even multiple of %3!. Explanation: Illegal value for a dump or load option. 7.3.2 2 Option error: when you specify %1!, you may not specify %2!.
CHAPTER 4 Number Severity 7.12.2 2 Backup Server Error Messages Text and Explanation Option `%1!' requires a value, but none was specified. You must specify a value for these options: density, blocksize, capacity, dumpvolume, retaindays, or file. Explanation: 7.13.2 2 Option `%1!': `%2!' is not unique -- supply more characters. Explanation: User abbreviated a keyword following a value, and the abbreviation is ambiguous. 7.14.2 2 Option error: when you specify %1!, you must also specify %2!.
Backup Server Error Messages 7.1.2 - 8.17.2 742 Number Severity Text and Explanation 8.4.2 2 Device %1!: Auto-configuration failure. This tape device is not supported. Explanation: An unexpected condition, possibly fatal to the session, has occurred. Error may have occurred with any or all of usage, environment, or internal logic. 8.5.1 1 Warning, unable to open device configuration file %1! for reading. Operating system error %2!.
CHAPTER 4 Backup Server Error Messages Number Severity Text and Explanation 8.12.2 2 Device %1!: the operating system device type is different than what is in the configuration file %2!. Please remove entry for this device in the configuration file and reconfigure the device by issuing a DUMP with the INIT qualifier. Explanation: An unexpected condition, possibly fatal to the session, has occurred. Error may have occurred with any or all of usage, environment, or internal logic. 8.13.
Backup Server Error Messages 7.1.2 - 8.17.
CH A PTE R 5 Component Integration Services Error Messages This chapter gives the error number, message text, and a brief explanation for Component Integration Services error messages. Component Integration Services Error Messages Number Severity Text and Explanation 11201 16 A remote table definition must be defined before the `existing' option is used (object `%.*s').
Component Integration Services Error Messages Number Severity Text and Explanation 11205 16 Datatype `%s' is unsupported for server `%.*s'. Explanation: The datatype is not supported by the server where the remote object is located. Rewrite the command using a valid datatype. 11206 16 Unable to connect to server `%.*s'.
CHAPTER 5 Component Integration Services Error Messages Number Severity Text and Explanation 11212 16 Identity attribute mismatch for column `%.*s'; (defined: `%s' found: `%s'). Explanation: Refer to the writeup “Problem Retrieving Data From Remote Objects” in Appendix A “Troubleshooting” of the Component Integration Services User's Guide. 11213 16 Column count mismatch in remote object `%.*s'; (defined: %d found %d).
Component Integration Services Error Messages Number Severity Text and Explanation 11219 17 Cannot open a connection to site `%.*s' because there are no free remote descriptors (RDES). Increase the configuration parameter for user connections and reboot the server. 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.
CHAPTER 5 Number Severity 11226 16 Component Integration Services Error Messages Text and Explanation Server class (%d) for server `%.*s' is not supported. An invalid server class has been defined for the remote server. Use sp_helpserver to check the server definition, and have your System Administrator correct the entry. Statement `%s' is unsupported by `%.*s'.
Component Integration Services Error Messages Number Severity Text and Explanation 11233 16 Column mismatch in remote object `%.*s' for column `%.*s'; (column must be defined with length >= 10 or as DATETIME). Explanation: Refer to the writeup “Problem Retrieving Data From Remote Objects” in Appendix A “Troubleshooting” of the Component Integration 11234 16 11235 16 11236 16 Update or `complex INSERT' of non-NULL TEXT/IMAGE data is unsupported by server `%.*s'. Use WRITETEXT instead.
CHAPTER 5 Number Severity 11243 10 Component Integration Services Error Messages Text and Explanation Component Integration Services recovery complete. This is an informational message. No action is required. Explanation: 11244 10 11245 10 11246 16 11247 16 Deallocating text/image data for external object `%.*s'. Explanation: This is an informational message. No action is required. Checking external objects. Explanation: This is an informational message. No action is required.
Component Integration Services Error Messages Number Severity Text and Explanation 11253 10 Dynamic Delete Explanation: This is an informational message generated by showplan. No action is required. 11254 10 11255 10 11256 10 Select for Delete Explanation: This is an informational message generated by showplan. No action is required. Remote Cursor Operation Explanation: This is an informational message generated by showplan. No action is required. %.
CHAPTER 5 Component Integration Services Error Messages Number Severity Text and Explanation 11267 16 Unable to create table '%.*s' on remote server; this server not configured for heterogeneous data access. Explanation: Command failed. Contact your System Administrator to install the Extended Enterprise Option of Adaptive Server Enterprise prior to accessing remote servers that are not server class sql_server.
Component Integration Services Error Messages Number Severity Text and Explanation 11273 10 Encounter %d conversion errors during processing of external statistics; some rows have been ignored. Explanation: update statistics cannot generate complete statistics because the proxy table has columns with datatypes or widths that are different from the corresponding column at the remote location. 11277 16 Operating system error %d: ’%.*s’. Command failed. Check query syntax and semantics.
CH A PTE R 6 Adaptive Server Error Messages This chapter contains the text of all the numbered Adaptive Server error messages through 14007. Each message is followed by a short explanation and brief instructions on what to do when you see the error. Messages in the 17xxx and 18xxx series are informational and error messages returned by stored procedures.
Working with Error Messages Use this chapter as an error reference. Look up the error number and note the severity. Then use the accompanying explanation (available for most, though not all, messages) to determine your next course of action. If the error is one of the commonly occurring server messages documented in the chapter “Error Message Writeups,” the explanation will refer you to that chapter. In other cases, it gives you guidance on the nature of the error and what to do next.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 1 - 199 Number 21 Severity 10 Text and Explanation WARNING - Fatal Error %ld occurred at %S_DATE. Please note the error and time, and contact a user with System Administrator (SA) authorization. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 101 15 Line %d: SQL syntax error. Explanation: Command failed.
Server Error Messages 1 - 199 Number Severity Text and Explanation 110 15 111 15 There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. %s must be the first command in a query batch. Explanation: Command failed.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 121 15 The SELECT list for the INSERT statement contains more items than the INSERT list. The number of SELECT values must match the number of INSERT columns. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. 122 15 The debug option `%d' is larger than the maximum allowed. The highest option available is %d.
Server Error Messages 1 - 199 Number Severity Text and Explanation 133 15 A GOTO statment references the label `%.*s' but the label has not been declared. Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. Explanation: 134 15 The variable name `%.*s' has already been declared. Variable names must be unique within a query batch or stored procedure. Explanation: Command failed. Check syntax and semantics.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 146 15 Cannot perform an aggregate function on a column from a table not declared in the same subquery. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
Server Error Messages 1 - 199 Number Severity Text and Explanation 159 15 For DROP INDEX, must give both the table and the index name, in the form tablename.indexname Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. 160 15 Rule does not contain a variable. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 172 15 Can't use HOLDLOCK in Browse Mode Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. Explanation: 173 15 174 15 175 15 176 15 The definition for column `%.*s' must include a datatype. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. The function `%.
Server Error Messages 1 - 199 Number Severity Text and Explanation 184 15 Invalid money datatype specification for column `%.*s'. Only money(19, 4) is allowed for non-external tables. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. 185 15 Data stream is invalid for WRITETEXT command in bulk form. Explanation: Command failed due to invalid or illegal request. Adaptive Server cannot perform the requested action.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 197 15 WITH CHECK OPTION is not allowed in the definition of a union view. Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. Explanation: 198 15 199 15 Browse mode is invalid for statements containing set operators. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
Server Error Messages 200 - 299 Number Severity Text and Explanation 207 16 Invalid column name `%.*s'. Refer to the writeup for Error 207. %.*s not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output). Explanation: Refer to the writeup for Error 208. Explanation: 208 16 209 16 Ambiguous column name %.*s Command failed. Check syntax and semantics. A column name may need the full table specification or alias.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 221 16 Column of type (%s) does not allow nulls. It may not be compared with null. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Explanation: 222 20 Unintelligible query plan step encountered. Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server.
Server Error Messages 200 - 299 Number Severity Text and Explanation 234 16 There is insufficient result space to convert MONEY value to CHAR. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Explanation: 235 16 236 16 237 16 238 16 Precision error during %S_MSG conversion of %s value `%s' to a %s field. Explanation: Command failed due to invalid or illegal request.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 246 16 The conversion of CHAR value `%.*s' overflowed an INT2 field, use a larger integer field. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 247 16 248 16 Arithmetic overflow during %S_MSG conversion of %s value `%s' to a %s field . Explanation: Refer to the writeup for Error 247.
Server Error Messages 200 - 299 Number Severity Text and Explanation 257 16 Implicit conversion from datatype `%s' to `%s' is not allowed. Use the CONVERT function to run this query. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 258 20 Database `%.*s' missing during query recompile. Explanation: Adaptive Server encountered an internal error affecting the current process.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 269 16 NULL value cannot be specified for conversion from datatype `%s' to `%s'. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Explanation: 270 16 Table `%.*s' can't be modified. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions.
Server Error Messages 200 - 299 Number Severity Text and Explanation 282 10 Procedure `%.*s' attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 283 16 You can't use browse mode with DBLIB 2.0 -- you must upgrade to DBLIB 4.0 in order to run this query.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 296 16 The conversion of CHAR to SMALLDATETIME resulted in a SMALLDATETIME value out of range. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 297 16 There is insufficient result space to convert SMALLDATETIME value to CHAR. Explanation: Adaptive Server could not perform the requested action.
Server Error Messages 300 - 399 Number Severity Text and Explanation 307 10 Index `%.*s' specified as optimizer hint in the FROM clause of table `%.*s' does not exist. Optimizer will choose another index instead. Explanation: This is an informational message but may require follow-up action. Contact your System Administrator. 308 20 309 20 310 10 311 16 312 16 313 16 314 16 315 16 316 17 Table not open for range table entry `%d', objid `%ld', dbid `%d'.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 317 16 A subquery in this query is correlated to an inner table of an outerjoin. This is not allowed in TSQL semantics. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
Server Error Messages 400 - 499 Server Error Messages 400 - 499 Number 401 Severity 16 Text and Explanation Unimplemented command or expression %s. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 403 16 Invalid operator for datatype op: %s type: %s. Refer to the writeup for Error 403. Too many ANDs or ORs in expression (limit %d per expression level). Try splitting query or limiting ANDs and ORs.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 411 20 Compute clause #%d, aggregate expression #%d is not in the select list. 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. Explanation: 412 16 Cannot update more than 1 sysindexes row at a time. Explanation: Adaptive Server could not perform the requested action.
Server Error Messages 400 - 499 Number Severity Text and Explanation 423 20 424 20 Table referenced in a foreign key constraint is missing, database = `%S_DBID', table = `%S_OBJID'. Explanation: This error is caused by an Adaptive Server problem which allows a referenced table in a referential integrity constraint to be dropped. Contact Sybase Technical Support to upgrade to a version in which the problem is resolved.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 432 16 Security Label datatypes may not be used in an ORDER BY clause. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Explanation: 433 17 434 16 435 16 436 16 441 18 442 16 444 16 445 16 Unable to allocate work table to process referential constraint. Query exceeds the maximum limit (%d) of work tables.
Server Error Messages 500 - 599 Number Severity Text and Explanation 446 16 The COMPUTE clause #%d, aggregate expression #%d may produce a result that is wider than 255 bytes, the maximum computed result allowed. Explanation: Adaptive Server could not perform the requested action. Check query. Server Error Messages 500 - 599 Number 501 Severity 20 Text and Explanation There is no result-list for a SELECT statement.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 513 16 A column insert or update conflicts with a rule imposed by a previous CREATE RULE command. The command was aborted. The conflict occurred in database `%S_DBID', table `%S_OBJID', column `%.*s' Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. (Not raised in Release 11.0 and higher.
Server Error Messages 500 - 599 Number Severity Text and Explanation 526 18 SQL Server has run out of alarms. Re-run your command when there are fewer users running WAITFOR, or ask your System Administrator to raise the configuration parameter ’number of alarms’. Explanation: Retry later, or increase the configuration parameter `number of alarms'. 527 20 Cannot remove alarm. Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 538 16 `%.*s' cannot be found. This language might have been dropped. Please contact a user with System Administrator (SA) role. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 539 20 Unexpected internal access methods error %d, state %d.
Server Error Messages 500 - 599 Number Severity Text and Explanation 548 16 Check constraint violation occurred, dbname = `%.*s', table name = `%.*s', constraint name = `%.*s'.%S_EED Explanation: Adaptive Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message. 549 18 Constraint violation occurred, bad constraint type passed to the exception handler. Explanation: Command failed due to internal Adaptive Server problem.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 558 16 Attempt to open cursor `%.*s' which is already open. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Explanation: 559 16 Attempt to use a cursor `%.*s' which is not open. Use the system stored procedure sp_cursorinfo for more information. Explanation: Command failed due to invalid or illegal request.
Server Error Messages 500 - 599 Number Severity Text and Explanation 569 16 The specified object with object ID `%d' is not found. Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects, variable names, and/or input data. Explanation: 570 14 Only a person with System Security Officer (SSO) role can change another person's password. Explanation: You do not have the permission to execute this command.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 580 18 Unable to update Syslogins in the set_password builtin. Password left unchanged. Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator. Explanation: 581 18 Unable to open Syslogins table in the set_password builtin. Password left unchanged. Explanation: Command failed due to internal Adaptive Server problem.
Server Error Messages 500 - 599 Number Severity Text and Explanation 590 16 Dynamic SQL error - Prepared statement `%.*s' does not exist. Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects, variable names, and/or input data. Explanation: 591 16 592 16 593 16 The UPDATE WHERE CURRENT OF to the cursor `%.*s' failed because column `%.*s' being updated was not specified in the FOR UPDATE OF list. Explanation: Command failed.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 600 - 699 Number 601 Severity 21 Text and Explanation Descriptor for system table `%ld' in database `%d' not found in the descriptor hash table. Explanation: Refer to the writeup for Error 601. 602 21 Could not find row in sysindexes for dbid `%d', object `%ld',index `%d'. Run DBCC CHECKTABLE on sysindexes. Explanation: Adaptive Server encountered an internal error affecting all processes in the current database.
Server Error Messages 600 - 699 Number Severity Text and Explanation 612 21 Attempt made to log a row of unknown type %d. Attempt made to write a log record of unknown type. Report the error to your System Administrator. Explanation: 613 21 Request made to retrieve more rows from an already completed scan of object `%.*s' in database `%.*s'. Explanation: Adaptive Server encountered an internal error affecting all processes in the current database. Report the error to your System Administrator.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 622 20 623 21 Opentable was passed a varno of %d. Object ’%.*s’ in database ’%.*s’ already has that session descriptor in use. This occured while opening object id %d in database id %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.
Server Error Messages 600 - 699 Number Severity Text and Explanation 634 20 Memmove() was called with an address of 0x%lx and a length of %d - which would cross the boundary address of 0x%lx. Explanation: There is a possible Adaptive Server problem. Run dbcc checks on the database that was being accessed when the error occurred. 635 20 Process %d tried to remove DES resource lock that it doesn't hold - %S_DES . Explanation: Report the error to your System Administrator. (Not raised in Release 11.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 649 21 650 26 Could not find the clustered index entry for Page %ld Objid %ld status 0x%x. Index page %ld was searched for this entry in database `%.*s'. 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. Page %ld of table ’%.
Server Error Messages 600 - 699 Number Severity Text and Explanation 660 10 Index id %d cannot be used to access table id %d as it is SUSPECT. Please have the SA run the DBCC REINDEX command on the specified table. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 661 21 As part of a transaction rollback, an attempt was made to modify object `%S_OBJID' in database `%.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 669 18 670 16 671 14 The length computation of the row %d is wrong. Ensure that row-length is no greater than max possible size of %d. This error was detected during cursor scan fixups for cursor ’%.*s’. This is an internal error. The processing is being stopped for the current query. Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message.
Server Error Messages 600 - 699 Number Severity Text and Explanation 678 20 Invalid Buffer Cache Access: Could not open object `%ld' in database `%d' 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. Explanation: 679 20 Inconsistent update state found during expensive direct update of object `%ld'.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 690 20 Pageno in lk_pglocked (%ld) different from lockobj (%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. 691 20 Encountered invalid logical page '%ld' while accessing object '%ld' in database '%d'. This is an internal system error.
Server Error Messages 700 - 799 Number Severity 702 20 Text and Explanation Memory request for %d bytes exceeds the size of single page of %d bytes. Refer to the writeup for this error. You cannot run this procedure, trigger, or SQL batch because it requires more than %ld pages of memory. Break it up into shorter queries, if possible. Explanation: Refer to the writeup for this error.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 800 - 899 Number 801 Severity 20 Text and Explanation Process %d tried to remove resource lock it doesn't hold on buffer 0x%lx - %S_PAGE in cache %s. Explanation: Check the Adaptive Server error log for 1105 or other errors. Restart Adaptive Server. Unable to place buffer `0x%lx' from cache `%.*s' holding logical page `%ld' in sdes for object `%.*s' - either there is no room in sdes or buffer already in requested slot.
Server Error Messages 800 - 899 Number Severity Text and Explanation 811 21 Attempt to grab buffer (from cache `%.*s') which is on descriptor chain. Report the error to your System Administrator. Adaptive Server must be restarted and DBCC diagnostics run. This error occurs in diagserver. Explanation: 812 21 813 20 814 20 815 21 816 20 817 20 818 19 Attempt to grab a pinned buffer. Explanation: Adaptive Server encountered an internal error affecting all current processes.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 821 20 Attempt to unhash buffer in cache `%.*s' at `0x%lx' with a buffer pageno of `%ld' and database id `%ld' with HASHED status set failed - buffer was not found. `%S_PAGE'. Explanation: Refer to the writeup for this error. 822 21 823 24 Could not start I/O for request BLKIO flags = 0x%lx, size = %ld, errcode = 0x%lx, %S_BUF. Explanation: Refer to the writeup for this error.
Server Error Messages 800 - 899 Number Severity Text and Explanation 831 20 832 20 833 20 834 20 Unable to find buffer 0x%x holding logical page %ld in sdes 0x%x, aux keep struct 0x%x, for object `%.*s'. 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. Unable to place buffer 0x%x holding logical page %ld in sdes for object `%.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 841 10 Attempt to set bufreserves in RESOURCE structure to negative value while unclaiming cache. Explanation: This is an informational message but may require follow-up action. Contact your System Administrator. 842 20 843 20 Attempt to set bufclaims in PSS structure for process %d to negative value while unclaiming cache. Explanation: Adaptive Server encountered an internal error affecting the current process.
Server Error Messages 800 - 899 Number Severity Text and Explanation 850 20 851 20 852 20 853 16 Wrong cache descriptor in buffer `0x%x', page `%d', dbid `%d'. Cache descriptor points to cache `%.*s'. Explanation: Internal error with a buffer pointer. Reconnect to Adaptive Server. Report the error to your System Administrator so DBCC diagnostics can be run. (Not raised in Release 11.0 and higher.) Wrong cluster mask for cache `%.*s', mask encountered = %d, should = %d.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 860 20 Invalid Buffer Cache Access: Attempt to locate page `%ld', dbid `%ld' objid `%ld', indid `%ld' in cache failed because the cache ID was not set in the scan_context structure. Contact Technical Support for assistance. 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.
Server Error Messages 800 - 899 Number Severity Text and Explanation 870 10 WARNING!!! You may have to change the log I/O size for the database `%.*s'. Current setting is `%dK' and the cache `%.*s' does not have a `%dK' memory pool. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 879 21 880 10 Task %d was expected to hold exclusive latch on buffer 0x%x of page %ld in database %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. Your query is blocked because it tried to write and database ’%.*s’ is in quiesce state.
Server Error Messages 900 - 999 Number Severity Text and Explanation 908 22 Unable to find any entries in sysusages for dbid `%d', database `%S_DBID'. Run DBCC CHECKTABLE on sysusages in the master database. Explanation: A table or index may be corrupt. Report the error to your System Administrator. Adaptive Server must be restarted and dbcc diagnostics run. 909 21 910 17 More than %d entries required to build the logical-virtual translation table for database `%S_DBID'.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 919 21 920 22 921 14 Database `%.*s' was marked `suspect' by an earlier attempt at recovery. Check the SQL Server errorlog for information as to the cause. 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.
Server Error Messages 900 - 999 Number Severity Text and Explanation 931 21 Database `%.*s' cannot be opened because of a failure to initialize the global timestamp. This indicates that a problem exists in the log for the current database. Please contact Technical support for assistance. 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.
CHAPTER 6 Number Severity 942 20 Adaptive Server Error Messages Text and Explanation Database cannot be opened because a system descriptor cannot be installed. Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator. Explanation: 943 14 944 20 945 21 946 10 947 14 948 14 949 14 Database `%.*s' cannot be opened since an attempt to upgrade it was unsuccessful. Explanation: Command failed.
Server Error Messages 900 - 999 Number Severity Text and Explanation 952 20 Database '%.*s' cannot be opened because a system index descriptor cannot be installed. 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. 953 11 Page '%ld', passed to curunreservedpgs built-in function, is an invalid page number in database ID '%d'.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 1000-1099 Number 1000 Severity 18 Text and Explanation Abstract Plan (AP) Internal Error : An error occurred while looking for the AP group ID in sysattributes. If the error persists, please contact Sybase Technical Support. Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by the message. Report the error to your System Administrator.
Server Error Messages 1000-1099 Number Severity Text and Explanation 1007 16 1008 16 Abstract Plan (AP) : The AP expression describes a bushy join tree, while the Server only supports left deep join trees. The bushy right join operand will not be applied. Check the AP syntax. Explanation: Adaptive Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 1016 16 Abstract Plan (AP) : There is no destination group for the new AP. The AP was not created. Specify a destination group within the statement or enable the AP capture mode. Explanation: Adaptive Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message. 1017 18 1018 16 1019 16 1020 16 Abstract Plan (AP) : sysqueryplans manager error.
Server Error Messages 1100-1199 Server Error Messages 1100-1199 Number 1101 Severity 17 Text and Explanation Unable to allocate new page for database `%.*s'. There are no more pages available on valid allocation pages. Space can be created by dropping objects, extending the database, or dumping the log with no_log. Explanation: Command failed due to resource limitation.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 1109 21 1110 20 Attempt to read allocation page %ld failed either because object ID is not correct (%ld) or the page ID is not correct (%ld). 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. (Not raised in Release 11.0 and higher.
Server Error Messages 1100-1199 Number Severity Text and Explanation 1120 20 Adaptive Server failed to access page %ld in database ’%.*s’ because it is not an allocation page. Explanation: Refer to the writeup for this error. 1122 20 Attempt to read allocation page before openning SYSALLOCPGS. 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.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 1132 22 Attempted to log allocation to the log. Report the error to your System Administrator. Adaptive Server must be restarted. Explanation: 1133 22 Page %ld was expected to be an OAM page for %ld and it is not. Explanation: Refer to the writeup for this error. 1134 20 Failed to get lock on OAM page %ld. This should never happen. Adaptive Server encountered an internal error affecting the current process.
Server Error Messages 1100-1199 Number Severity Text and Explanation 1143 22 Invalid OAM Page %ld. Expected object=%ld. Found object=%ld, database=%d, pstat=0x%x, indid=%d. Explanation: Refer to the writeup for this error. 1144 21 Page number %ld is higher than the highest page in database `%.*s': %ld. Explanation: Adaptive Server encountered an internal error affecting all processes in the current database. Report the error to your System Administrator.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 1154 16 WARNING!!! Attempt to do a prefetch of size %dK is not allowed. The prefetch request is reset to the maximum prefetch size of %dK. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 1155 20 1156 20 Invalid page validation type, %d, requested for page %ld, object %S_OBJID, indid %d in database %S_DBID.
Server Error Messages 1200-1299 Number Severity Text and Explanation 1205 13 Your server command (process id #%d) was deadlocked with another process and has been chosen as deadlock victim. Re-run your command. Explanation: Refer to the writeup for this error. 1221 26 1222 26 1223 26 Lock free chain linkage has been corrupted. Explanation: An internal locking/synchronization rule was broken. Report the error to your System Administrator. Shut down and restart Adaptive Server.
CHAPTER 6 Number Severity 1233 26 Adaptive Server Error Messages Text and Explanation An incorrect lock structure is linked a chain of lock structures. An internal locking/synchronization rule was broken. Report the error to your System Administrator. Shut down and restart Adaptive Server. Explanation: 1234 26 1235 26 1236 26 1237 26 An incorrect lock structure is linked to a semaphore. Explanation: An internal locking/synchronization rule was broken. Shut down and restart Adaptive Server.
Server Error Messages 1200-1299 Number Severity Text and Explanation 1247 26 Process attempting to wait on a lock that has already been waited for. An internal locking/synchronization rule was broken. Report the error to your System Administrator. Shut down and restart Adaptive Server. Explanation: 1249 20 1250 26 1251 26 1252 26 Process became runnable before lock it was waiting for was released. Explanation: Adaptive Server encountered an internal error affecting the current process.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 1261 20 1262 20 Attempt to promote from page to table locking on objid %ld encountered an internal error. 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. No matching xdes found. Lock was requested for objid %ld, dbid %d, type %d, by process %d.
Server Error Messages 1200-1299 Number Severity Text and Explanation 1272 20 Invalid parameter(s) passed to lock manager. 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. Explanation: 1273 16 Syntax error at line %d of file %s starting at `%s'. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 1283 19 Could not change deadlock checking period because SQL Server has run out of alarms. Please retry the command later. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 1284 26 Used Lock Sleeptask Entry not in Chain. Explanation: An internal locking/synchronization rule was broken.
Server Error Messages 1300-1399 Number Severity Text and Explanation 1293 20 Internal Error in lock manager routine: Process (fid %d, spid %d) incorrectly attempted to transfer locks to itself, from a process (fid %d, spid %d) belonging to a different family. Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator. 1294 26 Lock_logical was called with an illegal 'op' parameter: %d.
CHAPTER 6 Number Severity 1305 16 Adaptive Server Error Messages Text and Explanation This Propagation Context Data built-in function requires one argument. Command failed. Check the arguments of the SQL statement calling the system function. Explanation: 1306 16 The second argument for this Propagation Context Data built-in command specifies the number of keys supplied with the call. The value `%d' supplied is more than the keys given. At most `%d' arguments may be keys for this call.
Server Error Messages 1500-1599 Number Severity Text and Explanation 1314 16 1315 16 1316 10 The built-in function requested %d data fields as return parameters. The Propagation Context Data entry that was selected contains only %d data fields. It is an error to request more data fields than exist in the entry. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
CHAPTER 6 Number Severity 1505 14 Adaptive Server Error Messages Text and Explanation Create unique index aborted on duplicate key. Primary key is `%S_KEY' Refer to the writeup for this error. Warning: deleted duplicate row. Primary key is `%S_KEY' Explanation: Report the error to your System Administrator. You may need to increase swap space. Explanation: 1507 10 1508 14 Create index aborted on duplicate rows. Primary key is `%S_KEY' Refer to the writeup for this error.
Server Error Messages 1500-1599 Number Severity Text and Explanation 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.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 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.
Server Error Messages 1500-1599 Number Severity Text and Explanation 1539 17 1540 10 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. Warning: Only %d worker processes are available when %d worker processes are required.
CHAPTER 6 Number Severity 1554 10 Adaptive Server Error Messages Text and Explanation 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 1557 10 1558 10 1559 10 1560 10 1561 20 No such message! Explanation: Check command syntax and semantics.
Server Error Messages 1500-1599 Number Severity Text and Explanation 1568 16 Unable to find sort order. Please check sort order ID or name. Adaptive Server could not perform the requested action. Contact your System Administrator. Explanation: 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. The generated sortkey has been truncated.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 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.
Server Error Messages 1500-1599 Number Severity Text and Explanation 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.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 1600-1699 Number 1601 Severity 21 1602 21 1603 21 1604 21 Text and Explanation There are not enough `user connections' available to start a new process. Retry when there are fewer active users, or ask your System Administrator to reconfigure SQL Server with more user connections. Explanation: Refer to the writeup for this error. Unable to initialize network %d Explanation: Refer to the writeup for this error.
Server Error Messages 1600-1699 Number Severity Text and Explanation 1612 21 Could not install attention function A problem was encountered by a client process connecting to Adaptive Server. If the problem recurs, contact your Network Administrator. Explanation: 1613 21 Could not close network %d connection for server process %d. Explanation: Refer to the writeup for this error.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 1624 18 Warning: Errors occured while initializing thresholds on tempdb. Trying to continue the startup. Thresholds might not be active on tempdb. Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator. 1625 21 Warning: dataserver -u option failed. Please check for state ’%d’ to see where it failed.
Server Error Messages 1700-1799 Number Severity Text and Explanation 1704 16 Only the SA can create the system table `%.*s'. Adaptive Server could not perform the requested action. The command violates a permission or privilege restriction. Check the command and working database context. Explanation: 1705 16 Must create system table `%.*s' in the Master Database. Explanation: Command failed due to invalid or illegal request, check current database.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 1715 16 The number of columns in a foreign key column list and primary key/referenced column list not the same in referential constraint declaration on table `%.*s', in database `%.*s'. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 1716 18 Invalid system table given for status update, this is an internal error.
Server Error Messages 1700-1799 Number Severity Text and Explanation 1725 16 SELECT INTO failed because column %d in table `%.*s' has a null column name. Null column names are not allowed. Explanation: Adaptive Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message. 1726 18 Internal inconsistency: database id %d sent to crt_main() does not match Pss->pcurdb value of %d.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 1739 10 1740 10 1741 10 Warning: Parameter `exp_row_size' is not applicable to table `%.*s' in allpages locking scheme Explanation: Retry the command if necessary. Do not specify exp_row_size on an allpages-locked table. Use this parameter only for tables that use the data-only-locked scheme and contain variable length rows. Warning: Parameter `max_rows_per_page' is not applicable to table `%.
Server Error Messages 1700-1799 Number Severity Text and Explanation 1754 16 DELETE STATISTICS duplicate column '%.*s' specified, column can only be referenced once. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. 1755 16 DELETE STATISTICS column name '%.*s' not found. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. 1756 18 syscolumns cannot be read.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 1765 10 Unable to start a level zero scan on table '%.*s' for UPDATE STATISTICS. This can happen if some DDL command like ALTER/CREATE INDEX/REORG/DROP is active on the table. Explanation: Retry the scan after completing the DDL command. 1766 16 Cannot create syscoordinations tables in any database other than sybsystemdb. Explanation: Adaptive Server could not perform the requested action.
Server Error Messages 1800-1899 Server Error Messages 1800-1899 Number 1801 Severity 16 Text and Explanation Database `%.*s' already exists Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 1802 11 CREATE DATABASE failed. Some disk names listed in command were not found. Check that names exist and are spelled correctly before re-running Explanation: Command failed.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 1810 16 CREATE DATABASE failed because of incorrectly specified or unavailable space. Total number of megabytes specified and available must be at least %d megabytes so Model Database can be copied to the new database. Explanation: Refer to the writeup for this error. 1811 16 `%.*s' is the wrong type of device for CREATE or ALTER database. Please check sysdevices. The CREATE or ALTER is aborted.
Server Error Messages 1800-1899 Number Severity Text and Explanation 1825 14 Invalid curwrite label for creating sybsecurity database, label must be DATA_HIGH. Command failed due to invalid or illegal request. Adaptive Server cannot perform the requested action. Take any corrective action indicated by the message. Explanation: 1828 16 Cannot create sybsecurity with the log segment and the default segment on the same device.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 1837 16 CREATE DATABASE failed to create a dedicated data segment. The specified data segment size is too small to accommodate the data from the model database . Explanation: Adaptive Server could not perform the requested action. Check query and retry. Server Error Messages 1900-1999 Number 1901 Severity 16 Text and Explanation Column `%.*s' -- Can't create index on a column of BIT data type.
Server Error Messages 1900-1999 Number Severity Text and Explanation 1908 16 Too many parameters -- symbol table overflow. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Explanation: 1909 16 Can't use duplicate column names in index key list. Column name `%.*s' listed more than once. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 1923 16 A table cannot have more than one primary key, attempt to define a second primary key failed on table `%.*s'. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 1924 16 You cannot create an index on the sysaudits table. Explanation: Command failed due to invalid or illegal request.
Server Error Messages 1900-1999 Number Severity Text and Explanation 1937 10 1938 16 Warning: Clustered index '%.*s' has been created on the partitioned table '%.*s' with %d partitions using the segment %d with %d devices. For complete I/O parallelism, each partition should be on a separate device. Explanation: This is an informational message but may require follow-up action. Contact your System Administrator. Cannot create index or unique constraint because cursor '%.*s' is still open.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 2000–2099 Number 2001 Severity 10 Text and Explanation Cannot use duplicate parameter names. Parameter name `%.*s' listed more than once. Explanation: Check command syntax and semantics. 2002 10 Cannot use variable `%.*s' without first declaring it. Explanation: Check command syntax and semantics. 2004 16 Procedure `%.
Server Error Messages 2100–2199 Server Error Messages 2100–2199 Number 2103 Severity 16 Text and Explanation Cannot create a trigger on a view, name: %.*s Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 2106 11 Cannot create a trigger on table `%.*s', because this table does not exist in database `%S_DBID'. Explanation: Command failed.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 2200–2299 Number 2200 Severity 10 2201 11 Text and Explanation System databases that did not fail over cannot be shut down. Explanation: This is an informational message but may require follow-up action. Contact your System Administrator. Unable to find database %.*s in sysdatabases. Cannot shut down the database. Command failed.
Server Error Messages 2200–2299 Number Severity Text and Explanation 2210 10 DBS_DEBUG_MSG: waiting for tasks to reach 1st barrier Explanation: This is an informational message or a message header. No action is required. 2211 10 DBS_DEBUG_MSG: Wait on dbt keep count and freeing of resources done in asynchronous mode by the dbshutdown process: %d Explanation: This is an informational message or a message header. No action is required.
CHAPTER 6 Number Severity 2221 16 Adaptive Server Error Messages Text and Explanation QUIESCE DATABASE Error: Tag name %.*s is already in use. Use a different name. Adaptive Server could not perform the requested action. Modify your command to meet the Adaptive Server requirement for the objects or variables shown in the error message. Explanation: 2222 16 2223 20 2224 16 QUIESCE DATABASE with RELEASE option failed. No quiesce process with tag name %.
Server Error Messages 2200–2299 Number Severity Text and Explanation 2231 16 2232 16 Permission denied. Only a user with SA role can execute QUIESCE DATABASE command. Explanation: Adaptive Server could not perform the requested action. The command violates a permission or privilege restriction. Check the command and working database context. QUIESCE DATABASE Error: Database %.*s does not exist. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 2241 16 2242 10 2243 16 QUIESCE DATABASE failed because database %.*s has not been dumped since it was created or upgraded. You must perform a dump database before you can issue QUIESCE DATABASE command. Explanation: A database maintenance operation failed. Take any corrective action indicated by the message. Check the Adaptive Server error log. QUIESCE DATABASE is in progress on database %.*s.
Server Error Messages 2200–2299 Number Severity Text and Explanation 2251 17 2252 16 2253 10 Warning: HA Subsystem Internal Error - dbshutdown failed on database %.*s with dbid %d because the database was found to be in use after it was marked for shutdown. 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. Cannot restart database %.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 2261 10 Dbshutdown in progress for database %.*s with dbid %d. Timeout left %d secs. Please wait. Explanation: This is an informational message or a message header. No action is required. 2262 10 QUIESCE DATABASE HOLD was invoked with FOR EXTERNAL DUMP. Non-logged writes status in database ’%.*s’ has been cleared.
Server Error Messages 2300–2399 Server Error Messages 2300–2399 Number 2300 Severity 10 Text and Explanation HA Config successfully loaded the HA Services Library for NT version ’%s’. Explanation: This is an informational message or a message header. No action is required. 2301 16 HA Config Error: The ha_add_companion() built-in function was called with null parameter(s). Retry with non-null parameter value(s). Explanation: Adaptive Server could not perform the requested action.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 2309 16 HA Config Error: Failed to obtain the state for cluster resource ’%s’ (operating system error %d). Explanation: Adaptive Server could not perform the requested action. Contact your System Administrator. 2310 16 HA HAConfig Error: Failed to open cluster group ’%s’ containing the cluster resource for the ASE server (operating system error %d). Explanation: Adaptive Server could not perform the requested action.
Server Error Messages 2300–2399 Number Severity Text and Explanation 2319 16 HA Config Error: Unable to open cluster resource ’%s’ managing the ASE server (operating system error %d). Explanation: Adaptive Server could not perform the requested action. Contact your System Administrator. 2320 16 HA Config Error: Preexisting cluster resource ’%s’ is not of type ’%s’ (did this resource exist before configuration began?). Explanation: Adaptive Server could not perform the requested action.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 2330 17 HAPC Internal Error: Invalid rpc(%d) request. 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. 2331 17 2332 17 2333 17 HACFG Internal Error: This dbcc command is not applicable for Table ’%.*s’ in database ’%.*s’.
Server Error Messages 2300–2399 Number Severity Text and Explanation 2339 10 HACFG Internal Error: State machine error. Unable to set the state. This is an informational message but may require follow-up action. Contact your System Administrator. Explanation: 2340 10 HACFG Internal Error: State machine error. Unable to get the state. Explanation: This is an informational message but may require follow-up action. Contact your System Administrator. Pathname check failed. Pathname ’%.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 2350 10 HACFG Internal Warning: The store procedure ’%.*s’ is not allowed at the restriction class (%d). Explanation: This is an informational message but may require follow-up action. Contact your System Administrator. 2351 10 HACFG Internal Warning: The restriction class (%d) is invalid. Explanation: This is an informational message. Unless otherwise specified, no action is required.
Server Error Messages 2300–2399 Number Severity Text and Explanation 2362 16 HA Config Error: Server ’%s’ and server ’%s’ are not running on the same cluster; companionship setup failed. Explanation: Adaptive Server could not perform the requested action. Contact your System Administrator. 2363 16 HA Config Error: Failed to open temporary file ’%s’. Explanation: Adaptive Server could not perform the requested action. Contact your System Administrator.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 2372 16 HA Config error: Server mismatch. Local server version is ’%d’, remote server version is ’%d’. The server versions must be the same. A database maintenance operation failed. Take any corrective action indicated by the message. Check the Adaptive Server error log. Explanation: 2373 16 HA configuration error: The logical page size of this Adaptive Server is ’%d’.
Server Error Messages 2400–2499 Number Severity Text and Explanation 2407 17 Cannot use the requested character set since the character set cache is full. 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. Explanation: 2408 11 Cannot find the requested character set in Syscharsets: id = %d. Explanation: Command failed.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 2420 17 2421 11 Unable to load Unicode-based character set conversion table '%.*s' - Unicode conversion cache is full. Please notify your system administrator to add mode unicode buffers. 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.
Server Error Messages 2500–2599 Number Severity Text and Explanation 2431 10 WARNING! Some character(s) in the source string are considered illegal bytes in server’s character set. All bytes after the first illegal bytes are truncated. Explanation: This will be returned when conversion hits illegal bytes in the source string. This is an informational message. Unless otherwise specified, no action is required.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 2507 16 Table Corrupt: Offset table is incorrect (page#=%ld row#=%d offset in offset table is=%d correct offset is=%d) Explanation: Refer to the writeup for this error. 2508 16 Table Corrupt: Row length is incorrect (page#=%d row#=%d minimum row length=%d row length=%d) Explanation: A dbcc check detected table corruption.
Server Error Messages 2500–2599 Number Severity Text and Explanation 2519 16 Database Corrupt: The last checkpoint in sysdatabases is incorrect. Syslogs recorded a different checkpoint Explanation: Refer to the writeup for this error. 2520 16 Database named %.*s not found; check sysdatabases Explanation: Refer to the writeup for this error. 2521 16 2522 16 2523 16 2524 16 2525 16 2526 16 Table Corrupt: Page is linked but not allocated. Run DBCC TABLEALLOC to correct the problem.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 2531 16 2532 16 2533 16 2534 16 2535 16 Table Corrupt: Index id on extent should be 0; check the following page and ids: alloc page=%ld extent=%ld index id on extent=%d Explanation: There may be possible corruption in a database or a database object. Takeany corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.
Server Error Messages 2500–2599 Number Severity Text and Explanation 2541 16 Table Corrupt: object id does not match between extent in allocation page and sysindexes; check the following extent: alloc pg#=%ld extent#=%ld object id on extent=%ld (object name = %.*s) object id in sysindexes=%ld (object name = %.*s) Explanation: Refer to the writeup for this error. 2542 16 2543 16 Table Corrupt: Extent is linked in more than one chain.
CHAPTER 6 Number Severity 2556 20 Adaptive Server Error Messages Text and Explanation Page #%ld of sysindexes in database %d not found in cache after read. 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. Explanation: 2557 14 Only the owner of object `%.*s' or a user with System Administrator (SA) role can run DBCC %s on it.
Server Error Messages 2500–2599 Number Severity Text and Explanation 2568 16 Page %ld is out of range for this database There may be possible corruption in a database or a database object. Takeany corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide. Explanation: 2570 10 Warning - Page %ld has DEALLOC bit on - indid %d, status 0x%x Explanation: This is an informational message.
CHAPTER 6 Number Severity 2579 10 Adaptive Server Error Messages Text and Explanation The total number of data pages in this table is %d. This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. Explanation: 2580 16 The clustered index page (%S_PAGE) has an unexpected key pointer to an overflow data page (%S_PAGE). Please check page status.
Server Error Messages 2500–2599 Number Severity Text and Explanation 2587 16 The last key in the previouse page (%S_PAGE) is not equal to the first key in the current page (%S_PAGE); the current page is an overflow page; however, the status of previous page indicates that there is no disconnected overflow page. Explanation: There may be possible corruption in a database or a database object. Take any corrective action indicated by the message.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 2600–2699 Number 2601 Severity 14 Text and Explanation Attempt to insert duplicate key row in object `%.*s' with unique index `%.*s'%S_EED Explanation: Refer to the writeup for this error. 2603 21 Insufficient space (%d bytes) on logical page %ld of index %d for object ’%.*s’ when inserting row of length %d bytes on index page. Explanation: Adaptive Server encountered an internal error affecting all processes in the current database.
Server Error Messages 2600–2699 Number Severity Text and Explanation 2619 20 2620 21 Keys did not match overflow page when inserting row at end of page (%S_PAGE) that has overflow page (%S_PAGE) that is not disconnected in dbid = %d. Explanation: Adaptive Server encountered an internal error when inserting a data row into a clustered index overflow page. Report the error to your System Administrator so dbcc diagnostics can be run.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 2628 21 In database `%.*s', page %ld is linked forward to page %ld, but that page is linked backward to page %ld. Please report this internal error to Sybase Technical Support. 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.
Server Error Messages 2700–2799 Number Severity Text and Explanation 2715 16 Can't find type '%.*s'. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 2716 16 Can't specify a length or scale on type '%.*s'. Explanation: Adaptive Server could not perform the requested action. Modify your command to meet the Adaptive Server requirement for the objects or variables shown in the error message.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 2730 11 2731 16 2732 16 Cannot create procedure `%.*s' with a group number of %d because a procedure with the same name and a group number of 1 does not currently exist in the database. Must CREATE PROCEDURE `%.*s';1 first. Explanation: Command failed. Check your database for the object not found and reenter the command with the correct name. Column or parameter #%d: -- can't specify column width of zero for `%.*s'.
Server Error Messages 2700–2799 Number Severity 2742 16 Text and Explanation SET DATEFIRST %d is out of range. Command failed. See the Adaptive Server Reference Manual for help with datefirst. Explanation: 2743 16 2744 16 2745 16 2746 16 2747 16 %s command requires %S_MSG parameter. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Index distribution page was %ld, now %ld.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 2754 16 There is an argument position specifier that is out of range in a call to %s. Valid argument position specifiers must be in the range from 1 to %d. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 2756 16 Specified type precision %d more than the maximum precision %d.
Server Error Messages 2700–2799 Number Severity Text and Explanation 2766 16 Cannot use logsegment to create a user table or an index. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Explanation: 2767 16 The table with id=<%ld> in dbid=<%d> does not exist. It may have been created in a concurrently running transaction that rolled back and is now inaccessible.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 2777 16 Invalid update_mode provided. The only allowable update modes are: reclassify, over_range, and standard. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 2778 12 The object `%.*s' is not a table.
Server Error Messages 2800–2899 Number Severity Text and Explanation 2792 16 Cannot change curread label with open cursors. Please contact a user with System Security Officer (SSO) role for help. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 2793 16 User error number %ld is of invalid type. Number must be an integer. Explanation: Command failed due to invalid or illegal request.
CHAPTER 6 Number Severity 2803 20 Adaptive Server Error Messages Text and Explanation Bad pointer encountered during remapping: 0x%x. 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. Explanation: 2804 20 Stored procedure `%.*s' is out of sync with its own procedure header. Explanation: Adaptive Server encountered an internal error affecting the current process.
Server Error Messages 2800–2899 Number Severity Text and Explanation 2814 20 2815 20 Procedure %.*s in procedure buffer 0x%lx does not contain the same object id as procedure header 0x%lx. 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. Procedure %.*s in procedure buffer 0x%lx contains page address 0x%lx which is not aligned on a 2K boundary.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 2823 20 Process %d tried to remove a PROC_BUF 0x%lx named `%.*s' that it does not hold in the hold procedure linked list. Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator. 2824 19 Process %d cannot hold PROC_BUF 0x%lx named `%.*s' because it holds another PROC_BUF 0x%lx named `%.*s'.
Server Error Messages 2900–2999 Number Severity Text and Explanation 2837 16 The object `%.*s' must be recompiled. Use `sp_recompile %.*s', then rerun your command. Explanation: Adaptive Server could not perform the requested action. Contact your System Administrator. 2838 16 Invalid procedure name Explanation: Attempted to execute a stored procedure without specifying a procedure name. (Not raised in Release 11.0 and higher.) 2841 16 The text for the object '%.*s' is missing in syscomments.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 3000 - 3099 Number 3001 Severity 21 Text and Explanation DUMP DATABASE for database `%.*s' failed: insufficient memory to allocate backout structure. 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.
Server Error Messages 3100 - 3199 Server Error Messages 3100 - 3199 Number 3101 Severity 16 3102 16 3103 17 3105 16 3108 16 3109 16 3110 14 3111 16 898 Text and Explanation Database in use. A user with System Administrator (SA) role must have exclusive use of database to run load. Explanation: You cannot use load database while a database is in use by any user. This error occurs when you try to load a dump while users are still accessing the database.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 3112 16 Cannot load any database other than Master when server in single-user mode. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Explanation: 3113 21 Database %.*s does not have an entry in SYSUSERS for the DBO. Explanation: Adaptive Server encountered an internal error affecting all processes in the current database.
Server Error Messages 3100 - 3199 Number Severity Text and Explanation 3123 16 The dump header contains an invalid dump type code: %ld. This is not a valid transaction log dump or database dump. Explanation: A database maintenance operation failed. Take any corrective action indicated by the message. Check the Adaptive Server error log. 3124 10 This is a %S_MSG dump of database ID %d, name ’%.*s’, from %S_DATE. SQL Server version: %.*s. Backup Server version: %.*s. Database page size is %ld.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 3134 10 3135 10 3136 10 Security label consistency check failed. Please run DBCC SECURITY (LABEL_CHECK, `%S_DBID', {FULL | NOREPORT}, FIX) after all loads have been performed in order to make this database usable. Explanation: There may be a potential problem with a database or database object. Contact your System Administrator.
Server Error Messages 3200 - 3299 Number Severity Text and Explanation 3143 16 The master database you are attempting to load was dumped under a different sort order id (%d) or character set id (%d) than the ones running on this server (sort order id = %d, character set id = %d).
CHAPTER 6 Number Severity 3203 16 Adaptive Server Error Messages Text and Explanation Backup Server has detected a SQL Server error. Refer to the writeup for this error. User aborted DUMP or LOAD for database `%S_DBID'. Explanation: Adaptive Server could not perform the requested action. Contact your System Administrator. Explanation: 3204 16 3205 26 DUMP failed in database `%S_DBID': attempt to add run to full run list. An internal locking/synchronization rule was broken.
Server Error Messages 3200 - 3299 Number Severity Text and Explanation 3216 10 Backup Server session id is: %ld. Use this value when executing the `sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server. Explanation: This is an informational message. See the writeup for Error 3216. 3217 20 %s for database `%.*s' failed to write the dump header. Explanation: Command failed due to resource limitation.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 3226 21 3227 10 Attempt to allocate a %s failed -- there are none available. SQL Server is unable to clear unused pages in the database being loaded. Because of this error, the database is unusable. 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.
Server Error Messages 3200 - 3299 Number Severity Text and Explanation 3236 10 Remirroring the affected portions of the usage map that are on mirrored devices. This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. Explanation: 3237 20 3238 20 3239 17 3240 20 3241 20 3242 20 3243 10 %s failed to find disk status entry for virtual page `%ld'.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 3248 16 LOAD DATABASE / TRANSACTION failed because of page size incompatibility. The current page size is %ld, and the page size in the dump is %ld. Explanation: You can only load a dump to a server using the same page size. Server Error Messages 3300 - 3399 Number 3301 Severity 21 3303 21 3305 21 3306 21 Text and Explanation Invalid log record found in syslogs (logop %d).
Server Error Messages 3300 - 3399 Number Severity Text and Explanation 3310 21 Cannot find log record with RID: (%ld, %d). 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. Explanation: 3311 22 3312 22 3313 10 3314 10 Space left (%d bytes) on page %ld is insufficient to move data of %d length.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 3400 - 3499 Number 3401 Severity 21 Text and Explanation Rec_init: getnext SCAN_RID of last checkpoint failed on Rid from sysdatabases. %S_RID. Explanation: See the writeup for Error 3401. 3403 22 During recovery initialization, page %ld was encountered. This page belongs to object %ld, not the log. Explanation: Refer to the writeup for this error.
Server Error Messages 3400 - 3499 Number Severity Text and Explanation 3412 21 3413 21 Database %d, table %ld. Attempt to mark table as suspect. Getnext SCAN_CLUST on sysobjects.objid failed. 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. Database %d. Attempt to mark database as suspect failed. Getnext NC scan on sysdatabases.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 3426 10 Could not make log consistent during special recovery of database %d. Please contact Technical support for assistance. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 3429 21 Error recovering database `%.*s' - could not connect to commit service to check completion status of xact: %S_RID.
Server Error Messages 3400 - 3499 Number Severity Text and Explanation 3440 10 3443 16 3444 10 System stored procedures are not currently accessible due to a recovery error. Please consult the errorlog. You may need to drop and re-create the sybsystemprocs database and re-run the installmaster SQL script if the error is unrecoverable. Explanation: There may be a potential problem with a database or database object. Contact your System Administrator.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 3451 20 3452 20 3453 20 3454 10 3455 20 3456 20 3457 20 3458 20 3459 20 3460 20 Database `%.*s': upgrade has failed for this database. Please refer to previous messages for the cause of the failure, correct the problem and try again. Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server.
Server Error Messages 3400 - 3499 Number Severity Text and Explanation 3461 20 Database `%.*s': upgrade could not install required upgrade item `%d'. Please refer to previous error messages to determine the problem. Fix the problem, then try again. Explanation: A database maintenance operation failed. Restart Adaptive Server and take any corrective action indicated by the message. Check the Adaptive Server error log. 3462 10 Database `%.*s': upgrade could not install optional upgrade item `%d'.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 3471 10 3472 21 3473 21 Database `%.*s' can not be brought online because it has replicated tables that have not been completely transferred. It will come online automatically after replication is complete. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. Unable to access database '%.
Server Error Messages 3400 - 3499 Number Severity Text and Explanation 3483 10 Undo pass of recovery has resolved %d prepared transactions This is an informational message. Recovery encountered an error in acquiring locks for reinstantiated transactions. Please consult the Adaptive Server errorlog for further information as to the cause. Explanation: Adaptive Server encountered an internal error affecting all processes using the current database. Report the error to your System Administrator.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 3492 16 3493 16 This error message number is reserved for a recovery message that must also be printable as a kernel message. Recovery error messages not to be printed as kernel messages are added under the RECOVER2 major error number. Explanation: This is an informational message or a message header. No action is required.
Server Error Messages 3500 - 3599 Server Error Messages 3500 - 3599 Number 3501 Severity 21 Text and Explanation Could not get sysdatabases row for database `%d' at checkpoint time. Explanation: This message indicates a problem with the Replication Agent Thread due to shutdown or abnormal termination. Contact your System Administrator. 3502 21 No checkpoint records found in syslogs for database `%.*s'.
CHAPTER 6 Number Severity 3607 10 Adaptive Server Error Messages Text and Explanation Divide by zero occurred. This is an informational message but may require follow-up action. Contact your System Administrator. Explanation: 3608 10 3612 10 3613 10 3614 10 Null value used in an expression. Explanation: This is an informational message but may require follow-up action. Contact your System Administrator. Execution Time %ld. Explanation: This is an informational message.
Server Error Messages 3600 - 3699 Number Severity Text and Explanation 3623 10 A transaction on a no_log table was undone. Check the errorlog file in the SQL Server directory for details. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 3624 10 Truncation error occurred. Explanation: This is an informational message but may require follow-up action.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 3700 - 3799 Number 3701 Severity 11 Text and Explanation Cannot drop the %S_MSG `%.*s', because it doesn't exist in the system catalogs. Explanation: Refer to the writeup for this error. 3702 16 Cannot drop the %S_MSG `%.*s' because it is currently in use. Explanation: Refer to the writeup for this error. 3703 11 Cannot drop the %S_MSG with object-id %ld in database %d, because it doesn't exist in the system catalogs.
Server Error Messages 3700 - 3799 Number Severity Text and Explanation 3718 11 Could not drop index `%.*s' because the table/clustered index entry cannot be found in the sysindexes system catalog. Explanation: Command failed. Check your database for the object not found and reenter the command with the correct name. 3723 16 The table `%.*s' does not have the %S_MSG `%.*s'. Cannot drop. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 3733 10 Warning: There is an invalid cross-database reference in the system catalogs. The referenced database '%.*s' does not exist. Explanation: This is an informational message. Notify your System Administrator about the message. 3734 10 Warning: There is an invalid cross-database reference in the system catalogs. The referencing database '%.*s' does not exist. Explanation: This is an informational message.
Server Error Messages 3800 - 3899 Number Severity Text and Explanation 3745 16 Cannot drop the database ’%.*s’ because it contains one or more Java classes that are being used as datatypes for columns in table ’%.*s’. Drop the table before dropping the database. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 3746 16 Cannot drop table ’%.*s’ because option ’%s’ is set in database ’%.*s’.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 3804 16 More than one SELECT statement is used to define the cursor `%.*s'. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Explanation: 3805 18 3806 16 3807 18 3808 18 3809 18 3811 18 3812 18 3813 18 3814 16 3816 18 The token datastream length was not correct. This is an internal protocol error.
Server Error Messages 3900 – 3999 Number Severity Text and Explanation 3819 16 The dynamic PREPARE statement `%.*s' failed because of an internal problem while sending the input parameters formats to the client. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 3820 16 The datastream length for the ’%s’ token exceeds the allowable maximum of 65535 bytes.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 3907 21 3908 16 3909 18 3913 26 3914 26 Failed to receive results from PROBE. The distributed transaction named %.*s has not been committed and data may be inconsistent across databases. Explanation: Adaptive Server encountered an internal error with a distributed transaction affecting all processes using the current database. Report the error to your System Administrator.
Server Error Messages 3900 – 3999 Number Severity Text and Explanation 3924 26 Illegal attempt to start sub-transaction by a parent thread. This is an internal error. Explanation: An internal locking/synchronization rule was broken. Report the error to your System Administrator. Shut down and restart Adaptive Server. 3925 26 Attempt to set parallel status on transaction that is not in CMD mode. This is an internal error. Explanation: An internal locking/synchronization rule was broken.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 3934 16 3935 16 3936 0 3938 20 Transaction manager has detected a nesting failure. Number of BEGIN TRAN commands (issued after an attach operation) do not match the number of COMMIT TRAN commands (issued before a detach operation). Explanation: Command failed due to invalid or illegal request. Check semantics and working context. Fatal protocol error. xact_beginupdate() API was invoked in the wrong c ontext.
Server Error Messages 3900 – 3999 Number Severity Text and Explanation 3946 16 Cannot start external transaction without a DTM license. Command failed due to invalid or illegal request. Check semantics and working context. Explanation: 3947 930 16 A heuristic completion related operation failed. Please see errorlog for more details. Explanation: Command failed due to invalid or illegal request. Check semantics and working context.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 4000 – 4099 Number 4001 Severity 11 Text and Explanation Cannot open default database `%.*s'. Explanation: Command failed. Check syntax and your Adaptive Server environment. 4002 14 Login failed. 4013 14 Login failed - not a secure SQL Server. Explanation: You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command. 4016 16 Language name in login record `%.
Server Error Messages 4000 – 4099 Number Severity Text and Explanation 4024 10 The packet size (%d) specified at login time is illegal. Legal values are between 512 and %d. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 4025 10 4050 11 A serious error was encountered while attempting to increase the packet size specified for spid %d. The Network memory map maybe corrupt.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 4062 10 Some of the requested security services are not supported by the underlying security mechanism. Please contact a user with SSO_ROLE. Explanation: This is an informational message but may require action as indicated. 4063 10 4064 16 4066 16 4067 14 4068 14 Security services being used for this connection are inadequate as per the SQL Server's security configuration requirements.
Server Error Messages 4000 – 4099 Number Severity 4077 16 Text and Explanation EJB Config Error : SYBASE_EJB environment variable not set. 4078 16 Check your Adaptive Server environment. Enterprise java bean server is up and running. Explanation: This is an informational message. 4079 16 Enterprise java bean server is down. Explanation: This is an informational message. You may need to restart the EJB server.
CHAPTER 6 Number Severity 4092 10 Adaptive Server Error Messages Text and Explanation The ’enable enterprise java beans’ configuration option needs to be set to execute this command. Explanation: Command failed due to invalid or illegal request. Adaptive Server cannot perform the requested action. Take any corrective action indicated by the message. 4093 10 4094 16 SSL Plus security modules loaded successfully.\n Explanation: This is an informational message.
Server Error Messages 4200 - 4299 Number Severity Text and Explanation 4208 16 4210 16 4211 23 4212 16 DUMP TRANsaction to a dump device is not allowed while the trunc. log on chkpt. option is enabled. Disable the option with sp_dboption, then use DUMP DATABASE, before trying again. Explanation: A database maintenance operation failed. Take any corrective action indicated by the message. Check the Adaptive Server error log.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 4218 21 4219 21 Failure during DUMP of database '%.*s': serial log page allocation rules broken . Current page: %ld; next page: %ld; piece end: %ld; end-of-scan: %ld. 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.
Server Error Messages 4300 - 4399 Number Severity Text and Explanation 4227 17 4228 17 No space left in database master; creating user objects in master database not recommended. Else, an old transaction may be active; see Syslogshold table. 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.
CHAPTER 6 Number Severity 4302 16 Adaptive Server Error Messages Text and Explanation Specified file `%.*s' is not in valid dump transaction format. A database maintenance operation failed. Take any corrective action indicated by the message. Check the Adaptive Server error log. Explanation: 4305 16 4306 16 4312 14 4313 16 4314 20 Specified file `%.*s' is out of sequence. Current time stamp is %S_DATE while dump was from %S_DATE. Explanation: Refer to the writeup for this error.
Server Error Messages 4300 - 4399 Number Severity Text and Explanation 4318 21 Last log page `next free byte' value is out of range: %ld; should be no greater than %ld. 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. Explanation: 4319 21 Failed to patch the transaction log for database `%.*s'.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 4400 - 4499 Number 4401 Severity 16 Text and Explanation View `%.*s' no longer exists. Explanation: A database maintenance operation failed. Take any corrective action indicated by the message. Check the Adaptive Server error log. 4402 16 Infinite loop in view definition. Cannot resolve the view definitions in the query to the underlying tables. Explanation: Command failed due to invalid or illegal request.
Server Error Messages 4400 - 4499 Number Severity Text and Explanation 4412 16 View `%.*s's definition contains `%.*s', which is a temporary object. Views can only be based on permanent objects. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
CHAPTER 6 Number Severity 4423 16 Adaptive Server Error Messages Text and Explanation View `%.*s' cannot be updated since view is the inner table of an outer join. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Explanation: 4424 16 View `%.*s' contains a table being updated, and this table is referenced elsewhere in the query which is not allowed if create view WITH CHECK OPTION is used.
Server Error Messages 4600 - 4699 Number Severity Text and Explanation 4504 16 4505 16 4506 16 4507 16 4508 16 4509 10 CREATE TABLE failed because there was not enough space to allocate memory for the table. 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. CREATE VIEW failed because column ’%.*s’ in view ’%.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 4602 14 Permission denied. Only users with System Administrator (SA) role can GRANT/REVOKE CREATE DATABASE permission. Explanation: You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command. 4603 14 Only owner of current database may GRANT/REVOKE this permission. Explanation: You do not have the permission to execute this command.
Server Error Messages 4600 - 4699 Number Severity Text and Explanation 4612 16 4613 16 Too many users to revoke privileges from,due to cascading GRANT WITH GRANT. To continue, use REVOKE WITH CASCADE on user `%.*s'. Explanation: Adaptive Server could not perform the requested action. The command violates a permission or privilege restriction. Check the command and working database context. WITH GRANT OPTION does not apply to groups and roles.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 4621 16 Warning. All permissions except CREATE DATABASE are granted/revoked. Only System Administrator can grant/revoke CREATE DATABASE permission. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
Server Error Messages 4700 - 4799 Server Error Messages 4700 - 4799 Number 4701 Severity 11 Text and Explanation Cannot truncate table `%.*s', because this table does not exist in database `%S_DBID'. Explanation: Command failed. Check your database for the object not found and reenter the command with the correct name. 4706 17 4708 16 Could not truncate table `%.*s' because there is not enough room in the log to record the deallocation of all of the index and data pages.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 4716 16 Cannot truncate table `%.*s' because it is partitioned. Refer to the writeup for this error. Could not truncate table `%.*s' because there are referential constraints defined on it and there are data rows in some of the referencing tables. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
Server Error Messages 4800 - 4899 Number Severity Text and Explanation 4805 17 4806 16 The front end tool you are using does not support the feature of bulk insert from host, please use the proper tools for this command. 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. You cannot run the non-logged version of bulk copy in this database.
CHAPTER 6 Number Severity 4819 16 Adaptive Server Error Messages Text and Explanation You cannot BCP into the sysaudits table. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Explanation: 4820 16 4821 16 4822 14 4823 16 Illegal identity value specified for identity column in table `%.*s' through BCP. Explanation: Adaptive Server could not perform the requested action.
Server Error Messages 4800 - 4899 Number Severity Text and Explanation 4831 16 Expected TEXT or SENSITIVITY token in data stream for bulk copy of text or sensitivity label data. Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects, variable names, and/or input data. 4832 16 You cannot use a pre-10.0 client to bulk copy into a Secure SQL Server. Explanation: Command failed due to invalid or illegal request.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 4842 16 Bulk copy failed. Partition number %d was specified for table '%.*s', but that table is not partitioned. Explanation: Check command parameters and table, and retry. 4843 10 Slow bulk copy is being used because table '%.*s' has triggers or indexes. Explanation: This is an informational message. Bulk copy may take an extended period. 4844 16 Bulk copy failed.
Server Error Messages 4900 - 4999 Number Severity Text and Explanation 4909 16 Can't alter %.*s because it is not a table. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Explanation: 4910 16 Cannot alter table `%.*s' because you are not the owner or a user with System Administrator (SA) role. Explanation: Adaptive Server could not perform the requested action.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 4920 16 4921 14 Permission denied. A table can only be altered if the table's hurdle equals the user's curwrite. Explanation: Adaptive Server could not perform the requested action. The command violates a permission or privilege restriction. Check the command and working database context. Permission denied. A table's labels cannot be altered while it is in use.
Server Error Messages 4900 - 4999 Number Severity Text and Explanation 4932 16 Dropping a column from a system table is not allowed. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Explanation: 4933 16 4934 16 4935 16 4936 17 4937 17 Dropping a column from a replicated table is not allowed. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 4943 16 Dropping a column which is a primary key is not allowed. Drop the constraint (object id `%ld') before dropping this column. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 4944 16 Dropping a column which is a foreign key is not allowed. Drop the constraint (object id `%s') before dropping this column.
Server Error Messages 4900 - 4999 Number Severity Text and Explanation 4955 16 Number of partitions must be greater than one Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Explanation: 4956 16 Cannot alter table if REORG command or level 0 scans are active. Explanation: Refer to the writeup for this error. 4958 16 Cannot partition table `%.*s' because it is in a pre-System 11 database.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 4968 16 The table '%.*s' you've specified is a system table. Executing the '%.*s' command is not permitted on system tables. Explanation: Invalid command. 4969 16 4970 16 The table '%.*s' you've specified is a temporary table. Executing the '%.*s' command is not permitted on temporary tables. Explanation: Invalid command. Cannot unlock this table because the table is not locked in that mode.
Server Error Messages 4900 - 4999 Number Severity Text and Explanation 4981 16 4982 10 Column offset, %d bytes, for variable-length column number %d exceeds the maximum start offset for variable-length columns in DOL tables (%d bytes). The lock scheme for the object ’%.*s’ was not changed. Explanation: To change the lock scheme, bulk copy the table out, drop and re-create the table with the new scheme, and bulk copy data back in. Due to an internal error the table '%.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 4994 16 ALTER TABLE ’%.*s’ failed. The number of columns in the resultant table (%d) exceeds the current limit %d. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message. 4995 16 ALTER TABLE ’%.*s’ failed. Multiple references to the same column in ALTER TABLE statements are not allowed.
Server Error Messages 5000 - 5099 Server Error Messages 5000 - 5099 Number 5001 Severity 16 5002 16 5004 16 Text and Explanation User must be in Master Database. Explanation: Adaptive Server could not perform the requested action. The command violates a permission or privilege restriction. Check the command and working database context. Database %.*s does not exist; check sysdatabases. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 5016 10 ALTER DATABASE failed. The Model database may not be larger than the Temporary database. Alter tempdb first. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 5017 16 ALTER DATABASE failed. Database %.*s not created with `for load' option.
Server Error Messages 5000 - 5099 Number Severity Text and Explanation 5028 16 5029 16 5030 16 5031 10 5032 10 ALTER DATABASE failed. This command will not make changes to a database that would cause the number of device fragments to exceed the maximum of 128. Recreate the database and try again. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. ALTER DATABASE failed.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 5100 - 5199 Number 5101 Severity 15 Text and Explanation Must give parameters for `DISK %s' command. Usage: %s. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. 5102 15 No such command: `DISK %.*s'. Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
Server Error Messages 5100 - 5199 Number Severity Text and Explanation 5115 16 I/O error during disk initialization. PHYSNAME `%.*s' may be incorrect or %ld (VSTART + SIZE) may exceed the size of the device. Please consult the SQL Server error log for more details. Explanation: Refer to the writeup for this error. 5116 14 Permission denied. Only users with System Administrator (SA) role can run DISK commands. Explanation: You do not have the permission to execute this command.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 5126 16 The logical device `%.*s' does not exist in SYSDEVICES. A database maintenance operation failed. Take any corrective action indicated by the message. Check the Adaptive Server error log. Explanation: 5127 16 The device `%.*s' is already mirrored and mirroring is enabled. Explanation: A database maintenance operation failed. Take any corrective action indicated by the message. Check the Adaptive Server error log.
Server Error Messages 5100 - 5199 Number Severity Text and Explanation 5137 10 Failed to mirror device `%.*s'. This is an informational message but may require follow-up action. Contact your System Administrator. Explanation: 5138 10 Failed to unmirror device `%.*s'. Explanation: This is an informational message but may require follow-up action. Contact your System Administrator. Failed to remirror device `%.*s'. Explanation: This is an informational message but may require follow-up action.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 5148 16 Device `%.*s' already exists. A database maintenance operation failed. Take any corrective action indicated by the message. Check the Adaptive Server error log. Explanation: 5149 16 You cannot remove the primary physical device for virtual device `%.*s' since it is currently the only operational device. Use the SIDE=SECONDARY qualifier for the DISK UNMIRROR COMMAND.
Server Error Messages 5100 - 5199 Number Severity Text and Explanation 5159 16 Only the master database can be recovered when attempting to use the DISK REFIT command. Restart the server using trace flag 3608. Explanation: A database maintenance operation failed. Take any corrective action indicated by the message. 5160 16 Arithmetic overflow error for parameter ’%s’. Explanation: A database maintenance operation failed. Take any corrective action indicated by the message.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 5200 - 5299 Number 5201 Severity 26 5202 26 5203 17 Text and Explanation Failure concurrent with dump in database %d: DFL Manager caller must be DUMP DATABASE; instead, command token was %d. Explanation: An internal locking/synchronization rule was broken. Report the error to your System Administrator. Shut down and restart Adaptive Server. DUMP DATABASE for database %d failed: DFL synchronisation is prematurely set.
Server Error Messages 5600 - 5699 Number Severity Text and Explanation 5211 26 Failure concurrent with dump in database %d: caller does not possess flushlist lock. An internal locking/synchronization rule was broken. Report the error to your System Administrator. Shut down and restart Adaptive Server. Explanation: 5212 26 5213 26 5214 20 5215 26 5216 26 5217 20 Failure concurrent with dump in database %d: no DFL pieces on not-full list.
CHAPTER 6 Number Severity 5601 20 Adaptive Server Error Messages Text and Explanation Adaptive Server internal error: invalid input %d to internal functions. 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. Explanation: 5602 17 Could not find an available distributed transaction participant descriptor.
Server Error Messages 5600 - 5699 Number Severity Text and Explanation 5611 21 Adaptive Server internal error: distributed transaction recovery boot count error. Transaction boot count is %d, Server current boot count is %d. Explanation: Adaptive Server encountered an internal error affecting all processes using the current database. Report the error to your System Administrator. 5612 16 System database %s is not allowed to participate in a distributed transaction.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 5621 16 You cannot start non-transactional work on the remote server. ’enable xact coordination’ is off and the task enabled ’strict dtm enforcment’, which requires transactional work. Explanation: Adaptive Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message. 5622 21 Adaptive Server Internal Error.
Server Error Messages 5700 - 5799 Number Severity Text and Explanation 5631 16 Adaptive Server Internal Error. New transactional connection to server ’%S_SRVID’ is being passed while there is an existing transactional connection to the same server in the same transaction. Aborting the distributed transaction. Transaction key ’%.*s. 5632 16 Check error log and report the error to the System Administrator.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 5800 - 5899 Number 5803 Severity 10 Text and Explanation Unknown config number in sysconfigures, config = %d. Explanation: There may be a potential problem with a database or database object. Contact your System Administrator. 5804 16 The value for `%s' must not exceed `%s' or `%s'. Command failed. Check syntax and semantics. Check your configuration file and any configuration parameters supplied.
Server Error Messages 5800 - 5899 Number Severity Text and Explanation 5812 16 5813 16 The new load file has %d caches defined against running %d cache definitions.Cache type, size and number of caches should match the running values. Use sp_cacheconfig to determine the running value. Explanation: You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 5826 10 You have just reconfigured SQL Server's default sort order. System table indexes will be rebuilt when you reboot the SQL server. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 5827 10 In changing the default sort order, you have also reconfigured SQL Server's default character set.
Server Error Messages 5800 - 5899 Number Severity Text and Explanation 5838 10 The maximum network packet size must be a multiple of 512. It has been rounded down from %d to %d. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 5839 16 The value of `max network packet size', `%ld', must be greater than or equal to the value of the `default network packet size', `%ld'.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 5849 16 Verification failed for parameter `%s'. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Explanation: 5850 16 5851 16 Notification failed for parameter `%s'. Explanation: Refer to the writeup for this error. Configuration Error: Configuration file `%s' has an unknown format on line %d.
Server Error Messages 5800 - 5899 Number Severity Text and Explanation 5861 16 The current ’max memory’ value ’%ld’, is not sufficient to change the parameter ’%s’ to ’%ld’. ’max memory’ should be greater than ’total logical memory’ ’%ld’ required for the configuration. Explanation: 5862 18 5863 18 5864 18 Refer to the writeup for this error. Invalid portion encountered.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 5872 16 The total size of the configured pools (%dk) in cache %s is greater than the total size (%dk) of the cache. Explanation: Command failed. Check syntax and semantics. Check your configuration file and any configuration parameters supplied. 5873 16 Invalid configuration for the default %dk pool in cache %s. The default %dk pool must be a minimum of %dk. Explanation: Command failed. Check syntax and semantics.
Server Error Messages 5800 - 5899 Number Severity Text and Explanation 5882 16 5883 16 5884 10 A cache alignment factor of %dk was specified but no buffer pool containing %dk buffers has been configured. An attempt will be made to create this pool with extra memory (%dk bytes) from cache %s. Explanation: Command failed. Check syntax and semantics. Check your configuration file and any configuration parameters supplied.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 5892 16 You cannot use `allow sendmsg' option because syb_sendmsg() builtin is not supported on this platform. Explanation: Command failed. Check syntax and semantics. Check your configuration file and any configuration parameters supplied. 5893 16 The sum, (%s) + (%s %s) + (%s) + (%s) + (%s) + (%s), must be no greater than ’%ld’. Explanation: Command failed. Check syntax and semantics.
Server Error Messages 6000 - 6099 Server Error Messages 6000 - 6099 Number 6001 Severity 10 6002 10 Text and Explanation SHUTDOWN is waiting for %d process(es) to complete. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. A SHUTDOWN command is in progress. Please log off. This is an informational message. Unless otherwise specified, no action is required.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 6100 - 6199 Number 6101 Severity 16 Text and Explanation Process `%d' is not a valid process number. Choose a number between 1 and `%d'. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 6102 14 Permission denied. Only users with System Administrator (SA) role can run the KILL command.
Server Error Messages 6200 - 6299 Server Error Messages 6200 - 6299 Number 6201 Severity 10 Text and Explanation STEP %d Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 6202 10 The type of query is SELECT (into Worktable%d). This is an informational message. Unless otherwise specified, no action is required.
CHAPTER 6 Number Severity 6212 10 Adaptive Server Error Messages Text and Explanation Worktable%d created for REFORMATTING. This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. Explanation: 6213 10 6214 10 6215 10 6216 10 Worktable%d created for SELECT_INTO. Explanation: This is an informational message. Unless otherwise specified, no action is required.
Server Error Messages 6200 - 6299 Number Severity 6225 10 Text and Explanation Index : %.*s This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. Explanation: 6226 10 6227 10 6228 10 6229 10 Index name not found. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
CHAPTER 6 Number Severity 6238 10 Adaptive Server Error Messages Text and Explanation The cursor will remain open when a transaction is committed or rolled back. This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. Explanation: 6239 10 6240 10 6241 10 6242 10 The number of rows returned for each FETCH is %d. Explanation: This is an informational message.
Server Error Messages 6200 - 6299 Number Severity Text and Explanation 6251 10 This cursor is declared within a stored procedure. The cursor's memory usage cannot be distinguished from that of the procedure as a whole. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 6252 10 6253 10 This cursor is declared on a stored procedure. It is presently using `%d' bytes.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 6262 10 The cursor was closed because CLOSE ON ENDTRAN was SET ON and the transaction containing the cursor ended. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 6263 10 The cursor is read only because it is declared on a union. Explanation: This is an informational message.
Server Error Messages 6200 - 6299 Number Severity Text and Explanation 6274 10 Evaluate Grouped %s. This is an informational message or a message header. No action is required. Explanation: 6275 10 6276 10 6277 10 6278 10 Evaluate Ungrouped %s. Explanation: This is an informational message or a message header. No action is required. Forward scan. Explanation: This is an informational message or a message header. No action is required. Backward scan.
CHAPTER 6 Number Severity 6287 10 Adaptive Server Error Messages Text and Explanation Keys are: Explanation: This is an informational message or a message header. No action is required. 6288 10 6289 10 6290 10 6291 10 %.*s %S_MSG Explanation: This is an informational message or a message header. No action is required. QUERY PLAN FOR STATEMENT %u (at line %u). Explanation: This is an informational message or a message header. No action is required.
Server Error Messages 6500 - 6599 Number Severity Text and Explanation 6404 18 Process %d in database `%.*s' was aborted. The transaction was rolled back, but an ENDXACT record was not written, probably because the log is full. Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 6508 10 DB Mount: Unable to start transaction in database ’%.*s’. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 6509 10 6510 10 6511 10 DB Mount: Unable to update the sysusages table during mount operation. Explanation: This is an informational message.
Server Error Messages 6500 - 6599 Number Severity Text and Explanation 6521 10 DB Mount: Performing initial disk init of device ’%.*s’ for metadata extraction required for mount. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 6522 10 DB Mount: Performing disk init of device as ’%.*s’. Explanation: This is an informational message.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 6533 10 B Mount: Mount of all the database in master_companion is complete. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 6534 10 6535 10 6536 10 DB Mount: Failover of companion server is completed successfully. Explanation: This is an informational message.
Server Error Messages 6900 - 6999 Number Severity Text and Explanation 6702 20 Protection hash chain corrupt: element of type UNUSED found in hash chain (dbid %d, object %ld, protection type %d, protection status %d, column map %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.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 6906 18 Value of Commit Timestamp=%04x %08lx in database ’%.*s’ is greater than the Begin Timestamp=%04x %08lx of the completing transaction. If allowed, clients of Commit Timestamp could have missed some committed data. Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by the message. Report the error to your System Administrator.
Server Error Messages 7000 - 7099 Server Error Messages 7000 - 7099 Number 7001 Severity 16 Text and Explanation A transaction attempted on external table. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 7002 16 Attempt to open VOS file failed Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
CHAPTER 6 Number Severity 7012 16 Adaptive Server Error Messages Text and Explanation External table - skipped. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Explanation: 7013 10 7014 10 7015 10 7016 10 Create database feature is disabled. Explanation: This is an informational message. Unless otherwise specified, no action is required.
Server Error Messages 7100 - 7199 Number Severity Text and Explanation 7024 16 The collation_code argument must be ascii or numeric when creating a VOS index for extgernal tables. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 7025 20 Process not running on engine with attached ports for external table during external table scan.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 7121 22 Free offset %d is invalid on page %ld. A table or index may be corrupt. Report the error to your System Administrator. Adaptive Server must be restarted and dbcc diagnostics run. Explanation: 7123 16 Invalid text pointer value %s. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
Server Error Messages 7100 - 7199 Number Severity Text and Explanation 7134 16 The text table and the table referenced by the text pointer value %s disagree. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Explanation: 7135 25 Failed to acquire lock for objid %ld. Explanation: Internal error. No user action ncessary.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 7144 16 Mime pointer %s does not point to a multi-part message. Check input and syntax. Message pointed to by mime pointer %s has less than %d parts. Explanation: Check command input. Explanation: 7145 16 7146 16 7147 16 7148 16 7149 16 7150 16 7151 22 Selected message has %d bytes less than expected. Message is probably corrupt. Please contact your system administrator.
Server Error Messages 7200 - 7299 Number Severity Text and Explanation 7157 16 You cannot run the non-logged version of dbcc rebuild_text in this database. Please check with the DBO. Explanation: A database maintenance operation failed. Take any corrective action indicated by the message. Check the Adaptive Server error log. 7158 10 Non-logged version of dbcc rebuild_text is complete. Please dump your database to ensure recoverability. Explanation: This is an informational message.
CHAPTER 6 Number Severity 7206 17 Adaptive Server Error Messages Text and Explanation Can't open a connection to site `%S_SRVID' because all channel numbers are in use. 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.
Server Error Messages 7200 - 7299 Number Severity Text and Explanation 7217 18 Echo failed from site `%.*s'. Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator. Explanation: 7218 11 Site `%.*s' not found in sysservers. Explanation: Refer to the writeup for this error. 7219 11 Site %d not found in sysservers. Command failed.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 7230 18 The OS Session Label of the remote Server process does not equal the connection level assigned to it. Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator. 7231 18 The OS Session Label, curread and curwrite labels of the Client do not equal the connection level for the remote Server.
Server Error Messages 7300 - 7399 Number Severity Text and Explanation 7243 16 Internal Limit reached. All local LOGCONN array segments are full. The following display is accurate, but it does not contain all active LOGCONNs. Displaying %d active LOGCONNs in %d local arrays. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. (Not raised in 11.9.2).
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 7309 10 SQL statement on line number %d contains %S_MSG. The error is caused due to the use of %s. Explanation: Check command syntax and semantics. 7310 10 7311 10 7312 10 SQL statement on line number %d contains %S_MSG. The error is caused due to the use of non-ANSI option: %S_MSG. Explanation: Check command syntax and semantics. Line number %d contains %S_MSG.
Server Error Messages 7300 - 7399 Number Severity Text and Explanation 7322 10 Line number %d contains %S_MSG. The error is caused due to the use of set operations in an insert select: %S_MSG. Explanation: Check command syntax and semantics. 7323 10 7324 10 7325 16 Line number %d contains %S_MSG. The error is caused due to the use of column headings. Explanation: Check command syntax and semantics. Line number %d contains %S_MSG. The error is caused due to the use of compute statement.
CHAPTER 6 Number Severity 7334 16 Adaptive Server Error Messages Text and Explanation Subqueries are not allowed in a RAISERROR. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Explanation: 7335 15 A SELECT statement that assigns a value to a variable must not be combined with a COMPUTE clause. Explanation: Command failed. Check syntax and semantics.
Server Error Messages 7300 - 7399 Number Severity Text and Explanation 7347 16 The IDENTITY function should be used only when the SELECT statement has an INTO clause. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 7348 16 Select expression results in more than one column having same name. Column name `%.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 7358 16 Invalid type argument specified for the %s builtin function. Argument must either be SENSITIVITY or SENSITIVITY_BOUNDARY. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 7359 16 SYB_IDENTITY is not allowed in READ or WRITE TEXTS commands. Explanation: Command failed due to invalid or illegal request.
Server Error Messages 7300 - 7399 Number Severity Text and Explanation 7369 15 Procedure Grouping is not allowed. Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. Explanation: 7370 16 7371 16 7372 15 7373 15 Specified precision %d is more than the maximum precision %d. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
CHAPTER 6 Number Severity 7381 10 Adaptive Server Error Messages Text and Explanation prefetch size This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. Explanation: 7382 16 7383 16 7384 16 7385 16 Subqueries are not allowed in an ORDER BY clause. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions.
Server Error Messages 7400 - 7499 Number Severity Text and Explanation 7394 15 Duplicate specification of '%S_MSG' clauses for one table is not allowed. Check command syntax. forced index Explanation: This is informational text. Explanation: 7395 10 7396 10 forced parallel 7397 10 forced lru/mru Explanation: Explanation: 7398 10 15 This is informational text. forced prefetch Explanation: 7399 This is informational text. This is informational text.
CHAPTER 6 Number Severity 7407 10 Adaptive Server Error Messages Text and Explanation Failed to execute the threshold procedure for database %d, segment %d, free space %ld. Refer to the writeup for this error. Could not find a dbtable for database %d. Explanation: Refer to the writeup for this error. Explanation: 7408 16 7409 20 7410 26 7411 21 7412 10 7413 10 7414 10 7415 16 7416 20 This task tried to sleep waiting for space to become available in the log, but could not.
Server Error Messages 7400 - 7499 Number Severity Text and Explanation 7419 16 lct_admin(abort): Process %d that you are trying to abort is not a valid process. Choose a process with id between %d and %d. Explanation: Check command inputs and retry. 7420 16 lct_admin(abort): Cannot abort yourself. Your process id %d and the given process id %d. Explanation: Check command inputs and retry. 7421 16 7422 16 7423 10 lct_admin(abort): Process %d is not an active process. Cannot abort it.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 7434 16 lct_admin('unsuspend') is no longer supported. We recommend that you use the KILL command to stop suspended processes. You may wake individual processes using lct_admin('w akeup', ). 7435 16 7436 18 lct_admin('unsuspend') is no longer supported. We recommend that you use the KILL command to stop suspended processes. You may wake individual processes using lct_admin('w akeup', ).
Server Error Messages 7600 - 7699 Number Severity Text and Explanation 7605 20 An attempt to send a message to the audit process has failed. This is a system error. Contact a user with System Security Officer (SSO) role. Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator. 7606 20 An attempt to allocate memory for the audit queue has failed. This is a system error.
CHAPTER 6 Number Severity 7615 16 Adaptive Server Error Messages Text and Explanation The auditing system tables can only be created in the sybsecurity database. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Explanation: 7616 16 7617 20 7618 20 7619 20 7620 14 7623 20 7624 20 7625 20 You can only use SELECT or SELECT INTO with the sysaudits table.
Server Error Messages 7700 - 7799 Number Severity Text and Explanation 7627 20 Auditing: Fatal error - current audit table is full and server is configured to suspend auditing when device is full, but it failed to suspend the audit process. This is an internal error. Explanation: Adaptive Server encountered an internal error affecting the current process when trying to update audit records. Report the error to your System Administrator.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 7705 10 Invalid pattern string. The character following the escape character must be percent sign, underscore, left square bracket, right square bracket, or the escape character. Explanation: Check command syntax and semantics. 7706 10 7707 10 7708 10 Pattern string is too long. The given pattern string `%.*s' is converted using the escape character `%.*s'. The converted string is longer than %d bytes.
Server Error Messages 7700 - 7799 Number Severity Text and Explanation 7716 16 Cannot convert CHAR value to REAL. The CHAR value has incorrect syntax. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Explanation: 7717 20 Attempted to drop temporary table with object id %ld, which is not in the temporary object lists for this task.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 7730 14 SET ROLE fails. The caller is not granted with the specified `%.*s' role. Please contact a user with System Security Officer (SSO) role for help. Explanation: You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command. 7731 16 SET ROLE fails. The caller cannot assume the new user identity (uid) in the current database.
Server Error Messages 7700 - 7799 Number Severity Text and Explanation 7742 16 You must change your password using the sp_password system stored procedure before you can continue. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 7743 16 An explicit value for the identity field in table `%.*s' can only be specified in an insert statement when a field list is used.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 7752 16 Unable to SET IDENTITY_INSERT to ON/OFF for table `%.*s' because you are neither the DBO nor the object owner. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 7753 16 Unable to SET IDENTITY_INSERT to ON/OFF for object `%.*s' because the object is not a user table.
Server Error Messages 7700 - 7799 Number Severity Text and Explanation 7762 16 Trigger label configuration incompatible with user's profile. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Explanation: 7763 16 7764 23 7765 23 7766 16 Procedure label configuration incompatible with user's profile. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 7774 16 The procedure `%.*s' contains a select statement with FOR UPDATE clause. This should be the only statement in the procedure. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 7775 16 The column `%.*s' in FOR UPDATE list is not part of the SELECT list.
Server Error Messages 7700 - 7799 Number Severity Text and Explanation 7783 10 7784 16 7785 16 7786 16 7787 16 7788 10 7789 16 Internal error -- server failed to do garbage collection on this procedure, id = %ld. Please save the query tree and procedure text and inform the technical support. This is not a critical error, so server continues processing. Explanation: There was an error during procedure query tree compression.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 7792 16 An isolation level %d scan is being attempted on cursor `%.*s', but the cursor was declared at isolation level %d. You must re-declare the cursor at isolation level %d. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
Server Error Messages 7900 - 7999 Number Severity Text and Explanation 7903 16 7904 10 Page %ld was expected to be a TEXT/IMAGE page. This occurred when link number %ld was examined. Explanation: There may be possible corruption in a database or a database object. Take any corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide. The total number of TEXT/IMAGE pages in this table is %d.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 7914 10 Allocation page %ld extid %ld is not referenced, but there are referenced pages within this extent. Contact Technical Support for assistance on object %ld. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
Server Error Messages 7900 - 7999 Number Severity Text and Explanation 7926 16 Data level: %d. %ld Data pages allocated and %ld Extents allocated. This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. Explanation: 7927 16 7928 16 7929 16 7930 16 7931 16 7932 16 7933 16 7934 16 TOTAL # of extents = %ld Explanation: This is an informational message.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 7938 16 Table Corrupt: The oam entry for object %ld, indid %ld, alloc pg %ld, has a used count of %d and an unused count of %d. The used count should be %d and the unused count should be %d. Explanation: There may be possible corruption in a database or a database object. Take any corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.
Server Error Messages 7900 - 7999 Number Severity Text and Explanation 7948 16 Page %ld, object %ld, index %d, level %d, was found with fixed-row status improperly set. That status has been cleared by DBCC. Explanation: This informational message is displayed by dbcc checktable or dbcc checkdb (which calls dbcc checktable) when a page status bit in a page header is set on when it should not be.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 7956 16 7957 25 Remapping utility - Column descriptor should have been remapped earlier. This is an internal system error. Explanation: There may be possible corruption in a database or a database object. Take any corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide. Remapping utility - procedure is corrupted in Sysprocedures.
Server Error Messages 7900 - 7999 Number Severity Text and Explanation 7965 10 7966 20 The `fix' option has been ignored for this command. To use the `fix' option with system tables, run the command from the database where the table is located. The database must be in single user mode. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 7975 20 System catalog entrie(s) for Object %d, Database %d are corrupted. 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. Explanation: 7976 16 Object %d in database %d does not have any TEXT/IMAGE data. Explanation: There may be possible corruption in a database or a database object.
Server Error Messages 7900 - 7999 Number Severity Text and Explanation 7986 16 You can not change the mode of a remote stored procedure. Adaptive Server could not perform the requested action. The command violates a permission or privilege restriction. Check the command and working database context. Explanation: 7987 16 User named `%.*s' not found; check sysusers. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 7996 14 Permission denied. Object `%S_OBJID' not found. You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command. Explanation: 7997 14 Permission denied. User's curwrite does not match the sensitivity label of object `%S_OBJID'. Explanation: You do not have the permission to execute this command.
Server Error Messages 8000 - 8099 Server Error Messages 8000 - 8099 Number 8002 Severity 15 Text and Explanation Parameter number %d and subsequent parameters must be passed as `@name = value'. Once the form `@name = value' has been used, all subsequent parameters must be passed in the form `@name = value'. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 8012 16 Adaptive Server internal error: Received internal error %d from the remote server ’%S_SRVID’. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 8013 16 A CTLIB operation failed during an RPC. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions.
Server Error Messages 8200 - 8299 Number Severity Text and Explanation 8207 17 Couldn’t find an available descriptor for an object. Raise the value of the configuration parameter ’number of open objects’ for more descriptors. Explanation: Refer to the writeup for this error. 8208 21 Descriptor for object %d in database %d was notfound in the expected dbtable. Explanation: Adaptive Server encountered an internal error affecting all processes in the current database.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 8223 21 8224 21 As part of a transaction rollback, an attempt was made to modify object '%S_OBJID ' in database '%.*s', even though the current session is not holding an exclusive lock on that object. Explanation: The server encountered an internal error affecting all processes using this database. Report the error to your SA. Internal error: could not save description of lightweight procedure '%.*s'.
Server Error Messages 8400 - 8499 Server Error Messages 8400 - 8499 Number 8401 Severity 21 8402 21 8403 21 8404 21 8405 21 8406 21 8407 21 8408 21 8409 21 1050 Text and Explanation Object with id of %ld was not found in database number %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.
CHAPTER 6 Number Severity 8410 21 Adaptive Server Error Messages Text and Explanation Expected to find search lock during sysindexes scan. 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. Explanation: 8411 21 Invalid setup status found in sysindexes Manager during a call to: %s.
Server Error Messages 8400 - 8499 Number Severity Text and Explanation 8422 21 Indid mismatch between index descriptor 0x%x (indid %d) and page 0x%x (indid %d) for objid %d in dbid %d. Explanation: Internal error affecting the current process. Contact your SA. 8423 21 Expected table descriptor to be set for objid %d in dbid %d. Explanation: Internal error affecting the current process. Contact your SA. 8424 17 8425 21 Cannot find an available index descriptor for an index.
CHAPTER 6 Number Severity 8436 26 Adaptive Server Error Messages Text and Explanation Index descriptor found was not expected to be in a %s state. Internal locking/synchronization error. Contact your SA and restart the server. Explanation: 8437 20 Update failed. SQL Server could not find field '%d' within index descriptor/buffer. Explanation: Internal error affecting the current process. Contact your SA. 8438 21 Updating wrong indexrow in dbid %d.
Server Error Messages 8600 - 8699 Server Error Messages 8600 - 8699 Number 8601 Severity 20 8602 16 8603 16 Text and Explanation Process %d tried to keep the PSS for process %d when it already had the PSS for process %d kept. Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator. Unable to initialize worker thread %x because parent %x has an invalid PSS. Explanation: Command failed due to invalid or illegal request.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 8700 - 8799 Number 8701 Severity 26 8702 26 Text and Explanation Sitebuf has invalid state or keepcount. sitebuf=0x%lx, state=%d, keepcount=%ld. Explanation: An internal locking/synchronization rule was broken. Report the error to your System Administrator. Shut down and restart Adaptive Server. Sitebuf has invalid state. sitebuf=0x%lx, state=%d. An internal locking/synchronization rule was broken.
Server Error Messages 8900 - 8999 Number Severity Text and Explanation 8803 26 Missing sitebuf for siteid %d. An internal locking/synchronization rule was broken. Report the error to your System Administrator. Shut down and restart Adaptive Server. Explanation: 8804 26 8805 26 8806 26 Packet acknowledgment is neither read nor write. rdwr=%d. Explanation: An internal locking/synchronization rule was broken. Report the error to your System Administrator. Shut down and restart Adaptive Server.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 9000 - 9099 Number 9001 Severity 20 Text and Explanation Process %d has requested a memory size %d that is greater than the memory size %d in the disk buffer 0x%X, dbid %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.
Server Error Messages 9100 - 9199 Server Error Messages 9100 - 9199 Number 9101 Severity 16 9102 16 9103 16 9104 16 9105 16 9106 10 9107 16 9108 10 1058 Text and Explanation The total size of all parameter values for stored procedure `%.*s' exceeds maximum size (%d bytes) allowed for replication. Stored procedure `%.*s' is not replicated. Explanation: Adaptive Server could not perform the requested action. Contact your System Administrator.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 9109 10 9110 10 9111 10 9112 16 9113 16 9114 16 9115 16 9116 16 Cannot find user name for user ID %d while sending the %s log record for database `%.*s', XACT ID %S_RID, RID %S_RID. The user ID will be used instead of the user name. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
Server Error Messages 9100 - 9199 Number Severity Text and Explanation 9119 17 Execution of the the %s command fails due to insufficient memory. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Explanation: 9120 16 The log transfer context for database `%.*s' has not been reserved with the DBCC LOGTRANSFER (`reserve', `context') command. The specified DBCC command is not executed.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 9129 16 Unable to determine the end of the log for database `%.*s'. The log transfer scan of database `%.*s' is aborted. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 9130 16 The BEGINXACT log record referenced by the CHECKPOINT log record for database `%.
Server Error Messages 9100 - 9199 Number Severity Text and Explanation 9139 17 9140 17 Failed to free allocated but unused memory in order to satisfy memory allocation request. Memory allocation request fails. 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.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 9148 20 9149 10 Replication server could not send log records for log version change processing in database `%.*s' because the log processing functions returned internal error %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.
Server Error Messages 9200 - 9299 Number Severity Text and Explanation 9203 20 %S_REPAGNT: Encountered an End Transaction that was not in abort state while locating after image for Delete at (%d, %d), transaction = (%d, %d). Explanation: Internal error, affects current process. Contact your SA. 9204 20 9205 20 9206 20 %S_REPAGNT: Could not locate schema for object with id = (%d), current marker (%d , %d). Explanation: Internal error, affects current process. Contact your SA.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 9215 16 %S_REPAGNT: The Secondary Truncation Point is not valid. Please make sure that the Secondary Truncation Point is valid, and then restart the Rep Agent Thread for this data base. Explanation: Take recommended action. 9216 10 %S_REPAGNT: The Rep Agent Thread will retry the connection to the Replication Server every %d second(s). (RepSvr = %.*s). Explanation: Informational message.
Server Error Messages 9200 - 9299 Number Severity Text and Explanation 9229 16 %S_REPAGNT. Could not change to database, %S_DBID. Check syntax and input data. The Rep Agent Thread for database, %S_DBID, is not running. Please retry this command after starting the Rep Agent Thread for this database. Explanation: 9230 16 9231 16 9232 16 9233 17 9234 17 Explanation: %S_REPAGNT.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 9239 17 %S_REPAGNT: Could not allocate a Procedure Cache for the Rep Agent Thread. Try restarting the Rep Agent Thread after freeing up, or allocating a larger Procedure Cache. 9240 17 %S_REPAGNT: Could not allocate an alarm. Try restarting this Rep Agent Thread after freeing up some alarms, or restart the server with more alarms allocated. 9241 20 %S_REPAGNT: Failure initializing the Rep Agent Context.
Server Error Messages 9200 - 9299 Number Severity Text and Explanation 9258 20 %S_REPAGNT: Could not re-read EXECBEGIN log record at (%d, %d), current marker (% d, %d). Explanation: Internal error, affects current process. Contact your SA. 9259 20 9261 20 9262 16 %S_REPAGNT: Could not read TEXTINSERT/INOOPTEXT log record at (%d, %d), current marker (%d, %d). Explanation: Internal error, affects current process. Contact your SA.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 9272 20 %S_REPAGNT: Failure specifying the keytab filename. Please check that the keytab file '%.*s', exists and is accessable. (CT-lib error %d). Explanation: Check the Replication Server setup indicated in the message. 9273 10 9274 16 %S_REPAGNT: Using default keytab file because security mechanism requir es a keytab file, but the no keytab file was specified at server startup.
Server Error Messages 9300 - 9399 Number Severity Text and Explanation 9282 20 %S_REPAGNT: No free file descriptors available. Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator. Explanation: 9283 20 %S_REPAGNT: Aborting because a cross database stored procedure execution was detected. This event needs to be manually applied, and skipped before restarting the RepAgent.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 9302 18 Unexpected EX_CONTROL exception has been raised inside the Syslabels Manager: error = %d, severity = %d, state = %d Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator. 9303 18 Syslabels Manager: Insert into `%S_DBID.dbo.syslabels' failed during call to %s().
Server Error Messages 9300 - 9399 Number Severity Text and Explanation 9310 20 Internal MAC sub-system error. Label comparison failed. DO NOT USE THIS SERVER AND ITS ASSOCIATED DEVICES UNTIL THE CAUSE OF THIS ERROR HAS BEEN ELIMINATED. 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.
CHAPTER 6 Number Severity 9319 10 Adaptive Server Error Messages Text and Explanation Database `%S_DBID' passed Database Maxhold Consistency Check. This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. Explanation: 9321 18 9322 18 Corrupt security label encountered in database `%S_DBID'.
Server Error Messages 9500 – 9599 Number Severity Text and Explanation 9333 10 Security label consistency check of database `%S_DBID' done. This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. Explanation: 9334 10 Skipping checking of security label consistency for database `%S_DBID' as it hasn't been initialized with the proper Data High and Data Low values.
CHAPTER 6 Number Severity 9506 10 Adaptive Server Error Messages Text and Explanation Warning: Using only the first %d characters for password This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. Explanation: 9507 18 9508 16 9509 16 9510 16 9511 18 9512 18 9513 18 9514 18 The builtin function `syb_sendmsg' is not supported.
Server Error Messages 9500 – 9599 Number Severity Text and Explanation 9515 16 The UPDATE/DELETE WHERE CURRENT OF to the cursor `%.*s' failed because the isolation level is at 0. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 9516 16 %d is an invalid spid. You could use sp_who to identify the correct spid. Explanation: Command failed due to invalid or illegal request.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 9525 16 A positioned update/delete on a row in table `%.*s' failed. This is because cursor `%.*s' does not point to a valid row in an inner(outer) table of an outer(inner) join used in the query. Explanation: Attempted to delete or update a non-existent row in a table. Check join statement in the named cursor targeting this table. Cursor fetch may have returned NULL values due to no matching rows.
Server Error Messages 9500 – 9599 Number Severity Text and Explanation 9540 17 Insufficient number of messages to execute this parallel query. Increase the value of the configuration parameter 'number of messages'. 9541 18 Worker Process API internal error %d. Consider running this query serially by setting the session parameter 'parallel_degree' to 1. Please contact Sybase Technical SUpport 9543 16 Parameter passed to %s has an invalid type. It must be of type %s.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 9553 16 9554 16 9555 16 9556 16 9557 16 9558 10 No Unicode character returned for the range 0xD800..0xDFFF (surrogates) because it is not permitted to create Unicode expression with only half of a surrogate pair. Explanation: Adaptive Server could not perform the requested action. Modify your command to meet the Adaptive Server requirement for the objects or variables shown in the error message.
Server Error Messages 9600 - 9699 Number Severity Text and Explanation 9561 20 An insert or update to table ’%.*s’ places column ’%.*s’ at offset %d,ending at offset %d. The maximum permitted ending offset for this column is %d. This is a server internal error. Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator. Server Error Messages 9600 - 9699 Number Severity Text and Explanation 9601 10 A %.
CHAPTER 6 Number Severity 9704 16 Adaptive Server Error Messages Text and Explanation Unable to get SQL Server security information. Adaptive Server could not perform the requested action. The command violates a permission or privilege restriction. Check the command and working database context. Explanation: 9705 16 Unable to set SQL Server security information. Explanation: Adaptive Server could not perform the requested action. The command violates a permission or privilege restriction.
Server Error Messages 9700 - 9799 Number Severity 9715 16 Text and Explanation default account Explanation: This is an informational message or a message header. No action is required. 9716 16 default domain 16 required. set host 16 required. key _ Explanation: 9717 Explanation: 9718 Explanation: This is an informational message or a message header. No action is This is an informational message or a message header. No action is This is an informational message or a message header.
CHAPTER 6 Number Severity Text and Explanation 9729 16 false Adaptive Server Error Messages Explanation: This is an informational message or a message header. No action is required. 9730 16 space Explanation: This is an informational message or a message header. No action is 9731 16 9732 16 required. domain separator Explanation: This is an informational message or a message header. No action is required. null Explanation: This is an informational message or a message header.
Server Error Messages 9800 - 9899 Number Severity Text and Explanation 9809 21 9810 21 Control page %d specified for partition number %d of object id %d in database %d does not exist. 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. Control page %d specified for partition number %d for object id %d in database %d is corrupt.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 9823 20 9824 20 Insert new partition row in SYSPARTITIONS failed for slice number %d. Database id %d, Object id %d, Total number of slices %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. Update row in SYSPARTITIONS failed.
Server Error Messages 9900 - 9999 Number Severity Text and Explanation 9904 10 Total (# of text chains = %ld text pages = %ld) in this table. This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. Explanation: 9905 10 Processed %ld tables. Found %ld good text entries, %ld bad text entries in this database Explanation: This is an informational message.
CHAPTER 6 Number Severity 9918 16 Adaptive Server Error Messages Text and Explanation Encountered error using dbid %d. There may be possible corruption in a database or a database object. Take any corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide. Explanation: 9919 16 9920 16 Can't find object id for %.*s. Check the object name and re-run this command. Explanation: Command failed due to invalid or illegal request.
Server Error Messages 9900 - 9999 Number Severity Text and Explanation 9929 14 Only the DBO of database %S_DBID or a user with System Administrator (SA) role can run DBCC TEXTALLOC command. Explanation: You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 9942 16 Failed to hide the source text. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 9943 16 9944 10 The hidden text of object named '%s' with object id '%d' does not exist. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions.
Server Error Messages 9900 - 9999 Number Severity Text and Explanation 9951 17 9952 17 Workspace '%.*s' is too fragmented to be used. Use sp_dbcc_createws and sp_dbcc_updateconfig to correct the problem. 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. Workspace '%.*s' is too small to permit the CHECKSTORAGE operation to proceed.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 9962 17 9963 16 Access to table '%.*s' index '%.*s' in the target database failed. Explanation: Problem impacts outcome of dbcc checkstorage. An error occurred while attempting to insert a row into the dbcc_faults table or the dbcc_fault_params table. Explanation: Problem impacts outcome of dbcc checkstorage. 9964 16 9965 16 9966 16 9967 16 Database '%.*s' was not found.
Server Error Messages 9900 - 9999 Number Severity Text and Explanation 9974 10 9975 10 DBCC CHECKSTORAGE for database '%.*s' sequence %d completed at %s. %d faults and %d suspect conditions were located. %d checks were aborted. You should investigate the recorded faults, and plan a course of action that will correct them. Explanation: This is an informational message but may require follow-up action. Contact your System Administrator. DBCC CHECKSTORAGE for database '%.*s' encountered an error.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 9985 16 DBCC could not truncate the size of workspace '%.*s' in database '%.*s' by %d pages. Explanation: Problem impacts outcome of dbcc checkstorage. Check the SA Guide for assistance. 9986 10 Suspect conditions are to be treated as faults if the same suspect condition persists in subsequent CHECKSTORAGE operations, or if they are also detected by other DBCC functions.
Server Error Messages 9900 - 9999 Number Severity Text and Explanation 9995 16 9996 16 9997 16 There is a mismatch between value of insert free space %ld in page header of DOL datapage %ld and actual value of insert free space %ld computed from the page with expected row size as %ld Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message. Keys of index id %d for table '%.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 10100 - 10199 Number 10101 Severity 16 Text and Explanation The object_type column cannot be NULL. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 10102 16 The attrib_notify() function can only be used from a system stored procedure or with ad hoc updates enabled. Explanation: Command failed due to invalid or illegal request.
Server Error Messages 10200 - 10299 Server Error Messages 10200 - 10299 Number 10201 Severity 10 Text and Explanation NESTING LEVEL %u SUBQUERIES FOR STATEMENT %u. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 10202 10 QUERY PLAN FOR SUBQUERY %u (at nesting level %u and at line %u). This is an informational message. Unless otherwise specified, no action is required.
CHAPTER 6 Number Severity 10212 10 Adaptive Server Error Messages Text and Explanation The cursor is read only because it contains a subquery. This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. Explanation: 10213 10 10214 10 10215 10 10216 10 The update mode is deferred_varcol. Explanation: This is an informational message. Unless otherwise specified, no action is required.
Server Error Messages 10200 - 10299 Number Severity Text and Explanation 10225 10 Auxiliary scan descriptors required: %ld Explanation: This is an informational message or a message header. No action is required. 10226 10 The specified spid value '%d' is out of range. It must be positive and not exceed the maximum number of user connections. Explanation: This is an informational message or a message header. No action is required.
CHAPTER 6 Number Severity 10235 10 Adaptive Server Error Messages Text and Explanation The cursor was closed because the object associated with it has been dropped. This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. Explanation: 10236 10 10237 10 10239 10 10240 10 Executed by %ld worker processes. Explanation: This is an informational message or a message header.
Server Error Messages 10300 - 10399 Number Severity Text and Explanation 10251 10 10252 10 Merge join (outer table). Explanation: This is informational text. Merge join (inner table). Explanation: This is informational text. 10253 10 10254 10 10255 10 10256 10 Serial data merge. Explanation: This is informational text or header. Data copying. Explanation: This is informational text or header. Text/Image column(s) deallocation. Explanation: This is informational text. Catalog updates.
CHAPTER 6 Number Severity 10306 14 Adaptive Server Error Messages Text and Explanation You do not have the permission to use datatype named %.*s in database %.*s. You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command. Explanation: 10307 14 10308 14 10309 14 10310 14 Curread should dominate the label being used. Explanation: You do not have the permission to execute this command.
Server Error Messages 10300 - 10399 Number Severity Text and Explanation 10317 14 The specified password is too short. Passwords must be at least %d character(s) long. Explanation: You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command. 10318 14 10319 14 10320 14 10321 14 10322 14 10323 14 10324 14 Invalid user specified, password left unchanged. Explanation: You do not have the permission to execute this command.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 10328 14 UNCERTIFIED object %S_OBJID, database %S_DBID accessed by CERTIFIED object %S_OBJID, database %S_DBID. Cannot execute query. Explanation: Command failed due to invalid or illegal request. Adaptive Server cannot perform the requested action. Take any corrective action indicated by the message. 10329 14 Sysobjects entry NOT found for procedure buffer entry.
Server Error Messages 10300 - 10399 Number Severity Text and Explanation 10339 16 Database ’%S_DBID’ not found. Explanation: Adaptive Server could not perform the requested action. Contact your System Administrator. 10340 14 Permission denied. User's curwrite does not match the sensitivity label of database `%S_DBID'. Explanation: You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 10349 14 Permission denied. Only a user with curread set to @@data_high can perform the command `%.*s'. Explanation: You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command. 10350 14 Permission related internal error was encountered. Unable to continue execution. Explanation: You do not have the permission to execute this command.
Server Error Messages 10300 - 10399 Number Severity Text and Explanation 10359 18 The curread and curwrite labels of the Client do not equal the connection level for the remote Server. Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator. 10360 18 Site `%.*s' not found in sysservers. Explanation: Command failed due to internal Adaptive Server problem.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 10400 - 10499 Number 10401 Severity 10 10402 10 10403 10 10404 10 10405 10 10406 10 10407 10 10408 10 10409 10 Text and Explanation additional network memory allocates additional memory for clients which request packet sizes that are larger than the default packet size for the server. Explanation: This is an informational message. Unless otherwise specified, no action is required.
Server Error Messages 10400 - 10499 Number Severity Text and Explanation 10410 10 cpu grace time specifies the maximum amount of time (in milliseconds) a user process can run without yielding the CPU before SQL Server infects it. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 10420 10 event buffers per engine specifies the number of events per SQL Server engine that can be simultaneously monitored. Events are used for observing SQL Server performance. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
Server Error Messages 10400 - 10499 Number Severity Text and Explanation 10430 10 page lock promotion PCT sets the percentage of page locks allowed before SQL Server escalates to a table lock. The default value is 100. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 10440 10 number of alarms specifies the number of alarms allocated by SQL Server. Alarms are used with the Transact-SQL waitfor command. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 10441 10 number of devices controls the number of database devices SQL Server can use.
Server Error Messages 10400 - 10499 Number Severity Text and Explanation 10450 10 number of open objects sets the maximum number of database objects that can be open at one time on SQL Server. The default run value is 500. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 10460 10 partition spinlock ratio sets the number of partition caches each spinlock protects. These spinlocks keep processes from using partition caches used by other processes. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
Server Error Messages 10400 - 10499 Number Severity Text and Explanation 10471 10 stack size sets the size of SQL Server's execution stack. This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. Explanation: 10472 10 systemwide password expiration is the number of days that passwords remain in effect after they are changed. The default is 0 (passwords do not expire).
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 10482 10 shared memory starting address determines the virtual address at which SQL Server starts its shared memory region. Most users do not need to modify this. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
Server Error Messages 10500 - 10599 Number Severity Text and Explanation 10493 10 cis connect timeout specifies the number of seconds to wait for a connect request to a remote server to complete. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 10494 10 cis bulk insert batch size specifies the number of rows in a bulk copy batch when performing a SELECT INTO operation.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 10502 16 Internal error occurred. Unexpected value supplied. Please call Sybase Technical Support. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message. Server Error Messages 10600 - 10699 Number Severity 10601 10 Text and Explanation lock hashtable size specifies the number of buckets in the lock hash table.
Server Error Messages 10600 - 10699 Number Severity Text and Explanation 10608 10 enable unloading of a DLL after each execution of extended stored procedure. This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. Explanation: 10609 10 specify the extended stored procedure execution priority on the XP Server. The values range from 0 to 15. The default value is 8.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 10619 10 10620 10 10621 10 10622 10 10623 10 10624 10 10625 10 10626 10 number of large i/o buffers controls the number of extent size i/o disk buffers which are allocated at server startup. These buffers are used by 'disk mirroring', 'load database' and some dbcc commands. Explanation: This is an informational message. Unless otherwise specified, no action is required.
Server Error Messages 10600 - 10699 Number Severity Text and Explanation 10628 10 10629 10 When set to 1, the Server will not allow any user connections which are not using message replay detection checks. Default value is 0. When set to 0, the Server will allow connections which use message replay as well as those which don't. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 10636 10 enables/disables the grouping of stored procedures. The default is 1 (procedure grouping allowed). Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 10637 10 enables/disables granting select to public to the text column of the syscomments table. The default is 1 (grant select on syscomments.
Server Error Messages 10600 - 10699 Number Severity Text and Explanation 10647 10 enables/disables asynchronous prefetch server-wide. Sets the percentage of each buffer pool in which prefetched but unused pages can be stored. If needed, this value can be overridden for a pool with local async prefetch limit Explanation: This is an informational message. No action is required. 10648 10 10649 10 10650 10 disable disk mirroring is a toggle that allows the user to utilize SQL Server disk mirroring.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 10657 16 Size of object heap is the per-process memory used for allocating Java objects. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message. 10658 16 Size of class heap is the memory used for Java classes and other such structures that are shared between all processes.
Server Error Messages 10600 - 10699 Number Severity Text and Explanation 10667 10 enable monitoring specifies whether the Adaptive Server will collect information for the Monitoring and Diagnostic System. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 10679 10 statement pipe max messages specifies the maximum number of messages that can be stored for historical statement text. Explanation: This is an informational message. No action is required. 10680 10 10681 10 10682 10 10683 10 10684 10 errorlog pipe active indicates whether the Adaptive Server will collect historical errorlog monitoring information. Explanation: This is an informational message.
Server Error Messages 10600 - 10699 Number Severity Text and Explanation 10690 10 The ’default exp_row_size percent’ parameter reserves a specified percentage of page size for expanding updates in data-only-locked tables. The default value is 5. Explanation: This is an informational message. No action is required.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 10700 - 10799 Number 10701 Severity 16 10707 16 Text and Explanation getMoreResults() is not allowed after executeQuery() or executeUpdate(). Explanation: This is an informational message or a message header. No action is required. Unhandled Java Exception: %s. Explanation: 10708 16 Class %.*s not found. Check and make sure that the class has been installed, and an entry exists in Sysxtypes.
Server Error Messages 10700 - 10799 Number Severity Text and Explanation 10716 16 A SQL statement which produces a result set was submitted through a JDBC executeUpdate() method. Use the JDBC execute() or executeQuery() methods. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 10727 16 Invalid text pointer specified. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 10728 16 The specified file or image column contains a Java class. Java classes cannot be directly installed. Enclose this class in a jar and re-try your command. Explanation: ommand failed due to invalid or illegal request.
Server Error Messages 10700 - 10799 Number Severity Text and Explanation 10738 16 An overflow error was found while converting datatype ’%s’ to datatype ’%s’. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Explanation: 10739 16 10740 16 10741 16 10742 16 You cannot do an update (INSERT, DELETE or UPDATE) from a JAVA method which is invoked in a query already doing an update.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 10750 16 You cannot use a Java-SQL class datatype in which the size of class is more than the server limits in this aggregate expression. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 10751 16 You cannot use a Java-SQL class datatype in this subquery or aggregate expression.
Server Error Messages 10700 - 10799 Number Severity Text and Explanation 10761 16 You specified invalid datatypes in object comparison. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 10762 16 Cannot initialize the Java Virtual Machine because the Java class library ($SYBASE/$SYBASE_ASE/lib/runtime.zip) is either missing, corrupted, or incompatible with the current server release.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 10772 16 Cannot get data value or metadata from the result set because the result set has been closed or does not exist. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 10773 16 Cannot find column name ’%s’ in this result set. Explanation: Command failed due to invalid or illegal request.
Server Error Messages 10700 - 10799 Number Severity Text and Explanation 10783 16 %s is not a valid value for a parameter index because there is no parameter declared. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 10793 16 There is no class in a jar. Make sure that jar contains at least one class. Install failed. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Explanation: 10794 16 Cannot pass NULL as the value for parameter number %d to the method ’%s’ in class ’%s’. The parameter is of a Java primitive datatype, and is non-nullable.
Server Error Messages 10800 - 10899 Number Severity Text and Explanation 10802 16 Configuration Error: Configuration Parameter `%s' cannot be changed to 1 when parameter `evaluated configuration' is set to 1. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 10816 16 The value of the `dump on conditions' configuration parameter must be either 0 or 1. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Explanation: 10817 16 Configuration Error: Unknown cache replacement policy `%s' defined for cache `%s'. Explanation: Command failed due to invalid or illegal request.
Server Error Messages 10800 - 10899 Number Severity Text and Explanation 10827 10 Warning: the value of the configuration parameter 'max scan parallel degree' has been set to %d. For optimal performance, a value no larger than 4 is recommended. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 10837 16 Cannot ’enable ha’ as HA services require Omni services . Please enable Omni services first. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 10838 16 Server is currently HA cluster configured. ASE HA Services can not be disabled. Explanation: Command failed due to invalid or illegal request.
Server Error Messages 10900 - 10999 Number Severity Text and Explanation 10846 16 Overflow error: The ’total logical memory’ ’%d’ (2k pages) required for the configuration exceeds the maximum size of memory available on a ’%d’ bit platform: ’%lu’ bytes. Please reduce the configuration values that are consuming large amounts of memory. Explanation: Take corrective action indicated by message. Check the System Administration Guide for discussion of how Adaptive Server uses memory.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 11000 - 11099 Number 11001 Severity 10 Text and Explanation Row count exceeded limit of %d. Explanation: Indicates that resource limits defined with Resource Governor were exceeded. 11002 10 Estimated IO cost exceeded limit of %d. Indicates that resource limits defined with Resource Governor were reached. Explanation: 11003 10 11004 10 11005 10 11006 17 Actual IO cost exceeded limit of %d.
Server Error Messages 11000 - 11099 Number Severity Text and Explanation 11013 16 11014 16 Correlated columns are not allowed in the outer join clause of the subquery. Explanation: Refer to the writeup for Error 301. Insufficient worker processes available. Query executed using current available worker processes. Inform the system administrator (SA) that the value of worker processes m ay be too low. Explanation: Adaptive Server could not perform the requested action.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 11026 10 Warning: The statement on line %d uses the '%.*s' option with the view '%.*s'. Performance hint options are valid only for tables. This hint will be ignored. Explanation: There may be a potential problem with a database or database object. Contact your System Administrator. 11029 16 An index was found on table '%.*s' created via SELECT INTO. Parallel inserts into indexed tables is unsupported.
Server Error Messages 11000 - 11099 Number Severity Text and Explanation 11038 16 Your password will expire in %.*s days. Explanation: This is an informational message or a message header. No action is required. 11039 16 Another Execute Immediate statement cannot be executed inside an Execute Immediate statement. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 11048 17 11049 16 11050 16 ALTER TABLE ’%.*s’ failed. Cursor ’%.*s’ is still open. Close this and any other open cursors on this table before this schema change 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. Cannot add column with duplicate name.
Server Error Messages 11100 - 11199 Number Severity Text and Explanation 11058 16 Statement contains ’%d’ columns/expessions in the target list. This exceeds the maximum limit of ’%d’. Explanation: Rewrite the query or split into multiple queries to conform to the server limits. 11059 16 Too many tables in the query. The maximum allowable is %d. Explanation: Rewrite the query or split into multiple queries to conform to the server limits.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 11105 16 No such user/role '%.*s' exists. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 11106 16 11107 10 11108 10 11109 14 11110 14 11111 16 Failed to grant role '%.*s' to grantee '%.*s' because failed to expand the role to be granted. Explanation: Command failed due to invalid or illegal request.
Server Error Messages 11100 - 11199 Number Severity Text and Explanation 11116 16 Cannot drop role '%.*s' because it does not exist in this server. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 11117 16 11118 16 11119 16 11120 16 You must have SSO authorization to drop User Defined Roles. Explanation: Command failed due to invalid or illegal request.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 11126 16 Cannot add the '%.*s' exclusivity between role '%.*s' and role '%.*s' because it already exists for this server. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 11127 16 The role named as '%.*s' does not exist for this server.
Server Error Messages 11100 - 11199 Number Severity Text and Explanation 11142 16 You specified the wrong password for enabling role '%.*s'. Try again with the correct password. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 11143 16 11145 16 The password specified in CREATE/ALTER ROLE command is too short. The minimum length of passwords is %d characters.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 11153 16 Operation failed. Role '%.*s' (contained by role '%.*s') is mutually exclusive at membership or activation level with role '%.*s'. Remove the exclusivity and try again. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 11154 16 Operation failed. Role '%.*s' has not been granted to role '%.*s'.
Server Error Messages 11100 - 11199 Number Severity Text and Explanation 11162 16 Operation failed. Role '%.*s' (contained by role '%.*s') is mutually exclusive at activation level with role '%.*s' (which has already been enabled). Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 11165 16 11166 16 A user or group with the name '%.*s' already exists in this Server.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 11175 16 Operation failed because the limit for maximum number of roles that can be synchronized on companions is ’%d’. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
Server Error Messages 11300 - 11399 Number 11304 Severit y 20 11305 16 Failed to open the object '%d' in database '%d' while executing the built-in function logschema(). Check if the object exists and retry the operation. Explanation: Adaptive Server could not perform the requested action. Contact your System Administrator. 11306 16 The object '%d' cannot be found in sysobjects in database '%d'. Check the value o f the object ID and retry the operation.
CHAPTER 6 Adaptive Server Error Messages Number 11312 Severit y 20 11313 20 Failed to write the replication log record for the '%.*s' command for object '%.* s' in database '%S_DBID'. The '%.*s' command is aborted. 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. 11314 17 Failed to write the replication log record for the '%.
Server Error Messages 11400 - 11499 Number Severity Text and Explanation 11404 20 ESP %s not found in DLL %s. Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator. 11405 19 11406 10 11407 10 Illegal ESP priority specified. Setting it to previous value %d. Explanation: Command failed when a non-configurable limit was exceeded. Reconnect to Adaptive Server and report the error to your System Administrator.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 11416 20 Failed to install the connection handler. Check the XP Server log file. Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator. 11417 20 11418 20 11419 20 Failed to install the disconnect handler. Check the XP Server log file. Explanation: Adaptive Server encountered an internal error affecting the current process.
Server Error Messages 11400 - 11499 Number Severity Text and Explanation 11429 18 11430 10 Failed to free CS_CONTEXT structure. Check the XP Server log file. Explanation: Internal error affecting current process. Contact your SA. ESP priority set to %d. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 11431 10 Default stack size for ESP is %d.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 11442 20 Invalid authentication. Please contact Sybase Technical Support. Error affects XP Server operation. Contact your SA. Authentication was successful. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
Server Error Messages 11400 - 11499 Number Severity Text and Explanation 11456 20 Failed to get login authentication type. This is an internal error. Please contact Sybase Technical Support. Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator. 11457 17 Failed to get the time. Using random macro instead. Explanation: Command failed due to resource limitation.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 11469 20 Error condition in ESP. Refer to the XP Server log file for more information. Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator. 11470 10 11471 20 Stack size specified was too small. Using default size. Explanation: This is an informational message. Unless otherwise specified, no action is required.
Server Error Messages 11400 - 11499 Number Severity Text and Explanation 11481 10 Unable to start XP Server startup task. The server can continue running without this task, however notify Sybase Technical Support for this error. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 11482 17 Cannot allocate memory. Check the XP Server log file.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 11496 16 Cannot %S_MSG site '%S_SRVID'. Please check the XP Server error log file for detailed error description. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 11497 20 Extended stored procedure %s in dll %s has bad linkage (should be __stdcall) Explanation: Command failed due to invalid or illegal request.
Server Error Messages 11500 - 11599 Number Severity Text and Explanation 11513 10 Event log computer name is %s. This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. Explanation: 11514 17 Failed to log event in Event Log. The Event Log may be FULL. Explanation: Command failed due to resource limitation.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 11522 20 The call to srv_descfmt() failed in %s. Please contact Sybase Technical Support. 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. Explanation: 11523 20 The call to srv_xferdata() failed in %s. Please contact Sybase Technical Support.
Server Error Messages 11500 - 11599 Number Severity Text and Explanation 11531 20 Invocation of function %s failed. Please contact Sybase Technical Support. 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. Explanation: 11532 20 Failed to create attach file. Error number from Win32 System Service is %d.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 11541 20 Failed to unlock mutex in function %s. Please contact Sybase Technical Support. Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator. Explanation: 11542 20 Invalid mail profile name received. Check 'MailUserName' configuration parameter value for SQL Server login 'sybmail'.
Server Error Messages 11600 - 11699 Server Error Messages 11600 - 11699 Number 11601 Severity 18 Text and Explanation Instance does not have any data pointers for counters. Restart SQL Server. If problem persists, contact Sybase Technical Support. Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by the message. Report the error to your System Administrator.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 11609 10 Monitor Counter %s not found. This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. Explanation: 11610 10 11611 10 11612 10 11613 20 SYBPERF_OBJECT_TYPE %s not found. Explanation: This is an informational message. Unless otherwise specified, no action is required.
Server Error Messages 11700 - 11799 Number Severity Text and Explanation 11707 16 11710 16 Incorrect time syntax in time string '%.*s' used in the LOAD TRANSACTION UNTIL_TI ME statement. Correct format is month day, year hour:minute:seconds:milliseconds[am | pm] Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message. Subqueries are not allowed in a DEFAULT clause.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 11721 16 Global variables not allowed as defaults. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message. Explanation: 11722 15 The READPAST and HOLDLOCK object level locking options are incompatible. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
Server Error Messages 11700 - 11799 Number Severity Text and Explanation 11734 16 11735 15 The quoted identifier '%.*s' is illegal because it contains an embedded period followed by an embedded double quote. Please substitute another character in place of one of these characters. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message. You specified an invalid password option.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 11745 16 Function name ’%.*s’ is reserved for a T-SQL builtin function. Please use a different name. Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message. 11746 16 Unable to create access rule. Please make sure the the row level access option is enabled and ASE_ASM license is available and enabled. Explanation: Command failed.
Server Error Messages 11900 - 11999 Number Severity Text and Explanation 11904 16 You cannot specify an index with this REORG subcommand. Only the RECLAIM_SPACE subcommand can be run on an index. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message. 11906 16 You cannot use the RESUME or TIME options with the REBUILD subcommand. Explanation: Command failed due to invalid or illegal request.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 11921 10 Beginning REORG RECLAIM_SPACE of index '%.*s' on table '%.*s'. This informational message is printed when the REORG RECLAIM_SPACE command starts executing on an index. Explanation: 11922 10 Resuming REORG %s of '%.*s'. Explanation: This informational message is printed when the REORG utility starts execution with the RESUME option. The first parameter is the subcommand name, for example RECLAIM_SPACE.
Server Error Messages 12000 - 12099 Server Error Messages 12000 - 12099 Number 12001 Severity 16 Text and Explanation Unable to find entry for class: %d, attribute: %d, value: %d. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 12003 16 Unable to allocate shared memory dump condition. All conditions (%d) already allocated. Explanation: Command failed due to invalid or illegal request.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 12012 16 Unable to perform this operation. The internal dump condition table was not allocated at server startup time. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. 12013 16 Function ’%s’ expected %d parameters but received only %d. Retry the function with at least the expected number of parameters.
Server Error Messages 12000 - 12099 Number Severity Text and Explanation 12024 16 CCB ’%s’ cannot be found because %s. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Explanation: 12025 16 12026 16 12027 16 12028 16 CAPs configuration table rebuild may be required: %s ’%s’ is missing. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 12100 - 12199 Number 12100 Severity 16 12101 16 12102 16 12103 10 12104 16 12106 16 Text and Explanation Cannot execute a LOCK TABLE command on table '%.*s', because this table does not exist. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. The object '%.*s' you've specified is not a user table.
Server Error Messages 12200 - 12299 Server Error Messages 12200 - 12299 Number 12201 Severity 20 Text and Explanation Lock found in lock cache not on global lock chain: dbid %d, objid %d, locktype %d, sufficiency class %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.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 12300 - 12399 Number 12300 Severity 20 Text and Explanation Internal error: in table '%.*s', database %d, the forwarded row (%d, %d) pointed to by (%d, %d) is invalid. Aborting the transaction. 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.
Server Error Messages 12300 - 12399 Number Severity Text and Explanation 12309 21 Expanding update on object ’%.*s’ in database ’%.*s’ cannot succeed on page %ld, because the contiguous_free_bytes of %d is less than the difference of %d between new rowlen and old rowlen. This is an internal error. Explanation: Adaptive Server encountered an internal error affecting all processes using the current database. Report the error to your System Administrator.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 12316 20 12317 20 Internal error: Attempt to garbage collect a deallocated data page %d in table '% .*s', database '%.*s'. Aborting the transaction. 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.
Server Error Messages 12400 - 12499 Number Severity Text and Explanation 12323 20 Internal error occured during rebuild of index id %d of table ’%S_OBJID’ (id = %ld) in database ’%S_DBID’ while processing page %ld. Run dbcc checktable to see if the index is consistent. 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.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 12505 18 could not open table '%d' in database '%d' by id Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by the message. Report the error to your System Administrator. 12506 18 12507 18 sysstatistics upgrade error in table '%.*s' index '%.
Server Error Messages 12500 - 12599 Number Severity Text and Explanation 12513 10 12514 10 Failed to delete the user specified recovery order for the dropped database '%.*s '. Inform system administrator. During next bootup of server, this may turn off user specified recovery order. Explanation: his is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 12521 18 Recovery was unable to delete from the syscoordinations table. Please consult the Adaptive Server errorlog for further information as to the cause. Please cont act a user with System Administrator (SA) role Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by the message. Report the error to your System Administrator.
Server Error Messages 12500 - 12599 Number Severity Text and Explanation 12528 18 The pre-%s log for database ’%.*s’ includes a CREATE INDEX incompatible with this server version and operating environment. Only transactions completed before CREATE INDEX will be recovered. Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by the message. Report the error to your System Administrator. 12529 10 Warning: A transaction ’%.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 12537 16 Database ’%.*s’ is in QUIESCE DATABASE state. It will recovered as for LOAD DATABASE and left off line. Explanation: This is an informational message showing how the specified database will be treated upon server restart. 12538 10 12539 10 Database ’%.*s’ is in QUIESCE DATABASE state, but the server is not booted with the ’-q’ flag.
Server Error Messages 12700 - 12799 Number Severity Text and Explanation 12701 10 Suspect Granularity: Command failed. No cached suspect list. This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. Explanation: 12702 18 Suspect Granularity: Unable to delete suspect information from master..sysattributes table. Explanation: Command failed due to internal Adaptive Server problem.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 12712 18 Suspect Granularity: Command failed because an invalid action (`%d')was detected. This is an internal error. Please contact Sybase Technical Support. Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.
Server Error Messages 12700 - 12799 Number Severity Text and Explanation 12721 10 Suspect Granularity: Page `%ld' of database `%.*s' was made accessible to all users from previous state `%.*s'. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 12722 10 Suspect Granularity: The access state of page `%ld' of database `%.*s' was changed from `%.*s' to `%.*s'.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 12730 10 12731 17 Suspect Granularity: Automatic truncation of log after checkpoint has been disabled temporarily because some data in database `%.*s' is suspect. Either truncate log without no_log or truncate_only option, or online all suspect pages/objects. Explanation: This is an informational message. Unless otherwise specified, no action is required.
Server Error Messages 12700 - 12799 Number Severity Text and Explanation 12740 18 Recovery (Suspect Granularity): Failed to read suspect threshold from master..sysattributes for database `%.*s'. Assumimg default (`%d' pages). Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator. 12741 10 Recovery (Suspect Granularity): No transaction available to write to master..sysattributes table.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 12750 10 Recovery (Suspect Granularity): Warning - Page to object translation failed. This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. Explanation: 12751 18 Recovery (Suspect Granularity): Failed to insert suspect informationrow into master..sysattributes table.
Server Error Messages 12700 - 12799 Number Severity Text and Explanation 12760 10 Recovery (Suspect Granularity): Database `%.*s' - end list of pre-recovery suspect pages. This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. Explanation: 12761 10 Recovery (Suspect Granularity): Page '%ld' of database '%.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 12800 - 12899 Number 12801 Severity 12 12802 16 Text and Explanation The object `%.*s' is not a partitioned table. UPDATE PARTITION STATISTICS can only be run on partitioned tables. Explanation: Command failed. Specify an object of the correct type. Invalid partition number %d. Valid partition number is a positive integer. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions.
Server Error Messages 12800 - 12899 Number Severity Text and Explanation 12810 16 12811 16 12813 18 12814 18 12815 18 Cannot resolve column name '%.*s' for table '%.*s'. This could be because the column does not belong to the table or it has an unknown datatype or an internal error related to the system catalogs has happened Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message.
CHAPTER 6 Number Severity 12823 16 Adaptive Server Error Messages Text and Explanation Command ’addcert’ failed to add certificate path %s, system error: %s. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message. 12824 16 12825 16 12826 16 12827 16 12828 16 12829 16 12830 16 Command ’dropcert’ failed to drop certificate path %s.
Server Error Messages 12900 - 12999 Number Severity Text and Explanation 12902 16 Mime page chain starting at page %d has %d parts in it's header %d parts were found. Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 12912 10 12913 10 Incorrect offset entry(s) in the offset table of row %d in page %ld of object '%. *s' (ID %d) in database '%.*s' (ID %d). Explanation: This is an informational message. Correct the problem indicated in the preceeding messages or in the errorlog before re-executing the command. Contact your System Administrator for assistance. Incorrect column type in the offset table of row %d in page %ld of object '%.
Server Error Messages 12900 - 12999 Number Severity Text and Explanation 12923 10 Failed to get an '%s' lock on table '%.*s'. The faults for this table will not be processed. Explanation: dbcc checkstorage could not verify the faults for this table and its indexes because it was unable to block updates to the table. Contact your System Administrator. 12924 10 DBCC CHECKVERIFY for database '%.*s' encountered an error. Correct the reported problem reported and execute the CHECKVERIFY command again.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 12934 16 Page %ld of object %ld, indid %ld undergoing change. Some pages of indid %ld may not be checked, retry the command later. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message. 12935 16 Engine zero can not be offline. Explanation: Command failed due to invalid or illegal request.
Server Error Messages 12900 - 12999 Number Severity Text and Explanation 12947 16 Syslogs free space is currently %ld pages but DBCC counted %ld pages. This descrepancy may be spurious if this count was done in multi-user mode. Please run DBCC TABLEALLOC(syslogs, full, fix) to correct it. Explanation: Take any corrective action indicated by the message. 12948 10 Syslogs free space count has been successfully recalculated. It has been corrected to %ld pages.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 13000 - 13099 Number 13001 Severity 10 13002 10 Text and Explanation data page Explanation: This is an informational message or a message header. No action is required. index page Explanation: This is an informational message or a message header. No action is required. 13003 10 leaf page Explanation: 13004 10 Explanation: 13005 10 This is an informational message or a message header. No action is required.
Server Error Messages 13000 - 13099 Number Severity Text and Explanation 13012 10 A USE DATABASE statement This is an informational message or a message header. No action is required. Explanation: 13013 10 13014 10 13015 10 13016 10 a procedure or trigger Explanation: This is an informational message or a message header. No action is required. A DISTINCT clause Explanation: This is an informational message or a message header. No action is required.
CHAPTER 6 Number Severity 13025 10 Adaptive Server Error Messages Text and Explanation field Explanation: This is an informational message or a message header. No action is required. 13026 10 parameter This is an informational message or a message header. No action is required. convert specification Explanation: This is an informational message or a message header. No action is required. index Explanation: This is an informational message or a message header. No action is required.
Server Error Messages 13000 - 13099 Number Severity 13038 10 Text and Explanation SET command Explanation: This is an informational message or a message header. No action is required. 13039 10 column 10 required. type 10 required. character string Explanation: 13040 Explanation: 13041 Explanation: This is an informational message or a message header. No action is This is an informational message or a message header. No action is This is an informational message or a message header.
CHAPTER 6 Number Severity 13051 10 Adaptive Server Error Messages Text and Explanation ANSI text procesed in non-ANSI way This is an informational message or a message header. No action is required. Explanation: 13052 10 13053 10 13054 10 13055 10 a non-ANSI data type usage Explanation: This is an informational message or a message header. No action is required. Non-standard datatype TIMESTAMP Explanation: This is an informational message or a message header. No action is required.
Server Error Messages 13000 - 13099 Number Severity Text and Explanation 13064 10 Named columns in an ORDER BY included in a UNION This is an informational message or a message header. No action is required. Explanation: 13065 10 13066 10 13067 10 13068 10 Comparison operator != Explanation: This is an informational message or a message header. No action is required. Comparison operator !< Explanation: This is an informational message or a message header. No action is required.
CHAPTER 6 Number Severity 13077 10 Adaptive Server Error Messages Text and Explanation aborted Explanation: This is an informational message or a message header. No action is required. 13078 10 data Explanation: 13079 10 This is an informational message or a message header. No action is required. log This is an informational message or a message header. No action is required. A SYB_RESTREE statement Explanation: This is an informational message or a message header. No action is required.
Server Error Messages 13000 - 13099 Number Severity 13089 10 Text and Explanation object type Explanation: This is an informational message or a message header. No action is required. 13090 10 Backup Server 10 required. dump header 10 required. dump trailer Explanation: 13091 Explanation: 13092 Explanation: This is an informational message or a message header. No action is This is an informational message or a message header.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 13100 - 13199 Number 13100 Severity 16 13101 16 Text and Explanation recalculating sysindexes.minlen Explanation: This is an informational message or a message header. No action is required. WITH
Server Error Messages 13100 - 13199 Number Severity Text and Explanation 13112 10 checking database references in sysreferences This is an informational message or a message header. No action is required. Explanation: 13113 10 13114 10 13115 10 13116 10 modifying index syscomments.syscomments Explanation: This is an informational message or a message header. No action is required. recalculating sysindexes.maxlen Explanation: This is an informational message or a message header.
CHAPTER 6 Number Severity 13127 16 Adaptive Server Error Messages Text and Explanation forced lru/mru Explanation: This is an informational message or a message header. No action is required. 13128 16 forced prefetch This is an informational message or a message header. No action is required. initializing new column sysusers.sname Explanation: This is an informational message or a message header. No action is required. initializing new column sysalternates.
Server Error Messages 13200 - 13299 Server Error Messages 13200 - 13299 Number 13200 Severity 10 Text and Explanation executing SQL statement Explanation: This is an informational message or a message header. No action is required. 13201 10 initializing partition IDs for each extent This is an informational message or a message header. No action is required.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 13212 10 Creating/Updating the last chance threshold for logsegment. Explanation: This is an informational message or a message header. No action is required. 13214 10 13216 10 13217 16 insert rows into sysusrpartitions for each system table and index. Explanation: This is an informational message or a message header. No action is required. Upgrade SARGs in SYSINDEXES to 2-byte column IDs.
Server Error Messages 13900 - 13999 Number Severity Text and Explanation 13901 10 Warning: a rule or constraint is defined on column ’%.*s’ being modified. Verify the validity of rules and constraints after this ALTER TABLE operation. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 13902 10 Warning: Column ’%.*s’ being modified is a key in one or more indexes.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 13911 10 Warning: when modifying column ’%.*s’, user specified NULL type overrides the NULL type of user defined datatype ’%.*s’. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message. 13912 10 Warning: when modifying column ’%.*s’, the NULL type of the user-defined datatype ’%.
Server Error Messages 13900 - 13999 Number Severity Text and Explanation 13921 16 13922 16 ALTER TABLE ’%.*s’ failed. You cannot drop column ’%.*s’ on which a primary/foreign key constraint is defined using sp_primarykey or sp_foreignkey. Drop the key definitions before dropping the column. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message. ALTER TABLE ’%.*s’ failed.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 13931 16 ALTER TABLE ’%.*s’ failed. Internal error detected while trying to update SYSCOLUMNS with text/image replication status. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by the message. 13932 16 ALTER TABLE ’%.*s’ failed. You cannot modify column ’%.*s’ to type ’%.*s’ which has identity property.
Server Error Messages 14000 - 14099 Number Severity Text and Explanation 13940 16 One or more column names in the specified table contain reserved words or special characters, for example ’%.*s’. Set the QUOTED_IDENTIFIER option to handle the column(s) and re-run the command. Explanation: Adaptive Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 14006 10 The ’abstract plan cache’ option enables the server wide Abstract Plan EXISTS CHECK cache sub-mode. Explanation: This is an informational message. Unless otherwise specified, no action is required. 14007 10 14008 10 14009 10 14010 10 14011 10 14012 10 14013 10 14014 10 ’enable HA’ lets you enable or disable HA services in Adaptive Server. The default value is 0 (disabled).
Server Error Messages 14000 - 14099 Number Severity Text and Explanation 14016 16 dynamic allocation on demand specifies whether ASE memory can be allocated on demand due to reconfiguration of dynamic configuration parameters. Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
CHAPTER 6 Adaptive Server Error Messages Server Error Messages 14100 - 14199 Number 14101 Severity 21 Text and Explanation Insert of syspartition row failed. 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. 14102 21 Delete of syspartitions row failed. Explanation: Adaptive Server encountered an internal error affecting the current process.
Server Error Messages 14200 - 14299 Number Severity Text and Explanation 14122 21 Update failed. SQL Server could not find field ’%d’ within partition descript or/buffer. Adaptive Server encountered an internal error during a partitioning operation affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so diagnostics can be run. Explanation: 14123 21 Updating wrong ptnrow in dbid %d.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 14206 10 Warning: SQLJ procedure is trying to return more result sets than were specified in DYNAMIC RESULT SETS clause (%d). Only %d result sets are returned. Explanation: This is an informational message but may require follow-up action. 14207 16 Incorrect number of parameters for SQLJ function ’%.*s’. Explanation: Command failed. Check syntax and semantics. 14208 16 Unable to execute SQLJ function ’%s’.
Server Error Messages 14300 - 14399 Server Error Messages 14300 - 14399 Number 14300 Severity 16 Text and Explanation Cannot use duplicate column names in partition key list. Column name ’%.*s’ listed more than once. Explanation: Adaptive Server could not perform the requested action. Modify your command to meet the Adaptive Server requirement for the objects or variables shown in the error message. 14301 16 Column ’%.*s’ -- Cannot partition on a column of TEXT or IMAGE data type.
CHAPTER 6 Adaptive Server Error Messages Number Severity Text and Explanation 14308 20 Attempt to insert a row in syspartitionkeys failed. Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so diagnostics can be run. 14309 20 Attempt to delete a row in syspartitionkeys failed. Explanation: Adaptive Server encountered an internal error affecting the current process.
Server Error Messages 17000 - 18999 Number Severity Text and Explanation 1700018999 0 See above comment on this series of messages.
Glossary allocation pages Database-wide pages Adaptive Server uses to maintain the information about how each unit of 256 contiguous database pages is used. buffer A buffer is a structure that Adaptive Server uses to store physical disk pages while they are in memory. When a page is read into memory from disk, a buffer header is assigned to it. The header tracks the usage and the contents of the page image. Together, the page and the buffer header define a buffer.
The Navigation Server has its own error log file where Navigation Server error messages are written. Refer to the Navigation Server Reference Manual for details. extent Every 256-page allocation unit is divided into 32 structures called extents, each containing 8 contiguous pages. Each extent contains information about those 8 contiguous pages, including a bitmap showing pages in use and a bitmap showing pages to be deallocated.
object ID The number Adaptive Server uses to uniquely identify (within a database) an Adaptive Server object. If you know an object ID and you know the database the object is in, you can determine the object name. System tables have an object ID that is less than 100 and user tables have an object ID that is 100 or greater. primary key The column or combination of columns that uniquely identify a row.
1234
Index Symbols %S_MSG explanation 367 Numerics 102 error 142 107 error 143 11018 error 630 1105 error 281 1108 error 289, 379 1120 error 290 11203 error 632 1124 error 291 1127 error 292 1129 error 294 1131 error 296 1133 error 297 1141 error 298 1142 error 300 1143 error 304 11903 error 631 1203 error 306 1204 error 306 1205 error 308 1243 error 310 1249 error 311 1265 error 312 12716 error 633 12717 error 634 1279 error 313 12818 error 636 14200 error 637 1501 error 315 1505 error 316 1508 error 318 150
Index 1820 error 345 18750 error 649 1902 error 346 1903 error 347 1916 error 348 and 1508 error 319 1928 error 349 195 error 145 207 error 147 208 error 148 2110 error 349 213 error 150 216 error 151 2243 error 352 225 error 153 226 error 154 229 error 155 232 error 156 233 error 157 2401 error 353 2402 error 354 2409 error 355 241 error 159 247 error 160 2501 error 357 2502 error 358 2503 error 359 2506 error 361 2507 error 362 2509 error 364 2510 error 366 2511 error 367 2513 error 368 2514 error 369 25
Index 3211 error 444 3212 error 445 3216 error 446 3225 error 446 3230 error 447 3233 error 448 3240 error 449 3301 error 450 3307 error 451 3401 error 454 3403 error 455 3404 error 456 3414 error 457 3418 error 458 3425 error 459 3429 error 459 3434 error 461 3445 error 462 3446 error 463 3447 error 464 3452 error 465 3454 error 465 3470 error 467 3604 error 469 3621 error 469 3626 error 471 3701 error 473 3702 error 474 3703 error 475 3704 error 476 3731 error 477 3904 error 479 3905 error 480 3906 error
Index 5861 error 5863 error 5865 error 5866 error 5867 error 5868 error 5893 error 601 error 603 error 605 error 6103 error 6107 error 611 error 614 error 622 error 623 error 624 error 625 error 629 error 631 error 644 error 678 error 6901 error 6902 error 691 error 692 error 693 error 694 error 695 error 696 error 697 error 701 error 702 error 703 error 706 error 707 error 709 error 7101 error 7105 error 7114 error 7130 error 7134 error 7201 error 7205 error 7207 error 7211 error 1238 538 539 541 542 54
Index 8207 error 821 error 8210 error 8211 error 8219 error 822 error 823 error 832 error 834 error 835 error 840 error 8402 error 8419 error 842 error 847 error 849 error 852 error 855 error 8601 error 861 error 863 error 8704 error 9004 error 903 error 905 error 906 error 908 error 911 error 9122 error 913 error 916 error 921 error 924 error 925 error 926 error 930 error 935 error 940 error 941 error 945 error 950 error 616 240 617 618 619 241 243 245 246 248 248 621 622 249 250 251 253 254 625 255 256 6
Index and 1131 error 296 allow remote access and 7221 error 572 allow updates and 259 error 164 allow_dup_row and 1508 error 318 and 1916 error 348 create index option 318 alter database and 1808 error 342 and 2558 error 399 and 3225 error 447 for load 273 when database full 512 alter database errors 512 Error 5006 512 Error 5013 513 Error 5018 515 Error 5034 517 alter table and 3703 error 475 508 Error 4951 508 Error 4953 508 Error 4954 509 Error 4956 510 Error 4964 510 and expression limit 17
Index Character set error 654 Character set support error checkpoint and 3401 error 454 and 623 error 203 and 624 error 205 and 631 error 214 and 7413 error 589 654 checkpoint and 822 error 281 Client process 333 Clustered index 400 and duplicate values 418 one per table 347 wrong page 210 Column limit on tables 339 name rules 339 Command aborted and 3621 error 469 Comments xxv Commit and abort errors 449, 450 Error 3301 450 Error 3307 451 Composite index definition 347 Configuration errors 527, 629 Erro
Index Error 1808 342 Error 1809 343 Error 1810 344 Error 1813 344 Error 1820 345 Error 1902 346 Error 1903 347 Error 1916 348 Error 1928 349 Error 2110 349 Error 2714 426 Error 2729 427 Error 2762 428 Creating error messages CSMD Dump 132 sort order 441 suspect 207, 266, 270 suspect, how to reload 84 Database owner. See dbo dataserver and 1623 error 337 dataserver errors 487 Error 4001 487 Error 4002 488 Error 4020 491 Datatype storage size.
Index analyzing faults 69 and other dbcc errors 70 faults due to sp_placeobject dbcc checktable and 2501 error and 2506 error and 2507 error and 2509 error and 2524 error and 2582 error and 2596 error and 7902 error and 7930 error and 7948 error dbcc dbrepair and 2520 error 357 361 362 364 377 409 413 598 602 1040 372 dbcc dbrepair and 2573 error 404 and 3702 error 474 dbcc errors 357, 597 2591 error 412 Error 2501 357 Error 2502 358 Error 2503 359 Error 2506 361 Error 2507 362 Error 2509 364 Error 2510
Index and user connections 327 default character set changing manually 58 Deleting duplicate rows 324 Delimited identifiers 147 Descriptor Manager errors 613 Error 8201 613 Error 8203 613 Error 8204 615 Error 8207 616 Error 8210 617 Error 8211 618 Error 8219 619 Device finding virtual device number 108 lost, with pieces of tempdb 14 moving using disk mirroring 100 offline 241, 242, 249, 447 removed 241, 249 renamed 241, 249 dinit kernel error message 243 Disaster recovery 1 Disk errors 515, 519 Error 5115
Index Error 4305 Error 4322 502 503 dump database and 3211 error and 3212 error and 3240 error 444 445 449 dump transaction and 4204 error 493 and 4207 error 498 and 4222 error 501 with no_log 240 Duplicate key and create index 316 Duplicate rows deleting 324 E Error 243 creating error messages 138 faxing log fragments 140 hard 605 195 read Error 822 241 reporting to Sybase 138 system procedure 639 transient 605 195 variables in error message text write Error 822 241 Error 102 142 Error 107 143 Error
Index Error 17906 645 Error 17910 646 Error 1803 340 Error 18031 646 Error 18032 647 Error 18033 647 Error 1808 342 Error 1809 343 Error 18097 648 Error 1810 344 Error 18123 648 Error 1813 344 Error 18145 649 Error 1820 345 Error 18750 649 Error 1902 346 Error 1903 347 Error 1916 348 Error 1928 349 Error 195 145, 245 Error 207 147 Error 208 148 and 229 error 149 Error 2110 349 Error 213 150 Error 216 151 Error 2243 352 Error 225 153 Error 226 154 Error 229 155 Error 232 156 Error 233 157 Error 2401 353 Err
Index Error 2812 433 Error 2824 436 Error 2835 437 Error 301 172 Error 3019 438 Error 3020 439 Error 3105 440 Error 311 172 Error 3120 441 Error 313 174 Error 314 176 Error 3201 442 Error 3203 443 Error 3211 444 Error 3212 445 Error 3216 446 Error 3225 446 Error 3230 447 Error 3233 448 Error 3240 449 Error 3301 450 Error 3307 451 Error 3401 454 Error 3403 455 Error 3404 456 Error 3414 457 Error 3418 458 Error 3425 459 Error 3429 459 Error 3434 461 Error 3445 462 Error 3446 463 Error 3447 464 Error 3452 465
Index Error 5808 527 Error 5824 528 Error 584 191 Error 5846 529 Error 5847 530 Error 5848 531 Error 5849 532 Error 5850 532 Error 5851 533 Error 5852 534 Error 5853 535 Error 5854 536 Error 5857 537 Error 5859 538 Error 5861 538 Error 5863 539 Error 5865 541 Error 5866 542 Error 5867 542 Error 5868 543 Error 5893 544 Error 601 192 Error 603 193 Error 605 195 and 2502 error Error 6103 546 Error 6107 547 Error 611 198 Error 614 199 Error 622 202 Error 623 202 Error 624 204 Error 625 207 Error 631 211 Error
Index Error 7939 Error 7940 Error 7949 Error 7989 Error 8006 Error 8009 Error 803 Error 804 Error 806 Error 813 Error 820 Error 8201 Error 8203 Error 8204 Error 8207 Error 821 Error 8210 Error 8211 Error 8219 Error 822 Error 823 Error 834 Error 835 Error 840 Error 8402 Error 8419 Error 842 Error 847 Error 849 Error 852 Error 855 Error 8601 Error 861 Error 863 Error 8704 Error 9004 Error 903 Error 905 Error 906 Error 911 Error 9122 Error 913 Error 916 Error 921 Error 924 Error 925 603 605 607 609 610 611 23
Index query processor 171 recovery 452 remote create 631 RPC 610 Sequencer 147, 594, 630, 637 Site Buffer Manager 626 Sort Manager 313 sysindexes Manager 621 Text Manager 552 threshold 580 timestamp 548 Transaction 479 Execution plan and 225 error 153 Expression limit on queries 178 Extent 386, 394 F Failed to open device error 663 Fast bcp method 507 Fault Isolation Utility errors 633 Error 12716 633 Error 12717 634 File already in use error 664 forceindex and 313 error 176 and 314 error 176 Foreign key
Index Error 1608 Error 1613 Error 1621 Error 1622 Error 1623 333 334 335 336 337 insert and 1203 error 306 and 2620 error 421 Insert errors 2626 error 422 Error 2601 416 Error 2610 416 Error 2615 418 Error 2619 419 Error 2620 420 Error 2628 424 insert errors 416 installmaster and 2812 error 434 and permissions error executing 35 435 dopen 657 dstart I/O request repeatedly delayed 659 failed to open device 663 file already in use 664 memory too fragmented 665 memory usage in procedure headers 666 netwo
Index Lock Manager errors Error 1203 306 Error 1204 306 Error 1205 308 Error 1243 310 Error 1249 311 Error 1265 312 Error 1279 313 304, 306 lock promotion hwm configuration parameter. See sp_configure lock promotion lwm configuration parameter. See sp_configure lock promotion pct configuration parameter.
Index how to check size 341, 344 installing 35 lost or corrupted 13 rebuilding 39 Multiuser mode returning Adaptive Server to 34 N Naming conventions 148, 434 Network 1602 error 328 1605 error 330 1608 error 333 1613 error 334 information message 667 No more alarms available error 668 Non-logged operation 507 and 268 error 169 Novell starting Adaptive Server with trace flags 82 number of devices parameter altering manually 38 number of locks configuration parameter.
Index Optimizer problems getting help with 116, 125 preparing for analysis of 116, 125 or expression limit 178 OS/2 starting Adaptive Server with trace flags in os_attach_region error 670 os_create_region errors 671 P Page chain 359, 373, 386 distribution 380 incorrect free byte offset 413 linkage error 359 not found 381 offset table inconsistencies 421 See Also Allocation 383 Page Manager errors 281 Error 1105 281 Error 1108 289 Error 1120 290 Error 1124 291 Error 1127 292 Error 1129 294 Error 1131 296 E
Index Error 512 181 Error 515 183 Error 530 185 Error 539 185 Error 540 186 Error 547 188 Error 551 190 Error 584 191 Query tree 229 R Raw partitions correct use of 97 getting information about 99 Read Error 822 241 Error 823 244 Rebuilding Adaptive Server 17 Recovery and 3301 error 450 and 3403 error 455 and 631 error 212 and 906 error 257, 260 errors 205 preparing for database 1 Recovery errors 452, 454 Error 3401 454 Error 3403 455 Error 3404 456 Error 3414 457 Error 3418 458 Error 3425 459 Error 3429 4
Index modifying for UNIX 80 S sdes 232, 234 Search condition limits Segment default 395 log 396 mapping 394 system 395 227 select and 1203 error 306 select into and 4207 error 498 select into/bulkcopy how to activate 170 Sequencer Errors 147 Error 195 159 Error 207 147 Error 208 148 Error 213 150 Error 216 151 Error 225 153 Error 226 154 Error 229 155 Error 232 156 Error 233 157 Error 257 162 Error 259 163 Error 265 165 Error 266 166 Error 268 169 Error 277 171 Sequencer errors 594, 630, 637 Err
Index running out of locks 307 total memory configuration parameter sp_addthreshold and 17870 error and 17871 error and 17872 error and 17874 error and 17875 error and 18031 error 641 642 643 643 644 646 and 226 error 155 and 268 error 169 and 2762 error 429 and 4207 error 498 and 4806 error 507 and 924 error 268 and dbo 169 enabling select into/bulkcopy 170 sp_diskblock (user must add) 674 sp_bindcache and 861 error 255 sp_cacheconfig and 5868 error 543 sp_configure stack size configuration parame
Index and 17874 error 643 and 17875 error 644 and 17904 error 645 and 18031 error 646 and 18032 error 647 and 7403 error 582 sp_placeobject and 17737 error 641 sp_poolconfig 542 and 18145 error 649 and 852 error 253 sp_procqmode and 18097 error 648 sp_volchanged and 3216 error 446 sp_who and 924 error 267 output 95 Stack guardword 471 Stack guardword error 675 Stack size 472 and stack guardword error 676 stack size configuration parameter.
Index and 2501 error 357 and 2517 error 371 and 3703 error 475 and 906 error 260 finding system tables with ID value sysprocedures and 2517 error 371 and 2806 error 432 and 2811 error 433 and 2835 error 437 sysreferences and 3703 error 475 sysremotelogins and 4002 error 488 sysservers and 7214 error 566 and 7218 error 568 and 7220 error 569 System Administrator 135 System catalogs restoring information in 36 System memory 225 System procedure errors 639 Error 17461 639 Error 17715 640 Error 17716 640 Error
Index reducing the size of 111, 114 Temporary tables and 208 error 148 and 2714 error 426 Test cases 141 Text Manager errors 552 Error 7101 552 Error 7105 553 Error 7114 555 Error 7130 556 Error 7134 558 Threshold errors 580 Error 7401 580 Error 7402 581 Error 7403 582 Error 7404 583 Error 7406 584 Error 7407 585 Error 7408 586 Error 7409 586 Error 7410 587 Error 7411 588 Error 7412 589 Error 7413 589 Error 7414 590 Error 7415 591 Time out process times out 667 Timestamp and 4305 error 502 Timestamp errors
Index usertype problems 369 V Variables in error messages 135 vdevno 38 Virtual device number 38, 520, 522 Virtual disk number 673 Virtual page 235 Virtual sockets and 1605 error 330 W where clause limitations 178 Windows NT starting Adaptive Server with trace flags in Write Error 822 241 83 writetext and 268 error 169 and 7130 error 556 X XP Server 73 1261
Index 1262