On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-02101 -- GAUSS-02200/ GAUSS-02101 -- GAUSS-02110

GAUSS-02101 -- GAUSS-02110

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

View PDF

GAUSS-02101: "Invalid RTE found."

SQLSTATE: XX000

Description: An internal error occurs. The table information is invalid.

Solution: Internal system error. Contact technical support.

GAUSS-02102: "could not determine which collation to use for regular expression"

SQLSTATE: 42P22

Description: A proper collation cannot be determined for regular expressions.

Solution: Correct the regular expression definition.

Example:

   
      postgres=# insert into t8 values('a','b');
INSERT 0 1
postgres=# select regexp_matches(ifnull(a,b),'[Ab]') from t8;
ERROR:  could not determine which collation to use for regular expression
HINT:  Use the COLLATE clause to set the collation explicitly.
CONTEXT:  referenced column: regexp_matches

GAUSS-02103: "syntax error at line %d: unexpected character '%s'"

SQLSTATE: XX000

Description: The syntax is incorrect.

Solution: Modify the SQL statement.

GAUSS-02104: "%s at line %d"

SQLSTATE: XX000

Description: The syntax is incorrect.

Solution: Modify the SQL statement.

GAUSS-02105: "incorrect number of columns in row (expected %d, got %d)"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-02106: "relation not open"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-02107: "too many columns"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-02108: "unrecognized process type: %d"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-02109: "close of %s when %s was expected"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-02110: "close of %s before any relation was opened"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

Parent topic: GAUSS-02101 -- GAUSS-02200

Previous topic: GAUSS-02101 -- GAUSS-02200

Next topic: GAUSS-02111 -- GAUSS-02120

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

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback