Share via


SYNCED_TABLE_USER_ERROR error condition

SQLSTATE: 42000

Synced table pipeline user error.

CHARACTER_NOT_IN_REPERTOIRE

Instance: <instance>. Found invalid byte sequence in the source Delta table.

Detail: <detail>

This usually indicates the source Delta table contains characters that are not compatible with the target database's encoding. One workaround is to convert the source table to use BINARY TYPE, and then create a new synced table.

COLUMN_TYPE_CHANGE_NOT_SUPPORTED

Instance: <instance>. Changing the column type is currently not supported.

Source Delta table: <srcTableName>. Destination synced table: <destTableName>.

Column: <columnName>. Existing type: <existingType>. New type: <newType>.

To resolve this issue, consider one of the following options:

  1. Perform a full refresh of the existing synced table.

  2. Create a new synced table (which will pick up the new type)

PRIMARY_KEY_CONSTRAINT_VIOLATION

Instance: <instance>. Duplicate rows detected based on primary key. Detail: <detail>

This likely indicates a misconfiguration of primary key columns. Please verify that you are using the correct set of primary keys from the source Delta table: <srcTableName>. To resolve this issue, create a new synced table with the correct primary key configuration.

TARGET_DATABASE_FULL

The target database <databaseName> space is full. Not able to continue to ingest.