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
ERROR 9067: String with length value is too long for type string(value)

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