Skip to main content

DELTA_ALTER_TABLE_UNSET_MANAGED_FAILED error condition

SQLSTATE: 42809

<table> cannot be rolled back from managed to external table.

TIME_WINDOW_EXCEEDED

The time window for rolling back the table has been exceeded. Rollback is only supported

within <numDays> days after the migration to Unity Catalog managed table.

TRUNCATED_HISTORY

The table history is truncated and cannot find all the necessary commits to rollback

the table to its original state.

UNEXPECTED_ERROR

An unexpected error occurred.

== Error ==

<error>

VERSION_MISMATCH

The versions of the managed DeltaLog (<managedDeltaLogVersion>) and external DeltaLog (<externalDeltaLogVersion>) do not match.

This can happen if there is a concurrent ALTER TABLE tbl UNSET MANAGED command that already successfully rolled back the table to external.