Error: Illegal Argument Exception: No Enum Constant

Issue

Connections fail during schema discovery with the following error:

IllegalArgumentException: No enum constant com.fivetran.integrations.sql_server.connector.schema.SqlServerType.SYSNAME

Environment

Connector: Epic Clarity

Resolution

To resolve this issue:

1. In Fivetran, temporarily exclude tables that contain SYSNAME columns from the sync.

   i. In Fivetran, go to your Epic Clarity connection page.

   ii. Select the Schema tab.

   iii. Deselect the checkbox next to the affected tables.

   iv. Click Save changes.

2. If the affected columns are in custom or non-Epic-managed tables that you control, change them to a supported type, such as NVARCHAR.

   For Epic-managed Clarity tables, contact Epic or your database administrator to confirm whether the schema can be changed. If the schema can’t be changed, keep the affected tables excluded from the sync.

3. Re-enable the affected tables in the connection schema and click Save changes.

Cause

This issue occurs when we encounter a column with the SQL Server SYSNAME data type, which we don't support.