On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-00101 -- GAUSS-00200/ GAUSS-00171 -- GAUSS-00180

GAUSS-00171 -- GAUSS-00180

Updated on 2024-03-15 GMT+08:00

View PDF

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.

Parent topic: GAUSS-00101 -- GAUSS-00200

Previous topic: GAUSS-00161 -- GAUSS-00170

Next topic: GAUSS-00181 -- GAUSS-00190

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel