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 |
|---|---|---|---|---|---|
| -1156L | Error | 2832 | WT001 | "Argument \"%1\" must be a column reference." | The CONTAINS argument must be a column reference. Click here for a list of possible parameters and odbc states. |
| -1157L | Error | 2833 | WT002 | "All column reference arguments must refer to the same table." | All column references in a CONTAINS query must refer to the same table. Click here for a list of possible parameters and odbc states. |
| -1158L | Error | 2834 | WT003 | "No matching text index." | A single text index must exist on all columns referenced in a CONTAINS query. Click here for a list of possible parameters and odbc states. |
| -1159L | Error | 2835 | WT004 | "Non-constant or unknown text query string." | The query string argument to a CONTAINS query must be a constant, or a non-null value in a variable. Click here for a list of possible parameters and odbc states. |
| -1160L | Error | 2836 | WT005 | "Text configuration \"%1\".\"%2\" not found." | The specified text configuration does not exist. Click here for a list of possible parameters and odbc states. |
| -1161L | Error | 2837 | WT006 | "Text configuration \"%1\" already exists." | The specified text configuration name already exists. Click here for a list of possible parameters and odbc states. |
| -1162L | Error | 2838 | WT007 | "Term length outside allowed range." | The minimum and maximum term lengths must both be greater than 0 and less than or equal to 60 characters. Click here for a list of possible parameters and odbc states. |
| -1163L | Error | 2839 | WT008 | "Invalid collation: \"%1\"." | The collation was not found, or the tailoring options were invalid. Click here for a list of possible parameters and odbc states. |
| -1164L | Error | 2840 | WT009 | "Text query parser error: %1" | The text query could not be parsed. Click here for a list of possible parameters and odbc states. |
| -1165L | Error | 2841 | WT010 | "Error creating text index \"%1\" on table \"%2\No message | There was an internal error creating a text index. Click here for a list of possible parameters and odbc states. |
| -1166L | Error | 2842 | WT011 | "Text indexes are not supported for this database." | The current database does not have catalog support for text indexes. To use this feature, upgrade your database to the most recent version. Click here for a list of possible parameters and odbc states. |
| -1167L | Error | 2843 | 55W12 | "Cannot drop a user that owns text configurations" | You attempted to drop a user that is the creator of a text configuration. The text configuration must be dropped first. Click here for a list of possible parameters and odbc states. |
| -1168L | Error | 2844 | WT012 | "Cannot alter or drop a text configuration referenced by a text index." | It is not possible to alter or drop a text configuration referenced by a populated text index or currently being used by a text procedure. Either copy the configuration and alter the copy, or close all cursors on text procedures and truncate all indexes that use the configuration. Click here for a list of possible parameters and odbc states. |
| -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. 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. 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 statement could not acquire all the locks in specified time period Click here for a list of possible parameters and odbc states. |