Teradata DBC Errorcodes and Description

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