Thursday, August 09, 2012

Teradata DBC Errorcodes and Description

ErrorCode=======ErrorText
0      =======**** ErrMsgs file as of 07:11:26 04/05/2004.
2507=======Out of spool space on disk.
2566=======Processor nnnn failed to respond
2585=======An I/O error on an MLOAD table caused a crash.
2587=======Segment overflow -- FastExport request is too complex to process.
2589=======Request block is not found.
2606=======Bad argument involving %TVMID.%FLDID for LOG function.
2608=======Bad argument involving %TVMID.%FLDID for LN function
2610=======Internal error:  field maintenance error
2627=======Internal error:  invalid operand for UpCaseOp
2629=======Internal error:  bad data type for operation.
2648=======Internal error:  could not find spool header.
2650=======Numeric processor operand error.
2669=======Outrow reference to source is illegal case (in MoveRow).
2671=======Unable to find a source constant (in MoveRow).
2688=======Numeric Processor Operand Error.
2690=======Zero table length in Unload.
2709=======SSSWAIT has timed out.
2711=======Inconsistent AMP/PE Vproc count.
2728=======Aborted due to a non-valid reference index on %DBID.%TVMID.
2730=======Warning: RI is not valid on one or more AMPs.
2732=======Warning: Skipping parent key validation in level 3 checking.
2749=======Primary and fallback USI counts do not match
2751=======Data row out of order.
2770=======Data row id referenced by NUSI is on wrong AMP.
2772=======NUSI row indexes non existent data row.
2791=======Primary and fallback data row checksums do not match.
2793=======MLoad MARK DUPLICATE INSERT (dup row)
2810=======Internal error:  permanent journal error found.
2812=======Internal error:  invalid record found on transient journal.
2814=======Data size exceeds the maximum specified.
2831=======No row was found for the event in the Recovery Control Catalog.
2833=======Row already exists with different content.
2852=======Inconsistent check point records found on Restored journal.
2854=======Specified checkpoint row does not exist in Journal table %TVMID.
2871=======Missing table header for DBC.DBCInfoTbl, updates bypassed.
2873=======Pending operation on DBC.DBCInfoTbl prevented updates.
2875=======Task Lock cannot be granted - resource busy
2892=======Null value eliminated in set function
2894=======The cursor spool row specified is invalid.
2913=======A specific-AMP recovery was executed out of order.
2915=======The journal for the updated table does not exist
2934=======Input is in new row format -- expected old format.
2936=======No row was found for Bulk Load delete/update.
2955=======Invalid before image on transient journal.
2974=======Invalid backup message received.
2976=======Message with invalid kind has been received.
2995=======Duplicate field in into specification.
2997=======Requested field does not exist in row.
3016=======Userid, password or account > 30 characters.
3018=======RAR response is malformed.
3035=======DBC.Sessiontbl is corrupted, session cannot be recovered.
3117=======The continue request contains invalid parcels.
3119=======Continue request submitted but no response to return.
3136=======Internal Error: The request cannot be aborted, session is in-doubt.
3138=======Waiting to load in-doubt session information
3140=======Request has already been committed
3157=======DQM Cache invalid or size exceeded
3159=======DQM internal error
3180=======Service console programming fault detected.
3220=======RCT program fault.
3239=======Invalid RepBegin message received.
3241=======MDS database does not exist.
3260=======The LOGOFF SESSIONS option must have a value of Y,y,N,n,BLANK or NULL.
3262=======The LOCAL CHANGE option must have a value of Y,y,N,n,BLANK or NULL.
3279=======There are no more Monitor Sessions available.
3281=======Internal Error: Inconsistent Monitor software condition detected.
3283=======Internal Error:  No free context blocks are available.
3403=======Request parcel contains fewer session ids than specified.
3405=======Session %VSTR not found or does not have an in-doubt transaction.
3504=======Selected non-aggregate values must be part of the associated group.
3506=======Internal error: Tree segment contains errors.
3525=======The user cannot create or drop a PRIMARY index.
3527=======Format string '%VSTR' has combination of  numeric, character  and GRAPHIC values.
3544=======Partial string matching requires character operands.
3546=======Default values may not be parameterized.
3548=======The user cannot run FastLoad and MLoad at the same time.
3565=======Database has tables without After Image Journaling.
3567=======Deleting database 'DBC' is not allowed.
3586=======Processor specification error(too many or invalid values).
3588=======A User may not be assigned a NULL password.
3607=======Too many values in a subquery.
3609=======Excessively complex set conditional.
3626=======Internal error:  WITH BY clause contains multiple tables.
3628=======Only identical Aggregated Expressions can use the DISTINCT option.
3647=======NULL may not be used as the argument for an aggregate function.
3649=======Compressed NULL and NOT NULL cannot coexist for column %VSTR.
3668=======A table listed in the Dictionary is not present.
3670======='%VSTR' is not a User.
3687=======Special characters may not be used in passwords.
3689=======END EXPORT statement is valid only if in FastExport Task.
3708=======Syntax error, %VSTR should be deleted.
3710=======Insufficient memory to parse this request, during %VSTR phase.
3729=======Invalid use of non-SQL field definition(s) in ALTER TABLE.
3731=======The user must use IS NULL or IS NOT NULL to test for NULL values.
3748=======Parcel kind or ordering is invalid.
3750=======Illegal Kanji object name %VSTR.
3752=======Too many digits in exponent.
3769=======Checksum locking modifier must reference the same table as the SELECT statement that follows it.
3771=======Illegal expression in WHEN clause of CASE expression.
3790=======GRANT/REVOKE LOGON not allowed TO DBC.
3792=======Conflicting CASESPECIFIC options.
3809=======Column '%VSTR' is ambiguous.
3811=======Column '%VSTR' is NOT NULL.  Give the column a value.
3813=======The positional assignment list has too many values.
3832=======A 2PC parcel must not directly follow an Options parcel.
3851=======Macro is greater than %VSTR after name expansion.
3853======='%VSTR' is not a table.
3872=======Illegal use of an aggregate operation in an UPDATE statement.
3874=======No journaling options have been specified.
3891=======Check text for check constraint (explicit or derived from partitioning expression) is greater than 8192 characters.
3912=======Invalid message kind received.
3914=======ABORT request transaction ids do not match.
3933=======The Maximum Possible Row Length in the Table is too Large.
3935=======Session and/or request number does not match an aborted task.
3954=======Non-GRAPHIC data cannot be assigned to column %VSTR.
3956=======Improper representation of hexadecimal GRAPHIC data.
3973=======Cannot specify multiple constraints in an Alter Table statement.
3975=======Table '%VSTR' is an illegal referential constraint target.
3994=======Alias name defined should be used instead of table name%VSTR.
3996=======Right truncation of string data.
5014=======A CI with no DBDs has been found.
5016=======The table header passed in memory is invalid.
5033=======An invalid first sector number has been detected.
5035=======An unexpected FSG error has occurred.
5054=======An invalid SRD reference array index was detected.
5056=======An unfree (uninitialized) cylinder has been allocated.
5073=======The DB returned by IdxUpgradeDB is not the original one.
5075=======An invalid DBKOPERATION was specified.
5077=======An invalid deltasectors was specified.
5096=======Sort attempted to generate an invalid row uniq value.
5115=======An attempt was made to generate an invalid row uniq.
5117=======dbkmoddbs could not perform the block split indicated by dbkfit.
5136=======The CI was unlocked to avoid an undetectable deadlock.
5138=======An unexpected error has occurred in a UNIX service routine.
5157=======TID: %d %d %d  First RID: %d %d %d %d %d  Last Partition/Hash: %d %d %d\n
5159=======System test forced tpareset\n
5176=======The data block checksum is invalid.
5178=======The file information block checksum is '                                    'invalid.
5300=======Foreign Key column '%VSTR' cannot reference itself.
5319=======The specified DATABLOCKSIZE value is invalid
5321=======Constraint, primary index, or secondary index with the same name '%VSTR' already exists in table.
5338=======More than 1,000 volatile tables in current session.
5340=======Database name, if specified, must be the login user name for a volatile table.
5342=======Table option not allowed for temporary/volatile table.
5361=======The compress value must be in the repertoire of the character column.
5363=======The default value must be in the repertoire of the character column.
5380=======Internal error: Unexpected character Data type.
5382=======The word APPLY is not spelled correctly in the Release Mload statement.
5401=======Number of fractional digits out of range.
5403=======WITH TIME ZONE must follow either TIME or TIMESTAMP.
5420=======No triggers exist for table '%VSTR'.
5422=======A triggered action statement cannot update the subject table.
5424=======A triggered action statement is the wrong kind.
5441=======Replicated table status cannot be INITIATED for Define Role statement.
5443=======The specified role of a replicated table is either missing or invalid.
5462=======No DDL statements will be allowed until MDS is ready to accept them.
5464=======Error in Join Index DDL, %VSTR.
5483=======Illegal use of Ordered Analytical Function operation in an UPDATE statement.
5485=======MLinReg can have only one entry in the order specification list.
5502=======The name specified as an argument does not match the corresponding parameter name '%VSTR'.
5523=======Invalid MULTITSR parcel received.
5525=======LOCKING modifier canot be specified with CALL SQL statement.
5544=======The OPTCOST GDO is uninitialized.
5546=======Sampleid cannot be nested inside Ordered Analytical and AGGREGATE Functions.
5563=======The table specified in the UPSERT statement contains triggers that could be fired.
5565=======The UPDATE specified in the UPSERT statement is a complex update.
5584=======Data exception: numeric value out of range.
5586=======Random not allowed in inserted PI column value.
5605=======A NEW_TABLE or OLD_TABLE reference is not allowed to be passed to a macro.
5607=======Check output for possible warnings encountered in compiling UDF.
5624=======The Branch offset is very long.
5628=======Column %FSTR not found in %VSTR.
5645=======The value of '%VSTR' supplied is out of range.
5647=======Internal erorr: Data dictionary table UDFInfo in inconsistent state.
5666=======LOBs are not allowed in indexes.
5687=======REFERENTIAL INTEGRITY is not allowed on LOB columns.
5689=======LOBs are not allowed to be compared.
5706=======Cannot BEGIN QUERY LOGGING for user because ALL rule exists.
5708=======Table header size exceeds limit.
5727=======Missing the last range end.
5729=======Primary index for the table is not partitioned.
5769=======The Locator is invalid due to an internal error.
5788=======%VSTR currently do not support Identity Columns.
5790=======UPSERT on a table with an Identity Column primary index is illegal.
5809=======SET keyword in ANSI UPDATE is required.
5811=======MINUS of queries is not in Entry Level ANSI.
5828=======PRIVILEGES keyword is required in ANSI.
5830=======ROLLBACK WORK cannot indicate a condition or return text to user in ANSI.
5832=======LOCKING modifier is not ANSI.
5849=======INSTEAD OF triggers are not supported.
5851=======BEFORE triggers having data changing statements are not supported.
6013=======Vproc Number is not defined in the Physical Configuration.
6015=======The host number is invalid.
6032=======Warning: The number of Amps in a cluster is less than one-half of the Default Cluster value specified.
6034=======Incompatible operation with the Vproc type in current config map.
6036=======The range is invalid.
6053=======Unable to rebuild reference index, needs to be rebuilt.
6114=======Message Kind is invalid in the message header.
6135=======Reconfig is aborted at a reversible state.
6137=======The hash bucket arrays on an AMP are invalid.
6156=======Encountered disk error, causing too many Amps down in cluster
6158=======Recovery is still active, Reconfig will not run until recovery done
6604=======A changed data row was received that whose contents are in error
6606=======Not enough space was provided to receive the data into
6665=======RSG failed to locate the TD AMP Worker Task's well-known mailbox
6667=======Contents of RSG configuration file are incorrect
6705=======An illegally formed character string was encountered during translation.
6707=======Internal error: A move of overlapping strings was requested of the ISF subsystem.
6766=======Syntax error in SDF.
6768=======Invalid numeric format.
6770=======Invalid CCD value.
7420=======An invalid hash bucket has been encountered.
7439=======Row references non-existent session.
7441=======The date does not correspond to an exiting era.
7443=======The length of argument is incorrect.
7460=======Cannot continue utility operation on %DBID.%TVMID because system configuration has changed.
7462=======Operation not allowed: pending replication copy operation on table %DBID.%TVMID.
7481=======Operation with same utility Id and table Id already running.
7483=======Warning: RI checks bypassed for Referential Constraints.
7502=======A system trap was caused by UDF %DBID.%TVMID for %VSTR
7504=======in UDF %DBID.%TVMID: SQLSTATE %VSTR
7521=======Primary LOB row is on wrong AMP.
7523=======Fallback LOB row is in wrong subtable.
7544=======Cannot logon utility session.
7563=======Source row is deleted while update is in progress.
7565=======One or more rows found for table not in DBC.TVM. Deleted.
7624=======%FSTR: Invalid message class (%VSTR) encountered.
7626=======%FSTR: Invalid (%VSTR) step.
7643=======%FSTR: Error Initiating a new task; tskget failed with return code (%VSTR).
7645=======%FSTR: Error writing into file; fwrite failed with return code (%VSTR).
7704=======The RepPhase1 message indicates fewer RepDDL than already received.
7706=======Multiple RepBegTrans received for the same transaction before RepPhase1.
7708=======Transaction previously asynchronously aborted.  Now transaction aborted with RepPhase1Rsp message.
7725=======MDS received more DDL chunks than expected for a transaction.
8011=======The LAN message Format field is invalid.
8013=======The LAN message MessageLength field is invalid.
8051=======No network protocol exist.
8112=======Secondary index is not unique.
8114=======Update is illegal.
8215=======ROLLBACK recovery stopped.
8217=======Maximum number of tables exceeded.
8234=======Duplicate rows will not be restored to table
8236=======Cross Platform Migration is currently not supported.
8257=======Improperly formatted directed request.
8501=======LOB end of data encountered.
8503=======Invalid LOB ID
8522=======LOT could not allocate a PDE mailbox
8541=======LOT send was passed conflicting values in the descriptor
8543=======LOT got an unexpected return code discarding a scratch segment

4 comments:

Anonymous said...

Hі therе! Do yοu knοw if theу makе anу plugins to ρroteсt agaіnѕt hасkеrs?
І'm kinda paranoid about losing everything I'vе woгkеԁ hard on.
Any recommendаtіоnѕ?
Also visit my homepage www.galaxynote2.fr

Anonymous said...

I thіnk this is onе οf the moѕt іmportant information for mе.
And i'm happy reading your article. However want to remark on some normal issues, The site style is perfect, the articles is really excellent : D. Just right job, cheers
Also visit my web page :: pikavippii

Anonymous said...

Thаnkѕ , I have јust been lοoking fοr
info apρгoхimately thіs ѕubjeсt for a
while and youгs is the best I hаve found out till noω.
However, ωhat in regaгds to the conclusion?
Aге you certain in regarԁѕ to the
ѕupρly?
Also visit my web page - pikavippi

Anonymous said...

ecigarette, ecig forum, smokeless cigarettes, e cigarette, electronic cigarette brands, electronic cigarettes