WX/DES Error Codes

Navigation Links

AD0xxx AH0xxx AH2xxx AI0xxx AI2xxx AM0xxx AM2xxx CG0xxx CG2xxx CI0xxx CI1xxx CI2xxx CI3xxx CI4xxx CI5xxx CI7xxx CI8xxx DA0xxx DA2xxx DO0xxx DP0xxx DS0xxx DS2xxx EC1xxx ET0xxx IE0xxx IE1xxx IO0xxx IO2xxx LC0xxx LF0xxx LF2xxx MP0xxx NF0xxx OD0xxx PI0xxx PM0xxx PV0xxx QQ0xxx QQ2xxx RS0xxx RS2xxx SH0xxx SS0xxx TH0xxx TS0xxx

CodeErrorExpansionAction
AD0xxx
AD0100Internal error processing query planThere was an internal error which produced a bad query plan Contact support
AD0101Internal ungrouped projection on one row aggregateThere was an internal error which produced a bad query plan Contact support
AD0102Internal projection from inner table in subqueryThere was an internal error which produced a bad query plan Contact support
AD0103Window function used internally in incorrect contextThere was an internal error which produced a bad query plan Contact support
AD0104Invalid node in internal r.p.There was an internal error which produced a bad query plan Contact support
AD0105Invalid hash column specified in internal query planThere was an internal error which produced a bad query plan Contact support
AD0106Invalid ram projection column specified in internal query planThere was an internal error which produced a bad query plan Contact support
AD0107Access description overflowInternal data structure overflow. Contact support
AD0108Invalid internal variable referenceGenerated query plan references an invalid variable. Contact support
AD0109Duplicate internal variable definitionGenerated query plan defines a duplicate internal variable. Contact support
AD010AInternal access side reference badGenerated query plan contains references to an invalid join side number. Contact support
AH0xxx
AH0001Sessions inhibitedYou 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. Wait and try again later
AH0002Cannot allocate global session because other users are logged inYou cannot issue any of these commands if another user session is currently logged in: LOCK SYSTEM, CREATE IMAGE, CREATE SYSTEM IMAGE, NEW SYSTEM. Wait and try again later
AH0003Uncommitted transaction list overflowInternal RDBMS error Notify Help Desk
AH0004This operation requires a global sessionThe requested operation requires a global lock Global locks are set in response to a CREATE [SYSTEM] IMAGE or you can set the lock with LOCK SYSTEM command
AH0005No more sessions allowedThe maximum number of sessions allowed on this server has been reached Consult your System Administrator
AH0006Invalid value for maximum sessionsThe maximum number of sessions which you are trying to set is not permitted Amend your CREATE USER or ALTER USER statement; then try again
AH0007system is not initialisedConcurrent sessions are only enabled after 'create image' or similar initialise the system with create image or similar or only use one session
AH0008Invalid transaction numberA transaction number given to the AH is not known. This error can occur if a query is aborted. In other circumstances, contact the maintainers.
AH0009Invalid session numberA session number given to the AH is not known. This error may occur if a session is aborted, but should not be returned to the client.
AH2xxx
AH2003Query aborted
AI0xxx
AI0000Too many ORsInternal RDBMS error Notify Help Desk
AI0001The operation cannot be doneInternal RDBMS error Notify Help Desk
AI0002File not loadedInternal RDBMS error Notify Help Desk
AI0003Out of spaceInternal RDBMS error Notify Help Desk
AI0004No disk spaceInternal RDBMS error Notify Help Desk
AI0005Out of memoryYour enquiry needs more memory than is available Either Drop Table Image to release memory or wait to try later
AI0006Invalid disk positionYou have specified an invalid disk identifier for one of the commands FORMAT, SPIN UP or RECREATE Check IPE_DISK
AI0007Invalid checksumInternal RDBMS error Notify Help Desk
AI0008Invalid operation on virtual tableVirtual system tables (such as IPE_SYSTEM) allow a restricted set of update operations Modify the SQL statement and start again
AI0009Disk not foundDisk for formatting/extraction could not be found Check disk details. If trying to extract a virtual disk, need to just replace and reboot instead
AI000AStream Index not foundStream index cannot be found for codejoin conversion Internal error. Please contact support.
AI000BCardinality errorAn operation returned multiple rows when it should only return 1 or 0 Check query.
AI000CCannot move system table recordsCannot move records for system tables with repack/redistribute Leave system table records unmoved on disk
AI000DToo many access restartsA limit has been set on how many times operations can be repeated in a query Increase the limit, change the query or retry with more resources
AI000EToo many record recomputationsA limit has been set on how many times values can be recomputed in a query Increase the limit, change the query or retry with more resources
AI000FAccess retry timeout exceededA limit has been set on how long an operation can keep being restarted for Increase the limit, change the query or retry with more resources
AI0010Invalid header type in internal s-code structureAn internally generated header type in the query plan is not valid. Contact support
AI0011Internal error: size of keyed fetch is too bigAn internal attempt to fetch rows from a table tried to fetch more than the permitted number of rows at once. Contact support
AI0012Internal error: Ramstore group not found in lookupAn internal attempt to lookup the ramstore group containing an object has failed. Contact support
AI0101External access operation has no active processes due to exclusionsAn external operation has been defined with limits which prevent it from starting any threads (e.g. disallowing every node) Correct the thread or node limits and retry
AI0102Debug checking for the nostats flag is enabled and a check failedThis 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 Clear the ai_statschk parameter and retry
AI2xxx
AI2003Query aborted
AM0xxx
AM0001Cursor lock violationLocks prevent update of tables with open cursors Check your program logic; then try again
AM0002Cursor not foundYou must declare a cursor for this operation Check your program logic; then try again
AM0003Cursor not updatableTo Update or Delete Where Current of Cursor is valid only for tables and not for views or joins Check your program logic; then try again
AM0004Missing argument specificationRDA routines require arguments to Declare Cursor and Open Cursor Check your SQL statements; then try again
AM0005Duplicate cursor nameYou have used the same name as a declared cursor Check your SQL statements; then try again
AM0006Invalid cursor operationYour cursor operations do not follow the correct sequence Resubmit in the correct sequence
AM0007Invalid repeat count on raw diskYou have breached the implementation limit Simplify your SQL syntax and try again
AM0008Invalid argument specification on raw diskYou have breached the implementation limit Simplify your SQL syntax and try again
AM0009Invalid disk id specified by raw disk commandInvalid ID specified in SQL Check your SQL; then try again
AM000AInvalid raw disk operationYou have breached the implementation limit Simplify your SQL syntax and try again
AM000BAttempt to write past end of diskYou have breached the implementation limit Amend your SQL syntax and try again
AM000CInvalid data length for restoreYou have breached the implementation limit Amend your SQL syntax and try again
AM000DTransaction no longer validInternal RDBMS error Notify Help Desk
AM000ECursor no longer validThis cursor is not known Amend your SQL syntax and try again
AM000FInvalid Processor IDInvalid ID specified in SQL Check your SQL; then try again
AM0010Invalid direct export operationUser developed application has performed an invalid operation Check your program logic; then try again
AM0011Invalid direct import operationUser developed application has performed an invalid operation Check your program logic; then try again
AM0012Checksum in WCB block is incorrectImport file is either corrupt or not in WCB format Check file format and import parameters; then try again
AM0013Invalid WCB block formatImport file is either corrupt or not in WCB format Check file format and import parameters; then try again
AM0014Import field specification does not match table definitionThere is a mismatch between the table definition on the server and in the WCB file Check table and file definitions
AM0015WCB import version number incompatibleImport file is either corrupt or not in WCB format Check file format and import parameters; then try again
AM0016WCB record length improperImport file is either corrupt or not in WCB format Check file format and import parameters; then try again
AM0017Invalid initialise from RDAInternal RDBMS error Notify Help Desk
AM0018Invalid begin transaction from RDAInternal RDBMS error Notify Help Desk
AM0019Query with no transaction from RDAInternal RDBMS error Notify Help Desk
AM0020Password check failedThe password you have entered fails to meet the specification for this user ID or security class Consult your System Administrator
AM0021Prohibited by login restrictionsThe action you have selected is not allowed by the rules governing your user ID or security class Consult your System Administrator
AM0022Maximum login failures exceededThere have been too many failed login attempts Consult your System Administrator
AM0023User inactive too longThis user ID has expired Consult your System Administrator
AM0024Unknown userThe user ID used to log in is not recognised; this user may have been suspended Consult your System Administrator
AM0025Unknown security classThe security class you have specified is not recognised Consult your System Administrator
AM0026Login has been revokedYou have attempted to log in to a server to which you do not have access Consult your System Administrator
AM0027Password has expiredYou have attempted to log in using a password which is not legal in your security class Consult your System Administrator
AM0028Session inactivity period exceededThis session has been inactive too long and so has been terminated Consult your System Administrator
AM0029Invalid user statusInvalid status associated with this user ID Consult your System Administrator
AM002AInvalid username lengthThe user name you have tried to enter is too long Amend your CREATE USER or ALTER USER statement; then try again
AM002BGarbled challenge responseThe client's response to the authentication challenge sent by the server wasn't even recognisable. Report this to the maintainers.
AM002CUnknown authentication methodThe client is asking to authenticate in a manner unfamiliar to the server, or which the server cannot perform. 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 operationsAn operation such as NEW SYSTEM, CREATE [SYSTEM] IMAGE or RECLAIM is not the first in a transaction 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 operationAn operation such as NEW SYSTEM, CREATE [SYSTEM] IMAGE or RECLAIM is not the first in a transaction Consult your System Administrator
AM0032Connection has been bounced for load-balancingThe AH has determined that there is a better IP address/port combination for the connection, so try connecting to that The WCSODBC driver should connect to the alternative supplied
AM0033stored pointer passed into AM could not be found on stored listOccurred once at customer site, cause unclear. May be due to client behaving erroneously??? Notify Help Desk
AM0034Too many open cursors for the sessionThis session has reached its limit for open cursors - no more can be opened without first closing some of its existing cursors 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 onlyODBC connection must come from a trusted source port (<=1023) change adm_login_mode parameter or contact system administrator
AM0036Login mode set to sys onlyOnly sys may log into the machine change adm_login_mode parameter or contact system administrator
AM0037Login mode set to localhost onlyConnections to the DES must be made through localhost on the CP change adm_login_mode parameter or contact system administrator
AM0038Import invoked after import finishedThe client has sent an invoke request for an import which has ended. Notify help desk
AM0039Inconsistency in user and password system tablesThe password referred to for a user in IPE_ALLUSER does not exist in IPE_PASS_HIST. Notify help desk.
AM003ARecord too long and cannot merge fragmented blocks in this formatBulk-loaded blocks of data need to be merged due to long records, but this format doesn't allow that. 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%TThe number of conversion errors returned for a file exceeded the user imposed limit. Further conversion errors were not reported. Correct the data file or format string and try again.
AM003CSession is not initialisedThe client is trying to submit queries without first submitting a successful login command. The ODBC driver should never do this. Contact WX2 helpdesk.
AM003DError decompressing blockA compressed WCB block contained data that was not valid zlib-compressed data. ZWCB file corrupted. Re-export the file, or contact helpdesk.
AM003EZWCB decompressed length wrongA ZWCB file claimed the uncompressed length of a block was shorter than the actual uncompressed length. ZWCB file corrupted. Re-export the file, or contact helpdesk.
AM003FInvalid ZWCB subblock lengthThe 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. If this file was produced by wxunloader or wxwcbzip, it indicates a bug. Contact helpdesk.
AM0040Transaction has been aborted and rolled backYour transaction has been forcibly closed and rolled back by the system or by another session. 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 reachedThe import operation or connection cannot be completed because the process has used up all the communication channel slots available to it. Connect to a different node or try again when the system is less busy.
AM0042Cannot skip records when loading compressed WCBIt is not possible to skip records when loading compressed WCB into the database. 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 requestInternal RDBMS error: Invalid privilege request Notify Help Desk
AM0044Unable to count previous login failures because SYS.IPE_ALLLOGIN is not imagedThe 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. Put SYS.IPE_ALLLOGIN in RAM. As the SYS user, run CREATE TABLE IMAGE SYS.IPE_ALLLOGIN.
AM0045Server unable to use libcrypto libraryThe 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. Ensure 32-bit libcrypto is installed on all DB nodes.
AM0046Conversion errors used too much memoryThere 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. Use a smaller conversion error limit.
AM0047More than 32000 conversion errors for one block of import dataThere 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. Check the wxloader options and/or fix your data file.
AM0048Remote listener group sync failedThe server tried to tell the client that it had finished opening remote listening sockets on the client side, but couldn't. This error is for internal use.
AM0049JSON syntax error: %SA JSON syntax error was discovered when searching for the target array or in splitting up the array into objects. Correct your JSON and try again.
AM004ATarget array not found in root object of JSON documentA target array was specified for a JSON import, but no array of that name exists in the root object of the JSON document. 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 policyYou attempted to change your password while logging in, perhaps because your existing password has expired, but the server policy prohibits this. Consult your system administrator. The SYS user has the privilege to reset users' passwords.
AM004CAuthentication failedAuthentication failed for miscellaneous reasons. This is probably because the user has tried to present themselves as a certain principal name without authenticating.
AM004DServer failed to load libgssThe server failed to load the libgss API. Make sure the libgss API is installed on all nodes.
AM004EServer failed to acquire credentialThe server failed to acquire its credential using GSS, so authentication cannot be performed with this method. Consult your system administrator.
AM004FAuthentication succeeded but you are not authorised to log on as this userThe authentication step succeeded, but your principal name is not in the IPE_ALLPRINCIPAL_NAME table along with the user ID you specified. 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 usernameThe principal you've authenticated as is not a member of an external group which is allowed to log in with an automatically-created user. 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 failedYour login failed for unspecified reasons. Contact your system administrator.
AM0052Key authentication failedAn attempt to log in using public-private key authentication failed 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 inYour 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. Contact your system administrator.
AM0054Automatic transaction commit failedA server-side automatic commit of a transaction failed. Contact Kognitio support.
AM0055Syntax error or access violationYou do not have sufficient privileges to perform this query. Contact your database administrator.
AM0056Unknown RDA errorThe server tried to send back an error that doesn't have an error code. This is a bug. Contact Kognitio support.
AM0057Unrecognised Avro codecThis Avro data has been encoded with a codec which we do not recognise. Obtain the data in a different Avro codec.
AM0058No Avro schema suppliedAn Avro load was attempted, but the WCB header block sent to the server by the client did not specify the Avro schema. This is a bug in the client.
AM0059No Avro sync marker suppliedAn Avro load was attempted, but the WCB header block sent to the server by the client did not specify the block sync marker. This is a bug in the client.
AM0060Fatal data load error: %SAn error occurred which has resulted in the load being abandoned. Refer to the error context.
AM2xxx
AM2003Query aborted
CG0xxx
CG0001Code too complexNot enough buffer memory to return code from the T-Code generator Simplify your SQL statements; then try again
CG0002Illegal escape in LIKEYou cannot specify this as an escape character in a LIKE operation Choose another character as your escape character for the search
CG0004Unhandled internal generator exceptionThere was an unhandled internal error in the machine code generator Please report this to support
CG0005Generated code too largeThe query requires WX2 to generate a block of code which is too large Change the size limit (cg_max_gencode parameter) or contact support
CG002AInvalid EUC double byte characterA Kanji LIKE pattern contains an invalid Kanji character Check the LIKE expression; then try again
CG002BEscape at end of patternA Kanji LIKE pattern has a trailing escape character Check the LIKE expression; then try again
CG0065Invalid date valueOperation produced an invalid date value Contact the help desk
CG0067Invalid timestamp valueOperation produced an invalid timestamp value Contact the help desk
CG0068Invalid time valueOperation produced an invalid time value Contact the help desk
CG006AYear-month interval overflowPrecision of year-month interval value is too small Contact the help desk
CG006BDay-time interval overflowPrecision of day-time interval value is too small Contact the help desk
CG0088 Interval field overflowAn interval value has overflowed the maximum number of digits in its leading field Examine your query and data; then try again
CG0100Arithmetic overflowYou have tried to multiply values to a sum beyond the implementation limit Check your program logic; then try again
CG0101Division by zeroYou have tried to divide by zero Check your program logic; then try again
CG0102Invalid Trim specificationAn attempt was made to TRIM a character string which contained an invalid specification Correct the data or request; then try again
CG0103Insufficient string space for operationAn attempt was made to CAST a character string into another data type but there is insufficient space to complete the operation Correct the data or request; then try again
CG0104Bad regular expressionThe regular expression is incorrectly formatted Correct the data or request; then try again
CG0105Not enough memory to generate codeNot enough memory to generate code Either simplify the query, or free up some memory
CG0106Internal code generator erroran internal error has occurred contact support
CG0107Internal error running generated codean internal error has occurred contact support
CG0108Null value inserted into non-null columnNull value inserted into non-null column add a 'where field is not null' to the query or make target nullable
CG0109Invalid month parameter given to PACKDATE(year, month, day)Only values of 'month' where 1<=month<=12 are allowed when using PACKDATE Correct the data or request; then try again
CG010BToo many plugin functions usedThe SQL query uses too many plugins in one expression Simplify the query
CG010CCardinality errorA row was joined to more than one row where this is not allowed Check query
CG010EGenerate key is invalid in this contextThe generate_key function was used somewhere where it is not allowed Check query
CG010AInvalid day parameter given to PACKDATE(year, month, day)The day of the month must be between 1 and 28,29,30, or 31 (depending on the month and leap year Correct the data or request; then try again
CG010DInvalid parameter given to TIME(H, M, S)The time function must be given valid values 0-23,0-5,0-59 Correct the data or request; then try again
CG0110Internal Error: Index register allocation failedThis is an internal error, contact support. contact support
CG0111Internal Error: Column projection too bigAttempted to project a column into a space that was too small. contact support
CG0112Internal Error: Lookup value is NULLAttempted to use a NULL value as an internal array index. contact support
CG0113Internal Error: Lookup value not foundUnable to find a lookup value in an internal array. contact support
CG0114Internal Error: saved bucket queue is fullThis should never happen, something should drain it. contact support
CG0115Internal Error: Unable to restart access streamThe query attempted to restart an unrestartable operation. contact support
CG0116Internal Error: Varchar data is corruptedAn internal data structure became corrupted. contact support
CG0117Internal Error: Hint record leakageA hint record leaked into an incorrect place. contact support
CG0118The number of buckets in width_bucket() must be at least 1Change the number of buckets so that it is greater than zero Correct the data or request; then try again
CG0119The range in width_bucket must be non-zeroThe min and max values specified in width_bucket() are equal Correct the data or request; then try again
CG011ANo match found for join recordA record did not join to any records in a lookup table Correct the data or request; then try again
CG011BSAME_VALUE found different valuesThe SAME_VALUE aggregate received different non-NULL values, but they should all be the same Correct the data or request; then try again
CG011CONE_VALUE found multiple valuesThe ONE_VALUE aggregate received multiple non-NULL values, but they should be at most one Correct the data or request; then try again
CG011DInternal error, invalid disk block passed to scan.A disk scan was passed a block which does not contain a valid forward chain of records for the appropriate table Contact support
CG011EInvalid binary record length from external sourceAn external program outputed a binary record with an invalid length. Check query and external source (script or table)
CG011FPartial binary record from external sourceAn external program sent a partial binary record and then terminated. Check query and external source (script or table)
CG0120A string contained a partial characterA string in the database contains an incomplete character (e.g. 2 bytes of a utf-32). Check data and contact support
CG0122Incorrect value size for cast from binaryA value was cast from a binary to a type with incompatible length. Check binary casts in the query and correct
CG0123Internal error -- Incorrect lengths for approx count distinct mergeThe server tried to merge two approx distinct lists of different lengths. This should not happenContact support
CG0124Internal error: imported record sent with invalid lengthA record imported using wxloader, wximport or an external table or script has been presented for conversion with an invalid length on it. Contact support.
CG0181Plugin failureThe plugin is in safe mode and has crashed contact plugin vendor to resolve the problem or debug
CG0182Undefined plugin errorA plugin returned an undefined error code Contact the plugin vendor for support
CG0183Module %S: %TThe plugin module returned an error string Contact the plugin vendor for support
CG0184The plugin returned a string of the wrong lengthThe plugin module returned a string of the wrong length Contact the plugin vendor for support
CG0185Abiguous type for string argument to plugin functionThere are multiple possible types to convert the string argument into. Use an explicit cast from string to the correct type
CG0200Substring errorAn attempt was made to perform a Select Substring which contained an invalid specificationCorrect the data or request; then try again
CG0201Insufficient string memoryAn attempt was made to perform a string operation for which there was insufficient memoryCorrect the data or request; then try again
CG0202Character string too longAn attempt was made to insert a character string that exceeds the defined length of a columnCorrect the data or request; then try again
CG0203Invalid character value for castAn attempt was made to CAST a character string into another data type but it contained characters that could not be convertedCorrect the data or request; then try again
CG0204Numeric overflow during conversionAn attempt was made to CAST a character string into another data type but this resulted in an overflowCorrect the data or request; then try again
CG0205Numeric underflow during conversionAn attempt was made to CAST a character string into another data type but this resulted in an underflowCorrect the data or request; then try again
CG0206minchars parameter to string function too large or negativeThe value specified for the minchars parameter to a string function was not in the range of allowed valuesCorrect the data or request; then try again
CG0207Invalid value specified for base parameter to string functionThe value specified for the base parameter to a string function was not an allowed valueCorrect the data or request; then try again
CG0208Invalid character value for string functionAn attempt was make to use a string function such as strtoint() or strpackints() on an invalid stringCorrect the data or request; then try again
CG0209Invalid 'count' parameter for string functionstrunpackints() or strpackints() was called with an invalid 'count' parameterCorrect the data or request; then try again
CG020AInvalid 'bits' parameter for string functionstrunpackints() or strpackints() was called with an invalid 'bits' parameterCorrect the data or request; then try again
CG020B'bits' * 'count' > 64 in strunpackints()Too many bits specified for strunpackintsCorrect the data or request; then try again
CG020CInvalid separator for string functionstrunpackints() strpackints() strcount() or strchop() was called with a separator that was not a char(1)Correct the data or request; then try again
CG020DZeroth element selected as strpos(,,0) or strchop(,,0,) or strchop(,,,0)Only none zero positive or negative values are allowed for the 'start' and 'end' parameters to strchop() and the 'occurence' parameter to strpos()Correct the data or request; then try again
CG020EAttempt to search for a zero length stringThe second parameter given to strpos() evaluated to a zero length stringCorrect the data or request; then try again
CG020FAttempt to strpackints() a string with too few segmentsThe string given to strpackints() did not contain as many segments as were specified in the count argument.Correct the data or request; then try again
CG0210Attempt to strpackints() a string with too many segmentsThe string given to strpackints() contained more segments than were specified in the count argument.Correct the data or request; then try again
CG0211Product of count and bits params to strpackints greater than 64The result of strpackints is limited to 64 bits, so count*bits must be between 0 and 64.Correct the data or request; then try again
CG0212Result of strunpackints too large for formatThe number to be unpacked by strunpackints was too large to fit in the output format.Correct the data or request; then try again
CG0213String wrong length for functionThe string supplied is of the wrong length for the functionCorrect the data or request; then try again
CG0214Invalid string representationThere was a string with an invalid representation for its character set.Contact the help desk
CG0215Codepoint not in character setThere was a character not available in the destination character set during conversion.Correct the data or request; then try again
CG0216Unknown character setAn unknown character set was specified.Contact the help desk
CG0217Bad number of octets per characterThere was an invalid number of octets per character defining a character set.Contact the help desk
CG0218Bad translation table rangeThere was an invalid translation table defining a character set.Contact the help desk
CG0219Internal error in character conversionAn unknown error occurred while doing a character set conversion.Contact the help desk
CG0250Invalid string for to_numberAn invalid string was supplied to to_number() Check your SQL statement; then try again
CG0251Invalid format stringAn invalid format string was used Check your SQL statement; then try again
CG0252Invalid format stringAn invalid date specifier was used Check your SQL statement; then try again
CG0253Bad value in date stringThe date string contained an bad value Check your SQL statement; then try again
CG0254Internal error - ran out of digits!An internal error occurred Contact the help desk
CG0255Too many significant digits passed to to_numberToo many significant digits were passed to to_number() - use an explicit cast Check your SQL statement; then try again
CG0256Invalid day numberAn invalid day number was specified Check your SQL statement; then try again
CG0257No year was specifiedNo year was specified Check your SQL statement; then try again
CG0258FX specified but wrong number of digitsInvalid input - FX specified but wrong number of digits Check your SQL statement; then try again
CG2xxx
CG2003Query aborted
CI0xxx
CI0001Internal error (Global CI): Please contact KognitioAn internal compiler or interpreter error has occurredContact the help desk
CI0002Global feature not yet implementedAn SQL feature has not yet been implemented in the generic codeContact the help desk
CI0008Internal error (Bad data type): Please contact KognitioAn internal compiler or interpreter error has occurredContact the help desk
CI0011Insufficient memoryThere is insufficient memory to compile or run this requestFree some server memory and try again
CI0012Internal memory allocation too large (%S bytes requested)A request was made for an invalid amount of memoryContact the help desk
CI0013Memory allocation inconsistencyA request was made to allocate or reallocate undefined memoryContact the help desk
CI0014Transient buffer overflowThe request required more space than was available in the internal transient bufferSimplify the request and try again
CI0021Internal error (Bad old-style data type): Please contact KognitioAn internal error occurredContact the help desk
CI0022Internal error (Bad old-style numeric type): Please contact KognitioAn internal error occurredContact the help desk
CI0023Internal error (Bad old-style length): Please contact KognitioAn internal error occurredContact the help desk
CI0024Internal error (Bad compressed data map hash algorithm): Please contact KognitioThe compressed data map hash algorithm must be either SIMPLE or SIMPLE_REVContact the help desk
CI0025Table cannot have empty nameA table was specified with an empty nameDo not use empty table names
CI0026Column cannot have empty nameA column was specified with an empty nameDo not use empty column names
CI0027Too many privilegesThis request requires more privileges than can be managed by the compilerContact the help desk
CI0028Internal error (Ext addresses for temporary table): Please contact KognitioAn attempt was made to get ext addresses for a table where the header type indicates that it does not have ext addressesContact the help desk
CI0029Names or aliases cannot consist only of spacesYou tried to create a name or an alias that conists only of spacesContact the help desk
CI0030Internal error (Out of stack space): Please contact KognitioThe SQL compiler ran out of stack space while trying to compile the queryContact the help desk
CI0031Internal error (Replay failure): Please contact KognitioSomething went wrong with query replayContact the help desk
CI0032Error raised from %S line %C (backtrace %K)Debugging error message identifying the location where the error was raisedContact the help desk
CI0033GULError caught under DEBUG CRASH but ci_allow_crash not setDEBUG CRASH is not allowed to crash the database unless ci_allow_crash is set (or you are SYS)Contact the help desk
CI0065Invalid date valueOperation produced an invalid date value Contact the help desk
CI0067Invalid timestamp valueOperation produced an invalid timestamp value Contact the help desk
CI0068Invalid time valueOperation produced an invalid time value Contact the help desk
CI006AYear-month interval overflowPrecision of year-month interval value is too small Contact the help desk
CI006BDay-time interval overflowPrecision of day-time interval value is too small Contact the help desk
CI0088 Interval field overflowAn interval value has overflowed the maximum number of digits in its leading field Examine your query and data; then try again
CI0100Internal error (Invalid QDB %S index %T): Please contact KognitioThe qdb index is invalidContact the help desk
CI0101QDB: invalid data ref %S %T, start %C, len %KThe qdb data reference is invalidContact the help desk
CI0102QDB: invalid subtype %S for table %TThe subtype for the table is invalid for its typeContact the help desk
CI0103QDB: buffer self-reference, %S %TA QDB allocation refers to itself; this may cause inconsistenciesContact the help desk
CI0109Invalid month parameter given to PACKDATE(year, month, day)Only values of 'month' where 1<=month<=12 are allowed when using PACKDATE Correct the data or request; then try again
CI010AInvalid day parameter given to PACKDATE(year, month, day)The day of the month must be between 1 and 28,29,30, or 31 (depending on the month and leap year Correct the data or request; then try again
CI010DInvalid parameter given to TIME(H, M, S)The time function must be given valid values 0-23,0-5,0-59 Correct the data or request; then try again
CI0181Plugin failureThe plugin is in safe mode and has crashed contact plugin vendor to resolve the problem or debug
CI0182Undefined plugin errorA plugin returned an undefined error code Contact the plugin vendor for support
CI0183Module %S: %TThe plugin module returned an error string Contact the plugin vendor for support
CI0184The plugin returned a string of the wrong lengthThe plugin module returned a string of the wrong length Contact the plugin vendor for support
CI0185Abiguous type for string argument to plugin functionThere are multiple possible types to convert the string argument into. Use an explicit cast from string to the correct type
CI0201Insufficient string memoryA request required more dynamic string space than was availableContact the help desk
CI0202Character string too longAn attempt was made to insert a character string that exceeds the defined length of a columnCorrect the request and retry
CI0203Invalid character value for castAn attempt was made to cast a badly formed stringCorrect the data and retry the request
CI0204Numeric overflow during conversionThe request generated a result that was too large to be representedCorrect the data and retry the request
CI0205Numeric underflow during conversionThe request generated a result that was too small to be representedCorrect the data and retry the request
CI0250Invalid string for to_numberAn invalid string was supplied to to_number() Check your SQL statement; then try again
CI0251Invalid format stringAn invalid format string was used Check your SQL statement; then try again
CI0252Invalid format stringAn invalid date specifier was used Check your SQL statement; then try again
CI0253Bad value in date stringThe date string contained an bad value Check your SQL statement; then try again
CI0254Internal error - ran out of digits!An internal error occurred Contact the help desk
CI0255Too many significant digits passed to to_numberToo many significant digits were passed to to_number() - use an explicit cast Check your SQL statement; then try again
CI0256Invalid day numberAn invalid day number was specified Check your SQL statement; then try again
CI0257No year was specifiedNo year was specified Check your SQL statement; then try again
CI0258FX specified but wrong number of digitsInvalid input - FX specified but wrong number of digits Check your SQL statement; then try again
CI1xxx
CI1001Internal error (Lexer): Please contact KognitioAn internal error occurred in the Lexical AnalyserContact the help desk
CI1002Lexical feature not yet implementedAn SQL feature has not yet been implemented in the lexical analyserContact the help desk
CI1010Unterminated quote, starting at offset %SThe request contained an open quote with no terminating quoteCorrect the request and try again
CI1011Unterminated double quote, starting at offset %SThe request contained an open double quote with no terminating quoteCorrect the request and try again
CI1012Identifier %S is too long, offset %TThe length of an identifier exceeded the implemantation maximum sizeAmend the SQL; then try again
CI1013Syntax error at character with ASCII value %S, offset %CAn invalid character was found in the request stringCheck your SQL statement; then try again
CI1014Empty identifier not allowedAn empty identifier ("") was usedCheck your SQL statement; then try again
CI1015Identifier %S beginning with hash character, offset %CIdentifiers beginning "#" are reservedCheck your SQL statement; then try again
CI1016Character string too longThe length of a string exceeded the implementation maximum sizeCheck your SQL statement; then try again
CI1017Bad binary stringA binary string was specified with non-hexadecimal digits or an odd number of digitsCheck your SQL statement; then try again
CI2xxx
CI2002Syntax feature not yet implementedAn SQL feature has not yet been implemented in the syntax analyserContact the help desk
CI2003Query abortedYour query was abortedFind out why your query was aborted before trying to rerun it
CI2004Internal error (Syntax): Please contact KognitioAn internal error occurred in the Syntax AnalyserContact the help desk
CI2011Internal error (SQL string is NULL): Please contact KognitioThe compiler was passed an invalid SQL stringContact the help desk
CI2012Syntax error near %S, offset %C %KA syntax error was detected in the user's SQL at the specified offset in the textCorrect your SQL and try again
CI2013Expected %S at or near %T, offset %C %KA syntax error was detected in the user's SQL where certain constructs were expectedCorrect your SQL and try again
CI2014AUTHORIZATION missingA syntax error was detected in the user's SQL where the AUTHORIZATION keyword was expectedCorrect your SQL and try again
CI2015Transaction control statementA Commit or Rollback was encountered, but this is not valid SQLContact the help desk
CI2020Bad precision: %S, offset %TAn invalid value was specified for a data type's precisionCorrect your SQL and try again
CI2021Bad scale: %S, offset %TAn invalid value was specified for a data type's scaleCorrect your SQL and try again
CI2022Bad interval data type near %S, offset %TAn invalid interval type was specified for a data type definitionCorrect your SQL and try again
CI2023A compiler hint cannot use a query to get hash exception valuesA compiler hint says "RANDOM/REPLICATED IN (query)"Correct your SQL and try again
CI2026Bad precision for compressed data map statisticsWhere defined, the precision for compressed data map statistics must be a non-zero, positive integerCorrect your SQL and try again
CI2030Bad date value: %S, offset %TAn invalid literal date value was specifiedCorrect your SQL and try again
CI2031Bad time value: %S, offset %TAn invalid literal time value was specifiedCorrect your SQL and try again
CI2032Bad timestamp value: %S, offset %T (errcode %C)An invalid literal timestamp value was specifiedCorrect your SQL and try again
CI2033Bad interval value near %S, offset %T (errcode %C)An invalid literal interval value was specifiedCorrect your SQL and try again
CI2034Parameter name too long (maximum %S characters)The specified parameter name is too longCorrect your SQL and try again
CI2035Parameter name must be in 7-bit ASCIIThe specified parameter name contains characters not in 7-bit ASCIICorrect your SQL and try again
CI203ANumeric underflow in %SA literal number was too small to be representedCorrect your SQL and try again
CI203BNumeric overflow in %SA literal number was too large to be representedCorrect your SQL and try again
CI203CToo many reference columnsA single-column foreign key may only reference a single columnCorrect your SQL and try again
CI203EIncorrect arguments to function '%S', offset %CToo many or too few arguments were passed to an SQL functionCorrect your SQL and try again
CI203FNon-existent property in ALTER TABLE SET statementOnly 'name', 'owner' and 'schema' may be SET in an ALTER statementCorrect your SQL and try again
CI2040Ambiguous privilege statementThe domain cannot be deduced from the privileges, use ON [USER/TABLE] etc.Correct your SQL and try again
CI2041Privilege not valid in domainYou cannot use this privilege in the domain specified.Correct your SQL and try again
CI2042Privilege '%S' does not existThe privilege specified does not exist.Correct your SQL and try again
CI2043Two privileges are from different domainsYou cannot combine privileges from different domainsCorrect your SQL and try again
CI2044Cannot apply aggregate privileges to this domainAggregate privileges are not applicable here.Correct your SQL and try again
CI2045Invalid module mode '%S'Module mode selected is not validUse a module mode of SAFE, ACTIVE or INACTIVE
CI2046Plugin Modules are disabledPlugin Modules have beed disabled on this systemRe-enable plugin modules
CI2047Duplicate WITH name %sA WITH name has been used twiceChange your query to use unique WITH names
CI2048Nested WITH clausesYou cannot nest WITH clauses Remove the nested WITH clauses
CI2049Object given for system-wide privilegeYou cannot apply system-wide privileges to an objectCorrect your SQL and try again
CI2050Bad numeric value for TOPYou specified a bad value for the TOP numberChange the value
CI2051You cannot use TOP in this query - to fix, order by a specific column, not a numberTOP cannot cope if there is a * in the select list and you order by a numberChange the order by clause to specify a column
CI2052WITH can only be used at the start of a query expressionYou can only put WITH at the start of a query expression.Check your SQL; then try again
CI2053You cannot use TOP in a query with a qualified star (eg SELECT TOP 5 A.* FROM A)TOP cannot cope if there is a qualified * in the select list.Remove the qualified * if possible.
CI2054The same attribute has been specified more than once in the listAn attribute has been used more than once in the sec classRemove the duplicates
CI2055Invalid Unicode escape characterThe UESCAPE escape character for a Unicode string literal or identifier must be a single characterCheck your SQL; then try again
CI2056Invalid Unicode escape sequenceA Unicode string literal or identifier contains an invalid sequence following the UEscape characterCheck your SQL; then try again
CI2057No such window function '%S', offset %TAn unknown window function has been specified.Check your SQL; then try again
CI2058An errorcode must be AAHHHH, eg CI2058An errorcode in a bad format was specifiedCheck your SQL; then try again
CI2059You cannot repeat an element in ALTER LOGINAn element is ALTER LOGIN has been specified more than onceCheck your SQL; then try again
CI205AINTERNAL ERROR: AMBIGUOUS SYNTAX!! PLEASE SEND THIS QUERY TO KOGNITIOPlease report the SQL to Kognitio; the parser was unable to handle your queryPlease report the SQL to Kognitio
CI205BYou can only have one WHEN MATCHED/NOT MATCHED clause in a MERGE INTOYou can only have one matched/not matched clause in a MERGE INTOCheck your SQL; then try again
CI205CYou must specify a password when creating a userYou must specify a password when creating a userCheck your SQL; then try again
CI205DYou must specify each attribute only onceYou must specify each attribute only onceCheck your SQL; then try again
CI205EYou cannot use the CURRENT_ functions in the fragmentation WHERE clauseYou cannot use the CURRENT_ functions in the fragmentation WHERE clauseCheck your SQL; then try again
CI205FYou cannot use subqueries, functions, or aggregates in the fragmentation WHERE clauseYou cannot use subqueries in the fragmentation WHERE clauseCheck your SQL; then try again
CI2060Internal error (SQL is not in UTF-8): Please contact KognitioThe SQL query input is not in UTF-8.Contact the help desk
CI2061Aggregate does not support DISTINCT or ALLA set quantifier DISTINCT or ALL was given to a statistical aggregateCheck your SQL; then try again
CI2062The MAXDEPTH value must be between 1 and 100 inclusiveYou specified a MAXDEPTH with an EXEC command, but it must be between 1 and 100 inclusiveCheck your SQL; then try again
CI2063The MAXDEPTH value was set in SQL obtained from an EXEC SELECTMAXDEPTH can only be specified with EXEC at the user level, not belowCheck the SQL returned by the SELECT, then remove the MAXDEPTH from it
CI2064The MAXDEPTH has been reached in embedded EXEC SELECTsThe MAXDEPTH has been reached in embedded EXEC SELECTsEnsure that there are no loops in the EXEC calls, or increase MAXDEPTH
CI2065Users cannot be created with lower case charactersUsers cannot be created with lower case characters because they will not be able to log onCheck your SQL; then try again
CI2066NEW SYSTEM or UPGRADE on a running systemAn attempt was made to run the NEW SYSTEM or UPGRADE command on a system with RAM imagesContact the help desk
CI2067Parameter value overflowAn attempt was set a parameter to too large or small a valueCheck your SQL; then try again
CI2068A partition cannot contain CURRENT_, aggregates, functions, or subqueriesChange the partition so that it doesn't use something that it shouldn'tCheck your SQL; then try again
CI2069Bad length: %SAn invalid value was specified for a data type's lengthCorrect your SQL and try again
CI206AA WINDOW clause called %S was specified more than onceA WINDOW clause with the given name was specified more than onceCorrect your SQL and try again
CI206BThe Principal name is too longUse a shorter Principal nameCorrect your SQL and try again
CI206CYou cannot specify both TOP n and LIMIT nThe query specifies both a TOP n and a LIMIT n clauseCorrect 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 %KMultiple "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.)Correct your SQL and try again
CI206EPREJOINS are deprecated PREJOINS are deprecated and will be removed in a future release. Set the global parameter ci_prejoins to 1 to use themCorrect your SQL and try again
CI2080Internal error (Expr stack underflow): Please contact KognitioPlease report the SQL to Kognitio; the parser was unable to handle your queryPlease report the SQL to Kognitio
CI2081Internal error (Cond stack underflow): Please contact KognitioPlease report the SQL to Kognitio; the parser was unable to handle your queryPlease report the SQL to Kognitio
CI2082Internal error (Pred stack underflow): Please contact KognitioPlease report the SQL to Kognitio; the parser was unable to handle your queryPlease report the SQL to Kognitio
CI2083Internal error (From ref stack underflow): Please contact KognitioPlease report the SQL to Kognitio; the parser was unable to handle your queryPlease report the SQL to Kognitio
CI2084Internal error (Query spec stack underflow): Please contact KognitioPlease report the SQL to Kognitio; the parser was unable to handle your queryPlease report the SQL to Kognitio
CI2085Internal error (Bison stack overflow): Please contact KognitioPlease report the SQL to Kognitio; the parser was unable to handle your queryPlease report the SQL to Kognitio
CI2086Parser memory exhaustedYour SQL has exhausted the memory available to the parserContact the help desk
CI3xxx
CI3001Internal error (Resolver): Please contact KognitioAn internal error occurred in the ResolverContact the help desk
CI3002Resolver feature not yet implementedAn SQL feature has not yet been implemented in the resolverContact the help desk
CI3011Schema %S does not exist, offset %TThe SQL referenced a schema which does not existCheck your SQL; then try again
CI3012User or group %S does not existThe SQL referenced an user which does not existCheck your SQL; then try again
CI3013Table %S.%T does not exist, offset %CThe SQL referenced a table which does not existCheck your SQL; then try again
CI3014View %S.%T does not exist, offset %CThe SQL referenced a view which does not existCheck your SQL; then try again
CI3015Column %S.%T.%C does not existThe SQL referenced a column which does not existCheck your SQL; then try again
CI3016No columns in create tableA create table request does not include any columnsCheck your SQL; then try again
CI3017Duplicate column name %S not allowedEach column in the list must have a unique nameCheck your SQL statement; then try again
CI3018Unique column %S must be NOT NULLWhen you create a table, all columns in unique or primary keys must be defined as NOT NULLCheck your SQL; then try again
CI3019Column %S is not part of the associated create table requestA create table request refers to a local column that does not existCheck your SQL; then try again
CI301AMore than one primary keyA create table request contains more than one primary keyCheck your SQL; then try again
CI301BView %S.%T references itselfYou are attempting to create a view which references itselfCheck your SQL; then try again
CI301CInternal error (Table id larger than USER_TABLE_END): Please contact KognitioAttempt to create a table whose id would be larger than the maximum currently allowableContact the help desk
CI301DOperation invalid on a viewYour SQL specified an operation which cannot be performed on a viewCheck your SQL; then try again
CI301E%S.%T is a viewYour SQL specified a view where a table was expected Check your SQL; then try again
CI301F%S.%T is not a viewThe SQL referenced a view which does not existCheck your SQL; then try again
CI3020Column type definition in create table selectColumn type definitions are not permitted in create table for/from select statementsCorrect your SQL; then try again
CI3021Column default in create table select column definitionsColumn defaults are not permitted in create table for/from select statementsCorrect your SQL; then try again
CI3022Not null column definition in create table select column definitionsNot null column definitions are not permitted in create table for/from select statementsCorrect your SQL; then try again
CI3023Unique declaration in create table select column definitionsUnique declarations are not permitted in create table for/from select statementsCorrect your SQL; then try again
CI3024Primary key declaration in create table select column definitionsPrimary key declarations are not permitted in create table for/from select statementsCorrect your SQL; then try again
CI3025Check clause declaration in create table select column definitionsCheck clause declarations are not permitted in create table for/from select statementsCorrect your SQL; then try again
CI3026Foreign key declaration in create table select column definitionsForeign key declarations are not permitted in create table for/from select statementsCorrect your SQL; then try again
CI3027Column type declaration missing from create tableColumn type declarations are required in create table statements which do not incorporate a select statementCorrect your SQL; then try again
CI3028Number of column names does not match number of select columnsThe number of column names supplied in the create table does not match the number of columns returned by the selectCorrect your SQL; then try again
CI3029Column type declaration missing from external script definitionColumn type declarations are required in external script definitionsCorrect your SQL; then try again
CI3031Procedure %S does not existYour SQL referenced a procedure which does not existCheck your SQL; then try again
CI3032Snapshot %S does not existYour SQL referenced a snapshot which does not existCheck your SQL; then try again
CI3033Security class %S does not existYour SQL referenced a security class which does not existCheck your SQL; then try again
CI3034Security class for a user does not existThe server was unable to locate your security class detailsContact the help desk
CI3035Ambiguous column %S%KA column name referenced in your SQL cannot be uniquely resolvedAdd qualifiers where necessary; then try again
CI3036Table name %S used rather than alias %TOnce an alias has been defined for a table then the table name can no longer be usedUse the alias rather than the table name
CI3037Remote server %S does not existYour SQL referenced a remote server which does not existCheck your SQL; then try again
CI3038No IPE_FILE in current schemaYour SQL required a reference to IPE_FILE but no such table exists in the current schemaCheck your schema; then try again
CI3039NFS file %S for server %T does not existYour SQL referenced a server for which no entry in IPE_REM_SERVER existsCheck your SQL; then try again
CI303ANo NFS user detailsYour SQL required an NFS connection but no NFS user details exists for your user nameContact your system administrator
CI303BDuplicate object alias or name %SAn alias or name was used twice for two different objectsCorrect your SQL; then try again
CI303CDuplicate column alias %SAn alias name was used twice for two different columnsCorrect your SQL; then try again
CI303DLocal IPE_FILE is not in RAMYour import or export operation requires that the IPE_FILE table in your current schema be fully in RAMLoad IPE_FILE into RAM; then try again
CI303EAmbiguous object %SAn object name referenced in your SQL cannot be uniquely resolvedAdd qualifier or aliases where necessary; then try again
CI303FTable with id %S does not exist, offset %CThe SQL referenced a table which does not existCheck your SQL; then try again
CI3040Parameter ci_use_statsonly is set and we tried to get a cardinality without a predicateA very specific error condition occurredCheck your SQL; then try again
CI3041External script with id %S does not exist, offset %CThe SQL referenced an external script which does not existCheck your SQL; then try again
CI3051Identifier %S not declared%KAn identifier could not be resolvedCorrect your SQL; then try again
CI3052Object %S not declared%KThe table or view specified does not exist in the scopeCorrect your SQL; then try again
CI3061Internal error (Bad statement type): Please contact KognitioBad Statement TypeContact the Helpdesk.
CI3062No columns in tableSystem tables contain no column info for this tableContact the Helpdesk.
CI3063Internal error (Scope is NULL): Please contact KognitioInternal ErrorContact the Helpdesk.
CI3064 No base row for %S.%TSystem tables contain no base row for table.Contact the Helpdesk.
CI3065No view row for %S.%TSystem tables missing info for this view.Contact the Helpdesk.
CI3066No column rowsSystem tables missing info for 1 or more columns.Contact the Helpdesk.
CI3067No column img rowsSystem tables missing info for 1 or more columns.Contact the Helpdesk.
CI3068Wrong number of column rowsSystem tables missing info for 1 or more columns.Contact the Helpdesk.
CI3069No SQL fragments row for %S.%TSystem tables missing info for this view.Contact the Helpdesk.
CI3070Aggregate privileges cannot contain column referencesYou cannot specify column privileges in an aggregate privilege.Correct your SQL; then try again
CI3071Invalid grant/revoke privilege requestYour statement attempted an invalid grant or revoke operationCorrect your SQL; then try again
CI3072Connector '%S' already existsA connector of this name already existsCorrect your SQL; then try again
CI3073Connector '%S' does not existNo connector with this name existsCorrect your SQL; then try again
CI3074Connector '%S' is inactiveThe specified connector is not activeCorrect your SQL; then try again
CI3075Script environment '%S' already existsA script environment of this name already existsCorrect your SQL; then try again
CI3076Script environment '%S' does not existNo script environment with this name existsCorrect your SQL; then try again
CI3077External script '%S.%T' already existsAn external script of this name already existsCorrect your SQL; then try again
CI3078External script '%S.%T' does not existNo external script with this name existsCorrect your SQL; then try again
CI30D6Invalid (user) command given for group %SA user command was given which is not appropriate for a groupUse the appropriate group command
CI30D7Invalid (group) command given for user %SA group command was given which is not appropriate for a userUse the appropriate user command
CI30D8Plugin Module '%S' is already definedA plugin module of this name already existsChoose a different module name
CI30D9Plugin Module '%S' does not existNo plugin module with this name existsChoose a different module name
CI30E0Temporary table not allowedA temporary table is not allowed hereCorrect your SQL and try again
CI30E1Cannot specify schema for temporary tableA temporary table cannot be created in a particular schemaCorrect your SQL and try again
CI30E2Integrity not allowed for temporary tableTemporary tables cannot have UNIQUE, PRIMARY, FOREIGN or REFERENCESCorrect your SQL and try again
CI30E3Queue '%S' does not existNo queue with this name existsChoose a different queue name
CI30E4Queue '%S' already existsA queue with this name already existsChoose a different queue name
CI30E5Unknown character setThe query specifies a character set that does not existCorrect your SQL and try again
CI30E6Variable-length character encodings cannot be used with CHARVariable-length character encodings (such as UTF-8) can only be used with VARCHAR, not CHARCorrect your SQL and try again
CI30E7Scalar subqueries cannot have outer references (%S in this case) when used like thatYou used a scalar subquery with outer references in a situation where you cannot do thatCorrect your SQL and try again
CI30E8Bad value for parameter def_table_loc when creating tableYou tried to create a table but the default table location parameter def_table_loc is unknownCorrect the parameter and try again
CI30E9Your query uses view %S.%T, which is invalidatedYour query uses view %S.%T, which is invalidatedCorrect your SQL and try again
CI30EAIPE_FILE in current schema has bad prototypeYour import or export operation requires that the IPE_FILE table in your current schema has the same definition as SYS.IPE_FILECheck your schema; then try again
CI30EBInternal error (STINotNull assert failed: %S): Please contact KognitioAn internal assertion failed; a line has been logged to the cidebug file indicating where the failure occurredInform Kognitio of the problem
CI30ECInternal error (The default schema does not exist): Please contact KognitioAn attempt was made to SET SCHEMA DEFAULT but the default schema does not existInform Kognitio of the problem
CI30EDA schema must be specified; the default schema does not existAn attempt was made to use a table but the default schema does not existInform Kognitio of the problem
CI30EEExternal script with a partition mode specified but no partition columnsIt is not valid for an external script to have a partition mode when there are no partition columns.Correct your SQL and try again
CI30EFYou cannot have an ORDER BY clause hereYou cannot use an ORDER BY clause like thatCheck your SQL; then try again
CI30F0You cannot have a LIMIT or FETCH FIRST clause hereYou cannot use a LIMIT or FETCH FIRST clause like thatCheck your SQL; then try again
CI4xxx
CI4001Internal error (Semantic Analyser): Please contact KognitioAn internal error occurred in the Semantic AnalyserContact the help desk
CI4002Semantic feature not yet implementedAn SQL feature has not yet been implemented in the semantic analyserContact the help desk
CI4005Internal error (Conversion value overflow): Please contact KognitioThe compiler attempted to generate a conversion value that was too largeContact the help desk
CI4008Internal error (Bad data type): Please contact KognitioAn internal compiler or interpreter error has occurredContact the help desk
CI4010Operation invalid for group PUBLICYou cannot perform this operation on the public group.Correct your SQL and try again
CI4011Object %S.%T is not a tableThe object referred to in the table request is not a tableCorrect the request and try again
CI4012Object %S.%T is not a viewThe object referred to in the view request is not a viewCorrect the request and try again
CI4013Object %S.%T is not a procedureThe object referred to in the procedure request is not a procedureCorrect the request and try again
CI4014Object %S.%T already has a RAM imageThe new image cannot be created since a RAM image already existsNo action required
CI4015Object %S.%T has no RAM imageThere is no image to be dropped for the specified objectNo action required
CI4016Incorrect distributionAn attempt was made to create a replicated fragmented image but this is not a valid combinationChoose a different distribution, either hashed or random
CI4017Too many privilegesThis request requires more privileges than can be managed by the compilerContact the help desk
CI4018Too many columnsThe number of columns in this table or view exceed the maximum allowedContact the help desk
CI4019Table or view is too wideThe width of the table or view exceeds the maximum row sizeContact the help desk
CI401AOnly the sys user can create views based on the system viewsOnly the sys user can create views based on the SYS.IPE_ viewsDo not create views that use the SYS.IPE_ views
CI4020Invalid dynamic parameter typeA parameter was defined with an unrecognised data typeContact the help desk
CI4021Special invoke - no parametersThis special invoke request must have no parametersCorrect the request and try again
CI4022Invalid time zone valueThe value given for a time zone was out of rangeCorrect the request and try again
CI4023Password is shorter than style allowsThe user's security class defines a minimum password length, which the supplied password does not reachUse a longer password and try again
CI4024Password fails style requirementsThe user's security class defines the style of password, with which the supplied password does not complyCorrect the password and try again
CI4025Invalid Security Class style entryThe user's security class style is not validConsult your System Administrator
CI4026Invalid passwordThe password supplied does not match the user's old passwordCorrect the password and retry the request
CI4027Password re-used too recentlyThe password you entered has been used previously and the reuse interval for your user ID prevents its reuseChoose a different password and retry
CI4028Invalid parameter nameThe name of the specified parameter is too longCheck your SQL statement; then try again
CI4029No columns left in tableYou cannot delete columns in a table so that there are none leftCheck your SQL statement; then try again
CI402AOld password required to change user's own passwordIf you are changing your own password you must specify the old oneCorrect the password and retry the request
CI4031Only the System User may issue this requestThis request can only be issued by the system userConsult your System Administrator
CI4032Illegal operation on system table %S.%TYou are attempting an illegal operation on a system tableNo action required
CI4033Illegal operation on view image %S.%TIt is not possible to update or delete from view imagesNo action required
CI4034No authority to drop the schemaYou do not hold the privilege to drop the specified schemaConsult your System Administrator
CI4035Schema is not empty (contains tables or views)A schema cannot be dropped with the RESTRICT option if it contains objectsEither empty the schema or specify the CASCADE option
CI4036No authority to drop the userYou do not hold the privilege to drop the specified userConsult your System Administrator
CI4037The CASCADE or INVALIDATE DEPENDENT VIEWS options must be used to drop or alter objects on which views dependYour drop or alter request specified or implied Restrict and the object has dependentsEither drop the dependent views manually, use the Cascade option, or use the Invalidate Dependent Views option
CI4038Illegal operation on virtual tableIt is not possible to perform the specified operation on this virtual tableNo action required
CI4039View %S.%T is not updatableIn order to perform this request on a view then the view must be updatableNo action required
CI403AColumn %S has a data mapA request has been made to build a data map for a column for which a data map has already been builtNo action required
CI403CColumn %S has no data mapA request has been made to drop the data map for a column where no such data map has been builtNo action required
CI403DTable %S.%T has no data mapsA request has been made to drop all data maps for a table but no such data maps have been builtNo action required
CI403EMaximum of 6 columns allowedA maximum of 6 columns can be specified in any one update compressed data map statistics statementCorrect your SQL; then try again
CI4041Duplicate column name %S not allowedEach column in the list must have a unique nameCheck your SQL statement; then try again
CI4042Hash column %S is not in the RAM fragmentColumns used for hashing the RAM image must be present in that imageModify the SQL statement to hash only on the RAM columns and try again
CI4043Duplicate privileges present in requestThe grant or revoke request mentions the same privilege more than onceRemove the duplicate privilege and try again
CI4044Update privilege on a non-updatable viewThe grant or revoke request cannot specify a modify privilege for a view that cannot be modifiedRemove the modify privileges and try again
CI4045Privilege refers to a tableYou are only permitted to grant and revoke this privilege on a tableCheck your SQL statement; then try again
CI4046Privilege refers to a viewYou are only permitted to grant and revoke this privilege on a viewCheck your SQL statement; then try again
CI4047Duplicate processor id %SThe statement contains more than one reference to the same processorRemove the duplicate reference and try again
CI4048Processor %S is not a diskThe processor supplied for the disk operation is not a disk processorCorrect the processor number and try again
CI4049Rack %S does not existThe number supplied does not identify a valid rackCorrect the rack number and try again
CI404AMore exceptions than hash columnsThe number of exception values specified is more than the number of columns in the hash listCorrect your SQL; then try again
CI404BMore hash columns than exceptionsThe number of exception values specified is less than the number of columns in the hash listCorrect your SQL; then try again
CI404CInvalid exception value for column %SThe data type of an exception value does not match the data type of the related hash columnCorrect your SQL; then try again
CI404DToo many exception valuesThe number of exception values specified is more than the maximum allowed for an imageCorrect your SQL; then try again
CI404ENo exception valuesAttempting to create a partially hashed table reusing existing hash exception values, but no such values existCorrect your SQL; then try again
CI404FHash replicated table %S.%T with unique keyIt's not possible to create a hash replicated image of a table which has a unique index or primary keyCorrect your SQL; then try again
CI4051Insufficient privilege for this requestYou do not have the required privilege for this statementConsult your System Administrator
CI4052View column has no nameThe view contains an expression column that has not been assigned a nameCheck your SQL; then try again
CI4053Number of view columns in %S.%T does not match queryThe number of names in the view column name list does not match the number of columns present in the view queryCheck your SQL; then try again
CI4054CHECK OPTION but view %S not updatableThe view specified is not updatable but the WITH CHECK OPTION clause was present; this clause is only valid for updatable viewCheck your SQL; then try again
CI4055Duplicate object name %S not allowedEach table or view in the list can only be mentioned onceCheck your SQL statement; then try again
CI4056Cursor is not updatableAn attempt was made to declare a cursor for update, but the cursor's select query is not updatableCheck your SQL; then try again
CI4057View id larger than USER_TABLE_ENDAttempt to create a view whose id would be larger than the maximum currently allowableContact the help desk
CI405FModulus operator not valid for operand with non-zero scaleOperands with non-zero scale are not valid in this contextCheck your SQL; then try again
CI4060Data type mismatch for type %S%KThe data type of an expression is not valid in this contextCheck your SQL; then try again
CI4061Data type mismatch between %S and %T%KThe data type of an expression is not valid in this contextCheck your SQL; then try again
CI4062Bad cast lengthThe target data type for an expression is too smallCheck your SQL; then try again
CI4063Cannot gather statistics on %S.%T - not in RAMYou can only run this kind of Update Statistics when that object is loaded into memoryCreate an image of the object and then try again
CI4064Cannot coerce data types in UNION column %sThe data types in the UNION are not coercableCheck your SQL; then try again
CI4065Invalid escape characterThe escape character in a LIKE predicate must be a single character literal or dynamic parameterCheck your SQL; then try again
CI4066Case has no non-null branchesAt least one branch of a case expression must be non-nullCheck your SQL; then try again
CI4067Insufficient dynamic parametersThe SQL contained more dynamic parameter markers than actual dynamic parameter values passedCheck your SQL; then try again
CI4068Non-local JOIN ON inequality predicateThe ON clause in the JOIN phrase contains a predicate that is neither local nor an equals predicateCheck your SQL; then try again
CI4069Cannot gather statistics for %S.%T.%C - not in RAMYou can only run this kind of Update Statistics when the column is loaded into memoryCreate an image of the object which includes the column and then try again
CI406ABad subquery usageYour SQL contained an invalid use of a subqueryCheck your SQL; then try again
CI406BCannot coerce data types in CASE branch %sThe data types in the CASE results are not coercableCheck your SQL; then try again
CI406CIllegal use of subquery in JOIN ON clauseThe ON clause in the JOIN phrase must not contain a subquery predicateCheck your SQL; then try again
CI406DIllegal use of NOT in JOIN ON clauseThe ON clause in the JOIN phrase must not contain a NOT operatorCheck your SQL; then try again
CI406EIllegal use of OR in JOIN ON clauseThe ON clause in the JOIN phrase must not contain an OR operatorCheck your SQL; then try again
CI406FThe JOIN ON clause contains no join equalityThe ON clause in the JOIN phrase must contain at least one join equality predicateCheck your SQL; then try again
CI4070Illegal parameter for LIKEThe parameter for a LIKE predicate is incorrect; use literal text or a dynamic parameterCheck your SQL; then try again
CI4071Illegal parameter for MATCHINGThe parameter for a MATCHING predicate is incorrect; use literal text or a dynamic parameterCheck your SQL; then try again
CI4072Column %S is not part of the associated create requestA create request refers to a local column that does not existCheck your SQL; then try again
CI4073Primary key not found for foreign referenceYou have attempted to reference the primary key of a table where no such key existsCheck your SQL; then try again
CI4074Alter cannot add a unique columnWhen 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 columnRemove this clause; then try again
CI4075Alter / Add NOT NULL requires defaultWhen altering a table a new column cannot have a NOT NULL clause if no default value is definedEither remove the NOT NULL clause or add a DEFAULT clause
CI4076Duplicate column name %SWhen altering a table a new column must have a unique nameChange the column name and try again
CI4077Column %S references a column of different typeA foreign key references a primary key with different data typeCheck your SQL; then try again
CI4078Unique key not found for foreign referenceYou have attempted to reference a table in which the specified columns do not form a unique keyCheck your SQL; then try again
CI4079Foreign reference column count mismatchThe number of columns in the references clause is inconsistentCheck your SQL; then try again
CI407AForward reference in column %S defaultThe default value supplied for the specified column refers to a column later in the Create Table; this is not validCorrect your SQL; then try again
CI4080Foreign column %S does not existA foreign key references a non-existant columnCheck your SQL; then try again
CI4081Set null reference is not nullAttempt to use the 'SET NULL' referential integrity option when the column is defined as NOT NULLModify your SQL statement and try again
CI4082Set default reference has no defaultAttempt to use the 'SET DEFAULT' referential integrity option when no default value is defined for the columnModify your SQL statement and try again
CI4087Request requires a global lockThis request requires a global session lockFirst obtain the global session lock; then try again
CI4088Global session lock already acquiredA global session lock is already in place for this sessionNone
CI4091Invalid insert expression for column %SThe insert statement contains an expression that is invalid in this contextAmend your SQL; then try again
CI4092Number of columns does not match number of valuesThe number of columns selected must match the number of values in an insert statementAmend your SQL; then try again
CI4093Column %S is not nullableIt is not possible to place the NULL value in a column that has the not null attributeAmend your SQL; then try again
CI4094Column %S has no defaultCannot insert a default value to a column that has no defaultAmend your SQL; then try again
CI4095Column cannot be assigned twiceAn update statement can only update a column with one valueAmend your SQL; then try again
CI4096Number of aliases does not match number of columnsThe number of column aliases must match the number of columns selected in a derived tableAmend your SQL; then try again
CI4097Invalid sequence number for order byThe sequence number in an order must identify a selected columnAmend your SQL; then try again
CI4098Invalid column reference for order byThe column reference in an order must identify a selected columnAmend your SQL; then try again
CI4099Bad default precision for column %SThe default value for the specified column has a precision which is too large for the columnAmend your SQL; then try again
CI409ABad default type for column %SThe default value for the specified column has a data type inconsistent with the columnAmend your SQL; then try again
CI409BInsert data type mismatch for column %SThe insert value for the specified column has a data type inconsistent with the columnAmend your SQL; then try again
CI409CUpdate data type mismatch for column %SThe update value for the specified column has a data type inconsistent with the columnAmend your SQL; then try again
CI409DExternal script data type mismatch for column %SThe data type of the column in the subquery has a data type inconsistent with that defined in the external scriptAmend your SQL; then try again
CI409EWrong number of inputs for external script %SThe external script has a different number of subqueries in the query from that in in its definitionAmend your SQL; then try again
CI409Forder by non-integer sequence numberThe order by clause contained an invalid sequence numberAmend your SQL; then try again
CI40A0Wrong number of expressions for input for external script %SThe definition of the external script's input has a different number of expressions than that in the subqueryAmend your SQL; then try again
CI40A1Schema %S already existsIt is not possible to create two schemas with the same nameChoose a new schema name; then try again
CI40A2User or group %S already existsIt is not possible to create users or groups with the same name as an existing user or groupChoose a new name; then try again
CI40A3Table or view %S.%T already exists, offset %CIt is not possible to create two tables or views with the same nameChoose a new name; then try again
CI40A4Snapshot %S already existsIt is not possible to create two snapshots with the same nameChoose a new name; then try again
CI40A5Schema name %S is different from user nameYou have tried to create a schema with a different name from that of the current user; this request requires the same schema nameUse the same schema name or try a different form of the request
CI40A6Foreign references existA table cannot be dropped while foreign references to it existFirst drop the refering table and then retry the request
CI40B0Aggregate not allowedAn aggregate is not allowed in this contextAmend your SQL; then try again
CI40B1Select expression %T (%S)%K is not being grouped, offset %CAll select items which are not aggregates must be in the group by clauseAmend your SQL; then try again
CI40B2Aggregate of an aggregate not allowedYou are not permitted to aggregate an aggregate, e.g. SELET SUM(MAX(Status))Consider using a temporary table; then try again
CI40B3Bad sequence number in Group ByThe Group By clause contained an invalid sequence numberAmend your SQL; then try again
CI40B4Bad expression in Group By clauseThe Group By clause contained an invalid expressionAmend your SQL; then try again
CI40B5Row Value Constructor not allowed, offset %TA row value constructor is not allowed in this contextAmend your SQL; then try again
CI40B6Distinct used more than onceOnly one distinct modifier can appear in each select requestAmend your SQL; then try again
CI40B7Aggregate combined with columnsAn expression contains an invalid mix of aggregates and column referencesAmend your SQL; then try again
CI40B8Incorrect use of Row Value Constructor, offset %TA row value constructor was compared with a scalar value; RVCs can only be compared to other RVCsAmend your SQL; then try again
CI40B9Incorrect Row Value Constructor degree, offset %TThe number of elements in a row value constructor does not match the number of elements in the comparing row value constructorAmend your SQL; then try again
CI40BAIncorrect union degreeThe number of columns in the queries on each side of the UNION do not matchAmend your SQL; then try again
CI40BBIncorrect subquery degree, offset %TThe degree of the subquery does not match the degree of the associated row value constructorAmend your SQL; then try again
CI40BCHaving requires grouping or aggregationA having clause requires a group-by clause or all selected expressions to be aggregatesAmend your SQL; then try again
CI40BDIllegal identifier in having clauseThe only identifiers permitted in a having clause are group-by columns or aggregatesAmend your SQL; then try again
CI40BEMixed aggregates and non-aggregatesWhen no group by clause is present, the select list must be all aggregates or all non-aggregatesAmend your SQL; then try again
CI40BFGrouping by a literal that is not in the select listYou cannot group by a literal that is not in the select list and which cannot be interpreted as a column numberAmend your SQL; then try again
CI40C0Incorrect batching of statementsThe mix of statements in the batch is not validConsider splitting the SQL statements into separate requests
CI40C1Request cannot be picturedThe specified request has no query path and so cannot be picturedConsider using explain instead
CI40C8Grouping on an aggregate is not allowedAn aggregate is not allowed in this contextAmend your SQL; then try again
CI40C9Aggregate not allowed in a conditional expressionAn aggregate is not allowed in this contextAmend your SQL; then try again
CI40CAAggregate not allowed in an IN listAn aggregate is not allowed in this contextAmend your SQL; then try again
CI40CBAggregate not allowed in WHERE clauseAn aggregate is not allowed in this contextAmend your SQL; then try again
CI40CCAggregate not allowed in ON clauseAn aggregate is not allowed in this contextAmend your SQL; then try again
CI40CDCannot alter same property of table twice in same statementYou cannot alter the same property twice in the same ALTER statementAmend your SQL; then try again
CI40CEInvalid predicate for a correlated updateA correlated update predicate can only use an equality comparison on the table to be updated.Amend your SQL; then try again
CI40CFToo many correlated update statements in updateAn update statement can only contain one correlated update.Amend your SQL; then try again
CI40D0Mixed correlated and non correlated updatesYou cannot combine a correlated and non-correlated update.Amend your SQL; then try again
CI40D1Cannot perform correlated update on a viewYou cannot perform a correlated update on a view.Amend your SQL; then try again
CI40D2Cannot combine correlated and uncorrelated predicates with ORYou cannot OR correlated and uncorrelated predicates in a correlated update. Amend your SQL; then try again
CI40D3Cannot perform operation on a ram-only tableThis action is invalid for ram only tables.Amend your SQL; then try again
CI40D4Cannot use replicated ram-only tableRam-only tables cannot be replicated.Amend your SQL; then try again
CI40D5Bad integrity constraint (Ram only and not Ram only Tables)Bad integrity constraint (Ram only and not Ram only Tables)Amend your SQL; then try again
CI40D6Invalid (user) command given for group %SA user command was given which is not appropriate for a groupUse the appropriate group command
CI40D7Invalid (group) command given for user %SA group command was given which is not appropriate for a userUse the appropriate user command
CI40D8Duplicate group name %S not allowedEach group in the list must have a unique nameAmend your SQL; then try again
CI40D9Identical user and group namesIt is not possible to create a user with the same name as a groupAmend your SQL; then try again
CI40DAInvalid Check ConstraintTable create text contains an unsupported check constraintAmend your SQL; then try again
CI40DBDuplicate user/group name %S not allowedThe statement lists the same user/group name more than onceAmend your SQL; then try again
CI40DCGroup %S self-referenceA group cannot be a member of itselfAmend your SQL; then try again
CI40DDPlugin Module function name too longThe plugin function you have tried to use has too long a nameAmend your SQL; then try again
CI40DEFunction '%S' not foundThe function you have tried to use cannot be foundAmend your SQL; then try again
CI40DFNo valid prototype for Plugin function '%S'The plugin name is known, but the arguments dont match any known functionCheck your plugin arguments.
CI40E0Cannot create a disk based ram only tableA ram only table cannot have an image located on disk only.Amend your SQL; then try again
CI40E1Cannot create a ram only table with a fragmented imageA ram only table cannot have a fragmented image.Amend your SQL; then try again
CI40E2Cannot create a disk based fragmented tableA table which is located only on disk cannot also have a fragmented image.Amend your SQL; then try again
CI40E3wx_????() functions can only be used with base tableswx internal attributes such as create tno, etc, can only be obtained from base tablesAmend your SQL; then try again
CI40E4Cannot coerce data types in argument list element %sThe data types in the list of values are not coercableCheck your SQL; then try again
CI40E5Cannot aggregate on expression containing inner and outer referencesYou cannot aggregate on an outer reference and an inner reference (Sql92 6.5.4)Check your SQL; then try again
CI40E6Outer reference Aggregate not allowed in WHERE subquery clauseAn aggregate is not allowed in this contextAmend your SQL; then try again
CI40E7You cannot create a fragmented view imageFragmented view images are not allowedCreate a VI of a more restrictive view
CI40E8Operation invalid on table with a RAM imageThis operation is not valid on tables with a ram image.Either drop the image, or redefine the image.
CI40E9Partial hashing distribution neither RANDOM nor REPLICATEDYou must specify one of RANDOM or REPLICATEDUse a valid distribution
CI40EAPartial hashing distribution given where none requiredA partial hashing distribution (RANDOM or REPLICATED) is not valid hereDo not specify a distribution
CI40EBInsert hashed statistics only supports one columnYou can only provide disk hashing information for one columnUse one column
CI40ECIncorrect intersect degreeThe number of columns in the queries on each side of the INTERSECT do not matchAmend your SQL; then try again
CI40EDIncorrect except degreeThe number of columns in the queries on each side of the EXCEPT do not matchAmend your SQL; then try again
CI40EEInvalid scale for timestamp()The timestamp function requires a literal scaleAmend your SQL; then try again
CI40EFInvalid or non-constant length for l/rpadThe l,rpad functions require a literal sizeAmend your SQL; then try again
CI40F0Conditional expression mixes aggregates and non-aggregatesYou cannot mix aggregates and non aggregates in this contextAmend your SQL; then try again
CI40F1Generate_Key only allowed in select listYou can only use the Generate_Key function in the select list of a queryAmend your SQL; then try again
CI40F2Module not in a valid modeYou can only reload a module if it is currently in a valid mode (active, inactive, safe) Amend your SQL; then try again
CI40F3Duplicate Module parameter givenYou can refer to a plugin module parameter once in the requestAmend your SQL; then try again
CI40F4You cannot have an RVC containing more than one column in a select listOnly single column RVC expressions, and non-RVCs can be used in a select listAmend your SQL; then try again
CI40F5You must have an RVC here, offset %TOnly a row value constructor can be used hereAmend your SQL; then try again
CI40F6You must have a datetime data type, offset %TOnly a DATE, TIME or TIMESTAMP data type can be used hereAmend your SQL; then try again
CI40FAKey %S does not existThere are no keys matching the string specified.Check your SQL; then try again
CI40FBWindow functions only allowed in select listYou can only use a window function in the select list of a queryAmend your SQL; then try again
CI40FCWindow functions not allowed in aggregates or window functionsYou cannot use a window function in an aggregate or a window functionAmend your SQL; then try again
CI40FDWindow function has invalid boundsThe bounds you have specified for a window function are not allowedAmend your SQL; then try again
CI40FENTILE argument or LAG/LEAD offset must be a positive integerThe parameter you specified for a window function is not allowedAmend your SQL; then try again
CI40FFslab argument is not a slab in the systemThe parameter you specified for a slab argument is not a valid slab id for this systemCorrect the slab id and try again
CI4101Window function does not allow window frameYou have specified a window frame (ROWS or RANGE) for a window function that does not allow itAmend your SQL; then try again
CI4102You can only specify a (+) outer join condition in the WHERE clauseYou have specified (+) in the SELECT, FROM or HAVING clausesAmend your SQL; then try again
CI4103ALL quantifier not supported for EXCEPT and INTERSECTYou have specified ALL for EXCEPT or INTERSECT which is not supportedAmend your SQL; then try again
CI4104Too many grouping sets in GROUP BY clauseThe GROUP BY clause you have specified is too complex.Amend your SQL; then try again
CI4105Too many expressions in GROUPING operationThe GROUPING() operation you have specified has too many arguments.Amend your SQL; then try again
CI4106GROUPING can only apply to group expressionsYou can only use the GROUPING() operation on expressions in the GROUP BY list.Amend your SQL; then try again
CI4107GROUPING is only allowed in the select and having clausesYou can only specify the GROUPING() operation in the SELECT and HAVING clauses.Amend your SQL; then try again
CI4108Can only group by column in GROUPING SETS, CUBE and ROLLUPYou can only specify a column name for GROUPING SETS, CUBE and ROLLUP in the GROUP BY list.Amend your SQL; then try again
CI4109You are changing a view that has dependent views, but the number of columns has changedYou are changing a view that has dependent views, but the number of columns has changedEither 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 datatypeYou are changing a view that has dependent views, but a column has changed its name or type.Either change the view definition so that it matches, or drop dependent views.
CI4111The name of the security class is too longThe security class name exceeds the 32 character limit.Make it shorter.
CI4112The minimum length of passwords is too long.The minimum length of passwords exceeds the 32 character limit.Make it shorter.
CI4113You cannot specify a value of 0You must use a value greater than zero.Make it greater than zero.
CI4114You cannot drop required attributesYou cannot drop required security class attributesRemove the relevant drop clauses
CI4115One or more required security class attributes (%S) was not presentA required security class attribute was not specified.Specify the required security class attribute.
CI4116Security class '%S' already existsA security class with this name already existsChoose a different name
CI4117Security class %S does not existYour SQL referenced a security class which does not existCheck your SQL; then try again
CI4118The security class id already existsA security class with this id already existsChoose a different id
CI4119You cannot drop the SYS userNobody can drop the SYS user; even SYS can't do it.Stop trying to drop the SYS user
CI411AYou can specify a user or a sec_class, but not bothYou can specify a user or a sec_class, but not bothRemove 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 tablesYou are inserting, updating, or deleting from a view. However, we cannot determine the members on the base tables.Alter your query
CI411CYou cannot use TOP <n> in a subquery with outer referencesYou have a correlated subquery with a TOP <n> limit on the number of rows to return. We can't handle that.Alter your query
CI411DA subquery with >1 column has been used where only a scalar (ie 1 column) subquery can be usedYou have a subquery which selects more than one column, but it can only sensibly select one column.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)You have a CASE statement that contains a subquery, but it is being used in a context that we don't handle.Alter your query, perhaps by using a derived table
CI411FYou cannot set the slabs for a RAM-only tableYou are trying to set the disk slabs to be used for a table that is RAM-only.Alter your query
CI4120Star needs tablesYou cannot select * if you do not specify tablesAlter your query
CI4121The SELECT is not updatableIn order to perform this request on a select then the select must be updatableNo action required
CI4122Incorrect VALUES degreeThe number of columns in each branch of the VALUES do not matchAmend your SQL; then try again
CI4123Cannot coerce data types in VALUES column %sThe data types in the VALUES are not coercableCheck your SQL; then try again
CI4124The slabs can only be changed for user tablesYou can only change the slabs for user tablesCheck your SQL; then try again
CI4125The character set has a different number of octets per characterThe character sets must have the same number of octets per characterCheck your SQL; then try again
CI4126A FROM clause is required for that SELECT listA FROM clause is required for that SELECT listCheck your SQL; then try again
CI4127You cannot change that property of an object on which views dependYou cannot change that property of an object on which views dependCheck your SQL; then try again
CI4128To change the owner of an object on which views depend you must use the FORCE optionTo change the owner of an object on which views depend you must use the FORCE optionCheck your SQL; then try again
CI4129Bad ON clause predicate: '%s'That predicate does not specify the target alone on one side onlyCheck your SQL; then try again
CI412AA MERGE statement cannot update a column used in the ON clauseA MERGE statement cannot update a column used in the ON clauseCheck your SQL; then try again
CI412BViews based on the system tables must start IPE_, however bear in mind that upgrades may cause them to breakViews based on the system tables must start IPE_Rename the view to start IPE_
CI412CA view image cannot be created for a pure viewIf a view is declared pure then it cannot be imagedNo action required
CI412DNULL must be cast to a data typeA bare NULL without a cast to a data type is not allowed hereAmend your SQL or turn off strict typing; then try again
CI412ECannot create a cycle of tables with foreign referencesAn 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 statementAmend your SQL; then try again
CI412FCannot obtain row lock for table with no primary keyAn attempt was made to obtain a row lock for a table on which no primary key is definedAmend your SQL; then try again
CI4130Wrong number of key elementsThe number of values supplied to obtain a row lock for a table has the wrong number of elements to match the primary keyAmend your SQL; then try again
CI4131Invalid value for primary key at position %SOne of the values supplied to obtain a row lock for a table has the wrong type for that position in the primary keyAmend your SQL; then try again
CI4132You cannot use RANDOM() in that contextThe RANDOM() function cannot be called in that contextAmend your SQL; then try again
CI4133Cannot modify security class idYour SQL attempted to modify the id for a security class, which is not allowedCheck your SQL; then try again
CI4134Invalid default valueTable create text contains an unsupported default valueAmend your SQL; then try again
CI4135Replicated ram-only tables cannot have integrity constraintsTable that are replicated and RAM-only cannot have integrity constraintsAmend your SQL; then try again
CI4136SQL statements run via EXEC cannot be SELECT/EXPLAIN/PICTURE/DIAGNOSE/DESCRIBESQL statements run via EXEC cannot be SELECT/EXPLAIN/PICTURE/DIAGNOSE/DESCRIBEAmend your SQL; then try again
CI4137The SELECT used in EXEC must select only characters stringsCheck the SELECT statement used by EXECAmend your SQL; then try again
CI4138Table sample percentages must be between 0 and 100The percentage argument for TABLESAMPLE must be between 0 and 100Amend your SQL; then try again
CI4139Cannot project wx_ramaddr or wx_ramproc from a disk tableYou have tried to project wx_ramaddr() or wx_ramproc() which are not defined for disk-based tablesAmend your SQL; then try again
CI413ACannot project wx_diskaddr, wx_diskmpid or wx_diskptn from a ram-only tableYou have tried to project wx_diskaddr(), wx_diskmpid() or wx_diskptn() which are not defined for ram-only tablesAmend your SQL; then try again
CI413BNo columns in select listYour query selects no columns. This might be because the table in a qualified asterisk has only corresponding join columns (USING or NATURAL JOIN).Amend your SQL; then try again
CI413COperation not valid on external table%SExternal tables do not support operations such as integrity.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 specifiedCORV was specified with an unchanged signature, however it now depends on a newer object, so CASCADE must be specified.Amend your SQL; then try again
CI413EThe CASCADE option must be used to drop or alter connectors on which external tables dependYour drop or alter request specified or implied Restrict and the connector has dependentsEither drop the dependent tables manually or use the Cascade option
CI413FYou must prejoin with simple columns on both sides of the joinYou must prejoin with simple columns on both sides of the joinAmend 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)The prejoin predicate must refer to both sides, not just one side (ie A.A1=B.A2 rather than A.A1=A.A2)Amend your SQL; then try again
CI4141The prejoin view must be of the form "select * from table"The prejoin view must be of the form "select * from table"Amend your SQL; then try again
CI4142The prejoin cannot happen as the join columns are not located on the same ramstoreThe prejoin cannot happen as the join columns are not located on the same ramstoreAmend your SQL; then try again
CI4143The CASCADE option must be used to drop or alter script environments on which external scripts dependYour drop or alter request specified or implied Restrict and the external script has dependent scriptsEither 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 dependYour drop or alter request specified or implied Restrict and the external script has dependent viewsEither drop the dependent views manually or use the Cascade option
CI4145Schema is not empty (contains external scripts)A schema cannot be dropped with the RESTRICT option if it contains external scriptsEither empty the schema or specify the CASCADE option
CI4146View image %S.%T cannot be invalidated or altered as it is used by a prejoinYou are attempting to invalidate or alter a view image that is used by a prejoinNo action required
CI4147View image %S.%T is used by a prejoin, so CASCADE must be specified to drop the imageSpecify "DROP VIEW [IMAGE] X CASCADE"No action required
CI4148External script has variable arguments (...) in the output but not in any inputIf an external script has variable arguments (...) declared in the output then at least one input must also have variable arguments.Amend your SQL; then try again
CI4149External script output column %S has no declared type and no input column has the same nameColumns in external script outputs must either have a declared type or there must be a column in an input with the same name.Amend your SQL; then try again
CI414AThe columns used in the prejoin predicate must have exactly the same typeThe predicate used to do the prejoin must join two columns with exactly the same data typeAmend your lookup or fact table; then try again
CI414BValue range step overflow or zeroAn attempt was use zero or too large a value for the STEP in a VALUES BETWEEN tableCheck your SQL; then try again
CI414CCannot build a prejoin on a prejoinYou are trying to build a prejoin using a prejoined image, and a prejoined column is being used.Check your SQL; then try again
CI414DInvalid image encoding attributeYou are trying to create an object with image encoding attributes that are not valid in this context.Check your SQL; then try again
CI414ECannot evaluate outer reference from external scriptYou are trying to run an external script that has an outer reference, which is not supported.Check your SQL; then try again
CI414FDuplicate external script parameter givenThe statement defines the same parameter more than once for an external script.Check your SQL; then try again
CI4150Invalid image partition specificationAn invalid image partition specification was specified.Check your SQL; then try again
CI4151The values inside a VALUES() list must be simple expressionsInside VALUES() only use simple expression - in particular you can't use CASE or expressions like NULL+1.Check your SQL; then try again
CI4152Invalid column reference for partition byThe column reference in an partition must identify a selected columnAmend your SQL; then try again
CI4153Prejoin to a compressed image %S.%T not allowedIt is not allowed to make a prejoin to a compressed imageAmend your SQL; then try again
CI4154Cannot drop statistics on %S.%T - not in RAMYou can only run this kind of Drop Statistics when that object is loaded into memoryCreate an image of the object and then try again
CI4155A temporary table %S.%T already exists, offset %CIt is not possible to create a normal table with the same name as an existing temporary table (even from another session)Choose a new name; then try again
CI4156The window %S is not definedA window has been used without being defined in the WINDOW clauseDefine the window in the WINDOW CLAUSE, or use the correct name
CI4157The bitcount for APPROXIMATE COUNT DISTINCT must be between 4 and 14 inclusiveThe optional bitcount parameter for APPROXIMATE COUNT DISTINCT was set to an invalid valueChange the value to a number between 4 and 14
CI4158Operation only valid on external tableAn external table operation that is was attempted on an object that is not an external table.Amend your SQL; then try again
CI4159WITH DISTRIBUTIONS: %S is ambiguousAn entry in the WITH DISTRIBUTIONS list is ambiguousAmend your SQL; then try again
CI415AWITH DISTRIBUTIONS: %S is defined more than onceAn entry in the WITH DISTRIBUTIONS list is defined more than onceAmend your SQL; then try again
CI415BWITH DISTRIBUTIONS: unknown object %SAn entry in the WITH DISTRIBUTIONS list is not usedAmend your SQL; then try again
CI415CBad value used in the definition of a VALUES BETWEEN tableAn attempt was use a bad expression in a VALUES BETWEEN tableCheck your SQL; then try again
CI415DYou cannot rename the SYS userThe SYS user cannot be renamed.Check your SQL; then try again
CI415EAn Object Id cannot be specified without an Object TypeRemove the Object Id or add an Object Type.Check your SQL; then try again
CI415Fgenerate_key() is not allowed in aggregatesYou cannot use generate_key() in an aggregateAmend your SQL; then try again
CI4160You cannot order an image by generate_key()You cannot use generate_key() in the order image by clauseAmend your SQL; then try again
CI4161Principal and user combination does not existThere are no entries in the system that match the specified informationCheck your SQL; then try again
CI4162Principal and user combination already existThere is already an entry in the system that matches the specified informationCheck your SQL; then try again
CI4163You cannot create a user FROM USER SYSYou cannot create a user using the SYS user as a templateCheck your SQL; then try again
CI4164You cannot have ORDER IMAGE BY and ORDER BYYou cannot have an ORDER IMAGE BY clause if the view's SELECT is orderedCheck your SQL; then try again
CI4165Bad hash algorithm passed as first argument to XHASH_VALUE ()The first argument to XHASH_VALUE() must be a valid hash algorithm numberCheck your SQL; then try again
CI4166Cannot coerce data types in VALUES branch %sThe data types in the VALUES are not coercableCheck your SQL; then try again
CI4167The image partition is too complexAn invalid image partition specification was specified.Check your SQL; then try again
CI4168You cannot do APPROX aggregates from that table typeYou cannot do APPROX aggregates from that table typeCheck your SQL; then try again
CI4169Complex GROUP BY expression has grouping set column componentYou 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)Check your SQL; then try again
CI4170The ON clause of a MERGE must have one join predicate between the source and the targetThe ON clause must contain one predicate of the form SRC.COL = TGT.COLCheck your SQL; then try again
CI4171Creation of SYS schema objects is not allowed (use a different schema or change parameter sys_objects)When the parameter sys_objects is set to 0, objects may not be created in the SYS schemaCheck your SQL; then try again
CI5xxx
CI5001Internal error (Generator): Please contact KognitioAn internal error occurred in the GeneratorContact the help desk
CI5002Generator feature not yet implementedAn SQL feature has not yet been implemented in the code generatorContact the help desk
CI5003Internal error (Invalid SCode generated): Please contact KognitioThe SCode Generator detected an attempt construct invalid SCodeContact the help desk
CI5004Too much SCode generatedThe SCode Generator produced too much code to be passed back to the callerContact the help desk
CI5011Privilege does not existThe revoke request could not revoke a privilege which does not existCorrect your SQL; then try again
CI5012Privilege already existsThis grant request attempted to add a privilege which already existsCorrect your SQL; then try again
CI5020Default too complexThe default value for a column is too complex to record in the system tablesSimplify your SQL; then try again
CI5021Check clauses too complexThe check clauses on the create table request are too complex to record in the system tablesSimplify your SQL; then try again
CI5022Maximum view text lengthThe SQL text of your view definition is longer than that supported by the serverSimplify your SQL; then try again
CI5023Column specification overflowThe descriptions of the columns returned by your query are too complexSimplify your SQL; then try again
CI5025No such compressed data mapA request has been made to drop a compressed data map which does not existNo action required
CI5026Data maps exist for all columns with statisticsData maps have already been built for all those columns in the specified table for which compressed data map statistics have been gatheredUse drop compressed data map and/or update statistics for compressed data map first
CI5027Inconsistent M and B valuesAn attempt was made to use compressed data map statistics containing inconsistent M and B valuesUse update statistics for compressed data map first
CI5028Table creation text is too large to alterThe 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 dictionaryContact the help desk
CI5029Column %S has no data map statisticsAn attempt to create or drop a compressed data map referred to a column which has no data map statisticsUse update compressed data map statistics first
CI502ANo columns have data map statisticsExpansion: An attempt was made to create a compressed data map for which no valid data map statistics existUse update statistics for compressed data map first
CI502BBad raw queryThe query against an IPE_RAW table was incorrectly statedContact the help desk
CI502CColumn %S data map statistics not currentAn attempt to create a compressed data map referred to a column which has invalid data map statisticsUse update statistics for compressed data map first
CI502DNo compressed data map statistics for table %SAn attempt to drop compressed data map statistics referred to a table which has no compressed data map statisticsCorrect your SQL; then try again
CI502ENo compressed data map statistics for column %SAn attempt to drop compressed data map statistics referred to a column which has no compressed data map statisticsCorrect your SQL; then try again
CI502FCompressed data map exists for column %SAn attempt to drop compressed data map statistics referred to a column which has a compressed data mapDrop the compressed data map; then try again
CI5030Drop with circular referencesThe drop request attempts to remove a table for which circular references exist; this feature is not yet supportedContact the help desk
CI5031Cascaded drop too complexA cascaded drop contained too many levels of nesting.Contact the help desk
CI5032Property cannot be altered - original definition too complexThe original table definition contained possible self references. The table cannot be altered without invalidating these.Contact the help desk
CI5033New schema id too bigSchema ids must be lower than the smallest user table idContact the help desk
CI5034User/Group is not a member of GroupGroup operation was given on a non-member of a group.Contact the help desk
CI5035Expected a group identifierA user was given where a group was expected.Contact the help desk
CI5036Subquery updates to tables with foreign keys or check constraints are not supportedUpdates from subqueries cannot be performed to tables with foreign keys or check constraintsContact the help desk
CI5037Too many tables modified in statementYour query tried to alter too many tables.Contact the help desk
CI5038Bad bCNF was producedAn internal error meant that incorrect bCNF was generated.Contact the help desk
CI5039Replacing the view like that would create a circularity (V1 uses V2 uses V1...)You are trying to change the view definition in such a way that a circular list of view references would be created.Contact the help desk
CI503A%S.%T is not an invalidated viewYou are attempting to use a command that only applies to invalidated viewsCorrect your SQL
CI503BThere are no invalidated views in the systemThere are no invalidated views in the systemNo action required
CI503CYou cannot CREATE OR REPLACE view %S.%T as it is referenced elsewhere in these statementsYou are CREATE OR REPLACEing a view, but that view is referred to elsewhere in these batched statementsCorrect your SQL
CI503DYou cannot drop the compressed data map for a table that is horizontally fragmented in RAM; drop the image firstYou are trying to drop a compressed data map for a table that is horizontally fragmented in RAMDrop 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 sessionYou are trying to drop a schema cascade, but it contains temp tables created by a different sessionDisconnect the other session, then try again
CI503FThe fragmenting predicate is too complexThe fragmenting predicate that you are using is too complex to be storedSimplify the predicate if possible
CI5040A value specified in a VALUES() entry could not be evaluatedA value specified in a VALUES entry could not be evaluated (numeric overflow?)Simplify the VALUES values if possible
CI5041That queue cannot be dropped as it has users assigned to itYou are trying to drop a queue that still have usersDrop 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)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.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 existsYou are trying to create an external group using a name that already existsCheck that you are using the right name
CI5044An external group with that name does not existYou are trying to do something with an external group using a name that does not exist in the systemCheck that you are using the right name
CI5045USERS SHOULD NEVER SEE THIS - PLEASE SEND YOUR QUERY TO KOGNITIO!This should never be seenNone
CI5046You cannot order by an expression that is not present in the source (use a derived table)The query orders by an expression that is not directly available in the source tableUse a derived table so that the expression exists in the source
CI5500Internal error (Optimiser generator): Please contact KognitioOptimiser scode generation failedContact the help desk
CI5502Optimiser generator feature not yet implementedAn SQL feature has not yet been implemented in the optimiser scode generatorContact the help desk
CI5510Internal error (Optimiser generator): Please contact KognitioOptimiser scode generation failedContact the help desk
CI5511Internal error (Optimiser generator): Please contact KognitioOptimiser scode generation failedContact the help desk
CI5512Internal error (Optimiser generator): Please contact KognitioOptimiser scode generation failedContact the help desk
CI5513Internal error (Optimiser generator): Please contact KognitioOptimiser scode generation failedContact the help desk
CI5514Internal error (Optimiser generator): Please contact KognitioOptimiser scode generation failedContact the help desk
CI5515Internal error (Optimiser generator): Please contact KognitioOptimiser scode generation failedContact the help desk
CI5516Internal error (Optimiser generator): Please contact KognitioOptimiser scode generation failedContact the help desk
CI5517Internal error (Optimiser generator): Please contact KognitioOptimiser scode generation failedContact the help desk
CI7xxx
CI7001Internal error (Optimiser): Please contact KognitioAn internal error occurred in the OptimiserContact the help desk
CI7002Optimiser feature not yet implementedAn SQL feature has not yet been implemented in the optimiserContact the help desk
CI7003Internal error (Optimiser subquery): Please contact KognitioAn internal optimiser error occurredContact the help desk
CI7004Internal error (No joins found for subquery): Please contact KognitioAn internal optimiser error occurredContact the help desk
CI7005Optimiser parameter invalidAn internal optimiser error occurredContact the help desk
CI7006Mixed aggregates too complexYour query contained a mixture of distinct and non-distinct aggregates which is not yet supportedContact the help desk
CI7007Predicate too complexYour query contained a combination of predicates which is not yet supportedContact the help desk
CI7008Internal error (Invalid projection generated): Please contact KognitioAn internal optimiser error has occurredContact the help desk
CI7009Internal error (Unable to find a valid path): Please contact KognitioAn internal optimiser error has occurredContact the help desk
CI700AJOIN ON predicate with more than one table on a side of predicate - use WHEREYour query contained a predicate with more than one table on a side. Consider using WHERE, or rewriting the predicate
CI700BQuery contains too many joinsYour query requires more than the present limit of 32 joinsContact the help desk
CI700CQuery contains a theta join, which is disallowed as the error_on_theta parameter is setYour query contains a theta join, which is disallowed as the error_on_theta parameter is setContact the help desk
CI7100Internal error (Transformer): Please contact KognitioAn internal error occurred in the TransformerContact the help desk
CI7102Transformer feature not yet implementedAn SQL feature has not yet been implemented in the transformerContact the help desk
CI7107Predicate too complexYour query contained a combination of predicates which is not yet supportedContact the help desk
CI7108Outer reference Predicate containes no Inner referencesYour query contained a predicate with an outer reference which should be applied elsewhereContact the help desk
CI7109Cannot OR outer reference predicates except in an IN/NOT IN contextPerforming this operation is unsupported.Contact the help desk
CI710ADisjunction of Inner and Outer predicates not possible.Performing this operation is unsupported.Contact the help desk
CI710BYou cannot use an outer reference in a derived table.Performing this operation is unsupported.Contact the help desk
CI710CYou cannot combine a (+) outer join condition using OR.Performing this operation is unsupported.Contact the help desk
CI710DYou cannot self join a (+) outer join table.Performing this operation is unsupported.Contact the help desk
CI710EAll (+) joins must be to the same table.Performing this operation is unsupported.Contact the help desk
CI710FOnly one table can be (+) outer joined.Performing this operation is unsupported.Contact the help desk
CI7110A (+) table must join to another table.Performing this operation is unsupported.Contact the help desk
CI7111You cannot mix the outer join syntaxes.Performing this operation is unsupported.Contact the help desk
CI7112You cannot create a loop of outer joins.Performing this operation is unsupported.Contact the help desk
CI7113A (+) join cannot be to a subquery or outer reference.Performing this operation is unsupported.Contact the help desk
CI7114A dependent view has an image in RAM, so you cannot CASCADE without specifying one of CREATE IMAGES/DROP IMAGESYou cannot CASCADE if a dependent view has an image in RAM. Use CASCADE [CREATE|DROP] IMAGES [IGNORE ERRORS]Contact the help desk
CI8xxx
CI8001Internal error (Interpreter): Please contact KognitioSome internal interpreter error occurredContact the help desk
CI8002Interpreter feature not yet implementedAn SQL feature has not yet been implemented in the interpreterContact the help desk
CI8003Query abortedYour query was abortedFind out why your query was aborted before trying to rerun it
CI8005Internal error (No SCode supplied to interpreter): Please contact KognitioAn internal interpreter error occurredContact the help desk
CI8006Internal error (Invalid SCode instruction): Please contact KognitioSome internal interpreter error occurredContact the help desk
CI8007Internal error (Unsupported SCode instruction): Please contact KognitioSome internal interpreter error occurredContact the help desk
CI8008Internal error (Invalid System Version flag): Please contact KognitioSome internal interpreter error occurredContact the help desk
CI8009Insufficient memoryThere is insufficient memory to interpret this requestFree some server memory and try again
CI800AInvalid SCode specificationThe interpreter subsystem detected an inconsistent SCode instructionContact the help desk
CI800BInternal error (Invalid SCode Value): Please contact KognitioAn internal interpreter error occurredContact the help desk
CI800CInternal error (Invalid DataBuf): Please contact KognitioAn internal interpreter error occurredContact the help desk
CI800DInternal error (Invalid ColSpec): Please contact KognitioAn internal interpreter error occurredContact the help desk
CI800EInternal error (Invalid AccessNo): Please contact KognitioAn internal interpreter error occurredContact the help desk
CI800FInternal error (Invalid VarNum): Please contact KognitioAn internal interpreter error occurredContact the help desk
CI8010Invalid Cursor StateThe cursor is in an invalid state for this operation; it is not positioned on a rowCheck the last cursor operation
CI8011Cursor operations conflictTwo cursor operations have conflicted with each otherCheck if the current cursor row has been deleted
CI8021Schema %S existsAn attempt was made to create a schema which already existsChoose a new schema name and retry
CI8022User or group %S existsAn attempt was made to create a user or group which already existsChoose a new user or group name and retry
CI8023Table or view %S.%T existsAn attempt was made to create a table or view which already existsChoose a new name and retry
CI8024Snapshot %S existsAn attempt was made to create a snapshot which already existsChoose a new snapshot name and retry
CI8025Privilege existsAn attempt was made to add a privilege which already existsNone
CI8026Column privilege existsAn attempt was made to add a column privilege which already existsNone
CI8027Security Class %S existsAn attempt was made to create a security class which already existsChoose a new security class name and retry
CI8028Referential integrity row does not existYou are trying to create a foreign key reference to a column that is not a unique keyCheck your SQL statements; then try again
CI8029Unique group row already existsYou are trying to add a row which would violate a unique constraintCheck your SQL statements
CI802ATable contains no rowsAn attempt was made to obtain compressed data map statistics for an empty tablePopulate the table before attempting to gather compressed data map statistics
CI8030Internal error (Could not delete row): Please contact KognitioThe server could not delete a rowContact the help desk
CI8031Character string too longAn attempt was made to insert a character string that exceeds the defined length of a columnCheck your SQL statements; then try again
CI8032Type mismatchData type conversion - type mismatchExamine your query; then try again
CI8033Numeric value out of rangeData type conversion - numeric value out of rangeExamine your query; then try again
CI8034Restrict integrity violation
CI8035Invalid parameter valueA query was executed with a supplied parameter which is outside the range of its type defined when the query was preparedAmend your SQL; then try again
CI8036Interval field overflowAn interval value has overflowed the maximum number of digits in its leading fieldExamine your query and data; then try again
CI8041Reclaim is already in progressThis request cannot be run while a reclaim is in progressWait for the reclaim to complete; then try again
CI8045Check constraint violationYour query has breached a table's check constraintRefer to the definition of the table
CI8046Check option violationYour insert or update has breached a view's check optionRefer to the definition of the view
CI8048Table %s does not existThe table required by your query does not existCheck your SQL statements; then try again
CI8049View %s does not existThe view required by your query does not existCheck your SQL statements; then try again
CI804AUser or group %s does not existThe user or group required by your query does not existCheck your SQL statements; then try again
CI804BUser %s does not existThe schema required by your query does not existCheck your SQL statements; then try again
CI8051Row does not existA system table row does not existCheck your SQL statements; then try again
CI8052Improper cardinality for non-cursor selectA select statement returned more than one row but you have not declared a cursorCheck your SQL statements; then try again
CI8053Subquery cardinality too greatWhen comparing an expression or value with the result of a subquery, the subquery must not return more than one row.Check your SQL statements; then try again
CI8060NULL value is not allowed
CI8065Invalid date valueAn attempt was made to return an invalid date valueContact the help desk
CI8066Invalid time valueAn attempt was made to return an invalid time valueContact the help desk
CI8067Invalid timestamp valueAn attempt was made to return an invalid timestamp valueContact the help desk
CI8068Invalid time with zone valueAn attempt was made to return an invalid time with zone valueContact the help desk
CI8069Invalid timestamp valueAn attempt was made to return an invalid timestamp with zone valueContact the help desk
CI806AInvalid year-month interval valueAn attempt was made to return an invalid year-month interval valueContact the help desk
CI806BInvalid day-time interval valueAn attempt was made to return an invalid day-time interval valueContact the help desk
CI8070Invalid data type provided for a parameterThe data type of a parameter value does not match the data type which was specified when the query was initiatedCheck your SQL statement, make sure that you provide the correct data types; then try again
CI8071Invalid length provided for a parameterThe length of a dynamic parameter value does not match the data type which was specified when the query was initiatedCheck your SQL statement, make sure that you provide the correct parameters; then try again
CI8072Invalid value provided for a parameterThe value of a dynamic parameter does not match the data type which was specified when the query was initiatedCheck your SQL statement, make sure that you provide the correct parameters; then try again
CI8073Premature end of parameter setThe parameter count does not match the number of parameters in the SQLCheck your SQL statement, make sure that you provide the correct parameters; then try again
CI8074String too long fetching resultsThe result set contains a string that exceeds the system maximum byte length for a stringCheck your SQL statements; then try again
CI8078Column specification overflowThe descriptions of the columns in the export are too complexContact the help desk
CI8080Too many tables to pictureThe SQL statements contains more tables than the server is able to picture If it is feasible, try to limit the number of tables in your statement
CI8081Correlated update would introduce extra rowsThe table you are correlating against has more than one value which matches your data set to be updated.Check that you are using distinct rows in your correlated update statement.
CI8082User/Group is already member of groupThe group member you are trying to add is already a member of the groupContact the help desk
CI8083User/Group is not a member of groupThe group member you are trying to remove is not a member of the groupContact the help desk
CI8084Table wide privilege already existsA Table Privilege exists for the column privilege you are trying to addContact the help desk
CI8085Column privilege does not existThe revoke request could not revoke a column privilege which does not existContact the help desk
CI8086Table privilege does not existThe revoke request could not revoke a table privilege which does not existContact the help desk
CI8087Schema privilege does not existThe revoke request could not revoke a schema privilege which does not existContact the help desk
CI8088System privilege does not existThe revoke request could not revoke a system privilege which does not existContact the help desk
CI8089Privilege does not existThe revoke request could not revoke a privilege which does not existContact the help desk
CI808ASyntax error or access violationYou do not have a required privilege for this query.Contact the help desk
CI808BGroup privilege does not existThe revoke request could not revoke a group privilege which does not existContact the help desk
CI808CUser privilege does not existThe revoke request could not revoke a user privilege which does not existContact the help desk
CI808DPlugin already existsA plugin of this name already existsChoose a different plugin name
CI808EThe specified plugin does not existA plugin of this name does not existChoose a different plugin name
CI808FPlugin privilege does not existThe revoke request could not revoke a plugin privilege which does not existContact the help desk
CI8090Hash exception query produced no resultsThe query to generate hash exceptions did not return any rowsChoose a different query, or do not use exceptions
CI8091Hash exception query produced too many resultsThe query to generate hash exceptions returned too many rowsChoose a different query, or do not use exceptions
CI8092Illegal escape sequence in LIKEYou can only specify the escape character before an underscore, percent or the escape character itselfRewrite your SQL statement and then try again
CI8093Databuf assertion failure in interpreterSome internal interpreter error occurredContact the help desk
CI8094Error running embedded SQL '%S'. The error returned was '%M'Some internal interpreter error occurredContact the help desk
CI8095Trying to DEBUG DUMPTTS with streaming enabledDEBUG DUMPTTS is not allowed with streaming enabledRewrite your SQL statement and then try again
CI8096Internal error (Character set translation tables): Please contact KognitioAn internal error occurred reading the character set translation tables.Contact the help desk
CI8097Internal error (Validating system): Please contact KognitioAn internal error occurred while checking system table consistency.Contact the help desk
CI8098You cannot drop all of the slabs for a tableYou are dropping all of the slabs that have been set for a tableContact the help desk
CI8099Invalid string representationThere was a string with an invalid representation for its character set.Contact the help desk
CI809ACodepoint not in character setThere was a character not available in the destination character set during conversion.Correct the data or request; then try again
CI809BBinary string too longAn attempt was made to insert a binary string that exceeds the defined length of a columnCheck your SQL statements; then try again
CI809CInternal error validating system (see IPE_VALIDATE for details)An internal error occurred while checking system table consistency; see IPE_VALIDATE for more information.Contact the help desk
CI809DDEP line length too shortThe line length for diagnose/explain/picture is too short.Set the parameter ci_deplinelen to something larger
CI809EThe maximum length of a row has been exceeded An attempt was made to insert a row that exceeds the maximum possible length of a rowCorrect the data or request; then try again
CI809FToo many columnsThe number of columns in the query exceeded the maximum allowedContact the help desk
CI80A0Failed to recover memory imagesThe system failed to recover the memory images. Perform a CREATE IMAGEContact the help desk
CI80A1Internal error (Interpreter threading): Please contact KognitioSome internal interpreter error occurredContact the help desk
CI80A2That user map already existsThat user map already existsContact the help desk
CI80A3That user map doesn't existThat user map doesn't existsContact the help desk
DA0xxx
DA0001Queue fullThe Lock Manager queue is temporarily overloaded, so your lock request has not yet been processed Try again later
DA0003Lock timeoutTo avoid a deadlock, your command has failed but your transaction has NOT been rolled back Try again later
DA0004Locklist fullThe Lock Manager cannot process any more requests at present Either try again later or Commit or Rollback some existing transactions
DA0005Deadlock detectedTo avoid a deadlock, your command has failed but your transaction has NOT been rolled back Try again later
DA0006Transaction list fullThe Lock Manager cannot process any more requests at present Try again later
DA0007Insufficient memoryThe Lock Manager cannot process any more requests at present Try again later
DA0008Setting breakable transaction for tno already marked as breabaleThe transaction being marked as breakable is already brekable Try again later
DA0009Recursion too deep checking for deadlockThe Lock Manager was unable to check for deadlocks because the recursion was too deep (your transaction has NOT been rolled back) Try again later
DA2xxx
DA2003Query aborted
DO0xxx
DO0001Disk ID not foundError in the Disk ReCreate parameters which specify rack position of disk controller card Check your parameters; then try again
DO0002Invalid close stateMore than one disk in the cluster contains irrecoverable data, so you cannot simply ReCreate one Notify Help Desk
DO0003Another bad disk in clusterMore than one disk in the cluster contains irrecoverable data, so you cannot simply ReCreate one Notify Help Desk
DO0004Attempt to read bootinfo before disks initialisedAttempt to read bootinfo before disks initialised Notify Help Desk
DO0005Server code mismatchThe bootinfo on disk is older/younger than the server code being run. Notify Help Desk
DO0006Invalid bootdisk informationAttempt to update ipe_boot with an invalid value e.g. Check query is reasonable; then try again
DO0007Attempt to reconfigure system before image info available.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. create [system] image
DO0008Not all disks checked in yet, so no boot info availableAfter a reboot the DO reads in boot info only after all disks have checked in. *Retry. If this does not succeed, contact support
DO0009Reconfigure down would leave some WX2 clusters partially populatedReconfigure down must either remove a WX2 cluster completely or leave it untouched *Change the set of disk resources to be removed so that it matches this restriction
DO000AReconfigure down must be for some but not all disksReconfigure down was attempted for all / no disks, which is an error *Specify a valid number of disks for reconfigure down
DO000BNot enough disk space on remaining disks to allow reconfigure downReconfigure down not safe, as currently there is too much data on the disks to fit onto the disks which would remain afterwards *Free up some disk space via deletes/drops/reclaim, or remove fewer disks
DO000CNot in reconfigure mode so cannot run reconfigure SQLReconfigure can only be run after starting WX2 in reconfigure mode *Restart WX2 in reconfigure mode with wxserver start reconfigure
DP0xxx
DP0001Out of diskOne or more disks is full Use the Reclaim command to release some disk space
DP0002Invalid diskA disk in the cluster contains irrecoverable data Use the Disk ReCreate command to regenerate the contents
DS0xxx
DS0001No memoryIrrecoverable internal RDBMS error Notify Help Desk
DS0002No hash spaceInternal RDBMS error Notify Help Desk
DS0003Invalid lengthA disk in the cluster contains irrecoverable data RDBMS may regenerate the content automatically If RDBMS does not recreate the contents automatically, use the Disk ReCreate command to regenerate the contents
DS0006Garbage on diskA disk in the cluster contains irrecoverable data Use the Disk ReCreate command to regenerate the contents
DS0007Unable to perform RAID operationMore than one disk in the cluster contains irrecoverable data, so you cannot simply ReCreate one Notify Help Desk
DS0008Disk badA disk in the cluster contains irrecoverable data Use the Disk ReCreate command to regenerate the contents
DS000AOut of cacheInternal RDBMS error Re-boot the server; then Notify Help Desk
DS000DRecord too largeYou have breached the implementation limit for maximum record length Split your record into parts
DS000FToo many accessesDisk input/output channels currently busy Try again later
DS0010Access not foundInternal RDBMS error Notify Help Desk
DS0013Not initialisedInternal RDBMS error Notify Help Desk
DS0018Index not foundInternal RDBMS error Notify Help Desk
DS001DParity disk is invalidInternal RDBMS error Notify Help Desk
DS0020Record MissingDisk repair has identified an error Notify Help Desk
DS0023M values improper for compressed indexInternal RDBMS error Notify Help Desk
DS0024B values improper for compressed indexInternal RDBMS error Notify Help Desk
DS0025Invalid hash algorithmInternal RDBMS error Notify Help Desk
DS002BSimulated errorArtificially generated disk error to test error handling If you did not trigger the error, contact support
DS002DFormat can only be done to bad/reconfigurable disks
DS002EAttempt to read a sector from a disk performing background format.
DS002FParity disk is bad.Internal RDBMS error Notify Help Desk
DS0032More m and b values than are allowed for a compressed index.Internal RDBMS error. Notify Help Desk.
DS0033Bad blockpages value for compressed index.Internal RDBMS error. Notify Help Desk.
DS0034Attempting to read off end of disk.Internal RDBMS error / client software bug, possibly wxdisku / user error with wxdisku. Notify Help Desk.
DS0035Attempting to operate on invalid tableid for disk.Internal RDBMS error: a disk request was made using a tableid outside the valid range for disk-based data. Notify Help Desk.
DS0050OLR is not supported with this file system.Certain file systems do not currently support OLR. You must schedule a GSR or repack instead. Schedule a GSR or repack
DS0051Insert of data failed as no suitable partition with space.An insert was attempted which failed as there was no partition available for the target table with sufficient free space. 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.Statistics indicate that a compressed data map is not appropriate for this data. 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.An invalid slab was specified as the target slab for a table. 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.A table with a RAM image was specified for repacking, but the RAM subsystem cannot deal with this at the moment. Drop the image of the table, repack, then recreate the image if required.
DS0056Unable to start, a disk(s) has not been zeroed.With raid enabled, all disks must be zeroed prior to startup. One or more disks has not been Check newsys has not been executed twice
DS0057Unable to perform the operation with the specified slab list.The slab list specified is invalid. For example, trying to drop all the slabs a table uses Ensure that the slab list is valid for the operation being performed
DS0058Unable to construct map with no CNF providedA query has specified a null (0) CNF, creating the bitmap will fail Notify Help Desk.
DS0059Unable to perform read due to internal errorAn internal error has occurred on a read, further details in serverdbg logging file Notify Help Desk.
DS005ATried to remove slabs but they are not current target slabsThe slab list specified is invalid. For example, trying to remove a target slab which a table is not currently using Ensure that the slab list is valid for the operation being performed
DS005BTried to decompress data, but was not in compressed formatThe compressed data was corrupt and so could not be decompressed Notify Help Desk.
DS005CCannot format WX2 via server softwareFormatting via SQL is no longer supported - use wxtool -Z to format new disks, or recommission Notify Help Desk if wxtool -Z or recommissioning is not appropriate in this instance.
DS005DNot enough space on disk for compressed dataThe compressed version of a disk page has expanded and will no longer fit in the allocated space Repack the problem data into a new slab.
DS005ETrying to create extent snapshot using ID already in useThe Id given for the creation of an extent snapshot has already been used to define an extent snapshot Use a unique extent snapshot id or drop the existing snapshot using this id.
DS005FUnknown extent idThe Id given as reference to an extent does not match any existing extent Use a valid id.
DS0060Specified extent generated for a different fileAn extent has been specified to use to scan a specified table. However, that snapshot was generated for a different table Use the correct extent for this file.
DS0061Slab has non-repackable fileSlab has non-repackable file, i.e. it is only allowed to have rows on this slab. Alter the file in question to not be assigned to a single slab, or use the repack ROTATE option.
DS0062Train aborting scan, out of memoryThe Disk Train was unable to allocate or reclaim enough memory for a read buffer, aborting scan. Try again later
DS0063A redistribute was abortedThe redistribute was aborted, need to let the background server know this Should never be seen
DS0064Debugging error randomly generatedDue to a parameter being set, the DS has randomly errored for debugging purposes Ignore
DS0065Invalid date valueOperation produced an invalid date value Contact the help desk
DS0067Invalid timestamp valueOperation produced an invalid timestamp value Contact the help desk
DS0068Invalid time valueOperation produced an invalid time value Contact the help desk
DS006AYear-month interval overflowPrecision of year-month interval value is too small Contact the help desk
DS006BDay-time interval overflowPrecision of day-time interval value is too small Contact the help desk
DS006CRecord not found at delete addressAsked to delete a record, yet data at disk address indicates this is not a record Notify Help Desk.
DS006DProjected record (not physical record) larger then maximum record sizeNotify Help Desk.
DS006ECDM memory allocation would exceed allowed memory for CDMs as defined by the cdm_ram_limit parameterConsider dropping some CDMs after increasing cdm_ram_limit to allow restart
DS006FTrying to get an element programatically from the file table which doesn't existNotify Help Desk.
DS0070Returning a train meta block without having read one!!!Returning a meta block to the train queue when the flag that indicates we actually asked for it isn't set, this is badNotify Help Desk.
DS0071Train has generated an internal errorThe disk train has gotten into a bad or inconsistent state which requires it abort this operationNotify Help Desk.
DS0072Selective loader bucket allocation would result in too lower memory situationCurrent memory levels in the disk store preclude allocating memory for a selective load distribution bucets Notify Help Desk.
DS0073Write of a record attempted with an invalid lengthNotify Help Desk.
DS0074Sync or write to the disk resource failedAn attempt to persist data to disk failed. Notify Kognitio support.
DS0075Deletes could not be written to slab as not enough spaceDeletes not possible as reached delete threshold limit on slab. Repack/reclaim disk space on relevant slabs
DS0088 Interval field overflowAn interval value has overflowed the maximum number of digits in its leading field Examine your query and data; then try again
DS0100Arithmetic overflowYou have tried to multiply values to a sum beyond the implementation limit Check your program logic; then try again
DS0101Division by zeroYou have tried to divide by zero Check your program logic; then try again
DS0102Invalid Trim specificationAn attempt was made to TRIM a character string which contained an invalid specification Correct the data or request; then try again
DS0103Insufficient string space for operationAn attempt was made to CAST a character string into another data type but there is insufficient space to complete the operation Correct the data or request; then try again
DS0104Bad regular expressionThe regular expression is incorrectly formatted Correct the data or request; then try again
DS0105Not enough memory to generate codeNot enough memory to generate code Either simplify the query, or free up some memory
DS0106Internal code generator erroran internal error has occurred contact support
DS0107Internal error running generated codean internal error has occurred contact support
DS0108Null value inserted into non-null columnNull value inserted into non-null column add a 'where field is not null' to the query or make target nullable
DS0109Invalid month parameter given to PACKDATE(year, month, day)Only values of 'month' where 1<=month<=12 are allowed when using PACKDATE Correct the data or request; then try again
DS010BToo many plugin functions usedThe SQL query uses too many plugins in one expression Simplify the query
DS010CCardinality errorA row was joined to more than one row where this is not allowed Check query
DS010EGenerate key is invalid in this contextThe generate_key function was used somewhere where it is not allowed Check query
DS010AInvalid day parameter given to PACKDATE(year, month, day)The day of the month must be between 1 and 28,29,30, or 31 (depending on the month and leap year Correct the data or request; then try again
DS010DInvalid parameter given to TIME(H, M, S)The time function must be given valid values 0-23,0-5,0-59 Correct the data or request; then try again
DS0110Internal Error: Index register allocation failedThis is an internal error, contact support. contact support
DS0111Internal Error: Column projection too bigAttempted to project a column into a space that was too small. contact support
DS0112Internal Error: Lookup value is NULLAttempted to use a NULL value as an internal array index. contact support
DS0113Internal Error: Lookup value not foundUnable to find a lookup value in an internal array. contact support
DS0114Internal Error: saved bucket queue is fullThis should never happen, something should drain it. contact support
DS0115Internal Error: Unable to restart access streamThe query attempted to restart an unrestartable operation. contact support
DS0116Internal Error: Varchar data is corruptedAn internal data structure became corrupted. contact support
DS0117Internal Error: Hint record leakageA hint record leaked into an incorrect place. contact support
DS0118The number of buckets in width_bucket() must be at least 1Change the number of buckets so that it is greater than zero Correct the data or request; then try again
DS0119The range in width_bucket must be non-zeroThe min and max values specified in width_bucket() are equal Correct the data or request; then try again
DS011ANo match found for join recordA record did not join to any records in a lookup table Correct the data or request; then try again
DS011BSAME_VALUE found different valuesThe SAME_VALUE aggregate received different non-NULL values, but they should all be the same Correct the data or request; then try again
DS011CONE_VALUE found multiple valuesThe ONE_VALUE aggregate received multiple non-NULL values, but they should be at most one Correct the data or request; then try again
DS011DInternal error, invalid disk block passed to scan.A disk scan was passed a block which does not contain a valid forward chain of records for the appropriate table Contact support
DS011EInvalid binary record length from external sourceAn external program outputed a binary record with an invalid length. Check query and external source (script or table)
DS011FPartial binary record from external sourceAn external program sent a partial binary record and then terminated. Check query and external source (script or table)
DS0120A string contained a partial characterA string in the database contains an incomplete character (e.g. 2 bytes of a utf-32). Check data and contact support
DS0122Incorrect value size for cast from binaryA value was cast from a binary to a type with incompatible length. Check binary casts in the query and correct
DS0123Internal error -- Incorrect lengths for approx count distinct mergeThe server tried to merge two approx distinct lists of different lengths. This should not happenContact support
DS0124Internal error: imported record sent with invalid lengthA record imported using wxloader, wximport or an external table or script has been presented for conversion with an invalid length on it. Contact support.
DS0181Plugin failureThe plugin is in safe mode and has crashed contact plugin vendor to resolve the problem or debug
DS0182Undefined plugin errorA plugin returned an undefined error code Contact the plugin vendor for support
DS0183Module %S: %TThe plugin module returned an error string Contact the plugin vendor for support
DS0184The plugin returned a string of the wrong lengthThe plugin module returned a string of the wrong length Contact the plugin vendor for support
DS0185Abiguous type for string argument to plugin functionThere are multiple possible types to convert the string argument into. Use an explicit cast from string to the correct type
DS0200Substring errorAn attempt was made to perform a Select Substring which contained an invalid specificationCorrect the data or request; then try again
DS0201Insufficient string memoryAn attempt was made to perform a string operation for which there was insufficient memoryCorrect the data or request; then try again
DS0202Character string too longAn attempt was made to insert a character string that exceeds the defined length of a columnCorrect the data or request; then try again
DS0203Invalid character value for castAn attempt was made to CAST a character string into another data type but it contained characters that could not be convertedCorrect the data or request; then try again
DS0204Numeric overflow during conversionAn attempt was made to CAST a character string into another data type but this resulted in an overflowCorrect the data or request; then try again
DS0205Numeric underflow during conversionAn attempt was made to CAST a character string into another data type but this resulted in an underflowCorrect the data or request; then try again
DS0206minchars parameter to string function too large or negativeThe value specified for the minchars parameter to a string function was not in the range of allowed valuesCorrect the data or request; then try again
DS0207Invalid value specified for base parameter to string functionThe value specified for the base parameter to a string function was not an allowed valueCorrect the data or request; then try again
DS0208Invalid character value for string functionAn attempt was make to use a string function such as strtoint() or strpackints() on an invalid stringCorrect the data or request; then try again
DS0209Invalid 'count' parameter for string functionstrunpackints() or strpackints() was called with an invalid 'count' parameterCorrect the data or request; then try again
DS020AInvalid 'bits' parameter for string functionstrunpackints() or strpackints() was called with an invalid 'bits' parameterCorrect the data or request; then try again
DS020B'bits' * 'count' > 64 in strunpackints()Too many bits specified for strunpackintsCorrect the data or request; then try again
DS020CInvalid separator for string functionstrunpackints() strpackints() strcount() or strchop() was called with a separator that was not a char(1)Correct the data or request; then try again
DS020DZeroth element selected as strpos(,,0) or strchop(,,0,) or strchop(,,,0)Only none zero positive or negative values are allowed for the 'start' and 'end' parameters to strchop() and the 'occurence' parameter to strpos()Correct the data or request; then try again
DS020EAttempt to search for a zero length stringThe second parameter given to strpos() evaluated to a zero length stringCorrect the data or request; then try again
DS020FAttempt to strpackints() a string with too few segmentsThe string given to strpackints() did not contain as many segments as were specified in the count argument.Correct the data or request; then try again
DS0210Attempt to strpackints() a string with too many segmentsThe string given to strpackints() contained more segments than were specified in the count argument.Correct the data or request; then try again
DS0211Product of count and bits params to strpackints greater than 64The result of strpackints is limited to 64 bits, so count*bits must be between 0 and 64.Correct the data or request; then try again
DS0212Result of strunpackints too large for formatThe number to be unpacked by strunpackints was too large to fit in the output format.Correct the data or request; then try again
DS0213String wrong length for functionThe string supplied is of the wrong length for the functionCorrect the data or request; then try again
DS0214Invalid string representationThere was a string with an invalid representation for its character set.Contact the help desk
DS0215Codepoint not in character setThere was a character not available in the destination character set during conversion.Correct the data or request; then try again
DS0216Unknown character setAn unknown character set was specified.Contact the help desk
DS0217Bad number of octets per characterThere was an invalid number of octets per character defining a character set.Contact the help desk
DS0218Bad translation table rangeThere was an invalid translation table defining a character set.Contact the help desk
DS0219Internal error in character conversionAn unknown error occurred while doing a character set conversion.Contact the help desk
DS0250Invalid string for to_numberAn invalid string was supplied to to_number() Check your SQL statement; then try again
DS0251Invalid format stringAn invalid format string was used Check your SQL statement; then try again
DS0252Invalid format stringAn invalid date specifier was used Check your SQL statement; then try again
DS0253Bad value in date stringThe date string contained an bad value Check your SQL statement; then try again
DS0254Internal error - ran out of digits!An internal error occurred Contact the help desk
DS0255Too many significant digits passed to to_numberToo many significant digits were passed to to_number() - use an explicit cast Check your SQL statement; then try again
DS0256Invalid day numberAn invalid day number was specified Check your SQL statement; then try again
DS0257No year was specifiedNo year was specified Check your SQL statement; then try again
DS0258FX specified but wrong number of digitsInvalid input - FX specified but wrong number of digits Check your SQL statement; then try again
DS0800Error encountered - repair required.Internal RDBMS error. Notify Help Desk.
DS2xxx
DS2003Query aborted
EC1xxx
EC1201Mapper task failed to write dataa mapper task in a Hadoop map-reduce job failed to write out converted data. Contact support.
ET0xxx
ET0001Failed to create pipe for callInternal error, method call pipe creation failed. Contect support
ET0002Failed to execute script for method callThe call to an external table's script handler failed. check the external table connector's handler script
ET0003Error calling an external table connector methodAn external table connector returned an error handling a method call. check the external table connector's handler script
ET0004Out of buffer space processing script replyAn external table connector returned too much data from a method call. check the external table connector's handler script
ET0005Method handler for connector is not presentAn internal error generated an external table operation with no method handlers Cointact support
ET0101Internal error handling external table connectionan internal error has occurred contact support
ET0102The external table connector for the operation was not foundan internal error has occurred contact support
ET0103External table connector program exited abnormallyThe external program used to handle connection operations exited abnormally investigate the external script or program associated with the connector to diagnose this fault
ET0104Internal error caused two connectors with the same identifierThe external connector is registered twice in the external table manager (internal error) contact support
ET0105Cannot deactivate a connector while it is in useThe connector is being used in another operation Wait for the other operation to finish or abort it
ET0106External tables are not enabled for this serverThe external tables feature must be enabled by the [boot options] external_tables setting in the config file. Enable external tables and restart WX2
ET0107Invalid method type for callInternal error, WX2 used the wrong type for a method call. Contect support
ET0108Remote object has wrong number of columnsAttempted to create an external table on an object with the wrong number of columns Check external object and external table/connector deffinitions
ET0109Cannot determine external object data formatThe server cannot determine the number/type of columns in the external data source Define columns in the external table create or add attributes to tell the connector what the types are
ET010AInvalid format string for external tableThe connector returned an invalid format string for the external table Check connector arguments and consult the connector's author
ET010BUnsupported datatype for automatic format string generationThe external table contains columns for which a format string cannot be automatically generated Manually specify a format string or contact the connector's author for help
ET010CInternal error generating format stringA format string for the external table could not be automatically generated Manually specify a format string or contact support
ET010DInvalid character set for external data sourceThe external table wants to supply data in an invalid character set Check the specified character set and correct
ET010EFile type number is not valid.The file type number for the data is not in the correct range Check the specified file type number and correct
ET010FInvalid external data record, see SYS.IPE_CONV_ERROR for details (tno %S)An invalid external data record was suppliedCheck 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)An external table access encountered so many invalid records that the load was abandoned. Check the SYS.IPE_CONV_ERROR table and correct the data records or your formatting options.
ET0111User mapping for the external operation was invalidThe external operation could not be mapped onto a valid external user ID. Check limits on external user IDs. Check mapping table. Check users are created correctly.
ET0112External data source BINARY column too longThe external data source is returning a BINARY column which is defined as having more than 32000 bytes. 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 longThe external data source is returning a string column which is defined as having more than 32000 characters. 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 largeThe external data source is returning a DECIMAL column whose precision is greater than 18. 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 largeThe external data source is returning a TIME or TIMESTAMP column whose precision is greater than 6. 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 typeYou have specified that the external data source provides JSON, but you have not specified the column definitions as a format string. 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 operationYou have specified raw mode in the target string, but the connector does not support fetching data in this way. Remove the "raw" attribute from the target string.
IE0xxx
IE0001Code too complexNot enough buffer memory to return code from the T-Code generator Simplify your SQL statements; then try again
IE0002Illegal escape in LIKEYou cannot specify this as an escape character in a LIKE operation Choose another character as your escape character for the search
IE0004Unhandled internal generator exceptionThere was an unhandled internal error in the machine code generator Please report this to support
IE0005Generated code too largeThe query requires WX2 to generate a block of code which is too large Change the size limit (cg_max_gencode parameter) or contact support
IE002AInvalid EUC double byte characterA Kanji LIKE pattern contains an invalid Kanji character Check the LIKE expression; then try again
IE002BEscape at end of patternA Kanji LIKE pattern has a trailing escape character Check the LIKE expression; then try again
IE0065Invalid date valueOperation produced an invalid date value Contact the help desk
IE0067Invalid timestamp valueOperation produced an invalid timestamp value Contact the help desk
IE0068Invalid time valueOperation produced an invalid time value Contact the help desk
IE006AYear-month interval overflowPrecision of year-month interval value is too small Contact the help desk
IE006BDay-time interval overflowPrecision of day-time interval value is too small Contact the help desk
IE0088 Interval field overflowAn interval value has overflowed the maximum number of digits in its leading field Examine your query and data; then try again
IE0100Arithmetic overflowYou have tried to multiply values to a sum beyond the implementation limit Check your program logic; then try again
IE0101Division by zeroYou have tried to divide by zero Check your program logic; then try again
IE0102Invalid Trim specificationAn attempt was made to TRIM a character string which contained an invalid specification Correct the data or request; then try again
IE0103Insufficient string space for operationAn attempt was made to CAST a character string into another data type but there is insufficient space to complete the operation Correct the data or request; then try again
IE0104Bad regular expressionThe regular expression is incorrectly formatted Correct the data or request; then try again
IE0105Not enough memory to generate codeNot enough memory to generate code Either simplify the query, or free up some memory
IE0106Internal code generator erroran internal error has occurred contact support
IE0107Internal error running generated codean internal error has occurred contact support
IE0108Null value inserted into non-null columnNull value inserted into non-null column add a 'where field is not null' to the query or make target nullable
IE0109Invalid month parameter given to PACKDATE(year, month, day)Only values of 'month' where 1<=month<=12 are allowed when using PACKDATE Correct the data or request; then try again
IE010BToo many plugin functions usedThe SQL query uses too many plugins in one expression Simplify the query
IE010CCardinality errorA row was joined to more than one row where this is not allowed Check query
IE010EGenerate key is invalid in this contextThe generate_key function was used somewhere where it is not allowed Check query
IE010AInvalid day parameter given to PACKDATE(year, month, day)The day of the month must be between 1 and 28,29,30, or 31 (depending on the month and leap year Correct the data or request; then try again
IE010DInvalid parameter given to TIME(H, M, S)The time function must be given valid values 0-23,0-5,0-59 Correct the data or request; then try again
IE0110Internal Error: Index register allocation failedThis is an internal error, contact support. contact support
IE0111Internal Error: Column projection too bigAttempted to project a column into a space that was too small. contact support
IE0112Internal Error: Lookup value is NULLAttempted to use a NULL value as an internal array index. contact support
IE0113Internal Error: Lookup value not foundUnable to find a lookup value in an internal array. contact support
IE0114Internal Error: saved bucket queue is fullThis should never happen, something should drain it. contact support
IE0115Internal Error: Unable to restart access streamThe query attempted to restart an unrestartable operation. contact support
IE0116Internal Error: Varchar data is corruptedAn internal data structure became corrupted. contact support
IE0117Internal Error: Hint record leakageA hint record leaked into an incorrect place. contact support
IE0118The number of buckets in width_bucket() must be at least 1Change the number of buckets so that it is greater than zero Correct the data or request; then try again
IE0119The range in width_bucket must be non-zeroThe min and max values specified in width_bucket() are equal Correct the data or request; then try again
IE011ANo match found for join recordA record did not join to any records in a lookup table Correct the data or request; then try again
IE011BSAME_VALUE found different valuesThe SAME_VALUE aggregate received different non-NULL values, but they should all be the same Correct the data or request; then try again
IE011CONE_VALUE found multiple valuesThe ONE_VALUE aggregate received multiple non-NULL values, but they should be at most one Correct the data or request; then try again
IE011DInternal error, invalid disk block passed to scan.A disk scan was passed a block which does not contain a valid forward chain of records for the appropriate table Contact support
IE011EInvalid binary record length from external sourceAn external program outputed a binary record with an invalid length. Check query and external source (script or table)
IE011FPartial binary record from external sourceAn external program sent a partial binary record and then terminated. Check query and external source (script or table)
IE0120A string contained a partial characterA string in the database contains an incomplete character (e.g. 2 bytes of a utf-32). Check data and contact support
IE0122Incorrect value size for cast from binaryA value was cast from a binary to a type with incompatible length. Check binary casts in the query and correct
IE0123Internal error -- Incorrect lengths for approx count distinct mergeThe server tried to merge two approx distinct lists of different lengths. This should not happenContact support
IE0124Internal error: imported record sent with invalid lengthA record imported using wxloader, wximport or an external table or script has been presented for conversion with an invalid length on it. Contact support.
IE0200Substring errorAn attempt was made to perform a Select Substring which contained an invalid specificationCorrect the data or request; then try again
IE0201Insufficient string memoryAn attempt was made to perform a string operation for which there was insufficient memoryCorrect the data or request; then try again
IE0202Character string too longAn attempt was made to insert a character string that exceeds the defined length of a columnCorrect the data or request; then try again
IE0203Invalid character value for castAn attempt was made to CAST a character string into another data type but it contained characters that could not be convertedCorrect the data or request; then try again
IE0204Numeric overflow during conversionAn attempt was made to CAST a character string into another data type but this resulted in an overflowCorrect the data or request; then try again
IE0205Numeric underflow during conversionAn attempt was made to CAST a character string into another data type but this resulted in an underflowCorrect the data or request; then try again
IE0206minchars parameter to string function too large or negativeThe value specified for the minchars parameter to a string function was not in the range of allowed valuesCorrect the data or request; then try again
IE0207Invalid value specified for base parameter to string functionThe value specified for the base parameter to a string function was not an allowed valueCorrect the data or request; then try again
IE0208Invalid character value for string functionAn attempt was make to use a string function such as strtoint() or strpackints() on an invalid stringCorrect the data or request; then try again
IE0209Invalid 'count' parameter for string functionstrunpackints() or strpackints() was called with an invalid 'count' parameterCorrect the data or request; then try again
IE020AInvalid 'bits' parameter for string functionstrunpackints() or strpackints() was called with an invalid 'bits' parameterCorrect the data or request; then try again
IE020B'bits' * 'count' > 64 in strunpackints()Too many bits specified for strunpackintsCorrect the data or request; then try again
IE020CInvalid separator for string functionstrunpackints() strpackints() strcount() or strchop() was called with a separator that was not a char(1)Correct the data or request; then try again
IE020DZeroth element selected as strpos(,,0) or strchop(,,0,) or strchop(,,,0)Only none zero positive or negative values are allowed for the 'start' and 'end' parameters to strchop() and the 'occurence' parameter to strpos()Correct the data or request; then try again
IE020EAttempt to search for a zero length stringThe second parameter given to strpos() evaluated to a zero length stringCorrect the data or request; then try again
IE020FAttempt to strpackints() a string with too few segmentsThe string given to strpackints() did not contain as many segments as were specified in the count argument.Correct the data or request; then try again
IE0210Attempt to strpackints() a string with too many segmentsThe string given to strpackints() contained more segments than were specified in the count argument.Correct the data or request; then try again
IE0211Product of count and bits params to strpackints greater than 64The result of strpackints is limited to 64 bits, so count*bits must be between 0 and 64.Correct the data or request; then try again
IE0212Result of strunpackints too large for formatThe number to be unpacked by strunpackints was too large to fit in the output format.Correct the data or request; then try again
IE0213String wrong length for functionThe string supplied is of the wrong length for the functionCorrect the data or request; then try again
IE0214Invalid string representationThere was a string with an invalid representation for its character set.Contact the help desk
IE0215Codepoint not in character setThere was a character not available in the destination character set during conversion.Correct the data or request; then try again
IE0216Unknown character setAn unknown character set was specified.Contact the help desk
IE0217Bad number of octets per characterThere was an invalid number of octets per character defining a character set.Contact the help desk
IE0218Bad translation table rangeThere was an invalid translation table defining a character set.Contact the help desk
IE0219Internal error in character conversionAn unknown error occurred while doing a character set conversion.Contact the help desk
IE0250Invalid string for to_numberAn invalid string was supplied to to_number() Check your SQL statement; then try again
IE0251Invalid format stringAn invalid format string was used Check your SQL statement; then try again
IE0252Invalid format stringAn invalid date specifier was used Check your SQL statement; then try again
IE0253Bad value in date stringThe date string contained an bad value Check your SQL statement; then try again
IE0254Internal error - ran out of digits!An internal error occurred Contact the help desk
IE0255Too many significant digits passed to to_numberToo many significant digits were passed to to_number() - use an explicit cast Check your SQL statement; then try again
IE0256Invalid day numberAn invalid day number was specified Check your SQL statement; then try again
IE0257No year was specifiedNo year was specified Check your SQL statement; then try again
IE0258FX specified but wrong number of digitsInvalid input - FX specified but wrong number of digits Check your SQL statement; then try again
IE1xxx
IE1001Internal error: invalid date/time/timestamp format stringThe format string supplied with a date, time or timestamp conversion is invalid and this didn't result in the whole import being rejected. Notify WX2 support.
IE1100Date, time or timestamp field could not be converted: %S conversion cannot take '%T'The field does not match the date, time or timestamp format given. Correct the data file or format string and try again.
IE1101Day of year out of rangeThe 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. Correct the data file or format string and try again.
IE1102Day of month out of rangeThe day part of a date or timestamp field is less than 1 or greater than the number of days in the month. Correct the data file or format string and try again.
IE1103Month out of rangeThe month part of a date or timestamp field is not between 1 and 12. Correct the data file or format string and try again.
IE1104Year out of rangeThe year part of a date or timestamp field is not between 0 and 9999. Correct the data file or format string and try again.
IE1105Hour out of rangeThe hour part of a time or timestamp field is not between 0 and 23, or 1 and 12 for a 12-hour time. Correct the data file or format string and try again.
IE1106Minute out of rangeThe minute part of a time or timestamp field is not between 0 and 59. Correct the data file or format string and try again.
IE1107Second out of rangeThe second part of a time or timestamp field is not between 0 and 59. Correct the data file or format string and try again.
IE1108AM/PM indicator not found where expectedThe 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. Correct the data file or format string and try again.
IE1109Unrecognised month abbreviation "%S"The month part of a date or timestamp field ("MMM") is not a recognised three-letter month abbreviation. Correct the data file or format string and try again.
IE110AFailed to convert fieldThe field in the data file contains characters which are not valid for the conversion being performed. Correct the data file or format string and try again.
IE110BString literal unmatched: expected "%S", got "%T"The format string demands a certain string to appear in the record, and it does not appear at that point. Correct the data file or format string and try again.
IE110CField contains only spacesA field was encountered which contained only whitespace, and this is not allowed by the conversion. Correct the data file or format string and try again.
IE110DInvalid character for integer conversion: '%S' is not a valid base-%T digitA field which needs to be converted to an integer contains characters that cannot be converted. Correct the data file or format string and try again.
IE110EToo many decimal points in decimal conversionA 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). Correct the data file or format string and try again.
IE110FInvalid character '%S' for decimal conversionA field which needs to be converted to a DECIMAL column contains a character which shouldn't be there. Correct the data file or format string and try again.
IE1110Invalid character '%S' for floating point conversionA field which needs to be converted to a REAL or FLOAT column contains a character which shouldn't be there. Correct the data file or format string and try again.
IE1111Date, time or timestamp literal unmatched: expected '%S', got '%T'The date, time or timestamp format string calls for a literal character to appear in the field, which doesn't. Correct the data file or format string and try again.
IE1112Interval field overflow: %S too large for interval of precision %TThe interval is too large for the column. Correct the data file, or redefine the table to allow a larger interval.
IE1113Invalid nibble in BCD number: %SA binary coded decimal field has a nibble which is not 0-9, and not an initial or final C or D. Correct the data file.
IE1114%S junk characters after end of record, possibly caused by unescaped quoteA record had surplus data on the end after the format string consumed what it required. 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 quoteA 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. Correct your data file and try again.
IE1116Hexadecimal string length not evenA hexadecimal string in a record, which represents a sequence of bytes, has an odd number of hexadecimal digits in it. Correct your data file and try again.
IE1117Invalid digit '%S' in hexadecimal stringA hexadecimal string in a record has a character which is not a digit 0-9 or a letter A-F. Correct your data file and try again.
IE1118Invalid WKT polygon - expected pair of opening parentheses %S characters after start of fieldA Well-Known-Text formatted polygon was not in the form POLYGON((x y, x y, ...)) 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 fieldA Well-Known-Text formatted polygon was not in the form POLYGON((x y, x y, ...)) Correct your polygon definition and try again.
IE111AInvalid WKT polygon - text for point #%S is too long, %T characters after start of fieldA Well-Known-Text formatted polygon was not in the form POLYGON((x y, x y, ...)) Correct your polygon definition and try again.
IE111BInvalid WKT polygon - expected pair of closing parentheses %S characters after start of fieldA 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. Correct your polygon definition and try again.
IE111CInvalid WKT polygon - junk after polygon definition, %S characters after start of fieldA Well-Known-Text formatted polygon was in the form POLYGON((x y, x y, ...)), but the field contained junk at the end. Correct your polygon definition and try again.
IE111DJSON syntax error: %SA JSON record does not parse as valid JSON. Correct the JSON and try again.
IE111EJSON value (%S) not compatible with destination type (%T)A JSON value cannot be converted to its destination column, for example, an integer into a DATE column. Correct the JSON or redefine the table and try again.
IE111FJSON value is NULL but column is defined as NOT NULLA JSON record has a NULL value, but the corresponding column does not allow nulls. Alter the JSON, or redefine the column.
IE1120JSON format expression is an array but it should be a value: %SThe JSON format string refers to an object member which is not a value but an array. Correct the JSON or the format string and try again.
IE1121JSON format expression is an object but it should be a value: %SThe JSON format string refers to an object member which is not a value but another object. Correct the JSON or the format string and try again.
IE1122JSON format expression does not exist in object: %SThe JSON format string refers to an object member which does not exist in this JSON object. Correct the JSON or the format string and try again.
IE1123Not a JSON array: %SThe JSON format string uses the subscript operator [] on something other than an array. Correct the JSON or the format string and try again.
IE1124Not a JSON object: %SThe JSON format string refers to a member of something other than a JSON object. For example, "a.b" where a is a value. Correct the JSON or the format string and try again.
IE1125Invalid timestamp: %SA string value could not be put into a timestamp column because the value was not recognised as a timestamp. Correct the value and try again.
IE1126Invalid date: %SA string value could not be put into a date column because the value was not recognised as a date. Correct the value and try again.
IE1127Invalid time: %SA string value could not be put into a time column because the value was not recognised as a time. Correct the value and try again.
IE1128Invalid number: %SA string value could not be put into an integer or decimal column because the value was not recognised as a number. Correct the value and try again.
IE1129JSON record is not an objectAn 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. Correct the JSON and try again.
IE112AJSON expression runtime error: %SAn expression supplied in the JSON format string threw a runtime error, for example because a referenced JSON property did not exist. Consult the error message and correct your format string.
IE112BInvalid field value for column type or incorrect field terminatorA 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. Correct the field and try again.
IE112CAvro parsing error: %SAn Avro block does not parse as valid Avro. Correct the Avro and try again.
IE112DInvalid record count at start of Avro blockAn Avro block has a record count which is less than zero or greater than 2^32-1. Check that the Avro file is correct.
IE112EInvalid data length at start of Avro blockAn Avro block has a byte length which is less than zero or greater than 2^32-1. Check that the Avro file is correct.
IE112FAvro block sync marker incorrectThe 16-byte sync marker at the end of an Avro block is incorrect. Check that the Avro file is correct.
IE1130Out of memory when decompressing zlib blockThe zlib decompression ran out of memory. Try again when the system is less busy.
IE1131Internal error: zlib decompression version mismatchThe zlib version expected by the header file is not the same of the version of zlib in use. This is probably a bug. Contact support.
IE1132Internal error: zlib decompression failureThere was an internal error while doing zlib compression. This is a bug. Contact support.
IE1133Compressed Avro block is incompleteThe 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. Contact support.
IE1134zlib decompression stream errorThe zlib library returned a stream error when decompressing. Contact support.
IE1135zlib decompression data errorThe zlib library returned a data error when decompressing. Contact support.
IE1136Unexpected end of Avro blockAn Avro block ended before it was complete, such as in the middle of a record. Fix the Avro file.
IE1137Avro integer too largeAn Avro-encoded integer was larger than the maximum allowed by the schema. Fix the Avro file.
IE1138Invalid value for Avro booleanAn Avro boolean appears in the file as a byte other than 0 or 1. Fix the Avro file.
IE1139Invalid Avro string lengthAn Avro string has a length which is negative or too large. Fix the Avro file.
IE113AAvro map block too largeAn Avro map object has a block which is too large for this implementation. Use an Avro file which has smaller blocks.
IE113BAvro array block too largeAn Avro array object has a block which is too large for this implementation. Use an Avro file which has smaller blocks.
IE113CAvro map block contains too many elementsAn Avro map object has a block which contains too many elements for this implementation. Use an Avro file which has smaller blocks.
IE113DAvro array block contains too many elementsAn Avro array object has a block which contains too many elements for this implementation. Use an Avro file which has smaller blocks.
IE113EInvalid Avro union indexThe type indicator for an Avro union value is less than zero or greater than the maximum index specified for the union. Fix the Avro file.
IE113FAvro value (%S) not compatible with destination type (%T)An Avro value cannot be converted to its destination column, for example, a boolean into a DATE column. Correct the Avro or redefine the table and try again.
IE1140Invalid Avro enum indexAn Avro enum field has an index which is negative, or greater than or equal to the number of symbols in the enum. Fix the Avro file.
IE1141Invalid decompressed length at start of Snappy-compressed blockThe decompressed length, which appears at the start of a Snappy compressed block, was invalid or too large. Input file is corrupt or there is a bug. Contact support.
IE1142Error when decompressing Snappy block: %SAn error was encountered when decompressing a Snappy-compressed block. Input file is corrupt or there is a bug. Contact support.
IE1143Out of memory when decompressing Snappy blockThere wasn't enough memory to decompress the Snappy block. 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 blockThe code-generated Avro parser was expecting to be told what codec this block was compressed with, and it wasn't. This is a bug. Contact support.
IE1145Unrecognised Avro codecOne of the Avro files you're trying to load is encoded with a codec other than "null", "deflate" or "snappy". Re-encode that Avro file using a supported compression codec.
IE1146Internal error: failed to switch to different Avro codecAfter finishing with one Avro file and starting on another, the call to the Avro parser to switch compression codecs failed. Contact support.
IE1147More than %S conversion errors found by mpid %T for this load. No more conversion errors will be logged.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. Fix your data file.
IO0xxx
IO0001Insufficient memory for external communicationsIrrecoverable RDBMS error Notify Help Desk
IO0007NFS write length mismatchNFS has failed to confirm receipt of the correct number of bytes Consult your Network Administrator
IO0009Invalid WCB version numberYou are trying to import a file which is not in the correct WCB format Check file formats and import parameters; then try again
IO000AImport table - field spec mismatchFields don't match columns on import Check file formats and import parameters; then try again
IO000BInvalid file format for importImport file header corrupt (contains format info) or fields don't match columns on import Check file formats and import parameters; then try again
IO000CChecksum error in import fileImport file is either corrupt or not in WCB format Check file formats and import parameters; then try again
IO000DInvalid record length in import fileImport file corrupt or not in WCB format Check file formats and import parameters; then try again
IO000ENFS read retries exceededToo many repeated NFS read failures Check NFS is working properly
IO000FInvalid hostname for NFS operationHostname cannot be resolved Check file formats and import parameters; then try again
IO0010No create text in WCB and table does not existThe table being imported into needs to be created, but the WCB does not contain a create text field. Create the table manually, and retry the import.
IO0011Conversion from old WCB format disallowedThe 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. 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 disallowedThe 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. 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 %TA record in a CSV import is too long. Check that all the records in the CSV file are quoted correctly; a stray quote usually causes this error.
IO0014No character set specifiedA WCB4 import did not specify the source data character set in its header block. Notify WX2 helpdesk.
IO0015No record format specifiedA WCB4 import did not specify the record format in its header block. Notify WX2 helpdesk.
IO0016Record format unimplementedThe import client is specifying a record format the server does not understand. Upgrade the server to one that supports the record format you're trying to use.
IO0017Unrecognised character setThe character set of the file you are trying to import is not supported by this WX2 version. Translate the file to a character set supported by WX2.
IO0018Record terminator for variable width character set must be a single code unitThe 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). Use a different record terminator, for example, a newline.
IO0019Imported block not whole number of character code unitsThe block of text to be imported contains an incomplete code unit, for example, an odd trailing byte for UTF-16. Notify WX2 helpdesk: the import client should ensure blocks are
IO001AUnsupported data format for loadThe format string supplied does not describe a fixed-width or delimited format. Obtain data file in another format.
IO001BTable does not existThe target table for a load does not exist. Create the table and try again.
IO001CInconsistent quote characters in format stringThe format string contains two or more elements with different quote characters. This isn't allowed. Obtain data file in another format.
IO001DUnknown record type specified for loadThe client specified a record type which was not automatic (0), terminated (1), quoted terminated (2) or fixed-width (3). Specify a recognised record type.
IO001ENo record width specified for fixed-width record typeThe client specified that the records were to be treated as fixed-length records but did not supply a record length. Specify a record length.
IO001FHeader field extends outside header block - probably a client bugA 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. Contact WX2 support.
IO0020JSON record too long, object %S, starting at file offset %TA JSON object which was intended to be converted into one or more records exceeds the maximum length. Check your JSON is correct, or set load_rec_max to a higher value.
IO0021Avro block too long, object %S, starting at file offset %TAn Avro data block exceeds the maximum length for this implementation. Check your Avro file is correct, or set load_rec_max to a higher value.
IO2xxx
IO2003Query aborted
LC0xxx
LC0001Unlicensed systemInsufficient software licences for the current software configuration. Add licence keys, reconfigure the system or contact support.
LC0002Licensed concurrent session limit reachedInsufficient software licences to open another concurrent session Add licence keys, close some sessions or try again later.
LC0003Licensed data storage limit reachedInsufficient software licences to store any more data. Add licence keys, delete data, reclaim disk space or contact support.
LC0101Licensed node limit exceededThe system has more nodes than the valid licences allow Add licences or remove nodes.
LC0102Ramstore limit exceededThe system has more ramstores than the valid licences allow Add licences or remove ramstores.
LC0103Diskstore limit exceededThe system has more Diskstores than the valid licences allow Add licences or remove disk resources.
LC0104Interpreter limit exceededThe system has more interpreters than the valid licences allow Add licences or remove interpreters.
LC0105Compiler limit exceededThe system has more compilers than the valid licences allow Add licences or remove compilers.
LC0106IO process limit exceededThe system has more IO Processes (daemons) than the valid licences allow Add licences or remove daemons.
LC0107Total disk size limit exceededThe system has more disk storage than the valid licences allow Add licences or remove disk storage.
LC0108Ramstore memory size limit exceededThe system has more ramstore memory than the valid licences allow Add licences or remove/shrink ramstore memory.
LC0109System memory size limit exceededThe system has more ram than the valid licences allow Add licences or remove ram.
LC010AConcurrent session limit exceededThe system has more concurrent sessions than the valid licences allow Add licences or close sessions.
LC010BInternal licensing failureThis internal error should be impossible. Contact support.
LC010CData storage limit exceededThe system is storing more data than the valid licences allow Add licences or remove data.
LC010ENew system is unlicensedAvailable licences will not allow a new system to be created Check licence keys and/or contact support.
LC010FUnlicensed data storage RAM usedRam storage nodes (nodes with an RS on) have more RAM than licences allow Add licences or remove RAM (physically or with [system] memsize=).
LC0110Usable disk size limit exceededThe system has more usable disk storage than the valid licences allow Add licences or remove disk storage.
LC0111Use of disk compression requires additional licenceThe system has disk compression enabled and no valid licence allows this Add licences or turn off.
LC0112Use of external tables requires additional licenceThe system has external tables enabled and no valid licence allows this Add licences or turn off.
LC0113Use of external scripts requires additional licenceThe system has external scripts enabled and no valid licence allows this Add licences or turn off.
LC0140No base licence foundThe system needs a valid base licence code to allow it to work Add a base licence key or contact support.
LC0141Multiple base licencesMultiple base licences codes present in the system. remove all but one base licence.
LC0142No valid licence codes foundThe system cannot find any valid licence codes. Add valid licence codes.
LF0xxx
LF0001Empty attribute name in format stringAn empty attribute name has been given in a format specifier Give the attribute a name longer than zero characters
LF0002Comma or closing brace expected after attributeAn unexpected character followed a name=value attribute setting Correct your format string and try again
LF0003Unclosed brace in format stringAn opening brace in the format string has no corresponding closing brace Correct your format string and try again
LF0004Format string attribute type mismatchThe format string attempts to set a built-in attribute to something invalid, for example, an integer attribute is set to an alphabetic string Correct your format string and try again
LF0005Unclosed square bracket in format stringA %[ conversion in a format string does not have a corresponding ] Correct your format string and try again
LF0006Illegal byte sequence in format stringThe format string contains an invalid UTF-8 character Correct your format string and try again
LF0007Unrecognised format specifierThe format string contains an unrecognised format sequence Correct your format string and try again
LF0008Inconsistent column numbers in format stringThe format string has column numbers specified for some but not all of the conversions Specify column numbers for none or all of the non-ignored conversion specifiers
LF0009Column number repeated in format stringThe format string contains two or more conversion specifiers with the same column number Correct your format string and try again
LF000AInvalid date, time or timestamp formatThe format string contains a date, time or timestamp format string which is invalid Correct the date, time or timestamp format string and try again
LF000BInvalid escape sequence in format stringThe format string contains an illegal escape sequence, for example \x followed by a non-hexadecimal digit Correct your format string and try again
LF000CFormat string attribute value out of rangeThe format string attempts to set an attribute outside the allowable range, e.g. minyear is not between 0 and 9900 Correct your format string and try again
LF000DInvalid column number or too many format elements for tableThe format string contains a column number that is too large, or has more non-ignored conversions than there are column numbers. Correct your format string and try again.
LF000EFormat string element can't be converted to columnOne of the format elements in the format string is not compatible with its target column, for example, a %d conversion with a TIME field. Correct your format string and try again.
LF000FUnterminated quote in format stringThere is a quoted string in the format string that doesn't have a closing quote. Correct your format string and try again.
LF0010Format string literal too largeYour format string contains a literal which is longer than 32000 characters. Correct the format string, or use a less perverse file format.
LF0011Too many conversions in format stringYour format string contains too many conversion directives. Remove some conversion directives from the format string.
LF0012Too many elements in format stringYour format string contains too many conversion elements. Remove some elements from the format string.
LF0013Format string attribute token too largeAn attribute name or value in a conversion directive in your format string is too large. Use shorter attribute names or values.
LF0014Too much memory used by format string attributesYou have too many large attributes in a conversion directive in your format string. Use fewer or shorter attribute strings in your format string.
LF0015Not enough format elements in format stringThere is at least one column in the target table which does not have a format string element associated with it. Correct your format string and try again.
LF0016Cannot mix binary and non-binary conversion directivesBinary conversion directives (those with the & flag) and non-binary conversion directives cannot be mixed in the same format string. Correct your format string and try again.
LF0017Conversion directive must be binaryYou have supplied a conversion directive which only has meaning as a binary conversion, without the & flag. Give that conversion directive the & flag.
LF0018Field width required for conversion directiveYou have supplied a conversion directive with no field width, and a field width is mandatory for this conversion directive. Correct your format string and try again.
LF0019Expected precision value after dot in conversion specifierYou supplied a conversion directive with a dot in it but no number following it for the precision. Correct your format string and try again.
LF001ANot enough memory to parse JSON format stringThere is not enough space available to parse your JSON format string. Make your JSON format string less complex.
LF001BFailed to parse JSON format string: ended unexpectedlyThe end of your JSON format string came in an unexpected place, for example, immediately after a dot, or after an opening square bracket. Correct your format string and try again.
LF001CFailed to parse JSON format string: bad dimension specifierYour JSON format string has a badly-formed dimension specifier. "Dimension specifier" refers to the pair of square brackets after an array name. Correct your format string and try again.
LF001DFailed to parse JSON format string: expected word or dimensionWhere the JSON format string parser expected a word (the name of a member) or a dimension specifier ("[]"), it found something else. Correct your format string and try again.
LF001EFailed to parse JSON format string: expected attribute or commaWhere 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. Correct your format string and try again.
LF001FFailed to parse JSON format string: invalid attribute valueA 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. Correct your format string and try again.
LF0020Failed to parse JSON format string: each column definition must start with a nameOne 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. Correct your format string and try again.
LF0021Failed to parse JSON format string: %SYour JSON format string was invalid. Consult the error message and fix your format string.
LF0022Bad Avro schema: %SThe schema of this Avro file is not valid, or it describes a data structure we can't deal with. Fix your Avro file.
LF0023Internal error: automatically-generated JSON format string incorrectNo 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. Contact helpdesk.
LF0024Internal error: automatically-generated Avro format string incorrectThe server internally generated a string encapsulating the Avro codec, sync marker and schema, but this string is now invalid. This is a bug. Contact helpdesk.
LF0025Avro field name not foundThe Avro format string uses a name which does not correspond to any field defined in the Avro schema. Correct the format string and try again.
LF0026Avro field name invalidThe Avro format string uses an invalid name. Correct the format string and try again.
LF0027Invalid Avro format string: %SThe Avro format string is not valid. Correct the format string and try again.
LF2xxx
LF2001Out of memoryNot enough memory to process format string Use a shorter format string
MP0xxx
MP0001Memory allocation failure reading message statsMemory allocation failure trying to gather message passing statistics Contact support
MP0002Internal error retrieving statisticsThere was an internal error retrieving message passing statistics Contact support
NF0xxx
NF0001Not owner
NF0002No such file or directory
NF0005Physical I/O error !
NF0006No such file or address
NF000DPermission denied
NF0011File already exists
NF0013Bad call to device
NF0014Directory op on non-dir
NF0015Non-dir op on directory
NF001BFile too big
NF001CNo space left on device
NF001ERead only file system
NF003FName too long
NF0042Internal
NF0045Internal
NF0046Internal
NF0047Too many levels of remote
NF0063Internal
NF0064The host cannot be found or does not support NFS
NF0065The name of the host doesn't make sense"
NF0066Too many files are open
NF0067Invalid handle was passed to a NF_ procedure
NF0201Host not found
NF0202Try again - host not found or SERVERFAIL
NF0203Host not found - FORMERR, REFUSED, NOTIMP.
NF0204Host not found - Valid name, no data.
OD0xxx
OD0001Record exceeds server record length limitThe ODBC driver has fetched a record from the server whose length exceeds the maximum length of a record the server is supposed to return. Notify Kognitio support.
OD0002Socket tunnelling denied by serverThe server is not capable of socket tunnelling, or it refused to allow it. Upgrade or reconfigure the server.
OD0003Failed to set up socket tunnelling: %SThe client requested a socket tunnelling session be set up over this connection, but this did not succeed. Consult the error message for more information.
OD0004No socket tunnelling session activeThe application tried to get or set a tucket-specific attribute which requires a tucket session already active. The application must start a tucket session by setting the appropriate connection attribute.
OD0005GSS authentication requested but failed to authenticate: %SAuthentication using GSS-API was requested but this did not succeed for reasons included in the error message. Consult the error message.
OD0006GSS authentication requested but failed to load libgssapi: %SAuthentication using GSS-API was requested but we failed to load the libgssapi library. Consult the error message.
OD0007GSS session aborted: %SA session using GSS-API encountered a communication error, such as a disconnection, or an authentication problem such as an expired ticket. Reconnect and try again.
OD0008Varchar data in result block is invalidThe 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. Notify Kognitio support.
PI0xxx
PI0001Plugin has no WXPI_Initialise() functionserver internal error Notify Help Desk
PI0002Plugin WXPI_Initialise() function failureserver internal error Notify Help Desk
PI0003Plugin has no WXPI_Sym_Info() functionserver internal error Notify Help Desk
PI0004Plugin WXPI_Sym_Info() function failureserver internal error Notify Help Desk
PI0005Plugin function not yet implementedserver internal error Notify Help Desk
PI0006Plugin related server internal errorserver internal error Notify Help Desk
PI0007Plugin initialisation ran out of memoryserver internal error Notify Help Desk
PI0008Error during plugin unloadserver internal error Notify Help Desk
PI0009Attempt to use plugin after it has been unloadedAttempt to use plugin after it has been unloaded Wait for plugin to complete unloading, reload plugin, and try again
PI000AFailed to start plugin runnerA server node was unable to fork/exec a plugin runner Notify Help Desk
PI000BFailed to start plugin runner - pipe creation failedA server node was unable to fork/exec a plugin runner because it couldn't create comms pipes Notify Help Desk
PI000CFailed to start plugin runner - thread creation failedA server node was unable to start a plugin runner because it couldn't create a comms thread Notify Help Desk
PI000DBad first arg type for plugin functionThe first arg to a plugin function is not of type PI_Data_Utility_Ptr Notify Help Desk
PI000ENo plugin was found with the right nameWe searched for a plugin function with the given name but none was found Correct the data or request; then try again
PI000FNo plugin was found with compatible argument typesWe searched for plugin functions with the given name. Some were found, but none would take arguments compatible to those given Correct the data or request; then try again
PI0010The plugin file could not be foundThe plugin file on the CP could not be found or could not be opened 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 namePlugin function names must be composed of the letters a-z or A-Z and are case insensitive Correct the request; then try again
PI0012Plugin not foundserver internal error Notify Help Desk
PI0014Failed to make plugin filespaceserver internal error Notify Help Desk
PI0015plugin symbol lookup failedThe plugin does not contain a required symbol Contact the plugin author for support
PI0016Incompatible pluginThe plugin does not support any API version the server does Contact the plugin author for support
PI0017Plugin refused to unloadThe plugin returned an error during the close routine contact the plugin author for support
PI0018Plugin is about to be unloadedThe plugin is about to be unloaded, and cannot be used Reload the plugin
PI0019Duplicate plugin numberAttempted to load multiple plugins with the same identity number You probably loaded the same plugin twice. If not, contact the plugin vendor(s) for support
PI0020Cannot do this while the plugin is in useA transaction is using the plugin so you cannot perform this operation on it Wait until the plugin is idle then try again
PI0021The plugin is not loadedAn attempt was made to operate on a module which is not loaded Contact support if you were not unloading a plugin
PI0022Invalid plugin resource stringThe resource string you gave for the plugin was not valid Check the resource string
PI0023Multiple plugins provide a functiontwo plugins are attempting to provide a function with the same name You can only load one of these at a time. Contact the plugin author(s) if this is a problem
PI0024Module returned invalid function mapThe module has a bug in it and gave invalid function info to the server Contact the plugin author for support
PI0025Plugin function returned bad interval typeThe module has a bug in it and gave invalid function info to the server Contact the plugin author for support
PI0026Module returned invalid external data provider mapThe module has a bug in it and gave invalid external data provider info to the server Contact the plugin author for support
PI0027Multiple plugins provide the same external data provider nametwo plugins are attempting to define the same external data provider name 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 foundThe requested external data provider was not found in the server Check the external data provider's name against the available providers
PI0181Plugin failureThe plugin is in safe mode and has crashed contact plugin vendor to resolve the problem or debug
PI0182Undefined plugin errorA plugin returned an undefined error code Contact the plugin vendor for support
PI0183Module %S: %TThe plugin module returned an error string Contact the plugin vendor for support
PI0184The plugin returned a string of the wrong lengthThe plugin module returned a string of the wrong length Contact the plugin vendor for support
PI0185Abiguous type for string argument to plugin functionThere are multiple possible types to convert the string argument into. Use an explicit cast from string to the correct type
PM0xxx
PM0001Internal PMA errorAn internal error occurred in the Persistent Memory Handler Ccontact support.
PM0002Failed to create PM fileFailed to create a shared memory object Check system configuration, available memory and total memory size.
PM0003Failed to size PM fileFailed to set the correct size of a shared memory object Check system configuration, available memory and total memory size.
PM0004PMA map failureFailed to map memory from PMA file PMA file may be corrupt or this may be an internal error.
PM0005Invalid PMA block numberInternal error because a block number was not valid Contact support.
PM0006Failed to open PMA blockUnable to shm_open a PMA block Check presence of files and/or rebuild memory images
PM0007PMA out of memoryA persistent memory area is full. Check PMA occupancy and unload appropriate images.
PV0xxx
PV0000No roomInternal RDBMS error Notify Help Desk
PV0001Not foundInternal RDBMS error Notify Help Desk
PV0002Warn not setupInternal RDBMS error Notify Help Desk
PV0003Atempt to set two monitors for a parameterInternal RDBMS error Notify Help Desk
PV0004parameter is readonlythis parameter cannot be altered do not try to change this parameter directly
PV0005parameter too largeserver internal error Notify Help Desk
PV0006user parameter overrideserver internal error Notify Help Desk
PV0007session parameter overrideserver internal error Notify Help Desk
PV0008Using global parameter defaultserver internal error Notify Help Desk
PV0009Internal server error - bad args passed to pvserverserver internal error Notify Help Desk
PV000AParameter name invalidThe name of the parameter contained illegal characters Use a different parameter name
PV000BAttempt to drop a permanent parameterThis parameter cannot be dropped do not try to drop this parameter
QQ0xxx
QQ0001Query queue too longThe administrator has limited the number of queries qhich can be queued and there are currently too many. Contact your administrator for help
QQ2xxx
QQ2003Query aborted
RS0xxx
RS0001Insufficient RAM for table / viewNot enough memory available to complete this operation Try to Drop [Table] | [View] Image to release memory
RS0002RAM image not foundInternal RDBMS error Notify Help Desk
RS0003Index not foundInternal RDBMS error Notify Help Desk
RS0004Hash warningInternal RDBMS error Notify Help Desk
RS0005RAM image already existsInternal RDBMS error Notify Help Desk
RS0006Not enough memoryNot enough memory available for the temporary tables required to hold intermediate results Simplify your SQL
RS0007No more records found in accessInvalid SQL Check your SQL statements; then try again
RS0008Insufficient RAM for queryInternal RDBMS error Notify Help Desk
RS0009Invalid deleteDELETE is not permitted whilst this row is locked Try again when the row is unlocked
RS000ARecord too largeThis record is too large for the available Query Manager buffer Split your record into parts
RS000BInsufficient RAM to create indexNot enough memory available for the Memory handler process to build key indexes Simplify your SQL statements or try to Drop Table Image to release space or wait to try again later
RS000CLogged operation on temporary tableInternal error -- operation makes no sense on a temporary table Contact support.
RS000EInternal record too largeA ram record longer than 32Kbytes was created Contact support/modify your query.
RS000FInsufficient RAM for QueryNot enough memory available to complete this operation Try to Drop [Table] | [View] Image to release memory
RS0010Insufficient RAM for operationNot enough memory available to complete this operation Try to Drop [Table] | [View] Image to release memory
RS0011Internal failure to restart access componentInternal error, contact support contact support
RS0012Internal data bucket corruptionInternal error, contact support contact support
RS0013Internal data corruptionInternal error, contact support contact support
RS0014Bad record length for internal record insertInternal error, contact support contact support
RS0015Incorrect internal record scan lengthInternal error, contact support contact support
RS0016Temporary resource allocation failureAn internal resource allocator failed to allocate resources 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 fetchInternal error, contact support contact support
RS0018Randomly generated error for testingThis should never come out unless testing parameters are set Check settings or contact support
RS0019Internal consistency check errorThe query generated an inconsistent set of data due to a server bug Contact support
RS001AReplicated operation missing recordAn internal error caused when a record in a replicated table is missing from some ramstores Contact support
RS001BInternal disk address map not foundInternal RDBMS error Notify Help Desk
RS001CUnable to soak stream dataInternal error should never be seen externally. Ramstore failed to soak an import block because operation ended early. Contact support
RS0020broken error code should never come outYou should not see this. It was an error mistakenly defined and given text in older SW Contact support
RS0021Connector IPC buffer overflowThe external connector sent too many messages between instances This is a problem with the connector, contact the developer for support
RS0022Invalid Connector IPC destinationThe external connector sent a message to an invalid destination This is a problem with the connector, contact the developer for support
RS0023Error writing to external script pipeData could not be properly sent to the external script. It may have exited without consuming all data. Check the server logs and debug the script.
RS0024Error launching the external scriptThe external script could not be launched. Check the script and interpreter exist and that the temp filesystem is not full.
RS0025The external script returned an errorThe external script returned with a non-zero exit code or exited with a signal. Check the logs and debug the script.
RS0026Could not initialise zlib state to decompress blockThe 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. Check zlib is properly installed.
RS0027Decompressed WCB block longer than expectedA compressed WCB block expands to larger than the WCB block says it does. This is probably caused by a corrupt WCB file. Use another WCB file, or notify the help desk if the problem persists.
RS0028zlib decompression failedThe call to zlib's inflate() function failed, possibly because the data in a compressed WCB block was not a valid zlib block. Notify help desk.
RS0029External scripting feature is not enabled in the configuration fileExternal scripts need to be activated in the config file with the [boot options] external_scripts setting. Activate external scripts.
RS002Azlib compression failedThe call to zlib's deflate() function failed, possibly because the data in a compressed WCB block was not a valid zlib block. Notify help desk.
RS002BCompressed block too largeA 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. Notify help desk.
RS002CCannot recover as partially completed operation left memory in an inconsistent stateA previous instance of the server was in the middle of an atomic operation on the memory image when it was stopped.Rebuild images.
RS002DCannot recover due to previous failure during recoveryA previous instance of the server failed while recovering memory images rendering them unusable. Rebuild images.
RS002EFailed to create a core PMA for data. Check SMD's output log for infoWe failed to run the wxpmatool command to create a persistent memory area for data. Check logs, available memory space, etc.
RS002FUnable to recover a PMA because the blockmap is badThe persistent memory image for the server is corrupted. Rebuild images.
RS0030Unable to recover a PMA because the table data is badThe persistent memory image for the server is corrupted. Rebuild images.
RS0031Cannot recover images as one or more slices are incompleteThe image set was never created fully and cannot be recovered. Rebuild images.
RS0032Cannot recover images as the data format version is incorrectThe image set must be rebuilt to run with this version of the software. Rebuild images.
RS0033No partition available for record insertionInternal error -- the server could not find a partition in which to insert the record. Contact support.
RS0034Image partition limit reachedRecord insertion would cause the image to have more than the maximum allowed number of partitions. Reconfigure to allow more partitions or change the image definition to create fewer.
RS0035Partition key too longAn inserted record uses a partition key which is too large. Change the image definition to create shorter keys.
RS0036Cannot recover images as the server was in the process of rebuilding the image setThe image set must be rebuilt to run with this version of the software. Rebuild images.
RS0037Internal record reassignment to an invalid locationThis is an internal error caused by an attempt to update a record's disk location with an invalid value. Contact support.
RS0038Internal record corrupted with invalid disk numberThis is an internal error caused by record with an invalid disk number in the header. Contact support.
RS0039Internal record reassignment source locations do not matchThis 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. Contact support.
RS003AUnable to fetch data from external data sourceThe fetch method of the external data source returned an error, but did not specify any details. Check the server debug log, or contact the writer of the plugin if applicable.
RS003BAccess message too longA query plan step generated a message longer than the rs_max_msglen setting allows. Change query or adjust the rs_max_msglen parameter appropriately.
RS003CCorrupted fragmented message during deliveryAn internal error corrupted a fragmented message preventing reassembly. Contact support.
RS003DInsufficient memory to assemble fragmented messageAn large message was sent and the receiver was not able to allocate enough memory to hold it. 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 longan external script performed an IPC operation which sent a message bigger than the limit allowed. Debug the script or review the server's memory block size.
RS003FError occurred while communicating with external processAn error occurred while comminicating with the XSI library on an external script process. Debug the script, check serverdbg then contact support.
RS0040Invalid target for XSI messageAn external script generated a message to an invalid target. Debug the script.
RS0041XSI event sequence errorAn event occurred out of the proper sequence during execution of an XSI script. Debug the script, check for exits during sync, race conditions or other calls that are made at the wrong time.
RS0042Invalid input source numberAn external program requested data for an input source that isn't present. Debug the script, check for calls to get information about input sources.
RS0043Invalid debug message sent from external processAn external program sent a corrupted debug information message into the server. Debug the script, look for memory overwrites and other data corruption bugs.
RS0044Invalid external script state fileThe state file given by the external script was invalid or could not be opened preserve script directory on exit, check state file location, permissions, etc.
RS0045Internal ramstore cardinality check errorA subquery produced more than one row where it should only produce one. But this error should be changed internally before you see itCheck query for unique constraint violations and/or contact support.
RS0065Invalid date valueOperation produced an invalid date value Contact the help desk
RS0067Invalid timestamp valueOperation produced an invalid timestamp value Contact the help desk
RS0068Invalid time valueOperation produced an invalid time value Contact the help desk
RS006AYear-month interval overflowPrecision of year-month interval value is too small Contact the help desk
RS006BDay-time interval overflowPrecision of day-time interval value is too small Contact the help desk
RS0088 Interval field overflowAn interval value has overflowed the maximum number of digits in its leading field Examine your query and data; then try again
RS0100Arithmetic overflowYou have tried to multiply values to a sum beyond the implementation limit Check your program logic; then try again
RS0101Division by zeroYou have tried to divide by zero Check your program logic; then try again
RS0102Invalid Trim specificationAn attempt was made to TRIM a character string which contained an invalid specification Correct the data or request; then try again
RS0103Insufficient string space for operationAn attempt was made to CAST a character string into another data type but there is insufficient space to complete the operation Correct the data or request; then try again
RS0104Bad regular expressionThe regular expression is incorrectly formatted Correct the data or request; then try again
RS0105Not enough memory to generate codeNot enough memory to generate code Either simplify the query, or free up some memory
RS0106Internal code generator erroran internal error has occurred contact support
RS0107Internal error running generated codean internal error has occurred contact support
RS0108Null value inserted into non-null columnNull value inserted into non-null column add a 'where field is not null' to the query or make target nullable
RS0109Invalid month parameter given to PACKDATE(year, month, day)Only values of 'month' where 1<=month<=12 are allowed when using PACKDATE Correct the data or request; then try again
RS010BToo many plugin functions usedThe SQL query uses too many plugins in one expression Simplify the query
RS010CCardinality errorA row was joined to more than one row where this is not allowed Check query
RS010EGenerate key is invalid in this contextThe generate_key function was used somewhere where it is not allowed Check query
RS010AInvalid day parameter given to PACKDATE(year, month, day)The day of the month must be between 1 and 28,29,30, or 31 (depending on the month and leap year Correct the data or request; then try again
RS010DInvalid parameter given to TIME(H, M, S)The time function must be given valid values 0-23,0-5,0-59 Correct the data or request; then try again
RS0110Internal Error: Index register allocation failedThis is an internal error, contact support. contact support
RS0111Internal Error: Column projection too bigAttempted to project a column into a space that was too small. contact support
RS0112Internal Error: Lookup value is NULLAttempted to use a NULL value as an internal array index. contact support
RS0113Internal Error: Lookup value not foundUnable to find a lookup value in an internal array. contact support
RS0114Internal Error: saved bucket queue is fullThis should never happen, something should drain it. contact support
RS0115Internal Error: Unable to restart access streamThe query attempted to restart an unrestartable operation. contact support
RS0116Internal Error: Varchar data is corruptedAn internal data structure became corrupted. contact support
RS0117Internal Error: Hint record leakageA hint record leaked into an incorrect place. contact support
RS0118The number of buckets in width_bucket() must be at least 1Change the number of buckets so that it is greater than zero Correct the data or request; then try again
RS0119The range in width_bucket must be non-zeroThe min and max values specified in width_bucket() are equal Correct the data or request; then try again
RS011ANo match found for join recordA record did not join to any records in a lookup table Correct the data or request; then try again
RS011BSAME_VALUE found different valuesThe SAME_VALUE aggregate received different non-NULL values, but they should all be the same Correct the data or request; then try again
RS011CONE_VALUE found multiple valuesThe ONE_VALUE aggregate received multiple non-NULL values, but they should be at most one Correct the data or request; then try again
RS011DInternal error, invalid disk block passed to scan.A disk scan was passed a block which does not contain a valid forward chain of records for the appropriate table Contact support
RS011EInvalid binary record length from external sourceAn external program outputed a binary record with an invalid length. Check query and external source (script or table)
RS011FPartial binary record from external sourceAn external program sent a partial binary record and then terminated. Check query and external source (script or table)
RS0120A string contained a partial characterA string in the database contains an incomplete character (e.g. 2 bytes of a utf-32). Check data and contact support
RS0122Incorrect value size for cast from binaryA value was cast from a binary to a type with incompatible length. Check binary casts in the query and correct
RS0123Internal error -- Incorrect lengths for approx count distinct mergeThe server tried to merge two approx distinct lists of different lengths. This should not happenContact support
RS0124Internal error: imported record sent with invalid lengthA record imported using wxloader, wximport or an external table or script has been presented for conversion with an invalid length on it. Contact support.
RS0181Plugin failureThe plugin is in safe mode and has crashed contact plugin vendor to resolve the problem or debug
RS0182Undefined plugin errorA plugin returned an undefined error code Contact the plugin vendor for support
RS0183Module %S: %TThe plugin module returned an error string Contact the plugin vendor for support
RS0184The plugin returned a string of the wrong lengthThe plugin module returned a string of the wrong length Contact the plugin vendor for support
RS0185Abiguous type for string argument to plugin functionThere are multiple possible types to convert the string argument into. Use an explicit cast from string to the correct type
RS0200Substring errorAn attempt was made to perform a Select Substring which contained an invalid specificationCorrect the data or request; then try again
RS0201Insufficient string memoryAn attempt was made to perform a string operation for which there was insufficient memoryCorrect the data or request; then try again
RS0202Character string too longAn attempt was made to insert a character string that exceeds the defined length of a columnCorrect the data or request; then try again
RS0203Invalid character value for castAn attempt was made to CAST a character string into another data type but it contained characters that could not be convertedCorrect the data or request; then try again
RS0204Numeric overflow during conversionAn attempt was made to CAST a character string into another data type but this resulted in an overflowCorrect the data or request; then try again
RS0205Numeric underflow during conversionAn attempt was made to CAST a character string into another data type but this resulted in an underflowCorrect the data or request; then try again
RS0206minchars parameter to string function too large or negativeThe value specified for the minchars parameter to a string function was not in the range of allowed valuesCorrect the data or request; then try again
RS0207Invalid value specified for base parameter to string functionThe value specified for the base parameter to a string function was not an allowed valueCorrect the data or request; then try again
RS0208Invalid character value for string functionAn attempt was make to use a string function such as strtoint() or strpackints() on an invalid stringCorrect the data or request; then try again
RS0209Invalid 'count' parameter for string functionstrunpackints() or strpackints() was called with an invalid 'count' parameterCorrect the data or request; then try again
RS020AInvalid 'bits' parameter for string functionstrunpackints() or strpackints() was called with an invalid 'bits' parameterCorrect the data or request; then try again
RS020B'bits' * 'count' > 64 in strunpackints()Too many bits specified for strunpackintsCorrect the data or request; then try again
RS020CInvalid separator for string functionstrunpackints() strpackints() strcount() or strchop() was called with a separator that was not a char(1)Correct the data or request; then try again
RS020DZeroth element selected as strpos(,,0) or strchop(,,0,) or strchop(,,,0)Only none zero positive or negative values are allowed for the 'start' and 'end' parameters to strchop() and the 'occurence' parameter to strpos()Correct the data or request; then try again
RS020EAttempt to search for a zero length stringThe second parameter given to strpos() evaluated to a zero length stringCorrect the data or request; then try again
RS020FAttempt to strpackints() a string with too few segmentsThe string given to strpackints() did not contain as many segments as were specified in the count argument.Correct the data or request; then try again
RS0210Attempt to strpackints() a string with too many segmentsThe string given to strpackints() contained more segments than were specified in the count argument.Correct the data or request; then try again
RS0211Product of count and bits params to strpackints greater than 64The result of strpackints is limited to 64 bits, so count*bits must be between 0 and 64.Correct the data or request; then try again
RS0212Result of strunpackints too large for formatThe number to be unpacked by strunpackints was too large to fit in the output format.Correct the data or request; then try again
RS0213String wrong length for functionThe string supplied is of the wrong length for the functionCorrect the data or request; then try again
RS0214Invalid string representationThere was a string with an invalid representation for its character set.Contact the help desk
RS0215Codepoint not in character setThere was a character not available in the destination character set during conversion.Correct the data or request; then try again
RS0216Unknown character setAn unknown character set was specified.Contact the help desk
RS0217Bad number of octets per characterThere was an invalid number of octets per character defining a character set.Contact the help desk
RS0218Bad translation table rangeThere was an invalid translation table defining a character set.Contact the help desk
RS0219Internal error in character conversionAn unknown error occurred while doing a character set conversion.Contact the help desk
RS0250Invalid string for to_numberAn invalid string was supplied to to_number() Check your SQL statement; then try again
RS0251Invalid format stringAn invalid format string was used Check your SQL statement; then try again
RS0252Invalid format stringAn invalid date specifier was used Check your SQL statement; then try again
RS0253Bad value in date stringThe date string contained an bad value Check your SQL statement; then try again
RS0254Internal error - ran out of digits!An internal error occurred Contact the help desk
RS0255Too many significant digits passed to to_numberToo many significant digits were passed to to_number() - use an explicit cast Check your SQL statement; then try again
RS0256Invalid day numberAn invalid day number was specified Check your SQL statement; then try again
RS0257No year was specifiedNo year was specified Check your SQL statement; then try again
RS0258FX specified but wrong number of digitsInvalid input - FX specified but wrong number of digits Check your SQL statement; then try again
RS0901Access DeferredThis is an internal error, you should never see this. Contact support.
RS0902Space warning -- rs low on ramThis is an internal error, you should never see this. Contact support.
RS2xxx
RS2003Query aborted
SH0xxx
SH0001No compilers freeNo compiler processes available Try again later
SS0xxx
SS0001Insufficient resources available for taskThere were insufficient resources available to create the required number of contexts for the script Examine concurrent resource usage, machine resource levels and concurrency controls
SS0002Script operation not foundInternal error trying to look up a script in the script scheduler service Contact support
TH0xxx
TH0001No query managers freeNo Query Manager processes available Try again later
TS0xxx
TS0101Local time occurs more than onceAttempted to set a local time which has more than one possible GMT time use the tadj parameter to set time or set to a time which only occurrs once
TS0102Timeserver readonlyAttempted to change the time but the clock is read only set tfix parameter to 0 to make the clock read-write
TS0103Unable to set local timeThe local time could not be set. Perhaps the time is in a hole or repeated block caused by a DST change? Check query