Messages 1216 through 1235

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
-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. Contact Sybase IQ support. %1." The multiplex DDL statement (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.

-1229L Error 2908 54W51 "Reorganize table is already being run on table \"%1\No message There is already a REORGANIZE TABLE statement being run on this table. Only one such statement can be executing on a table at any time.

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

-1230L Error 2909 54W12 "Too many open cursors" You exceeded the number of cursors that can be open on a single UltraLite database. Check to ensure you are freeing statements when you are done with them.

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

-1231L Error 2910 57W05 "Statement timed out: '%1!s!'" The statement failed because it did not complete within the allotted or specified time.

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

-1232L Error 2911 42WC9 "Attempt to start a second snapshot in a transaction" A transaction tried to start a snapshot (for example, using the BEGIN SNAPSHOT statement) while another snapshot was already active.

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

-1233L Error 2912 42WCA "The materialized view %1 cannot be changed to immediate because it does not have a unique index on 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-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.

-1234L Error 2913 42W7A "Dbspace file with name or path '%1' already exists." Error code to use for catalog update errors in IQ code.

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

-1235L Error 2914 54W13 "Too many columns in SELECT list" You executed a statement with too many expressions in the SELECT list. The number of expressions within a SELECT list is limited to 60000.

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


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