Messages 1209 through 1228

Messages on this page are sorted by SQLCODE. Locate the appropriate code in the table below, and click the link for a full description of the message.

SQL Code Msg Type Number SQL State Message Possible Cause
-1209L Error 2886 WW106 "Cannot convert value '%1' to an %2" The value is not compatible with the type of the partition key.

Click here for a list of possible parameters and odbc states.

-1210L Error 2887 WW107 "Partition bound value '%1' out of order" Range partition bound values must be provided in ascending order.

Click here for a list of possible parameters and odbc states.

-1211L Error 2888 23509 "MERGE statement ANSI cardinality violation on table '%1'" You have attempted to execute the MERGE statement and the same row is the target of a WHEN MATCHED clause more than once

Click here for a list of possible parameters and odbc states.

-1212L Error 2889 28W15 "Connection disallowed by login policy for this user" A connection attempt was disallowed based on the login policy for the user. It may be necessary for a user with DBA authority to reset this user via the ALTER USER statement.

Click here for a list of possible parameters and odbc states.

-1213L Error 2891 WJ031 "External environment does not support result sets" You attempted to define dynamic result sets for an external environment that does not support result sets.

Click here for a list of possible parameters and odbc states.

-1214L Error 2892 WW108 "External library '%1' is in use" The external library cannot be unloaded as it is currently in use.

Click here for a list of possible parameters and odbc states.

-1215L Error 2893 WW109 "External library '%1' not loaded" The external library cannot be unloaded as it is not current loaded.

Click here for a list of possible parameters and odbc states.

-1216L Error 2894 WT017 "The arguments to this procedure must be literal strings." This procedure only accepts literal strings as arguments.

Click here for a list of possible parameters and odbc states.

-1217L Error 2895 42W75 "Synchronization profile '%1' not found" You tried to access a synchronization profile that the database could not find.

Click here for a list of possible parameters and odbc states.

-1218L Error 2896 42WC7 "The materialized view cannot be changed to immediate because it does not have a unique index on non-aggregate non-nullable columns" You attempted to change the refresh type to immediate for a materialized view which does not have a unique index on non-aggregate non-nullable columns. Create a unique index on the materialized view before changing the refresh type.

Click here for a list of possible parameters and odbc states.

-1219L Error 2897 42WC8 "Maintenance of dependent immediate materialized view(s) failed" Maintenance of immediate materialized view(s) dependent on the base table failed.

Click here for a list of possible parameters and odbc states.

-1220L Error 2898 WO028 "User cannot be dropped because external logins exist for this user." The user cannot be dropped while an external login for the user still exists.

Click here for a list of possible parameters and odbc states.

-1221L Error 2899 42U08 "Duplicate options not allowed in the CREATE DATABASE statement" You have specified one of the options more than once when executing the CREATE DATABASE statement.

Click here for a list of possible parameters and odbc states.

-1222L Error 2900 WW110 "Multiplex Server '%1' not found" Multiplex Server with this name does not exist.

Click here for a list of possible parameters and odbc states.

-1223L Error 2901 42W76 "Synchronization profile '%1' already exists" You tried to create a synchronization profile that already exists.

Click here for a list of possible parameters and odbc states.

-1224L Error 2902 42W77 "Synchronization profile '%1' has invalid parameter '%2'" You tried to create or alter a synchronization profile using a string containing an invalid parameter setting.

Click here for a list of possible parameters and odbc states.

-1225L Error 2903 42W78 "Synchronization profiles are not supported for this database" The current database does not have catalog support for synchronization profiles. To use this feature, upgrade your database to the most recent version.

Click here for a list of possible parameters and odbc states.

-1226L Error 2904 42R04 "Foreign key columns do not match the primary key or a uniqueness constraint in \"%1\No message An attempt was made to create a foreign key, but the columns specified do not match the primary key or a uniqueness constraint for the referenced table.

Click here for a list of possible parameters and odbc states.

-1227L Error 2905 WI111 "Internal error, please contact Sybase IQ support. %1." The multiplex DDL command (create/alter/drop) failed with internal error due to specified reason.

Click here for a list of possible parameters and odbc states.

-1228L Error 2907 42W72 "Syntax error, cannot specify IQ specific options (%1) when creating a table in an SA database" An attempt was made to use IQ specific create table syntax when creating a table in an SA database

Click here for a list of possible parameters and odbc states.


Created May 6, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com