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 |
|---|---|---|---|---|---|
| -1176L | Error | 2853 | 0AW20 | "Plan not available. NOEXEC Plan cannot 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 a remote data access/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 | "Statement 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 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. |
| -1189L | Error | 2866 | WC004 | "The UTF-16 endian specified does not match the Byte Order Mark found in the data" | The specified UTF-16 encoding explicitly specifies the expected endian of the data; however, the Byte Order Mark found at the beginning of the data indicates that the data is encoded in the opposite endian. Click here for a list of possible parameters and odbc states. |
| -1190L | Error | 2867 | WL014 | "LOAD TABLE is not allowed on a materialized view %1" | LOAD TABLE statement is not allowed on a materialized view. Click here for a list of possible parameters and odbc states. |
| -1191L | Error | 2868 | WL015 | "LOAD TABLE not allowed: initialized immediate materialized view %1 depends on %2" | LOAD 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. |
| -1192L | Error | 2869 | 55W29 | "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. |
| -1193L | Error | 2870 | 55W30 | "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. |
| -1194L | Error | 2871 | WW097 | "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. |
| -1195L | Error | 2872 | WW098 | "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. |