Help Center/ GaussDB(DWS)/ 8.2.0 and earlier versions/ Data Warehouse Service Error Codes/ GAUSS-00101 -- GAUSS-00200/ GAUSS-00171 -- GAUSS-00180
Updated on 2023-12-22 GMT+08:00
View PDF
Share

GAUSS-00171 -- GAUSS-00180

GAUSS-00171: "%s constraints cannot be marked NO INHERIT"

SQLSTATE: 0A000

Description: The constraint that cannot be marked with NO INHERIT is used.

Solution: Modify the SQL statement.

GAUSS-00172: "undefined or invalid action for statement ' alter system '"

SQLSTATE: 42704

Description: The length of the option for alter system is not 1.

Solution: Ensure that the length of the option for alter system is 1.

GAUSS-00173: "unsupported action '%s' for statement ' alter system '"

SQLSTATE: 42704

Description: An unsupported parameter is used in alter system.

Solution: Use a supported parameter. For details, see "ALTER SYSTEM KILL SESSION" in the SQL Syntax.

GAUSS-00174: "undefined action '%s' for statement ' alter system '"

SQLSTATE: 42704

Description: An unsupported option is used in alter system.

Solution: Use a supported option. For details, see "ALTER SYSTEM KILL SESSION" in the SQL Syntax.

GAUSS-00175: "missing or invalid session ID"

SQLSTATE: 42704

Description: The Session ID value used in ALTER SYSTEM is incorrect.

Solution: Use a correct Session ID value. For details about Session ID values, see the v$session view.

GAUSS-00176: "parameter '%s' is assigned more than once"

SQLSTATE: 42710

Description: Duplicate parameter names exist.

Solution: Ensure that names of parameters for a function are different.

GAUSS-00177: "parameter '%s' is undefined"

SQLSTATE: 42P02

Description: The parameter is not defined.

Solution: Modify the SQL statement.

GAUSS-00178: "the parameter located '%d' have been assigned"

SQLSTATE: 42710

Description: A value has been assigned to the parameter mode.

Solution: Modify the SQL statement.

GAUSS-00179: "parameter mode %c doesn't exist"

SQLSTATE: XX000

Description: An invalid parameter mode is used.

Solution: Use a valid parameter mode. For details about valid parameter modes, see SQL language reference.

GAUSS-00180: "output argument located '%d' doesnot assigned"

SQLSTATE: XX000

Description: The type of the output parameter is not set.

Solution: Set types for all parameters.