Messages 1169 through 1188

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
-1169L Error 2846 WT013 "Cannot access a table that is part of a text index." It is not possible to directly manipulate tables created as part of a text index.

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

-1170L Error 2847 42WC3 "The materialized view %1 cannot be changed to immediate because it has already been initialized" You attempted to change the refresh type to immediate for a materialized view which is already in an initialized state. Truncate the view before changing the refresh type.

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

-1171L Error 2848 WW092 "Client application does not allow transfer of data ('%1')" The client application does not allow the transfer of server initiated data. In order to allow transfer of server initiated data, the application must register a validation callback mechanism with the client library.

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

-1172L Error 2849 WW093 "Client application disallowed the transfer of data ('%1')" The client application rejected the transfer of server initiated data. In order to allow transfer of server initiated data, the application registered a validation callback which rejected the transfer of requested data.

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

-1173L Error 2850 WW094 "Client library reported an error accessing data during transfer ('%1')" The client application reported an error while attempting to access the data for a transfer request from the server. Reasons could include the client application lacking permissions to the data object or other operating system reported errors.

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

-1174L Error 2851 WT014 "Cannot create text configuration '%1' because option '%2' has an inappropriate setting" You attempted an operation that needs to create or alter the database options settings for a text configuration, but one of the options is currently set to a value not permitted for a text configuration.

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

-1175L Error 2852 42WC4 "Unable to acquire table locks in specified time" The LOCK TABLE command could not acquire all the locks in specified time period

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

-1176L Error 2853 0AW20 "Plan not available. NOEXEC Plan can not be generated for this type of statement" You tried to get the NOEXEC plan for a statement type for which IQ cannot generate a NOEXEC plan.

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

-1177L Error 2854 0AW21 "No plan. HTML_PLAN function is not supported for this type of statement or database." You tried to get the HTML plan for a query which is either a SQL Anywhere query or an OMNI/CIS decomposed query. HTML_PLAN is supported for a pure IQ query.

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

-1178L Error 2855 WW095 "Transaction log mirroring cannot be used with database mirroring" Transaction log mirroring cannot be used with database mirroring. Use the DBLOG utility to disable transaction log mirroring.

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

-1179L Error 2856 08WA2 "Unable to start database server: missing license file" It was not possible to start the database server because the server license file was not found. The server license file has the same name as the server executable with the extension ".lic".

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

-1180L Error 2857 WW096 "Cannot set database option \"%1\" because it is on the options watch list" An attempt was made to set a database option that is on the options watch list. The options watch list is used to help find references to options that have been removed or deprecated.

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

-1181L Error 2858 42WC5 "The materialized view cannot be changed to immediate because its definition must not contain more than one query block" You attempted to change the refresh type to immediate for a materialized view whose definition contains more than one query block.

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

-1182L Error 2859 WT015 "Command not allowed on IMMEDIATE REFRESH text index" You cannot use REFRESH TEXT INDEX or TRUNCATE TEXT INDEX on an index that is created with immediate refresh. You cannot alter a text index to use or stop using immediate refresh.

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

-1183L Error 2860 0AW22 "Support for permissions on dbspaces is not available for this database" The statement being executed requires support for permissions on dbspaces, but the database being used does not have this capability. The database must be recreated or upgraded using a version of the server that supports permissions on dbspaces.

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

-1184L Error 2861 55W21 "Cannot drop last unique index of an immediate materialized view" You attempted to drop the last unique index on non-nullable columns of an immediate materialized view. Immediate materialized view needs at least one unique index on non-nullable columns in order to be valid.

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

-1185L Error 2862 WI002 "Index validation failed for table %1, index %2 with code: %3" UltraLite database validation failed while validating the specified index. The code provides more specific information on the validation failure.

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

-1186L Error 2863 WI003 "Database page validation failed with code: %1" UltraLite database validation failed while validating the database pages. The code provides more specific information on the validation failure.

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

-1187L Error 2864 WL012 "Cannot append when using compression or encryption" The UNLOAD statement cannot append to a file when using compression or encryption. Either the compressed or encrypted keywords were specified, or the file being appended to is compressed or encrypted.

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

-1188L Error 2865 WL013 "LOAD TABLE error: %1" The LOAD TABLE statement failed. The message specifies the actual problem that occurred.

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