Teradata Database Errors

Teradata Database Errors starting with: errors 54*

Errors starting with: errors 54*

change error category

errors 54*

Teradata error 5400 Number of leading digits out of range.

Teradata error 5401 Number of fractional digits out of range.

Teradata error 5402 WITH TIME ZONE is incompatible with specified data type.

Teradata error 5403 WITH TIME ZONE must follow either TIME or TIMESTAMP.

Teradata error 5404 Datetime field overflow.

Teradata error 5405 Interval field overflow.

Teradata error 5406 Invalid combination of Teradata and ANSI datetime value functions.

Teradata error 5407 Invalid operation for DateTime or Interval.

Teradata error 5408 Invalid operands to OVERLAPS operator.

Teradata error 5409 Invalid DATE Literal.

Teradata error 5410 Invalid TIME Literal.

Teradata error 5413 Invalid Time Zone Specified.

Teradata error 5416 The trigger action time must be BEFORE or AFTER.

Teradata error 5417 The trigger event must be INSERT, UPDATE or DELETE.

Teradata error 5419 Trigger %VSTR already exists.

Teradata error 5420 No triggers exist for table %VSTR.

Teradata error 5421 Cannot drop or rename a column referenced by a trigger.

Teradata error 5423 This trigger contains an invalid REFERENCING clause.

Teradata error 5424 A triggered action statement is the wrong kind.

Teradata error 5425 An updatable cursor update or delete is not allowed upon which a trigger has been defined.

Teradata error 5426 %VSTR is not a trigger.

Teradata error 5427 Trigger is greater than 20480 characters after name expansion.

Teradata error 5428 Table %VSTR has defined triggers.

Teradata error 5429 A triggered action statement contained an invalid reference.

Teradata error 5430 The Trigger WHEN clause cannot contain an aggregate or table reference.

Teradata error 5431 The update column list can only be used with UPDATE trigger event.

Teradata error 5432 A trigger Order value must be within a range of 0 to 32767.

Teradata error 5433 The update column list can only contain subject table columns.

Teradata error 5434 A syntax error occurred in a triggered action statement.

Teradata error 5435 Invalid RS operation.

Teradata error 5436 Table list is missing for the RDDL statement.

Teradata error 5437 The specified table is already a replicated table.

Teradata error 5439 RS Error table %VSTR already exists.

Teradata error 5441 Replicated table status cannot be INITIATED for Define Role statement.

Teradata error 5442 Replicated table does not have the appropriate status for this RDDL statement.

Teradata error 5443 The specified role of a replicated table is either missing or invalid.

Teradata error 5445 Change data apply operation must not be active for this DML statement.

Teradata error 5446 Replicated table does not have the appropriate status for this DML statement.

Teradata error 5449 Cross group transaction is not allowed.

Teradata error 5450 Invalid SET SESSION OVERRIDE option is specified. It can either be ON or OFF.

Teradata error 5452 No fastload operation is allowed on a replicated table.

Teradata error 5453 The replicated table does not have the appropriate status for this Rollback/Rollforward

Teradata error 5454 No Restore functions are allowed on a table in a replication group.

Teradata error 5456 The requested DDL statement is not allowed on a replicated table.

Teradata error 5457 Replicated table does not have the appropriate status for this DDL statement.

Teradata error 5458 Access lock must be specified for the target table for select, join or abort with test.

Teradata error 5459 Attempt to add a dictionary table as a replicated table.

Teradata error 5460 This requested DDL statement is not allowed on a non-replicated table.

Teradata error 5461 Invalid syntax of the Rep-Begin statement.

Teradata error 5463 Invalid coordinator for a RS coordinated transaction.

Teradata error 5464 Error in Join Index DDL, %VSTR.

Teradata error 5465 Error in Using Join Index, %VSTR.

Teradata error 5466 Error in Secondary Index DDL, %VSTR.

Teradata error 5467 Cannot drop, MLOAD, or RESTORE a table with join or hash indexes.

Teradata error 5468 Cannot delete database because either this database has a join or hash index in it or one of

Teradata error 5469 SAMPLE clause has invalid set of arguments.

Teradata error 5470 SampleId not permitted in WHERE/ON Clause.

Teradata error 5471 SampleId not permitted in HAVING/QUALIFY Clause.

Teradata error 5472 SampleId reference invalid without a SAMPLE Clause.

Teradata error 5473 SAMPLE clause has invalid set of arguments.

Teradata error 5474 SAMPLE clause specifies more than 16 samples.

Teradata error 5475 SAMPLE clause not allowed in SET operations.

Teradata error 5476 SAMPLE clause not allowed in Embedded SELECTS.

Teradata error 5478 Aggregates are allowed only with Window Functions.

Teradata error 5481 Ordered Analytical Functions not allowed in GROUP BY Clause.

Teradata error 5482 NULL may not be used as the argument for an Ordered Analytical Function.

Teradata error 5483 Illegal use of Ordered Analytical Function operation in an UPDATE statement.

Teradata error 5484 No Ordered Analytical Function operation allowed in the search condition for a joined table.

Teradata error 5485 MLinReg can have only one entry in the order specification list.

Teradata error 5486 Window size value is not acceptable.

Teradata error 5487 An invalid account has been specified.

Teradata error 5488 SampleId not permitted in GROUP BY Clause.

Teradata error 5489 Change Data Capture is not allowed on temporary or volatile table.

Teradata error 5490 Fastload or multiload are not allowed on tables with triggers.

Teradata error 5491 The privilege is not applicable to a trigger.

Teradata error 5492 The argument for an INOUT/OUT parameter %VSTR is invalid.

Teradata error 5493 The privilege is not applicable to a stored procedure.

Teradata error 5494 %VSTR is not a stored procedure.

Teradata error 5495 Stored Procedure %VSTR does not exist.

Teradata error 5497 CALL cannot be submitted in multi-statement request.

Teradata error 5499 The data size for input parameters exceeds the maximum allowable row length.

More informatoin

Teradata error 2515 The modification at this time instant can violate serializability. Please retry the request.

Teradata error 1 Invalid pmHandle parameter

Teradata error SWITCH RESPONSE

Teradata error SELECT-INTO statement.

Teradata error 2598 Discrepancy between CI DBD and data block.

Teradata error TPT1143 Error: Failed to Write a message to the pipe, System errno: %d (%s)

Teradata error 5541 Local instance of temporary table ’%VSTR’ does not exist in current session.

Teradata error 233 EM_DLLLOADFAIL LoadLibrary failed.

Teradata error 3322 TDWM internal error. %VSTR

Teradata error 6993 The sample column %VSTR does not match the table’s definition.



Teradata Database Errors