Skip to main content

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)

CONNECTION_ERROR

Instance: <instance>. Connection error. Detail: <detail>.

To resolve this issue, please ensure the database instance is running, not paused or stopped.

Restart the pipeline to retry.

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.