SQL Anywhere error messages sorted by Sybase error code

Sybase error code SQL Anywhere SQLCODE Message text
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 or rename 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 Permission denied: %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'
401 –994 Too many arguments for function or procedure '%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' on line %2
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'
548 –1091 Constraint '%1' violated: Invalid value in table '%2'
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 –1179 Unable to start database server: missing license file
709 –996 Specified local connection ID not found
710 –997 Local connection ID does not refer to the current database
711 –998 Cannot close a remote JDBC connection that is not the current connection
840 –82 Unable to start specified database: %1
840 –87 Database name required to start server
840 –1008 Unable to start specified database: '%1' is an invalid transaction log mirror
840 –1009 Unable to start specified database: The transaction log '%1' or its mirror '%2' is invalid
840 –1010 Unable to start specified database: '%1' not expecting any operations in transaction log
840 –1011 Unable to start specified database: Unknown encryption algorithm
840 –1012 Unable to start specified database: '%1' must be upgraded to start with this server (capability %2 missing)
840 –1016 Unable to start specified database: Cannot use log file '%1' since it has been used more recently than the database file
840 –1017 Unable to start specified database: '%1': transaction log file not found
840 –1018 Unable to start specified database: Cannot use log file '%1' since the offsets do not match the offsets in the database file
840 –1019 Unable to start specified database: Cannot use log file '%1' since the database file has been used more recently
840 –1020 Unable to start specified database: Cannot use log file '%1' since it is shorter than expected
840 –1004 Unable to start specified database: '%1' is not a database
840 –1005 Unable to start specified database: '%1' was created by a different version of the software
840 –1006 Unable to start specified database: '%1' is not a valid database file
840 –1007 Unable to start specified database: '%1' is an invalid transaction log
840 –1063 Unable to start database %1: Cannot use read-only mode if auditing is enabled
840 –1147 Database '%1' cannot be started on this platform. See http://ianywhere.com/developer/product_manuals/sqlanywhere/notes/en/endian_corruption_warning.html
840 –1149 Database '%1' cannot be started on this platform. See http://ianywhere.com/developer/product_manuals/sqlanywhere/notes/en/endian_cant_change_platform.html
911 –83 Specified database not found
924 –816 Specified database file already in use
927 –97 Database page size too big: %1
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 and not created with ON COMMIT DELETE ROWS. For global temporary tables they must both be shared if one is shared
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 : Primary key value ('%2')
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 must 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
3206 –1021 Invalid backup operation
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 –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 be used on 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 near '%1' on line %2
5849 –201 Invalid setting for option '%1'
5849 –1053 '%1' is an invalid value for '%2'
5864 –81 Invalid database server command line
5864 –735 Invalid parameter
5864 –79 Invalid local database option
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
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
13241 –1315 Script file missing statement \"go\" delimiter on a separate line
13243 –1267 Event parameter '%1' not found
13244 –1266 No notification within timeout on queue '%1'
13245 –1265 Event object named '%1' already exists
13246 –1264 Event object name '%1' is not valid
13247 –1263 Event notification queue '%1' not found
13248 148 Event notification queue '%1' not found warning
13249 147 Event notifications lost on queue '%1'
13250 –1269 Service statement definition is invalid or unsupported
13251 –1262 This edition of SQL Anywhere is not available on this platform
13252 –1261 This server is not licensed to support '%1' connections
13253 –1260 This server is not licensed to support the '%1' feature
13254 145 Two rows with the same primary key have been download for table '%1'
13259 –1254 MERGE statement for table '%1' failed because of a RAISERROR specification in the statement
13260 –1253 The text index %1 needs to be refreshed
13261 –1151 The logging type ( '%1' ) specified is invalid, not supported or incompatible
13266 –1313 Maximum string length exceeded
13270 –1244 An attempt to decrypt database '%1' failed
13271 –1243 An attempt to encrypt database '%1' failed
13273 –1241 Value-sensitive cursor used after a TRUNCATE
13274 144 Mirror file requires higher checksum_level
13275 143 Retrying read of corrupt page (page '%1')
13276 142 UltraLite database state was restored
13277 –1240 The provided stoplist is too long
13280 –1238 Passthrough SQL script failed
13281 –1237 Too many columns in procedure result set
13282 –1236 Too many expressions in GROUP BY list
13283 –1235 Too many columns in SELECT list
13284 –1233 The materialized view %1 cannot be changed to immediate because it does not have a unique index on non-nullable columns
13285 –1232 Attempt to start a second snapshot in a transaction
13286 –1231 Statement timed out: '%1'
13287 –1230 Too many open cursors
13288 –1229 Reorganize table is already being run on table \"%1\
13289 141 Passthrough SQL script failed
13291 –1226 Foreign key columns do not match the primary key or a uniqueness constraint in \"%1\
13292 –1225 Synchronization profiles are not supported for this database
13293 –1224 Synchronization profile '%1' has invalid parameter '%2'
13294 –1223 Synchronization profile '%1' already exists
13296 –1221 Duplicate options not allowed in the CREATE DATABASE statement
13297 –1216 The arguments to this procedure must be literal strings
13298 –1219 Maintenance of dependent immediate materialized view(s) failed
13299 –1218 The materialized view cannot be changed to immediate because it does not have a unique index on non-aggregate non-nullable columns
13300 –1220 User cannot be dropped because external logins exist for this user
13301 –1213 External environment does not support result sets
13302 –1217 Synchronization profile '%1' not found
13303 –1212 Connection disallowed by login policy for this user
13304 –1211 MERGE statement ANSI cardinality violation on table '%1'
13308 –1207 Invalid use of NEAR operator in text query
13309 –1206 External environments are not supported for this database
13310 –1205 External environment '%1' could not be found
13311 –1204 INSERT ... ON EXISTING UPDATE not allowed: immediate materialized view %1 depends on %2
13312 –1203 WRITETEXT not allowed: immediate materialized view %1 depends on %2
13313 –1202 Operation not allowed on a table with dependent immediate materialized views
13314 –1201 Client library reported an error opening object ('%1') during transfer
13315 –1200 Client library reported a permissions error accessing object ('%1') during transfer
13316 –1199 The materialized view cannot be changed to immediate because COUNT(*) is required to be part of the SELECT list
13317 –1198 User \"%1\" already exists
13318 –1197 Login policy \"%1\" in use
13319 –1196 Login policies are not supported for this database
13320 –1195 Login policy \"%1\" not found
13321 –1194 Login policy \"%1\" already exists
13322 –1193 TRUNCATE TABLE not allowed: initialized immediate materialized view %1 depends on %2
13323 –1192 Cannot update multiple tables immediate materialized view %1 depends on
13324 –1191 LOAD TABLE not allowed: initialized immediate materialized view %1 depends on %2
13325 –1190 LOAD TABLE is not allowed on a materialized view %1
13326 –1189 The UTF-16 endian specified does not match the Byte Order Mark found in the data
13327 –1188 LOAD TABLE error: %1
13328 –1187 Cannot append when using compression or encryption
13329 –1186 Database page validation failed with code: %1
13330 –1185 Index validation failed for table %1, index %2 with code: %3
13331 –1184 Cannot drop last unique index of an immediate materialized view
13332 –1183 Support for permissions on dbspaces is not available for this database
13333 –1182 Command not allowed on IMMEDIATE REFRESH text index
13334 –1181 The materialized view cannot be changed to immediate because its definition must not contain more than one query block
13335 –1180 Cannot set database option \"%1\" because it is on the options watch list
13336 –1178 Transaction log mirroring cannot be used with database mirroring
13337 –1176 Plan not available. NOEXEC Plan can not be generated for this type of statement
13338 –1175 Unable to acquire table locks in specified time
13339 –1174 Cannot create text configuration '%1' because option '%2' has an inappropriate setting
13340 –1173 Client library reported an error accessing data during transfer ('%1')
13341 –1172 Client application disallowed the transfer of data ('%1')
13342 –1171 Client application does not allow transfer of data ('%1')
13343 –1170 The materialized view %1 cannot be changed to immediate because it has already been initialized
13344 –1169 Cannot access a table that is part of a text index
13345 –1168 Cannot alter or drop a text configuration referenced by a text index
13346 –1167 Cannot drop a user that owns text configurations
13347 –1166 Text indexes are not supported for this database
13348 –1165 Error creating text index \"%1\" on table \"%2\
13349 –1164 Text query parser error: %1
13350 –1163 Invalid collation: \"%1\"
13351 –1162 Term length outside allowed range
13352 –1161 Text configuration \"%1\" already exists
13353 –1160 Text configuration \"%1\".\"%2\" not found
13354 –1159 Non-constant or unknown text query string
13355 –1158 No matching text index
13356 –1157 All column reference arguments must refer to the same table
13357 –1156 Argument \"%1\" must be a column reference
13358 –1155 Unable to close the cursor on table \"%1\". LOAD TABLE cannot be executed
13359 –1154 Traced query (%1, %2) does not exist
13360 –1153 Password has expired but cannot be changed because the database is read-only
13361 –1152 Password has expired
13362 –1150 The SQL scripts DLL cannot be loaded
13363 –1148 Feature not supported by the client version or the client interface
13366 –1146 LOAD TABLE not allowed on temporary table which has foreign key references from another table
13367 –1145 Unable to connect: The server did not accept the requested encryption type
13368 –1144 '%1' cannot be used as the encoding specification for '%2' data
13369 140 Encryption has not been enabled
13370 –1143 Encryption has not been enabled
13371 –1142 Use of statement '%1', which requires feature '%2', is not allowed
13372 –1141 Unable to start database \"%1\": NCHAR collation or tailoring not supported on this platform
13373 –1140 Unable to start database \"%1\": CHAR collation or tailoring not supported on this platform
13374 –1139 The Remote Data Services feature is not supported on this platform
13375 –1138 The mirror '%1' does not match database '%2'
13376 –1137 Escape character conflict '%1'
13377 –1136 Invalid use of escape character '%1'
13378 –1135 Invalid regular expression: %1 in '%2'
13379 –1134 Triggers cannot be created on materialized view '%1'
13380 –1133 Invalid trigger type for view '%1'
13381 –1132 Maximum row size for table '%1' would be exceeded
13382 –1131 The attribute '%1' sets an option '%2' that is incompatible with '%3'
13383 –1130 The '%1' attribute is missing a comma within '%2'
13384 –1129 The '%1' attribute contains mismatched parentheses within '%2'
13385 –1128 Start date/time for non-recurring event '%1' is in the past
13386 –1127 Positioned update operation attempted on a view with an INSTEAD OF trigger
13387 –1126 Operation failed because table or view '%1' has an INSTEAD OF trigger
13388 –1125 Conflicting INSTEAD OF trigger and WITH CHECK OPTION on view '%1'
13389 –1124 The dbicu library and server versions do not match
13390 –1123 Invalid mime type '%1'
13391 –1122 Exceeded maximum of '%1' allowable parameters
13392 –1121 Not enough free space on device to grow dbspace '%1' by requested amount
13393 –1120 The dbspace '%1' cannot be dropped because it contains tables or indexes
13394 –1119 The '%1' property is no longer supported
13395 –1118 Cannot change the MobiLink remote id when the status of the last upload is unknown
13396 –1117 A row cannot be stored because it exceeds the database page size
13397 201 The ICU collation '%1' has defaulted to another collation
13398 –1116 Collation '%1' not supported on this platform
13399 –1115 Table '%1' contains an invalid reference to the ROWID function
13400 –1114 Invalid setting for SOAP header '%1'
13401 –1113 Correlation name '%1' is not valid for use with the ROWID function
13402 –1112 Specified file system volume not found for database '%1'
13403 –1111 Information for synchronization was not provided
13404 –1110 Synchronization process was unable to re-enter synchronization
13405 –1109 Unable to perform requested operation since this database uses keyless encryption
13406 –1108 Unable to access the filesystem on the device
13407 –1107 Too many references to a BLOB
13408 –1106 Too many publications specified for operation
13410 –1104 Too many users in database
13411 –1103 No partial download was found
13412 –1102 Unable to retry download because upload is not finished
13413 –1101 Column '%1' not part of any indexes in its containing table
13414 –1100 The operation failed because column '%1''s type does not support streaming
13415 139 Option '%1' specified more than once
13416 –1099 Transact-SQL outer joins are currently disabled
13417 –1098 A tracing connection is already active
13418 –1097 ATTACH TRACING could not connect to the tracing database
13419 –1096 The specified http header is malformed
13420 –1095 The specified http header contains illegal or non-ASCII characters
13421 –1094 The http header '%1' is reserved and cannot be modified
13422 –1093 The size of the character column, variable, or value data type exceeds 32767
13423 138 Publication predicates were not evaluated
13424 –1090 Function '%1' has invalid parameter '%2' ('%3')
13425 –1089 Invalid commit action for shared temporary table
13426 –1088 ATTACH TRACING TO LOCAL DATABASE cannot be used with a strongly encrypted database
13427 –1087 Could not refresh tracing: volatile_statistics have to be collected in order for %1 specified on row %2 to be collected
13428 –1086 Write access was denied
13429 –1085 Duplicate key column (%1)
13430 –1084 Use of feature '%1' is not allowed
13431 –1083 Could not refresh tracing: failed to find object %1 on row %2
13432 –1082 Could not refresh tracing: invalid tracing specification on sa_diagnostic_tracing_level row %1
13433 –1081 Could not refresh tracing: at least one enabled tracing level must be specified
13434 –1080 Cannot revoke these permissions while user '%1' is actively replicating transactions
13435 –1079 Backup is unable to open database file '%1'
13436 –1078 Cycle in computed column dependencies
13437 –1077 Cannot use materialized view '%1' because it has not yet been initialized
13438 –1076 dbicu libraries are required but not installed
13439 –1075 Failed to convert from character set '%1' to '%2'
13440 –1074 Login mode '%1' not permitted by login_mode setting
13441 –1072 '%1' is not a valid character set encoding for use with collation '%2'
13442 –1092 The method you attempted to invoke was not enabled for your application
13442 –1071 The %1 algorithm is not available in FIPS mode
13442 –1073 '%1' cannot be used as the NCHAR collation: only UCA and UTF8BIN may be used
13444 –1070 Kerberos logins are not supported
13445 –1069 Kerberos login failed
13446 –1068 Default dbspace '%1' not found
13448 –1066 File system error: %1
13449 –1065 Attempt to use snapshot isolation in a non-snapshot transaction
13450 –1064 Update conflict on snapshot transaction
13451 –1062 Statement not allowed during snapshot
13452 –1061 Table created or altered after start of snapshot
13453 –1060 Operation conflict with publication type
13454 –1305 MobiLink communication error; code: %1, parameter: %2, system code %3
13455 –1304 Could not create a new text for this table with the same settings as \"%1\
13456 –1057 BACKUP clause '%1' conflicts with '%2'
13457 –1303 Too many MESSAGE ... FOR CONNECTION messages
13459 –1054 Snapshot isolation disabled or pending
13460 –1051 Cannot create a materialized view because option '%1' has an inappropriate setting
13461 –1050 Cannot return NULL result as requested data type
13461 –1052 Cannot update materialized view because option '%1' has an inappropriate setting
13464 –1047 This database does not support encrypted tables
13465 –1046 Illegal column definition: %1
13466 –1045 Invalid backup parameter value
13467 –1044 Invalid password: %1
13468 –1043 Request interrupted due to timeout
13469 –1042 Cannot add a comment to a table declared as LOCAL TEMPORARY
13470 –1041 Materialized View '%1' not found
13471 –1040 Cannot use view '%1' because it is invalid
13472 –1039 Cannot connect to mirror server. Use server name '%1' to find the primary server
13473 –1038 Cannot use view '%1' because it has been disabled
13474 –1037 Cannot drop or modify object '%1' because at least one other object ( %2 '%3') depends upon it
13475 –1036 The DBN/DBF parameters do not match the database for this alternate server name
13476 –1035 LOAD TABLE not permitted on mirrored database
13477 –1034 The '%1' attribute is not valid with procedure type '%2'
13478 –1033 Unable to start database server: Server fatal error
13479 –1031 Syntax error near '%1' -- Materialized view definition must not use the following construct: '%2'
13480 –1032 Syntax error near '%1' -- The materialized view cannot be changed to immediate because its definition contains an illegal construct: '%2'
13480 –1030 Secure HTTP connections are not supported on this platform
13481 –1029 Support for materialized views is not available for this database
13482 –1028 Connection attempting BACKUP has uncommitted transactions
13483 –1027 Service type does not allow '%1' attribute
13484 –1026 USING attribute cannot coexist with FORMAT or GROUP attributes
13485 –1025 Duplicate attribute '%1' in service
13486 –1024 Unsupported property '%1' in service USING attribute
13487 –1023 Missing value for attribute '%1' in service
13488 –1022 Invalid value for attribute '%1' in service
13489 137 Row was dropped from table %1 to maintain referential integrity
13490 –1003 Too many distinct group mappings for integrated user
13491 –1001 Parameter '%1' in procedure or function '%2' does not have a default value
13492 –1000 Temporary space limit exceeded
13493 –999 Invalid request log format on line %1
13494 136 The database was created
13494 –1002 The option '%1' is not recognized
13495 –995 Warning detected when optimizing SELECT INTO is treated as an error
13496 –993 LOAD TABLE not allowed on temporary table with ON COMMIT DELETE ROWS
13497 –992 The specified listener could not be registered
13498 –991 Clause '%1' has invalid attribute '%2'
13499 –990 The secure connection to the remote host failed: %1
13500 –989 NAMESPACE attribute is not valid with procedure type '%1'
13501 –988 Invalid response from the HTTP server
13502 –987 Invalid procedure subtype '%1' for type '%2'
13503 –986 Invalid procedure type '%1'
13504 –985 The database name 'utility_db' is reserved for the utility database
13505 –984 Could not initialize the encryption DLL: '%1'
13506 –983 HTTP request failed. Status code '%1'
13507 –982 Connection timed out
13508 –981 Unable to connect to the remote host specified by '%1'
13509 –980 The URI '%1' is invalid
13510 –979 Output file cannot be written
13511 –978 Directory for output file does not exist
13513 –976 Could not load the encryption DLL \"%1\
13515 –973 The string is too long (%1)
13516 –972 Database page size too small: %1
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
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
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 must 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 object
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 was dropped because it 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, 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 conversion 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: %1
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
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 –1288 '%1' statement is not allowed on a mirrored database
13668 –1286 Immediate materialized view definition cannot contain a SUM function over a nullable expression
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
13684 149 Automatic database upgrade applied
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
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 database 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/restore: %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 database
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 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 Backward 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 External environment could not be started, '%1' could not be found
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 –1270 Must own table '%1' in order to make an immediate view reference it
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
13785 146 Event notification queue '%1' is full, notification discarded
13786 –1268 The materialized view cannot be changed to immediate because its definition contains an illegal construct
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
13791 –1283 A CONTAINS query is not allowed on the view or derived table '%1'
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 –1281 Another connection has the row in '%1' locked
13806 –1280 Underflow when converting '%1'
13807 –797 Synchronization option '%1' contains semi-colon, equal sign, curly brace, or is null
13808 –1279 Operation '%1' failed for reason: '%2'
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 must 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 External object '%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 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 TLS 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 TLS initialization on server failed
13845 –839 Download failed because of conflicts with existing rows
13846 –1278 Operation is not allowed
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
13862 –1277 Parameter '%1' cannot be null
13863 –1276 Configuration cannot not be modified while in use
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 encoding 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
13876 –872 %1 does not return a result set
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
13881 –1275 Invalid domain '%1'
13882 –876 Client out of memory
13883 122 The result returned is non-deterministic
13884 –1274 Index '%1' has no columns
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 when converting from %1 to %2
13891 –1273 Table '%1' has no columns
13892 125 An invalid multi-byte input character was encountered when converting from %1 to %2
13893 –1272 Synchronization is already in progress
13894 –881 Character substitution was required when converting from %1 to %2
13895 –1215 External library '%1' not loaded
13896 127 Character substitution occurred when converting from %1 to %2
13897 –1214 External library '%1' is in use
13898 –883 Character conversion error or warning report is not available when the single-byte converter is used
13899 –1271 Synchronization download failed to complete
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
1333336 –1177 No plan. HTML_PLAN function is not supported for this type of statement or database
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1