Messages 2869 through 2888

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
2869 Error 55W29 -1192L "Cannot update multiple tables immediate materialized view %1 depends on" You attempted to simultaneously update two or more tables initialized immediate materialized view depends on. No more than one base table an immediate materialized view depends on can be updated in a statement.

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

2870 Error 55W30 -1193L "TRUNCATE TABLE not allowed: initialized immediate materialized view %1 depends on %2" TRUNCATE TABLE is not permitted on any table that has dependent initialized immediate materialized views.

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

2871 Error WW097 -1194L "Login policy \"%1\" already exists" An attempt was made to create a login policy that already exists in the database.

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

2872 Error WW098 -1195L "Login policy \"%1\" not found" The named login policy was not found in the database.

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

2873 Error WW099 -1196L "Login policies are not supported for this database" The current database does not have catalog support for login policies. To use this feature, upgrade your database to the most recent version.

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

2874 Error WW100 -1197L "Login policy \"%1\" in use" The named login policy is associated with a user in the database. Any users associated with the login policy must be assigned a different login policy before the named login policy can be dropped.

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

2875 Error WW101 -1198L "User \"%1\" already exists" An attempt was made to create a user that already exists in the database.

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

2876 Error 42WC6 -1199L "The materialized view cannot be changed to immediate because COUNT(*) is required to be part of the SELECT list." You attempted to change the refresh type to immediate for a materialized view whose definition does not include COUNT(*) in the SELECT list.

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

2877 Error WW103 -1200L "Client library reported a permissions error accessing object ('%1') during transfer" The client application reported a permissions error while attempting to access the object for a data transfer request from the server. The client application likely does not have the necessary operating system authorization required to access the object.

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

2878 Error WW102 -1201L "Client library reported an error opening object ('%1') during transfer" The client application reported an error while attempting to open the object for a data transfer request from the server. Reasons could include an invalid name for the object or a missing object.

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

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.


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