Type cast error since updating to 0.50.19

Get Help
1

Hi All,

Hoping someone can help me. We've got production reports that were working fine until recently. I believe it stopped working after the last update. These reports have been working for 6 months and no changes have been made.

Two models that are joined using a EK and FK is all of a sudden giving the error below.

ERROR: operator does not exist: character varying = uuid
Hint: No operator matches the given name and argument types. You might need to add explicit type casts.

I have tried updating the metadata but nothing works. What I can see is that when choosing the column to join on, it does state that it has no special type (which is wrong). See images below.

When joining:
image

The model:
image

Any help would be greatly appreciated. In case it matters, this is a Postgres database.

2

What's EK? what is the database and what are the data types? what does metabase see as base types for these 2 fields?

3

Entity Key (job-id) is a UUID. JobId is a UUID and Foreign Key. Not sure how to see the base type Metabase sees for a each field.

4

Got it working. Somehow it forgot the correct column name.