Error Messages Associated with SQLSTATE 22001

This topic lists the errors associated with the SQLSTATE 22001.

SQLSTATE 22001 Description

ERRCODE_STRING_DATA_RIGHT_TRUNCATION

Error messages associated with this SQLState

ERROR 2991: Date 'string'string too long for type string(value)
ERROR 3426: Float 'string'string too long for type string
ERROR 3589: Integer 'string'string is too long for type string(value)
ERROR 3605: Interval 'string'string too long for type string(value)
ERROR 4208: Numeric 'string' is too long for type string
ERROR 4315: Padded octet length (value) exceeds the value octet limit
ERROR 4604: Result (value characters) exceeds the field width (value)
ERROR 4800: String of value octets is too long for type string(value)
ERROR 5004: Time 'string'string too long for type string(value)
ERROR 5024: Timestamp 'string'string too long for type string(value)
ERROR 5032: Timestamptz 'string'string too long for type string(value)
ERROR 5035: Timetz 'string'string too long for type string(value)
ERROR 5417: Value too long for type character varying(value)
ERROR 5418: Value too long for type character(value)
ERROR 7401: Date 'string' too long for buffer of length (value)
ERROR 7431: Interval 'string' too long for buffer of length (value)
ERROR 7568: Time 'string' too long for buffer of length (value)
ERROR 7569: Timestamp 'string' too long for buffer of length (value)
ERROR 7570: TimestampTz 'string' too long for buffer of length (value)
ERROR 7571: TimeTz 'string' too long for buffer of length (value)
ERROR 8276: Type string(value) is too short to hold UUID values, need at least value
ERROR 8682: String of value octets is too long for type string(value) for column string

The Vertica User Community contains knowledge base articles, blogs, and forum posts that may help you resolve these errors.