Messages on this page are sorted by Sybase error code. Locate the appropriate code for a full description of the message.
| Error 1218 | "The materialized view cannot be changed to immediate because it does not have a unique index on non-aggregate, non-nullable columns" |
|---|---|
Constant | UPDATABLE_MATVIEW_NON_AGGR_INDEX |
SAP Sybase Error Number | 2896 |
SQL State | 42WC7 |
SQL Code | -1218L |
ODBC 2 State | 42000 |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | 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. |
| Error 1219 | "Maintenance of dependent immediate materialized view(s) failed" |
|---|---|
Constant | MAINTENANCE_OF_IMV_FAILED |
SAP Sybase Error Number | 2897 |
SQL State | 42WC8 |
SQL Code | -1219L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | Maintenance of immediate materialized view(s) dependent on the base table failed. |
| Error 1220 | "User cannot be dropped because external logins exist for this user." |
|---|---|
Constant | USER_HAS_EXTERNLOGINS |
SAP Sybase Error Number | 2898 |
SQL State | WO028 |
SQL Code | -1220L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | The user cannot be dropped while an external login for the user still exists. |
| Error 1221 | "Duplicate options not allowed in the CREATE DATABASE statement" |
|---|---|
Constant | DUPLICATE_CREATE_DB_OPTION |
SAP Sybase Error Number | 2899 |
SQL State | 42U08 |
SQL Code | -1221L |
ODBC 2 State | S0002 |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | You have specified one of the options more than once when executing the CREATE DATABASE statement. |
| Error 1222 | "Multiplex Server '%1' not found" |
|---|---|
Constant | IQ_MULTIPLEX_SERVER_NOT_FOUND |
SAP Sybase Error Number | 2900 |
SQL State | WW110 |
SQL Code | -1222L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | The name of Multiplex Server. |
Probable Cause | Multiplex Server with this name does not exist. |
| Error 1223 | "Synchronization profile '%1' already exists" |
|---|---|
Constant | SYNC_PROFILE_ALREADY_EXISTS |
SAP Sybase Error Number | 2901 |
SQL State | 42W76 |
SQL Code | -1223L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | Name of the synchronization profile. |
Probable Cause | You tried to create a synchronization profile that already exists. |
| Error 1224 | "Synchronization profile '%1' has invalid parameter '%2'" |
|---|---|
Constant | SYNC_PROFILE_INVALID |
SAP Sybase Error Number | 2902 |
SQL State | 42W77 |
SQL Code | -1224L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | Name of the synchronization profile that is invalid. |
Parameter 2 | Name of the parameter in the profile that has the problem. |
Probable Cause | You tried to create or alter a synchronization profile using a string containing an invalid parameter setting. |
| Error 1225 | "Synchronization profiles are not supported for this database" |
|---|---|
Constant | SYNC_PROFILE_UPGRADE |
SAP Sybase Error Number | 2903 |
SQL State | 42W78 |
SQL Code | -1225L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | The current database does not have catalog support for synchronization profiles. To use this feature, upgrade your database to the most recent version. |
| Error 1226 | "Foreign key columns do not match the primary key or a uniqueness constraint in \"%1\No message |
|---|---|
Constant | NO_MATCHING_INDEX |
SAP Sybase Error Number | 2904 |
SQL State | 42R04 |
SQL Code | -1226L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | The name of the primary table. |
Probable Cause | 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. |
| Error 1227 | "Internal error. Contact SAP Sybase IQ support. %1." |
|---|---|
Constant | IQ_MPX_INTERNAL_ERROR |
SAP Sybase Error Number | 2905 |
SQL State | WI111 |
SQL Code | -1227L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | The error description. |
Probable Cause | The multiplex DDL statement (CREATE/ALTER/DROP) failed with internal error due to specified reason. |
| Error 1228 | "Syntax error, cannot specify SAP Sybase IQ specific options (%1) when creating a table in a SQL Anywhere database" |
|---|---|
Constant | IQ_ONLY_SYNTAX_ERROR |
SAP Sybase Error Number | 2907 |
SQL State | 42W72 |
SQL Code | -1228L |
ODBC 2 State | 37000 |
ODBC 3 State | 42000 |
Severity Code | |
Parameter 1 | SAP Sybase IQ option used. |
Probable Cause | An attempt was made to use SAP Sybase IQ specific create table syntax when creating a table in a SQL Anywhere database. |
| Error 1229 | "Reorganize table is already being run on table \"%1\No message |
|---|---|
Constant | REORG_ALREADY_IN_PROGRESS |
SAP Sybase Error Number | 2908 |
SQL State | 54W51 |
SQL Code | -1229L |
ODBC 2 State | 54000 |
ODBC 3 State | 54000 |
Severity Code | |
Parameter 1 | The name of the table. |
Probable Cause | 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. |
| Error 1230 | "Too many open cursors" |
|---|---|
Constant | TOO_MANY_CURSORS |
SAP Sybase Error Number | 2909 |
SQL State | 54W12 |
SQL Code | -1230L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | 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. |
| Error 1231 | "Statement timed out: '%1!s!'" |
|---|---|
Constant | STATEMENT_TIMEOUT |
SAP Sybase Error Number | 2910 |
SQL State | 57W05 |
SQL Code | -1231L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | Statement type |
Probable Cause | The statement failed because it did not complete within the allotted or specified time. |
| Error 1232 | "Attempt to start a second snapshot in a transaction" |
|---|---|
Constant | SNAPSHOT_ALREADY_STARTED |
SAP Sybase Error Number | 2911 |
SQL State | 42WC9 |
SQL Code | -1232L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | A transaction tried to start a snapshot (for example, using the BEGIN SNAPSHOT statement) while another snapshot was already active. |
| Error 1233 | "The materialized view %1 cannot be changed to immediate because it does not have a unique index on non-nullable columns." |
|---|---|
Constant | IMMEDIATE_MV_NO_UNIQUE_INDEX |
SAP Sybase Error Number | 2912 |
SQL State | 42WCA |
SQL Code | -1233L |
ODBC 2 State | 42000 |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | Name of the materialized view. |
Probable Cause | 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. |
| Error 1234 | "Dbspace file with name or path '%1' already exists." |
|---|---|
Constant | IQ_DBSPACEFILE_UPDATE_ERROR |
SAP Sybase Error Number | 2913 |
SQL State | 42W7A |
SQL Code | -1234L |
ODBC 2 State | 37000 |
ODBC 3 State | 42000 |
Severity Code | |
Parameter 1 | Logical file name or physical path from CREATE/ALTER DBSPACE SQL statement. |
Probable Cause | Error code to use for catalog update errors in SAP Sybase IQ code. |
| Error 1235 | "Too many columns in SELECT list" |
|---|---|
Constant | TOO_MANY_COLUMNS_IN_SELECT |
SAP Sybase Error Number | 2914 |
SQL State | 54W13 |
SQL Code | -1235L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | You executed a statement with too many expressions in the SELECT list. The number of expressions within a SELECT list is limited to 60000. |
| Error 1236 | "Too many expressions in GROUP BY list" |
|---|---|
Constant | TOO_MANY_COLUMNS_IN_GROUPBY |
SAP Sybase Error Number | 2915 |
SQL State | 54W14 |
SQL Code | -1236L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | You executed a statement with too many expressions in the GROUP BY list. The number of expressions within a GROUP BY list is limited to 60000. |
| Error 1237 | "Too many columns in procedure result set" |
|---|---|
Constant | TOO_MANY_COLUMNS_IN_PROC_RES |
SAP Sybase Error Number | 2916 |
SQL State | 54W15 |
SQL Code | -1237L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | You executed a statement with too many expressions in the GROUP BY list. The number of expressions within a GROUP BY list is limited to 60000. You executed a CREATE PROCEDURE or ALTER PROCEDURE statement. The resulting number of columns in the result set of the procedure would exceed the server's limit. |