Updated on 2023-12-22 GMT+08:00

GAUSS-04651 -- GAUSS-04660

GAUSS-04651: "the bulkload state is already set before bulkload starts"

SQLSTATE: XX000

Description: Internal system error. The imported CopyState is not cleared.

Solution: Contact technical support.

GAUSS-04652: "cannot specify bulkload compatibility options in BINARY mode"

SQLSTATE: 42601

Description: Internal error. The imported CopyState object is not cleared.

Solution: Contact technical support.

GAUSS-04653: "IGNORE_EXTRA_DATA specification only available using COPY FROM or READ ONLY foreign table"

SQLSTATE: 42601

Description: The ignore_extra_data parameter can only be used to import data.

Solution: Remove the ignore_extra_data parameter when the export function is enabled.

GAUSS-04654: "COMPATIBLE_ILLEGAL_CHARS specification only available using COPY FROM or READ ONLY foreign table"

SQLSTATE: 42601

Description: The compatible_illegal_chars parameter can only be used to import data.

Solution: Remove the compatible_illegal_chars parameter when the export function is enabled.

GAUSS-04655: "DATE_FORMAT specification only available using COPY FROM or READ ONLY foreign table"

SQLSTATE: 42601

Description: The date_format parameter can only be used to import data.

Solution: Remove the date_format parameter when the export function is enabled.

GAUSS-04656: "TIME_FORMAT specification only available using COPY FROM or READ ONLY foreign table"

SQLSTATE: 42601

Description: The time_format parameter can only be used to import data.

Solution: Remove the time_format parameter when the export function is enabled.

GAUSS-04657: "TIMESTAMP_FORMAT specification only available using COPY FROM or READ ONLY foreign table"

SQLSTATE: 42601

Description: The timestamp_format parameter can only be used to import data.

Solution: Remove the timestamp_format parameter when the export function is enabled.

GAUSS-04658: "SMALLDATETIME_FORMAT specification only available using COPY FROM or READ ONLY foreign table"

SQLSTATE: 42601

Description: The smalldatetime_format parameter can only be used to import data.

Solution: Remove the smalldatetime_format parameter when the export function is enabled.

GAUSS-04659: "illegal chars conversion may confuse COPY null 0x%x"

SQLSTATE: 42601

Description: The null parameter is set to a space or question mark (?), and compatible_illegal_chars is set to true, indicating the invalid characters are compatible. The imported invalid characters are converted to spaces or question marks, and introduces confusion with the null parameter resulting in potential import errors.

Solution: Set null to other characters except a space or question mark to avoid confusion with invalid characters after they are converted.

GAUSS-04660: "illegal chars conversion may confuse COPY delimiter 0x%x"

SQLSTATE: 42601

Description: The delimiter parameter is set to a space or question mark (?), and compatible_illegal_chars is set to true, indicating the invalid characters are compatible. The imported invalid characters are converted to spaces or question marks, and introduces confusion with the delimiter parameter resulting in potential import errors.

Solution: Set delimiter to other characters except a space or question mark to avoid confusion with invalid characters after they are converted.