Kognitio Error Codes

This is a list of all error codes returned by a Kognitio server. A Kognitio error code consists of two uppercase letters followed by four hex digits.

This list corresponds to Kognitio server version 8.02.04-rel190926.

AD error codes

AD0100Internal error processing query plan
Expansion There was an internal error which produced a bad query plan
Action Contact support
AD0101Internal ungrouped projection on one row aggregate
Expansion There was an internal error which produced a bad query plan
Action Contact support
AD0102Internal projection from inner table in subquery
Expansion There was an internal error which produced a bad query plan
Action Contact support
AD0103Window function used internally in incorrect context
Expansion There was an internal error which produced a bad query plan
Action Contact support
AD0104Invalid node in internal r.p.
Expansion There was an internal error which produced a bad query plan
Action Contact support
AD0105Invalid hash column specified in internal query plan
Expansion There was an internal error which produced a bad query plan
Action Contact support
AD0106Invalid ram projection column specified in internal query plan
Expansion There was an internal error which produced a bad query plan
Action Contact support
AD0107Access description overflow
Expansion Internal data structure overflow.
Action Contact support
AD0108Invalid internal variable reference
Expansion Generated query plan references an invalid variable.
Action Contact support
AD0109Duplicate internal variable definition
Expansion Generated query plan defines a duplicate internal variable.
Action Contact support
AD010AInternal access side reference bad
Expansion Generated query plan contains references to an invalid join side number.
Action Contact support

AH error codes

AH0001Sessions inhibited
Expansion You cannot start a user session whilst there is a session that is running/has run any of these commands: LOCK SYSTEM, CREATE IMAGE, CREATE SYSTEM IMAGE, NEW SYSTEM.
Action Wait and try again later
AH0002Cannot allocate global session because other users are logged in
Expansion You cannot issue any of these commands if another user session is currently logged in: LOCK SYSTEM, CREATE IMAGE, CREATE SYSTEM IMAGE, NEW SYSTEM.
Action Wait and try again later
AH0003Uncommitted transaction list overflow
Expansion Internal RDBMS error
Action Notify Help Desk
AH0004This operation requires a global session
Expansion The requested operation requires a global lock
Action Global locks are set in response to a CREATE [SYSTEM] IMAGE or you can set the lock with LOCK SYSTEM command
AH0005No more sessions allowed
Expansion The maximum number of sessions allowed on this server has been reached
Action Consult your System Administrator
AH0006Invalid value for maximum sessions
Expansion The maximum number of sessions which you are trying to set is not permitted
Action Amend your CREATE USER or ALTER USER statement; then try again
AH0007system is not initialised
Expansion Concurrent sessions are only enabled after 'create image' or similar
Action initialise the system with create image or similar or only use one session
AH0008Invalid transaction number
Expansion A transaction number given to the AH is not known.
Action This error can occur if a query is aborted. In other circumstances, contact the maintainers.
AH0009Invalid session number
Expansion A session number given to the AH is not known.
Action This error may occur if a session is aborted, but should not be returned to the client.
AH2003Query aborted
Expansion
Action

AI error codes

AI0000Too many ORs
Expansion Internal RDBMS error
Action Notify Help Desk
AI0001The operation cannot be done
Expansion Internal RDBMS error
Action Notify Help Desk
AI0002File not loaded
Expansion Internal RDBMS error
Action Notify Help Desk
AI0003Out of space
Expansion Internal RDBMS error
Action Notify Help Desk
AI0004No disk space
Expansion Internal RDBMS error
Action Notify Help Desk
AI0005Out of memory
Expansion Your enquiry needs more memory than is available
Action Either Drop Table Image to release memory or wait to try later
AI0006Invalid disk position
Expansion You have specified an invalid disk identifier for one of the commands FORMAT, SPIN UP or RECREATE
Action Check IPE_DISK
AI0007Invalid checksum
Expansion Internal RDBMS error
Action Notify Help Desk
AI0008Invalid operation on virtual table
Expansion Virtual system tables (such as IPE_SYSTEM) allow a restricted set of update operations
Action Modify the SQL statement and start again
AI0009Disk not found
Expansion Disk for formatting/extraction could not be found
Action Check disk details. If trying to extract a virtual disk, need to just replace and reboot instead
AI000AStream Index not found
Expansion Stream index cannot be found for codejoin conversion
Action Internal error. Please contact support.
AI000BCardinality error
Expansion An operation returned multiple rows when it should only return 1 or 0
Action Check query.
AI000CCannot move system table records
Expansion Cannot move records for system tables with repack/redistribute
Action Leave system table records unmoved on disk
AI000DToo many access restarts
Expansion A limit has been set on how many times operations can be repeated in a query
Action Increase the limit, change the query or retry with more resources
AI000EToo many record recomputations
Expansion A limit has been set on how many times values can be recomputed in a query
Action Increase the limit, change the query or retry with more resources
AI000FAccess retry timeout exceeded
Expansion A limit has been set on how long an operation can keep being restarted for
Action Increase the limit, change the query or retry with more resources
AI0010Invalid header type in internal s-code structure
Expansion An internally generated header type in the query plan is not valid.
Action Contact support
AI0011Internal error: size of keyed fetch is too big
Expansion An internal attempt to fetch rows from a table tried to fetch more than the permitted number of rows at once.
Action Contact support
AI0012Internal error: Ramstore group not found in lookup
Expansion An internal attempt to lookup the ramstore group containing an object has failed.
Action Contact support
AI0101External access operation has no active processes due to exclusions
Expansion An external operation has been defined with limits which prevent it from starting any threads (e.g. disallowing every node)
Action Correct the thread or node limits and retry
AI0102Debug checking for the nostats flag is enabled and a check failed
Expansion This is a debug check which happens when the ai_statschk parameter is set. This parameter is for debugging and QA testing and should not be set in production
Action Clear the ai_statschk parameter and retry
AI2003Query aborted
Expansion
Action

AM error codes

AM0001Cursor lock violation
Expansion Locks prevent update of tables with open cursors
Action Check your program logic; then try again
AM0002Cursor not found
Expansion You must declare a cursor for this operation
Action Check your program logic; then try again
AM0003Cursor not updatable
Expansion To Update or Delete Where Current of Cursor is valid only for tables and not for views or joins
Action Check your program logic; then try again
AM0004Missing argument specification
Expansion RDA routines require arguments to Declare Cursor and Open Cursor
Action Check your SQL statements; then try again
AM0005Duplicate cursor name
Expansion You have used the same name as a declared cursor
Action Check your SQL statements; then try again
AM0006Invalid cursor operation
Expansion Your cursor operations do not follow the correct sequence
Action Resubmit in the correct sequence
AM0007Invalid repeat count on raw disk
Expansion You have breached the implementation limit
Action Simplify your SQL syntax and try again
AM0008Invalid argument specification on raw disk
Expansion You have breached the implementation limit
Action Simplify your SQL syntax and try again
AM0009Invalid disk id specified by raw disk command
Expansion Invalid ID specified in SQL
Action Check your SQL; then try again
AM000AInvalid raw disk operation
Expansion You have breached the implementation limit
Action Simplify your SQL syntax and try again
AM000BAttempt to write past end of disk
Expansion You have breached the implementation limit
Action Amend your SQL syntax and try again
AM000CInvalid data length for restore
Expansion You have breached the implementation limit
Action Amend your SQL syntax and try again
AM000DTransaction no longer valid
Expansion Internal RDBMS error
Action Notify Help Desk
AM000ECursor no longer valid
Expansion This cursor is not known
Action Amend your SQL syntax and try again
AM000FInvalid Processor ID
Expansion Invalid ID specified in SQL
Action Check your SQL; then try again
AM0010Invalid direct export operation
Expansion User developed application has performed an invalid operation
Action Check your program logic; then try again
AM0011Invalid direct import operation
Expansion User developed application has performed an invalid operation
Action Check your program logic; then try again
AM0012Checksum in WCB block is incorrect
Expansion Import file is either corrupt or not in WCB format
Action Check file format and import parameters; then try again
AM0013Invalid WCB block format
Expansion Import file is either corrupt or not in WCB format
Action Check file format and import parameters; then try again
AM0014Import field specification does not match table definition
Expansion There is a mismatch between the table definition on the server and in the WCB file
Action Check table and file definitions
AM0015WCB import version number incompatible
Expansion Import file is either corrupt or not in WCB format
Action Check file format and import parameters; then try again
AM0016WCB record length improper
Expansion Import file is either corrupt or not in WCB format
Action Check file format and import parameters; then try again
AM0017Invalid initialise from RDA
Expansion Internal RDBMS error
Action Notify Help Desk
AM0018Invalid begin transaction from RDA
Expansion Internal RDBMS error
Action Notify Help Desk
AM0019Query with no transaction from RDA
Expansion Internal RDBMS error
Action Notify Help Desk
AM0020Password check failed
Expansion The password you have entered fails to meet the specification for this user ID or security class
Action Consult your System Administrator
AM0021Prohibited by login restrictions
Expansion The action you have selected is not allowed by the rules governing your user ID or security class
Action Consult your System Administrator
AM0022Maximum login failures exceeded
Expansion There have been too many failed login attempts
Action Consult your System Administrator
AM0023User inactive too long
Expansion This user ID has expired
Action Consult your System Administrator
AM0024Unknown user
Expansion The user ID used to log in is not recognised; this user may have been suspended
Action Consult your System Administrator
AM0025Unknown security class
Expansion The security class you have specified is not recognised
Action Consult your System Administrator
AM0026Login has been revoked
Expansion You have attempted to log in to a server to which you do not have access
Action Consult your System Administrator
AM0027Password has expired
Expansion You have attempted to log in using a password which is not legal in your security class
Action Consult your System Administrator
AM0028Session inactivity period exceeded
Expansion This session has been inactive too long and so has been terminated
Action Consult your System Administrator
AM0029Invalid user status
Expansion Invalid status associated with this user ID
Action Consult your System Administrator
AM002AInvalid username length
Expansion The user name you have tried to enter is too long
Action Amend your CREATE USER or ALTER USER statement; then try again
AM002BGarbled challenge response
Expansion The client's response to the authentication challenge sent by the server wasn't even recognisable.
Action Report this to the maintainers.
AM002CUnknown authentication method
Expansion The client is asking to authenticate in a manner unfamiliar to the server, or which the server cannot perform.
Action Either upgrade the server to one that does know how to authenticate in the manner the client is describing, or use a different authentication method, or ensure the server has the appropriate libraries available.
AM0030Solo operation is not first in transaction - if reusing tnos via am_keep_tno param, switch off for users running solo operations
Expansion An operation such as NEW SYSTEM, CREATE [SYSTEM] IMAGE or RECLAIM is not the first in a transaction
Action Consult your System Administrator - if reusing tnos via am_keep_tno param, switch off for the user running solo operations
AM0031Operation not allowed after solo operation
Expansion An operation such as NEW SYSTEM, CREATE [SYSTEM] IMAGE or RECLAIM is not the first in a transaction
Action Consult your System Administrator
AM0032Connection has been bounced for load-balancing
Expansion The AH has determined that there is a better IP address/port combination for the connection, so try connecting to that
Action The WCSODBC driver should connect to the alternative supplied
AM0033stored pointer passed into AM could not be found on stored list
Expansion Occurred once at customer site, cause unclear. May be due to client behaving erroneously???
Action Notify Help Desk
AM0034Too many open cursors for the session
Expansion This session has reached its limit for open cursors - no more can be opened without first closing some of its existing cursors
Action Either increase the open cursor limit for this session/user/system, change the server to boot with more interpreters, or check to see if the application is opening more cursors than it should (i.e. does it really need to have the current number of cursors open)
AM0035Login mode set to root only
Expansion ODBC connection must come from a trusted source port (<=1023)
Action change adm_login_mode parameter or contact system administrator
AM0036Login mode set to sys only
Expansion Only sys may log into the machine
Action change adm_login_mode parameter or contact system administrator
AM0037Login mode set to localhost only
Expansion Connections to the DES must be made through localhost on the CP
Action change adm_login_mode parameter or contact system administrator
AM0038Import invoked after import finished
Expansion The client has sent an invoke request for an import which has ended.
Action Notify help desk
AM0039Inconsistency in user and password system tables
Expansion The password referred to for a user in IPE_ALLUSER does not exist in IPE_PASS_HIST.
Action Notify help desk.
AM003ARecord too long and cannot merge fragmented blocks in this format
Expansion Bulk-loaded blocks of data need to be merged due to long records, but this format doesn't allow that.
Action Shorten the records of your file, or allow a larger block size by increasing the parameter load_split_size.
AM003BDetected at least %S further conversion error%T
Expansion The number of conversion errors returned for a file exceeded the user imposed limit. Further conversion errors were not reported.
Action Correct the data file or format string and try again.
AM003CSession is not initialised
Expansion The client is trying to submit queries without first submitting a successful login command.
Action The ODBC driver should never do this. Contact WX2 helpdesk.
AM003DError decompressing block
Expansion A compressed WCB block contained data that was not valid zlib-compressed data.
Action ZWCB file corrupted. Re-export the file, or contact helpdesk.
AM003EZWCB decompressed length wrong
Expansion A ZWCB file claimed the uncompressed length of a block was shorter than the actual uncompressed length.
Action ZWCB file corrupted. Re-export the file, or contact helpdesk.
AM003FInvalid ZWCB subblock length
Expansion The wxloader client sent in a compressed block where one of the sub-blocks had a length larger than the remainder of the block, larger than 1 MB, or less than 0. This is probably caused by a corrupt ZWCB file.
Action If this file was produced by wxunloader or wxwcbzip, it indicates a bug. Contact helpdesk.
AM0040Transaction has been aborted and rolled back
Expansion Your transaction has been forcibly closed and rolled back by the system or by another session.
Action Try again in a new transaction. If the error persists, execute an explicit "rollback" to force ODBC to open a new transaction on the next query.
AM0041Internal resource limit reached
Expansion The import operation or connection cannot be completed because the process has used up all the communication channel slots available to it.
Action Connect to a different node or try again when the system is less busy.
AM0042Cannot skip records when loading compressed WCB
Expansion It is not possible to skip records when loading compressed WCB into the database.
Action If using wxloader, do not use the --skip-records option when loading compressed WCB. If necessary, load the file into a staging table and delete any unwanted rows afterwards.
AM0043Invalid privilege request
Expansion Internal RDBMS error: Invalid privilege request
Action Notify Help Desk
AM0044Unable to count previous login failures because SYS.IPE_ALLLOGIN is not imaged
Expansion The user trying to log in is in a security class which locks the user out after a certain number of login failures. This condition cannot be checked because SYS.IPE_ALLLOGIN is not in RAM.
Action Put SYS.IPE_ALLLOGIN in RAM. As the SYS user, run CREATE TABLE IMAGE SYS.IPE_ALLLOGIN.
AM0045Server unable to use libcrypto library
Expansion The server cannot perform a request to authenticate with SSH keys because it could not load the libcrypto library, the libcrypto library was too old, or it did not contain a required function. More information is in the serverdbg log.
Action Ensure 32-bit libcrypto is installed on all DB nodes.
AM0046Conversion errors used too much memory
Expansion There were a large number of conversion errors returned for this load, and they used too much memory so they were discarded and the load was aborted.
Action Use a smaller conversion error limit.
AM0047More than 32000 conversion errors for one block of import data
Expansion There were too many conversion errors returned in response to one block of imported data. Due to an ODBC limitation, one response cannot contain more than this many diagnostic records.
Action Check the wxloader options and/or fix your data file.
AM0048Remote listener group sync failed
Expansion The server tried to tell the client that it had finished opening remote listening sockets on the client side, but couldn't.
Action This error is for internal use.
AM0049JSON syntax error: %S
Expansion A JSON syntax error was discovered when searching for the target array or in splitting up the array into objects.
Action Correct your JSON and try again.
AM004ATarget array not found in root object of JSON document
Expansion A target array was specified for a JSON import, but no array of that name exists in the root object of the JSON document.
Action Specify the correct target array. If there is no target array and the JSON document contains an unnamed array which is to be the target, or a series of self-contained objects, leave the target array blank.
AM004BPassword reset on login prohibited by server policy
Expansion You attempted to change your password while logging in, perhaps because your existing password has expired, but the server policy prohibits this.
Action Consult your system administrator. The SYS user has the privilege to reset users' passwords.
AM004CAuthentication failed
Expansion Authentication failed for miscellaneous reasons.
Action This is probably because the user has tried to present themselves as a certain principal name without authenticating.
AM004DServer failed to load libgss
Expansion The server failed to load the libgss API.
Action Make sure the libgss API is installed on all nodes.
AM004EServer failed to acquire credential
Expansion The server failed to acquire its credential using GSS, so authentication cannot be performed with this method.
Action Consult your system administrator.
AM004FAuthentication succeeded but you are not authorised to log on as this user
Expansion The authentication step succeeded, but your principal name is not in the IPE_ALLPRINCIPAL_NAME table along with the user ID you specified.
Action Log in as a different user, or get your principal name added to IPE_ALLPRINCIPAL_NAME with the appropriate user ID.
AM0050Not authorised to log in without a pre-existing username
Expansion The principal you've authenticated as is not a member of an external group which is allowed to log in with an automatically-created user.
Action The system administrator can add your principal to an appropriate external group, or make an external group of which you are a member be allowed to log in.
AM0051Login failed
Expansion Your login failed for unspecified reasons.
Action Contact your system administrator.
AM0052Key authentication failed
Expansion An attempt to log in using public-private key authentication failed
Action Ensure you are using the correct private key and passphrase, and that your public key is associated with your username. Contact your system administrator.
AM0053Automatically created user is not a member of an external group with permission to log in
Expansion Your Kognitio user ID was automatically created at a time when your principal name was a member of an external group in IPE_ALLEXTERNAL_GROUP with CAN_LOGIN set. However, you are no longer in such a group, so you cannot log in with this user ID.
Action Contact your system administrator.
AM0054Automatic transaction commit failed
Expansion A server-side automatic commit of a transaction failed.
Action Contact Kognitio support.
AM0055Syntax error or access violation
Expansion You do not have sufficient privileges to perform this query.
Action Contact your database administrator.
AM0056Unknown RDA error
Expansion The server tried to send back an error that doesn't have an error code. This is a bug.
Action Contact Kognitio support.
AM0057Unrecognised Avro codec
Expansion This Avro data has been encoded with a codec which we do not recognise.
Action Obtain the data in a different Avro codec.
AM0058No Avro schema supplied
Expansion An Avro load was attempted, but the WCB header block sent to the server by the client did not specify the Avro schema.
Action This is a bug in the client.
AM0059No Avro sync marker supplied
Expansion An Avro load was attempted, but the WCB header block sent to the server by the client did not specify the block sync marker.
Action This is a bug in the client.
AM0060Fatal data load error: %S
Expansion An error occurred which has resulted in the load being abandoned.
Action Refer to the error context.
AM2003Query aborted
Expansion
Action

CG error codes

CG0001Code too complex
Expansion Not enough buffer memory to return code from the T-Code generator
Action Simplify your SQL statements; then try again
CG0002Illegal escape in LIKE
Expansion You cannot specify this as an escape character in a LIKE operation
Action Choose another character as your escape character for the search
CG0004Unhandled internal generator exception
Expansion There was an unhandled internal error in the machine code generator
Action Please report this to support
CG0005Generated code too large
Expansion The query requires WX2 to generate a block of code which is too large
Action Change the size limit (cg_max_gencode parameter) or contact support
CG002AInvalid EUC double byte character
Expansion A Kanji LIKE pattern contains an invalid Kanji character
Action Check the LIKE expression; then try again
CG002BEscape at end of pattern
Expansion A Kanji LIKE pattern has a trailing escape character
Action Check the LIKE expression; then try again
CG0065Invalid date value
Expansion Operation produced an invalid date value
Action Contact the help desk
CG0067Invalid timestamp value
Expansion Operation produced an invalid timestamp value
Action Contact the help desk
CG0068Invalid time value
Expansion Operation produced an invalid time value
Action Contact the help desk
CG006AYear-month interval overflow
Expansion Precision of year-month interval value is too small
Action Contact the help desk
CG006BDay-time interval overflow
Expansion Precision of day-time interval value is too small
Action Contact the help desk
CG0088 Interval field overflow
Expansion An interval value has overflowed the maximum number of digits in its leading field
Action Examine your query and data; then try again
CG0100Arithmetic overflow
Expansion You have tried to multiply values to a sum beyond the implementation limit
Action Check your program logic; then try again
CG0101Division by zero
Expansion You have tried to divide by zero
Action Check your program logic; then try again
CG0102Invalid Trim specification
Expansion An attempt was made to TRIM a character string which contained an invalid specification
Action Correct the data or request; then try again
CG0103Insufficient string space for operation
Expansion An attempt was made to CAST a character string into another data type but there is insufficient space to complete the operation
Action Correct the data or request; then try again
CG0104Bad regular expression
Expansion The regular expression is incorrectly formatted
Action Correct the data or request; then try again
CG0105Not enough memory to generate code
Expansion Not enough memory to generate code
Action Either simplify the query, or free up some memory
CG0106Internal code generator error
Expansion an internal error has occurred
Action contact support
CG0107Internal error running generated code
Expansion an internal error has occurred
Action contact support
CG0108Null value inserted into non-null column
Expansion Null value inserted into non-null column
Action add a 'where field is not null' to the query or make target nullable
CG0109Invalid month parameter given to PACKDATE(year, month, day)
Expansion Only values of 'month' where 1<=month<=12 are allowed when using PACKDATE
Action Correct the data or request; then try again
CG010BToo many plugin functions used
Expansion The SQL query uses too many plugins in one expression
Action Simplify the query
CG010CCardinality error
Expansion A row was joined to more than one row where this is not allowed
Action Check query
CG010EGenerate key is invalid in this context
Expansion The generate_key function was used somewhere where it is not allowed
Action Check query
CG010AInvalid day parameter given to PACKDATE(year, month, day)
Expansion The day of the month must be between 1 and 28, 29, 30, or 31 (depending on the month and leap year)
Action Correct the data or request; then try again
CG010DInvalid parameter given to TIME(H, M, S)
Expansion The time function must be given valid values 0-23,0-59,0-59
Action Correct the data or request; then try again
CG0110Internal Error: Index register allocation failed
Expansion This is an internal error, contact support.
Action contact support
CG0111Internal Error: Column projection too big
Expansion Attempted to project a column into a space that was too small.
Action contact support
CG0112Internal Error: Lookup value is NULL
Expansion Attempted to use a NULL value as an internal array index.
Action contact support
CG0113Internal Error: Lookup value not found
Expansion Unable to find a lookup value in an internal array.
Action contact support
CG0114Internal Error: saved bucket queue is full
Expansion This should never happen, something should drain it.
Action contact support
CG0115Internal Error: Unable to restart access stream
Expansion The query attempted to restart an unrestartable operation.
Action contact support
CG0116Internal Error: Varchar data is corrupted
Expansion An internal data structure became corrupted.
Action contact support
CG0117Internal Error: Hint record leakage
Expansion A hint record leaked into an incorrect place.
Action contact support
CG0118The number of buckets in width_bucket() must be at least 1
Expansion Change the number of buckets so that it is greater than zero
Action Correct the data or request; then try again
CG0119The range in width_bucket must be non-zero
Expansion The min and max values specified in width_bucket() are equal
Action Correct the data or request; then try again
CG011ANo match found for join record
Expansion A record did not join to any records in a lookup table
Action Correct the data or request; then try again
CG011BSAME_VALUE found different values
Expansion The SAME_VALUE aggregate received different non-NULL values, but they should all be the same
Action Correct the data or request; then try again
CG011CONE_VALUE found multiple values
Expansion The ONE_VALUE aggregate received multiple non-NULL values, but they should be at most one
Action Correct the data or request; then try again
CG011DInternal error, invalid disk block passed to scan.
Expansion A disk scan was passed a block which does not contain a valid forward chain of records for the appropriate table
Action Contact support
CG011EInvalid binary record length from external source
Expansion An external program outputed a binary record with an invalid length.
Action Check query and external source (script or table)
CG011FPartial binary record from external source
Expansion An external program sent a partial binary record and then terminated.
Action Check query and external source (script or table)
CG0120A string contained a partial character
Expansion A string in the database contains an incomplete character (e.g. 2 bytes of a utf-32).
Action Check data and contact support
CG0122Incorrect value size for cast from binary
Expansion A value was cast from a binary to a type with incompatible length.
Action Check binary casts in the query and correct
CG0123Internal error -- Incorrect lengths for approx count distinct merge
Expansion The server tried to merge two approx distinct lists of different lengths. This should not happen
Action Contact support
CG0124Internal error: imported record sent with invalid length
Expansion A record imported using wxloader, wximport or an external table or script has been presented for conversion with an invalid length on it.
Action Contact support.
CG0125External text record too long
Expansion A CSV or other text record obtained from an external connector or script appears to be longer than the implementation limit.
Action Check the external data for long records.
CG0126External text record too long: encountered a record which is either too long or contains an unterminated quote
Expansion A CSV or other text record obtained from an external connector or script appears to be longer than the implementation limit. This may be because a record is very large, or because a record contains an unmatched quote. More information may be found in serverdbg or in SYS.IPE_CONV_ERROR.
Action Check the external data for long records or unmatched quotes, or check serverdbg and SYS.IPE_CONV_ERROR.
CG0181Plugin failure
Expansion The plugin is in safe mode and has crashed
Action contact plugin vendor to resolve the problem or debug
CG0182Undefined plugin error
Expansion A plugin returned an undefined error code
Action Contact the plugin vendor for support
CG0183Module %S: %T
Expansion The plugin module returned an error string
Action Contact the plugin vendor for support
CG0184The plugin returned a string of the wrong length
Expansion The plugin module returned a string of the wrong length
Action Contact the plugin vendor for support
CG0185Ambiguous type for string argument to plugin function
Expansion There are multiple possible types to convert the string argument into.
Action Use an explicit cast from string to the correct type
CG0200Substring error
Expansion An attempt was made to perform a Select Substring which contained an invalid specification
Action Correct the data or request; then try again
CG0201Insufficient string memory
Expansion An attempt was made to perform a string operation for which there was insufficient memory
Action Correct the data or request; then try again
CG0202Character string too long
Expansion An attempt was made to insert a character string that exceeds the defined length of a column
Action Correct the data or request; then try again
CG0203Invalid character value for cast
Expansion An attempt was made to CAST a character string into another data type but it contained characters that could not be converted
Action Correct the data or request; then try again
CG0204Numeric overflow during conversion
Expansion An attempt was made to CAST a character string into another data type but this resulted in an overflow
Action Correct the data or request; then try again
CG0205Numeric underflow during conversion
Expansion An attempt was made to CAST a character string into another data type but this resulted in an underflow
Action Correct the data or request; then try again
CG0206minchars parameter to string function too large or negative
Expansion The value specified for the minchars parameter to a string function was not in the range of allowed values
Action Correct the data or request; then try again
CG0207Invalid value specified for base parameter to string function
Expansion The value specified for the base parameter to a string function was not an allowed value
Action Correct the data or request; then try again
CG0208Invalid character value for string function
Expansion An attempt was make to use a string function such as strtoint() or strpackints() on an invalid string
Action Correct the data or request; then try again
CG0209Invalid 'count' parameter for string function
Expansion strunpackints() or strpackints() was called with an invalid 'count' parameter
Action Correct the data or request; then try again
CG020AInvalid 'bits' parameter for string function
Expansion strunpackints() or strpackints() was called with an invalid 'bits' parameter
Action Correct the data or request; then try again
CG020B'bits' * 'count' > 64 in strunpackints()
Expansion Too many bits specified for strunpackints
Action Correct the data or request; then try again
CG020CInvalid separator for string function
Expansion strunpackints() strpackints() strcount() or strchop() was called with a separator that was not a char(1)
Action Correct the data or request; then try again
CG020DZeroth element selected as strpos(,,0) or strchop(,,0,) or strchop(,,,0)
Expansion Only none zero positive or negative values are allowed for the 'start' and 'end' parameters to strchop() and the 'occurence' parameter to strpos()
Action Correct the data or request; then try again
CG020EAttempt to search for a zero length string
Expansion The second parameter given to strpos() evaluated to a zero length string
Action Correct the data or request; then try again
CG020FAttempt to strpackints() a string with too few segments
Expansion The string given to strpackints() did not contain as many segments as were specified in the count argument.
Action Correct the data or request; then try again
CG0210Attempt to strpackints() a string with too many segments
Expansion The string given to strpackints() contained more segments than were specified in the count argument.
Action Correct the data or request; then try again
CG0211Product of count and bits params to strpackints greater than 64
Expansion The result of strpackints is limited to 64 bits, so count*bits must be between 0 and 64.
Action Correct the data or request; then try again
CG0212Result of strunpackints too large for format
Expansion The number to be unpacked by strunpackints was too large to fit in the output format.
Action Correct the data or request; then try again
CG0213String wrong length for function
Expansion The string supplied is of the wrong length for the function
Action Correct the data or request; then try again
CG0214Invalid string representation
Expansion There was a string with an invalid representation for its character set.
Action Contact the help desk
CG0215Codepoint not in character set
Expansion There was a character not available in the destination character set during conversion.
Action Correct the data or request; then try again
CG0216Unknown character set
Expansion An unknown character set was specified.
Action Contact the help desk
CG0217Bad number of octets per character
Expansion There was an invalid number of octets per character defining a character set.
Action Contact the help desk
CG0218Bad translation table range
Expansion There was an invalid translation table defining a character set.
Action Contact the help desk
CG0219Internal error in character conversion
Expansion An unknown error occurred while doing a character set conversion.
Action Contact the help desk
CG0250Invalid string for to_number
Expansion An invalid string was supplied to to_number()
Action Check your SQL statement; then try again
CG0251Invalid format string
Expansion An invalid format string was used
Action Check your SQL statement; then try again
CG0252Invalid format string
Expansion An invalid date specifier was used
Action Check your SQL statement; then try again
CG0253Bad value in date string
Expansion The date string contained an bad value
Action Check your SQL statement; then try again
CG0254Internal error - ran out of digits!
Expansion An internal error occurred
Action Contact the help desk
CG0255Too many significant digits passed to to_number
Expansion Too many significant digits were passed to to_number() - use an explicit cast
Action Check your SQL statement; then try again
CG0256Invalid day number
Expansion An invalid day number was specified
Action Check your SQL statement; then try again
CG0257No year was specified
Expansion No year was specified
Action Check your SQL statement; then try again
CG0258FX specified but wrong number of digits
Expansion Invalid input - FX specified but wrong number of digits
Action Check your SQL statement; then try again
CG2003Query aborted
Expansion
Action

CI error codes

CI0001Internal error (Global CI): Please contact Kognitio
Expansion An internal compiler or interpreter error has occurred
Action Contact the help desk
CI0002Global feature not yet implemented
Expansion An SQL feature has not yet been implemented in the generic code
Action Contact the help desk
CI0008Internal error (Bad data type): Please contact Kognitio
Expansion An internal compiler or interpreter error has occurred
Action Contact the help desk
CI0011Insufficient memory
Expansion There is insufficient memory to compile or run this request
Action Free some server memory and try again
CI0012Internal memory allocation too large (%S bytes requested)
Expansion A request was made for an invalid amount of memory
Action Contact the help desk
CI0013Memory allocation inconsistency
Expansion A request was made to allocate or reallocate undefined memory
Action Contact the help desk
CI0014Transient buffer overflow
Expansion The request required more space than was available in the internal transient buffer
Action Simplify the request and try again
CI0021Internal error (Bad old-style data type): Please contact Kognitio
Expansion An internal error occurred
Action Contact the help desk
CI0022Internal error (Bad old-style numeric type): Please contact Kognitio
Expansion An internal error occurred
Action Contact the help desk
CI0023Internal error (Bad old-style length): Please contact Kognitio
Expansion An internal error occurred
Action Contact the help desk
CI0024Internal error (Bad compressed data map hash algorithm): Please contact Kognitio
Expansion The compressed data map hash algorithm must be either SIMPLE or SIMPLE_REV
Action Contact the help desk
CI0025Table cannot have empty name
Expansion A table was specified with an empty name
Action Do not use empty table names
CI0026Column cannot have empty name
Expansion A column was specified with an empty name
Action Do not use empty column names
CI0027Too many privileges
Expansion This request requires more privileges than can be managed by the compiler
Action Contact the help desk
CI0028Internal error (Ext addresses for temporary table): Please contact Kognitio
Expansion An attempt was made to get ext addresses for a table where the header type indicates that it does not have ext addresses
Action Contact the help desk
CI0029Names or aliases cannot consist only of spaces
Expansion You tried to create a name or an alias that conists only of spaces
Action Contact the help desk
CI0030Internal error (Out of stack space): Please contact Kognitio
Expansion The SQL compiler ran out of stack space while trying to compile the query
Action Contact the help desk
CI0031Internal error (Replay failure): Please contact Kognitio
Expansion Something went wrong with query replay
Action Contact the help desk
CI0032Error raised from %S line %C (backtrace %K)
Expansion Debugging error message identifying the location where the error was raised
Action Contact the help desk
CI0033GULError caught under DEBUG CRASH but ci_allow_crash not set
Expansion DEBUG CRASH is not allowed to crash the database unless ci_allow_crash is set (or you are SYS)
Action Contact the help desk
CI0065Invalid date value
Expansion Operation produced an invalid date value
Action Contact the help desk
CI0067Invalid timestamp value
Expansion Operation produced an invalid timestamp value
Action Contact the help desk
CI0068Invalid time value
Expansion Operation produced an invalid time value
Action Contact the help desk
CI006AYear-month interval overflow
Expansion Precision of year-month interval value is too small
Action Contact the help desk
CI006BDay-time interval overflow
Expansion Precision of day-time interval value is too small
Action Contact the help desk
CI0088 Interval field overflow
Expansion An interval value has overflowed the maximum number of digits in its leading field
Action Examine your query and data; then try again
CI0100Internal error (Invalid QDB %S index %T): Please contact Kognitio
Expansion The qdb index is invalid
Action Contact the help desk
CI0101QDB: invalid data ref %S %T, start %C, len %K
Expansion The qdb data reference is invalid
Action Contact the help desk
CI0102QDB: invalid subtype %S for table %T
Expansion The subtype for the table is invalid for its type
Action Contact the help desk
CI0103QDB: buffer self-reference, %S %T
Expansion A QDB allocation refers to itself; this may cause inconsistencies
Action Contact the help desk
CI0109Invalid month parameter given to PACKDATE(year, month, day)
Expansion Only values of 'month' where 1<=month<=12 are allowed when using PACKDATE
Action Correct the data or request; then try again
CI010AInvalid day parameter given to PACKDATE(year, month, day)
Expansion The day of the month must be between 1 and 28, 29, 30, or 31 (depending on the month and leap year)
Action Correct the data or request; then try again
CI010DInvalid parameter given to TIME(H, M, S)
Expansion The time function must be given valid values 0-23,0-59,0-59
Action Correct the data or request; then try again
CI0181Plugin failure
Expansion The plugin is in safe mode and has crashed
Action contact plugin vendor to resolve the problem or debug
CI0182Undefined plugin error
Expansion A plugin returned an undefined error code
Action Contact the plugin vendor for support
CI0183Module %S: %T
Expansion The plugin module returned an error string
Action Contact the plugin vendor for support
CI0184The plugin returned a string of the wrong length
Expansion The plugin module returned a string of the wrong length
Action Contact the plugin vendor for support
CI0185Ambiguous type for string argument to plugin function
Expansion There are multiple possible types to convert the string argument into.
Action Use an explicit cast from string to the correct type
CI0201Insufficient string memory
Expansion A request required more dynamic string space than was available
Action Contact the help desk
CI0202Character string too long
Expansion An attempt was made to insert a character string that exceeds the defined length of a column
Action Correct the request and retry
CI0203Invalid character value for cast
Expansion An attempt was made to cast a badly formed string
Action Correct the data and retry the request
CI0204Numeric overflow during conversion
Expansion The request generated a result that was too large to be represented
Action Correct the data and retry the request
CI0205Numeric underflow during conversion
Expansion The request generated a result that was too small to be represented
Action Correct the data and retry the request
CI0250Invalid string for to_number
Expansion An invalid string was supplied to to_number()
Action Check your SQL statement; then try again
CI0251Invalid format string
Expansion An invalid format string was used
Action Check your SQL statement; then try again
CI0252Invalid format string
Expansion An invalid date specifier was used
Action Check your SQL statement; then try again
CI0253Bad value in date string
Expansion The date string contained an bad value
Action Check your SQL statement; then try again
CI0254Internal error - ran out of digits!
Expansion An internal error occurred
Action Contact the help desk
CI0255Too many significant digits passed to to_number
Expansion Too many significant digits were passed to to_number() - use an explicit cast
Action Check your SQL statement; then try again
CI0256Invalid day number
Expansion An invalid day number was specified
Action Check your SQL statement; then try again
CI0257No year was specified
Expansion No year was specified
Action Check your SQL statement; then try again
CI0258FX specified but wrong number of digits
Expansion Invalid input - FX specified but wrong number of digits
Action Check your SQL statement; then try again
CI1001Internal error (Lexer): Please contact Kognitio
Expansion An internal error occurred in the Lexical Analyser
Action Contact the help desk
CI1002Lexical feature not yet implemented
Expansion An SQL feature has not yet been implemented in the lexical analyser
Action Contact the help desk
CI1010Unterminated quote, starting at offset %S
Expansion The request contained an open quote with no terminating quote
Action Correct the request and try again
CI1011Unterminated double quote, starting at offset %S
Expansion The request contained an open double quote with no terminating quote
Action Correct the request and try again
CI1012Identifier %S is too long, offset %T
Expansion The length of an identifier exceeded the implemantation maximum size
Action Amend the SQL; then try again
CI1013Syntax error at character with ASCII value %S, offset %C
Expansion An invalid character was found in the request string
Action Check your SQL statement; then try again
CI1014Empty identifier not allowed
Expansion An empty identifier ("") was used
Action Check your SQL statement; then try again
CI1015Identifier %S beginning with hash character, offset %C
Expansion Identifiers beginning "#" are reserved
Action Check your SQL statement; then try again
CI1016Character string too long
Expansion The length of a string exceeded the implementation maximum size
Action Check your SQL statement; then try again
CI1017Bad binary string
Expansion A binary string was specified with non-hexadecimal digits or an odd number of digits
Action Check your SQL statement; then try again
CI2002Syntax feature not yet implemented
Expansion An SQL feature has not yet been implemented in the syntax analyser
Action Contact the help desk
CI2003Query aborted
Expansion Your query was aborted
Action Find out why your query was aborted before trying to rerun it
CI2004Internal error (Syntax): Please contact Kognitio
Expansion An internal error occurred in the Syntax Analyser
Action Contact the help desk
CI2011Internal error (SQL string is NULL): Please contact Kognitio
Expansion The compiler was passed an invalid SQL string
Action Contact the help desk
CI2012Syntax error near %S, offset %C %K
Expansion A syntax error was detected in the user's SQL at the specified offset in the text
Action Correct your SQL and try again
CI2013Expected %S at or near %T, offset %C %K
Expansion A syntax error was detected in the user's SQL where certain constructs were expected
Action Correct your SQL and try again
CI2014AUTHORIZATION missing
Expansion A syntax error was detected in the user's SQL where the AUTHORIZATION keyword was expected
Action Correct your SQL and try again
CI2015Transaction control statement
Expansion A Commit or Rollback was encountered, but this is not valid SQL
Action Contact the help desk
CI2020Bad precision: %S, offset %T
Expansion An invalid value was specified for a data type's precision
Action Correct your SQL and try again
CI2021Bad scale: %S, offset %T
Expansion An invalid value was specified for a data type's scale
Action Correct your SQL and try again
CI2022Bad interval data type near %S, offset %T
Expansion An invalid interval type was specified for a data type definition
Action Correct your SQL and try again
CI2023A compiler hint cannot use a query to get hash exception values
Expansion A compiler hint says "RANDOM/REPLICATED IN (query)"
Action Correct your SQL and try again
CI2026Bad precision for compressed data map statistics
Expansion Where defined, the precision for compressed data map statistics must be a non-zero, positive integer
Action Correct your SQL and try again
CI2030Bad date value: %S, offset %T
Expansion An invalid literal date value was specified
Action Correct your SQL and try again
CI2031Bad time value: %S, offset %T
Expansion An invalid literal time value was specified
Action Correct your SQL and try again
CI2032Bad timestamp value: %S, offset %T (errcode %C)
Expansion An invalid literal timestamp value was specified
Action Correct your SQL and try again
CI2033Bad interval value near %S, offset %T (errcode %C)
Expansion An invalid literal interval value was specified
Action Correct your SQL and try again
CI2034Parameter name too long (maximum %S characters)
Expansion The specified parameter name is too long
Action Correct your SQL and try again
CI2035Parameter name must be in 7-bit ASCII
Expansion The specified parameter name contains characters not in 7-bit ASCII
Action Correct your SQL and try again
CI203ANumeric underflow in %S
Expansion A literal number was too small to be represented
Action Correct your SQL and try again
CI203BNumeric overflow in %S
Expansion A literal number was too large to be represented
Action Correct your SQL and try again
CI203CToo many reference columns
Expansion A single-column foreign key may only reference a single column
Action Correct your SQL and try again
CI203EIncorrect arguments to function '%S', offset %C
Expansion Too many or too few arguments were passed to an SQL function
Action Correct your SQL and try again
CI203FNon-existent property in ALTER TABLE SET statement
Expansion Only 'name', 'owner' and 'schema' may be SET in an ALTER statement
Action Correct your SQL and try again
CI2040Ambiguous privilege statement
Expansion The domain cannot be deduced from the privileges, use ON [USER/TABLE] etc.
Action Correct your SQL and try again
CI2041Privilege not valid in domain
Expansion You cannot use this privilege in the domain specified.
Action Correct your SQL and try again
CI2042Privilege '%S' does not exist
Expansion The privilege specified does not exist.
Action Correct your SQL and try again
CI2043Two privileges are from different domains
Expansion You cannot combine privileges from different domains
Action Correct your SQL and try again
CI2044Cannot apply aggregate privileges to this domain
Expansion Aggregate privileges are not applicable here.
Action Correct your SQL and try again
CI2045Invalid module mode '%S'
Expansion Module mode selected is not valid
Action Use a module mode of SAFE, ACTIVE or INACTIVE
CI2046Plugin Modules are disabled
Expansion Plugin Modules have beed disabled on this system
Action Re-enable plugin modules
CI2047Duplicate WITH name %s
Expansion A WITH name has been used twice
Action Change your query to use unique WITH names
CI2048Nested WITH clauses
Expansion You cannot nest WITH clauses
Action Remove the nested WITH clauses
CI2049Object given for system-wide privilege
Expansion You cannot apply system-wide privileges to an object
Action Correct your SQL and try again
CI2050Bad numeric value for TOP
Expansion You specified a bad value for the TOP number
Action Change the value
CI2051You cannot use TOP in this query - to fix, order by a specific column, not a number
Expansion TOP cannot cope if there is a * in the select list and you order by a number
Action Change the order by clause to specify a column
CI2052WITH can only be used at the start of a query expression
Expansion You can only put WITH at the start of a query expression.
Action Check your SQL; then try again
CI2053You cannot use TOP in a query with a qualified star (eg SELECT TOP 5 A.* FROM A)
Expansion TOP cannot cope if there is a qualified * in the select list.
Action Remove the qualified * if possible.
CI2054The same attribute has been specified more than once in the list
Expansion An attribute has been used more than once in the sec class
Action Remove the duplicates
CI2055Invalid Unicode escape character
Expansion The UESCAPE escape character for a Unicode string literal or identifier must be a single character
Action Check your SQL; then try again
CI2056Invalid Unicode escape sequence
Expansion A Unicode string literal or identifier contains an invalid sequence following the UEscape character
Action Check your SQL; then try again
CI2057No such window function '%S', offset %T
Expansion An unknown window function has been specified.
Action Check your SQL; then try again
CI2058An errorcode must be AAHHHH, eg CI2058
Expansion An errorcode in a bad format was specified
Action Check your SQL; then try again
CI2059You cannot repeat an element in ALTER LOGIN
Expansion An element is ALTER LOGIN has been specified more than once
Action Check your SQL; then try again
CI205AINTERNAL ERROR: AMBIGUOUS SYNTAX!! PLEASE SEND THIS QUERY TO KOGNITIO
Expansion Please report the SQL to Kognitio; the parser was unable to handle your query
Action Please report the SQL to Kognitio
CI205BYou can only have one WHEN MATCHED/NOT MATCHED clause in a MERGE INTO
Expansion You can only have one matched/not matched clause in a MERGE INTO
Action Check your SQL; then try again
CI205CYou must specify a password when creating a user
Expansion You must specify a password when creating a user
Action Check your SQL; then try again
CI205DYou must specify each attribute only once
Expansion You must specify each attribute only once
Action Check your SQL; then try again
CI205EYou cannot use the CURRENT_ functions in the fragmentation WHERE clause
Expansion You cannot use the CURRENT_ functions in the fragmentation WHERE clause
Action Check your SQL; then try again
CI205FYou cannot use subqueries, functions, or aggregates in the fragmentation WHERE clause
Expansion You cannot use subqueries in the fragmentation WHERE clause
Action Check your SQL; then try again
CI2060Internal error (SQL is not in UTF-8): Please contact Kognitio
Expansion The SQL query input is not in UTF-8.
Action Contact the help desk
CI2061Aggregate does not support DISTINCT or ALL
Expansion A set quantifier DISTINCT or ALL was given to a statistical aggregate
Action Check your SQL; then try again
CI2062The MAXDEPTH value must be between 1 and 100 inclusive
Expansion You specified a MAXDEPTH with an EXEC command, but it must be between 1 and 100 inclusive
Action Check your SQL; then try again
CI2063The MAXDEPTH value was set in SQL obtained from an EXEC SELECT
Expansion MAXDEPTH can only be specified with EXEC at the user level, not below
Action Check the SQL returned by the SELECT, then remove the MAXDEPTH from it
CI2064The MAXDEPTH has been reached in embedded EXEC SELECTs
Expansion The MAXDEPTH has been reached in embedded EXEC SELECTs
Action Ensure that there are no loops in the EXEC calls, or increase MAXDEPTH
CI2065Users cannot be created with lower case characters
Expansion Users cannot be created with lower case characters because they will not be able to log on
Action Check your SQL; then try again
CI2066NEW SYSTEM or UPGRADE on a running system
Expansion An attempt was made to run the NEW SYSTEM or UPGRADE command on a system with RAM images
Action Contact the help desk
CI2067Parameter value overflow
Expansion An attempt was set a parameter to too large or small a value
Action Check your SQL; then try again
CI2068A partition cannot contain CURRENT_, aggregates, functions, or subqueries
Expansion Change the partition so that it doesn't use something that it shouldn't
Action Check your SQL; then try again
CI2069Bad length: %S
Expansion An invalid value was specified for a data type's length
Action Correct your SQL and try again
CI206AA WINDOW clause called %S was specified more than once
Expansion A WINDOW clause with the given name was specified more than once
Action Correct your SQL and try again
CI206BThe Principal name is too long
Expansion Use a shorter Principal name
Action Correct your SQL and try again
CI206CYou cannot specify both TOP n and LIMIT n
Expansion The query specifies both a TOP n and a LIMIT n clause
Action Correct your SQL and try again
CI206DExpected %Send of request (batched statements are deprecated but will be allowed if parameter ci_allowbatch is set to 1) at offset %C %K
Expansion Multiple "batched" statements have been submitted as a single SQL query; support for this is deprecated. Perhaps you forgot to terminate a statement with a semicolon? (Setting parameter ci_allowbatch to 1 will suppress this error.)
Action Correct your SQL and try again
CI206EPREJOINS are deprecated
Expansion PREJOINS are deprecated and will be removed in a future release. Set the global parameter ci_prejoins to 1 to use them
Action Correct your SQL and try again
CI206FYou cannot use LISTAGG (DISTINCT...) - use a derived table
Expansion You cannot use LISTAGG (DISTINCT...) - use a derived table to perform the DISTINCTion
Action Correct your SQL and try again
CI2080Internal error (Expr stack underflow): Please contact Kognitio
Expansion Please report the SQL to Kognitio; the parser was unable to handle your query
Action Please report the SQL to Kognitio
CI2081Internal error (Cond stack underflow): Please contact Kognitio
Expansion Please report the SQL to Kognitio; the parser was unable to handle your query
Action Please report the SQL to Kognitio
CI2082Internal error (Pred stack underflow): Please contact Kognitio
Expansion Please report the SQL to Kognitio; the parser was unable to handle your query
Action Please report the SQL to Kognitio
CI2083Internal error (From ref stack underflow): Please contact Kognitio
Expansion Please report the SQL to Kognitio; the parser was unable to handle your query
Action Please report the SQL to Kognitio
CI2084Internal error (Query spec stack underflow): Please contact Kognitio
Expansion Please report the SQL to Kognitio; the parser was unable to handle your query
Action Please report the SQL to Kognitio
CI2085Internal error (Bison stack overflow): Please contact Kognitio
Expansion Please report the SQL to Kognitio; the parser was unable to handle your query
Action Please report the SQL to Kognitio
CI2086Parser memory exhausted
Expansion Your SQL has exhausted the memory available to the parser
Action Contact the help desk
CI3001Internal error (Resolver): Please contact Kognitio
Expansion An internal error occurred in the Resolver
Action Contact the help desk
CI3002Resolver feature not yet implemented
Expansion An SQL feature has not yet been implemented in the resolver
Action Contact the help desk
CI3011Schema %S does not exist, offset %T
Expansion The SQL referenced a schema which does not exist
Action Check your SQL; then try again
CI3012User or group %S does not exist
Expansion The SQL referenced an user which does not exist
Action Check your SQL; then try again
CI3013Table %S.%T does not exist, offset %C
Expansion The SQL referenced a table which does not exist
Action Check your SQL; then try again
CI3014View %S.%T does not exist, offset %C
Expansion The SQL referenced a view which does not exist
Action Check your SQL; then try again
CI3015Column %S.%T.%C does not exist
Expansion The SQL referenced a column which does not exist
Action Check your SQL; then try again
CI3016No columns in create table
Expansion A create table request does not include any columns
Action Check your SQL; then try again
CI3017Duplicate column name %S not allowed
Expansion Each column in the list must have a unique name
Action Check your SQL statement; then try again
CI3018Unique column %S must be NOT NULL
Expansion When you create a table, all columns in unique or primary keys must be defined as NOT NULL
Action Check your SQL; then try again
CI3019Column %S is not part of the associated create table request
Expansion A create table request refers to a local column that does not exist
Action Check your SQL; then try again
CI301AMore than one primary key
Expansion A create table request contains more than one primary key
Action Check your SQL; then try again
CI301BView %S.%T references itself
Expansion You are attempting to create a view which references itself
Action Check your SQL; then try again
CI301CInternal error (Table id larger than USER_TABLE_END): Please contact Kognitio
Expansion Attempt to create a table whose id would be larger than the maximum currently allowable
Action Contact the help desk
CI301DOperation invalid on a view
Expansion Your SQL specified an operation which cannot be performed on a view
Action Check your SQL; then try again
CI301E%S.%T is a view
Expansion Your SQL specified a view where a table was expected
Action Check your SQL; then try again
CI301F%S.%T is not a view
Expansion The SQL referenced a view which does not exist
Action Check your SQL; then try again
CI3020Column type definition in create table select
Expansion Column type definitions are not permitted in create table for/from select statements
Action Correct your SQL; then try again
CI3021Column default in create table select column definitions
Expansion Column defaults are not permitted in create table for/from select statements
Action Correct your SQL; then try again
CI3022Not null column definition in create table select column definitions
Expansion Not null column definitions are not permitted in create table for/from select statements
Action Correct your SQL; then try again
CI3023Unique declaration in create table select column definitions
Expansion Unique declarations are not permitted in create table for/from select statements
Action Correct your SQL; then try again
CI3024Primary key declaration in create table select column definitions
Expansion Primary key declarations are not permitted in create table for/from select statements
Action Correct your SQL; then try again
CI3025Check clause declaration in create table select column definitions
Expansion Check clause declarations are not permitted in create table for/from select statements
Action Correct your SQL; then try again
CI3026Foreign key declaration in create table select column definitions
Expansion Foreign key declarations are not permitted in create table for/from select statements
Action Correct your SQL; then try again
CI3027Column type declaration missing from create table
Expansion Column type declarations are required in create table statements which do not incorporate a select statement
Action Correct your SQL; then try again
CI3028Number of column names does not match number of select columns
Expansion The number of column names supplied in the create table does not match the number of columns returned by the select
Action Correct your SQL; then try again
CI3029Column type declaration missing from external script definition
Expansion Column type declarations are required in external script definitions
Action Correct your SQL; then try again
CI3031Procedure %S does not exist
Expansion Your SQL referenced a procedure which does not exist
Action Check your SQL; then try again
CI3032Snapshot %S does not exist
Expansion Your SQL referenced a snapshot which does not exist
Action Check your SQL; then try again
CI3033Security class %S does not exist
Expansion Your SQL referenced a security class which does not exist
Action Check your SQL; then try again
CI3034Security class for a user does not exist
Expansion The server was unable to locate your security class details
Action Contact the help desk
CI3035Ambiguous column %S%K
Expansion A column name referenced in your SQL cannot be uniquely resolved
Action Add qualifiers where necessary; then try again
CI3036Table name %S used rather than alias %T
Expansion Once an alias has been defined for a table then the table name can no longer be used
Action Use the alias rather than the table name
CI3037Remote server %S does not exist
Expansion Your SQL referenced a remote server which does not exist
Action Check your SQL; then try again
CI3038No IPE_FILE in current schema
Expansion Your SQL required a reference to IPE_FILE but no such table exists in the current schema
Action Check your schema; then try again
CI3039NFS file %S for server %T does not exist
Expansion Your SQL referenced a server for which no entry in IPE_REM_SERVER exists
Action Check your SQL; then try again
CI303ANo NFS user details
Expansion Your SQL required an NFS connection but no NFS user details exists for your user name
Action Contact your system administrator
CI303BDuplicate object alias or name %S
Expansion An alias or name was used twice for two different objects
Action Correct your SQL; then try again
CI303CDuplicate column alias %S
Expansion An alias name was used twice for two different columns
Action Correct your SQL; then try again
CI303DLocal IPE_FILE is not in RAM
Expansion Your import or export operation requires that the IPE_FILE table in your current schema be fully in RAM
Action Load IPE_FILE into RAM; then try again
CI303EAmbiguous object %S
Expansion An object name referenced in your SQL cannot be uniquely resolved
Action Add qualifier or aliases where necessary; then try again
CI303FTable with id %S does not exist, offset %C
Expansion The SQL referenced a table which does not exist
Action Check your SQL; then try again
CI3040Parameter ci_use_statsonly is set and we tried to get a cardinality without a predicate
Expansion A very specific error condition occurred
Action Check your SQL; then try again
CI3041External script with id %S does not exist, offset %C
Expansion The SQL referenced an external script which does not exist
Action Check your SQL; then try again
CI3051Identifier %S not declared%K
Expansion An identifier could not be resolved
Action Correct your SQL; then try again
CI3052Object %S not declared%K
Expansion The table or view specified does not exist in the scope
Action Correct your SQL; then try again
CI3061Internal error (Bad statement type): Please contact Kognitio
Expansion Bad Statement Type
Action Contact the Helpdesk.
CI3062No columns in table
Expansion System tables contain no column info for this table
Action Contact the Helpdesk.
CI3063Internal error (Scope is NULL): Please contact Kognitio
Expansion Internal Error
Action Contact the Helpdesk.
CI3064 No base row for %S.%T
Expansion System tables contain no base row for table.
Action Contact the Helpdesk.
CI3065No view row for %S.%T
Expansion System tables missing info for this view.
Action Contact the Helpdesk.
CI3066No column rows
Expansion System tables missing info for 1 or more columns.
Action Contact the Helpdesk.
CI3067No column img rows
Expansion System tables missing info for 1 or more columns.
Action Contact the Helpdesk.
CI3068Wrong number of column rows
Expansion System tables missing info for 1 or more columns.
Action Contact the Helpdesk.
CI3069No SQL fragments row for %S.%T
Expansion System tables missing info for this view.
Action Contact the Helpdesk.
CI3070Aggregate privileges cannot contain column references
Expansion You cannot specify column privileges in an aggregate privilege.
Action Correct your SQL; then try again
CI3071Invalid grant/revoke privilege request
Expansion Your statement attempted an invalid grant or revoke operation
Action Correct your SQL; then try again
CI3072Connector '%S' already exists
Expansion A connector of this name already exists
Action Correct your SQL; then try again
CI3073Connector '%S' does not exist
Expansion No connector with this name exists
Action Correct your SQL; then try again
CI3074Connector '%S' is inactive
Expansion The specified connector is not active
Action Correct your SQL; then try again
CI3075Script environment '%S' already exists
Expansion A script environment of this name already exists
Action Correct your SQL; then try again
CI3076Script environment '%S' does not exist
Expansion No script environment with this name exists
Action Correct your SQL; then try again
CI3077External script '%S.%T' already exists
Expansion An external script of this name already exists
Action Correct your SQL; then try again
CI3078External script '%S.%T' does not exist
Expansion No external script with this name exists
Action Correct your SQL; then try again
CI30D6Invalid (user) command given for group %S
Expansion A user command was given which is not appropriate for a group
Action Use the appropriate group command
CI30D7Invalid (group) command given for user %S
Expansion A group command was given which is not appropriate for a user
Action Use the appropriate user command
CI30D8Plugin Module '%S' is already defined
Expansion A plugin module of this name already exists
Action Choose a different module name
CI30D9Plugin Module '%S' does not exist
Expansion No plugin module with this name exists
Action Choose a different module name
CI30E0Temporary table not allowed
Expansion A temporary table is not allowed here
Action Correct your SQL and try again
CI30E1Cannot specify schema for temporary table
Expansion A temporary table cannot be created in a particular schema
Action Correct your SQL and try again
CI30E2Integrity not allowed for temporary table
Expansion Temporary tables cannot have UNIQUE, PRIMARY, FOREIGN or REFERENCES
Action Correct your SQL and try again
CI30E3Queue '%S' does not exist
Expansion No queue with this name exists
Action Choose a different queue name
CI30E4Queue '%S' already exists
Expansion A queue with this name already exists
Action Choose a different queue name
CI30E5Unknown character set
Expansion The query specifies a character set that does not exist
Action Correct your SQL and try again
CI30E6Variable-length character encodings cannot be used with CHAR
Expansion Variable-length character encodings (such as UTF-8) can only be used with VARCHAR, not CHAR
Action Correct your SQL and try again
CI30E7Scalar subqueries cannot have outer references (%S in this case) when used like that
Expansion You used a scalar subquery with outer references in a situation where you cannot do that
Action Correct your SQL and try again
CI30E8Bad value for parameter def_table_loc when creating table
Expansion You tried to create a table but the default table location parameter def_table_loc is unknown
Action Correct the parameter and try again
CI30E9Your query uses view %S.%T, which is invalidated
Expansion Your query uses view %S.%T, which is invalidated
Action Correct your SQL and try again
CI30EAIPE_FILE in current schema has bad prototype
Expansion Your import or export operation requires that the IPE_FILE table in your current schema has the same definition as SYS.IPE_FILE
Action Check your schema; then try again
CI30EBInternal error (STINotNull assert failed: %S): Please contact Kognitio
Expansion An internal assertion failed; a line has been logged to the cidebug file indicating where the failure occurred
Action Inform Kognitio of the problem
CI30ECInternal error (The default schema does not exist): Please contact Kognitio
Expansion An attempt was made to SET SCHEMA DEFAULT but the default schema does not exist
Action Inform Kognitio of the problem
CI30EDA schema must be specified; the default schema does not exist
Expansion An attempt was made to use a table but the default schema does not exist
Action Inform Kognitio of the problem
CI30EEExternal script with a partition mode specified but no partition columns
Expansion It is not valid for an external script to have a partition mode when there are no partition columns.
Action Correct your SQL and try again
CI30EFYou cannot have an ORDER BY clause here
Expansion You cannot use an ORDER BY clause like that
Action Check your SQL; then try again
CI30F0You cannot have a LIMIT or FETCH FIRST clause here
Expansion You cannot use a LIMIT or FETCH FIRST clause like that
Action Check your SQL; then try again
CI30F1You cannot specify DISK ONLY with RAM qualifiers
Expansion If you are creating a DISK ONLY table you cannot specify a fragmented image, a distribution, RAM ONLY or DISK.
Action Check your SQL; then try again
CI30F2Operation not valid on %S.%T because it has an invalid image; recreate or drop image to proceed
Expansion You tried to use a table or view image with an old image generation number indicating that it was not successfully imaged by the most recent CREATE IMAGE. Use CREATE MAINTENANCE IMAGE FOR TABLE/VIEW to try imaging again, DROP TABLE/VIEW IMAGE to drop the image, DROP TABLE/VIEW to drop the object completely or CREATE IMAGE to recreate all object images.
Action Check your SQL; then try again
CI4001Internal error (Semantic Analyser): Please contact Kognitio
Expansion An internal error occurred in the Semantic Analyser
Action Contact the help desk
CI4002Semantic feature not yet implemented
Expansion An SQL feature has not yet been implemented in the semantic analyser
Action Contact the help desk
CI4005Internal error (Conversion value overflow): Please contact Kognitio
Expansion The compiler attempted to generate a conversion value that was too large
Action Contact the help desk
CI4008Internal error (Bad data type): Please contact Kognitio
Expansion An internal compiler or interpreter error has occurred
Action Contact the help desk
CI4010Operation invalid for group PUBLIC
Expansion You cannot perform this operation on the public group.
Action Correct your SQL and try again
CI4011Object %S.%T is not a table
Expansion The object referred to in the table request is not a table
Action Correct the request and try again
CI4012Object %S.%T is not a view
Expansion The object referred to in the view request is not a view
Action Correct the request and try again
CI4013Object %S.%T is not a procedure
Expansion The object referred to in the procedure request is not a procedure
Action Correct the request and try again
CI4014Object %S.%T already has a RAM image
Expansion The new image cannot be created since a RAM image already exists
Action No action required
CI4015Object %S.%T has no RAM image
Expansion There is no image to be dropped for the specified object
Action No action required
CI4016Incorrect distribution
Expansion An attempt was made to create a replicated fragmented image but this is not a valid combination
Action Choose a different distribution, either hashed or random
CI4017Too many privileges
Expansion This request requires more privileges than can be managed by the compiler
Action Contact the help desk
CI4018Too many columns
Expansion The number of columns in this table or view exceed the maximum allowed
Action Contact the help desk
CI4019Table or view is too wide
Expansion The width of the table or view exceeds the maximum row size
Action Contact the help desk
CI401AOnly the sys user can create views based on the system views
Expansion Only the sys user can create views based on the SYS.IPE_ views
Action Do not create views that use the SYS.IPE_ views
CI4020Invalid dynamic parameter type
Expansion A parameter was defined with an unrecognised data type
Action Contact the help desk
CI4021Special invoke - no parameters
Expansion This special invoke request must have no parameters
Action Correct the request and try again
CI4022Invalid time zone value
Expansion The value given for a time zone was out of range
Action Correct the request and try again
CI4023Password is shorter than style allows
Expansion The user's security class defines a minimum password length, which the supplied password does not reach
Action Use a longer password and try again
CI4024Password fails style requirements
Expansion The user's security class defines the style of password, with which the supplied password does not comply
Action Correct the password and try again
CI4025Invalid Security Class style entry
Expansion The user's security class style is not valid
Action Consult your System Administrator
CI4026Invalid password
Expansion The password supplied does not match the user's old password
Action Correct the password and retry the request
CI4027Password re-used too recently
Expansion The password you entered has been used previously and the reuse interval for your user ID prevents its reuse
Action Choose a different password and retry
CI4028Invalid parameter name
Expansion The name of the specified parameter is too long
Action Check your SQL statement; then try again
CI4029No columns left in table
Expansion You cannot delete columns in a table so that there are none left
Action Check your SQL statement; then try again
CI402AOld password required to change user's own password
Expansion If you are changing your own password you must specify the old one
Action Correct the password and retry the request
CI4031Only the System User may issue this request
Expansion This request can only be issued by the system user
Action Consult your System Administrator
CI4032Illegal operation on system table %S.%T
Expansion You are attempting an illegal operation on a system table
Action No action required
CI4033Illegal operation on view image %S.%T
Expansion It is not possible to update or delete from view images
Action No action required
CI4034No authority to drop the schema
Expansion You do not hold the privilege to drop the specified schema
Action Consult your System Administrator
CI4035Schema is not empty (contains tables or views)
Expansion A schema cannot be dropped with the RESTRICT option if it contains objects
Action Either empty the schema or specify the CASCADE option
CI4036No authority to drop the user
Expansion You do not hold the privilege to drop the specified user
Action Consult your System Administrator
CI4037The CASCADE or INVALIDATE DEPENDENT VIEWS options must be used to drop or alter objects on which views depend
Expansion Your drop or alter request specified or implied Restrict and the object has dependents
Action Either drop the dependent views manually, use the Cascade option, or use the Invalidate Dependent Views option
CI4038Illegal operation on virtual table
Expansion It is not possible to perform the specified operation on this virtual table
Action No action required
CI4039View %S.%T is not updatable
Expansion In order to perform this request on a view then the view must be updatable
Action No action required
CI403AColumn %S has a data map
Expansion A request has been made to build a data map for a column for which a data map has already been built
Action No action required
CI403CColumn %S has no data map
Expansion A request has been made to drop the data map for a column where no such data map has been built
Action No action required
CI403DTable %S.%T has no data maps
Expansion A request has been made to drop all data maps for a table but no such data maps have been built
Action No action required
CI403EMaximum of 6 columns allowed
Expansion A maximum of 6 columns can be specified in any one update compressed data map statistics statement
Action Correct your SQL; then try again
CI4041Duplicate column name %S not allowed
Expansion Each column in the list must have a unique name
Action Check your SQL statement; then try again
CI4042Hash column %S is not in the RAM fragment
Expansion Columns used for hashing the RAM image must be present in that image
Action Modify the SQL statement to hash only on the RAM columns and try again
CI4043Duplicate privileges present in request
Expansion The grant or revoke request mentions the same privilege more than once
Action Remove the duplicate privilege and try again
CI4044Update privilege on a non-updatable view
Expansion The grant or revoke request cannot specify a modify privilege for a view that cannot be modified
Action Remove the modify privileges and try again
CI4045Privilege refers to a table
Expansion You are only permitted to grant and revoke this privilege on a table
Action Check your SQL statement; then try again
CI4046Privilege refers to a view
Expansion You are only permitted to grant and revoke this privilege on a view
Action Check your SQL statement; then try again
CI4047Duplicate processor id %S
Expansion The statement contains more than one reference to the same processor
Action Remove the duplicate reference and try again
CI4048Processor %S is not a disk
Expansion The processor supplied for the disk operation is not a disk processor
Action Correct the processor number and try again
CI4049Rack %S does not exist
Expansion The number supplied does not identify a valid rack
Action Correct the rack number and try again
CI404AMore exceptions than hash columns
Expansion The number of exception values specified is more than the number of columns in the hash list
Action Correct your SQL; then try again
CI404BMore hash columns than exceptions
Expansion The number of exception values specified is less than the number of columns in the hash list
Action Correct your SQL; then try again
CI404CInvalid exception value for column %S%K
Expansion The data type of an exception value does not match the data type of the related hash column
Action Correct your SQL; then try again
CI404DToo many exception values
Expansion The number of exception values specified is more than the maximum allowed for an image
Action Correct your SQL; then try again
CI404ENo exception values
Expansion Attempting to create a partially hashed table reusing existing hash exception values, but no such values exist
Action Correct your SQL; then try again
CI404FHash replicated table %S.%T with unique key
Expansion It's not possible to create a hash replicated image of a table which has a unique index or primary key
Action Correct your SQL; then try again
CI4051Insufficient privilege for this request
Expansion You do not have the required privilege for this statement
Action Consult your System Administrator
CI4052View column has no name
Expansion The view contains an expression column that has not been assigned a name
Action Check your SQL; then try again
CI4053Number of view columns in %S.%T does not match query
Expansion The number of names in the view column name list does not match the number of columns present in the view query
Action Check your SQL; then try again
CI4054CHECK OPTION but view %S not updatable
Expansion The view specified is not updatable but the WITH CHECK OPTION clause was present; this clause is only valid for updatable view
Action Check your SQL; then try again
CI4055Duplicate object name %S not allowed
Expansion Each table or view in the list can only be mentioned once
Action Check your SQL statement; then try again
CI4056Cursor is not updatable
Expansion An attempt was made to declare a cursor for update, but the cursor's select query is not updatable
Action Check your SQL; then try again
CI4057View id larger than USER_TABLE_END
Expansion Attempt to create a view whose id would be larger than the maximum currently allowable
Action Contact the help desk
CI4058CHECK OPTION not supported with subquery predicates
Expansion The view has CHECK OPTION specified, which is not supported when it has predicates containing subqueries
Action Check your SQL; then try again
CI405FModulus operator not valid for operand with non-zero scale
Expansion Operands with non-zero scale are not valid in this context
Action Check your SQL; then try again
CI4060Data type mismatch for type %S%K
Expansion The data type of an expression is not valid in this context
Action Check your SQL; then try again
CI4061Data type mismatch between %S and %T%K
Expansion The data type of an expression is not valid in this context
Action Check your SQL; then try again
CI4062Bad cast length
Expansion The target data type for an expression is too small
Action Check your SQL; then try again
CI4063Cannot gather statistics on %S.%T - not in RAM
Expansion You can only run this kind of Update Statistics when that object is loaded into memory
Action Create an image of the object and then try again
CI4064Cannot coerce data types in UNION column %s%k
Expansion The data types in the UNION are not coercable
Action Check your SQL; then try again
CI4065Invalid escape character
Expansion The escape character in a LIKE predicate must be a single character literal or dynamic parameter
Action Check your SQL; then try again
CI4066Case has no non-null branches
Expansion At least one branch of a case expression must be non-null
Action Check your SQL; then try again
CI4067Insufficient dynamic parameters
Expansion The SQL contained more dynamic parameter markers than actual dynamic parameter values passed
Action Check your SQL; then try again
CI4068Non-local JOIN ON inequality predicate
Expansion The ON clause in the JOIN phrase contains a predicate that is neither local nor an equals predicate
Action Check your SQL; then try again
CI4069Cannot gather statistics for %S.%T.%C - not in RAM
Expansion You can only run this kind of Update Statistics when the column is loaded into memory
Action Create an image of the object which includes the column and then try again
CI406ABad subquery usage
Expansion Your SQL contained an invalid use of a subquery
Action Check your SQL; then try again
CI406BCannot coerce data types in CASE branch %s%K
Expansion The data types in the CASE results are not coercable
Action Check your SQL; then try again
CI406CIllegal use of subquery in JOIN ON clause
Expansion The ON clause in the JOIN phrase must not contain a subquery predicate
Action Check your SQL; then try again
CI406DIllegal use of NOT in JOIN ON clause
Expansion The ON clause in the JOIN phrase must not contain a NOT operator
Action Check your SQL; then try again
CI406EIllegal use of OR in JOIN ON clause
Expansion The ON clause in the JOIN phrase must not contain an OR operator
Action Check your SQL; then try again
CI406FThe JOIN ON clause contains no join equality
Expansion The ON clause in the JOIN phrase must contain at least one join equality predicate
Action Check your SQL; then try again
CI4070Illegal parameter for LIKE%K
Expansion The parameter for a LIKE predicate is incorrect; use literal text or a dynamic parameter
Action Check your SQL; then try again
CI4071Illegal parameter for MATCHING%K
Expansion The parameter for a MATCHING predicate is incorrect; use literal text or a dynamic parameter
Action Check your SQL; then try again
CI4072Column %S is not part of the associated create request
Expansion A create request refers to a local column that does not exist
Action Check your SQL; then try again
CI4073Primary key not found for foreign reference
Expansion You have attempted to reference the primary key of a table where no such key exists
Action Check your SQL; then try again
CI4074Alter cannot add a unique column
Expansion When altering a table a new column cannot be defined as unique in case rows exist in the table since duplicate NULL values will be placed in the new column
Action Remove this clause; then try again
CI4075Alter / Add NOT NULL requires default
Expansion When altering a table a new column cannot have a NOT NULL clause if no default value is defined
Action Either remove the NOT NULL clause or add a DEFAULT clause
CI4076Duplicate column name %S
Expansion When altering a table a new column must have a unique name
Action Change the column name and try again
CI4077Column %S references a column of different type
Expansion A foreign key references a primary key with different data type
Action Check your SQL; then try again
CI4078Unique key not found for foreign reference
Expansion You have attempted to reference a table in which the specified columns do not form a unique key
Action Check your SQL; then try again
CI4079Foreign reference column count mismatch
Expansion The number of columns in the references clause is inconsistent
Action Check your SQL; then try again
CI407AForward reference in column %S default
Expansion The default value supplied for the specified column refers to a column later in the Create Table; this is not valid
Action Correct your SQL; then try again
CI4080Foreign column %S does not exist
Expansion A foreign key references a non-existant column
Action Check your SQL; then try again
CI4081Set null reference is not null
Expansion Attempt to use the 'SET NULL' referential integrity option when the column is defined as NOT NULL
Action Modify your SQL statement and try again
CI4082Set default reference has no default
Expansion Attempt to use the 'SET DEFAULT' referential integrity option when no default value is defined for the column
Action Modify your SQL statement and try again
CI4087Request requires a global lock
Expansion This request requires a global session lock
Action First obtain the global session lock; then try again
CI4088Global session lock already acquired
Expansion A global session lock is already in place for this session
Action None
CI4091Invalid insert expression for column %S
Expansion The insert statement contains an expression that is invalid in this context
Action Amend your SQL; then try again
CI4092Number of columns does not match number of values%K
Expansion The number of columns selected must match the number of values in an insert statement
Action Amend your SQL; then try again
CI4093Column %S is not nullable
Expansion It is not possible to place the NULL value in a column that has the not null attribute
Action Amend your SQL; then try again
CI4094Column %S has no default
Expansion Cannot insert a default value to a column that has no default
Action Amend your SQL; then try again
CI4095Column cannot be assigned twice
Expansion An update statement can only update a column with one value
Action Amend your SQL; then try again
CI4096Number of aliases does not match number of columns
Expansion The number of column aliases must match the number of columns selected in a derived table
Action Amend your SQL; then try again
CI4097Invalid sequence number for order by
Expansion The sequence number in an order must identify a selected column
Action Amend your SQL; then try again
CI4098Invalid column reference for order by%K
Expansion The column reference in an order must identify a selected column
Action Amend your SQL; then try again
CI4099Bad default precision for column %S
Expansion The default value for the specified column has a precision which is too large for the column
Action Amend your SQL; then try again
CI409ABad default type for column %S%K
Expansion The default value for the specified column has a data type inconsistent with the column
Action Amend your SQL; then try again
CI409BInsert data type mismatch for column %S%K
Expansion The insert value for the specified column has a data type inconsistent with the column
Action Amend your SQL; then try again
CI409CUpdate data type mismatch for column %S%K
Expansion The update value for the specified column has a data type inconsistent with the column
Action Amend your SQL; then try again
CI409DExternal script data type mismatch for column %S
Expansion The data type of the column in the subquery has a data type inconsistent with that defined in the external script
Action Amend your SQL; then try again
CI409EWrong number of inputs for external script %S
Expansion The external script has a different number of subqueries in the query from that in in its definition
Action Amend your SQL; then try again
CI409Forder by non-integer sequence number%K
Expansion The order by clause contained an invalid sequence number
Action Amend your SQL; then try again
CI40A0Wrong number of expressions for input for external script %S
Expansion The definition of the external script's input has a different number of expressions than that in the subquery
Action Amend your SQL; then try again
CI40A1Schema %S already exists
Expansion It is not possible to create two schemas with the same name
Action Choose a new schema name; then try again
CI40A2User or group %S already exists
Expansion It is not possible to create users or groups with the same name as an existing user or group
Action Choose a new name; then try again
CI40A3Table or view %S.%T already exists, offset %C
Expansion It is not possible to create two tables or views with the same name
Action Choose a new name; then try again
CI40A4Snapshot %S already exists
Expansion It is not possible to create two snapshots with the same name
Action Choose a new name; then try again
CI40A5Schema name %S is different from user name
Expansion You have tried to create a schema with a different name from that of the current user; this request requires the same schema name
Action Use the same schema name or try a different form of the request
CI40A6Foreign references exist
Expansion A table cannot be dropped while foreign references to it exist
Action First drop the refering table and then retry the request
CI40B0Aggregate not allowed%K
Expansion An aggregate is not allowed in this context
Action Amend your SQL; then try again
CI40B1Select expression %T (%S)%K is not being grouped, offset %C
Expansion All select items which are not aggregates must be in the group by clause
Action Amend your SQL; then try again
CI40B2Aggregate of an aggregate not allowed%K
Expansion You are not permitted to aggregate an aggregate, e.g. SELECT MAX(SUM(Status))
Action Consider using a derived table; then try again
CI40B3Bad sequence number in Group By
Expansion The Group By clause contained an invalid sequence number
Action Amend your SQL; then try again
CI40B4Bad expression in Group By clause
Expansion The Group By clause contained an invalid expression
Action Amend your SQL; then try again
CI40B5Row Value Constructor not allowed, offset %T
Expansion A row value constructor is not allowed in this context
Action Amend your SQL; then try again
CI40B6Distinct used more than once
Expansion Only one distinct modifier can appear in each select request
Action Amend your SQL; then try again
CI40B7Aggregate combined with columns
Expansion An expression contains an invalid mix of aggregates and column references
Action Amend your SQL; then try again
CI40B8Incorrect use of Row Value Constructor, offset %T
Expansion A row value constructor was compared with a scalar value; RVCs can only be compared to other RVCs
Action Amend your SQL; then try again
CI40B9Incorrect Row Value Constructor degree, offset %T
Expansion The number of elements in a row value constructor does not match the number of elements in the comparing row value constructor
Action Amend your SQL; then try again
CI40BAIncorrect union degree%K
Expansion The number of columns in the queries on each side of the UNION do not match
Action Amend your SQL; then try again
CI40BBIncorrect subquery degree, offset %T
Expansion The degree of the subquery does not match the degree of the associated row value constructor
Action Amend your SQL; then try again
CI40BCHaving requires grouping or aggregation
Expansion A having clause requires a group-by clause or all selected expressions to be aggregates
Action Amend your SQL; then try again
CI40BDIllegal identifier in having clause%K
Expansion The only identifiers permitted in a having clause are group-by columns or aggregates
Action Amend your SQL; then try again
CI40BEMixed aggregates and non-aggregates%K
Expansion When no group by clause is present, the select list must be all aggregates or all non-aggregates
Action Amend your SQL; then try again
CI40BFGrouping by a literal that is not in the select list%K
Expansion You cannot group by a literal that is not in the select list and which cannot be interpreted as a column number
Action Amend your SQL; then try again
CI40C0Incorrect batching of statements
Expansion The mix of statements in the batch is not valid
Action Consider splitting the SQL statements into separate requests
CI40C1Request cannot be pictured
Expansion The specified request has no query path and so cannot be pictured
Action Consider using explain instead
CI40C8Grouping on an aggregate is not allowed%K
Expansion An aggregate is not allowed in this context
Action Amend your SQL; then try again
CI40C9Aggregate not allowed in a conditional expression
Expansion An aggregate is not allowed in this context
Action Amend your SQL; then try again
CI40CAAggregate not allowed in an IN list
Expansion An aggregate is not allowed in this context
Action Amend your SQL; then try again
CI40CBAggregate not allowed in WHERE clause%K
Expansion An aggregate is not allowed in this context
Action Amend your SQL; then try again
CI40CCAggregate not allowed in ON clause
Expansion An aggregate is not allowed in this context
Action Amend your SQL; then try again
CI40CDCannot alter same property of table twice in same statement
Expansion You cannot alter the same property twice in the same ALTER statement
Action Amend your SQL; then try again
CI40CEInvalid predicate for a correlated update
Expansion A correlated update predicate can only use an equality comparison on the table to be updated.
Action Amend your SQL; then try again
CI40CFToo many correlated update statements in update
Expansion An update statement can only contain one correlated update.
Action Amend your SQL; then try again
CI40D0Mixed correlated and non correlated updates
Expansion You cannot combine a correlated and non-correlated update.
Action Amend your SQL; then try again
CI40D1Cannot perform correlated update on a view
Expansion You cannot perform a correlated update on a view.
Action Amend your SQL; then try again
CI40D2Cannot combine correlated and uncorrelated predicates with OR
Expansion You cannot OR correlated and uncorrelated predicates in a correlated update.
Action Amend your SQL; then try again
CI40D3Cannot perform operation on a ram-only table
Expansion This action is invalid for ram only tables.
Action Amend your SQL; then try again
CI40D4Cannot use replicated ram-only table
Expansion Ram-only tables cannot be replicated.
Action Amend your SQL; then try again
CI40D5Bad integrity constraint (Ram only and not Ram only Tables)
Expansion Bad integrity constraint (Ram only and not Ram only Tables)
Action Amend your SQL; then try again
CI40D6Invalid (user) command given for group %S
Expansion A user command was given which is not appropriate for a group
Action Use the appropriate group command
CI40D7Invalid (group) command given for user %S
Expansion A group command was given which is not appropriate for a user
Action Use the appropriate user command
CI40D8Duplicate group name %S not allowed
Expansion Each group in the list must have a unique name
Action Amend your SQL; then try again
CI40D9Identical user and group names
Expansion It is not possible to create a user with the same name as a group
Action Amend your SQL; then try again
CI40DAInvalid Check Constraint
Expansion Table create text contains an unsupported check constraint
Action Amend your SQL; then try again
CI40DBDuplicate user/group name %S not allowed
Expansion The statement lists the same user/group name more than once
Action Amend your SQL; then try again
CI40DCGroup %S self-reference
Expansion A group cannot be a member of itself
Action Amend your SQL; then try again
CI40DDPlugin Module function name too long
Expansion The plugin function you have tried to use has too long a name
Action Amend your SQL; then try again
CI40DEFunction '%S' not found%K
Expansion The function you have tried to use cannot be found
Action Amend your SQL; then try again
CI40DFNo valid prototype for Plugin function '%S'%K
Expansion The plugin name is known, but the arguments dont match any known function
Action Check your plugin arguments.
CI40E0Cannot create a disk based ram only table
Expansion A ram only table cannot have an image located on disk only.
Action Amend your SQL; then try again
CI40E1Cannot create a ram only table with a fragmented image
Expansion A ram only table cannot have a fragmented image.
Action Amend your SQL; then try again
CI40E2Cannot create a disk based fragmented table
Expansion A table which is located only on disk cannot also have a fragmented image.
Action Amend your SQL; then try again
CI40E3wx_????() functions can only be used with base tables
Expansion wx internal attributes such as create tno, etc, can only be obtained from base tables
Action Amend your SQL; then try again
CI40E4Cannot coerce data types in argument list element %s%K
Expansion The data types in the list of values are not coercable
Action Check your SQL; then try again
CI40E5Cannot aggregate on expression containing inner and outer references
Expansion You cannot aggregate on an outer reference and an inner reference (Sql92 6.5.4)
Action Check your SQL; then try again
CI40E6Outer reference Aggregate not allowed in WHERE subquery clause
Expansion An aggregate is not allowed in this context
Action Amend your SQL; then try again
CI40E7You cannot create a fragmented view image
Expansion Fragmented view images are not allowed
Action Create a VI of a more restrictive view
CI40E8Operation invalid on table with a RAM image
Expansion This operation is not valid on tables with a ram image.
Action Either drop the image, or redefine the image.
CI40E9Partial hashing distribution neither RANDOM nor REPLICATED
Expansion You must specify one of RANDOM or REPLICATED
Action Use a valid distribution
CI40EAPartial hashing distribution given where none required
Expansion A partial hashing distribution (RANDOM or REPLICATED) is not valid here
Action Do not specify a distribution
CI40EBInsert hashed statistics only supports one column
Expansion You can only provide disk hashing information for one column
Action Use one column
CI40ECIncorrect intersect degree%K
Expansion The number of columns in the queries on each side of the INTERSECT do not match
Action Amend your SQL; then try again
CI40EDIncorrect except degree%K
Expansion The number of columns in the queries on each side of the EXCEPT do not match
Action Amend your SQL; then try again
CI40EEInvalid scale for timestamp()
Expansion The timestamp function requires a literal scale
Action Amend your SQL; then try again
CI40EFInvalid or non-constant length for l/rpad
Expansion The l,rpad functions require a literal size
Action Amend your SQL; then try again
CI40F0Conditional expression mixes aggregates and non-aggregates
Expansion You cannot mix aggregates and non aggregates in this context
Action Amend your SQL; then try again
CI40F1Generate_Key only allowed in select list
Expansion You can only use the Generate_Key function in the select list of a query
Action Amend your SQL; then try again
CI40F2Module not in a valid mode
Expansion You can only reload a module if it is currently in a valid mode (active, inactive, safe)
Action Amend your SQL; then try again
CI40F3Duplicate Module parameter given
Expansion You can refer to a plugin module parameter once in the request
Action Amend your SQL; then try again
CI40F4You cannot have an RVC containing more than one column in a select list
Expansion Only single column RVC expressions, and non-RVCs can be used in a select list
Action Amend your SQL; then try again
CI40F5You must have an RVC here, offset %T
Expansion Only a row value constructor can be used here
Action Amend your SQL; then try again
CI40F6You must have a datetime data type, offset %T
Expansion Only a DATE, TIME or TIMESTAMP data type can be used here
Action Amend your SQL; then try again
CI40FAKey %S does not exist
Expansion There are no keys matching the string specified.
Action Check your SQL; then try again
CI40FBWindow functions only allowed in select list
Expansion You can only use a window function in the select list of a query
Action Amend your SQL; then try again
CI40FCWindow functions not allowed in aggregates or window functions
Expansion You cannot use a window function in an aggregate or a window function
Action Amend your SQL; then try again
CI40FDWindow function has invalid bounds
Expansion The bounds you have specified for a window function are not allowed
Action Amend your SQL; then try again
CI40FENTILE argument or LAG/LEAD offset must be a positive integer
Expansion The parameter you specified for a window function is not allowed
Action Amend your SQL; then try again
CI40FFslab argument is not a slab in the system
Expansion The parameter you specified for a slab argument is not a valid slab id for this system
Action Correct the slab id and try again
CI4101Window function does not allow window frame
Expansion You have specified a window frame (ROWS or RANGE) for a window function that does not allow it
Action Amend your SQL; then try again
CI4102You can only specify a (+) outer join condition in the WHERE clause
Expansion You have specified (+) in the SELECT, FROM or HAVING clauses
Action Amend your SQL; then try again
CI4103ALL quantifier not supported for EXCEPT and INTERSECT
Expansion You have specified ALL for EXCEPT or INTERSECT which is not supported
Action Amend your SQL; then try again
CI4104Too many grouping sets in GROUP BY clause
Expansion The GROUP BY clause you have specified is too complex.
Action Amend your SQL; then try again
CI4105Too many expressions in GROUPING operation
Expansion The GROUPING() operation you have specified has too many arguments.
Action Amend your SQL; then try again
CI4106GROUPING can only apply to group expressions
Expansion You can only use the GROUPING() operation on expressions in the GROUP BY list.
Action Amend your SQL; then try again
CI4107GROUPING is only allowed in the select and having clauses
Expansion You can only specify the GROUPING() operation in the SELECT and HAVING clauses.
Action Amend your SQL; then try again
CI4108Can only group by column in GROUPING SETS, CUBE and ROLLUP
Expansion You can only specify a column name for GROUPING SETS, CUBE and ROLLUP in the GROUP BY list.
Action Amend your SQL; then try again
CI4109You are changing a view that has dependent views, but the number of columns has changed
Expansion You are changing a view that has dependent views, but the number of columns has changed
Action Either change the view definition so that it matches, or drop dependent views.
CI4110You are changing a view that has dependent views, but column %S has changed its name or datatype
Expansion You are changing a view that has dependent views, but a column has changed its name or type.
Action Either change the view definition so that it matches, or drop dependent views.
CI4111The name of the security class is too long
Expansion The security class name exceeds the 32 character limit.
Action Make it shorter.
CI4112The minimum length of passwords is too long.
Expansion The minimum length of passwords exceeds the 32 character limit.
Action Make it shorter.
CI4113You cannot specify a value of 0
Expansion You must use a value greater than zero.
Action Make it greater than zero.
CI4114You cannot drop required attributes
Expansion You cannot drop required security class attributes
Action Remove the relevant drop clauses
CI4115One or more required security class attributes (%S) was not present
Expansion A required security class attribute was not specified.
Action Specify the required security class attribute.
CI4116Security class '%S' already exists
Expansion A security class with this name already exists
Action Choose a different name
CI4117Security class %S does not exist
Expansion Your SQL referenced a security class which does not exist
Action Check your SQL; then try again
CI4118The security class id already exists
Expansion A security class with this id already exists
Action Choose a different id
CI4119You cannot drop the SYS user
Expansion Nobody can drop the SYS user; even SYS can't do it.
Action Stop trying to drop the SYS user
CI411AYou can specify a user or a sec_class, but not both
Expansion You can specify a user or a sec_class, but not both
Action Remove either the user name or the sec_class
CI411BIN or EXISTS is used in the view definition, so the right expression can't be found on the base tables
Expansion You are inserting, updating, or deleting from a view. However, we cannot determine the members on the base tables.
Action Alter your query
CI411CYou cannot use TOP <n> in a subquery with outer references
Expansion You have a correlated subquery with a TOP <n> limit on the number of rows to return. We can't handle that.
Action Alter your query
CI411DA subquery with >1 column has been used where only a scalar (ie 1 column) subquery can be used
Expansion You have a subquery which selects more than one column, but it can only sensibly select one column.
Action Alter your query
CI411EA CASE statement containing a subquery is being used in an unhandled context (in an aggregate, with no FROM, with GROUP BY, or with aggregates/winfuncs in other parts of the select clause)
Expansion You have a CASE statement that contains a subquery, but it is being used in a context that we don't handle.
Action Alter your query, perhaps by using a derived table
CI411FYou cannot set the slabs for a RAM-only table
Expansion You are trying to set the disk slabs to be used for a table that is RAM-only.
Action Alter your query
CI4120Star needs tables
Expansion You cannot select * if you do not specify tables
Action Alter your query
CI4121The SELECT is not updatable
Expansion In order to perform this request on a select then the select must be updatable
Action No action required
CI4122Incorrect VALUES degree
Expansion The number of columns in each branch of the VALUES do not match
Action Amend your SQL; then try again
CI4123Cannot coerce data types in VALUES column %s%K
Expansion The data types in the VALUES are not coercable
Action Check your SQL; then try again
CI4124The slabs can only be changed for user tables
Expansion You can only change the slabs for user tables
Action Check your SQL; then try again
CI4125The character set has a different number of octets per character
Expansion The character sets must have the same number of octets per character
Action Check your SQL; then try again
CI4126A FROM clause is required for that SELECT list
Expansion A FROM clause is required for that SELECT list
Action Check your SQL; then try again
CI4127You cannot change that property of an object on which views depend
Expansion You cannot change that property of an object on which views depend
Action Check your SQL; then try again
CI4128To change the owner of an object on which views depend you must use the FORCE option
Expansion To change the owner of an object on which views depend you must use the FORCE option
Action Check your SQL; then try again
CI4129Bad ON clause predicate: '%s'
Expansion That predicate does not specify the target alone on one side only
Action Check your SQL; then try again
CI412AA MERGE statement cannot update a column used in the ON clause
Expansion A MERGE statement cannot update a column used in the ON clause
Action Check your SQL; then try again
CI412BViews based on the system tables must start IPE_, however bear in mind that upgrades may cause them to break
Expansion Views based on the system tables must start IPE_
Action Rename the view to start IPE_
CI412CA view image cannot be created for a pure view
Expansion If a view is declared pure then it cannot be imaged
Action No action required
CI412DNULL must be cast to a data type%K
Expansion A bare NULL without a cast to a data type is not allowed here
Action Amend your SQL or turn off strict typing; then try again
CI412ECannot create a cycle of tables with foreign references
Expansion An attempt was made to create a cycle of tables with a foreign key (even if the foreign references themselves do not form a cycle) in a batched statement
Action Amend your SQL; then try again
CI412FCannot obtain row lock for table with no primary key
Expansion An attempt was made to obtain a row lock for a table on which no primary key is defined
Action Amend your SQL; then try again
CI4130Wrong number of key elements
Expansion The number of values supplied to obtain a row lock for a table has the wrong number of elements to match the primary key
Action Amend your SQL; then try again
CI4131Invalid value for primary key%K
Expansion One of the values supplied to obtain a row lock for a table has the wrong type for that position in the primary key
Action Amend your SQL; then try again
CI4132You cannot use RANDOM() in that context
Expansion The RANDOM() function cannot be called in that context
Action Amend your SQL; then try again
CI4133Cannot modify security class id
Expansion Your SQL attempted to modify the id for a security class, which is not allowed
Action Check your SQL; then try again
CI4134Invalid default value%K
Expansion Table create text contains an unsupported default value
Action Amend your SQL; then try again
CI4135Replicated ram-only tables cannot have integrity constraints
Expansion Table that are replicated and RAM-only cannot have integrity constraints
Action Amend your SQL; then try again
CI4136SQL statements run via EXEC cannot be SELECT/EXPLAIN/PICTURE/DIAGNOSE/DESCRIBE
Expansion SQL statements run via EXEC cannot be SELECT/EXPLAIN/PICTURE/DIAGNOSE/DESCRIBE
Action Amend your SQL; then try again
CI4137The SELECT used in EXEC must select only characters strings
Expansion Check the SELECT statement used by EXEC
Action Amend your SQL; then try again
CI4138Table sample percentages must be between 0 and 100
Expansion The percentage argument for TABLESAMPLE must be between 0 and 100
Action Amend your SQL; then try again
CI4139Cannot project wx_ramaddr or wx_ramproc from a disk table
Expansion You have tried to project wx_ramaddr() or wx_ramproc() which are not defined for disk-based tables
Action Amend your SQL; then try again
CI413ACannot project wx_diskaddr, wx_diskmpid or wx_diskptn from a ram-only table
Expansion You have tried to project wx_diskaddr(), wx_diskmpid() or wx_diskptn() which are not defined for ram-only tables
Action Amend your SQL; then try again
CI413BNo columns in select list
Expansion Your query selects no columns. This might be because the table in a qualified asterisk has only corresponding join columns (USING or NATURAL JOIN).
Action Amend your SQL; then try again
CI413COperation not valid on external table%S
Expansion External tables do not support operations such as integrity.
Action Amend your SQL; then try again
CI413DThough the signature of the view hasn't changed, it will depend on a newer object so CASCADE must be specified
Expansion CORV was specified with an unchanged signature, however it now depends on a newer object, so CASCADE must be specified.
Action Amend your SQL; then try again
CI413EThe CASCADE option must be used to drop or alter connectors on which external tables depend
Expansion Your drop or alter request specified or implied Restrict and the connector has dependents
Action Either drop the dependent tables manually or use the Cascade option
CI413FYou must prejoin with simple columns on both sides of the join
Expansion You must prejoin with simple columns on both sides of the join
Action Amend your SQL; then try again
CI4140The prejoin predicate must refer to both sides, not just one side (ie A.A1=B.A2 rather than A.A1=A.A2)
Expansion The prejoin predicate must refer to both sides, not just one side (ie A.A1=B.A2 rather than A.A1=A.A2)
Action Amend your SQL; then try again
CI4141The prejoin view must be of the form "select * from table"
Expansion The prejoin view must be of the form "select * from table"
Action Amend your SQL; then try again
CI4142The prejoin cannot happen as the join columns are not located on the same ramstore
Expansion The prejoin cannot happen as the join columns are not located on the same ramstore
Action Amend your SQL; then try again
CI4143The CASCADE option must be used to drop or alter script environments on which external scripts depend
Expansion Your drop or alter request specified or implied Restrict and the external script has dependent scripts
Action Either drop the dependent scripts manually or use the Cascade option
CI4144The CASCADE option must be used to drop or alter external scripts on which views depend
Expansion Your drop or alter request specified or implied Restrict and the external script has dependent views
Action Either drop the dependent views manually or use the Cascade option
CI4145Schema is not empty (contains external scripts)
Expansion A schema cannot be dropped with the RESTRICT option if it contains external scripts
Action Either empty the schema or specify the CASCADE option
CI4146View image %S.%T cannot be invalidated or altered as it is used by a prejoin
Expansion You are attempting to invalidate or alter a view image that is used by a prejoin
Action No action required
CI4147View image %S.%T is used by a prejoin, so CASCADE must be specified to drop the image
Expansion Specify "DROP VIEW [IMAGE] X CASCADE"
Action No action required
CI4148External script has variable arguments (...) in the output but not in any input
Expansion If an external script has variable arguments (...) declared in the output then at least one input must also have variable arguments.
Action Amend your SQL; then try again
CI4149External script output column %S has no declared type and no input column has the same name
Expansion Columns in external script outputs must either have a declared type or there must be a column in an input with the same name.
Action Amend your SQL; then try again
CI414AThe columns used in the prejoin predicate must have exactly the same type
Expansion The predicate used to do the prejoin must join two columns with exactly the same data type
Action Amend your lookup or fact table; then try again
CI414BValue range step overflow or zero
Expansion An attempt was use zero or too large a value for the STEP in a VALUES BETWEEN table
Action Check your SQL; then try again
CI414CCannot build a prejoin on a prejoin
Expansion You are trying to build a prejoin using a prejoined image, and a prejoined column is being used.
Action Check your SQL; then try again
CI414DInvalid image encoding attribute
Expansion You are trying to create an object with image encoding attributes that are not valid in this context.
Action Check your SQL; then try again
CI414ECannot evaluate outer reference from external script
Expansion You are trying to run an external script that has an outer reference, which is not supported.
Action Check your SQL; then try again
CI414FDuplicate external script parameter given
Expansion The statement defines the same parameter more than once for an external script.
Action Check your SQL; then try again
CI4150Invalid image partition specification
Expansion An invalid image partition specification was specified.
Action Check your SQL; then try again
CI4151The values inside a VALUES() list must be simple expressions
Expansion Inside VALUES() only use simple expression - in particular you can't use CASE or expressions like NULL+1.
Action Check your SQL; then try again
CI4152Invalid column reference for partition by
Expansion The column reference in an partition must identify a selected column
Action Amend your SQL; then try again
CI4153Prejoin to a compressed image %S.%T not allowed
Expansion It is not allowed to make a prejoin to a compressed image
Action Amend your SQL; then try again
CI4154Cannot drop statistics on %S.%T - not in RAM
Expansion You can only run this kind of Drop Statistics when that object is loaded into memory
Action Create an image of the object and then try again
CI4155A temporary table %S.%T already exists, offset %C
Expansion It is not possible to create a normal table with the same name as an existing temporary table (even from another session)
Action Choose a new name; then try again
CI4156The window %S is not defined
Expansion A window has been used without being defined in the WINDOW clause
Action Define the window in the WINDOW CLAUSE, or use the correct name
CI4157The bitcount for APPROXIMATE COUNT DISTINCT must be between 4 and 14 inclusive
Expansion The optional bitcount parameter for APPROXIMATE COUNT DISTINCT was set to an invalid value
Action Change the value to a number between 4 and 14
CI4158Operation only valid on external table
Expansion An external table operation that is was attempted on an object that is not an external table.
Action Amend your SQL; then try again
CI4159WITH DISTRIBUTIONS: %S is ambiguous
Expansion An entry in the WITH DISTRIBUTIONS list is ambiguous
Action Amend your SQL; then try again
CI415AWITH DISTRIBUTIONS: %S is defined more than once
Expansion An entry in the WITH DISTRIBUTIONS list is defined more than once
Action Amend your SQL; then try again
CI415BWITH DISTRIBUTIONS: unknown object %S
Expansion An entry in the WITH DISTRIBUTIONS list is not used
Action Amend your SQL; then try again
CI415CBad value used in the definition of a VALUES BETWEEN table
Expansion An attempt was use a bad expression in a VALUES BETWEEN table
Action Check your SQL; then try again
CI415DYou cannot rename the SYS user
Expansion The SYS user cannot be renamed.
Action Check your SQL; then try again
CI415EAn Object Id cannot be specified without an Object Type
Expansion Remove the Object Id or add an Object Type.
Action Check your SQL; then try again
CI415Fgenerate_key() is not allowed in aggregates
Expansion You cannot use generate_key() in an aggregate
Action Amend your SQL; then try again
CI4160You cannot order an image by generate_key()
Expansion You cannot use generate_key() in the order image by clause
Action Amend your SQL; then try again
CI4161Principal and user combination does not exist
Expansion There are no entries in the system that match the specified information
Action Check your SQL; then try again
CI4162Principal and user combination already exist
Expansion There is already an entry in the system that matches the specified information
Action Check your SQL; then try again
CI4163You cannot create a user FROM USER SYS
Expansion You cannot create a user using the SYS user as a template
Action Check your SQL; then try again
CI4164You cannot have ORDER IMAGE BY and ORDER BY
Expansion You cannot have an ORDER IMAGE BY clause if the view's SELECT is ordered
Action Check your SQL; then try again
CI4165Bad hash algorithm passed as first argument to XHASH_VALUE ()
Expansion The first argument to XHASH_VALUE() must be a valid hash algorithm number
Action Check your SQL; then try again
CI4166Cannot coerce data types in VALUES branch %s
Expansion The data types in the VALUES are not coercable
Action Check your SQL; then try again
CI4167The image partition is too complex
Expansion An invalid image partition specification was specified.
Action Check your SQL; then try again
CI4168You cannot do APPROX aggregates from that table type
Expansion You cannot do APPROX aggregates from that table type
Action Check your SQL; then try again
CI4169Complex GROUP BY expression has grouping set column component
Expansion You cannot GROUP BY an expression where any constituent column is part of a GROUPING SET, CUBE or ROLLUP (and the expression is not simply a column reference and the column is not present in every grouping set)
Action Check your SQL; then try again
CI4170The ON clause of a MERGE must have one join predicate between the source and the target
Expansion The ON clause must contain one predicate of the form SRC.COL = TGT.COL
Action Check your SQL; then try again
CI4171Creation of SYS schema objects is not allowed (use a different schema or change parameter sys_objects)
Expansion When the parameter sys_objects is set to 0, objects may not be created in the SYS schema
Action Check your SQL; then try again
CI4172You cannot drop your own user
Expansion You are trying to drop the currently logged in user, which is not allowed.
Action If this is intended, get another user to drop your user.
CI4173row_size(*) requires a table
Expansion You are performing row_size(*) without a table being present
Action Check your SQL; then try again
CI4174Top N cannot be specified directly either side of UNION/EXCEPT/INTERSECT
Expansion You cannot have a query that says "SELECT TOP n... UNION..."; use a derived table
Action Check your SQL; then try again
CI4175View %S.%T does not allow operation %C
Expansion The view does not allow the given operation because of privileges on underlying objects
Action Check your SQL; then try again
CI4177External table %S.%T does not support INSERT
Expansion You are trying to insert into an external table which does not support the INSERT operation.
Action Check your SQL; then try again
CI4178External table %S.%T does not support SELECT
Expansion You are trying to select from an external table which does not support the SELECT operation.
Action Check your SQL; then try again
CI4179Cannot image a disk-only table
Expansion This table has been created as DISK ONLY so cannot be imaged.
Action No action required
CI417AExternal connector %C does not support INSERT for table %S.%T
Expansion You are trying to create or insert into an external table using a connector that does not support the INSERT operation for that table's current definition. (The connector might have been altered since the table was defined.)
Action Check your SQL; then try again
CI417BExternal connector %C does not support SELECT for table %S.%T
Expansion You are trying to create or insert into an external table using a connector that does not support the SELECT operation for that table's current definition. (The connector might have been altered since the table was defined.)
Action Check your SQL; then try again
CI417CLISTAGG cannot be used as a window function
Expansion Performing this operation is unsupported.
Action Contact the help desk
CI5001Internal error (Generator): Please contact Kognitio
Expansion An internal error occurred in the Generator
Action Contact the help desk
CI5002Generator feature not yet implemented
Expansion An SQL feature has not yet been implemented in the code generator
Action Contact the help desk
CI5003Internal error (Invalid SCode generated): Please contact Kognitio
Expansion The SCode Generator detected an attempt construct invalid SCode
Action Contact the help desk
CI5004Too much SCode generated
Expansion The SCode Generator produced too much code to be passed back to the caller
Action Contact the help desk
CI5011Privilege does not exist
Expansion The revoke request could not revoke a privilege which does not exist
Action Correct your SQL; then try again
CI5012Privilege already exists
Expansion This grant request attempted to add a privilege which already exists
Action Correct your SQL; then try again
CI5020Default too complex
Expansion The default value for a column is too complex to record in the system tables
Action Simplify your SQL; then try again
CI5021Check clauses too complex
Expansion The check clauses on the create table request are too complex to record in the system tables
Action Simplify your SQL; then try again
CI5022Maximum view text length
Expansion The SQL text of your view definition is longer than that supported by the server
Action Simplify your SQL; then try again
CI5023Column specification overflow
Expansion The descriptions of the columns returned by your query are too complex
Action Simplify your SQL; then try again
CI5025No such compressed data map
Expansion A request has been made to drop a compressed data map which does not exist
Action No action required
CI5026Data maps exist for all columns with statistics
Expansion Data maps have already been built for all those columns in the specified table for which compressed data map statistics have been gathered
Action Use drop compressed data map and/or update statistics for compressed data map first
CI5027Inconsistent M and B values
Expansion An attempt was made to use compressed data map statistics containing inconsistent M and B values
Action Use update statistics for compressed data map first
CI5028Table creation text is too large to alter
Expansion The Alter Table statement attempted to locate the original create text for the table but could not find it, indicating the text was too long to be stored in the data dictionary
Action Contact the help desk
CI5029Column %S has no data map statistics
Expansion An attempt to create or drop a compressed data map referred to a column which has no data map statistics
Action Use update compressed data map statistics first
CI502ANo columns have data map statistics
Expansion Expansion: An attempt was made to create a compressed data map for which no valid data map statistics exist
Action Use update statistics for compressed data map first
CI502BBad raw query
Expansion The query against an IPE_RAW table was incorrectly stated
Action Contact the help desk
CI502CColumn %S data map statistics not current
Expansion An attempt to create a compressed data map referred to a column which has invalid data map statistics
Action Use update statistics for compressed data map first
CI502DNo compressed data map statistics for table %S
Expansion An attempt to drop compressed data map statistics referred to a table which has no compressed data map statistics
Action Correct your SQL; then try again
CI502ENo compressed data map statistics for column %S
Expansion An attempt to drop compressed data map statistics referred to a column which has no compressed data map statistics
Action Correct your SQL; then try again
CI502FCompressed data map exists for column %S
Expansion An attempt to drop compressed data map statistics referred to a column which has a compressed data map
Action Drop the compressed data map; then try again
CI5030Drop with circular references
Expansion The drop request attempts to remove a table for which circular references exist; this feature is not yet supported
Action Contact the help desk
CI5031Cascaded drop too complex
Expansion A cascaded drop contained too many levels of nesting.
Action Contact the help desk
CI5032Property cannot be altered - original definition too complex
Expansion The original table definition contained possible self references. The table cannot be altered without invalidating these.
Action Contact the help desk
CI5033New schema id too big
Expansion Schema ids must be lower than the smallest user table id
Action Contact the help desk
CI5034User/Group is not a member of Group
Expansion Group operation was given on a non-member of a group.
Action Contact the help desk
CI5035Expected a group identifier
Expansion A user was given where a group was expected.
Action Contact the help desk
CI5036Subquery updates to tables with foreign keys or check constraints are not supported
Expansion Updates from subqueries cannot be performed to tables with foreign keys or check constraints
Action Contact the help desk
CI5037Too many tables modified in statement
Expansion Your query tried to alter too many tables.
Action Contact the help desk
CI5038Bad bCNF was produced
Expansion An internal error meant that incorrect bCNF was generated.
Action Contact the help desk
CI5039Replacing the view like that would create a circularity (V1 uses V2 uses V1...)
Expansion You are trying to change the view definition in such a way that a circular list of view references would be created.
Action Contact the help desk
CI503A%S.%T is not an invalidated view
Expansion You are attempting to use a command that only applies to invalidated views
Action Correct your SQL
CI503BThere are no invalidated views in the system
Expansion There are no invalidated views in the system
Action No action required
CI503CYou cannot CREATE OR REPLACE view %S.%T as it is referenced elsewhere in these statements
Expansion You are CREATE OR REPLACEing a view, but that view is referred to elsewhere in these batched statements
Action Correct your SQL
CI503DYou cannot drop the compressed data map for a table that is horizontally fragmented in RAM; drop the image first
Expansion You are trying to drop a compressed data map for a table that is horizontally fragmented in RAM
Action Drop the image first, the drop the data map, then recreate the image
CI503ECannot drop schema cascade as it contains temporary tables created by a different session
Expansion You are trying to drop a schema cascade, but it contains temp tables created by a different session
Action Disconnect the other session, then try again
CI503FThe fragmenting predicate is too complex
Expansion The fragmenting predicate that you are using is too complex to be stored
Action Simplify the predicate if possible
CI5040A value specified in a VALUES() entry could not be evaluated
Expansion A value specified in a VALUES entry could not be evaluated (numeric overflow?)
Action Simplify the VALUES values if possible
CI5041That queue cannot be dropped as it has users assigned to it
Expansion You are trying to drop a queue that still have users
Action Drop the users first, then drop the queue
CI5042Statement would drop %S dependent objects which is more than parameter ci_max_drop_objs (which is set to %T)
Expansion You are trying to drop a table, view or external script that would cause more than ci_max_drop_objs dependent objects to be dropped; this is a sanity check to prevent large hierarchies from being dropped accidentally but you can change the parameter if you are sure that your query is correct.
Action Check your query and you are sure if it is correct set ci_max_drop_objs larger or to zero.
CI5043An external group with that name already exists
Expansion You are trying to create an external group using a name that already exists
Action Check that you are using the right name
CI5044An external group with that name does not exist
Expansion You are trying to do something with an external group using a name that does not exist in the system
Action Check that you are using the right name
CI5045USERS SHOULD NEVER SEE THIS - PLEASE SEND YOUR QUERY TO KOGNITIO!
Expansion This should never be seen
Action None
CI5046You cannot order by an expression that is not present in the source (use a derived table)
Expansion The query orders by an expression that is not directly available in the source table
Action Use a derived table so that the expression exists in the source
CI5047Can't drop security class that has users in it
Expansion There are users in the security class that you are trying to drop, which is not allowed. (Move the users to another security class or drop them first.)
Action Move the users to another security class or drop them first, then try again.
CI5500Internal error (Optimiser generator): Please contact Kognitio
Expansion Optimiser scode generation failed
Action Contact the help desk
CI5502Optimiser generator feature not yet implemented
Expansion An SQL feature has not yet been implemented in the optimiser scode generator
Action Contact the help desk
CI5510Internal error (Optimiser generator): Please contact Kognitio
Expansion Optimiser scode generation failed
Action Contact the help desk
CI5511Internal error (Optimiser generator): Please contact Kognitio
Expansion Optimiser scode generation failed
Action Contact the help desk
CI5512Internal error (Optimiser generator): Please contact Kognitio
Expansion Optimiser scode generation failed
Action Contact the help desk
CI5513Internal error (Optimiser generator): Please contact Kognitio
Expansion Optimiser scode generation failed
Action Contact the help desk
CI5514Internal error (Optimiser generator): Please contact Kognitio
Expansion Optimiser scode generation failed
Action Contact the help desk
CI5515Internal error (Optimiser generator): Please contact Kognitio
Expansion Optimiser scode generation failed
Action Contact the help desk
CI5516Internal error (Optimiser generator): Please contact Kognitio
Expansion Optimiser scode generation failed
Action Contact the help desk
CI5517Internal error (Optimiser generator): Please contact Kognitio
Expansion Optimiser scode generation failed
Action Contact the help desk
CI7001Internal error (Optimiser): Please contact Kognitio
Expansion An internal error occurred in the Optimiser
Action Contact the help desk
CI7002Optimiser feature not yet implemented
Expansion An SQL feature has not yet been implemented in the optimiser
Action Contact the help desk
CI7003Internal error (Optimiser subquery): Please contact Kognitio
Expansion An internal optimiser error occurred
Action Contact the help desk
CI7004Internal error (No joins found for subquery): Please contact Kognitio
Expansion An internal optimiser error occurred
Action Contact the help desk
CI7005Optimiser parameter invalid
Expansion An internal optimiser error occurred
Action Contact the help desk
CI7006Mixed aggregates too complex
Expansion Your query contained a mixture of distinct and non-distinct aggregates which is not yet supported
Action Contact the help desk
CI7007Predicate too complex
Expansion Your query contained a combination of predicates which is not yet supported
Action Contact the help desk
CI7008Internal error (Invalid projection generated): Please contact Kognitio
Expansion An internal optimiser error has occurred
Action Contact the help desk
CI7009Internal error (Unable to find a valid path): Please contact Kognitio
Expansion An internal optimiser error has occurred
Action Contact the help desk
CI700AJOIN ON predicate with more than one table on a side of predicate - use WHERE
Expansion Your query contained a predicate with more than one table on a side.
Action Consider using WHERE, or rewriting the predicate
CI700BQuery contains too many joins
Expansion Your query requires more than the present limit of 32 joins
Action Contact the help desk
CI700CQuery contains a theta join, which is disallowed as the error_on_theta parameter is set
Expansion Your query contains a theta join, which is disallowed as the error_on_theta parameter is set
Action Contact the help desk
CI7100Internal error (Transformer): Please contact Kognitio
Expansion An internal error occurred in the Transformer
Action Contact the help desk
CI7102Transformer feature not yet implemented
Expansion An SQL feature has not yet been implemented in the transformer
Action Contact the help desk
CI7107Predicate too complex
Expansion Your query contained a combination of predicates which is not yet supported
Action Contact the help desk
CI7108Outer reference Predicate containes no Inner references
Expansion Your query contained a predicate with an outer reference which should be applied elsewhere
Action Contact the help desk
CI7109Cannot OR outer reference predicates except in an IN/NOT IN context
Expansion Performing this operation is unsupported.
Action Contact the help desk
CI710ADisjunction of Inner and Outer predicates not possible.
Expansion Performing this operation is unsupported.
Action Contact the help desk
CI710BYou cannot use an outer reference in a derived table.
Expansion Performing this operation is unsupported.
Action Contact the help desk
CI710CYou cannot combine a (+) outer join condition using OR.
Expansion Performing this operation is unsupported.
Action Contact the help desk
CI710DYou cannot self join a (+) outer join table.
Expansion Performing this operation is unsupported.
Action Contact the help desk
CI710EAll (+) joins must be to the same table.
Expansion Performing this operation is unsupported.
Action Contact the help desk
CI710FOnly one table can be (+) outer joined.
Expansion Performing this operation is unsupported.
Action Contact the help desk
CI7110A (+) table must join to another table.
Expansion Performing this operation is unsupported.
Action Contact the help desk
CI7111You cannot mix the outer join syntaxes.
Expansion Performing this operation is unsupported.
Action Contact the help desk
CI7112You cannot create a loop of outer joins.
Expansion Performing this operation is unsupported.
Action Contact the help desk
CI7113A (+) join cannot be to a subquery or outer reference.
Expansion Performing this operation is unsupported.
Action Contact the help desk
CI7114A dependent view has an image in RAM, so you cannot CASCADE without specifying one of CREATE IMAGES/DROP IMAGES
Expansion You cannot CASCADE if a dependent view has an image in RAM. Use CASCADE [CREATE|DROP] IMAGES [IGNORE ERRORS]
Action Contact the help desk
CI7115LISTAGG cannot be used with other DISTINCT aggregates
Expansion Performing this operation is unsupported.
Action Contact the help desk
CI7116LISTAGG cannot be used with GROUPING SETS
Expansion Performing this operation is unsupported.
Action Contact the help desk
CI8001Internal error (Interpreter): Please contact Kognitio
Expansion Some internal interpreter error occurred
Action Contact the help desk
CI8002Interpreter feature not yet implemented
Expansion An SQL feature has not yet been implemented in the interpreter
Action Contact the help desk
CI8003Query aborted
Expansion Your query was aborted
Action Find out why your query was aborted before trying to rerun it
CI8005Internal error (No SCode supplied to interpreter): Please contact Kognitio
Expansion An internal interpreter error occurred
Action Contact the help desk
CI8006Internal error (Invalid SCode instruction): Please contact Kognitio
Expansion Some internal interpreter error occurred
Action Contact the help desk
CI8007Internal error (Unsupported SCode instruction): Please contact Kognitio
Expansion Some internal interpreter error occurred
Action Contact the help desk
CI8008Internal error (Invalid System Version flag): Please contact Kognitio
Expansion Some internal interpreter error occurred
Action Contact the help desk
CI8009Insufficient memory
Expansion There is insufficient memory to interpret this request
Action Free some server memory and try again
CI800AInvalid SCode specification
Expansion The interpreter subsystem detected an inconsistent SCode instruction
Action Contact the help desk
CI800BInternal error (Invalid SCode Value): Please contact Kognitio
Expansion An internal interpreter error occurred
Action Contact the help desk
CI800CInternal error (Invalid DataBuf): Please contact Kognitio
Expansion An internal interpreter error occurred
Action Contact the help desk
CI800DInternal error (Invalid ColSpec): Please contact Kognitio
Expansion An internal interpreter error occurred
Action Contact the help desk
CI800EInternal error (Invalid AccessNo): Please contact Kognitio
Expansion An internal interpreter error occurred
Action Contact the help desk
CI800FInternal error (Invalid VarNum): Please contact Kognitio
Expansion An internal interpreter error occurred
Action Contact the help desk
CI8010Invalid Cursor State
Expansion The cursor is in an invalid state for this operation; it is not positioned on a row
Action Check the last cursor operation
CI8011Cursor operations conflict
Expansion Two cursor operations have conflicted with each other
Action Check if the current cursor row has been deleted
CI8021Schema %S exists
Expansion An attempt was made to create a schema which already exists
Action Choose a new schema name and retry
CI8022User or group %S exists
Expansion An attempt was made to create a user or group which already exists
Action Choose a new user or group name and retry
CI8023Table or view %S.%T exists
Expansion An attempt was made to create a table or view which already exists
Action Choose a new name and retry
CI8024Snapshot %S exists
Expansion An attempt was made to create a snapshot which already exists
Action Choose a new snapshot name and retry
CI8025Privilege exists
Expansion An attempt was made to add a privilege which already exists
Action None
CI8026Column privilege exists
Expansion An attempt was made to add a column privilege which already exists
Action None
CI8027Security Class %S exists
Expansion An attempt was made to create a security class which already exists
Action Choose a new security class name and retry
CI8028Referential integrity row does not exist
Expansion You are trying to create a foreign key reference to a column that is not a unique key
Action Check your SQL statements; then try again
CI8029Unique group row already exists
Expansion You are trying to add a row which would violate a unique constraint
Action Check your SQL statements
CI802ATable contains no rows
Expansion An attempt was made to obtain compressed data map statistics for an empty table
Action Populate the table before attempting to gather compressed data map statistics
CI8030Internal error (Could not delete row): Please contact Kognitio
Expansion The server could not delete a row
Action Contact the help desk
CI8031Character string too long
Expansion An attempt was made to insert a character string that exceeds the defined length of a column
Action Check your SQL statements; then try again
CI8032Type mismatch
Expansion Data type conversion - type mismatch
Action Examine your query; then try again
CI8033Numeric value out of range
Expansion Data type conversion - numeric value out of range
Action Examine your query; then try again
CI8034Restrict integrity violation
Expansion
Action
CI8035Invalid parameter value
Expansion A query was executed with a supplied parameter which is outside the range of its type defined when the query was prepared
Action Amend your SQL; then try again
CI8036Interval field overflow
Expansion An interval value has overflowed the maximum number of digits in its leading field
Action Examine your query and data; then try again
CI8041Reclaim is already in progress
Expansion This request cannot be run while a reclaim is in progress
Action Wait for the reclaim to complete; then try again
CI8045Check constraint violation
Expansion Your query has breached a table's check constraint
Action Refer to the definition of the table
CI8046Check option violation
Expansion Your insert or update has breached a view's check option
Action Refer to the definition of the view
CI8048Table %s does not exist
Expansion The table required by your query does not exist
Action Check your SQL statements; then try again
CI8049View %s does not exist
Expansion The view required by your query does not exist
Action Check your SQL statements; then try again
CI804AUser or group %s does not exist
Expansion The user or group required by your query does not exist
Action Check your SQL statements; then try again
CI804BUser %s does not exist
Expansion The schema required by your query does not exist
Action Check your SQL statements; then try again
CI8051Row does not exist
Expansion A system table row does not exist
Action Check your SQL statements; then try again
CI8052Improper cardinality for non-cursor select
Expansion A select statement returned more than one row but you have not declared a cursor
Action Check your SQL statements; then try again
CI8053Subquery cardinality too great
Expansion When comparing an expression or value with the result of a subquery, the subquery must not return more than one row.
Action Check your SQL statements; then try again
CI8060NULL value is not allowed
Expansion
Action
CI8065Invalid date value
Expansion An attempt was made to return an invalid date value
Action Contact the help desk
CI8066Invalid time value
Expansion An attempt was made to return an invalid time value
Action Contact the help desk
CI8067Invalid timestamp value
Expansion An attempt was made to return an invalid timestamp value
Action Contact the help desk
CI8068Invalid time with zone value
Expansion An attempt was made to return an invalid time with zone value
Action Contact the help desk
CI8069Invalid timestamp value
Expansion An attempt was made to return an invalid timestamp with zone value
Action Contact the help desk
CI806AInvalid year-month interval value
Expansion An attempt was made to return an invalid year-month interval value
Action Contact the help desk
CI806BInvalid day-time interval value
Expansion An attempt was made to return an invalid day-time interval value
Action Contact the help desk
CI8070Invalid data type provided for a parameter
Expansion The data type of a parameter value does not match the data type which was specified when the query was initiated
Action Check your SQL statement, make sure that you provide the correct data types; then try again
CI8071Invalid length provided for a parameter
Expansion The length of a dynamic parameter value does not match the data type which was specified when the query was initiated
Action Check your SQL statement, make sure that you provide the correct parameters; then try again
CI8072Invalid value provided for a parameter
Expansion The value of a dynamic parameter does not match the data type which was specified when the query was initiated
Action Check your SQL statement, make sure that you provide the correct parameters; then try again
CI8073Premature end of parameter set
Expansion The parameter count does not match the number of parameters in the SQL
Action Check your SQL statement, make sure that you provide the correct parameters; then try again
CI8074String too long fetching results
Expansion The result set contains a string that exceeds the system maximum byte length for a string
Action Check your SQL statements; then try again
CI8078Column specification overflow
Expansion The descriptions of the columns in the export are too complex
Action Contact the help desk
CI8080Too many tables to picture
Expansion The SQL statements contains more tables than the server is able to picture
Action If it is feasible, try to limit the number of tables in your statement
CI8081Correlated update would introduce extra rows
Expansion The table you are correlating against has more than one value which matches your data set to be updated.
Action Check that you are using distinct rows in your correlated update statement.
CI8082User/Group is already member of group
Expansion The group member you are trying to add is already a member of the group
Action Contact the help desk
CI8083User/Group is not a member of group
Expansion The group member you are trying to remove is not a member of the group
Action Contact the help desk
CI8084Table wide privilege already exists
Expansion A Table Privilege exists for the column privilege you are trying to add
Action Contact the help desk
CI8085Column privilege does not exist
Expansion The revoke request could not revoke a column privilege which does not exist
Action Contact the help desk
CI8086Table privilege does not exist
Expansion The revoke request could not revoke a table privilege which does not exist
Action Contact the help desk
CI8087Schema privilege does not exist
Expansion The revoke request could not revoke a schema privilege which does not exist
Action Contact the help desk
CI8088System privilege does not exist
Expansion The revoke request could not revoke a system privilege which does not exist
Action Contact the help desk
CI8089Privilege does not exist
Expansion The revoke request could not revoke a privilege which does not exist
Action Contact the help desk
CI808ASyntax error or access violation
Expansion You do not have a required privilege for this query.
Action Contact the help desk
CI808BGroup privilege does not exist
Expansion The revoke request could not revoke a group privilege which does not exist
Action Contact the help desk
CI808CUser privilege does not exist
Expansion The revoke request could not revoke a user privilege which does not exist
Action Contact the help desk
CI808DPlugin already exists
Expansion A plugin of this name already exists
Action Choose a different plugin name
CI808EThe specified plugin does not exist
Expansion A plugin of this name does not exist
Action Choose a different plugin name
CI808FPlugin privilege does not exist
Expansion The revoke request could not revoke a plugin privilege which does not exist
Action Contact the help desk
CI8090Hash exception query produced no results
Expansion The query to generate hash exceptions did not return any rows
Action Choose a different query, or do not use exceptions
CI8091Hash exception query produced too many results
Expansion The query to generate hash exceptions returned too many rows
Action Choose a different query, or do not use exceptions
CI8092Illegal escape sequence in LIKE
Expansion You can only specify the escape character before an underscore, percent or the escape character itself
Action Rewrite your SQL statement and then try again
CI8093Databuf assertion failure in interpreter
Expansion Some internal interpreter error occurred
Action Contact the help desk
CI8094Error running embedded SQL '%S'. The error returned was '%M'
Expansion Some internal interpreter error occurred
Action Contact the help desk
CI8095Trying to DEBUG DUMPTTS with streaming enabled
Expansion DEBUG DUMPTTS is not allowed with streaming enabled. Use "set [current_session] parameter ai_auto_stream to 0".
Action Rewrite your SQL statement and then try again
CI8096Internal error (Character set translation tables): Please contact Kognitio
Expansion An internal error occurred reading the character set translation tables.
Action Contact the help desk
CI8097Internal error (Validating system): Please contact Kognitio
Expansion An internal error occurred while checking system table consistency.
Action Contact the help desk
CI8098You cannot drop all of the slabs for a table
Expansion You are dropping all of the slabs that have been set for a table
Action Contact the help desk
CI8099Invalid string representation
Expansion There was a string with an invalid representation for its character set.
Action Contact the help desk
CI809ACodepoint not in character set
Expansion There was a character not available in the destination character set during conversion.
Action Correct the data or request; then try again
CI809BBinary string too long
Expansion An attempt was made to insert a binary string that exceeds the defined length of a column
Action Check your SQL statements; then try again
CI809CInternal error validating system (see IPE_VALIDATE for details)
Expansion An internal error occurred while checking system table consistency; see IPE_VALIDATE for more information.
Action Contact the help desk
CI809DDEP line length too short
Expansion The line length for diagnose/explain/picture is too short.
Action Set the parameter ci_deplinelen to something larger
CI809EThe maximum length of a row has been exceeded
Expansion An attempt was made to insert a row that exceeds the maximum possible length of a row
Action Correct the data or request; then try again
CI809FToo many columns
Expansion The number of columns in the query exceeded the maximum allowed
Action Contact the help desk
CI80A0Failed to recover memory images
Expansion The system failed to recover the memory images. Perform a CREATE IMAGE
Action Contact the help desk
CI80A1Internal error (Interpreter threading): Please contact Kognitio
Expansion Some internal interpreter error occurred
Action Contact the help desk
CI80A2That user map already exists
Expansion That user map already exists
Action Contact the help desk
CI80A3That user map doesn't exist
Expansion That user map doesn't exist
Action Contact the help desk
CI80A4Trying to DEBUG DUMPTTS with vccheck enabled
Expansion DEBUG DUMPTTS is not allowed with vccheck enabled. Use "set [current_session] parameter ai_vccheck to 0".
Action Rewrite your SQL statement and then try again

DA error codes

DA0001Queue full
Expansion The Lock Manager queue is temporarily overloaded, so your lock request has not yet been processed
Action Try again later
DA0003Lock timeout
Expansion To avoid a deadlock, your command has failed but your transaction has NOT been rolled back
Action Try again later
DA0004Locklist full
Expansion The Lock Manager cannot process any more requests at present
Action Either try again later or Commit or Rollback some existing transactions
DA0005Deadlock detected
Expansion To avoid a deadlock, your command has failed but your transaction has NOT been rolled back
Action Try again later
DA0006Transaction list full
Expansion The Lock Manager cannot process any more requests at present
Action Try again later
DA0007Insufficient memory
Expansion The Lock Manager cannot process any more requests at present
Action Try again later
DA0008Setting breakable transaction for tno already marked as breakable
Expansion The transaction being marked as breakable is already breakable
Action Try again later
DA0009Recursion too deep checking for deadlock
Expansion The Lock Manager was unable to check for deadlocks because the recursion was too deep (your transaction has NOT been rolled back)
Action Try again later
DA000ADeadlock detected involving priority pending lock
Expansion A deadlock between granted locks, pending locks and priority pending locks has been detected. This should be handled internally by the software and not seen by the user.
Action Contact the help desk
DA2003Query aborted
Expansion
Action

DO error codes

DO0001Disk ID not found
Expansion Error in the Disk ReCreate parameters which specify rack position of disk controller card
Action Check your parameters; then try again
DO0002Invalid close state
Expansion More than one disk in the cluster contains irrecoverable data, so you cannot simply ReCreate one
Action Notify Help Desk
DO0003Another bad disk in cluster
Expansion More than one disk in the cluster contains irrecoverable data, so you cannot simply ReCreate one
Action Notify Help Desk
DO0004Attempt to read bootinfo before disks initialised
Expansion Attempt to read bootinfo before disks initialised
Action Notify Help Desk
DO0005Server code mismatch
Expansion The bootinfo on disk is older/younger than the server code being run.
Action Notify Help Desk
DO0006Invalid bootdisk information
Expansion Attempt to update ipe_boot with an invalid value e.g.
Action Check query is reasonable; then try again
DO0007Attempt to reconfigure system before image info available.
Expansion In order to reconfigure a system, the system must have had at least one create [system] image performed on it since booting. The create [system] image sets up information essential to the reconfigure process.
Action create [system] image
DO0008Not all disks checked in yet, so no boot info available
Expansion After a reboot the DO reads in boot info only after all disks have checked in. *
Action Retry. If this does not succeed, contact support
DO0009Reconfigure down would leave some WX2 clusters partially populated
Expansion Reconfigure down must either remove a WX2 cluster completely or leave it untouched *
Action Change the set of disk resources to be removed so that it matches this restriction
DO000AReconfigure down must be for some but not all disks
Expansion Reconfigure down was attempted for all / no disks, which is an error *
Action Specify a valid number of disks for reconfigure down
DO000BNot enough disk space on remaining disks to allow reconfigure down
Expansion Reconfigure down not safe, as currently there is too much data on the disks to fit onto the disks which would remain afterwards *
Action Free up some disk space via deletes/drops/reclaim, or remove fewer disks
DO000CNot in reconfigure mode so cannot run reconfigure SQL
Expansion Reconfigure can only be run after starting WX2 in reconfigure mode *
Action Restart WX2 in reconfigure mode with wxserver start reconfigure

DP error codes

DP0001Out of disk
Expansion One or more disks is full
Action Use the Reclaim command to release some disk space
DP0002Invalid disk
Expansion A disk in the cluster contains irrecoverable data
Action Use the Disk ReCreate command to regenerate the contents

DS error codes

DS0001No memory
Expansion Irrecoverable internal RDBMS error
Action Notify Help Desk
DS0002No hash space
Expansion Internal RDBMS error
Action Notify Help Desk
DS0003Invalid length
Expansion A disk in the cluster contains irrecoverable data RDBMS may regenerate the content automatically
Action If RDBMS does not recreate the contents automatically, use the Disk ReCreate command to regenerate the contents
DS0006Garbage on disk
Expansion A disk in the cluster contains irrecoverable data
Action Use the Disk ReCreate command to regenerate the contents
DS0007Unable to perform RAID operation
Expansion More than one disk in the cluster contains irrecoverable data, so you cannot simply ReCreate one
Action Notify Help Desk
DS0008Disk bad
Expansion A disk in the cluster contains irrecoverable data
Action Use the Disk ReCreate command to regenerate the contents
DS000AOut of cache
Expansion Internal RDBMS error
Action Re-boot the server; then Notify Help Desk
DS000DRecord too large
Expansion You have breached the implementation limit for maximum record length
Action Split your record into parts
DS000FToo many accesses
Expansion Disk input/output channels currently busy
Action Try again later
DS0010Access not found
Expansion Internal RDBMS error
Action Notify Help Desk
DS0013Not initialised
Expansion Internal RDBMS error
Action Notify Help Desk
DS0018Index not found
Expansion Internal RDBMS error
Action Notify Help Desk
DS001DParity disk is invalid
Expansion Internal RDBMS error
Action Notify Help Desk
DS0020Record Missing
Expansion Disk repair has identified an error
Action Notify Help Desk
DS0023M values improper for compressed index
Expansion Internal RDBMS error
Action Notify Help Desk
DS0024B values improper for compressed index
Expansion Internal RDBMS error
Action Notify Help Desk
DS0025Invalid hash algorithm
Expansion Internal RDBMS error
Action Notify Help Desk
DS002BSimulated error
Expansion Artificially generated disk error to test error handling
Action If you did not trigger the error, contact support
DS002DFormat can only be done to bad/reconfigurable disks
Expansion
Action
DS002EAttempt to read a sector from a disk performing background format.
Expansion
Action
DS002FParity disk is bad.
Expansion Internal RDBMS error
Action Notify Help Desk
DS0032More m and b values than are allowed for a compressed index.
Expansion Internal RDBMS error.
Action Notify Help Desk.
DS0033Bad blockpages value for compressed index.
Expansion Internal RDBMS error.
Action Notify Help Desk.
DS0034Attempting to read off end of disk.
Expansion Internal RDBMS error / client software bug, possibly wxdisku / user error with wxdisku.
Action Notify Help Desk.
DS0035Attempting to operate on invalid tableid for disk.
Expansion Internal RDBMS error: a disk request was made using a tableid outside the valid range for disk-based data.
Action Notify Help Desk.
DS0050OLR is not supported with this file system.
Expansion Certain file systems do not currently support OLR. You must schedule a GSR or repack instead.
Action Schedule a GSR or repack
DS0051Insert of data failed as no suitable partition with space.
Expansion An insert was attempted which failed as there was no partition available for the target table with sufficient free space.
Action Free up some space with deletes or drops, then schedule a GSR or repack
DS0053Statistics indicate that a compressed data map is not appropriate for this data.
Expansion Statistics indicate that a compressed data map is not appropriate for this data.
Action reload the data so that it clusters better on the attribute, or choose a more suitable attribute.
DS0054An invalid slab was specified as the target slab for a table.
Expansion An invalid slab was specified as the target slab for a table.
Action system tables and logging tables cannot be assigned to different slabs, and user tables must be in slab 3 or higher.
DS0055Cannot repack a table with a RAM image currently.
Expansion A table with a RAM image was specified for repacking, but the RAM subsystem cannot deal with this at the moment.
Action Drop the image of the table, repack, then recreate the image if required.
DS0056Unable to start, a disk(s) has not been zeroed.
Expansion With raid enabled, all disks must be zeroed prior to startup. One or more disks has not been
Action Check newsys has not been executed twice
DS0057Unable to perform the operation with the specified slab list.
Expansion The slab list specified is invalid. For example, trying to drop all the slabs a table uses
Action Ensure that the slab list is valid for the operation being performed
DS0058Unable to construct map with no CNF provided
Expansion A query has specified a null (0) CNF, creating the bitmap will fail
Action Notify Help Desk.
DS0059Unable to perform read due to internal error
Expansion An internal error has occurred on a read, further details in serverdbg logging file
Action Notify Help Desk.
DS005ATried to remove slabs but they are not current target slabs
Expansion The slab list specified is invalid. For example, trying to remove a target slab which a table is not currently using
Action Ensure that the slab list is valid for the operation being performed
DS005BTried to decompress data, but was not in compressed format
Expansion The compressed data was corrupt and so could not be decompressed
Action Notify Help Desk.
DS005CCannot format WX2 via server software
Expansion Formatting via SQL is no longer supported - use wxtool -Z to format new disks, or recommission
Action Notify Help Desk if wxtool -Z or recommissioning is not appropriate in this instance.
DS005DNot enough space on disk for compressed data
Expansion The compressed version of a disk page has expanded and will no longer fit in the allocated space
Action Repack the problem data into a new slab.
DS005ETrying to create extent snapshot using ID already in use
Expansion The Id given for the creation of an extent snapshot has already been used to define an extent snapshot
Action Use a unique extent snapshot id or drop the existing snapshot using this id.
DS005FUnknown extent id
Expansion The Id given as reference to an extent does not match any existing extent
Action Use a valid id.
DS0060Specified extent generated for a different file
Expansion An extent has been specified to use to scan a specified table. However, that snapshot was generated for a different table
Action Use the correct extent for this file.
DS0061Slab has non-repackable file
Expansion Slab has non-repackable file, i.e. it is only allowed to have rows on this slab.
Action Alter the file in question to not be assigned to a single slab, or use the repack ROTATE option.
DS0062Train aborting scan, out of memory
Expansion The Disk Train was unable to allocate or reclaim enough memory for a read buffer, aborting scan.
Action Try again later
DS0063A redistribute was aborted
Expansion The redistribute was aborted, need to let the background server know this
Action Should never be seen
DS0064Debugging error randomly generated
Expansion Due to a parameter being set, the DS has randomly errored for debugging purposes
Action Ignore
DS0065Invalid date value
Expansion Operation produced an invalid date value
Action Contact the help desk
DS0067Invalid timestamp value
Expansion Operation produced an invalid timestamp value
Action Contact the help desk
DS0068Invalid time value
Expansion Operation produced an invalid time value
Action Contact the help desk
DS006AYear-month interval overflow
Expansion Precision of year-month interval value is too small
Action Contact the help desk
DS006BDay-time interval overflow
Expansion Precision of day-time interval value is too small
Action Contact the help desk
DS006CRecord not found at delete address
Expansion Asked to delete a record, yet data at disk address indicates this is not a record
Action Notify Help Desk.
DS006DProjected record (not physical record) larger then maximum record size
Expansion
Action Notify Help Desk.
DS006ECDM memory allocation would exceed allowed memory for CDMs as defined by the cdm_ram_limit parameter
Expansion
Action Consider dropping some CDMs after increasing cdm_ram_limit to allow restart
DS006FTrying to get an element programatically from the file table which doesn't exist
Expansion
Action Notify Help Desk.
DS0070Returning a train meta block without having read one!!!
Expansion Returning a meta block to the train queue when the flag that indicates we actually asked for it isn't set, this is bad
Action Notify Help Desk.
DS0071Train has generated an internal error
Expansion The disk train has gotten into a bad or inconsistent state which requires it abort this operation
Action Notify Help Desk.
DS0072Selective loader bucket allocation would result in too lower memory situation
Expansion Current memory levels in the disk store preclude allocating memory for a selective load distribution bucets
Action Notify Help Desk.
DS0073Write of a record attempted with an invalid length
Expansion
Action Notify Help Desk.
DS0074Sync or write to the disk resource failed
Expansion An attempt to persist data to disk failed.
Action Notify Kognitio support.
DS0075Deletes could not be written to slab as not enough space
Expansion Deletes not possible as reached delete threshold limit on slab.
Action Repack/reclaim disk space on relevant slabs
DS0088 Interval field overflow
Expansion An interval value has overflowed the maximum number of digits in its leading field
Action Examine your query and data; then try again
DS0100Arithmetic overflow
Expansion You have tried to multiply values to a sum beyond the implementation limit
Action Check your program logic; then try again
DS0101Division by zero
Expansion You have tried to divide by zero
Action Check your program logic; then try again
DS0102Invalid Trim specification
Expansion An attempt was made to TRIM a character string which contained an invalid specification
Action Correct the data or request; then try again
DS0103Insufficient string space for operation
Expansion An attempt was made to CAST a character string into another data type but there is insufficient space to complete the operation
Action Correct the data or request; then try again
DS0104Bad regular expression
Expansion The regular expression is incorrectly formatted
Action Correct the data or request; then try again
DS0105Not enough memory to generate code
Expansion Not enough memory to generate code
Action Either simplify the query, or free up some memory
DS0106Internal code generator error
Expansion an internal error has occurred
Action contact support
DS0107Internal error running generated code
Expansion an internal error has occurred
Action contact support
DS0108Null value inserted into non-null column
Expansion Null value inserted into non-null column
Action add a 'where field is not null' to the query or make target nullable
DS0109Invalid month parameter given to PACKDATE(year, month, day)
Expansion Only values of 'month' where 1<=month<=12 are allowed when using PACKDATE
Action Correct the data or request; then try again
DS010BToo many plugin functions used
Expansion The SQL query uses too many plugins in one expression
Action Simplify the query
DS010CCardinality error
Expansion A row was joined to more than one row where this is not allowed
Action Check query
DS010EGenerate key is invalid in this context
Expansion The generate_key function was used somewhere where it is not allowed
Action Check query
DS010AInvalid day parameter given to PACKDATE(year, month, day)
Expansion The day of the month must be between 1 and 28, 29, 30, or 31 (depending on the month and leap year)
Action Correct the data or request; then try again
DS010DInvalid parameter given to TIME(H, M, S)
Expansion The time function must be given valid values 0-23,0-59,0-59
Action Correct the data or request; then try again
DS0110Internal Error: Index register allocation failed
Expansion This is an internal error, contact support.
Action contact support
DS0111Internal Error: Column projection too big
Expansion Attempted to project a column into a space that was too small.
Action contact support
DS0112Internal Error: Lookup value is NULL
Expansion Attempted to use a NULL value as an internal array index.
Action contact support
DS0113Internal Error: Lookup value not found
Expansion Unable to find a lookup value in an internal array.
Action contact support
DS0114Internal Error: saved bucket queue is full
Expansion This should never happen, something should drain it.
Action contact support
DS0115Internal Error: Unable to restart access stream
Expansion The query attempted to restart an unrestartable operation.
Action contact support
DS0116Internal Error: Varchar data is corrupted
Expansion An internal data structure became corrupted.
Action contact support
DS0117Internal Error: Hint record leakage
Expansion A hint record leaked into an incorrect place.
Action contact support
DS0118The number of buckets in width_bucket() must be at least 1
Expansion Change the number of buckets so that it is greater than zero
Action Correct the data or request; then try again
DS0119The range in width_bucket must be non-zero
Expansion The min and max values specified in width_bucket() are equal
Action Correct the data or request; then try again
DS011ANo match found for join record
Expansion A record did not join to any records in a lookup table
Action Correct the data or request; then try again
DS011BSAME_VALUE found different values
Expansion The SAME_VALUE aggregate received different non-NULL values, but they should all be the same
Action Correct the data or request; then try again
DS011CONE_VALUE found multiple values
Expansion The ONE_VALUE aggregate received multiple non-NULL values, but they should be at most one
Action Correct the data or request; then try again
DS011DInternal error, invalid disk block passed to scan.
Expansion A disk scan was passed a block which does not contain a valid forward chain of records for the appropriate table
Action Contact support
DS011EInvalid binary record length from external source
Expansion An external program outputed a binary record with an invalid length.
Action Check query and external source (script or table)
DS011FPartial binary record from external source
Expansion An external program sent a partial binary record and then terminated.
Action Check query and external source (script or table)
DS0120A string contained a partial character
Expansion A string in the database contains an incomplete character (e.g. 2 bytes of a utf-32).
Action Check data and contact support
DS0122Incorrect value size for cast from binary
Expansion A value was cast from a binary to a type with incompatible length.
Action Check binary casts in the query and correct
DS0123Internal error -- Incorrect lengths for approx count distinct merge
Expansion The server tried to merge two approx distinct lists of different lengths. This should not happen
Action Contact support
DS0124Internal error: imported record sent with invalid length
Expansion A record imported using wxloader, wximport or an external table or script has been presented for conversion with an invalid length on it.
Action Contact support.
DS0125External text record too long
Expansion A CSV or other text record obtained from an external connector or script appears to be longer than the implementation limit.
Action Check the external data for long records.
DS0126External text record too long: encountered a record which is either too long or contains an unterminated quote
Expansion A CSV or other text record obtained from an external connector or script appears to be longer than the implementation limit. This may be because a record is very large, or because a record contains an unmatched quote. More information may be found in serverdbg or in SYS.IPE_CONV_ERROR.
Action Check the external data for long records or unmatched quotes, or check serverdbg and SYS.IPE_CONV_ERROR.
DS0181Plugin failure
Expansion The plugin is in safe mode and has crashed
Action contact plugin vendor to resolve the problem or debug
DS0182Undefined plugin error
Expansion A plugin returned an undefined error code
Action Contact the plugin vendor for support
DS0183Module %S: %T
Expansion The plugin module returned an error string
Action Contact the plugin vendor for support
DS0184The plugin returned a string of the wrong length
Expansion The plugin module returned a string of the wrong length
Action Contact the plugin vendor for support
DS0185Ambiguous type for string argument to plugin function
Expansion There are multiple possible types to convert the string argument into.
Action Use an explicit cast from string to the correct type
DS0200Substring error
Expansion An attempt was made to perform a Select Substring which contained an invalid specification
Action Correct the data or request; then try again
DS0201Insufficient string memory
Expansion An attempt was made to perform a string operation for which there was insufficient memory
Action Correct the data or request; then try again
DS0202Character string too long
Expansion An attempt was made to insert a character string that exceeds the defined length of a column
Action Correct the data or request; then try again
DS0203Invalid character value for cast
Expansion An attempt was made to CAST a character string into another data type but it contained characters that could not be converted
Action Correct the data or request; then try again
DS0204Numeric overflow during conversion
Expansion An attempt was made to CAST a character string into another data type but this resulted in an overflow
Action Correct the data or request; then try again
DS0205Numeric underflow during conversion
Expansion An attempt was made to CAST a character string into another data type but this resulted in an underflow
Action Correct the data or request; then try again
DS0206minchars parameter to string function too large or negative
Expansion The value specified for the minchars parameter to a string function was not in the range of allowed values
Action Correct the data or request; then try again
DS0207Invalid value specified for base parameter to string function
Expansion The value specified for the base parameter to a string function was not an allowed value
Action Correct the data or request; then try again
DS0208Invalid character value for string function
Expansion An attempt was make to use a string function such as strtoint() or strpackints() on an invalid string
Action Correct the data or request; then try again
DS0209Invalid 'count' parameter for string function
Expansion strunpackints() or strpackints() was called with an invalid 'count' parameter
Action Correct the data or request; then try again
DS020AInvalid 'bits' parameter for string function
Expansion strunpackints() or strpackints() was called with an invalid 'bits' parameter
Action Correct the data or request; then try again
DS020B'bits' * 'count' > 64 in strunpackints()
Expansion Too many bits specified for strunpackints
Action Correct the data or request; then try again
DS020CInvalid separator for string function
Expansion strunpackints() strpackints() strcount() or strchop() was called with a separator that was not a char(1)
Action Correct the data or request; then try again
DS020DZeroth element selected as strpos(,,0) or strchop(,,0,) or strchop(,,,0)
Expansion Only none zero positive or negative values are allowed for the 'start' and 'end' parameters to strchop() and the 'occurence' parameter to strpos()
Action Correct the data or request; then try again
DS020EAttempt to search for a zero length string
Expansion The second parameter given to strpos() evaluated to a zero length string
Action Correct the data or request; then try again
DS020FAttempt to strpackints() a string with too few segments
Expansion The string given to strpackints() did not contain as many segments as were specified in the count argument.
Action Correct the data or request; then try again
DS0210Attempt to strpackints() a string with too many segments
Expansion The string given to strpackints() contained more segments than were specified in the count argument.
Action Correct the data or request; then try again
DS0211Product of count and bits params to strpackints greater than 64
Expansion The result of strpackints is limited to 64 bits, so count*bits must be between 0 and 64.
Action Correct the data or request; then try again
DS0212Result of strunpackints too large for format
Expansion The number to be unpacked by strunpackints was too large to fit in the output format.
Action Correct the data or request; then try again
DS0213String wrong length for function
Expansion The string supplied is of the wrong length for the function
Action Correct the data or request; then try again
DS0214Invalid string representation
Expansion There was a string with an invalid representation for its character set.
Action Contact the help desk
DS0215Codepoint not in character set
Expansion There was a character not available in the destination character set during conversion.
Action Correct the data or request; then try again
DS0216Unknown character set
Expansion An unknown character set was specified.
Action Contact the help desk
DS0217Bad number of octets per character
Expansion There was an invalid number of octets per character defining a character set.
Action Contact the help desk
DS0218Bad translation table range
Expansion There was an invalid translation table defining a character set.
Action Contact the help desk
DS0219Internal error in character conversion
Expansion An unknown error occurred while doing a character set conversion.
Action Contact the help desk
DS0250Invalid string for to_number
Expansion An invalid string was supplied to to_number()
Action Check your SQL statement; then try again
DS0251Invalid format string
Expansion An invalid format string was used
Action Check your SQL statement; then try again
DS0252Invalid format string
Expansion An invalid date specifier was used
Action Check your SQL statement; then try again
DS0253Bad value in date string
Expansion The date string contained an bad value
Action Check your SQL statement; then try again
DS0254Internal error - ran out of digits!
Expansion An internal error occurred
Action Contact the help desk
DS0255Too many significant digits passed to to_number
Expansion Too many significant digits were passed to to_number() - use an explicit cast
Action Check your SQL statement; then try again
DS0256Invalid day number
Expansion An invalid day number was specified
Action Check your SQL statement; then try again
DS0257No year was specified
Expansion No year was specified
Action Check your SQL statement; then try again
DS0258FX specified but wrong number of digits
Expansion Invalid input - FX specified but wrong number of digits
Action Check your SQL statement; then try again
DS0800Error encountered - repair required.
Expansion Internal RDBMS error.
Action Notify Help Desk.
DS2003Query aborted
Expansion
Action

EC error codes

EC1201Mapper task failed to write data
Expansion a mapper task in a Hadoop map-reduce job failed to write out converted data.
Action Contact support.

ET error codes

ET0001Failed to create pipe for call
Expansion Internal error, method call pipe creation failed.
Action Contect support
ET0002Failed to execute script for method call
Expansion The call to an external table's script handler failed.
Action check the external table connector's handler script
ET0003Error calling an external table connector method
Expansion An external table connector returned an error handling a method call.
Action check the external table connector's handler script
ET0004Out of buffer space processing script reply
Expansion An external table connector returned too much data from a method call.
Action check the external table connector's handler script
ET0005Method handler for connector is not present
Expansion An internal error generated an external table operation with no method handlers
Action Cointact support
ET0101Internal error handling external table connection
Expansion an internal error has occurred
Action contact support
ET0102The external table connector for the operation was not found
Expansion an internal error has occurred
Action contact support
ET0103External table connector program exited abnormally
Expansion The external program used to handle connection operations exited abnormally
Action investigate the external script or program associated with the connector to diagnose this fault
ET0104Internal error caused two connectors with the same identifier
Expansion The external connector is registered twice in the external table manager (internal error)
Action contact support
ET0105Cannot deactivate a connector while it is in use
Expansion The connector is being used in another operation
Action Wait for the other operation to finish or abort it
ET0106External tables are not enabled for this server
Expansion The external tables feature must be enabled by the [boot options] external_tables setting in the config file.
Action Enable external tables and restart WX2
ET0107Invalid method type for call
Expansion Internal error, WX2 used the wrong type for a method call.
Action Contect support
ET0108Remote object has wrong number of columns
Expansion Attempted to create an external table on an object with the wrong number of columns
Action Check external object and external table/connector deffinitions
ET0109Cannot determine external object data format
Expansion The server cannot determine the number/type of columns in the external data source
Action Define columns in the external table create or add attributes to tell the connector what the types are
ET010AInvalid format string for external table
Expansion The connector returned an invalid format string for the external table
Action Check connector arguments and consult the connector's author
ET010BUnsupported datatype for automatic format string generation
Expansion The external table contains columns for which a format string cannot be automatically generated
Action Manually specify a format string or contact the connector's author for help
ET010CInternal error generating format string
Expansion A format string for the external table could not be automatically generated
Action Manually specify a format string or contact support
ET010DInvalid character set for external data source
Expansion The external table wants to supply data in an invalid character set
Action Check the specified character set and correct
ET010EFile type number is not valid.
Expansion The file type number for the data is not in the correct range
Action Check the specified file type number and correct
ET010FInvalid external data record, see SYS.IPE_CONV_ERROR for details (tno %S)
Expansion An invalid external data record was supplied
Action Check the SYS.IPE_CONV_ERROR table and correct the problem
ET0110Load abandoned: too many invalid external data records. See SYS.IPE_CONV_ERROR for details (tno %S)
Expansion An external table access encountered so many invalid records that the load was abandoned.
Action Check the SYS.IPE_CONV_ERROR table and correct the data records or your formatting options.
ET0111User mapping for the external operation was invalid
Expansion The external operation could not be mapped onto a valid external user ID.
Action Check limits on external user IDs. Check mapping table. Check users are created correctly.
ET0112External data source BINARY column too long
Expansion The external data source is returning a BINARY column which is defined as having more than 32000 bytes.
Action Modify the query being made to the external data source, or specify the external table's column types yourself, or set the adapt_types target string attribute to 1 to automatically impose limits on column types.
ET0113External data source string column too long
Expansion The external data source is returning a string column which is defined as having more than 32000 characters.
Action Modify the query being made to the external data source, or specify the external table's column types yourself, or set the adapt_types target string attribute to 1 to automatically impose limits on column types.
ET0114External data source DECIMAL column too large
Expansion The external data source is returning a DECIMAL column whose precision is greater than 18.
Action Modify the query being made to the external data source, or specify the external table's column types yourself, or set the adapt_types target string attribute to 1 to automatically impose limits on column types.
ET0115External data source TIME or TIMESTAMP column precision too large
Expansion The external data source is returning a TIME or TIMESTAMP column whose precision is greater than 6.
Action Modify the query being made to the external data source, or specify the external table's column types yourself, or set the adapt_types target string attribute to 1 to automatically impose limits on column types.
ET0116No format string supplied for JSON file type
Expansion You have specified that the external data source provides JSON, but you have not specified the column definitions as a format string.
Action specify the JSON properties, separated by commas, in the order they are to go into the columns, as the value for the 'format' target string attribute.
ET0117Raw mode is not supported for this external connector operation
Expansion You have specified raw mode in the target string, but the connector does not support fetching data in this way.
Action Remove the "raw" attribute from the target string.
ET0118Filename partition list is invalid - it must be a comma-separated list of filename partition names, each accompanied by a column number if the column name is not the same
Expansion The filename partition list given with fmt_filename_partitions is not valid. Format is "foo 1, bar 3, baz 6", where the names refer to partition names in the filename. The number refers to the column number in the table, starting from 1, and this may be omitted if the partition name matches the column name.
Action Correct the filename partition list.
ET0119Column number in filename partition list exceeds number of columns in table
Expansion Your filename partition list, given with fmt_filename_partitions, specifies a column number which is greater than the number of columns in the table.
Action Correct the filename partition list.
ET011AExternal connector command not found
Expansion You are creating an external connector which is implemented by a program or script, but the specified command is a file that does not exist.
Action Check the name of the command with which you are creating this connector.
ET011BCannot open external connector command
Expansion You are creating an external connector which uses a program or script, but the file specified by the "command" setting cannot be opened.
Action Check that the specified command exists and is readable.
ET011CFile required by external connector not found
Expansion A file required by an external connector, or requested by an external connector script's WX2GETFILE: command, was not found.
Action Check the location of the file. Information on which file it was can be found in the serverdbg file.
ET011DCannot open file required by external connector
Expansion A file required by an external connector, or requested by an external connector script's WX2GETFILE: command, could not be opened.
Action Check that the file exists and is readable. Information on which file it was can be found in the serverdbg file.
ET011EFile type is not supported for writing.
Expansion The specified filetype is not supported for writable external tables
Action You need to write out in a different format
ET011FSpecified column number is invalid.
Expansion A write setup method call returned an order or partition column number that was not valid
Action Check query, debug connector if it's a custom one or contact support
ET0120Specified partitioning mode is invalid.
Expansion A write setup method call returned a partition mode that was not valid
Action Check query, debug connector if it's a custom one or contact support
ET0121No suitable connector is defined for this table
Expansion A metadata connector has requested a connector which supports a file format, endpoint and transport type combination which no connector is able to fulfil.
Action Create the appropriate connector.
ET0122More than one connector is suitable for this table, with the same highest priority
Expansion A metadata connector has requested resources which can be satisfied by more than one connector, and the priority for these connectors is equal so does not decide between them.
Action Modify the priorities of the external connectors so that no two external connectors which might both satisfy the same resource request can have the same priority.
ET0123Specified lock type is invalid.
Expansion A project or write setup method call returned a lock type that was not valid
Action Check query, debug connector if it's a custom one or contact support
ET0124Filename partition list is invalid - the same column or column number appears more than once
Expansion The filename partition list given with fmt_filename_partitions specifies the same column or column number twice. This isn't allowed.
Action Correct the filename partition list.

IE error codes

IE0001Code too complex
Expansion Not enough buffer memory to return code from the T-Code generator
Action Simplify your SQL statements; then try again
IE0002Illegal escape in LIKE
Expansion You cannot specify this as an escape character in a LIKE operation
Action Choose another character as your escape character for the search
IE0004Unhandled internal generator exception
Expansion There was an unhandled internal error in the machine code generator
Action Please report this to support
IE0005Generated code too large
Expansion The query requires WX2 to generate a block of code which is too large
Action Change the size limit (cg_max_gencode parameter) or contact support
IE002AInvalid EUC double byte character
Expansion A Kanji LIKE pattern contains an invalid Kanji character
Action Check the LIKE expression; then try again
IE002BEscape at end of pattern
Expansion A Kanji LIKE pattern has a trailing escape character
Action Check the LIKE expression; then try again
IE0065Invalid date value
Expansion Operation produced an invalid date value
Action Contact the help desk
IE0067Invalid timestamp value
Expansion Operation produced an invalid timestamp value
Action Contact the help desk
IE0068Invalid time value
Expansion Operation produced an invalid time value
Action Contact the help desk
IE006AYear-month interval overflow
Expansion Precision of year-month interval value is too small
Action Contact the help desk
IE006BDay-time interval overflow
Expansion Precision of day-time interval value is too small
Action Contact the help desk
IE0088 Interval field overflow
Expansion An interval value has overflowed the maximum number of digits in its leading field
Action Examine your query and data; then try again
IE0100Arithmetic overflow
Expansion You have tried to multiply values to a sum beyond the implementation limit
Action Check your program logic; then try again
IE0101Division by zero
Expansion You have tried to divide by zero
Action Check your program logic; then try again
IE0102Invalid Trim specification
Expansion An attempt was made to TRIM a character string which contained an invalid specification
Action Correct the data or request; then try again
IE0103Insufficient string space for operation
Expansion An attempt was made to CAST a character string into another data type but there is insufficient space to complete the operation
Action Correct the data or request; then try again
IE0104Bad regular expression
Expansion The regular expression is incorrectly formatted
Action Correct the data or request; then try again
IE0105Not enough memory to generate code
Expansion Not enough memory to generate code
Action Either simplify the query, or free up some memory
IE0106Internal code generator error
Expansion an internal error has occurred
Action contact support
IE0107Internal error running generated code
Expansion an internal error has occurred
Action contact support
IE0108Null value inserted into non-null column
Expansion Null value inserted into non-null column
Action add a 'where field is not null' to the query or make target nullable
IE0109Invalid month parameter given to PACKDATE(year, month, day)
Expansion Only values of 'month' where 1<=month<=12 are allowed when using PACKDATE
Action Correct the data or request; then try again
IE010BToo many plugin functions used
Expansion The SQL query uses too many plugins in one expression
Action Simplify the query
IE010CCardinality error
Expansion A row was joined to more than one row where this is not allowed
Action Check query
IE010EGenerate key is invalid in this context
Expansion The generate_key function was used somewhere where it is not allowed
Action Check query
IE010AInvalid day parameter given to PACKDATE(year, month, day)
Expansion The day of the month must be between 1 and 28, 29, 30, or 31 (depending on the month and leap year)
Action Correct the data or request; then try again
IE010DInvalid parameter given to TIME(H, M, S)
Expansion The time function must be given valid values 0-23,0-59,0-59
Action Correct the data or request; then try again
IE0110Internal Error: Index register allocation failed
Expansion This is an internal error, contact support.
Action contact support
IE0111Internal Error: Column projection too big
Expansion Attempted to project a column into a space that was too small.
Action contact support
IE0112Internal Error: Lookup value is NULL
Expansion Attempted to use a NULL value as an internal array index.
Action contact support
IE0113Internal Error: Lookup value not found
Expansion Unable to find a lookup value in an internal array.
Action contact support
IE0114Internal Error: saved bucket queue is full
Expansion This should never happen, something should drain it.
Action contact support
IE0115Internal Error: Unable to restart access stream
Expansion The query attempted to restart an unrestartable operation.
Action contact support
IE0116Internal Error: Varchar data is corrupted
Expansion An internal data structure became corrupted.
Action contact support
IE0117Internal Error: Hint record leakage
Expansion A hint record leaked into an incorrect place.
Action contact support
IE0118The number of buckets in width_bucket() must be at least 1
Expansion Change the number of buckets so that it is greater than zero
Action Correct the data or request; then try again
IE0119The range in width_bucket must be non-zero
Expansion The min and max values specified in width_bucket() are equal
Action Correct the data or request; then try again
IE011ANo match found for join record
Expansion A record did not join to any records in a lookup table
Action Correct the data or request; then try again
IE011BSAME_VALUE found different values
Expansion The SAME_VALUE aggregate received different non-NULL values, but they should all be the same
Action Correct the data or request; then try again
IE011CONE_VALUE found multiple values
Expansion The ONE_VALUE aggregate received multiple non-NULL values, but they should be at most one
Action Correct the data or request; then try again
IE011DInternal error, invalid disk block passed to scan.
Expansion A disk scan was passed a block which does not contain a valid forward chain of records for the appropriate table
Action Contact support
IE011EInvalid binary record length from external source
Expansion An external program outputed a binary record with an invalid length.
Action Check query and external source (script or table)
IE011FPartial binary record from external source
Expansion An external program sent a partial binary record and then terminated.
Action Check query and external source (script or table)
IE0120A string contained a partial character
Expansion A string in the database contains an incomplete character (e.g. 2 bytes of a utf-32).
Action Check data and contact support
IE0122Incorrect value size for cast from binary
Expansion A value was cast from a binary to a type with incompatible length.
Action Check binary casts in the query and correct
IE0123Internal error -- Incorrect lengths for approx count distinct merge
Expansion The server tried to merge two approx distinct lists of different lengths. This should not happen
Action Contact support
IE0124Internal error: imported record sent with invalid length
Expansion A record imported using wxloader, wximport or an external table or script has been presented for conversion with an invalid length on it.
Action Contact support.
IE0125External text record too long
Expansion A CSV or other text record obtained from an external connector or script appears to be longer than the implementation limit.
Action Check the external data for long records.
IE0126External text record too long: encountered a record which is either too long or contains an unterminated quote
Expansion A CSV or other text record obtained from an external connector or script appears to be longer than the implementation limit. This may be because a record is very large, or because a record contains an unmatched quote. More information may be found in serverdbg or in SYS.IPE_CONV_ERROR.
Action Check the external data for long records or unmatched quotes, or check serverdbg and SYS.IPE_CONV_ERROR.
IE0200Substring error
Expansion An attempt was made to perform a Select Substring which contained an invalid specification
Action Correct the data or request; then try again
IE0201Insufficient string memory
Expansion An attempt was made to perform a string operation for which there was insufficient memory
Action Correct the data or request; then try again
IE0202Character string too long
Expansion An attempt was made to insert a character string that exceeds the defined length of a column
Action Correct the data or request; then try again
IE0203Invalid character value for cast
Expansion An attempt was made to CAST a character string into another data type but it contained characters that could not be converted
Action Correct the data or request; then try again
IE0204Numeric overflow during conversion
Expansion An attempt was made to CAST a character string into another data type but this resulted in an overflow
Action Correct the data or request; then try again
IE0205Numeric underflow during conversion
Expansion An attempt was made to CAST a character string into another data type but this resulted in an underflow
Action Correct the data or request; then try again
IE0206minchars parameter to string function too large or negative
Expansion The value specified for the minchars parameter to a string function was not in the range of allowed values
Action Correct the data or request; then try again
IE0207Invalid value specified for base parameter to string function
Expansion The value specified for the base parameter to a string function was not an allowed value
Action Correct the data or request; then try again
IE0208Invalid character value for string function
Expansion An attempt was make to use a string function such as strtoint() or strpackints() on an invalid string
Action Correct the data or request; then try again
IE0209Invalid 'count' parameter for string function
Expansion strunpackints() or strpackints() was called with an invalid 'count' parameter
Action Correct the data or request; then try again
IE020AInvalid 'bits' parameter for string function
Expansion strunpackints() or strpackints() was called with an invalid 'bits' parameter
Action Correct the data or request; then try again
IE020B'bits' * 'count' > 64 in strunpackints()
Expansion Too many bits specified for strunpackints
Action Correct the data or request; then try again
IE020CInvalid separator for string function
Expansion strunpackints() strpackints() strcount() or strchop() was called with a separator that was not a char(1)
Action Correct the data or request; then try again
IE020DZeroth element selected as strpos(,,0) or strchop(,,0,) or strchop(,,,0)
Expansion Only none zero positive or negative values are allowed for the 'start' and 'end' parameters to strchop() and the 'occurence' parameter to strpos()
Action Correct the data or request; then try again
IE020EAttempt to search for a zero length string
Expansion The second parameter given to strpos() evaluated to a zero length string
Action Correct the data or request; then try again
IE020FAttempt to strpackints() a string with too few segments
Expansion The string given to strpackints() did not contain as many segments as were specified in the count argument.
Action Correct the data or request; then try again
IE0210Attempt to strpackints() a string with too many segments
Expansion The string given to strpackints() contained more segments than were specified in the count argument.
Action Correct the data or request; then try again
IE0211Product of count and bits params to strpackints greater than 64
Expansion The result of strpackints is limited to 64 bits, so count*bits must be between 0 and 64.
Action Correct the data or request; then try again
IE0212Result of strunpackints too large for format
Expansion The number to be unpacked by strunpackints was too large to fit in the output format.
Action Correct the data or request; then try again
IE0213String wrong length for function
Expansion The string supplied is of the wrong length for the function
Action Correct the data or request; then try again
IE0214Invalid string representation
Expansion There was a string with an invalid representation for its character set.
Action Contact the help desk
IE0215Codepoint not in character set
Expansion There was a character not available in the destination character set during conversion.
Action Correct the data or request; then try again
IE0216Unknown character set
Expansion An unknown character set was specified.
Action Contact the help desk
IE0217Bad number of octets per character
Expansion There was an invalid number of octets per character defining a character set.
Action Contact the help desk
IE0218Bad translation table range
Expansion There was an invalid translation table defining a character set.
Action Contact the help desk
IE0219Internal error in character conversion
Expansion An unknown error occurred while doing a character set conversion.
Action Contact the help desk
IE0250Invalid string for to_number
Expansion An invalid string was supplied to to_number()
Action Check your SQL statement; then try again
IE0251Invalid format string
Expansion An invalid format string was used
Action Check your SQL statement; then try again
IE0252Invalid format string
Expansion An invalid date specifier was used
Action Check your SQL statement; then try again
IE0253Bad value in date string
Expansion The date string contained an bad value
Action Check your SQL statement; then try again
IE0254Internal error - ran out of digits!
Expansion An internal error occurred
Action Contact the help desk
IE0255Too many significant digits passed to to_number
Expansion Too many significant digits were passed to to_number() - use an explicit cast
Action Check your SQL statement; then try again
IE0256Invalid day number
Expansion An invalid day number was specified
Action Check your SQL statement; then try again
IE0257No year was specified
Expansion No year was specified
Action Check your SQL statement; then try again
IE0258FX specified but wrong number of digits
Expansion Invalid input - FX specified but wrong number of digits
Action Check your SQL statement; then try again
IE1001Internal error: invalid date/time/timestamp format string
Expansion The format string supplied with a date, time or timestamp conversion is invalid and this didn't result in the whole import being rejected.
Action Notify WX2 support.
IE1100Date, time or timestamp field could not be converted: %S conversion cannot take '%T'
Expansion The field does not match the date, time or timestamp format given.
Action Correct the data file or format string and try again.
IE1101Day of year out of range
Expansion The day-of-year part of a date or timestamp field ("DDD") is less than 1 or greater than the number of days in the year.
Action Correct the data file or format string and try again.
IE1102Day of month out of range
Expansion The day part of a date or timestamp field is less than 1 or greater than the number of days in the month.
Action Correct the data file or format string and try again.
IE1103Month out of range
Expansion The month part of a date or timestamp field is not between 1 and 12.
Action Correct the data file or format string and try again.
IE1104Year out of range
Expansion The year part of a date or timestamp field is not between 0001 and 9999.
Action Correct the data file or format string and try again.
IE1105Hour out of range
Expansion The hour part of a time or timestamp field is not between 0 and 23, or 1 and 12 for a 12-hour time.
Action Correct the data file or format string and try again.
IE1106Minute out of range
Expansion The minute part of a time or timestamp field is not between 0 and 59.
Action Correct the data file or format string and try again.
IE1107Second out of range
Expansion The second part of a time or timestamp field is not between 0 and 59.
Action Correct the data file or format string and try again.
IE1108AM/PM indicator not found where expected
Expansion The format string for this time or timestamp field calls for an AM or PM indicator, and one does not appear at this point in the field.
Action Correct the data file or format string and try again.
IE1109Unrecognised month abbreviation "%S"
Expansion The month part of a date or timestamp field ("MMM") is not a recognised three-letter month abbreviation.
Action Correct the data file or format string and try again.
IE110AFailed to convert field
Expansion The field in the data file contains characters which are not valid for the conversion being performed.
Action Correct the data file or format string and try again.
IE110BString literal unmatched: expected "%S", got "%T"
Expansion The format string demands a certain string to appear in the record, and it does not appear at that point.
Action Correct the data file or format string and try again.
IE110CField contains only spaces
Expansion A field was encountered which contained only whitespace, and this is not allowed by the conversion.
Action Correct the data file or format string and try again.
IE110DInvalid character for integer conversion: '%S' is not a valid base-%T digit
Expansion A field which needs to be converted to an integer contains characters that cannot be converted.
Action Correct the data file or format string and try again.
IE110EToo many decimal points in decimal conversion
Expansion A field which needs to be converted to a DECIMAL column contains too many decimal point characters (usually more than one, or more than zero if implieddp is set).
Action Correct the data file or format string and try again.
IE110FInvalid character '%S' for decimal conversion
Expansion A field which needs to be converted to a DECIMAL column contains a character which shouldn't be there.
Action Correct the data file or format string and try again.
IE1110Invalid character '%S' for floating point conversion
Expansion A field which needs to be converted to a REAL or FLOAT column contains a character which shouldn't be there.
Action Correct the data file or format string and try again.
IE1111Date, time or timestamp literal unmatched: expected '%S', got '%T'
Expansion The date, time or timestamp format string calls for a literal character to appear in the field, which doesn't.
Action Correct the data file or format string and try again.
IE1112Interval field overflow: %S too large for interval of precision %T
Expansion The interval is too large for the column.
Action Correct the data file, or redefine the table to allow a larger interval.
IE1113Invalid nibble in BCD number: %S
Expansion A binary coded decimal field has a nibble which is not 0-9, and not an initial or final C or D.
Action Correct the data file.
IE1114%S junk characters after end of record, possibly caused by unescaped quote
Expansion A record had surplus data on the end after the format string consumed what it required.
Action If the record looks like it's correct, this may be caused by incorrect splitting of the file into records - make sure quotes are escaped properly, and make sure the options to wxloader regarding whether fields are quoted match the format of the data file.
IE1115Unterminated quote: record contains an opening quote with no closing quote
Expansion A record contains an opening quote but no closing quote. In CSV files this is usually because the file ended in the middle of a quoted string.
Action Correct your data file and try again.
IE1116Hexadecimal string length not even
Expansion A hexadecimal string in a record, which represents a sequence of bytes, has an odd number of hexadecimal digits in it.
Action Correct your data file and try again.
IE1117Invalid digit '%S' in hexadecimal string
Expansion A hexadecimal string in a record has a character which is not a digit 0-9 or a letter A-F.
Action Correct your data file and try again.
IE1118Invalid WKT polygon - expected pair of opening parentheses %S characters after start of field
Expansion A Well-Known-Text formatted polygon was not in the form POLYGON((x y, x y, ...))
Action Correct your polygon definition and try again.
IE1119Invalid WKT polygon - point #%S is not a pair of numbers separated by spaces, %T characters after start of field
Expansion A Well-Known-Text formatted polygon was not in the form POLYGON((x y, x y, ...))
Action Correct your polygon definition and try again.
IE111AInvalid WKT polygon - text for point #%S is too long, %T characters after start of field
Expansion A Well-Known-Text formatted polygon was not in the form POLYGON((x y, x y, ...))
Action Correct your polygon definition and try again.
IE111BInvalid WKT polygon - expected pair of closing parentheses %S characters after start of field
Expansion A Well-Known-Text formatted polygon was not in the form POLYGON((x y, x y, ...)). Note that POLYGON definitions containing multiple polygons are not supported.
Action Correct your polygon definition and try again.
IE111CInvalid WKT polygon - junk after polygon definition, %S characters after start of field
Expansion A Well-Known-Text formatted polygon was in the form POLYGON((x y, x y, ...)), but the field contained junk at the end.
Action Correct your polygon definition and try again.
IE111DJSON syntax error: %S
Expansion A JSON record does not parse as valid JSON.
Action Correct the JSON and try again.
IE111EJSON value (%S) not compatible with destination type (%T)
Expansion A JSON value cannot be converted to its destination column, for example, an integer into a DATE column.
Action Correct the JSON or redefine the table and try again.
IE111FJSON value is NULL but column is defined as NOT NULL
Expansion A JSON record has a NULL value, but the corresponding column does not allow nulls.
Action Alter the JSON, or redefine the column.
IE1120JSON format expression is an array but it should be a value: %S
Expansion The JSON format string refers to an object member which is not a value but an array.
Action Correct the JSON or the format string and try again.
IE1121JSON format expression is an object but it should be a value: %S
Expansion The JSON format string refers to an object member which is not a value but another object.
Action Correct the JSON or the format string and try again.
IE1122JSON format expression does not exist in object: %S
Expansion The JSON format string refers to an object member which does not exist in this JSON object.
Action Correct the JSON or the format string and try again.
IE1123Not a JSON array: %S
Expansion The JSON format string uses the subscript operator [] on something other than an array.
Action Correct the JSON or the format string and try again.
IE1124Not a JSON object: %S
Expansion The JSON format string refers to a member of something other than a JSON object. For example, "a.b" where a is a value.
Action Correct the JSON or the format string and try again.
IE1125Invalid timestamp: %S
Expansion A string value could not be put into a timestamp column because the value was not recognised as a timestamp.
Action Correct the value and try again.
IE1126Invalid date: %S
Expansion A string value could not be put into a date column because the value was not recognised as a date.
Action Correct the value and try again.
IE1127Invalid time: %S
Expansion A string value could not be put into a time column because the value was not recognised as a time.
Action Correct the value and try again.
IE1128Invalid number: %S
Expansion A string value could not be put into an integer or decimal column because the value was not recognised as a number.
Action Correct the value and try again.
IE1129JSON record is not an object
Expansion An element of the target array (or one of the JSON records if there is no target array) is not a JSON object, but an array or some scalar type.
Action Correct the JSON and try again.
IE112AJSON expression runtime error: %S
Expansion An expression supplied in the JSON format string threw a runtime error, for example because a referenced JSON property did not exist.
Action Consult the error message and correct your format string.
IE112BInvalid field value for column type or incorrect field terminator
Expansion A field could not be converted to the required column type, because a character was encountered which was not valid for the field and is not a recognised terminator for that field.
Action Correct the field and try again.
IE112CAvro parsing error: %S
Expansion An Avro block does not parse as valid Avro.
Action Correct the Avro and try again.
IE112DInvalid record count at start of Avro block
Expansion An Avro block has a record count which is less than zero or greater than 2^32-1.
Action Check that the Avro file is correct.
IE112EInvalid data length at start of Avro block
Expansion An Avro block has a byte length which is less than zero or greater than 2^32-1.
Action Check that the Avro file is correct.
IE112FAvro block sync marker incorrect
Expansion The 16-byte sync marker at the end of an Avro block is incorrect.
Action Check that the Avro file is correct.
IE1130Out of memory when decompressing zlib block
Expansion The zlib decompression ran out of memory.
Action Try again when the system is less busy.
IE1131Internal error: zlib decompression version mismatch
Expansion The zlib version expected by the header file is not the same of the version of zlib in use. This is probably a bug.
Action Contact support.
IE1132Internal error: zlib decompression failure
Expansion There was an internal error while doing zlib compression. This is a bug.
Action Contact support.
IE1133Compressed Avro block is incomplete
Expansion The compressed data of an Avro block is not complete - more data is required to make a valid Avro block. This is probably a bug or a corrupt Avro file.
Action Contact support.
IE1134zlib decompression stream error
Expansion The zlib library returned a stream error when decompressing.
Action Contact support.
IE1135zlib decompression data error
Expansion The zlib library returned a data error when decompressing.
Action Contact support.
IE1136Unexpected end of Avro block
Expansion An Avro block ended before it was complete, such as in the middle of a record.
Action Fix the Avro file.
IE1137Avro integer too large
Expansion An Avro-encoded integer was larger than the maximum allowed by the schema.
Action Fix the Avro file.
IE1138Invalid value for Avro boolean
Expansion An Avro boolean appears in the file as a byte other than 0 or 1.
Action Fix the Avro file.
IE1139Invalid Avro string length
Expansion An Avro string has a length which is negative or too large.
Action Fix the Avro file.
IE113AAvro map block too large
Expansion An Avro map object has a block which is too large for this implementation.
Action Use an Avro file which has smaller blocks.
IE113BAvro array block too large
Expansion An Avro array object has a block which is too large for this implementation.
Action Use an Avro file which has smaller blocks.
IE113CAvro map block contains too many elements
Expansion An Avro map object has a block which contains too many elements for this implementation.
Action Use an Avro file which has smaller blocks.
IE113DAvro array block contains too many elements
Expansion An Avro array object has a block which contains too many elements for this implementation.
Action Use an Avro file which has smaller blocks.
IE113EInvalid Avro union index
Expansion The type indicator for an Avro union value is less than zero or greater than the maximum index specified for the union.
Action Fix the Avro file.
IE113FAvro value (%S) not compatible with destination type (%T)
Expansion An Avro value cannot be converted to its destination column, for example, a boolean into a DATE column.
Action Correct the Avro or redefine the table and try again.
IE1140Invalid Avro enum index
Expansion An Avro enum field has an index which is negative, or greater than or equal to the number of symbols in the enum.
Action Fix the Avro file.
IE1141Invalid decompressed length at start of Snappy-compressed block
Expansion The decompressed length, which appears at the start of a Snappy compressed block, was invalid or too large.
Action Input file is corrupt or there is a bug. Contact support.
IE1142Error when decompressing Snappy block: %S
Expansion An error was encountered when decompressing a Snappy-compressed block.
Action Input file is corrupt or there is a bug. Contact support.
IE1143Out of memory when decompressing Snappy block
Expansion There wasn't enough memory to decompress the Snappy block.
Action Try again when the system is less busy. If the problem persists, check that the blocks are not enormous.
IE1144Internal error: no codec given for this Avro block
Expansion The code-generated Avro parser was expecting to be told what codec this block was compressed with, and it wasn't. This is a bug.
Action Contact support.
IE1145Unrecognised Avro codec
Expansion One of the Avro files you're trying to load is encoded with a codec other than "null", "deflate" or "snappy".
Action Re-encode that Avro file using a supported compression codec.
IE1146Internal error: failed to switch to different Avro codec
Expansion After finishing with one Avro file and starting on another, the call to the Avro parser to switch compression codecs failed.
Action Contact support.
IE1147More than %S conversion errors found by mpid %T for this load. No more conversion errors will be logged.
Expansion An external table load has resulted in one ramstore producing more than the permitted number of conversion errors, and no more conversion errors for this ramstore will be logged in IPE_CONV_ERROR.
Action Fix your data file.
IE1148Unrecoverable error reading file %S. The rest of the file will be ignored.
Expansion A syntax error was found in a file to be loaded, which meant we could not continue parsing the file. No records from this file after the point at which the error occurred have been loaded.
Action Fix your data file.
IE1149Target array not found in first object in JSON file
Expansion The JSON format string specifies a named target array which we should find in the file, then apply the format string to each element in that array. However, that target array does not exist in the root object of the JSON file. The JSON file has been rejected.
Action Check that the target array you have named appears in the JSON file's root object.
IE114AAvro logical type 'duration' cannot be converted to day/time interval type because months field is nonzero (%S) and destination type can't store months
Expansion You are trying to load an Avro "duration" type into an INTERVAL DAY/HOUR/MINUTE/SECOND column, but the "months" field of the Avro value is not zero, and this column type can't store months.
Action Use an INTERVAL YEAR TO MONTH type instead. You will lose the days or milliseconds fields of the value.
IE114BTime zone offset out of range
Expansion A time zone offset indicator on a TIME or TIMESTAMP field is outside the allowed range. The offset may not be more than 24 hours in either direction.
Action Express the time or timestamp fields using a smaller offset.
IE114CInvalid record count in Avro block header
Expansion We received an Avro block whose record count is negative.
Action Fix the Avro block.
IE114DInvalid data length in Avro block header
Expansion We received an Avro block whose data length is negative.
Action Fix the Avro block.
IE114EInvalid base64 symbol: %S
Expansion A string which is supposed to be a base64-encoded string contains a character that isn't a valid base64 symbol.
Action Fix the string, or check that this really is a base64 encoded string.
IE114FFound base64 symbol after padding character
Expansion We found extra symbols after the padding symbol (=) used to terminate a base64-encoded string.
Action Fix the string, or check that this really is a base64 encoded string.
IE1150Timestamp out of range
Expansion We are trying to load a timestamp which is not between 0001-01-01 00:00:00.00 and 9999-12-31 23:59:59.99.
Action Fix the invalid timestamp.
IE1151Avro loading error: %S
Expansion There was an error loading an Avro file.
Action See the error text or serverdbg.

IO error codes

IO0001Insufficient memory for external communications
Expansion Irrecoverable RDBMS error
Action Notify Help Desk
IO0007NFS write length mismatch
Expansion NFS has failed to confirm receipt of the correct number of bytes
Action Consult your Network Administrator
IO0009Invalid WCB version number
Expansion You are trying to import a file which is not in the correct WCB format
Action Check file formats and import parameters; then try again
IO000AImport table - field spec mismatch
Expansion Fields don't match columns on import
Action Check file formats and import parameters; then try again
IO000BInvalid file format for import
Expansion Import file header corrupt (contains format info) or fields don't match columns on import
Action Check file formats and import parameters; then try again
IO000CChecksum error in import file
Expansion Import file is either corrupt or not in WCB format
Action Check file formats and import parameters; then try again
IO000DInvalid record length in import file
Expansion Import file corrupt or not in WCB format
Action Check file formats and import parameters; then try again
IO000ENFS read retries exceeded
Expansion Too many repeated NFS read failures
Action Check NFS is working properly
IO000FInvalid hostname for NFS operation
Expansion Hostname cannot be resolved
Action Check file formats and import parameters; then try again
IO0010No create text in WCB and table does not exist
Expansion The table being imported into needs to be created, but the WCB does not contain a create text field.
Action Create the table manually, and retry the import.
IO0011Conversion from old WCB format disallowed
Expansion The WCB file being imported is an old format which contains no character set information, and there are one or more string columns in the table.
Action Force the import if it is known that the WCB contains strings of the same character encoding as the table expects (-wcb2-force in wximport), or convert the file to CSV, identify the character encoding and convert to WCB with the latest wximport.
IO0012Automatic table creation from old WCB format disallowed
Expansion The WCB file being imported is an old format whose create text contains no character set information, the table does not exist, and the default character set is not a single-byte character set.
Action Set the default character set to a single-byte character set, or create the table manually with the appropriate character set settings and import again.
IO0013CSV record too long, record %S, file offset %T
Expansion A record in a CSV import is too long.
Action Check that all the records in the CSV file are quoted correctly; a stray quote usually causes this error.
IO0014No character set specified
Expansion A WCB4 import did not specify the source data character set in its header block.
Action Notify WX2 helpdesk.
IO0015No record format specified
Expansion A WCB4 import did not specify the record format in its header block.
Action Notify WX2 helpdesk.
IO0016Record format unimplemented
Expansion The import client is specifying a record format the server does not understand.
Action Upgrade the server to one that supports the record format you're trying to use.
IO0017Unrecognised character set
Expansion The character set of the file you are trying to import is not supported by this WX2 version.
Action Translate the file to a character set supported by WX2.
IO0018Record terminator for variable width character set must be a single code unit
Expansion The record terminator for an import of a file whose character set is variable-width must be a single code unit (one byte for UTF-8, two bytes for UTF-16).
Action Use a different record terminator, for example, a newline.
IO0019Imported block not whole number of character code units
Expansion The block of text to be imported contains an incomplete code unit, for example, an odd trailing byte for UTF-16.
Action Notify WX2 helpdesk: the import client should ensure blocks are
IO001AUnsupported data format for load
Expansion The format string supplied does not describe a fixed-width or delimited format.
Action Obtain data file in another format.
IO001BTable does not exist
Expansion The target table for a load does not exist.
Action Create the table and try again.
IO001CInconsistent quote characters in format string
Expansion The format string contains two or more elements with different quote characters. This isn't allowed.
Action Obtain data file in another format.
IO001DUnknown record type specified for load
Expansion The client specified a record type which was not automatic (0), terminated (1), quoted terminated (2) or fixed-width (3).
Action Specify a recognised record type.
IO001ENo record width specified for fixed-width record type
Expansion The client specified that the records were to be treated as fixed-length records but did not supply a record length.
Action Specify a record length.
IO001FHeader field extends outside header block - probably a client bug
Expansion A field in the header block sent to the server has a length that would put part of the field outside the block. This is probably a bug with wximport or wxloader, depending on which you're using.
Action Contact WX2 support.
IO0020JSON record too long, object %S, starting at file offset %T
Expansion A JSON object which was intended to be converted into one or more records exceeds the maximum length.
Action Check your JSON is correct, or set load_rec_max to a higher value.
IO0021Avro block too long, object %S, starting at file offset %T
Expansion An Avro data block exceeds the maximum length for this implementation.
Action Check your Avro file is correct, or set load_rec_max to a higher value.
IO2003Query aborted
Expansion
Action

LC error codes

LC0001Unlicensed system
Expansion Insufficient software licences for the current software configuration.
Action Add licence keys, reconfigure the system or contact support.
LC0002Licensed concurrent session limit reached
Expansion Insufficient software licences to open another concurrent session
Action Add licence keys, close some sessions or try again later.
LC0003Licensed data storage limit reached
Expansion Insufficient software licences to store any more data.
Action Add licence keys, delete data, reclaim disk space or contact support.
LC0101Licensed node limit exceeded
Expansion The system has more nodes than the valid licences allow
Action Add licences or remove nodes.
LC0102Ramstore limit exceeded
Expansion The system has more ramstores than the valid licences allow
Action Add licences or remove ramstores.
LC0103Diskstore limit exceeded
Expansion The system has more Diskstores than the valid licences allow
Action Add licences or remove disk resources.
LC0104Interpreter limit exceeded
Expansion The system has more interpreters than the valid licences allow
Action Add licences or remove interpreters.
LC0105Compiler limit exceeded
Expansion The system has more compilers than the valid licences allow
Action Add licences or remove compilers.
LC0106IO process limit exceeded
Expansion The system has more IO Processes (daemons) than the valid licences allow
Action Add licences or remove daemons.
LC0107Total disk size limit exceeded
Expansion The system has more disk storage than the valid licences allow
Action Add licences or remove disk storage.
LC0108Ramstore memory size limit exceeded
Expansion The system has more ramstore memory than the valid licences allow
Action Add licences or remove/shrink ramstore memory.
LC0109System memory size limit exceeded
Expansion The system has more ram than the valid licences allow
Action Add licences or remove ram.
LC010AConcurrent session limit exceeded
Expansion The system has more concurrent sessions than the valid licences allow
Action Add licences or close sessions.
LC010BInternal licensing failure
Expansion This internal error should be impossible.
Action Contact support.
LC010CData storage limit exceeded
Expansion The system is storing more data than the valid licences allow
Action Add licences or remove data.
LC010ENew system is unlicensed
Expansion Available licences will not allow a new system to be created
Action Check licence keys and/or contact support.
LC010FUnlicensed data storage RAM used
Expansion Ram storage nodes (nodes with an RS on) have more RAM than licences allow
Action Add licences or remove RAM (physically or with [system] memsize=).
LC0110Usable disk size limit exceeded
Expansion The system has more usable disk storage than the valid licences allow
Action Add licences or remove disk storage.
LC0111Use of disk compression requires additional licence
Expansion The system has disk compression enabled and no valid licence allows this
Action Add licences or turn off.
LC0112Use of external tables requires additional licence
Expansion The system has external tables enabled and no valid licence allows this
Action Add licences or turn off.
LC0113Use of external scripts requires additional licence
Expansion The system has external scripts enabled and no valid licence allows this
Action Add licences or turn off.
LC0140No base licence found
Expansion The system needs a valid base licence code to allow it to work
Action Add a base licence key or contact support.
LC0141Multiple base licences
Expansion Multiple base licences codes present in the system.
Action remove all but one base licence.
LC0142No valid licence codes found
Expansion The system cannot find any valid licence codes.
Action Add valid licence codes.

LF error codes

LF0001Empty attribute name in format string
Expansion An empty attribute name has been given in a format specifier
Action Give the attribute a name longer than zero characters
LF0002Comma or closing brace expected after attribute
Expansion An unexpected character followed a name=value attribute setting
Action Correct your format string and try again
LF0003Unclosed brace in format string
Expansion An opening brace in the format string has no corresponding closing brace
Action Correct your format string and try again
LF0004Format string attribute type mismatch
Expansion The format string attempts to set a built-in attribute to something invalid, for example, an integer attribute is set to an alphabetic string
Action Correct your format string and try again
LF0005Unclosed square bracket in format string
Expansion A %[ conversion in a format string does not have a corresponding ]
Action Correct your format string and try again
LF0006Illegal byte sequence in format string
Expansion The format string contains an invalid UTF-8 character
Action Correct your format string and try again
LF0007Unrecognised format specifier
Expansion The format string contains an unrecognised format sequence
Action Correct your format string and try again
LF0008Inconsistent column numbers in format string
Expansion The format string has column numbers specified for some but not all of the conversions
Action Specify column numbers for none or all of the non-ignored conversion specifiers
LF0009Column number repeated in format string
Expansion The format string contains two or more conversion specifiers with the same column number
Action Correct your format string and try again
LF000AInvalid date, time or timestamp format
Expansion The format string contains a date, time or timestamp format string which is invalid
Action Correct the date, time or timestamp format string and try again
LF000BInvalid escape sequence in format string
Expansion The format string contains an illegal escape sequence, for example \x followed by a non-hexadecimal digit
Action Correct your format string and try again
LF000CFormat string attribute value out of range
Expansion The format string attempts to set an attribute outside the allowable range, e.g. minyear is not between 0 and 9900
Action Correct your format string and try again
LF000DInvalid column number or too many format elements for table
Expansion The format string contains a column number that is too large, or has more non-ignored conversions than there are column numbers.
Action Correct your format string and try again.
LF000EFormat string element can't be converted to column
Expansion One of the format elements in the format string is not compatible with its target column, for example, a %d conversion with a TIME field.
Action Correct your format string and try again.
LF000FUnterminated quote in format string
Expansion There is a quoted string in the format string that doesn't have a closing quote.
Action Correct your format string and try again.
LF0010Format string literal too large
Expansion Your format string contains a literal which is longer than 32000 characters.
Action Correct the format string, or use a less perverse file format.
LF0011Too many conversions in format string
Expansion Your format string contains too many conversion directives.
Action Remove some conversion directives from the format string.
LF0012Too many elements in format string
Expansion Your format string contains too many conversion elements.
Action Remove some elements from the format string.
LF0013Format string attribute token too large
Expansion An attribute name or value in a conversion directive in your format string is too large.
Action Use shorter attribute names or values.
LF0014Too much memory used by format string attributes
Expansion You have too many large attributes in a conversion directive in your format string.
Action Use fewer or shorter attribute strings in your format string.
LF0015Not enough format elements in format string
Expansion There is at least one column in the target table which does not have a format string element associated with it.
Action Correct your format string and try again.
LF0016Cannot mix binary and non-binary conversion directives
Expansion Binary conversion directives (those with the & flag) and non-binary conversion directives cannot be mixed in the same format string.
Action Correct your format string and try again.
LF0017Conversion directive must be binary
Expansion You have supplied a conversion directive which only has meaning as a binary conversion, without the & flag.
Action Give that conversion directive the & flag.
LF0018Field width required for conversion directive
Expansion You have supplied a conversion directive with no field width, and a field width is mandatory for this conversion directive.
Action Correct your format string and try again.
LF0019Expected precision value after dot in conversion specifier
Expansion You supplied a conversion directive with a dot in it but no number following it for the precision.
Action Correct your format string and try again.
LF001ANot enough memory to parse JSON format string
Expansion There is not enough space available to parse your JSON format string.
Action Make your JSON format string less complex.
LF001BFailed to parse JSON format string: ended unexpectedly
Expansion The end of your JSON format string came in an unexpected place, for example, immediately after a dot, or after an opening square bracket.
Action Correct your format string and try again.
LF001CFailed to parse JSON format string: bad dimension specifier
Expansion Your JSON format string has a badly-formed dimension specifier. "Dimension specifier" refers to the pair of square brackets after an array name.
Action Correct your format string and try again.
LF001DFailed to parse JSON format string: expected word or dimension
Expansion Where the JSON format string parser expected a word (the name of a member) or a dimension specifier ("[]"), it found something else.
Action Correct your format string and try again.
LF001EFailed to parse JSON format string: expected attribute or comma
Expansion Where the JSON format string parser expected an attribute setting ("name=value") or a comma to separate this column from the next, it found something else.
Action Correct your format string and try again.
LF001FFailed to parse JSON format string: invalid attribute value
Expansion A name=value attribute setting in one of the column definitions of your JSON format string uses an attribute value which is invalid for that attribute.
Action Correct your format string and try again.
LF0020Failed to parse JSON format string: each column definition must start with a name
Expansion One of the column definitions of your JSON format string starts with something other than the name of a JSON object member, or a # symbol followed by the same.
Action Correct your format string and try again.
LF0021Failed to parse JSON format string: %S
Expansion Your JSON format string was invalid.
Action Consult the error message and fix your format string.
LF0022Bad Avro schema: %S
Expansion The schema of this Avro file is not valid, or it describes a data structure we can't deal with.
Action Fix your Avro file.
LF0023Internal error: automatically-generated JSON format string incorrect
Expansion No JSON format string was specified for an Avro load, so the server tried to generate one itself using the Avro schema. However, this format string was invalid. This is a bug.
Action Contact helpdesk.
LF0024Internal error: automatically-generated Avro format string incorrect
Expansion The server internally generated a string encapsulating the Avro codec, sync marker and schema, but this string is now invalid. This is a bug.
Action Contact helpdesk.
LF0025Avro field name not found
Expansion The Avro format string uses a name which does not correspond to any field defined in the Avro schema.
Action Correct the format string and try again.
LF0026Avro field name invalid
Expansion The Avro format string uses an invalid name.
Action Correct the format string and try again.
LF0027Invalid Avro format string: %S
Expansion The Avro format string is not valid.
Action Correct the format string and try again.
LF2001Out of memory
Expansion Not enough memory to process format string
Action Use a shorter format string

MP error codes

MP0001Memory allocation failure reading message stats
Expansion Memory allocation failure trying to gather message passing statistics
Action Contact support
MP0002Internal error retrieving statistics
Expansion There was an internal error retrieving message passing statistics
Action Contact support

NF error codes

NF0001Not owner
Expansion
Action
NF0002No such file or directory
Expansion
Action
NF0005Physical I/O error !
Expansion
Action
NF0006No such file or address
Expansion
Action
NF000DPermission denied
Expansion
Action
NF0011File already exists
Expansion
Action
NF0013Bad call to device
Expansion
Action
NF0014Directory op on non-dir
Expansion
Action
NF0015Non-dir op on directory
Expansion
Action
NF001BFile too big
Expansion
Action
NF001CNo space left on device
Expansion
Action
NF001ERead only file system
Expansion
Action
NF003FName too long
Expansion
Action
NF0042Internal
Expansion
Action
NF0045Internal
Expansion
Action
NF0046Internal
Expansion
Action
NF0047Too many levels of remote
Expansion
Action
NF0063Internal
Expansion
Action
NF0064The host cannot be found or does not support NFS
Expansion
Action
NF0065The name of the host doesn't make sense"
Expansion
Action
NF0066Too many files are open
Expansion
Action
NF0067Invalid handle was passed to a NF_ procedure
Expansion
Action
NF0201Host not found
Expansion
Action
NF0202Try again - host not found or SERVERFAIL
Expansion
Action
NF0203Host not found - FORMERR, REFUSED, NOTIMP.
Expansion
Action
NF0204Host not found - Valid name, no data.
Expansion
Action

OD error codes

OD0001Record exceeds server record length limit
Expansion The ODBC driver has fetched a record from the server whose length exceeds the maximum length of a record the server is supposed to return.
Action Notify Kognitio support.
OD0002Socket tunnelling denied by server
Expansion The server is not capable of socket tunnelling, or it refused to allow it.
Action Upgrade or reconfigure the server.
OD0003Failed to set up socket tunnelling: %S
Expansion The client requested a socket tunnelling session be set up over this connection, but this did not succeed.
Action Consult the error message for more information.
OD0004No socket tunnelling session active
Expansion The application tried to get or set a tucket-specific attribute which requires a tucket session already active.
Action The application must start a tucket session by setting the appropriate connection attribute.
OD0005GSS authentication requested but failed to authenticate: %S
Expansion Authentication using GSS-API was requested but this did not succeed for reasons included in the error message.
Action Consult the error message.
OD0006GSS authentication requested but failed to load libgssapi: %S
Expansion Authentication using GSS-API was requested but we failed to load the libgssapi library.
Action Consult the error message.
OD0007GSS session aborted: %S
Expansion A session using GSS-API encountered a communication error, such as a disconnection, or an authentication problem such as an expired ticket.
Action Reconnect and try again.
OD0008Varchar data in result block is invalid
Expansion The ODBC driver received a result row from the server whose varchar data did not make sense. This is a bug in the ODBC driver or the server.
Action Notify Kognitio support.

PI error codes

PI0001Plugin has no WXPI_Initialise() function
Expansion server internal error
Action Notify Help Desk
PI0002Plugin WXPI_Initialise() function failure
Expansion server internal error
Action Notify Help Desk
PI0003Plugin has no WXPI_Sym_Info() function
Expansion server internal error
Action Notify Help Desk
PI0004Plugin WXPI_Sym_Info() function failure
Expansion server internal error
Action Notify Help Desk
PI0005Plugin function not yet implemented
Expansion server internal error
Action Notify Help Desk
PI0006Plugin related server internal error
Expansion server internal error
Action Notify Help Desk
PI0007Plugin initialisation ran out of memory
Expansion server internal error
Action Notify Help Desk
PI0008Error during plugin unload
Expansion server internal error
Action Notify Help Desk
PI0009Attempt to use plugin after it has been unloaded
Expansion Attempt to use plugin after it has been unloaded
Action Wait for plugin to complete unloading, reload plugin, and try again
PI000AFailed to start plugin runner
Expansion A server node was unable to fork/exec a plugin runner
Action Notify Help Desk
PI000BFailed to start plugin runner - pipe creation failed
Expansion A server node was unable to fork/exec a plugin runner because it couldn't create comms pipes
Action Notify Help Desk
PI000CFailed to start plugin runner - thread creation failed
Expansion A server node was unable to start a plugin runner because it couldn't create a comms thread
Action Notify Help Desk
PI000DBad first arg type for plugin function
Expansion The first arg to a plugin function is not of type PI_Data_Utility_Ptr
Action Notify Help Desk
PI000ENo plugin was found with the right name
Expansion We searched for a plugin function with the given name but none was found
Action Correct the data or request; then try again
PI000FNo plugin was found with compatible argument types
Expansion We searched for plugin functions with the given name. Some were found, but none would take arguments compatible to those given
Action Correct the data or request; then try again
PI0010The plugin file could not be found
Expansion The plugin file on the CP could not be found or could not be opened
Action Check resource name, check daemons are connected, check plugin file exists in the correct place, check wcsadmin can read the file
PI0011An attempt was made to use a plugin function with an invalid name
Expansion Plugin function names must be composed of the letters a-z or A-Z and are case insensitive
Action Correct the request; then try again
PI0012Plugin not found
Expansion server internal error
Action Notify Help Desk
PI0014Failed to make plugin filespace
Expansion server internal error
Action Notify Help Desk
PI0015plugin symbol lookup failed
Expansion The plugin does not contain a required symbol
Action Contact the plugin author for support
PI0016Incompatible plugin
Expansion The plugin does not support any API version the server does
Action Contact the plugin author for support
PI0017Plugin refused to unload
Expansion The plugin returned an error during the close routine
Action contact the plugin author for support
PI0018Plugin is about to be unloaded
Expansion The plugin is about to be unloaded, and cannot be used
Action Reload the plugin
PI0019Duplicate plugin number
Expansion Attempted to load multiple plugins with the same identity number
Action You probably loaded the same plugin twice. If not, contact the plugin vendor(s) for support
PI0020Cannot do this while the plugin is in use
Expansion A transaction is using the plugin so you cannot perform this operation on it
Action Wait until the plugin is idle then try again
PI0021The plugin is not loaded
Expansion An attempt was made to operate on a module which is not loaded
Action Contact support if you were not unloading a plugin
PI0022Invalid plugin resource string
Expansion The resource string you gave for the plugin was not valid
Action Check the resource string
PI0023Multiple plugins provide a function
Expansion two plugins are attempting to provide a function with the same name
Action You can only load one of these at a time. Contact the plugin author(s) if this is a problem
PI0024Module returned invalid function map
Expansion The module has a bug in it and gave invalid function info to the server
Action Contact the plugin author for support
PI0025Plugin function returned bad interval type
Expansion The module has a bug in it and gave invalid function info to the server
Action Contact the plugin author for support
PI0026Module returned invalid external data provider map
Expansion The module has a bug in it and gave invalid external data provider info to the server
Action Contact the plugin author for support
PI0027Multiple plugins provide the same external data provider name
Expansion two plugins are attempting to define the same external data provider name
Action You can only load one of these at a time. Contact the plugin author(s) if this is a problem
PI0028The external data provider was not found. If this functionality is provided by a plugin module, you may need to load the module ("create module <modulename>"). If the module is already loaded, you may need to activate it ("alter module <modulename> set mode active").
Expansion The requested external data provider was not found in the server
Action Check that you have loaded the appropriate module with "create module <modulename>" and that you have activated it with "alter module <modulename> set mode active".
PI0181Plugin failure
Expansion The plugin is in safe mode and has crashed
Action contact plugin vendor to resolve the problem or debug
PI0182Undefined plugin error
Expansion A plugin returned an undefined error code
Action Contact the plugin vendor for support
PI0183Module %S: %T
Expansion The plugin module returned an error string
Action Contact the plugin vendor for support
PI0184The plugin returned a string of the wrong length
Expansion The plugin module returned a string of the wrong length
Action Contact the plugin vendor for support
PI0185Ambiguous type for string argument to plugin function
Expansion There are multiple possible types to convert the string argument into.
Action Use an explicit cast from string to the correct type

PM error codes

PM0001Internal PMA error
Expansion An internal error occurred in the Persistent Memory Handler
Action Contact support.
PM0002Failed to create PM file
Expansion Failed to create a shared memory object
Action Check system configuration, available memory and total memory size.
PM0003Failed to size PM file
Expansion Failed to set the correct size of a shared memory object
Action Check system configuration, available memory and total memory size.
PM0004PMA map failure
Expansion Failed to map memory from PMA file
Action PMA file may be corrupt or this may be an internal error.
PM0005Invalid PMA block number
Expansion Internal error because a block number was not valid
Action Contact support.
PM0006Failed to open PMA block
Expansion Unable to shm_open a PMA block
Action Check presence of files and/or rebuild memory images
PM0007PMA out of memory
Expansion A persistent memory area is full.
Action Check PMA occupancy and unload appropriate images.

PV error codes

PV0000No room
Expansion Internal RDBMS error
Action Notify Help Desk
PV0001Not found
Expansion Internal RDBMS error
Action Notify Help Desk
PV0002Warn not setup
Expansion Internal RDBMS error
Action Notify Help Desk
PV0003Attempt to set two monitors for a parameter
Expansion Internal RDBMS error
Action Notify Help Desk
PV0004Parameter is readonly
Expansion this parameter cannot be altered
Action do not try to change this parameter directly
PV0005Parameter too large
Expansion server internal error
Action Notify Help Desk
PV0006User parameter override
Expansion server internal error
Action Notify Help Desk
PV0007Session parameter override
Expansion server internal error
Action Notify Help Desk
PV0008Using global parameter default
Expansion server internal error
Action Notify Help Desk
PV0009Internal server error - bad args passed to pvserver
Expansion server internal error
Action Notify Help Desk
PV000AParameter name invalid
Expansion The name of the parameter contained illegal characters
Action Use a different parameter name
PV000BAttempt to drop a permanent parameter
Expansion This parameter cannot be dropped
Action do not try to drop this parameter

QQ error codes

QQ0001Query queue too long
Expansion The administrator has limited the number of queries which can be queued and there are currently too many.
Action Contact your administrator for help
QQ2003Query aborted
Expansion
Action

RS error codes

RS0001Insufficient RAM for table / view
Expansion Not enough memory available to complete this operation
Action Try to Drop [Table] | [View] Image to release memory
RS0002RAM image not found
Expansion Internal RDBMS error
Action Notify Help Desk
RS0003Index not found
Expansion Internal RDBMS error
Action Notify Help Desk
RS0004Hash warning
Expansion Internal RDBMS error
Action Notify Help Desk
RS0005RAM image already exists
Expansion Internal RDBMS error
Action Notify Help Desk
RS0006Not enough memory
Expansion Not enough memory available for the temporary tables required to hold intermediate results
Action Simplify your SQL
RS0007No more records found in access
Expansion Invalid SQL
Action Check your SQL statements; then try again
RS0008Insufficient RAM for query
Expansion Internal RDBMS error
Action Notify Help Desk
RS0009Invalid delete
Expansion DELETE is not permitted whilst this row is locked
Action Try again when the row is unlocked
RS000ARecord too large
Expansion This record is too large for the available Query Manager buffer
Action Split your record into parts
RS000BInsufficient RAM to create index
Expansion Not enough memory available for the Memory handler process to build key indexes
Action Simplify your SQL statements or try to Drop Table Image to release space or wait to try again later
RS000CLogged operation on temporary table
Expansion Internal error -- operation makes no sense on a temporary table
Action Contact support.
RS000EInternal record too large
Expansion A ram record longer than 32Kbytes was created
Action Contact support/modify your query.
RS000FInsufficient RAM for Query
Expansion Not enough memory available to complete this operation
Action Try to Drop [Table] | [View] Image to release memory
RS0010Insufficient RAM for operation
Expansion Not enough memory available to complete this operation
Action Try to Drop [Table] | [View] Image to release memory
RS0011Internal failure to restart access component
Expansion Internal error, contact support
Action contact support
RS0012Internal data bucket corruption
Expansion Internal error, contact support
Action contact support
RS0013Internal data corruption
Expansion Internal error, contact support
Action contact support
RS0014Bad record length for internal record insert
Expansion Internal error, contact support
Action contact support
RS0015Incorrect internal record scan length
Expansion Internal error, contact support
Action contact support
RS0016Temporary resource allocation failure
Expansion An internal resource allocator failed to allocate resources
Action This is usually a bug so please report it to support. If you get a lot of these, try adding RAM, shrinking queues or removing some table images
RS0017Too many record matches in fetch
Expansion Internal error, contact support
Action contact support
RS0018Randomly generated error for testing
Expansion This should never come out unless testing parameters are set
Action Check settings or contact support
RS0019Internal consistency check error
Expansion The query generated an inconsistent set of data due to a server bug
Action Contact support
RS001AReplicated operation missing record
Expansion An internal error caused when a record in a replicated table is missing from some ramstores
Action Contact support
RS001BInternal disk address map not found
Expansion Internal RDBMS error
Action Notify Help Desk
RS001CUnable to soak stream data
Expansion Internal error should never be seen externally. Ramstore failed to soak an import block because operation ended early.
Action Contact support
RS0020broken error code should never come out
Expansion You should not see this. It was an error mistakenly defined and given text in older SW
Action Contact support
RS0021Connector IPC buffer overflow
Expansion The external connector sent too many messages between instances
Action This is a problem with the connector, contact the developer for support
RS0022Invalid Connector IPC destination
Expansion The external connector sent a message to an invalid destination
Action This is a problem with the connector, contact the developer for support
RS0023Error writing to external script pipe
Expansion Data could not be properly sent to the external script. It may have exited without consuming all data.
Action Check the server logs and debug the script.
RS0024Error launching the external script
Expansion The external script could not be launched.
Action Check the script and interpreter exist and that the temp filesystem is not full.
RS0025The external script returned an error. For details run "table IPE_MY_LAST_SCRIPT_DEBUG order by SEQ".
Expansion The external script returned with a non-zero exit code or exited with a signal. For details look at IPE_MY_LAST_SCRIPT_DEBUG or IPE_SCRIPT_DEBUG.
Action Check the logs and debug the script.
RS0026Could not initialise zlib state to decompress block
Expansion The zlib call inflateInit() failed. This could be due to a lack of memory or a mismatch between the version of zlib installed and the version assumed by Kognitio.
Action Check zlib is properly installed.
RS0027Decompressed WCB block longer than expected
Expansion A compressed WCB block expands to larger than the WCB block says it does.
Action This is probably caused by a corrupt WCB file. Use another WCB file, or notify the help desk if the problem persists.
RS0028zlib decompression failed
Expansion The call to zlib's inflate() function failed, possibly because the data in a compressed WCB block was not a valid zlib block.
Action Notify help desk.
RS0029External scripting feature is not enabled in the configuration file
Expansion External scripts need to be activated in the config file with the [boot options] external_scripts setting.
Action Activate external scripts.
RS002Azlib compression failed
Expansion The call to zlib's deflate() function failed, possibly because the data in a compressed WCB block was not a valid zlib block.
Action Notify help desk.
RS002BCompressed block too large
Expansion A zlib-compressed block turned out to be larger than the maximum size allocated for it. This shouldn't happen, as we allocate a buffer big enough to hold the compressed version of any message of a certain size.
Action Notify help desk.
RS002CCannot recover as partially completed operation left memory in an inconsistent state
Expansion A previous instance of the server was in the middle of an atomic operation on the memory image when it was stopped.
Action Rebuild images.
RS002DCannot recover due to previous failure during recovery
Expansion A previous instance of the server failed while recovering memory images rendering them unusable.
Action Rebuild images.
RS002EFailed to create a core PMA for data. Check SMD's output log for info
Expansion We failed to run the wxpmatool command to create a persistent memory area for data.
Action Check logs, available memory space, etc.
RS002FUnable to recover a PMA because the blockmap is bad
Expansion The persistent memory image for the server is corrupted.
Action Rebuild images.
RS0030Unable to recover a PMA because the table data is bad
Expansion The persistent memory image for the server is corrupted.
Action Rebuild images.
RS0031Cannot recover images as one or more slices are incomplete
Expansion The image set was never created fully and cannot be recovered.
Action Rebuild images.
RS0032Cannot recover images as the data format version is incorrect
Expansion The image set must be rebuilt to run with this version of the software.
Action Rebuild images.
RS0033No partition available for record insertion
Expansion Internal error -- the server could not find a partition in which to insert the record.
Action Contact support.
RS0034Image partition limit reached
Expansion Record insertion would cause the image to have more than the maximum allowed number of partitions.
Action Reconfigure to allow more partitions or change the image definition to create fewer.
RS0035Partition key too long
Expansion An inserted record uses a partition key which is too large.
Action Change the image definition to create shorter keys.
RS0036Cannot recover images as the server was in the process of rebuilding the image set
Expansion The image set must be rebuilt to run with this version of the software.
Action Rebuild images.
RS0037Internal record reassignment to an invalid location
Expansion This is an internal error caused by an attempt to update a record's disk location with an invalid value.
Action Contact support.
RS0038Internal record corrupted with invalid disk number
Expansion This is an internal error caused by record with an invalid disk number in the header.
Action Contact support.
RS0039Internal record reassignment source locations do not match
Expansion This is an internal error caused when we attempt to update a record's disk location but the original location doesn't match what we thought it would be.
Action Contact support.
RS003AUnable to fetch data from external data source
Expansion The fetch method of the external data source returned an error, but did not specify any details.
Action Check the server debug log, or contact the writer of the plugin if applicable.
RS003BAccess message too long
Expansion A query plan step generated a message longer than the rs_max_msglen setting allows.
Action Change query or adjust the rs_max_msglen parameter appropriately.
RS003CCorrupted fragmented message during delivery
Expansion An internal error corrupted a fragmented message preventing reassembly.
Action Contact support.
RS003DInsufficient memory to assemble fragmented message
Expansion An large message was sent and the receiver was not able to allocate enough memory to hold it.
Action Check query, check concurrent workload. Try to reduce query complexity and/or relieve memory pressure on the system. Contact support if unclear how to resolve this.
RS003EExternal script IPC message too long
Expansion an external script performed an IPC operation which sent a message bigger than the limit allowed.
Action Debug the script or review the server's memory block size.
RS003FError occurred while communicating with external process
Expansion An error occurred while comminicating with the XSI library on an external script process.
Action Debug the script, check serverdbg then contact support.
RS0040Invalid target for XSI message
Expansion An external script generated a message to an invalid target.
Action Debug the script.
RS0041XSI event sequence error
Expansion An event occurred out of the proper sequence during execution of an XSI script.
Action Debug the script, check for exits during sync, race conditions or other calls that are made at the wrong time.
RS0042Invalid input source number
Expansion An external program requested data for an input source that isn't present.
Action Debug the script, check for calls to get information about input sources.
RS0043Invalid debug message sent from external process
Expansion An external program sent a corrupted debug information message into the server.
Action Debug the script, look for memory overwrites and other data corruption bugs.
RS0044Invalid external script state file
Expansion The state file given by the external script was invalid or could not be opened
Action preserve script directory on exit, check state file location, permissions, etc.
RS0045Internal ramstore cardinality check error
Expansion A subquery produced more than one row where it should only produce one. But this error should be changed internally before you see it
Action Check query for unique constraint violations and/or contact support.
RS0046The script environment interpreter could not be run. For details run "table IPE_MY_LAST_SCRIPT_DEBUG order by SEQ".
Expansion The interpreter command for the script environment does not exist, is not present in $PATH or is not executable. For details look at IPE_MY_LAST_SCRIPT_DEBUG or IPE_SCRIPT_DEBUG.
Action Check the logs and check the script environment definition.
RS0065Invalid date value
Expansion Operation produced an invalid date value
Action Contact the help desk
RS0067Invalid timestamp value
Expansion Operation produced an invalid timestamp value
Action Contact the help desk
RS0068Invalid time value
Expansion Operation produced an invalid time value
Action Contact the help desk
RS006AYear-month interval overflow
Expansion Precision of year-month interval value is too small
Action Contact the help desk
RS006BDay-time interval overflow
Expansion Precision of day-time interval value is too small
Action Contact the help desk
RS0088 Interval field overflow
Expansion An interval value has overflowed the maximum number of digits in its leading field
Action Examine your query and data; then try again
RS0100Arithmetic overflow
Expansion You have tried to multiply values to a sum beyond the implementation limit
Action Check your program logic; then try again
RS0101Division by zero
Expansion You have tried to divide by zero
Action Check your program logic; then try again
RS0102Invalid Trim specification
Expansion An attempt was made to TRIM a character string which contained an invalid specification
Action Correct the data or request; then try again
RS0103Insufficient string space for operation
Expansion An attempt was made to CAST a character string into another data type but there is insufficient space to complete the operation
Action Correct the data or request; then try again
RS0104Bad regular expression
Expansion The regular expression is incorrectly formatted
Action Correct the data or request; then try again
RS0105Not enough memory to generate code
Expansion Not enough memory to generate code
Action Either simplify the query, or free up some memory
RS0106Internal code generator error
Expansion an internal error has occurred
Action contact support
RS0107Internal error running generated code
Expansion an internal error has occurred
Action contact support
RS0108Null value inserted into non-null column
Expansion Null value inserted into non-null column
Action add a 'where field is not null' to the query or make target nullable
RS0109Invalid month parameter given to PACKDATE(year, month, day)
Expansion Only values of 'month' where 1<=month<=12 are allowed when using PACKDATE
Action Correct the data or request; then try again
RS010BToo many plugin functions used
Expansion The SQL query uses too many plugins in one expression
Action Simplify the query
RS010CCardinality error
Expansion A row was joined to more than one row where this is not allowed
Action Check query
RS010EGenerate key is invalid in this context
Expansion The generate_key function was used somewhere where it is not allowed
Action Check query
RS010AInvalid day parameter given to PACKDATE(year, month, day)
Expansion The day of the month must be between 1 and 28, 29, 30, or 31 (depending on the month and leap year)
Action Correct the data or request; then try again
RS010DInvalid parameter given to TIME(H, M, S)
Expansion The time function must be given valid values 0-23,0-59,0-59
Action Correct the data or request; then try again
RS0110Internal Error: Index register allocation failed
Expansion This is an internal error, contact support.
Action contact support
RS0111Internal Error: Column projection too big
Expansion Attempted to project a column into a space that was too small.
Action contact support
RS0112Internal Error: Lookup value is NULL
Expansion Attempted to use a NULL value as an internal array index.
Action contact support
RS0113Internal Error: Lookup value not found
Expansion Unable to find a lookup value in an internal array.
Action contact support
RS0114Internal Error: saved bucket queue is full
Expansion This should never happen, something should drain it.
Action contact support
RS0115Internal Error: Unable to restart access stream
Expansion The query attempted to restart an unrestartable operation.
Action contact support
RS0116Internal Error: Varchar data is corrupted
Expansion An internal data structure became corrupted.
Action contact support
RS0117Internal Error: Hint record leakage
Expansion A hint record leaked into an incorrect place.
Action contact support
RS0118The number of buckets in width_bucket() must be at least 1
Expansion Change the number of buckets so that it is greater than zero
Action Correct the data or request; then try again
RS0119The range in width_bucket must be non-zero
Expansion The min and max values specified in width_bucket() are equal
Action Correct the data or request; then try again
RS011ANo match found for join record
Expansion A record did not join to any records in a lookup table
Action Correct the data or request; then try again
RS011BSAME_VALUE found different values
Expansion The SAME_VALUE aggregate received different non-NULL values, but they should all be the same
Action Correct the data or request; then try again
RS011CONE_VALUE found multiple values
Expansion The ONE_VALUE aggregate received multiple non-NULL values, but they should be at most one
Action Correct the data or request; then try again
RS011DInternal error, invalid disk block passed to scan.
Expansion A disk scan was passed a block which does not contain a valid forward chain of records for the appropriate table
Action Contact support
RS011EInvalid binary record length from external source
Expansion An external program outputed a binary record with an invalid length.
Action Check query and external source (script or table)
RS011FPartial binary record from external source
Expansion An external program sent a partial binary record and then terminated.
Action Check query and external source (script or table)
RS0120A string contained a partial character
Expansion A string in the database contains an incomplete character (e.g. 2 bytes of a utf-32).
Action Check data and contact support
RS0122Incorrect value size for cast from binary
Expansion A value was cast from a binary to a type with incompatible length.
Action Check binary casts in the query and correct
RS0123Internal error -- Incorrect lengths for approx count distinct merge
Expansion The server tried to merge two approx distinct lists of different lengths. This should not happen
Action Contact support
RS0124Internal error: imported record sent with invalid length
Expansion A record imported using wxloader, wximport or an external table or script has been presented for conversion with an invalid length on it.
Action Contact support.
RS0125External text record too long
Expansion A CSV or other text record obtained from an external connector or script appears to be longer than the implementation limit.
Action Check the external data for long records.
RS0126External text record too long: encountered a record which is either too long or contains an unterminated quote
Expansion A CSV or other text record obtained from an external connector or script appears to be longer than the implementation limit. This may be because a record is very large, or because a record contains an unmatched quote. More information may be found in serverdbg or in SYS.IPE_CONV_ERROR.
Action Check the external data for long records or unmatched quotes, or check serverdbg and SYS.IPE_CONV_ERROR.
RS0181Plugin failure
Expansion The plugin is in safe mode and has crashed
Action contact plugin vendor to resolve the problem or debug
RS0182Undefined plugin error
Expansion A plugin returned an undefined error code
Action Contact the plugin vendor for support
RS0183Module %S: %T
Expansion The plugin module returned an error string
Action Contact the plugin vendor for support
RS0184The plugin returned a string of the wrong length
Expansion The plugin module returned a string of the wrong length
Action Contact the plugin vendor for support
RS0185Ambiguous type for string argument to plugin function
Expansion There are multiple possible types to convert the string argument into.
Action Use an explicit cast from string to the correct type
RS0200Substring error
Expansion An attempt was made to perform a Select Substring which contained an invalid specification
Action Correct the data or request; then try again
RS0201Insufficient string memory
Expansion An attempt was made to perform a string operation for which there was insufficient memory
Action Correct the data or request; then try again
RS0202Character string too long
Expansion An attempt was made to insert a character string that exceeds the defined length of a column
Action Correct the data or request; then try again
RS0203Invalid character value for cast
Expansion An attempt was made to CAST a character string into another data type but it contained characters that could not be converted
Action Correct the data or request; then try again
RS0204Numeric overflow during conversion
Expansion An attempt was made to CAST a character string into another data type but this resulted in an overflow
Action Correct the data or request; then try again
RS0205Numeric underflow during conversion
Expansion An attempt was made to CAST a character string into another data type but this resulted in an underflow
Action Correct the data or request; then try again
RS0206minchars parameter to string function too large or negative
Expansion The value specified for the minchars parameter to a string function was not in the range of allowed values
Action Correct the data or request; then try again
RS0207Invalid value specified for base parameter to string function
Expansion The value specified for the base parameter to a string function was not an allowed value
Action Correct the data or request; then try again
RS0208Invalid character value for string function
Expansion An attempt was make to use a string function such as strtoint() or strpackints() on an invalid string
Action Correct the data or request; then try again
RS0209Invalid 'count' parameter for string function
Expansion strunpackints() or strpackints() was called with an invalid 'count' parameter
Action Correct the data or request; then try again
RS020AInvalid 'bits' parameter for string function
Expansion strunpackints() or strpackints() was called with an invalid 'bits' parameter
Action Correct the data or request; then try again
RS020B'bits' * 'count' > 64 in strunpackints()
Expansion Too many bits specified for strunpackints
Action Correct the data or request; then try again
RS020CInvalid separator for string function
Expansion strunpackints() strpackints() strcount() or strchop() was called with a separator that was not a char(1)
Action Correct the data or request; then try again
RS020DZeroth element selected as strpos(,,0) or strchop(,,0,) or strchop(,,,0)
Expansion Only none zero positive or negative values are allowed for the 'start' and 'end' parameters to strchop() and the 'occurence' parameter to strpos()
Action Correct the data or request; then try again
RS020EAttempt to search for a zero length string
Expansion The second parameter given to strpos() evaluated to a zero length string
Action Correct the data or request; then try again
RS020FAttempt to strpackints() a string with too few segments
Expansion The string given to strpackints() did not contain as many segments as were specified in the count argument.
Action Correct the data or request; then try again
RS0210Attempt to strpackints() a string with too many segments
Expansion The string given to strpackints() contained more segments than were specified in the count argument.
Action Correct the data or request; then try again
RS0211Product of count and bits params to strpackints greater than 64
Expansion The result of strpackints is limited to 64 bits, so count*bits must be between 0 and 64.
Action Correct the data or request; then try again
RS0212Result of strunpackints too large for format
Expansion The number to be unpacked by strunpackints was too large to fit in the output format.
Action Correct the data or request; then try again
RS0213String wrong length for function
Expansion The string supplied is of the wrong length for the function
Action Correct the data or request; then try again
RS0214Invalid string representation
Expansion There was a string with an invalid representation for its character set.
Action Contact the help desk
RS0215Codepoint not in character set
Expansion There was a character not available in the destination character set during conversion.
Action Correct the data or request; then try again
RS0216Unknown character set
Expansion An unknown character set was specified.
Action Contact the help desk
RS0217Bad number of octets per character
Expansion There was an invalid number of octets per character defining a character set.
Action Contact the help desk
RS0218Bad translation table range
Expansion There was an invalid translation table defining a character set.
Action Contact the help desk
RS0219Internal error in character conversion
Expansion An unknown error occurred while doing a character set conversion.
Action Contact the help desk
RS0250Invalid string for to_number
Expansion An invalid string was supplied to to_number()
Action Check your SQL statement; then try again
RS0251Invalid format string
Expansion An invalid format string was used
Action Check your SQL statement; then try again
RS0252Invalid format string
Expansion An invalid date specifier was used
Action Check your SQL statement; then try again
RS0253Bad value in date string
Expansion The date string contained an bad value
Action Check your SQL statement; then try again
RS0254Internal error - ran out of digits!
Expansion An internal error occurred
Action Contact the help desk
RS0255Too many significant digits passed to to_number
Expansion Too many significant digits were passed to to_number() - use an explicit cast
Action Check your SQL statement; then try again
RS0256Invalid day number
Expansion An invalid day number was specified
Action Check your SQL statement; then try again
RS0257No year was specified
Expansion No year was specified
Action Check your SQL statement; then try again
RS0258FX specified but wrong number of digits
Expansion Invalid input - FX specified but wrong number of digits
Action Check your SQL statement; then try again
RS0901Access Deferred
Expansion This is an internal error, you should never see this.
Action Contact support.
RS0902Space warning -- rs low on ram
Expansion This is an internal error, you should never see this.
Action Contact support.
RS2003Query aborted
Expansion
Action

SH error codes

SH0001No compilers free
Expansion No compiler processes available
Action Try again later

SS error codes

SS0001Insufficient resources available for task
Expansion There were insufficient resources available to create the required number of contexts for the script
Action Examine concurrent resource usage, machine resource levels and concurrency controls
SS0002Script operation not found
Expansion Internal error trying to look up a script in the script scheduler service
Action Contact support

TH error codes

TH0001No query managers free
Expansion No Query Manager processes available
Action Try again later

TS error codes

TS0101Local time occurs more than once
Expansion Attempted to set a local time which has more than one possible GMT time
Action use the tadj parameter to set time or set to a time which only occurrs once
TS0102Timeserver readonly
Expansion Attempted to change the time but the clock is read only
Action set tfix parameter to 0 to make the clock read-write
TS0103Unable to set local time
Expansion The local time could not be set. Perhaps the time is in a hole or repeated block caused by a DST change?
Action Check query