Messages 2879 through 2898

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

Number Msg Type SQL State SQL Code Message Possible Cause
2879 Error 55W31 -1202L "Operation not allowed on a table with dependent immediate materialized views" Requested operation cannot be applied to a table with dependent immediate materialized views.

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

2880 Error 55W32 -1203L "WRITETEXT not allowed: immediate materialized view %1 depends on %2" WRITETEXT is not allowed on base tables that have dependent initialized immediate materialized views. No operation that does not fire triggers is allowed on base tables with dependent initialized immediate materialized views.

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

2881 Error 55W33 -1204L "INSERT...ON EXISTING UPDATE not allowed: immediate materialized view %1 depends on %2" Insert statement with ON EXISTING clause is not permitted on a base table if the base table has dependent initialized immediate materialized view.

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

2882 Error WJ030 -1205L "External environment '%1' could not be found" You attempted to define an object for an external environment that has not been added.

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

2883 Error WW104 -1206L "External environments are not supported for this database" The current database does not have catalog support for external environments. To use this feature, upgrade your database to the most recent version.

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

2884 Error WT016 -1207L "Invalid use of NEAR operator in text query." Only terms, prefixes, or other NEAR operators are allowed as arguments to a NEAR operator.

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

2885 Error WW105 -1208L "Invalid partition bound value '%1'" The partition bound value is invalid and cannot be used.

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

2886 Error WW106 -1209L "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.

2887 Error WW107 -1210L "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.

2888 Error 23509 -1211L "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.

2889 Error 28W15 -1212L "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.

2890 Error 42W89 -1318L "More articles are being dropped from publication '%1' than are defined" The number of articles in a publication can never fall below one. Your ALTER PUBLICATION has more drop/delete article clauses than the current number of articles in the publication.

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

2891 Error WJ031 -1213L "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.

2892 Error WW108 -1214L "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.

2893 Error WW109 -1215L "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.

2894 Error WT017 -1216L "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.

2895 Error 42W75 -1217L "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.

2896 Error 42WC7 -1218L "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.

2897 Error 42WC8 -1219L "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.

2898 Error WO028 -1220L "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.


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