Fivetran: Some Workday HCM connectors are failing with a QUOTED_IDENTIFIERS_IGNORE_CASE exception
Incident
Report for Fivetran
Resolved
This incident has been resolved. We have observed that instance rates are returning to normal levels and affected connectors are syncing successfully.
Incident Summary
Description:
We identified an issue for some Workday_HCM connectors which resulted in syncs failing with a `QUOTED_IDENTIFIERS_IGNORE_CASE` error.
Timeline:
This issue began on October 25th at 14:00 UTC and was resolved on October 26th at 10:00 UTC.
Cause:
An issue occurred during a schema migration - connectors were unable to rename the `JOB_REQUISITION` table to `JOB_REQUISITION_BACKUP_2024_10_28` which resulted in sync failures.
Reference link for the schema migration: https://fivetran.com/docs/connectors/applications/workday-hcm/changelog#october2024
Resolution:
This issue was resolved by updating the schema migration code.
Incident Summary
Description:
We identified an issue for some Workday_HCM connectors which resulted in syncs failing with a `QUOTED_IDENTIFIERS_IGNORE_CASE` error.
Timeline:
This issue began on October 25th at 14:00 UTC and was resolved on October 26th at 10:00 UTC.
Cause:
An issue occurred during a schema migration - connectors were unable to rename the `JOB_REQUISITION` table to `JOB_REQUISITION_BACKUP_2024_10_28` which resulted in sync failures.
Reference link for the schema migration: https://fivetran.com/docs/connectors/applications/workday-hcm/changelog#october2024
Resolution:
This issue was resolved by updating the schema migration code.
Update
We have deployed a fix for this issue and failing connectors are currently returning to normal sync functionality. We will continue to monitor all affected connectors and check in with some updates accordingly.
Monitoring
Whilst we continue to work on a fix for the issue, we have identified a workaround that will allow failing connectors to sync successfully. Please drop the `JOB_REQUISITION_BACKUP_2024_10_28` table in your destination, this table does not contain any data. Once this step is completed, your sync will return to its normal functionality.
Update
We have identified the root cause of the observed failures. As part of a recent schema migration, Workday_HCM connectors are attempting to rename the `JOB_REQUISITION` table to `JOB_REQUISITION_BACKUP_2024_10_28`. This action is resulting in the observed failures for some connectors. We are currently working on a fix for the issue.
Identified
We have identified an issue where some Workday_HCM connectors are failing with a `QUOTED_IDENTIFIERS_IGNORE_CASE` exception. We are currently investigating this issue in more detail and will provide additional updates accordingly.
This incident affected: Human Resources connectors (Workday HCM).