Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-02801 -- GAUSS-02900/ GAUSS-02821 -- GAUSS-02830
Updated on 2024-03-15 GMT+08:00
View PDF

GAUSS-02821 -- GAUSS-02830

GAUSS-02821: "invalid length in external 'numeric' value"

SQLSTATE: 22P03

Description: The Numeric input is invalid.

Solution: Check whether the data contains invalid numeric input.

GAUSS-02822: "invalid sign in external 'numeric' value"

SQLSTATE: 22P03

Description: The Numeric input is invalid.

Solution: Check whether the data contains invalid numeric input.

GAUSS-02823: "invalid digit in external 'numeric' value"

SQLSTATE: 22P03

Description: The Numeric input is invalid.

Solution: Check whether the data contains invalid numeric input.

GAUSS-02824: "NUMERIC precision %d must be between 1 and %d"

SQLSTATE: 22023

Description: The numeric precision is beyond the normal range.

Solution: Adjust the input value according to the precision range described in the error message.

GAUSS-02825: "NUMERIC scale %d must be between 0 and precision %d"

SQLSTATE: 22023

Description: The numeric scale is beyond the range.

Solution: Adjust the input value according to the precision range described in the error message.

GAUSS-02826: "invalid NUMERIC type modifier"

SQLSTATE: 22023

Description: The Numeric input is invalid.

Solution: Check whether the data contains invalid numeric input.

GAUSS-02827: "count must be greater than zero"

SQLSTATE: 2201G

Description: The value of parameter count of the width_bucket function must be greater than zero.

Solution: Ensure that the value of parameter count of the width_bucket function is greater than zero.

GAUSS-02828: "operand, lower bound, and upper bound cannot be NaN"

SQLSTATE: 2201G

Description: Both the operand and upper and lower limits for the width_bucket function cannot be NaN.

Solution: Ensure that operand and upper and lower limits for the width_bucket function are not NaN.

GAUSS-02829: "lower bound cannot equal upper bound"

SQLSTATE: 2201G

Description: The upper and lower limits of the width_bucket function must be different.

Solution: Ensure that the upper and lower limits for the width_bucket function are different.

GAUSS-02830: "value overflows numeric format"

SQLSTATE: 22003

Description: The numeric factorial overflows.

Solution: Check whether the data input for the program is too large. If not, take measures to solve the problem at the application layer.