ucx icon indicating copy to clipboard operation
ucx copied to clipboard

Update Table History Logs fails

Open FastLee opened this issue 1 year ago • 3 comments

Is there an existing issue for this?

  • [x] I have searched the existing issues

Current Behavior

update_table_history_log task of migrate tables workflow fails.

[SCHEMA_NOT_FOUND] The schema `ucx.multiworkspace` cannot be found. Verify the spelling and correctness of the schema and catalog.
If you did not qualify the name with a catalog, verify the current_schema() output, or qualify the name with the correct catalog.
To tolerate the error on drop use DROP SCHEMA IF EXISTS. SQLSTATE: 42704```



### Expected Behavior

We expect the task to succeed or fail gracefully.

### Steps To Reproduce

_No response_

### Cloud

AWS

### Operating System

macOS

### Version

latest via Databricks CLI

### Relevant log output

```shell

FastLee avatar Jan 27 '25 19:01 FastLee

@FastLee : Could you add some more context to this issue? Where did it fail? In our integration tests? By a user?

JCZuurmond avatar Feb 18 '25 11:02 JCZuurmond

It fails because we have an undocumented dependency on a UC Catalog

FastLee avatar Feb 18 '25 16:02 FastLee

In that case, we should update the workflow to not fail if the dependency is not fulfilled, we should only append the log if we can.

Note that this is an almost duplicate of #3438 and would be less likely to happen if #2737 is implemented

JCZuurmond avatar Feb 19 '25 08:02 JCZuurmond