Skip to main content

INVALID_PARAMETER_VALUE error condition

SQLSTATE: 22023

The value of parameter(s) <parameter> in <functionName> is invalid:

AES_CRYPTO_ERROR​

detail message: <detailMessage>

AES_IV_LENGTH​

supports 16-byte CBC IVs and 12-byte GCM IVs, but got <actualLength> bytes for <mode>.

AES_KEY_LENGTH​

expects a binary value with 16, 24 or 32 bytes, but got <actualLength> bytes.

AI_FORECAST_MODEL_PATH​

must reference a Databricks-managed model location.

AI_FORECAST_VERSION​

expects '1' or '2', but got <invalidValue>.

BINARY_FORMAT​

expects one of binary formats 'base64', 'hex', 'utf-8', but got <invalidFormat>.

BIT_POSITION_RANGE​

expects an integer value in [0, <upper>), but got <invalidValue>.

BOOLEAN​

expects a boolean literal, but got <invalidValue>.

CHARSET​

expects one of the <charsets>, but got <charset>.

DATETIME_UNIT​

expects one of the units without quotes YEAR, QUARTER, MONTH, WEEK, DAY, DAYOFYEAR, HOUR, MINUTE, SECOND, MILLISECOND, MICROSECOND, but got the string literal <invalidValue>.

DOUBLE​

expects an double literal, but got <invalidValue>.

DTYPE​

Unsupported dtype: <invalidValue>. Valid values: float64, float32.

EXTENSION​

Invalid extension: <invalidValue>. Extension is limited to exactly 3 letters (for example, csv, tsv, etc...)

HMAC_ALGORITHM​

expects one of the algorithms 'SHA-224', 'SHA-256', 'SHA-384', 'SHA-512', 'SHA-1', 'MD5', but got <algorithm>.

HMAC_CRYPTO_ERROR​

detail message: <detailMessage>

INTEGER​

expects an integer literal, but got <invalidValue>.

INTERRUPT_TYPE_OPERATION_ID_REQUIRES_ID​

INTERRUPT_TYPE_OPERATION_ID requested, but no operation_id provided.

INTERRUPT_TYPE_TAG_REQUIRES_TAG​

INTERRUPT_TYPE_TAG requested, but no operation_tag provided.

LENGTH​

Expects length greater than or equal to 0, but got <length>.

LONG​

expects a long literal, but got <invalidValue>.

METADATA_FORMAT_JSON​

<detailMessage>

METADATA_SYNONYMS_JSON​

<detailMessage>

NULL​

expects a non-NULL value.

OCCURRENCE​

expects a positive integer, but got <actual>.

PATTERN​

<value>.

REGEX_GROUP_INDEX​

Expects group index between 0 and <groupCount>, but got <groupIndex>.

START​

Expects a positive or a negative value for start, but got 0.

STREAMING_LISTENER_COMMAND_MISSING​

Missing command in StreamingQueryListenerBusCommand.

STRING​

expects a string literal, but got <invalidValue>.

TIME_UNIT​

expects one of the units 'HOUR', 'MINUTE', 'SECOND', 'MILLISECOND', 'MICROSECOND', but got '<invalidValue>'.

TRIM_ARRAY_LENGTH​

Expects a value between 0 and the array cardinality (<numElements>), but got <length>.

ZERO_INDEX​

expects %1$, %2$ and so on, but got %0$.

ZSTD_DECOMPRESS_INPUT​

expects valid zstd-compressed data.