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. |