Error Messages Associated with SQLSTATE 22003

This topic lists the errors associated with the SQLSTATE 22003.

SQLSTATE 22003 Description

ERRCODE_NUMERIC_VALUE_OUT_OF_RANGE

Error messages associated with this SQLState

ERROR 2429: Cannot find matching query in the system
ERROR 2828: Could not convert 'string'string to an int8
ERROR 3425: Float "value" is out of range for type string
ERROR 3675: Invalid input for string, exceeds 32 bits: "value"
ERROR 3676: Invalid input for string, exceeds 64 bits: "value"
ERROR 3786: Invalid value for float: "string"
ERROR 4200: Number of buckets must be a positive integer
ERROR 4361: Percentile value must be a number between 0 and 1
ERROR 4704: Sequence exceeded max value
ERROR 4705: Sequence exceeded min value
ERROR 4756: Smoothing factor must between 0 and 1
ERROR 4795: String "string"string is out of range as a float8
ERROR 4796: String "string"string is out of range as an int8
ERROR 4845: Sum() overflowed
ERROR 5408: Value "value" is out of range for type string
ERROR 5409: Value "string" is out of range for type int8
ERROR 5411: Value exceeds range of type string
ERROR 5412: Value is too long for type string: "value"
ERROR 6063: Total number of significant digits for value string is more than what is defined. Buffer size is value while actual length of word is value instead
ERROR 7623: Value "string" is out of range for type int64
ERROR 7697: Arithmetic overflow accumulating numeric, operand %Lg
ERROR 7698: Arithmetic overflow adding numerics, operands %Lg, %Lg
ERROR 7699: Arithmetic overflow subtracting numerics, operands %Lg, %Lg
ERROR 7986: Evaluation of expression to be inserted exceeded range of type numeric(value,value)

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