http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0901/en/html/dberen9/00000011.htm

Error messages indexed by Sybase error code


Sybase error codes are a set of error codes for use by all Sybase products, including Adaptive Server Enterprise. For every Sybase error code returned by Adaptive Server Anywhere, there is a matching Adaptive Server Anywhere error code. In many cases Adaptive Server Anywhere error codes offer a finer level of granularity than their Sybase error code counterparts, thus some Sybase error codes in the following table are non-unique.

Sybase error code Adaptive Server Anywhere SQLCODE Error message
0 –631 RAISERROR executed: %1
102 –171 Error opening cursor
102 –199 INSERT/DELETE on cursor can modify only one table
102 –933 A log is required for IQ databases
102 –275 Triggers and procedures not supported in runtime server
102 –273 COMMIT/ROLLBACK not allowed within trigger actions
102 –131 Syntax error near '%1' %2
102 –687 Syntax error, cannot specify IQ specific options without specifying IQ PATH
102 –875 There is no way to join to '%1'
102 –145 Foreign key name '%1' not found
102 –271 Trigger definition conflicts with existing triggers
102 –272 Invalid REFERENCES clause in trigger definition
102 –635 GRANT of column permission on view not allowed
102 –151 Subquery allowed only one select list item
102 –269 Cannot delete a column referenced in a trigger definition
103 –250 Identifier '%1' too long
104 –854 Function or column reference to '%1' in the ORDER BY clause is invalid
108 –152 Invalid ORDER BY specification
133 –262 Label '%1' not found
134 –261 There is already a variable named '%1'
137 –260 Variable '%1' not found
154 –623 Data definition statements not allowed in procedures or triggers
155 –200 Invalid option '%1' -- no PUBLIC setting exists
174 –154 Wrong number of parameters to function '%1'
176 –611 Transact-SQL feature not supported
176 –148 Unknown function '%1'
182 –159 Invalid column number
201 –639 Parameter name missing in call to procedure '%1'
201 –615 Parameter '%1' not found in procedure '%2'
201 –737 Signature '%1' does not match procedure parameters
205 –153 SELECT lists in UNION, INTERSECT or EXCEPT do not match in length
207 –124 More columns are being dropped from table '%1' than are defined
207 –143 Column '%1' not found
208 –142 Correlation name '%1' not found
209 –144 Column '%1' found in more than one table -- need a correlation name
209 –163 Derived table '%1' has no name for column %2
213 –207 Wrong number of values for INSERT
217 –274 Procedure or trigger calls have nested too deeply
220 –158 Value %1 out of range for destination
230 –191 Cannot modify column '%1' in table '%2'
230 –190 Cannot update an expression
233 –195 Column '%1' in table '%2' cannot be NULL
233 –733 Number of columns allowing NULLs exceeds limit
257 –157 Cannot convert %1 to a %2
257 –705 Return type of void from procedure '%1' cannot be used in any expression
262 –121 %1
264 –637 Duplicate insert column
285 –708 READTEXT or WRITETEXT statement cannot refer to a view
301 –147 There is more than one way to join '%1' to '%2'
301 –680 Invalid expression in WHERE clause of Transact-SQL outer join
301 –146 There is no way to join '%1' to '%2'
305 –681 Invalid join type used with Transact-SQL outer join
311 –295 Cannot uniquely identify rows in cursor
314 –122 Operation would cause a group cycle
315 –136 Table '%1' is in an outer join cycle
315 –137 Table '%1' requires a unique correlation name
401 –134 Feature '%1' not implemented
401 –135 Language extension
401 –156 Invalid expression near '%1'
404 –890 Statement size or complexity exceeds server limits
409 109 Null value eliminated in aggregate function
409 –90 Argument %1 of procedure '%2' cannot be null
504 –265 Procedure '%1' not found
509 –140 User ID '%1' does not exist
512 –186 Subquery cannot return more than one row
518 103 Invalid data conversion
532 104 Row has been updated since last time read
532 106 Value for column '%1' in table '%2' has changed
538 –627 Disallowed language extension detected in syntax near '%1'
546 –194 No primary key value for foreign key '%1' in table '%2'
547 –198 Primary key for row in table '%1' is referenced by foreign key '%2' in table '%3'
547 –677 Table '%1' has a foreign key with a referential action
548 –196 Index '%1' for table '%2' would not be unique
548 –209 Constraint '%1' violated: Invalid value for column '%2' in table '%3'
549 –729 The specified foreign key (%1) can not be enforced
550 –632 WITH CHECK OPTION violated for insert/update on base table '%1'
553 –264 Wrong number of variables in FETCH
554 –208 Row has changed since last read -- operation canceled
557 –853 Cursor not in a valid state
557 –170 Cursor has not been declared
558 –172 Cursor already open
559 –180 Cursor not open
560 100 Row not found
560 –197 No current row of cursor
573 –738 Password must be at least %1 characters
590 111 Statement cannot be executed
601 –642 Invalid SQL descriptor name
708 –80 Unable to start database server
708 –86 Not enough memory to start
708 –679 Not enough memory is allocated to the Java virtual machine for remote access
840 –82 Unable to start specified database: %1
840 –87 Database name required to start server
911 –83 Specified database not found
924 –816 Specified database file already in use
927 –97 Database page size too big
927 –644 Invalid database page size
928 –645 Database creation failed: %1
932 –311 Internal rollback log corrupted
950 –76 Request denied -- no active databases
950 –74 The selected database is currently inactive
1205 –306 Deadlock detected
1205 –307 All threads are blocked
1205 –684 Rollback occurred due to deadlock during prefetch
1601 –102 Database server connection limit exceeded
1602 –85 Communication error
1602 –88 Client/server communications protocol version mismatch
1702 –616 Too many columns in table
1709 –849 Referential integrity actions other than RESTRICT not allowed for temporary tables
1709 –850 Tables related by key constraint must both be permanent or both be temporary created with ON COMMIT PRESERVE ROWS
1709 –865 Key constraint between temporary tables requires a primary key (not unique constraint)
1719 –118 Table '%1' has no primary key
1721 –113 Column '%1' in foreign key has a different definition than primary key
1801 –77 Database name not unique
1802 –138 Dbspace '%1' not found
1909 –636 Duplicate referencing column
1909 –119 Primary key column '%1' already defined
1909 –251 Foreign key '%1' for table '%2' duplicates an existing foreign key
1921 –111 Index name '%1' not unique
1921 –678 Index name '%1' is ambiguous
1923 –126 Table cannot have two primary keys
1923 –112 Table already has a primary key
2561 –106 Cannot open transaction log file -- %1
2601 –193 Primary key for table '%1' is not unique
2706 –141 Table '%1' not found
2715 –613 User-defined type '%1' not found
2727 –189 Unable to find in index '%1' for table '%2'
2732 –296 Error number %1 for RAISERROR may not be less than 17000
2748 –612 User message %1 not found
2749 –294 Format string argument number %1 is invalid
3013 –305 I/O error %1 -- transaction rolled back
3013 –309 Memory error -- transaction rolled back
3206 –240 Unknown backup operation
3206 –241 Database backup not started
3206 –242 Incomplete transactions prevent transaction log renaming
3451 –672 Database upgrade failed
3451 –673 Database upgrade not possible
3618 –302 Terminated by user -- transaction rolled back
3618 –304 Disk full '%1' -- transaction rolled back
3619 –107 Error writing to transaction log file
3621 –299 Statement interrupted by user
3702 –214 Table in use
3702 –215 Procedure in use by '%1'
3702 –750 User owns procedures in use
3702 –751 User owns tables in use
3819 –160 Can only describe a SELECT statement
4001 –105 Database cannot be started -- %1
4001 –84 Specified database is invalid
4001 –72 No database file specified
4002 –103 Invalid user ID or password
4002 –103 Invalid user ID or password
4002 –104 Invalid user ID or password on preprocessed module
4224 –108 Connection not found
4224 –99 Connections to database have been disabled
4224 –308 Connection was terminated
4406 –703 Cannot insert or update computed column '%1'
4409 –114 Number of columns defined for the view does not match SELECT statement
4412 –766 View references '%1', which is a temporary object. Views can only refer to permanent objects.
4708 –702 TRUNCATE TABLE statement cannot refer to a view
4901 –116 Table must be empty
4939 –127 Cannot alter a column in an index
5006 –604 A dbspace has reached its maximum file size
5006 –605 The server attempted to access a page beyond the end of the maximum allowable dbspace file size
5703 107 Language extension detected in syntax
5849 –201 Invalid setting for option '%1'
5864 –81 Invalid database server command line
5864 –735 Invalid parameter
5864 –79 Invalid local database switch
5864 –95 Parse error: %1
5864 –754 Parse error: %1
5878 –204 Only the DBA can set the option '%1'
5878 –216 The option '%1' can only be set as a temporary option
5878 –217 The option '%1' cannot be set from within a procedure
6001 –109 There are still active database connections
6004 –75 Request to start/stop database denied
6226 –183 Cannot find index named '%1'
6259 –263 Invalid absolute or relative offset in FETCH
6267 –814 Cannot update column '%1' since it appears in the ORDER BY clause.
6401 –220 Savepoint '%1' not found
7123 –608 Invalid TEXTPTR value used with WRITETEXT or READTEXT
7139 –609 Invalid data type for column in WRITETEXT or READTEXT
7201 –155 Invalid host variable
7203 –89 Database server not running in multi-user mode
7301 –192 Update operation attempted on non-updatable query
7301 –813 FOR UPDATE has been incorrectly specified for a READ ONLY cursor.
7321 –149 Function or column reference to '%1' must also appear in a GROUP BY
7337 101 Value truncated
7338 –728 Update operation attempted on non-updatable remote query
7364 –139 More than one table is identified as '%1'
7374 –676 The specified transaction isolation is invalid
7705 –630 Invalid escape sequence '%1'
7706 –606 The pattern is too long
7707 –629 Invalid escape character '%1'
7732 –633 Update operation attempted on a read-only cursor
7740 –815 Cannot update column '%1' since it does not appear in the SELECT clause.
7950 –100 Database server not found
7950 –96 Database server already running
8201 –640 Invalid descriptor index
8205 –641 Error in assignment
8405 –210 User '%1' has the row in '%2' locked
9119 –78 Dynamic memory exhausted
9502 –638 Right truncation of string data
9526 –187 Illegal cursor operation attempt
9819 –268 Trigger '%1' not found
10356 –624 Expression has unsupported data type
11205 –698 The remote server does not support an auto-incrementing data type
11205 –732 Creating remote tables with computed columns is not supported
11205 –736 The data type of column '%1' is not supported
11206 –656 Unable to connect to server '%1': %2
11207 –667 Could not access column information for the table '%1'
11208 –722 The column '%1' does not exist in the remote table
11209 –721 The data type specified for column '%1' is not compatible with the actual data type
11210 –723 The length specified for column '%1' is different than the actual length
11211 –724 Null attribute mismatch for column '%1'
11212 –725 Identity attribute mismatch for column '%1'
11214 –659 Remote server '%1' could not be found; Add the server using CREATE SERVER
11214 –666 The remote table '%1' could not be found
11215 –726 The table specification '%1' identifies more than one remote table
11221 –712 External login for server '%1' could not be found
11227 –706 Remote server does not have the ability to support this statement
11248 –658 Remote server '%1' is currently configured as read only
12006 –110 Item '%1' already exists
13075 102 Using temporary table
13204 –150 Invalid use of an aggregate function
13512 –977 UltraLite runtime library is incompatible with the database file
13513 –976 Could not load the encryption dll "%1"
13514 135 Compressed database is not encrypted
13515 –973 The string is too long (%1)
13516 –972 Database page size too small
13517 –971 Checksums are not enabled in this database
13518 134 UltraLite cursor (or result set or table) was restored
13519 133 UltraLite connection was restored
13520 –970 Invalid hint specified for table '%1'
13521 –969 Required operators excluded
13522 –968 User '%1' already has EXECUTE permission
13523 –967 Backup file '%1' already exists
13524 –966 Composite ORDER BY not allowed with RANGE or CUME_DIST()
13525 –965 Window function requires ORDER BY
13526 –964 Window function used in predicate
13527 –962 Argument to GROUPING aggregate must be a grouping column in the GROUP BY clause
13528 –963 Password contains an illegal character
13528 –961 Input string is not base64-encoded
13529 –959 Compression error: %1
13530 –958 Password cannot be longer than %1 characters
13530 –960 Decompression error: %1
13531 –957 Invalid preceding or following size in OLAP function
13532 –956 Information for synchronization is incomplete or invalid, check '%1'
13533 –955 This connection already exists
13534 –954 The database '%1' was not found
13535 –953 A schema upgrade is not currently allowed
13536 –952 The status of the last synchronization upload is unknown
13537 –951 Cannot access schema file '%1'
13538 –950 Frame not allowed for window '%1'
13539 –949 ORDER BY not allowed in window '%1'
13540 –948 PARTITION BY not allowed in reference to window '%1'
13541 –947 Window '%1' not found
13542 –946 Result set not permitted in '%1'
13543 –945 Recursive column %1: conversion from '%2' to '%3' loses precision
13544 –944 Too many expressions in GROUP BY list for ROLLUP, CUBE, or GROUPING SETS operation.
13545 –943 No workload capture currently exists
13546 –942 A workload capture (%1) is already in progress
13547 –940 Invalid setting for HTTP header '%1'
13548 –941 jConnect does not support encryption
13548 –939 Invalid setting for HTTP option '%1'
13549 –938 Recursion is not allowed without the RECURSIVE keyword
13550 –937 Invalid reference to or operation on constraint '%1'
13551 –936 too many constraints in database
13552 –934 Unable to start specified database: Server must be upgraded to start database %1
13553 –935 Unable to start specified database: Log file error
13553 –932 Service type does not allow 'USING' attribute
13554 –931 Service definition requires a statement when authorization is off
13555 –930 (no message)
13556 –929 Constraint '%1' not found
13557 –928 Constant expressions may not appear in GROUP BY clause
13558 –927 Service statement definition is inconsistent with service type
13559 –926 Host variable reference in service definition must be named
13560 –925 Invalid service name '%1'
13561 –923 Too many recursive iterations
13562 –922 No column list for recursive query
13563 –921 Invalid recursive query
13564 –920 Service '%1' not found
13565 –919 Service '%1' already exists
13566 –918 A user name must be specified if AUTHORIZATION is OFF
13567 –924 Service '%1' in use
13568 –916 '%1' is an unrecognized service type
13569 –915 Service type required for CREATE SERVICE
13570 –914 Cycle in common table expression references
13571 –913 A transaction log file is required for auditing
13572 –912 Insufficient memory for OPENXML query
13573 –911 Control character in XML output
13574 –910 System command failed with return code %1
13575 –908 Invalid operation on a closed '%1'
13576 –907 No name for argument
13577 –906 XMLGEN evaluation failure
13578 –905 Invalid XQuery constructor
13579 –904 Illegal ORDER BY in aggregate function
13580 –901 Undeclared tag id: '%1'
13580 –903 CDATA has a name
13581 –900 Parent not open: '%1'
13581 –902 Too few columns
13582 –899 Illegal column name: '%1'
13583 –898 Unknown FOR XML EXPLICIT directive: '%1'
13584 –897 Illegal FOR XML EXPLICIT tag value: '%1'
13585 132 Cannot output the histogram for string column '%1'
13587 –896 Cannot delete PUBLIC option '%1' since user settings exist
13588 130 A row could not be converted to the new schema format
13589 –895 Encryption error: %1
13589 –894 Plan can not be generated for this type of statement
13590 –893 Illegal flags value passed to OPENXML
13591 –892 XPath parser error: %1
13592 –891 Cannot convert between requested character sets '%1' and '%2'
13593 –657 Unable to connect to server '%1': server definition is circular
13594 –889 Statement contains an illegal usage of the non-deterministic function '%1'
13595 –888 XML parser error: %1
13596 129 Plan may contain virtual indexes.
13597 –887 Virtual index creation with more than %1 columns.
13600 0 (no message)
13601 –690 Return value cannot be set
13602 –693 JDBC feature '%1' not supported
13603 –694 Could not change an opened prepared statement or callable statement
13604 –695 An internal error occurred in a '%1'
13605 –696 Invalid operation on a closed '%1'
13606 –699 Cannot update member fields qualified with "final" modifier
13607 –701 Cannot access instance member through a class
13608 –713 An internal error occurred in a '%1'
13609 –714 Invalid operation on a closed '%1'
13613 114 Character set translation to '%1' cannot be performed; '%2' is used instead
13614 115 Database server cannot convert data from/to character set '%1', conversion may not be correct
13615 116 Language '%1' is not supported, '%2' will be used
13616 117 Unsupported character set '%1' and unsupported language '%2'; language used is '%3' instead
13617 118 Illegal user selectivity estimate specified
13618 105 Procedure has completed
13619 200 Warning
13620 –98 Authentication violation
13621 –218 Authentication failed
13622 –101 Not connected to a database
13623 –125 ALTER clause conflict
13624 –610 User message %1 already exists
13625 –120 User '%1' already has GRANT permission
13626 –123 User '%1' is not a user group
13627 –312 User '%1' already has membership in group '%2'
13628 –130 Invalid statement
13629 –132 SQL statement error
13630 –133 Invalid prepared statement type
13631 –707 Statement is not allowed in passthrough mode
13632 –614 Cannot drop a user that owns messages or data types
13633 –731 Cannot drop a user that owns objects involved in replication
13634 –161 Invalid type on DESCRIBE statement
13635 –181 No indicator variable provided for NULL result
13636 –182 Not enough fields allocated in SQLDA
13637 –185 SELECT returns more than one row
13638 –188 Not enough values for host variables
13639 –266 %1
13640 –267 COMMIT/ROLLBACK not allowed within atomic operation
13641 –270 Cannot drop a user that owns procedures in runtime server
13642 –280 Publication '%1' not found
13643 –281 Table '%1' has publications
13644 –282 Subscription to '%1' for '%2' already exists
13645 –283 Subscription to '%1' for '%2' not found
13646 –284 User '%1' is already the publisher for this database
13647 –285 User '%1' is not a remote user for this database
13648 –286 Remote message type '%1' not found
13649 –287 Passthrough statement inconsistent with current passthrough
13650 –288 Remote statement failed
13652 –211 Not allowed while '%1' is using the database
13653 –212 CHECKPOINT statement requires a rollback log
13654 –221 ROLLBACK TO SAVEPOINT not allowed
13655 –222 Result set not allowed from within an atomic compound statement
13656 –213 Savepoints require a rollback log
13657 –230 Sqlpp/dblib version mismatch
13658 –231 Client/database server version mismatch
13660 –243 Unable to delete database file
13661 –244 Transaction log was truncated
13662 –297 User-defined exception signaled
13663 –298 Attempted two active database requests
13664 –300 Run time SQL error -- %1
13665 –301 Internal database error %1 -- transaction rolled back
13666 –310 Attempt to read beyond end-of-file in a compressed database
13669 –601 '%1' is not a known file format for loading or unloading tables
13670 –602 Cannot access file '%1' -- %2
13672 –643 UNLOAD TABLE cannot be used to unload a view
13673 –607 Cannot stop the database server
13674 –617 Calling functions outside the database server is not supported
13675 –618 Mismatch between external function platform specifier and current operating system
13676 –619 Need a dynamic library name
13677 –620 Could not load dynamic library '%1'
13678 –621 Could not find '%1' in dynamic library '%2'
13679 –622 Could not allocate resources to call external function
13680 –625 Too many parameters to this external procedure call
13681 –626 A thread used internally could not be started
13682 –634 Unterminated C string
13683 110 Transaction log backup page only partially full
13685 –202 Only PUBLIC settings are allowed for option '%1'
13686 112 More information required
13687 –203 Cannot set a temporary option for user '%1'
13688 113 Database option '%1' for user '%2' has an invalid setting
13689 –205 Integrated logins are not permitted
13690 –206 Integrated logins are required, standard logins are not permitted
13691 –245 Integrated login failed
13692 –503 (no message)
13693 –504 (no message)
13694 –246 Integrated logins are not supported for this database
13695 –247 The integrated login ID guest can only be mapped to the guest database user ID
13696 –248 Cannot map a login ID to the sys or public user ID
13697 –249 The login ID '%1' is already mapped to user ID '%2'
13698 –313 The login ID '%1' has not been mapped to any database user ID
13699 –646 Could not load the store DLL "%1"
13700 –647 Could not execute store DLL (%1) entry point.
13701 –711 Incorrect store DLL (%1) version.
13702 –648 Cannot create item (%1) in the specified dbspace.
13703 –93 Class '%1' has no public field '%2'
13704 –650 Index type specification of '%1' is invalid
13705 –651 An attempt to delete database '%1' failed
13706 –654 The connection parameters file could not be found
13707 –655 Error parsing connection parameter string
13708 –664 Database is active
13709 –665 Database "%1" needs recovery
13710 –668 Cursor is restricted to FETCH NEXT operations
13711 –669 Method '%1' cannot be called at this time
13712 –671 Parameter not registered as output parameter
13713 –674 statement's size limit is invalid.
13714 –683 The cursor name '%1' already exists
13715 –685 Resource governor for '%1' exceeded
13717 –689 Input parameter index out of range
13718 –691 Could not load the backup/restore DLL "%1"
13719 –692 Could not execute backup/restore DLL (%1) entry point.
13720 –697 Error during backup: %1
13721 –700 SQLDA fields inconsistent for a multi-row SQLDA
13722 –709 Computed columns are not supported in this database
13723 –761 Server capability name '%1' could not be found in the SYS.SYSCAPABILITYNAME table.
13724 –715 Contents of backup files are inconsistent
13725 –716 Backup file format is invalid
13726 –717 RESTORE unable to open file '%1'
13727 –718 RESTORE unable to write to file '%1'
13728 –719 RESTORE unable to start database '%1'
13729 –720 VALIDATE TABLE statement must refer to a base table
13730 –727 The optimizer was unable to construct a valid access plan
13731 –128 Cannot drop a user that owns tables in runtime system
13732 –660 Server '%1': %2
13733 –661 Backwards scrolling cursors are not supported for remote objects
13734 –682 %1
13735 –91 Procedure '%1' terminated with unhandled exception '%2'
13736 –92 '%1' is not a valid class file
13737 –730 Invalid jar file
13738 –94 Invalid type for field reference
13739 –164 Namespace heap exhausted at internal function: %1
13740 –165 Java VM heap exhausted at internal function: %1
13741 –649 Field '%1' of class '%2' cannot be null
13742 –652 Could not decompress class '%1' from Jar.
13743 –653 Cannot remove class '%1': member of Jar
13744 –662 Cannot serialize Java object with class '%1'
13745 –663 Cannot deserialize Java object
13746 –670 Invalid class byte code
13747 –675 Java virtual machine could not be started
13748 –704 Cannot create an index on Java class '%1'
13749 –710 Invalid comparison
13750 –734 Cannot update or delete an all-NULL row from table '%1'
13751 120 '%1' is an unknown option
13752 –739 db_init has not been called or the call to db_init failed
13753 –740 The communications environment could not be created
13754 –741 '%1' is not a write file for '%2'
13755 –742 JDBC SAStatement batch execute abandoned
13756 –743 Seek absolute 0 was attempted on a JDBC SAResultSet
13757 –744 Invalid IQ database command line option or parameter value: %1
13758 –745 Cannot initialize IQ memory manager: %1
13759 –746 Cannot allocate System V resources
13760 –747 Invalid JDBC resultset type
13761 –748 Invalid JDBC resultset concurrency
13762 –749 Feature not available with UltraLite
13763 –752 Cannot call the '%1' function on a JDBC resultset when it is positioned on an insert row
13764 –753 The JDBC resultset must be positioned on an insert row in order to use the '%1' function
13765 –755 You cannot synchronize or upgrade with uncommitted transactions
13766 –756 Cannot uniquely identify column '%2' of table '%1' in the current JDBC resultset
13767 –289 Multiple consolidated users cannot be defined
13768 –757 Modifications not permitted for read-only database
13769 –758 The database does not support the Java virtual machine
13770 –759 SQLDA data type invalid
13771 –760 Invalid SQL identifier
13772 –762 '%1' is not a public Java class, and cannot be referenced from SQL
13773 –763 '%1' is not a public Java reference, and cannot be referenced from SQL
13774 –764 Server not found and unable to autostart
13775 –765 Synchronization message type '%1' not found
13776 119 Unable to open backup log '%1'
13777 –767 Cannot find synchronization subscription with the name '%1'
13778 –768 Cannot subscribe to '%1'
13779 –769 Cannot modify synchronization entry using ALTER PUBLICATION
13780 –770 Cannot modify publication entry using ALTER SYNCHRONIZATION
13781 –771 Event '%1' not found
13782 –772 Event '%1' already exists
13783 –773 Schedule '%1' for event '%2' not found
13784 –774 Schedule '%1' for event '%2' already exists
13787 –777 Cannot synchronize table '%1' since it does not have a primary key
13788 –778 Must include primary key for table '%1' in the synchronization
13789 –779 Cannot create synchronization entry for table '%1' with BLOB primary key
13790 –780 Cannot update primary key for table '%1' involved in a publication
13792 –782 Cannot register '%1' since another exclusive instance is running
13793 –783 Cannot register another '%1' as an exclusive application
13794 –784 Cannot register connection because of invalid application cookie
13795 –785 Cannot deregister application because of invalid cookie
13796 –786 Cannot deregister '%1' since active registered connection exists
13797 –787 Current connection is already registered to '%1' as '%2'
13798 –788 Another connection has already registered as '%1'
13799 –789 Cannot register '%1' since registration cookie exhausted
13800 –790 Cannot register connection to '%1' since automatic label exhausted
13801 –791 Invalid day of week or month '%1' for event '%2'
13802 –792 Invalid time '%1' for event '%2'
13803 –793 Invalid start date/time for event '%1'
13804 –794 Synchronization server failed to commit the upload
13805 –795 Undefined synchronization template '%1'
13806 –796 Synchronization site '%1' is already defined
13807 –797 Synchronization option '%1' contains semi-colon, equal sign or curly brace
13809 –799 DTC transactions are not supported on this platform
13810 –800 Cannot commit or rollback while enlisted in a transaction
13811 –801 Cannot enlist in a transaction while already enlisted in a transaction
13812 –802 Cannot enlist in a transaction with uncommitted data pending
13813 –803 Unable to enlist transaction; DTC may be down
13814 –804 Unable to reenlist transaction; DTC may be down
13815 –805 Synchronization option '%1' not found
13816 –806 System event type '%1' not found
13817 –807 Host variables may not be used within a batch
13818 –808 An internal error was generated by the test harness
13819 –809 Synchronization option is too long
13820 –810 Java class '%1' not found
13821 –811 Jar '%1' not found
13822 –812 The Select list for the derived table '%1' has no expression to match '%2'
13823 –817 too many temporary tables in connection
13824 –818 The external function call is incompatible
13825 –819 Table '%1' is part of a synchronization definition
13826 –820 Invalid scroll position '%1'
13827 –821 Dbspace for table '%1' not found
13828 –822 Table '%1' is already included
13829 –823 OMNI cannot handle expressions involving remote tables inside stored procedures
13830 –824 Illegal reference to correlation name '%1'
13831 –825 Previous error lost prior to RESIGNAL
13832 –826 Database upgrade not possible; RowGenerator table not owned by user dbo
13833 –827 Database upgrade not possible; user tables have table ids in system table range
13834 –828 A conflict with the DBMLSync download phase was detected
13835 –829 Certicom handshake failure
13836 –830 Alias '%1' is not unique
13837 –831 Definition for alias '%1' must appear before its first reference
13838 –832 Connection error: %1
13839 –833 Row in table '%1' was modified or deleted in BEFORE trigger
13840 –834 Column '%1' not found in table '%2'
13841 –835 Event '%1' in use
13842 –836 Procedure '%1' is no longer valid
13843 –837 Trigger or foreign key for table '%1' is no longer valid
13844 –838 Certicom initialization on server failed
13845 –839 Download failed because of conflicts with existing rows.
13847 –841 The JDK version in '%1' does not match '%2'
13848 –842 JDK '%1' is not a supported JDK
13849 –843 Cannot find synchronization user with the name '%1'
13850 –844 Cannot find synchronization definition with the name '%1'
13851 –845 Owner '%1' used in a qualified column reference does not match correlation name '%2'
13852 –846 Set clause for column '%1' used incorrectly
13853 –847 Java SecurityManager class not found: %1
13854 –848 Exception occurred while loading Java SecurityManager
13855 –851 Decryption error: %1
13856 –852 Table name '%1' is ambiguous
13857 121 Cursor option values changed
13858 –855 Trigger name '%1' is ambiguous
13859 –856 Invalid sqllen field in SQLDA
13860 –857 Synchronization failed due to an error on the server: %1
13861 –858 CREATE/DROP STATISTICS statement cannot refer to virtual tables
13863 –859 %1
13864 –860 At least one of the specified dbspaces was not calibrated.
13865 –861 Aggregated expression '%1' contains multiple columns of which one or more are outer references
13866 –862 The aggregate expression '%1' must appear in either the select list or a HAVING clause subquery
13867 –863 Grouped query contains more than one distinct aggregate function
13868 –303 Disk write failure '%1' -- transaction rolled back
13869 –864 Statement contains an illegal usage of the NUMBER(*) function
13870 –866 %1 returned a result set with a different schema than expected
13871 –867 Cannot change synchronization user_name when status of the last upload is unknown.
13872 –868 '%1' is an unknown character set label
13873 –869 Database server cannot convert data from/to character set '%1'
13874 –870 Cannot convert between requested character set '%1' and database character set '%2'
13875 –871 The database needs to be restarted for this Java related command
13877 –873 %1 returned multiple result sets
13878 –686 Insufficient cache to start Java virtual machine
13879 –688 Strongly-encrypted database files are not supported in the runtime server
13880 –874 Column must be named: %1
13882 –876 Client out of memory
13883 122 The result returned is non-deterministic.
13884 123 Database created without any schema
13885 –184 Column '%1' in table '%2' cannot be NULL. The invalid data was supplied to load table in a data file on line %3.
13886 124 Invalid data conversion: NULL was inserted for column '%1' on row %2.
13887 –162 Cannot convert %1 to a %2. The bad value was supplied for column '%3' on row %4 of the data file.
13888 –877 SETUSER not allowed in procedures, triggers, events or batches
13889 –878 Index '%1' can not be clustered
13890 –879 An invalid multi-byte input character was encountered
13891 –880 An invalid multi-byte output character was encountered
13892 125 An invalid multi-byte input character was encountered
13893 126 An invalid multi-byte output character was encountered
13894 –881 An input character could not be converted to database character set
13895 –882 An output character could not be converted to the application character set
13896 127 An input character could not be converted to database character set and simple substitution took place
13897 128 An output character could not be converted to the application character set and simple substitution took place
13898 –883 Character conversion reporting is not available when the single byte converter is used
13959 –974 File I/O failed for '%1'
13960 –975 Incorrect volume ID for '%1'
16846 –840 Incorrect or missing encryption key
36007 –628 Division by zero

'plming > DB' 카테고리의 다른 글

Oracle - Table Schema 조회  (0) 2011.07.15
Oracle - Table Comment 조회  (0) 2011.07.15
Sybase - Error code별 메시지  (0) 2010.11.23
Sybase - Transact-SQL functions  (0) 2010.11.23
Sybase - Error 원인 & 처리방법  (0) 2010.11.22
Sybase - This exceeds the maximum allowable limit of  (0) 2010.11.22

Adaptive Server Enterprise 12.5 이므로,
15.5 와 약간 차이가 있을 수 있지만...
기본 Sybase의 function들은 거의 다 있다.

다른 버전의 Reference는 아래 링크를 타면, 좌측 메뉴에서 고를 수 있다.

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc36271_36272_36273_36274_1250/html/refman/CHDFCGIF.htm


Types of functions

Table 2-1 lists the different types of Transact-SQL functions and describes the type of information each returns.

Table 2-1: Types of Transact-SQL functions

Type of function

Description

Aggregate functions

Generate summary values that appear as new columns or as additional rows in the query results.

Datatype conversion functions

Change expressions from one datatype to another and specify new display formats for date/time information.

Date functions

Do computations on datetime and smalldatetime values and their components, date parts.

Mathematical functions

Return values commonly needed for operations on mathematical data.

Security functions

Return security-related information.

String functions

Operate on binary data, character strings, and expressions.

System functions

Return special information from the database.

Text and image functions

Supply values commonly needed for operations on text and image data.

Table 2-2 lists the functions in alphabetical order.

Table 2-2: List of Transact-SQL functions

Function

Type

Return value

abs

Mathematical

The absolute value of an expression.

acos

Mathematical

The angle (in radians) whose cosine is specified.

ascii

String

The ASCII code for the first character in an expression.

asin

Mathematical

The angle (in radians) whose sine is specified.

atan

Mathematical

The angle (in radians) whose tangent is specified.

atn2

Mathematical

The angle (in radians) whose sine and cosine are specified.

avg

Aggregate

The numeric average of all (distinct) values.

ceiling

Mathematical

The smallest integer greater than or equal to the specified value.

char

String

The character equivalent of an integer.

charindex

String

Returns an integer representing the starting position of an expression.

char_length

String

The number of characters in an expression.

col_length

System

The defined length of a column.

col_name

System

The name of the column whose table and column IDs are specified.

compare

System

Returns the following values, based on the collation rules that you chose:

  • 1 – indicates that char_expression1 is greater than char_expression2

  • 0 – indicates that char_expression1 is equal to char_expression2

  • -1 – indicates that char_expression1 is less than char_expression2

convert

Datatype Conversion

The specified value, converted to another datatype or a different datetime display format.

cos

Mathematical

The cosine of the specified angle (in radians).

cot

Mathematical

The cotangent of the specified angle (in radians).

count

Aggregate

The number of (distinct) non-null values.

curunreservedpgs

System

The number of free pages in the specified disk piece.

data_pgs

System

The number of pages used by the specified table or index.

datalength

System

The actual length, in bytes, of the specified column or string.

dateadd

Date

The date produced by adding a given number of years, quarters, hours, or other date parts to the specified date.

datediff

Date

The difference between two dates.

datename

Date

The name of the specified part of a datetime value.

datepart

Date

The integer value of the specified part of a datetime value.

db_id

System

The ID number of the specified database.

db_name

System

The name of the database whose ID number is specified.

degrees

Mathematical

The size, in degrees, of an angle with a specified number of radians.

difference

String

The difference between two soundex values.

exp

Mathematical

The value that results from raising the constant e to the specified power.

floor

Mathematical

The largest integer that is less than or equal to the specified value.

getdate

Date

The current system date and time.

hextoint

Datatype Conversion

The platform-independent integer equivalent of the specified hexadecimal string.

host_id

System

The host process ID of the client process.

host_name

System

The current host computer name of the client process.

index_col

System

The name of the indexed column in the specified table or view.

inttohex

Datatype Conversion

The platform-independent, hexadecimal equivalent of the specified integer.

isnull

System

Substitutes the value specified in expression2 when expression1 evaluates to NULL.

is_sec_service_on

Security

“1” if the security service is active; “0” if it is not.

isnull

String

The specified expression, trimmed of leading blanks.

lct_admin

System

Manages the last-chance threshold.

license_enabled

System

“1” if the feature’s license is enabled; “0” if it is not.

log

Mathematical

The natural logarithm of the specified number.

log10

Mathematical

The base 10 logarithm of the specified number.

lower

String

The uppercase equivalent of the specified expression.

max

Aggregate

The highest value in a column.

min

Aggregate

The lowest value in a column.

mut_excl_roles

System

The mutual exclusivity between two roles.

object_id

System

The object ID of the specified object.

object_name

System

The name of the object whose object ID is specified.

patindex

String, Text and Image

The starting position of the first occurrence of a specified pattern.

pi

Mathematical

The constant value 3.1415926535897936.

power

Mathematical

The value that results from raising the specified number to a given power.

proc_role

System

1 if the user has the correct role to execute the procedure; 0 if the user does not have this role.

ptn_data_pgs

System

The number of data pages used by a partition.

radians

Mathematical

The size, in radians, of an angle with a specified number of degrees.

rand

Mathematical

A random value between 0 and 1, generated using the specified seed value.

replicate

String

A string consisting of the specified expression repeated a given number of times.

reserved_pgs

System

The number of pages allocated to the specified table or index.

reverse

String

The specified string, with characters listed in reverse order.

right

String

The part of the character expression, starting the specified number of characters from the right.

role_contain

System

1 if role2 contains role1.

role_id

System

The system role ID of the role whose name you specify.

role_name

System

The name of a role whose system role ID you specify.

round

Mathematical

The value of the specified number, rounded to a given number of decimal places.

rowcnt

System

An estimate of the number of rows in the specified table.

rtrim

String

The specified expression, trimmed of trailing blanks.

show_role

System

The login’s currently active roles.

show_sec_services

Security

A list of the user’s currently active security services.

sign

Mathematical

The sign (+1 for positive, 0, or -1 for negative) of the specified value.

sin

Mathematical

The sine of the specified angle (in radians).

sortkey

System

Values that can be used to order results based on collation behavior, which allows you to work with character collation behaviors beyond the default set of Latin-character-based dictionary sort orders and case or accent sensitivity.

soundex

String

A 4-character code representing the way an expression sounds.

space

String

A string consisting of the specified number of single-byte spaces.

sqrt

Mathematical

The square root of the specified number.

str

String

The character equivalent of the specified number.

stuff

String

The string formed by deleting a specified number of characters from one string and replacing them with another string.

substring

String

The string formed by extracting a specified number of characters from another string.

sum

Aggregate

The total of the values.

suser_id

System

The server user’s ID number from the syslogins system table.

suser_name

System

The name of the current server user, or the user whose server user ID is specified.

syb_sendmsg

Sends a message to a User Datagram Protocol (UDP) port.

tan

Mathematical

The tangent of the specified angle (in radians).

textptr

Text and Image

The pointer to the first page of the specified text column.

textvalid

Text and Image

1 if the pointer to the specified text column is valid; 0 if it is not.

to_unichar

String

A unichar expression having the value of the integer expression.

tsequal

System

Compares timestamp values to prevent update on a row that has been modified since it was selected for browsing.

uhighsurr

String

1 if the Unicode value at position start is the high half of a surrogate pair (which should appear first in the pair); otherwise 0.

ulowsurr

String

1 if the Unicode value at position start is the low half of a surrogate pair (which should appear second in the pair); otherwise 0.

upper

String

The uppercase equivalent of the specified string.

uscalar

String

The Unicode scalar value for the first Unicode character in an expression.

used_pgs

System

The number of pages used by the specified table and its clustered index.

user

System

The name of the current server user.

user_id

System

The ID number of the specified user or the current user.

user_name

System

The name within the database of the specified user or the current user.

valid_name

System

0 if the specified string is not a valid identifier; a number other than 0 if the string is valid.

valid_user

System

1 if the specified ID is a valid user or alias in at least one database on this Adaptive Server.

The following sections describe the types of functions in detail. The remainder of the chapter contains descriptions of the individual functions in alphabetical order.


'plming > DB' 카테고리의 다른 글

Oracle - Table Comment 조회  (0) 2011.07.15
Sybase - Error code별 메시지  (0) 2010.11.23
Sybase - Transact-SQL functions  (0) 2010.11.23
Sybase - Error 원인 & 처리방법  (0) 2010.11.22
Sybase - This exceeds the maximum allowable limit of  (0) 2010.11.22
GetDate - Sybase, MS SQL  (0) 2010.10.13
SQL 실행 시 Error (번호)라고만 나오면, 원인이 무엇인지 알 수가 없다.

 Error (414)
 The current query would generate a key size of 648 for a work table.
 This exceeds the maximum allowable limit of 600.

뭔가 힌트성으로라도 어디에서 뭔가 잘못되서 나왔다고라도 표시를 좀 해주면...
엄~~청난 삽질의 굴레에서 벗어날 수 있을테지만...
워낙에 어디에서도 찾기가 쉽지 않다...

하지만, 나름의 페이지로 정리는 되어있다.

#1
http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0901/en/html/dberen9/00000011.htm

#2
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc00729_1500/html/errMessageAdvRes/X100552.htm

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_12.5.svrtsg/html/svrtsg/svrtsg192.htm

Error 뒤의 (번호)에 맞는 넘을 찾으면
뜬 구름속의 원인을 찾을 수 있을 듯 싶다...


Sybase를 사용하는 게 죄다...
오늘도 건투를 빌어본다...!!!

'plming > DB' 카테고리의 다른 글

Sybase - Error code별 메시지  (0) 2010.11.23
Sybase - Transact-SQL functions  (0) 2010.11.23
Sybase - Error 원인 & 처리방법  (0) 2010.11.22
Sybase - This exceeds the maximum allowable limit of  (0) 2010.11.22
GetDate - Sybase, MS SQL  (0) 2010.10.13
Sybase 15.0.1 vs Oracle 10.2  (0) 2010.10.13
Select SQL 실행 시 발생한다.

Error (414) The current query would generate a key size of 648 for a work table.  This exceeds the maximum allowable limit of 600.

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_12.5.svrtsg/html/svrtsg/svrtsg192.htm

 Error 414
 Severity
 16

 Message text
 The current query would generate a key size of %d for a work table.  This exceeds the maximum allowable limit of %d.

 Explanation
 When you execute a query, Adaptive Server may need to create work tables to temporarily store query results. For example, a work table is used when duplicate rows must be removed in processing a query with an aggregate function. A sysindexes row is built for the work table after checking that the specified command does not violate any limitations on keys for user tables.

 Error 414 is raised when you execute a query containing an aggregate function, and the total length of columns named in the group by clause of the query exceeds the maximum limit of 600 bytes.

 Action
 Check the command for possible violations of the 600 byte size limit. You can correct the problem by doing one of the following:
 - Reduce the columns named in the group by clause until the combined column length is no more than 600 bytes.
 - If it is necessary to group by a large character column, consider using the substring string function on the column in the group by clause. This allows Adaptive Server to build a composite key to group the result set using only a portion of the character string. For example:
   1> select * from titles
   2> group by title, substring(notes,1,10)

   This query uses only the first 10 bytes of notes (a 200 byte varchar column) to group the data.

 Versions in which this error is raised
 All versions



문제는 group by에 기술된 column의 갯수가 많아서 그렇다.
    → group을 처리하기 위한 Key를 저장하는 공간의 기본 byte수를 초과한 것이다.

group by에 기술된 column의 갯수를 줄이면 문제는 해결된다.

'plming > DB' 카테고리의 다른 글

Sybase - Transact-SQL functions  (0) 2010.11.23
Sybase - Error 원인 & 처리방법  (0) 2010.11.22
Sybase - This exceeds the maximum allowable limit of  (0) 2010.11.22
GetDate - Sybase, MS SQL  (0) 2010.10.13
Sybase 15.0.1 vs Oracle 10.2  (0) 2010.10.13
Sybase SQL등 명령어  (0) 2010.08.26

+ Recent posts