On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-01201 -- GAUSS-01300/ GAUSS-01211 -- GAUSS-01220

GAUSS-01211 -- GAUSS-01220

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

View PDF

GAUSS-01211: "cannot copy from view '%s'"

SQLSTATE: 42809

Description: Data fails to be copied from views.

Solution: Do not copy data from views.

GAUSS-01212: "cannot copy from foreign table '%s'"

SQLSTATE: 42809

Description: Data fails to be copied from foreign tables.

Solution: Do not copy data from foreign tables.

GAUSS-01213: "cannot copy from sequence '%s'"

SQLSTATE: 42809

Description: Data fails to be copied from sequences.

Solution: Do not copy data from sequences.

GAUSS-01214: "cannot copy from non-table relation '%s'"

SQLSTATE: 42809

Description: Data fails to be copied from non-table relation.

Solution: Do not copy data from non-table relation.

GAUSS-01215: "relative path not allowed for COPY to file"

SQLSTATE: 42602

Description: The path format of the target file to be copied cannot be a relative path.

Solution: Use an absolute path as a target file path during the copy.

GAUSS-01216: "could not open file '%s' for writing: %m"

SQLSTATE: XX000

Description: The specified file cannot be opened.

Solution: Ensure that the specified file is not damaged and the permission is sufficient.

GAUSS-01217: "'%s' is a directory"

SQLSTATE: 42809

Description: The specified parameter is a directory name but not a file name.

Solution: Specify a file name rather than a directory name for COPY.

GAUSS-01218: "could not chmod file '%s' : %m"

SQLSTATE: XX000

Description: The permission of the file fails to be changed.

Solution: Ensure that the permission and user group of the file are correct.

GAUSS-01219: "Invalid file format"

SQLSTATE: XX000

Description: The file format is not supported.

Solution: Use a TXT, binary, or CSV format that is supported during copy.

GAUSS-01220: "null value in column '%s' violates not-null constraint"

SQLSTATE: 23502

Description: A null value is entered in a column having the Not-Null constraint.

Solution: Enter valid values in columns having the Not-Null constraint.

Parent topic: GAUSS-01201 -- GAUSS-01300

Previous topic: GAUSS-01201 -- GAUSS-01210

Next topic: GAUSS-01221 -- GAUSS-01230

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